Discounted Cash Flow Valuations and Net Present Value
DatDude
WorksheetinRWJ_Corp_12e_PPT_Ch041.xlsx
Sheet1
| Year | Beginning Balance | Total Payment | Interest Paid | Principal Paid | Ending Balance |
| 1 | $50,000 | $9,000 | $4,000 | $5,000 | $45,000 |
| 2 | $45,000 | $8,600 | $3,600 | $5,000 | $40,000 |
| 3 | $40,000 | $8,200 | $3,200 | $5,000 | $35,000 |
| 4 | $35,000 | $7,800 | $2,800 | $5,000 | $30,000 |
| 5 | $30,000 | $7,400 | $2,400 | $5,000 | $25,000 |
| 6 | $25,000 | $7,000 | $2,000 | $5,000 | $20,000 |
| 7 | $20,000 | $6,600 | $1,600 | $5,000 | $15,000 |
| 8 | $15,000 | $6,200 | $1,200 | $5,000 | $10,000 |
| 9 | $10,000 | $5,800 | $800 | $5,000 | $5,000 |
| 10 | $5,000 | $5,400 | $400 | $5,000 | $0 |
