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

New answers tagged


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