N Time |
PV BALANCE $$$ 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 | |||||||
DELTA EQUITY — exit after 6 months
Interest = PV × IR. Principal = PMT − Interest. FV = PV − Principal. Equity at sale = Exit price − final FV. Green / red cells match the lesson answer key.