Discounted Cash Flow Valuations and Net Present Value
DatDude
WorksheetinRWJ_Corp_12e_PPT_Ch04_Amortization1.xlsSheet1
| Year | Beginning Balance | Total Payment | Interest Paid | Principal Paid | Ending Balance | |
| 1 | $ 5,000 | $ 1,509.60 | $ 400.00 | $ 1,109.60 | $ 3,890.40 | |
| 2 | $ 3,890.40 | $ 1,509.60 | $ 311.23 | $ 1,198.37 | $ 2,692.03 | |
| 3 | $ 2,692.03 | $ 1,509.60 | $ 215.36 | $ 1,294.24 | $ 1,397.79 | |
| 4 | $ 1,397.79 | $ 1,509.60 | $ 111.82 | $ 1,397.78 | $ 0.02 | (rounding) |
