|
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
| |
Yr. 1 |
Yr. 2 |
Yr. 3 |
Yr. 4 |
Yr. 5 |
Yr. 6 |
Yr. 7 |
Yr. 8 |
Yr. 9 |
Yr. 10 |
| |
2003 |
2004 |
2005 |
2006 |
2007 |
2008 |
2009 |
2010 |
2011 |
2012 |
|
|
|
|
|
| RESALE ANALYSIS |
|
|
|
|
|
|
|
|
| Projected Real Estate Resale Value |
|
|
|
|
Calculated
using Cap Rate of 11% |
1,308,327 |
1,723,182 |
1,809,336 |
1,899,818 |
1,994,791 |
2,094,545 |
2,199,273 |
2,309,236 |
2,424,691 |
2,545,918 |
|
|
|
|
| Original
Basis -- Real Estate Purchase |
1,800,000 |
1,800,000 |
1,800,000 |
1,800,000 |
1,800,000 |
1,800,000 |
1,800,000 |
1,800,000 |
1,800,000 |
1,800,000 |
|
|
|
| + |
Closing Costs |
36,000 |
36,000 |
36,000 |
36,000 |
36,000 |
36,000 |
36,000 |
36,000 |
36,000 |
36,000 |
| + |
Other Fees |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
| + |
Capital and Tenant Improvements |
200,000 |
200,000 |
200,000 |
200,000 |
200,000 |
200,000 |
200,000 |
200,000 |
200,000 |
200,000 |
| + |
Cost
of Sale (7% of Resale Value) |
91,583 |
120,623 |
126,654 |
132,987 |
139,635 |
146,618 |
153,949 |
161,647 |
169,728 |
178,214 |
| - |
Accumulated Depreciation, Building |
52,500 |
112,500 |
172,500 |
232,500 |
292,500 |
352,500 |
412,500 |
472,500 |
532,500 |
592,500 |
| - |
Accumulated Depreciation, Land Improvement |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
| - |
Accumulated Depreciation, Capital Improvements |
5,152 |
12,425 |
19,698 |
26,971 |
34,244 |
41,517 |
48,790 |
56,063 |
63,336 |
70,609 |
|
|
|
| Adjusted Basis at Sales Date |
2,069,931 |
2,031,698 |
1,970,456 |
1,909,516 |
1,848,891 |
1,788,601 |
1,728,659 |
1,669,084 |
1,609,892 |
1,551,105 |
|
|
|
| Gain or (Loss) on Real Estate Transaction |
(761,604) |
(308,516) |
(161,120) |
(9,698) |
145,900 |
305,944 |
470,614 |
640,152 |
814,799 |
994,813 |
|
|
|
| + |
Projected Personal Property Resale Value |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Original Basis -- Personal Property Purchase |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Accumulated Depreciation, Personal Property |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
| - |
Book Value, Personal Property |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
| Gain or (Loss) on Personal Property
Transaction |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
Suspended Losses Utilized on Sale |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Unamoritized Fees |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Unamoritized Loan Points, Loan 1 |
27,480 |
26,040 |
- |
- |
- |
- |
- |
- |
- |
- |
|
Unamoritized Loan Points, Loan 2 |
4,087 |
3,091 |
- |
- |
- |
- |
- |
- |
- |
- |
|
Unamoritized Loan Points, Loan 3 |
- |
- |
39,889 |
38,557 |
37,225 |
35,893 |
34,561 |
33,229 |
31,897 |
30,565 |
|
Unamoritized Loan Points, Loan 4 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Unamoritized Loan Points, Loan 5 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
| Total Tax Deductions on Real Estate
Transaction |
31,567 |
29,131 |
39,889 |
38,557 |
37,225 |
35,893 |
34,561 |
33,229 |
31,897 |
30,565 |
|
|
|
| Calculation of Federal Tax on Resale |
|
|
Pers.
Prop. Capital Gains at ordinary rate of 21% |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
Real Estate Capital Gains Tax |
- |
- |
- |
- |
27,169 |
67,513 |
109,013 |
146,246 |
182,631 |
219,982 |
|
|
|
| Total Estimated Federal Tax on Resale |
- |
- |
- |
- |
27,169 |
67,513 |
109,013 |
146,246 |
182,631 |
219,982 |
|
|
|
| Projected Resale Value, Real & Personal
Property |
1,308,327 |
1,723,182 |
1,809,336 |
1,899,818 |
1,994,791 |
2,094,545 |
2,199,273 |
2,309,236 |
2,424,691 |
2,545,918 |
| - |
Cost of Sale |
91,583 |
120,623 |
126,654 |
132,987 |
139,635 |
146,618 |
153,949 |
161,647 |
169,728 |
178,214 |
| - |
Payoff, Loan 1 |
1,410,478 |
1,375,878 |
1,341,808 |
- |
- |
- |
- |
- |
- |
- |
| - |
Payoff, Loan 2 |
250,000 |
250,000 |
250,000 |
- |
- |
- |
- |
- |
- |
- |
| - |
Payoff, Loan 3 |
- |
- |
1,998,658 |
1,981,843 |
1,963,633 |
1,943,911 |
1,922,552 |
1,899,420 |
1,874,368 |
1,847,237 |
| - |
Payoff, Loan 4 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
| - |
Payoff, Loan 5 |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
| + |
Remaining Cash Reserve w/ Interest Earned |
74,118 |
77,824 |
81,715 |
85,801 |
90,091 |
94,596 |
99,326 |
104,292 |
109,507 |
114,982 |
| + |
Adjust Total Loan Payoff for Refinancing |
- |
- |
1,591,808 |
- |
- |
- |
- |
- |
- |
- |
|
|
|
| Resale Proceeds before Taxes |
(369,616) |
54,505 |
(234,261) |
(129,211) |
(18,386) |
98,612 |
222,098 |
352,461 |
490,102 |
635,449 |
| - |
Estimated Federal Tax on Resale |
- |
- |
- |
- |
27,169 |
67,513 |
109,013 |
146,246 |
182,631 |
219,982 |
|
|
|
| Resale Proceeds after Taxes |
(369,616) |
54,505 |
(234,261) |
(129,211) |
(45,554) |
31,100 |
113,085 |
206,216 |
307,471 |
415,467 |
|
|
|
|
|
|
| MEASURES OF INVESTMENT PERFORMANCE |
|
|
|
|
|
Initial Cash Investment |
(454,800) |
(454,800) |
(454,800) |
(454,800) |
(454,800) |
(454,800) |
(454,800) |
(454,800) |
(454,800) |
(454,800) |
|
PreTax Cash Flow |
- |
31,544 |
408,199 |
36,966 |
47,617 |
58,805 |
70,550 |
82,882 |
95,831 |
109,426 |
|
PreTax Cash Flow + Resale Proceed |
(369,616) |
86,049 |
173,938 |
(92,245) |
29,231 |
157,417 |
292,648 |
435,343 |
585,933 |
744,875 |
| IRR on PreTax Cash Flow & Resale |
#NUM! |
#NUM! |
-24.23% |
-9.74% |
3.47% |
11.40% |
16.06% |
18.88% |
20.65% |
21.78% |
| MIRR
on PreTax Cash Flow & Resale (PV at 5%) |
-100.00% |
-56.50% |
-23.07% |
-3.02% |
4.05% |
8.91% |
11.69% |
13.33% |
14.31% |
14.88% |
|
After Tax Cash Flow |
- |
31,544 |
408,199 |
36,966 |
47,617 |
56,721 |
65,656 |
75,026 |
84,853 |
95,156 |
|
After Tax Cash Flow + Resale Proceed |
(369,616) |
86,049 |
173,938 |
(92,245) |
2,063 |
87,821 |
178,741 |
281,242 |
392,324 |
510,623 |
| IRR on After Tax Cash Flow & Resale |
#NUM! |
#NUM! |
-24.23% |
-9.74% |
1.72% |
8.76% |
13.29% |
16.32% |
18.34% |
19.69% |
| MIRR
on After Tax Cash Flow & Resale (PV at 5%) |
-100.00% |
-56.50% |
-23.07% |
-3.02% |
3.01% |
7.18% |
9.71% |
11.37% |
12.43% |
13.11% |
|
|
|
|
|
|
|
|
| INVESTMENT RATIOS |
|
|
|
|
|
|
|
Debt Coverage |
0.97 |
1.17 |
1.22 |
1.19 |
1.25 |
1.31 |
1.37 |
1.44 |
1.51 |
1.59 |
|
Cap Rate % |
7.20% |
9.44% |
9.87% |
10.32% |
10.79% |
11.28% |
11.80% |
12.34% |
12.90% |
13.49% |
|
Cash on Cash % |
-0.19% |
6.94% |
89.75% |
8.13% |
10.47% |
12.93% |
15.51% |
18.22% |
21.07% |
24.06% |
|
Oper. Exp Ratio % |
34.62% |
31.61% |
31.61% |
31.61% |
31.61% |
31.61% |
31.61% |
31.61% |
31.61% |
31.61% |
|
|
|
|
|
|
| SUMMARY INFORMATION |
|
|
|
|
|
Projected Total Cash Return |
(369,616) |
86,049 |
205,482 |
347,498 |
505,940 |
681,743 |
875,779 |
1,089,024 |
1,322,496 |
1,577,269 |
|
Total Estimated Taxes |
- |
- |
- |
- |
27,169 |
69,597 |
115,991 |
161,080 |
208,443 |
260,064 |
|
Projected After Tax Return |
(369,616) |
86,049 |
205,482 |
347,498 |
478,772 |
612,147 |
759,788 |
927,945 |
1,114,053 |
1,317,205 |
|
Taxfree
Return at 5% (for comparison) |
476,085 |
500,442 |
526,046 |
552,959 |
581,250 |
610,987 |
642,247 |
675,105 |
709,645 |
745,952 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|