00 Real Estate Evaluator (New)

STEP 1: DETERMINE YOUR TOTAL INVESTMENT
Property Name: Initial Out-of-Pocket

Property Address: Down Payment
Initial Renos & Repairs
Closing Costs & Fees
Purchase Price Total Investment $0.00
Down Payment (%)
Down Payment ($) #VALUE!
STEP 2: CALCULATE OPERATING INCOME
# of Units Unit Type Sq Ft Rent Per Unit Monthly Yearly

$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
Gross Rental Income $0.00 $0.00

Other Income $0.00 $0.00
Vacancy Loss (%) 0.0% $0.00 $0.00
Total Operating Income $0.00 $0.00
STEP 3: ADD UP OPERATING EXPENSES
Basic Expenses $ or % Amount Monthly Yearly
Maintenance (General) $ Amt $0.00 $0.00

Management (General) $ Amt $0.00 $0.00
Property Taxes (General) $ Amt $0.00 $0.00
Insurance (General) $ Amt $0.00 $0.00
Accounting & Legal (General) $ Amt $0.00 $0.00
*Shared Utilities (Multi-fam) $ Amt $0.00 $0.00
*Lawn Care (Multi-fam) $ Amt $0.00 $0.00
Other (General) $ Amt $0.00 $0.00
*These rarely apply to single-family homes
Advanced Expenses
Capital Expenditures (Maintenance) $ Amt $0.00 $0.00
Landscape Maintenance (Maintenance) $ Amt $0.00 $0.00
Pest/Termite Control (Maintenance) $ Amt $0.00 $0.00
Reserves (Maintenance) $ Amt $0.00 $0.00
Supplies (Maintenance) $ Amt $0.00 $0.00
Advertising (Management) $ Amt $0.00 $0.00

Inspections (Management) $ Amt $0.00 $0.00
Manager Salary (Management) $ Amt $0.00 $0.00
Phone & Internet (Management) $ Amt $0.00 $0.00
Office Supplies (Management) $ Amt $0.00 $0.00
Accounting (Professional) $ Amt $0.00 $0.00

Bank Charges (Professional) $ Amt $0.00 $0.00
Legal Services (Professional) $ Amt $0.00 $0.00
Referrals/Commissions (Professional) $ Amt $0.00 $0.00
Electricity (Utilities) $ Amt $0.00 $0.00

Gas/Heating Oil (Utilities) $ Amt $0.00 $0.00
Trash Removal (Utilities) $ Amt $0.00 $0.00
Water/Sewer (Utilities) $ Amt $0.00 $0.00
HOA/Condo Fees (Other) $ Amt $0.00 $0.00

Miscellaneous (Other) $ Amt $0.00 $0.00
Mortgage Insurance (Other) $ Amt $0.00 $0.00
Permits & Fees (Other) $ Amt $0.00 $0.00
Warranties (Other) $ Amt $0.00 $0.00
Total Operating Expenses $0.00 $0.00

% Operating Expenses to Income #DIV/0! #DIV/0!
*Net Operating Income (NOI) $0.00 $0.00
STEP 4: CALCULATE MORTGAGE PAYMENT
Financing Terms (Loan)
Loan Term in months (N)
Interest Rate (I/YR)
Original Loan Amount (PV) #VALUE!
Final Loan Balance (FV) <--- This is usually $0.
Monthly Yearly
Payment (principal & interest) #VALUE! #VALUE!
STEP 5: EVALUATE CASH FLOW AND ROI

Monthly Yearly
Operating Income $0.00 $0.00
(-) Operating Expenses $0.00 $0.00
(-) Mortgage Payment #VALUE! #VALUE!
(=) CASH FLOW #VALUE! #VALUE!
CASH-ON-CASH ROI #VALUE!
Cap Rate #VALUE!
Evaluator Instructions:
<-- Gray fields contain automatic calculations and cannot be overwritten.

<-- Yellow fields are essential fields that must be filled out for the gray field calculations to work properly.
<-- White fields are optional fields that don't usually have to be filled out for the automatic calculations to f
Step 1: Figure out your total out-of-pocket investment by filling out the yellow fields in the "Step 1" section of the s
Step 2: Next, calculate your operating income by filling out the relevant yellow fields. These include "Rent Per Un
Step 3: Then, tally your operating expenses by adding estimated monthly expenses to the appropriate yellow field
Use "Advanced Expenses" as needed or for commercial deals. The worksheet will then calculate your "To
Step 4: Calculate your mortgage payment by filling out each of the four yellow fileds with your loan information. T
For additional instructions, see the inserted comments (indicated by small, red triangles) located in the wh
Step 5: In the final section, the evaluator will automatically calculate property's monthly and annual "Cash Flow" a
Review these numbers to assess whether the property is a suitable investment or not. If the numbers do n
calculations to work properly.
the automatic calculations to function.
in the "Step 1" section of the spreadsheet. Calculate your down payment first and then your total investment.
s. These include "Rent Per Unit" and "Vacancy Loss (%)". The sheet will then calculate your "Total Operating Income".
s to the appropriate yellow fields. For single-family or small multi-family properties, focus on the "Basic Expenses".
eet will then calculate your "Total Operating Expenses" and your "Net Operating Income (NOI)".
s with your loan information. The worksheet will then calculate your "Payment (principal & interest)".
red triangles) located in the white cells just to the left of each yellow field.
thly and annual "Cash Flow" and annual "Cash-on-Cash ROI" (Return on Investment).
ment or not. If the numbers do not calculate automatically, go through the worksheet again and correct any errors.

00 Real Estate Evaluator (New)

Uploaded by

Copyright:

Available Formats

00 Real Estate Evaluator (New)

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

00 Real Estate Evaluator (New)

Uploaded by

Copyright:

Available Formats

STEP 1: DETERMINE YOUR TOTAL INVESTMENT

Property Name: Initial Out-of-Pocket

STEP 2: CALCULATE OPERATING INCOME

# of Units Unit Type Sq Ft Rent Per Unit Monthly Yearly

Gross Rental Income $0.00 $0.00

STEP 3: ADD UP OPERATING EXPENSES

Basic Expenses $ or % Amount Monthly Yearly

Maintenance (General) $ Amt $0.00 $0.00

Advertising (Management) $ Amt $0.00 $0.00

Accounting (Professional) $ Amt $0.00 $0.00

Electricity (Utilities) $ Amt $0.00 $0.00

HOA/Condo Fees (Other) $ Amt $0.00 $0.00

Total Operating Expenses $0.00 $0.00

STEP 5: EVALUATE CASH FLOW AND ROI

<-- Gray fields contain automatic calculations and cannot be overwritten.

You might also like