on excel

Excel Amortization Spreadsheet Fall 2021 Loan Rate Payment Number 100000 8% 21 ($9,983.23) Interest Period Beginning Balance Cash Payment Interest Expense Principal Principal Reduction Ending Balance 100,000.00 $ 9,983.23 $ 8,000.00 $ 1,983.23 $ 98,016.77 98,016.77 $ 9,983.23 $ 7,841.34 $ 2,141.89 $ 95,874.88 1 $ 2 $ 3 4 5 1 $ 2 $ 100,000.00 $ 9,983.23 $ 8,000.00 $ 1,983.23 $ 98,016.77 98,016.77 $ 9,983.23 $ 7,841.34 $ 2,141.89 $ 95,874.88 N000 10 11 12 13 14 15 16 17 18 19 20 21