rental real estate spreadsheet predictions

REAL ESTATE INVESTMENT ANALYSIS

(Page 1 of 6)

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. Tab from field to field but allow a few seconds each time for the numbers to update.

Purchase Price:

Down Payment:

Interest Rate on Loan:

% p.a.

Term of Loan:

yrs.

Improvement Ratio:

%age of building to total property value

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:

Electricity: