Mortgage Amortization Excel Spreadsheet - Free Download | Page 3
4.8,
3860
votes
Please vote for this template if it helps you.
L $300,000 Mortgage loan
Y 20 Years (can be up to 30 years in this program)
M 240 Months (calculated by program)
RATE 5.00% Annual borrowing rate (A.P.R.)
i 0.42% Monthly borrowing rate (calculated by program)
PMT $1,979.87 Monthly mortgage payment (calculated by pgm.)
DEBT STILL OWED INTEREST DUE PAYMENT DUE REPAYMENT OF DEBT
MONTH AT BEGINNING OF AT THE END OF AT THE END OF WITH THIS PERIOD'S
THE PERIOD THE PERIOD THE PERIOD PAYMENT
(1) (2) (3) = i x (2) (4) (5) = (4) - (3)
1 $300,000.00 $1,250.00 $1,979.87 $729.87
2 $299,270.13 $1,246.96 $1,979.87 $732.91
3 $298,537.22 $1,243.91 $1,979.87 $735.96
4 $297,801.26 $1,240.84 $1,979.87 $739.03
5 $297,062.23 $1,237.76 $1,979.87 $742.11
Disregard any row row past the number of months for this deal
AMORTIZATION TABLE FOR A MORTGAGE LOAN (SCROLL DOWN)
SPREADSHEET FOR ANALYZING MORTGAGE LOANS
You need to specify only the numbers shown in red. The machine will do the rest.
SEE THE MORTIZATION TABLE FOR THIS DEAL BELOW
