|
Investment
Techniques
Investing How To's
Finding
Real Estate Deals
Good
Buying Area
Home
Repair Costs
MLS
Sheet/Proforma
Mortages
in Excel
Negotiating
Deals
Paul's
Property Analyzer
Power
Team
Property
Management
Real
Estate Offer
Homeowner
How To's
Real
Estate Links
|
|
 |
Mortgages
in Excel |
 |
|
Here's how you can put mortgage calculations in your excel spreadsheet:
- Here is the fields you need and the calculations that go with
them. Put them anywhere in your spreadsheet and just adjust the
locations in the calculations.
| |
A |
B |
1 |
User Inputs |
|
2 |
Loan |
how much the mortgage is for |
3 |
Interest Rate |
the nominal interest rate |
4 |
Compounding Frequency |
how many times a year the mortgage is compounded. US is
12, Canada is 2 and loans are 12. |
5 |
Payment Frequency |
monthly is 12 biweekly is 26 |
6 |
Term of years |
number of years the mortgage is for |
7 |
Calculations |
|
8 |
Interest rate per period |
=((1+$B$3/($B$4))^($B$4/$B$5)-1) |
9 |
Holding periods |
=$B$6*$B$5 |
10 |
Payment Amounts |
=PMT($B$8,$B$9,$B$2)
|
|
|
Real-Estate-Haven