We’re rewarding the question askers & reputations are being recalculated! Read more.

New answers tagged

2

You need to change your interest calculation as shown below. I.e. the formula for cell C10 (and likewise for the rest of column C) was originally =F9*RATE*(B10-B9)/365 should be =F9*((1+RATE)^((B10-B9)/365)-1) That is the correct way of applying compounding using a daily rate calculated from an effective annual rate. daily rate, d = (1 + 0.0295)^(1/...


Top 50 recent answers are included