CREDIT CARD, 6 month declining balance table Play More Game
AMORTIZATION SCHEDULE
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).