Real Estate Investment Analysis Spreadsheet

This is a simple one page cash flow analyzation¬†spreadsheet. The Property Analyzer is a spreadsheet used to evaluate a property’s cashflow characteristics. Enter in the basic information of the transaction and the spreadsheet will calculate several common ratios and profitability measures to help properly analyze your transaction.

You can enter the property details including address type and size.

The first section has cost information which calculates your cost basis.

The main section of the spreadsheet allows for
1) POTENTIAL RENTAL INCOME
2) Less: Vacancy
3) EFFECTIVE RENTAL INCOME
4) Plus: Other Income
5) GROSS OPERATING INCOME

OPERATING EXPENSES
6) Real Estate Taxes
7) Personal Property Taxes
8) Property Insurance
9) Off Site Management
10) Payroll
11) Expenses/Benefits
12) Taxes/Worker’s Compensation
13) Repairs and Maintenance
14) Utilities
15) Accounting and Legal
16) Licenses/Permits
17) Advertising
18) Supplies
19) Lawn and Grounds Keeping
20,21,22,23) Miscellaneous

The folowing sections are calculated.
24) TOTAL OPERATING EXPENSES
25) NET OPERATING INCOME
26) Less: Annual Debt Service
27) CASH FLOW BEFORE TAXES
28) Add Back: Principal Payments
29) – Depreciation
30) TAXABLE NET INCOME (LOSS)

The lower section is a brief explanation of the spreadsheet and its calculations.

Spreadsheet Real Estate Property Analyzer Download