Purchase Info

Here you just need to add the purchase information for the total property.
Closing costs vary by location. If you are not sure of this number use 3% of the purchase price


Property Description
Purchase Price: $
Down Payment: $
Closing Costs: $

Next -->
Start Over

Annual Operating Expenses

Input in the form of $ dollars, not %


Real Estate Taxes: $
Repairs: $
Insurance: $
Utilities: $
Landscaping: $
Property Management: $
Association Dues: $
Trash: $
Misceillaneous: $

<-- Prev   Next -->
Start Over

Financial Information

Here you just need to add Financial information for 1st and 2nd mortgage when applicable. Input number as a percentage number.


First Mortgage to Value: %
First Mortgate Rate: %
First Mortgage Length:
Second Mortgage to Value: %
Second Mortgage Rate: %
Second Mortgage Length:
Your Tax Bracket: %

<-- Prev   Next -->
Start Over

Purchase Cost Breakdown

As your investment properties have tax advantages that are in part based on the depreciable values,
for maximum tax benefit your tax advisor will want to know a break down of the value for each of the following.
As the values will change by location, you will get the best idea of these break downs from your
realtor or tax person. If you are currently not sure, a suggested rule of thumb would be as follows.


Land Value: %
Personal Property Value: %
Building Value: %

<-- Prev   Next -->
Start Over

Income Breakdown


Monthly Rent: $
Vacancy Allowance: %
Estimated Appreciation Rate: %

<-- Prev   Finish -->
Start Over

IDEAL Summary

Note this summary assumes one full calendar year of ownership for first year.


Total Cash Flow Before Taxes: $ Income
Total Tax Paid or Saved: $ Deductions
Total Principal Reduction: $ Equity
Total Appreciation: $ Appreciation
LEVERAGE INCOME: $ Leverage      (based on financed)
TOTAL INCOME: $
Cap Rate: %
Cash-on-Cash Return: %
Return on Investment: %

<-- Prev   View Worksheet -->
Return to Summary
PURCHASE INFORMATION
Purchase Cost:
Down Payment:
Closing Costs:
TOTAL CASH INVESTED:
RATE OF RETURN ANALYSIS
CAP RATE:
CASH-ON-CASH:
RETURN ON INVESTMENT:
ANNUAL OPERATING EXPENSES
Real Estate Taxes:
Repairs:
Insurance:
Landscaping:
Property Management:
Association Dues:
Trash:
Miscellaneous:
TOTAL ANNUAL OPERATING EXPENSES:
TOTAL DEPRECIATION
PROPERTY INFORMATION
% of Total Interest Rate Loan Amount Loan Term
First Mortgage
Second Mortgage
TOTAL LOAN
Monthly P & I First Year Interest First Year Principal Annual P & I
First Mortgage
Second Mortgage
TOTALS
Depreciation Rate Depreciation Amount
Land Value
Personal Property Value
Building Value
Monthly Annual
Rent
Less Vacancy
Gross Operating Income
FIVE YEAR PROJECTION
TAXABLE INCOME Year 1 Year 2 Year 3 Year 4 Year 5
Total Gross Income (+5%)
Vacancy Loss
Operating Expenses (+10%)
Net Operating Income
Interest
Depreciation
Taxable Income
CASH FLOWS
Net Operating Income
Principal & Interest Payments
I Cash Flow Before Taxes
D Taxes Paid (or Saved)
E Principal Reduction
A Appreciation
L Leverage Income
Total Income