| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||
2 | Cash Flow Worksheet | |||||||||||
3 | Enter data in GREEN fields only below | |||||||||||
4 | Property Location | Estimated Values* | Annual Depreciation | |||||||||
5 | ||||||||||||
6 | 23220 Sea Oats Drive | Land: | $125,000 | N/A | ||||||||
7 | Surf-Side | Improvments: | $345,177 | / | 27.5 | = | $12,552 | |||||
8 | Furnishings: | $10,000 | / | 7 | = | $1,429 | ||||||
9 | Total: | $480,177 | Total Dep. | = | $13,980 | |||||||
10 | ||||||||||||
11 | Estimated Gross Expenses | Estimated Gross Income | ||||||||||
12 | ||||||||||||
13 | Taxes | $2,133 | 10 | Weeks In-Season | x | = | $0 | |||||
14 | Insurance( Home Owners, wind & flood) | $3,900 | 2 | Weeks Pre-Season | x | = | $0 | |||||
15 | Utilities,elec,water,cable,internet | $5,420 | 2 | Weeks Post-Season | x | = | $0 | |||||
16 | Maintenance | $2,500 | 5 | Weeks Low-Season | x | = | $0 | |||||
17 | Other (reserve fund, etc.) | $1,000 | 5 | Weeks Off-Season | x | = | $0 | |||||
18 | Management Fee | 18.00% | $7,962 | |||||||||
19 | Pool & Hot Tub Maint. | $1,800 | 0 | Total Gross Owner Income | = | $44,232 | ||||||
20 | Total Gross Expenses | $24,715 | Less Total Gross Expenses | - | $24,715 | |||||||
21 | Equal Net Income | = | $19,517 | |||||||||
22 | ||||||||||||
23 | Financial Data | |||||||||||
24 | ||||||||||||
25 | Loan to Value (%) | 80% | ||||||||||
26 | Interest Rate | 2.75% | ||||||||||
27 | Loan Amount | $384,142 | ||||||||||
28 | Loan Term (Months) | 360 | = | 30 | Year Loan | |||||||
29 | Monthly Payment ( P&I ) | ($1,568) | Principal | Interest | ||||||||
30 | Total Annual Payments | ($18,819) | = | $8,360 | + | $10,459 | ||||||
31 | Plus Net Income | $19,517 | ||||||||||
32 | Equals Annual Cash Flow | $699 | /12 | = | Monthly Cash Flow Before Taxes: | $58 | ||||||
33 | ||||||||||||
34 | Summation | |||||||||||
35 | ||||||||||||
36 | Annual Cash Flow | $699 | ||||||||||
37 | Plus Annual Principal Payment | $8,360 | ||||||||||
38 | Equals (Loss) Gain Before Depreciation | $9,058 | This line shows yearly loss or gain after adding back principal payments | |||||||||
39 | Less Total Annual Depreciation | $13,980 | ||||||||||
40 | Equals Total Write-Off for Year | ($4,922) | x Tax Bracket = Estimated Tax Savings | |||||||||
41 | ||||||||||||
42 | State + Federal Tax Rate | Annual Cash + | Estimated Tax | = Annual Cash Flow / 12 | = Net Monthy (Loss) Gain | |||||||
43 | Flow | Savings | Net After Taxes | |||||||||
44 | ||||||||||||
45 | 27.5% | $699 | $1,354 | $2,052 | $171 | |||||||
46 | 30.5% | $699 | $1,501 | $2,200 | $183 | |||||||
47 | 35.5% | $699 | $1,747 | $2,446 | $204 | |||||||
48 | 39.1% | $699 | $1,925 | $2,623 | $219 | |||||||
49 | ||||||||||||
50 | Notes: | (1) This is a projection of future possibilities based on both known and estimated data. | ||||||||||
51 | Consult with your tax advisor to determine the effect on your personal financial situation. | |||||||||||
52 | (2) Tax Bracket equals the sum of both federal and state taxes. | |||||||||||
53 | (3) All dollar amounts are rounded. | |||||||||||
54 | * Real estate agent opinion | |||||||||||
55 | copyright 2004 John VanderMyde., all rights reserved | |||||||||||