1. Replicate the following loan analysis scenarios from Chapter 9 in our text book on an Excel Spreadsheet using financial formulas where applicable

   3. Illustration 9-10 Loan Amortization Schedule (5 Points)

Loan Amortization Schedule Generated: Year Payment 36,956 36,956 36,956 36,956 36,956 Principal 28,956 30,404 31,924 33,520 35,196 Interest 8,000 6,552 5,032 3,436 1,760 Balance 131,044 100,640 68,716 35,196 0.00 ILLUSTRATION 9-10 (Continued) Loan Amortization Schedule Generated: Year Payment 36,956 36,956 36,956 36,956 36,956 Principal 28,956 30,404 31,924 33,520 35,196 Interest 8,000 6,552 5,032 3,436 1,760 Balance 131,044 100,640 68,716 35,196 0.00 ILLUSTRATION 9-10 (Continued)