N Time |
PV BALANCE of Loan $$$ owed |
APR annual % rate |
IR interest per cycle |
PMT Payment cash flow out CFO |
Interest $$$ owed to LENDER |
Principal Reduction Amount |
FV new balance owing lender = future value |
|---|---|---|---|---|---|---|---|
| START begin month BOM 1 |
|||||||
| End Of Month EOM 1 |
|||||||
| note the prior month FV becomes the new PV & begins the next month | |||||||
| EOM 2 | |||||||
| EOM 3 | |||||||
| EOM 4 | |||||||
| EOM 5 | |||||||
| EOM 6 | |||||||
Green / red cells compare to the built-in lesson answer key (same pattern as the car loan worksheet).