REAL ESTATE CALCULATORS(More Info)

Example Report
Back To HOME Page

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
By Using This Website You Agree That You Have Read and Understand Our Disclaimer!
Analytical Finances, Inc. Contents © 2005 - 2007
Real Estate Models / Mortgage Calculators / Real Estate Calculators / Business Calculators / Mortgage Interest Rates / Contact Us