|
|
|---|---|
| REAL ESTATE CALCULATORS(More Info) | |
Example Report |
Try It : |
Real Estate Calculators / Five Year Forecast / Rental Property |
||||||
PROCEEDS FROM SALE |
||||||
Closing |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Value |
500,000 |
510,000 |
520,200 |
530,604 |
541,216 |
552,040 |
Mortgage (First) |
360,000 |
355,682 |
351,092 |
346,213 |
341,026 |
335,512 |
Mortgage (Second) |
80,000 |
79,040 |
78,019 |
76,934 |
75,782 |
74,558 |
Equity |
60,000 |
75,278 |
91,089 |
107,457 |
124,408 |
141,970 |
Real Estate Brokers Fees @ 4.50% |
N/A |
22,950 |
23,409 |
23,877 |
24,355 |
24,842 |
Proceeds After Mort. and R.E. Fees |
N/A |
52,328 |
67,680 |
83,580 |
100,053 |
117,128 |
Total Estimated Deferred Tax Liab. |
N/A |
645 |
6,249 |
11,894 |
17,582 |
23,315 |
Net Proceeds After Taxes |
N/A |
51,683 |
61,431 |
71,686 |
82,471 |
93,813 |
INCOME STATEMENT |
||||||
Closing |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Rent |
N/A |
30,000 |
30,900 |
31,827 |
32,782 |
33,765 |
Real Estate Taxes |
N/A |
7,500 |
7,800 |
8,112 |
8,436 |
8,773 |
Mortgage Interest (First) |
N/A |
21,930 |
21,658 |
21,369 |
21,062 |
20,735 |
Mortgage Interest (Second) |
N/A |
4,873 |
4,813 |
4,749 |
4,680 |
4,608 |
Maintenance |
N/A |
4,500 |
4,725 |
4,961 |
5,209 |
5,469 |
P/L Before Depreciation |
N/A |
-8,803 |
-8,096 |
-7,364 |
-6,605 |
-5,819 |
Depreciation |
N/A |
10,909 |
10,909 |
10,909 |
10,909 |
10,909 |
P/L Before Taxes |
N/A |
-19,712 |
-19,005 |
-18,273 |
-17,514 |
-16,728 |
Prior Year Loss Carryforward |
N/A |
0 |
0 |
0 |
0 |
0 |
P/L Before Taxes Adjusted for Prior Year Loss Carryforward |
N/A |
-19,712 |
-19,005 |
-18,273 |
-17,514 |
-16,728 |
Income Tax Adjustment Rental YES @ 30.00% |
N/A |
-5,914 |
-5,702 |
-5,482 |
-5,254 |
-5,018 |
P/L After Taxes |
N/A |
-13,798 |
-13,304 |
-12,791 |
-12,260 |
-11,710 |
STATEMENT OF CASH FLOWS |
||||||
Closing |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
P/L After Taxes |
N/A |
-13,798 |
-13,304 |
-12,791 |
-12,260 |
-11,710 |
ADDITIONS: |
N/A |
|||||
Depreciation |
N/A |
10,909 |
10,909 |
10,909 |
10,909 |
10,909 |
SUBTRACTIONS: |
N/A |
|||||
Mortgage Principal (First) |
N/A |
4,319 |
4,591 |
4,880 |
5,187 |
5,514 |
Mortgage Principal (Second) |
N/A |
960 |
1,020 |
1,085 |
1,153 |
1,225 |
Cash Flow |
N/A |
-8,168 |
-8,005 |
-7,846 |
-7,691 |
-7,540 |
PROPERTY BASIS |
||||||
Closing |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Value |
500,000 |
510,000 |
520,200 |
530,604 |
541,216 |
552,040 |
Less Cost Basis (Purcahse Price) |
400,000 |
400,000 |
400,000 |
400,000 |
400,000 |
400,000 |
Less Cost Basis (Rehab Costs) |
100,000 |
100,000 |
100,000 |
100,000 |
100,000 |
100,000 |
Less R.E. Brokers Fees @ 4.50% |
N/A |
22,950 |
23,409 |
23,877 |
24,355 |
24,842 |
Long Term Capital Gain/Loss |
N/A |
-12,950 |
-3,209 |
6,727 |
16,861 |
27,198 |
Accumulated Depreciation |
N/A |
10,909 |
21,818 |
32,727 |
43,636 |
54,545 |
DEFERRED TAXES |
||||||
Closing |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Fed. LT Capital Gains Tax @ 15.00% |
N/A |
-1,942 |
-481 |
1,009 |
2,529 |
4,080 |
State Capital Gains Tax @ 6.85% |
N/A |
-887 |
-220 |
461 |
1,155 |
1,863 |
Fed. Depr. Recapture @ 25.00% |
N/A |
2,727 |
5,455 |
8,182 |
10,909 |
13,636 |
State Depr. Recapture @ 6.85% |
N/A |
747 |
1,495 |
2,242 |
2,989 |
3,736 |
Total Estimated Deferred Tax Liab. Before Adj. For Any Loss Carryforward |
N/A |
645 |
6,249 |
11,894 |
17,582 |
23,315 |
Loss Carryforward |
N/A |
0 |
0 |
0 |
0 |
0 |
Estimated Offset To Tax Liab. Due To Loss Carryforward @ (15.00% + 6.85%) |
N/A |
0 |
0 |
0 |
0 |
0 |
Total Estimated Deferred Tax Liab. |
N/A |
645 |
6,249 |
11,894 |
17,582 |
23,315 |
| Analytical Finances, Inc. Contents © 2005 - 2007 |
|---|
 |
 |
 |
 |
 |
|
