The compound interest formula is similar to the Compounded Annual ... There are three ways to set this up in Excel. The most easy to audit and understand is to have all the data in one table ...

The formula for calculating the total amount paid on a loan with compound interest is ... that i = 9.86% using a financial calculator or Excel spreadsheet. Your initial investment (PV) of $ ...