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 | |||||||
| EOM 7 | |||||||
| EOM 8 | |||||||
| EOM 9 | |||||||
| EOM 10 | |||||||
| EOM 11 | |||||||
| EOM 12 | |||||||
Green / red cells compare to the built-in lesson answer key (same as the original reader worksheet).