This simple interest template will calculate the ending balance of a deposit that earns yearly simple interest that is paid out monthly, as well as the effective annual interest rate for a 12-month period.

It also has the option of calculating the ending balance of a deposit that earns yearly compound interest, paid out monthly for a period of 12 months. The template also creates a visual presentation of the interest earned each month as time progresses.