The Investor Calculator
Analyze investment properties like a professional.
Initial Investment
Purchase Price:
$380,000
Down Payment (30%):
$150,000
Closing Costs & Fees:
$6,000
Total Cash Investment:
$156,000
Financing Details
Loan Amount (70%):
$300,000
Mortgage Rate:
6.25%
Monthly Mortgage Payment:
$2400
Annual Mortgage Payment:
$22,000
Annual Expenses
Property Taxes:
$1579.50
Insurance Premium:
$725
HOA Fees:
$200
Vacancy Loss:
$200
Maintenance Costs:
$200
Property Management:
$200
Total Annual Expenses:
$27,000
Projected Income
Estimated Monthly Rent:
$2,600
Estimated Annual Rent (GSI):
$36,000
Monthly Before Tax Cash Flow :
$6,000
Annual Before Tax Cash Flow :
$6,000
Net Operating Income (NOI) :
$6,000
Metrics & ROI
10-Year Internal Rate of Return:
11.9%
10-Year Avg. Cash-On-Cash ROI:
3.9%
Cash-On-Cash ROI + Debt Paydown ROI:
7.4%
Capitalization Rate (First Year):
5.9%
Real Estate Value in 10 Years:
$9000
Economic Assumptions
Year:
Y1
Y2
Y3
Y4
Y5
Y6
Y7
Y8
Y9
Y10
Vacancy Rate (% of GSI):
0%
5%
5%
5%
5%
5%
5%
5%
5%
5%
Maintenance Rate (% of GOI):
2%
3%
4%
5%
5%
5%
5%
5%
5%
5%
Property Mgmt Rate (% of GOI):
10%
10%
10%
10%
10%
10%
10%
10%
10%
10%
Property Appreciation Rate:
4%
4%
4%
4%
4%
4%
4%
4%
4%
4%
Rent Appreciation Rate:
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
Expense Inflation Rate:
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
Sales Cost Rate (% of Price):
-
-
-
-
-
-
-
-
-
7%
Vacancy Rate (% of GSI):
0%
5%
5%
5%
5%
5%
5%
5%
5%
5%
Maintenance Rate (% of GOI):
2%
3%
4%
5%
5%
5%
5%
5%
5%
5%
Property Mgmt Rate (% of GOI):
10%
10%
10%
10%
10%
10%
10%
10%
10%
10%
Property Appreciation Rate:
4%
4%
4%
4%
4%
4%
4%
4%
4%
4%
Rent Appreciation Rate:
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
3.5%
Expense Inflation Rate:
3%
3%
3%
3%
3%
3%
3%
3%
3%
3%
Sales Cost Rate (% of Price):
-
-
-
-
-
-
-
-
-
7%
INITIAL INVESTMENT
Enter Purchase Price of the property. If you are financing the property, enter the Down Payment percentage here. For most investors, it’s usually a number between 20-30%. For a cash purchase, enter 100%. Next, enter the Closing Costs & Fees. If you are working with a lender, she can give you a good faith estimate for this line item.
Purchase Price
$
Closing Costs & Fees
$
INCOME AND EXPENSES
Enter the Monthly Rent, Annual Property Tax and Annual Insurance Premium amounts here. The tax information is available on most county property tax websites. The insurance information is available from the insurance company. It is important to research whether or not the property is located in a homeowner’s association that carries Homeowner’s Association (HOA) fees. If so, enter the annual amount.
Monthly Rent*
$
Annual Property Tax
$
Annual Insurance Premium
$
Annual HOA Fees
$
ECONOMIC ASSUMPTIONS
In this section, you need to make some assumptions about the property as indicated to the right. Vacancy Rate: Percentage of Gross Scheduled Income (GSI) or total annual rents possible per year. Maintenance Rate: Percentage of Gross Operating Income (GOI), or the income the property receives after accounting for vacancy. Property Management Rate: Percentage of GOI, the amount of rents actually collected by the property manager. Property Appreciation Rate: Your expectation of how the property value will appreciate. Expense Inflation Rate: The general economic inflation percentage rate. Sales Costs: Costs associated with selling property when it is finally sold, including sales commissions and closing costs. This is a one-time expense.
Vacancy Rate (% of GSI)
%
Advanced +Maintenance Rate (% of GOI)
%
Advanced +Property Mgmt Rate (% of GOI)
%
Advanced +Property Appreciation Rate
%
Advanced +Rent Appreciation Rate
%
Advanced +Expense Inflation Rate
%
Advanced +Sales Cost Rate (% of Price)
%
INVESTMENT AND DEBT SERVICE CALCULATIONS
Investment and debt service calculations: Based on the data entered above, the investor’s total cash investment, and the monthly and annual debt service is calculated here.
Property Purchase Price
Down Payment
Closing Costs & Fees
Total Cash Investment
DEBT SERVICE SUMMARY
Investment and debt service calculations: Based on the data entered above, the investor’s total cash investment, and the monthly and annual debt service is calculated here.
Amount Financed
Debt Service (P&I), Monthly
Debt Service (P&I), Annual
KEY FINANCIAL RATIOS (RETURN ON INVESTMENT)
Key Financial Ratios are calculated as 10-year averages to the right based on the data entered above.
10-Year Average Cash on Cash ROI – ten year average of cash on cash (CoC) return.
Cash-On-Cash ROI + Debt Pay Down – this is the combined return of the debt pay down and the cash on cash return.
10-Year Average Capitalization Rate – 10 year average of annual Net Operating Income of the property divided by its purchase price. This is the approximate annual CoC return for an all-cash purchase.
10-Year Internal Rate of Return (IRR) – the annual return accounting for the amount invested, cash flow earned through rents, pay down of the mortgage loan, and appreciation realized from the sale of the property. IRR is an overall return on investment metric that accounts for the amount and timing of all cash flows disbursed and received each year.
10-Year Average Cash-On-Cash ROI
Avg 10-Year CoC
Cash-On-Cash ROI + Debt Paydown ROI
Avg 10-Year CoC + Debt Paydown ROI, Excl. Appreciation
Capitalization Rate (First Year)
First Year Net Operating Income ÷ Purchase Price
10-Year Internal Rate of Return
IRR per Year
About These Calculations
All numbers are estimates for illustration only and not guaranteed. Actual performance, pricing, and rent may vary. This is not a commitment to sell or invest. Please consult your financial advisor. We expect the rent to be within $50 of the estimated rent. Meridian helps to protect the rental income for our investors through our rent warranty program.
