keybd
INPUT
yes
screen
OUTPUT
lf
swiss11
on
~%month,%prin
60
fmtlist
fmt
\n\N \V\n\T
yes
ugga
1
yes
fixed
3
degrees
off
235.000
0.000
200000.000
0.000
10
10
month,prin
apr
annual periodic interest rate
0.14 |
home
Amortiation calculator. Currently set up to simulate paying off a note at a set interest rate. Minor changes will allow it to compute the future value of a sum given an interest rate and a payment amount.
DIRECTORY:
month-- payment number
prin -- principal amount
apr -- set to annual periodic interest rate...
itm -- interest paid this month... computed
mi -- monthly interest rate... computed
pymt -- monthly payment.... set to payment
SETUP:
In execution preferences:
set Execution Results to Formatted
set number of iterations to a number larger than necessary to pay off note or accumulate sum.
USAGE:
Set month to 0.
Fill in payment amount (pymt) if it hasn't been already.
Fill in apr percentage (apr) if it hasn't been already.
Fill in principal amount. (prin)
Return to home cell, and select Execute from the Special menu.
244.000
|
itm
interest paid this month
2292.241
|
mi
monthly interest rate
0.012
|
month
0
|
prin
Principal amount
196270.030
|
pymt
monthly payment
2500 |