Amortization Table
* Fill out the Yellow boxes only
loan amount # of monthly Payments $175,000.00 240 months = ----->
20 years
Interest Rate 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 7.00%
Monthly Payments ($1,179.23) ($1,203.80) ($1,228.65) ($1,253.75) ($1,279.12) ($1,304.75) ($1,330.64) ($1,356.77)
Total Payout ($283,014.55) ($288,912.67) ($294,875.07) ($300,901.04) ($306,989.84) ($313,140.72) ($319,352.88) ($325,625.55)
total average interest paid monthly interest ($108,014.55) ($450.06) ($113,912.67) ($474.64) ($119,875.07) ($499.48) ($125,901.04) ($524.59) ($131,989.84) ($549.96) ($138,140.72) ($575.59) ($144,352.88) ($601.47) ($150,625.55) ($627.61)
Same thing, just a little different Loan amount $175,000.00 down pmt $0.00 annual int rate 6.50% apr = term (in yrs) 20 years monthly pmt ($1,304.75)
0.54% per month
Lavy Concrete is not responsible if this sheet is incorrect
single monthly payment calculator Loan Amount Annual Interest rate
Monthly Interest rate
Formulas, DON'T TOUCH 1.45329441 0.00908309 0.45329441 0.02003795 $3,326.30
# of years # of months monthly payment total paid amount of Principal
$166,000.00 7.50% 0.63% 5 60
1+monthly interest rate, raised top of equation or monthly inte bottom of equation, or f4 - 1 top devided by bottom monthly payment, or f7 times l
$3,326.30
$199,577.97 amount of interest
* this was done the hard way, excel has a PM that is simple to use. total $3,326.30
month #
ON'T TOUCH 1+monthly interest rate, raised to the # of months top of equation or monthly interest rate times f4 bottom of equation, or f4 - 1 top devided by bottom monthly payment, or f7 times loan amount
one the hard way, excel has a PMT formula