The concept of the long run proportion can be demonstrated. These spreadsheets function using macro programs. The user does not need to select these options as the spreadsheets will select the appropriate settings when loaded. Compare the difference in growth over ten periods for a principal earning simple interest and compound interest. View the growth on the chart.
Simple interest is linear whereas compound interest is exponential.
Also create a table showing the value for each period. Compare two ordinary annuities. A table and graph is shown. Sheet1 Vary the amount borrowed, the interest rate, term of loan and monthly repayment. Compare two levels of accelerated repayment with the minimum repayment.