We’re rewarding the question askers & reputations are being recalculated! Read more.
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/...


Only top voted, non community-wiki answers of a minimum length are eligible