Illustration of Interest Calculation

An Excel file that teaches how to perform Interest Calculation Example operation.

Excel Dashboard for Illustration of Interest Calculation

Principal, rate and duration parameters are entered. The interest amount is calculated by the formula. Total refund available. The result is reflected in the table. The graph shows the pay curve.

Hope it is useful.