rental real estate spreadsheet predictions

REAL ESTATE INVESTMENT ANALYSIS

This spreadsheet is designed to allow you to forecast the income, expenses, NOI and after tax returns of an income property held for 10 years.

It will also calculate estimated profits when you sell, both before and after tax.

Of course, the old theory applies, garbage in, garbage out. And it also must be understood that it

is truly impossible to predict the future path of inflation, rent increases and property prices.

Enter numbers in the YELLOW fields only

Purchase Price:

Down Payment:

Interest Rate on Loan:

% p.a.

Term of Loan:

yrs.

Improvement Ratio:

Percentage of building itself to total property value including land

No. Yrs. of Depreciation:

yrs. Straightline for residential.

39.5 years for commercial.

Scheduled Annual Gross Income:

Vacancy/Collection losses:

(Annual Operating Expenses)

---------

Property taxes :

Insurance: