REAL ESTATE CALCULATORS(More Info)

Example Report
Back To HOME Page

You have selected to run a 15 year forecast . This will include both an income statement and a balance sheet, hence it will include 1) a forecast of the properties estimated value, 2) a forecast of the properties basis, 3) a forecast of the remaining mortgage balance, 4) a forecast of any accumulated depreciation and 5) a forecast of any other balance sheet item.

You will need to select the appropriate property classification from the below drop down menu. The property classifications are non rental property, rental property and part rental / part non rental property. Owner occupied property would fall under the property classifications of either non rental property or part rental / part non rental property.

In selecting an appropriate property classification you will need to determine if the property is to be acquired or if the property was previously acquired. Performing a forecast on a property that was previously acquired will require additional information relating to 1) mortgage amounts, 2) accumulated depreciation and 3) any possible carry forward losses.
 

Try It :

Real Estate Calculators / Fifteen Year Forecast / Rental Property
 
PROCEEDS FROM SALE
 
Closing
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
Year 11
Year 12
Year 13
Year 14
Year 15
Value
500,000
510,000
520,200
530,604
541,216
552,040
510,000
520,200
530,604
541,216
552,040
541,216
552,040
541,216
552,040
541,216
Mortgage (First)
360,000
355,682
351,092
346,213
341,026
335,512
355,682
351,092
346,213
341,026
335,512
341,026
335,512
341,026
335,512
341,026
Mortgage (Second)
80,000
79,040
78,019
76,934
75,782
74,558
79,040
78,019
76,934
75,782
74,558
75,782
74,558
75,782
74,558
75,782
Equity
60,000
75,278
91,089
107,457
124,408
141,970
75,278
91,089
107,457
124,408
141,970
124,408
141,970
124,408
141,970
124,408
Real Estate Brokers Fees @ 4.50%
N/A
22,950
23,409
23,877
24,355
24,842
22,950
23,409
23,877
24,355
24,842
24,355
24,842
24,355
24,842
24,355
Proceeds After Mort. and R.E. Fees
N/A
52,328
67,680
83,580
100,053
117,128
52,328
67,680
83,580
100,053
117,128
100,053
117,128
100,053
117,128
100,053
Total Estimated Deferred Tax Liab.
N/A
645
6,249
11,894
17,582
23,315
645
6,249
11,894
17,582
23,315
17,582
23,315
17,582
23,315
17,582
Net Proceeds After Taxes
N/A
51,683
61,431
71,686
82,471
93,813
51,683
61,431
71,686
82,471
93,813
82,471
93,813
82,471
93,813
82,471
INCOME STATEMENT
 
Closing
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
Year 11
Year 12
Year 13
Year 14
Year 15
Rent
N/A
30,000
30,900
31,827
32,782
33,765
30,000
30,900
31,827
32,782
33,765
32,782
33,765
32,782
33,765
32,782
Real Estate Taxes
N/A
7,500
7,800
8,112
8,436
8,773
7,500
7,800
8,112
8,436
8,773
8,436
8,773
8,436
8,773
8,436

Mortgage Interest (First)

N/A
21,930
21,658
21,369
21,062
20,735
21,930
21,658
21,369
21,062
20,735
21,062
20,735
21,062
20,735
21,062

Mortgage Interest (Second)

N/A
4,873
4,813
4,749
4,680
4,608
4,873
4,813
4,749
4,680
4,608
4,680
4,608
4,680
4,608
4,680
Maintenance
N/A
4,500
4,725
4,961
5,209
5,469
4,500
4,725
4,961
5,209
5,469
5,209
5,469
5,209
5,469
5,209
P/L Before Depreciation
N/A
-8,803
-8,096
-7,364
-6,605
-5,819
-8,803
-8,096
-7,364
-6,605
-5,819
-6,605
-5,819
-6,605
-5,819
-6,605
Depreciation
N/A
10,909
10,909
10,909
10,909
10,909
10,909
10,909
10,909
10,909
10,909
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
-19,712
-19,005
-18,273
-17,514
-16,728
-17,514
-16,728
-17,514
-16,728
-17,514
Prior Year Loss Carryforward
N/A
0
0
0
0
0
0
0
0
0
0
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
-19,712
-19,005
-18,273
-17,514
-16,728
-17,514
-16,728
-17,514
-16,728
-17,514
Income Tax Adjustment
Rental YES @ 30.00%
N/A
-5,914
-5,702
-5,482
-5,254
-5,018
-5,914
-5,702
-5,482
-5,254
-5,018
-5,254
-5,018
-5,254
-5,018
-5,254
P/L After Taxes
N/A
-13,798
-13,304
-12,791
-12,260
-11,710
-13,798
-13,304
-12,791
-12,260
-11,710
-12,260
-11,710
-12,260
-11,710
-12,260
STATEMENT OF CASH FLOWS
 
Closing
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
Year 11
Year 12
Year 13
Year 14
Year 15
P/L After Taxes
N/A
-13,798
-13,304
-12,791
-12,260
-11,710
-13,798
-13,304
-12,791
-12,260
-11,710
-12,260
-11,710
-12,260
-11,710
-12,260
ADDITIONS:
N/A
                              
Depreciation
N/A
10,909
10,909
10,909
10,909
10,909
10,909
10,909
10,909
10,909
10,909
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
4,319
4,591
4,880
5,187
5,514
5,187
5,514
5,187
5,514
5,187
Mortgage Principal (Second)
N/A
960
1,020
1,085
1,153
1,225
960
1,020
1,085
1,153
1,225
1,153
1,225
1,153
1,225
1,153
Cash Flow
N/A
-8,168
-8,005
-7,846
-7,691
-7,540
-8,168
-8,005
-7,846
-7,691
-7,540
-7,691
-7,540
-7,691
-7,540
-7,691
PROPERTY BASIS
 
Closing
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
Year 11
Year 12
Year 13
Year 14
Year 15
Value
500,000
510,000
520,200
530,604
541,216
552,040
510,000
520,200
530,604
541,216
552,040
541,216
552,040
541,216
552,040
541,216
Less Cost Basis (Purcahse Price)
400,000
400,000
400,000
400,000
400,000
400,000
400,000
400,000
400,000
400,000
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
100,000
100,000
100,000
100,000
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
22,950
23,409
23,877
24,355
24,842
24,355
24,842
24,355
24,842
24,355
Long Term Capital Gain/Loss
N/A
-12,950
-3,209
6,727
16,861
27,198
-12,950
-3,209
6,727
16,861
27,198
16,861
27,198
16,861
27,198
16,861
Accumulated Depreciation
N/A
10,909
21,818
32,727
43,636
54,545
10,909
21,818
32,727
43,636
54,545
43,636
54,545
43,636
54,545
43,636
DEFERRED TAXES
 
Closing
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
Year 11
Year 12
Year 13
Year 14
Year 15
Fed. LT Capital Gains Tax @ 15.00%
N/A
-1,942
-481
1,009
2,529
4,080
-1,942
-481
1,009
2,529
4,080
2,529
4,080
2,529
4,080
2,529
State Capital Gains Tax @ 6.85%
N/A
-887
-220
461
1,155
1,863
-887
-220
461
1,155
1,863
1,155
1,863
1,155
1,863
1,155
Fed. Depr. Recapture @ 25.00%
N/A
2,727
5,455
8,182
10,909
13,636
2,727
5,455
8,182
10,909
13,636
10,909
13,636
10,909
13,636
10,909
State Depr. Recapture @ 6.85%
N/A
747
1,495
2,242
2,989
3,736
747
1,495
2,242
2,989
3,736
2,989
3,736
2,989
3,736
2,989
Total Estimated Deferred Tax Liab.
Before Adj. For Any Loss Carryforward
N/A
645
6,249
11,894
17,582
23,315
645
6,249
11,894
17,582
23,315
17,582
23,315
17,582
23,315
17,582
Loss Carryforward
N/A
0
0
0
0
0
0
0
0
0
0
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
0
0
0
0
0
0
0
0
0
0
Total Estimated Deferred Tax Liab.
N/A
645
6,249
11,894
17,582
23,315
645
6,249
11,894
17,582
23,315
17,582
23,315
17,582
23,315
17,582
PROCEEDS FROM SALE
Owner occupied residential sales may qualify for the $250,000/$500,000 tax exclusion. Speak to your tax specialist to see if you qualify. This model applies federal and state tax rates to any gain from the sale of real property used as a primary residence net of any qualifying exclusion. However, it is the responsibility of the user to determine their federal tax rates, their state tax rates, their tax exclusion amount and whether they qualify for any exclusion. This model does not consider and adjust for the varying tax circumstances resulting if the property is held for a period less than the time period needed to qualify for long term capital gains tax rates or any exclusion. As an example, if you input "YES" to qualifying for an exclusion and you input a long term capital gains tax of 15%, this model will apply these parameters to all years with out regard to any other consideration, i.e. if you sell in "Year 1" you may not qualify for either long term capital gains tax rates and/or any exclusion.
ANNUAL EXPENSES
This is before mortgage principal included below in statement of cash outflows. In addition the "Income Tax Adjustment " is calculated from your ordinary income tax rate; however your benefit may be less due to other considerations such as no longer being eligible for the standard deduction on the basis that you would be itemizing the above deductions. Speak to you tax specialist.
CASH OUTFLOW
This is what most homeowners are interested in and that is what they expect to pay out on a cash flow basis after any possible tax benefit. Remember that this number contains maintenance as well. So if you do not want to see maintenance than enter zero for annual maintenance expenses.
PROPERTY BASIS
The above "Long Term Capital Gain/Loss" is net of real estate commissions.
DEFERRED TAXES
Remember that deferred taxes may be irrelevant if you qualify for the exclusion. Speak to your tax specialist.

*If you have losses from the sale of the property this model does not consider any tax benefit for deducting capital losses from the sale of the property and will display zero both here under "Gain After Any Exclusion" and above under "Total Estimated Deferred Tax Liability" .

Remember that this is only an estimate and that actual numbers may differ at the time of tax preparation.

By Using This Website You Agree That You Have Read and Understand Our Disclaimer!

Analytical Finances, Inc. Contents © 2005 - 2007