| ( bty )( aty ) |
0% |
10% |
12% |
15% |
18% |
20% |
25% |
| Developer( ****)( ) |
|
|
|
|
|
|
|
| Start-up Oper. Losses (exp.) ( 1 167) |
-1212488 |
-987318 |
-949833 |
-897468 |
-849300 |
-819301 |
-750883 |
| Equity Residual ( 1 196) |
57,362,703 |
7,751,455 |
5,309,470 |
3,047,719 |
1,774,629 |
1,246,877 |
529078 |
| Investment Adj. ( 1 320) |
-1920876 |
-673255 |
-552206 |
-412879 |
-311026 |
-258527 |
-165002 |
| Refinancing Net Proceeds ( 1 330) |
24,648,285 |
8,639,074 |
7,085,793 |
5,297,982 |
3,991,027 |
3,317,363 |
2,117,272 |
| Net Cash Flow (NCF) ( 1 699) |
25,416,797 |
6,854,044 |
5,490,409 |
4,017,304 |
3,002,708 |
2,498,326 |
1,624,047 |
| Subtotal: Developer( ****)( ) |
104,294,422 |
21,583,999 |
16,383,632 |
11,052,658 |
7,608,037 |
5,984,737 |
3,354,511 |
| |
|
|
|
|
|
|
|
| Lender ( ****)( ) |
|
|
|
|
|
|
|
| Orig.Mtge(s) ( 2 240) |
-41400000 |
-37636364 |
-36964286 |
-36000000 |
-35084746 |
-34500000 |
-33120000 |
| Mtge Interest ( 2 660) |
42,600,223 |
23,884,644 |
21,585,094 |
18,690,107 |
16,324,888 |
14,983,625 |
12,265,619 |
| Mtge Amortization ( 2 670) |
2,019,076 |
1,039,562 |
924637 |
782409 |
668584 |
605139 |
479449 |
| Mtge Amortization ( 2 670) |
|
|
|
|
|
|
|
| Mortgage Balloon Payment ( 2 678) |
39,380,924 |
13,802,774 |
11,321,075 |
8,464,663 |
6,376,521 |
5,300,199 |
3,382,796 |
| Subtotal: Lender ( ****)( ) |
42,600,223 |
1,090,617 |
-3133480 |
-8062821 |
-11714752 |
-13611037 |
-16992136 |
| |
|
|
|
|
|
|
|
| Investor ( ****)( ) |
|
|
|
|
|
|
|
| Land ( 3 132) |
-13788750 |
-12535227 |
-12311384 |
-11990217 |
-11685381 |
-11490625 |
-11031000 |
| Land Residual ( 3 195) |
46,074,152 |
6,226,026 |
4,264,606 |
2,447,951 |
1,425,395 |
1,001,501 |
424959 |
| Equity Residual ( 3 196) |
19,120,901 |
2,583,818 |
1,769,823 |
1,015,906 |
591543 |
415626 |
176359 |
| Ground Rent ( 3 631) |
27,577,500 |
10,671,946 |
9,195,919 |
7,505,075 |
6,254,888 |
5,595,451 |
4,361,528 |
| Participation ( 3 682) |
9,035,291 |
3,233,200 |
2,743,270 |
2,189,488 |
1,786,908 |
1,577,638 |
1,193,534 |
| Participation ( 3 682) |
1,727,034 |
348667 |
259450 |
168837 |
111590 |
85363 |
44867 |
| Participation ( 3 682) |
2,303,231 |
371707 |
264018 |
160101 |
98532 |
71851 |
33483 |
| Participation Variance ( 3 683) |
-1045163 |
-491703 |
-429084 |
-352576 |
-292296 |
-259141 |
-194647 |
| Subtotal: Investor ( ****)( ) |
91,004,196 |
10,408,436 |
5,756,618 |
1,144,565 |
-1708822 |
-3002337 |
-4990916 |
| |
|
|
|
|
|
|
|
| Other ( ****)( ) |
|
|
|
|
|
|
|
| Financing Fees ( 4 158) |
|
|
|
|
|
|
|
| Financing Fees ( 4 158) |
1,920,876 |
673255 |
552206 |
412879 |
311026 |
258527 |
165002 |
| Refinancing Proceeds (gross) ( 4 248) |
-64029210 |
-22441847 |
-18406868 |
-13762645 |
-10367548 |
-8617562 |
-5500067 |
| Mtge Interest ( 4 660) |
75,739,463 |
16,355,270 |
12,341,273 |
8,201,750 |
5,536,019 |
4,294,430 |
2,336,352 |
| Mtge Amortization ( 4 670) |
2,290,357 |
449492 |
333143 |
215719 |
142040 |
108452 |
56853 |
| Mtge Amortization ( 4 670) |
61,738,853 |
8,342,806 |
5,714,524 |
3,280,227 |
1,910,013 |
1,342,000 |
569440 |
| Subtotal: Other ( ****)( ) |
77,660,339 |
3,378,976 |
534278 |
-1652069 |
-2468449 |
-2614154 |
-2372420 |
| |
|
|
|
|
|
|
|
| Total |
315,559,179 |
36,462,027 |
19,541,048 |
2,482,332 |
-8283986 |
-13242790 |
-21000961 |
|
