REAL ESTATE CALCULATORS(More Info)

Try It :

Real Estate Calculators / Ten Year Forecast / Commercial Property

NET PRESENT VALUE
 
T-0
T-1
T-2
T-3
T-4
T-5
T-6
T-7
T-8
T-9
T-10
Initial Cash Outlay
-500,000
-500,000
-500,000
-500,000
-500,000
-500,000
-500,000
-500,000
-500,000
-500,000
-500,000
Conversion Factor @ 6.00%
1.00
0.94
0.89
0.84
0.79
0.75
0.70
0.67
0.63
0.59
0.56
PV Of Cash Flows From Operations
  
-21,103
-17,586
-14,334
-11,329
-8,556
-6,001
-3,649
-1,487
497
2,316
PV Of Cash Flows From Operations
(Accumulated)
 
-21,103
-38,689
-53,023
-64,352
-72,908
-78,908
-82,558
-84,045
-83,547
-81,232
PV Of Net Proceeds After Taxes
From Sale
 
448,108
483,180
508,793
531,396
551,231
568,524
583,484
596,304
607,165
616,234
Total PV Of Subsequent Cash Flows
  
427,005
444,491
455,770
467,044
478,324
489,615
500,926
512,259
523,618
535,002
NPV
  
-72,995
-55,509
-44,230
-32,956
-21,676
-10,385
926
12,259
23,618
35,002
PROCEEDS FROM SALE
 
T-0
T-1
T-2
T-3
T-4
T-5
T-6
T-7
T-8
T-9
T-10
Value
2,000,000
2,060,000
2,121,800
2,185,454
2,251,018
2,318,548
2,388,105
2,459,748
2,533,540
2,609,546
2,687,833
Mortgage
1,500,000
1,482,006
1,462,876
1,442,544
1,420,931
1,397,955
1,373,531
1,347,568
1,319,970
1,290,633
1,259,448
Equity
500,000
577,994
658,924
742,910
830,087
920,593
1,014,574
1,112,180
1,213,570
1,318,913
1,428,385
Real Estate Brokers Fees @ 5.00%
  
103,000
106,090
109,273
112,551
115,927
119,405
122,987
126,677
130,477
134,392
Proceeds After Mort. and RE Fees
 
474,994
552,834
633,637
717,536
804,666
895,169
989,193
1,086,893
1,188,436
1,293,993
LT Cap. Gain Tax and Depr. Recap.
Tax Adj. For Any Loss Carryforward
 
0
9,933
27,656
46,661
66,994
88,707
111,849
136,475
162,643
190,412
Net Proceeds After Taxes
 
474,994
542,901
605,981
670,875
737,672
806,462
877,344
950,418
1,025,793
1,103,581
INCOME STATEMENT
 
T-0
T-1
T-2
T-3
T-4
T-5
T-6
T-7
T-8
T-9
T-10
Rent
  
100,000
103,000
106,090
109,273
112,551
115,927
119,405
122,987
126,677
130,477
Real Estate Taxes
 
10,000
10,300
10,609
10,927
11,255
11,593
11,941
12,299
12,668
13,048

Mortgage Interest

  
91,375
90,242
89,037
87,756
86,394
84,947
83,408
81,772
80,034
78,185
Maintenance
  
3,000
3,090
3,183
3,278
3,376
3,477
3,581
3,688
3,799
3,913
P/L Before Depreciation
 
-4,375
-632
3,261
7,312
11,526
15,911
20,475
25,228
30,176
35,331
Depreciation
  
37,975
37,975
37,975
37,975
37,975
37,975
37,975
37,975
37,975
37,975
P/L Before Taxes
 
-42,350
-38,607
-34,714
-30,663
-26,449
-22,064
-17,500
-12,747
-7,799
-2,644
Prior Year Loss Carryforward
  
0
-42,350
-80,957
-115,671
-146,334
-172,783
-194,847
-212,347
-225,094
-232,893
P/Ls Before Taxes Adj.
For Prior Year Loss Carryforward
 
-42,350
-80,957
-115,671
-146,334
-172,783
-194,847
-212,347
-225,094
-232,893
-235,537
Income Taxes Adjustment NO 35.00%
  
0
0
0
0
0
0
0
0
0
0
P/L After Taxes
 
-42,350
-38,607
-34,714
-30,663
-26,449
-22,064
-17,500
-12,747
-7,799
-2,644
STATEMENT OF CASH FLOWS
 
T-0
T-1
T-2
T-3
T-4
T-5
T-6
T-7
T-8
T-9
T-10
Profits After Taxes
 
-42,350
-38,607
-34,714
-30,663
-26,449
-22,064
-17,500
-12,747
-7,799
-2,644
ADDITIONS:
                      
Depreciation
  
37,975
37,975
37,975
37,975
37,975
37,975
37,975
37,975
37,975
37,975
SUBTRACTIONS:
                      
Mortgage Principal
  
17,994
19,128
20,333
21,614
22,976
24,423
25,962
27,598
29,336
31,184
Cash Flows From Operations
  
-22,369
-19,760
-17,072
-14,302
-11,450
-8,512
-5,487
-2,370
840
4,147
PROPERTY BASIS
 
T-0
T-1
T-2
T-3
T-4
T-5
T-6
T-7
T-8
T-9
T-10
Value
2,000,000
2,060,000
2,121,800
2,185,454
2,251,018
2,318,548
2,388,105
2,459,748
2,533,540
2,609,546
2,687,833
Less Cost Basis
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
2,000,000
Less R.E. Brokers Fees @ 5.00%
  
103,000
106,090
109,273
112,551
115,927
119,405
122,987
126,677
130,477
134,392
Long Term Capital Gain/Loss
  
-43,000
15,710
76,181
138,467
202,621
268,700
336,761
406,863
479,069
553,441
Acc. Depr.
  
37,975
75,949
113,924
151,899
189,873
227,848
265,823
303,797
341,772
379,747
DEFERRED TAXES
 
T-0
T-1
T-2
T-3
T-4
T-5
T-6
T-7
T-8
T-9
T-10
Fed. LT Capital Gains Tax @ 15.00%
  
-6,450
2,356
11,427
20,770
30,393
40,305
50,514
61,029
71,860
83,016
State Capital Gains Tax @ 6.85%
  
-2,945
1,076
5,218
9,485
13,880
18,406
23,068
27,870
32,816
37,911
Fed. Depr. Recapture @ 25.00%
  
9,494
18,987
28,481
37,975
47,468
56,962
66,456
75,949
85,443
94,937
State Depr. Recapture @ 6.85%
  
2,601
5,203
7,804
10,405
13,006
15,608
18,209
20,810
23,411
26,013
Total Estimated Deferred Tax Liab.
Before Adj. For Any Loss Carryforward
  
2,700
27,622
52,930
78,635
104,747
131,281
158,247
185,658
213,530
241,877
Loss Carryforward
  
-42,350
-80,957
-115,671
-146,334
-172,783
-194,847
-212,347
-225,094
-232,893
-235,537
Estimated Offset To Tax Liab. Due To
Loss Carryforward @ (15.00% + 6.85%)
  
-9,253
-17,689
-25,274
-31,974
-37,753
-42,574
-46,398
-49,183
-50,887
-51,465
Total Estimated Deferred Tax Liab.
  
-6,553
9,933
27,656
46,661
66,994
88,707
111,849
136,475
162,643
190,412

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

Analytical Finances, Inc. Contents © 2005 - 2007