Use a spreadsheet (not formulas) to answer problems 9 through 13 below.
An annuity firm pays 5% APR compounded yearly, and offers an investor the following: Deposit $100,000 with them today, and then starting one year from today, you will receive ten equal annual payments, with zero balance remaining afterward in the account. If an investor accepts their offer, then find the following:
What will be the payment amount for each of the ten equal payments?
After ten years, how much interest will the investor have received, and what percentage of the total payment sum will represent interest?
Lee et al., Math in Society, §2.4 Loan Payments, Exercise 11