Property Analysis Calculator

Fair Market Value Price a buyer would pay based on resent sold comps

$

Discount Discount from fair market value

%

Purchase Price (Max Offer Price) Highest price you want to pay

$

Down Payment Cash down payment based on purchase price

%

Interest Rate Loan mortgage rate

%

Costs of Repairs (Make Ready) Amount needed for repairs prior to renting the property

$

Closing Cost Purchase related cost - title, mortgage, document fees etc.

$

Length of Mortgage (Years)

$

Total Cash In Down payment + cost of repairs + closing cost

Amount Financed Total mortgage amount

Payment

Monthly

Annual

Monthly Mortgage Payment

Rental Income Tooltip Text

Monthly

Annual

Unit A If multifamily use Unit A to D for each unit, if single family use only Unit A

$

Unit B

$

Unit C

$

Unit D

$

Gross Rental Income Total rental income before expenses

Other Rental Income Income in addition of the rent, laundry income, vending machine income etc.

$

Vacancy Rate Estimated percent of time the property will be vacant

%

Net Rental Income Gross rental income minus lost income from vacancy

Expenses

Monthly

Annual

Property Management Fees

$

Leasing Costs One time management fee when you rent to new tenant

$

Monthly Maintenance Estimated dollar amount for property repairs

$

Utilities Utilities that the landlord will be paying – water, gas, electricity etc.

$

Property Taxes Yearly property tax

$

Insurance Yearly property insurance

$

Other (HOA fees, Lawn Care, Trash, etc) Additional landlord expenses

$

Total Expenses Total landlord expenses

Expenses & Vacancy % Of Rental Income What percent are the expenses from the gross rental income

Net Operating Income Gross rental income minus vacancy loss and total expenses

Mortgage Payment

Net Cash Flow Cash left after paying monthly mortgage and expenses

Investment Analysis

Appreciation Rate Percentage of yearly home price increase

%

Rent Appreciation Percentage of yearly home price increase

%

Cost to Sell Property Expenses related to selling the investment property – commission, closing cost etc.

%

Year
Gross Rents (Adjusted for Inflation)
Rent Appreciation Rate
Vacancy
Net Rental Income (Annual)
Annual Expenses (Adjusted for Inflation)
Net Operating Income (Annual)
Debt Pay Down (Principle Paid)
Accumulated Debt Pay Down
Interest Paid
Annual Net Cash Flow (Annual)
Property Value (Start of Year)
Annual Appreciation
Accumulated Appreciation
Year
Property Value (EOY)
Cost of Sale (COS)
Total Mortgage Debt
Equity
Accumulated Cash Flow
Total Cash In
Annual Total Return (Before COS)
Total ROI (Annual)
Cash on Cash ROR (Annual)
Total Return on Equity (After COS)
Accumulated Total Return (Accumulated Debt Pay Down, Cash Flow & Appreciation)
Total ROI Based on Acc.Total Return
Accumulated Total Return (after COS)
Total ROI on Acc.Total Return (after COS)