>D20
' |
>D19
' |
>D18
' |
>D17
' |
>D16
' |
>C16
+C14*C12
/FE,P2
>B16
' TOTAL PAYMENTS
>D15
' |
>F14
+C14-F12
>E14
'Interest paid this month
>D14
' |
>C14
+C7*(C11-1)/(1-C11^-C12)
/FE,P2
>B14
' MONTHLY PAYMENT
>F13
+F9-F11
>E13
'Cumulative interest paid
>D13
' |
>C13
"=
>B13
"=
>F12
+C7*C11^(F7-1)-C14*(C11^(F7-1)-1)/(C11-1)-F10
>E12
'Principal paid this month
>D12
' |
>C12
+12*C9
>B12
' N MONTHS
>F11
+C7-F10
>E11
'Cumulative principal paid
>D11
' |
>C11
+1+C8/1200
>B11
' R
>F10
+C7*C11^F7-C14*(C11^F7-1)/(C11-1)
>E10
'Principal remaining
>D10
' |
>C10
"-
>B10
"-
>F9
+F7*C14
>E9
'Cumulative payments
>D9
' |
>C9
+30
/FEWN
>B9
' YEARS
>F8
"=
>E8
"=
>D8
'%|
>C8
+12
/FEFP3WN
>B8
' YEARLY INTEREST
>F7
+120
/FEFPVWN
>E7
'Payment number
>D7
' |
>C7
+50000
/FE,P2WN
>B7
' PRINCIPAL
>A5
' total payment will be automatically re-computed.
>A4
' When you change any of those three values, the monthly payment and
>A3
' as a function of the principal, interest rate, and term.
>A2
' This worksheet allows you to compute loan or mortgage payments
>A1
/FCC3
>B1
/FCC17
>C1
/FCC14
>D1
/FCC3
>E1
/FCC25
>F1
/FCC14
>F1
/FC,P2
/FWC9
/FWGPVWY
/TN
>A1
/Z1
>C7
/GOC
/GRA
/GLL
/WU
/POT5:M10:L56:W65:P66:Q