8005 Church Street East, Suite 103 Brentwood, TN 37027 615.373.4350 Office
Investment Property Worksheet Property Information Financing Purchase Cost Down Payment Amount Financing
$ $ $
222,222.00 44,444.00 177,778.00
$ $ $ $
25,000.00 197,222.00 -
Financing Int Rate
P&I Monthly P&I Yearly
6.50% $ 1,134.48 $ 13,613.78
Depreciation Land Cost Personal Prop Cost (5 Yr) Building Cost (27.5 Yr Res) Landing Improv Cost (15 Yr)
x x x
20.00% 3.64% 6.67% Total Depreciation
= = = =
Income & Expenses Annual Income Annual Rent Less Vacancy Gross Operating Income =
$ $ $
19,200.00 (960.00) 18,240.00
Vacancy % Rate
$ $ $
2,222.00 120.00 1536 -
Advertising Insurance Supplies Misc Total Op. Exp. =
5.00%
Annual Operating Expenses REA Tax Repairs Association Dues Mgmt Fees (8%) Utilities
The Four Benefits 1. Gross Operating Income Less Operating Expenses Yields Net Operating Income Less Annual Debt Service Yields Cash Flow Before Taxes
2. Annual Debt Service Less Interest Yields Principal Reduction
3. Net Operating Income Less Interest Less Total Depreciation Yields Taxable Income (Loss) Times Tax Bracket Yields Tax PAID or SAVED
$ $ $ $ $ $ $ $ $ $ $
4. Appreciation (est 6.4%)
18,240.00 (4,478.00) 13,762.00 (13,613.78) [Yearly P & I] $ 13,613.78 (11,555.57) $ 13,762.00 (11,555.57) (7,171.70) (4,965.27) 35.00% $ $
148.22
2,058.21
1,737.85 14,222.21
Rates of Return ROI with Appreciation
= 40.87% [(Cash Flow before Tax + Principle Reduction + Tax Saved + Appreciation)/Cash]
ROI without Appreciation = 8.87% [(Cash Flow before Tax + Principle Reduction + Tax Saved)/Cash] Capitalization Rate
=
6.19%
[Net Operating Income/Purchase Cost]
Cash on Cash
= 8.87% [(Cash Flow before Tax+Principal Reduction+Tax Paid or Saved)/Cash Invested]
$ $ 600.00 $ $ $ 4,478.00
$ $ $ $
7,171.70 7,171.70