|
Re:
|
America First Tax Exempt Investors, L.P.
|
|
Form 10-K for the fiscal year ended December 31, 2008
|
|
Filed March 4, 2009
|
|
Form 10-Q for the Quarterly Period Ended September 30, 2009
|
|
Filed November 6, 2009
|
|
File No. 000-24843
|
|
September 30, 2009 Form 10-Q
|
|
4. Investments in Tax-Exempt Bonds, page 11
|
DCF Model - Property Valuation
|
Mortgage Bond Principal
|
Difference
|
Valuation as % of Bond Principal
|
||
Woodland Park
|
$15,700,000
|
$15,662,000
|
$38,000
|
100%
|
|
Gardens of Decordova
|
$5,300,000
|
$4,853,000
|
$447,000
|
109%
|
|
Gardens of Weatherford
|
$5,300,000
|
$4,686,000
|
$614,000
|
113%
|
|
Totals
|
$26,300,000
|
$25,201,000
|
$1,099,000
|
104%
|
DCF Model - Property Valuation
|
Mortgage Bond Principal
|
Remaining Value
|
Taxable Loan Balance
|
Loan Loss Allowance Needed? Yes/No
|
||
Woodland Park
|
$15,700,000
|
$15,662,000
|
$38,000
|
$700,000
|
YES
|
|
Gardens of Decordova
|
$5,300,000
|
$4,853,000
|
$447,000
|
$315,000
|
No
|
|
Gardens of Weatherford
|
$5,300,000
|
$4,686,000
|
$614,000
|
$335,000
|
No
|
|
Totals
|
$26,300,000
|
$25,201,000
|
$1,099,000
|
1.
|
Cost Approach – This approach considers the current cost to reproduce the property. In the cost approach to value, the subject property is valued based upon the market value of the land (as if vacant) to which is added the depreciated reproduction cost of the buildings and site improvements.
|
2.
|
Sales Comparison Approach – This approach estimates value by comparing the subject property to the sales of similar properties. This approach gives consideration to actual sales in the current real estate market of other similar properties as adjusted for differences between the specific properties such as quality, location, size, services and markets.
|
3.
|
Income Capitalization Approach – More specifically, the Direct Capitalization Approach was utilized in the appraisals. This approach consists of several steps which results in the estimation of net operating income of the subject property to which is applied an appropriate capitalization rate to arrive at a valuation. In arriving at the estimation of net operating income the appraiser assumed both restricted rent schedules and market rate rent schedules.
|
·
|
Woodland Park – February 10, 2010
|
·
|
The Gardens of DeCordova – February 16, 2010
|
·
|
The Gardens of Weatherford – January 1, 2011.
|
·
|
Woodland Park – March 1, 2011
|
·
|
The Gardens of DeCordova – February 1, 2011
|
·
|
The Gardens of Weatherford – January 1, 2013.
|
1.
|
“As is” – Restricted Rent Schedule
|
2.
|
“As stabilized” – Restricted Rent Schedule
|
3.
|
“As is” - Market Rent Schedule
|
4.
|
“As stabilized” – Market Rent Schedule.
|
All Amounts in Thousands
|
|||
Appraisal Method
|
|||
Woodland Park
|
As Stabilized
|
||
Restricted Rents
|
Market Rents
|
||
Cost Approach
|
$ 16,700
|
$ 16,700
|
|
Sales Comparison Approach
|
$ 15,100
|
$ 16,400
|
|
Income Capitalization Approach
|
$ 15,400
|
$ 16,500
|
|
(FINAL APPRAISED VALUES)
|
|||
FINAL APPRAISED VALUE
|
$ 15,400
|
$ 16,500
|
|
Internal Valuation
|
$ 15,700
|
$ 15,700
|
|
Variance
|
$ (300)
|
$ 800
|
|
Weighted Average of Final Appraised "As Stabilized Value"
|
|||
weighted to 75% restricted rents, 25% market rents
|
|||
Internal Valuation
|
$ 15,700
|
||
Variance
|
$ (25)
|
||
1.
|
Time period of the model – Our model is a ten year DCF model with an assumed sale at the end of year ten. We evaluated several discount rates to be used in the model as part of a sensitivity analysis and selected a rate of 7%. We believe the selected rate is appropriate and the DCF model reflects the view of a “market participant” with a long term investment strategy similar to the strategy the Company has in the bonds. The appraisal model is effectively a one year model in that it estimates one year of income and determines a value, or sales price, from that one year of estimated operations.
|
2.
|
Capitalization rate utilized by the model – Each model utilizes a capitalization rate applied to operating income to estimate a value or sale price. In our model we evaluated several capitalization rates as part of a sensitivity analysis before selecting a capitalization rate for our model. We believe the selected rate is appropriate and reflects a potential sales price for a market participant with a long term investment strategy (similar to the Company). The capitalization rate utilized in our internal model is 7% as compared to 7.25% used in the appraisal model. Applying a 7% capitalization rate to the appraisal model would result in the following “as stabilized” valuations:
|
·
|
“as stabilized” – restricted rents valuation of $15.9 million
|
·
|
“as stabilized” – market rents valuation of $17.1 million.
|
1.
|
The weighted average of the “as stabilized” valuation - $15.7 million. This average better reflects the current business plan for the property, and
|
2.
|
The “as stabilized” market rent valuation- $16.5 million. This represents the expected value of the property if the Company were to foreclose and sell the property in order to recover its investment.
|
All Amounts in Thousands
|
|||
Appraisal Method
|
|||
The Gardens of Decordova
|
As Stabilized
|
||
Restricted Rents
|
Market Rents
|
||
Cost Approach
|
$ 7,710
|
$ 7,710
|
|
Sales Comparison Approach
|
$ 4,180
|
$ 6,840
|
|
Income Capitalization Approach
|
$ 3,830
|
$ 7,340
|
|
(FINAL APPRAISED VALUES)
|
|||
FINAL APPRAISED VALUE
|
$ 3,830
|
$ 7,340
|
|
Internal Valuation
|
$ 5,300
|
$ 5,300
|
|
Variance
|
$ (1,470)
|
$ 2,040
|
|
Weighted Average of Final Appraised "As Stabilized Value"
|
|||
weighted to 75% restricted rents, 25% market rents
|
|||
Internal Valuation
|
$ 5,300
|
||
Variance
|
$ (593)
|
||
1.
|
Time period of the model – Our model is a ten year DCF model with an assumed sale at the end of year ten. We evaluated several discount rates to be used in the model as part of a sensitivity analysis and selected a rate of 7%. We believe the selected rate is appropriate and the DCF model reflects the view of a “market participant” with a long term investment strategy similar to the strategy the Company has in the bonds. The appraisal model is effectively a one year model in that it estimates one year of income and determines a value, or sales price, from that one year of estimated operations.
|
2.
|
Capitalization rate utilized by the model – Each model utilizes a capitalization rate applied to operating income to estimate a value or sale price. In our model we evaluated several capitalization rates as part of a sensitivity analysis before selecting a capitalization rate for our model. We believe the selected rate is appropriate and reflects a potential sales price for a market participant with a long term investment strategy (similar to the Company). The capitalization rate utilized in our internal model is 7% as compared to 7.5% used in the appraisal model. Applying a 7% capitalization rate to the appraisal model would result in the following “as stabilized” valuations:
|
·
|
“as stabilized” – restricted rents valuation of $4.1 million
|
·
|
“as stabilized” – market rents valuation of $7.8 million.
|
3.
|
Occupancy rate at stabilization – As our model is a ten year model, we assume occupancy rates that change over the periods in the model. For DeCordova we assume stabilization in 2011 at 85% occupancy. Additionally, the occupancy assumptions in our model never exceed 93%. The appraisal assumes stabilized occupancy in 2011 at 95%.
|
4.
|
Real estate taxes – The Gardens of DeCordova general partner is a non-profit organization who has applied to the State of Texas for property tax relief which will reduce this expense item for the property beginning in 2010. The appraisal estimated real estate tax expenses in their models using the full tax assessment from 2009 thus resulting in a lower income estimate for the property and a lower valuation. Our model takes into account the expected reduction in real estate tax expense.
|
1.
|
The weighted average of the “as stabilized” valuation - $4.7 million. This average better reflects the current business plan for the property.
|
2.
|
The “as stabilized” market rent valuation- $7.3 million. This represents the expected value of the property if the Company were to foreclose and sell the property in order to recover its investment.
|
All Amounts in Thousands
|
|||
Appraisal Method
|
|||
The Gardens of Weatherford
|
As Stabilized
|
||
Restricted Rents
|
Market Rents
|
||
Cost Approach
|
$ 7,850
|
$ 7,850
|
|
Sales Comparison Approach
|
$ 4,010
|
$ 7,570
|
|
Income Capitalization Approach
|
$ 3,770
|
$ 7,280
|
|
(FINAL APPRAISED VALUES)
|
|||
FINAL APPRAISED VALUE
|
$ 3,770
|
$ 7,280
|
|
Internal Valuation
|
$ 5,300
|
$ 5,300
|
|
Variance
|
$ (1,530)
|
$ 1,980
|
|
Weighted Average of Final Appraised "As Stabilized Value"
|
|||
weighted to 75% restricted rents, 25% market rents
|
|||
Internal Valuation
|
$ 5,300
|
||
Variance
|
$ (653)
|
||
1.
|
Time period of the model – Our model is a ten year DCF model with an assumed sale at the end of year ten. We evaluated several discount rates to be used in the model as part of a sensitivity analysis and selected a rate of 7%. We believe the selected rate is appropriate and the DCF model reflects the view of a “market participant” with a long term investment strategy similar to the strategy the Company has in the bonds. The appraisal model is effectively a one year model in that it estimates one year of income and determines a value, or sales price, from that one year of estimated operations.
|
2.
|
Capitalization rate utilized by the model – Each model utilizes a capitalization rate applied to operating income to estimate a value or sale price. In our model we evaluated several capitalization rates as part of a sensitivity analysis before selecting a capitalization rate for our model. We believe the selected rate is appropriate and reflects a potential sales price for a market participant with a long term investment strategy (similar to the Company). The capitalization rate utilized in our internal model is 7% as compared to 7.5% used in the appraisal model. Applying a 7% capitalization rate to the appraisal model would result in the following “as stabilized” valuations:
|
a.
|
“as stabilized” – restricted rents valuation of $4.0 million
|
b.
|
“as stabilized” – market rents valuation of $7.8 million.
|
3.
|
Occupancy rate at stabilization – As our model is a ten year model, we assume occupancy rates that change over the periods in the model. For Weatherford we assume stabilization in 2013 at 80% occupancy. Additionally, the occupancy assumptions in our model never exceed 93%. The appraisal assumes stabilized occupancy in 2013 at 95%.
|
4.
|
Real estate taxes – The Gardens of Weatherford general partner is a non-profit organization who has applied to the State of Texas for property tax relief which will reduce this expense item for the property beginning in 2010. The appraisal estimated real estate tax expenses in their models using the full tax assessment thus resulting in a lower income estimate for the property and a lower valuation. Our model takes into account the expected reduction in real estate tax expense.
|
1.
|
The weighted average of the “as stabilized” valuation - $4.65 million. This average better reflects the current business plan for the property, and
|
2.
|
The “as stabilized” market rent valuation- $7.3 million. This represents the expected value of the property if the Company were to foreclose and sell the property in order to recover its investment.
|
Woodland Park
|
Cap Rate:
|
7.00%
|
Units:
|
236
|
|||||||
Projected Budget
|
Discount Rate:
|
7.00%
|
Mgt Fee:
|
4.00%
|
|||||||
FMV of Loan if Applicable
|
|||||||||||
Survey Location:
|
Topeka, KS
|
RR per Unit:
|
$200
|
||||||||
Assumptions:
|
|||||||||||
Income Increases
|
ACTUAL
|
BUDGET
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
Effective Rent %
|
29.1%
|
68.0%
|
89.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
Expense Increases
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2009
|
2010
|
2011
|
2012
|
2013
|
2014
|
2015
|
2016
|
2017
|
2018
|
2019
|
|
Gross Potential Income
|
1,873,920
|
1,911,398
|
1,949,626
|
1,988,619
|
2,028,391
|
2,068,959
|
2,110,338
|
2,152,545
|
2,195,596
|
2,239,508
|
2,284,298
|
Economic Rent
|
544,791
|
1,299,364
|
1,735,167
|
1,849,416
|
1,886,404
|
1,924,132
|
1,962,615
|
2,001,867
|
2,041,904
|
2,082,742
|
2,124,397
|
Other Income
|
34,683
|
43,020
|
43,880
|
44,758
|
45,653
|
46,566
|
47,498
|
48,448
|
49,416
|
50,405
|
51,413
|
Total Income
|
579,474
|
1,342,384
|
1,779,048
|
1,894,174
|
1,932,057
|
1,970,698
|
2,010,112
|
2,050,314
|
2,091,321
|
2,133,147
|
2,175,810
|
Taxes
|
49,716
|
210,836
|
216,107
|
221,510
|
227,047
|
232,723
|
238,542
|
244,505
|
250,618
|
256,883
|
263,305
|
Insurance
|
29,911
|
45,192
|
46,322
|
47,480
|
48,667
|
49,884
|
51,131
|
52,409
|
53,719
|
55,062
|
56,439
|
Replacement Reserve
|
47,200
|
47,200
|
47,200
|
47,200
|
47,200
|
47,200
|
47,200
|
47,200
|
47,200
|
47,200
|
|
Labor & Benefits
|
166,079
|
177,802
|
182,247
|
186,803
|
191,473
|
196,260
|
201,167
|
206,196
|
211,351
|
216,634
|
222,050
|
Utilities
|
88,246
|
97,404
|
99,839
|
102,335
|
104,893
|
107,516
|
110,204
|
112,959
|
115,783
|
118,677
|
121,644
|
Repairs & Maintenance
|
54,799
|
91,980
|
94,280
|
96,636
|
99,052
|
101,529
|
104,067
|
106,669
|
109,335
|
112,069
|
114,870
|
Administrative
|
40,710
|
35,383
|
36,268
|
37,174
|
38,104
|
39,056
|
40,033
|
41,033
|
42,059
|
43,111
|
44,189
|
Advertising
|
65,765
|
32,484
|
33,296
|
34,129
|
34,982
|
35,856
|
36,753
|
37,671
|
38,613
|
39,579
|
40,568
|
Management Fee
|
36,000
|
53,695
|
55,037
|
56,413
|
57,824
|
59,269
|
60,751
|
62,270
|
63,826
|
65,422
|
67,058
|
Capital expenditures
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Total Operating Expense
|
531,226
|
791,976
|
810,595
|
829,680
|
849,242
|
869,293
|
889,846
|
910,912
|
932,505
|
954,637
|
977,323
|
Net Operating Income
|
48,248
|
550,408
|
968,452
|
1,064,493
|
1,082,815
|
1,101,405
|
1,120,266
|
1,139,403
|
1,158,816
|
1,178,510
|
1,198,487
|
Valuation:
|
|||||||||||
Net Operating Income
|
48,248
|
550,408
|
968,452
|
1,064,493
|
1,082,815
|
1,101,405
|
1,120,266
|
1,139,403
|
1,158,816
|
1,178,510
|
1,198,487
|
Cap Rate
|
7.00%
|
||||||||||
Sales Proceeds
|
17,121,241
|
||||||||||
3% Selling Cost
|
513,637
|
||||||||||
Net Sales Proceeds
|
16,607,604
|
||||||||||
Total Cash Flow
|
48,248
|
550,408
|
968,452
|
1,064,493
|
1,082,815
|
1,101,405
|
1,120,266
|
1,139,403
|
1,158,816
|
1,178,510
|
17,806,091
|
USE
|
|||||||||||
NPV Of Cash Flows
|
15,663,818
|
15,700,000
|
|||||||||
Mortgage Amount
|
15,662,000
|
||||||||||
NPV As A % Of Mortgage
|
100.01%
|
Gardens of Decordova
|
Cap Rate:
|
7.00%
|
Units:
|
76
|
|||||||
Discount Rate:
|
7.00%
|
Mgt Fee:
|
5.00%
|
||||||||
FMV of Loan if Applicable
|
|||||||||||
Survey Location:
|
Granbury, TX
|
RR per Unit:
|
$300
|
||||||||
Assumptions:
|
|||||||||||
Income Increases
|
Actual
|
Budget
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
Effective Rent %
|
23.5%
|
65.0%
|
85.0%
|
90.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
Expense Increases
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2009
|
2010
|
2011
|
2012
|
2013
|
2014
|
2015
|
2016
|
2017
|
2018
|
2019
|
|
Gross Potential Income
|
624,498
|
624,864
|
637,361
|
650,109
|
663,111
|
676,373
|
689,900
|
703,698
|
717,772
|
732,128
|
746,770
|
Economic Rent
|
146,827
|
458,508
|
541,757
|
585,098
|
616,693
|
629,027
|
641,607
|
654,439
|
667,528
|
680,879
|
694,496
|
Other Income
|
8,791
|
33,864
|
33,864
|
33,864
|
33,864
|
33,864
|
33,864
|
33,864
|
33,864
|
33,864
|
33,864
|
Total Income
|
155,618
|
492,372
|
575,621
|
618,962
|
650,557
|
662,891
|
675,471
|
688,303
|
701,392
|
714,743
|
728,360
|
Taxes
|
84,337
|
106,000
|
31,800
|
32,595
|
33,410
|
34,245
|
35,101
|
35,979
|
36,878
|
37,800
|
38,745
|
Insurance
|
16,450
|
19,960
|
20,459
|
20,970
|
21,495
|
22,032
|
22,583
|
23,147
|
23,726
|
24,319
|
24,927
|
Replacement Reserve
|
22,800
|
22,800
|
22,800
|
22,800
|
22,800
|
22,800
|
22,800
|
22,800
|
22,800
|
22,800
|
|
Labor & Benefits
|
53,897
|
51,470
|
52,757
|
54,076
|
55,428
|
56,813
|
58,234
|
59,689
|
61,182
|
62,711
|
64,279
|
Utilities
|
14,354
|
15,900
|
16,298
|
16,705
|
17,123
|
17,551
|
17,989
|
18,439
|
18,900
|
19,373
|
19,857
|
Repairs & Maintenance
|
24,571
|
24,666
|
25,283
|
25,915
|
26,563
|
27,227
|
27,907
|
28,605
|
29,320
|
30,053
|
30,804
|
Administrative
|
26,878
|
34,750
|
35,619
|
36,509
|
37,422
|
38,357
|
39,316
|
40,299
|
41,307
|
42,340
|
43,398
|
Advertising
|
44,040
|
27,528
|
28,216
|
28,922
|
29,645
|
30,386
|
31,145
|
31,924
|
32,722
|
33,540
|
34,379
|
Management Fee
|
22,774
|
24,619
|
28,781
|
30,948
|
32,528
|
33,145
|
33,774
|
34,415
|
35,070
|
35,737
|
36,418
|
Capital expenditures
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
Total Operating Expense
|
287,301
|
327,693
|
262,012
|
269,440
|
276,412
|
282,556
|
288,850
|
295,298
|
301,905
|
308,673
|
315,608
|
Net Operating Income
|
(131,683)
|
164,679
|
313,609
|
349,522
|
374,145
|
380,335
|
386,621
|
393,005
|
399,487
|
406,070
|
412,753
|
Valuation:
|
|||||||||||
Net Operating Income
|
(131,683)
|
164,679
|
313,609
|
349,522
|
374,145
|
380,335
|
386,621
|
393,005
|
399,487
|
406,070
|
412,753
|
Cap Rate
|
7.00%
|
||||||||||
Sales Proceeds
|
5,896,469
|
||||||||||
3% Selling Cost
|
176,894
|
||||||||||
Net Sales Proceeds
|
5,719,575
|
||||||||||
Total Cash Flow
|
(131,683)
|
164,679
|
313,609
|
349,522
|
374,145
|
380,335
|
386,621
|
393,005
|
399,487
|
406,070
|
6,132,328
|
USE
|
|||||||||||
NPV Of Cash Flows
|
5,342,856
|
5,300,000
|
|||||||||
Mortgage Amount
|
4,853,000
|
||||||||||
NPV As A % Of Mortgage
|
110.09%
|
Gardens of Weatherford
|
|
Cap Rate:
|
7.00%
|
Units:
|
76
|
|||||
Projected Budget
|
Discount Rate:
|
7.00%
|
Mgt Fee:
|
5.00%
|
||||||
FMV of Loan if Applicable
|
||||||||||
Survey Location:
|
Weatherford, TX
|
RR per Unit:
|
$350
|
|||||||
Assumptions:
|
||||||||||
Income Increases
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
2.00%
|
||
Effective Rent %
|
40.0%
|
60.0%
|
80.0%
|
85.0%
|
90.0%
|
93.0%
|
93.0%
|
93.0%
|
93.0%
|
|
Expense Increases
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
2.50%
|
|
2010
|
2011
|
2012
|
2013
|
2014
|
2015
|
2016
|
2017
|
2018
|
2019
|
|
Gross Potential Income
|
688,000
|
701,760
|
715,795
|
730,111
|
744,713
|
759,608
|
774,800
|
790,296
|
806,102
|
|
Economic Rent
|
275,200
|
421,056
|
572,636
|
620,594
|
670,242
|
706,435
|
720,564
|
734,975
|
749,675
|
|
Other Income
|
20,520
|
20,930
|
21,349
|
21,776
|
22,212
|
22,656
|
23,109
|
23,571
|
24,042
|
|
Total Income
|
0
|
295,720
|
441,986
|
593,985
|
642,370
|
692,454
|
729,091
|
743,673
|
758,546
|
773,717
|
Taxes
|
37,600
|
38,540
|
39,504
|
40,491
|
41,503
|
42,541
|
43,604
|
44,695
|
45,812
|
|
Insurance
|
26,492
|
27,154
|
27,833
|
28,529
|
29,242
|
29,973
|
30,723
|
31,491
|
32,278
|
|
Replacement Reserve
|
26,600
|
26,600
|
26,600
|
26,600
|
26,600
|
26,600
|
26,600
|
26,600
|
26,600
|
|
Labor & Benefits
|
50,735
|
52,003
|
53,303
|
54,636
|
56,002
|
57,402
|
58,837
|
60,308
|
61,816
|
|
Utilities
|
18,520
|
18,983
|
19,458
|
19,944
|
20,443
|
20,954
|
21,478
|
22,014
|
22,565
|
|
Repairs & Maintenance
|
27,200
|
27,880
|
28,577
|
29,291
|
30,024
|
30,774
|
31,544
|
32,332
|
33,141
|
|
Administrative
|
23,850
|
24,446
|
25,057
|
25,684
|
26,326
|
26,984
|
27,659
|
28,350
|
29,059
|
|
Advertising
|
11,100
|
11,378
|
11,662
|
11,953
|
12,252
|
12,559
|
12,873
|
13,194
|
13,524
|
|
Management Fee
|
14,786
|
22,099
|
29,699
|
32,119
|
34,623
|
36,455
|
37,184
|
37,927
|
38,686
|
|
Capital expenditures
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
||
Total Operating Expense
|
0
|
236,883
|
249,084
|
261,693
|
269,247
|
277,015
|
284,241
|
290,500
|
296,912
|
303,480
|
Net Operating Income
|
0
|
58,837
|
192,903
|
332,292
|
373,123
|
415,439
|
444,849
|
453,172
|
461,634
|
470,237
|
Valuation:
|
||||||||||
Net Operating Income
|
0
|
58,837
|
192,903
|
332,292
|
373,123
|
415,439
|
444,849
|
453,172
|
461,634
|
470,237
|
Cap Rate
|
7.00%
|
|||||||||
Sales Proceeds
|
6,717,672
|
|||||||||
3% Selling Cost
|
201,530
|
|||||||||
Net Sales Proceeds
|
6,516,142
|
|||||||||
Total Cash Flow
|
0
|
58,837
|
192,903
|
332,292
|
373,123
|
415,439
|
444,849
|
453,172
|
461,634
|
6,986,379
|
USE
|
||||||||||
NPV Of Cash Flows
|
5,348,616
|
5,300,000
|
||||||||
Mortgage Amount
|
4,686,000
|
|||||||||
NPV As A % Of Mortgage
|
114.14%
|