bond

 logo arch
 

CASH FLOW ANALYSIS

Welcome to the '$how Me The Money' Real Estate Analysis tool!

This tool is quick and easy to use. It can help you analyze potential investment property and calculate future profitability. Simply type in the property information and the ‘$how Me the Money’ analysis tool will do all the rest.
Run the analysis against multiple properties to find out which one you should buy. Play with futurevalues like property appreciation, inflation, and rental increases. Use it as many times as you like.
Lets get started.

Data Entry [Help]

Fill in the white fields. All grayed out fields are automatically calculated. Hold your mouse over the information icon Information icon to see a description of the field.

PROPERTY INFORMATION

Property Address: Physical address of property
Property Type: Description of property; i.e. duplex, four-plex, condo, etc.
Year of Purchases:
Year property will be purchased

LOAN INFORMATION

 
$
%
Property Purchase Price ($)
The total purchase price of the investment property
Total Down Payment ($)
Down payment as percentage of purchase price, the dollar value is automatically calculated
Less Deposit
Less earnest money or already deposited funds
Down Payment Due($)
Down payment less deposit
Loan Amount ($)
Loan amount less down payment or the amount to be financed
Interest Rate (%)
Expected interest rate for real estate loan
Loan Term (months)
Term of loan in months (360 months = 30 years)
Loan Fees
Expected closing costs for loan
Monthly Payment (P&I)
Monthly and yearly principle and interest payments for loan

INCOME

 
Monthly
Yearly
Gross Scheduled Income ($)
Gross scheduled monthly income from rents, yearly income is automatically calculated
Less Vacancy (%)
Percent of expected vacancy, dollar value is automatically calculated
Gross Operating Income
Gross operating income = scheduled income less vacancy

EXPENSES

Yearly Expenses
$
%
Property Taxes Annual property taxes for property and property taxes as percentage of gross operating income- this is helpful when comparing similar properties
Insurance   Annual insurance costs
Electricity   Annual electricity costs
Natural Gas   Annual natural gas costs
Sewer   Annual sewer costs
Water   Annual water bill costs
Garbage   Annual waste removal costs
Management Professional management fees as a percentage of gross income, dollar value is automatically calculated
Maintenance   Annual maintenance costs
Advertising   Annual rental advertising costs
Telephone   Annual telephone costs
Lawn Care & Snow Removal   Annual lawn care and/or snow removal costs
Pest Control   Annual pest control expenses
Miscellaneous   Miscellaneous expenses
  User defined expenses
  User defined expenses
Total Itemized Expenses Total of all annualized expenses and total of all annualized expenses divided by gross operating income

INCOME TAX

Tax bracket (%) Investor's income tax bracket

MISCELLANEOUS

Annual Expense Increase Rate % Expected annual percentage increase of expenses
Rental Income Increase Rate % Expected annual percentage increase of rental income
Property Appreciation Rate % Expected annual percentage increase of investment property value
Initial Start Up Costs: Estiamted initial startup costs or fix up cost property requires
Structure vs. Land Rate Percentage of property value versus land value used to calculate yearly depreciation
Yearly Depreciation Allowance($) Yearly tax depreciation allowance based on purchase price, tax bracket, and percentage of structure vs. land
Total Amount Invested ($) Down payment plus loan fees plus fix up costs

Copyright © 2007 Gary Bond Realty, Inc.

Gary Bond, ePro 703/587-4141 Fax: 703/425-2729 gary@agent-bond.com