An owner of a small business borrows $785,000 at 6.9% annual compound interest. The loan is to be repaid over a 7-year period using the four possible repayment methods. Payments are made at the end of the year.
Solve using Excel. Use Excel Functions/Operations to create 4 tables showing the four loan repayment methods.