| ( bty )( aty ) |
0% |
10% |
12% |
15% |
18% |
20% |
25% |
| Developer ( ****)( ) |
|
|
|
|
|
|
|
| Equity Residual ( 1 196) |
2,136,801 |
748936 |
614279 |
459291 |
345989 |
287588 |
183550 |
| Investment ( 1 310) |
-500000 |
-454545 |
-446429 |
-434783 |
-423729 |
-416667 |
-400000 |
| Investment Adj. ( 1 320) |
57601 |
52365 |
51430 |
50088 |
48815 |
48001 |
46081 |
| Net Cash Flow (NCF) ( 1 699) |
689231 |
320500 |
279117 |
228799 |
189415 |
167884 |
126350 |
| Subtotal: Developer ( ****)( ) |
2,383,633 |
667256 |
498397 |
303395 |
160490 |
86806 |
-44019 |
| |
|
|
|
|
|
|
|
| Lender ( 8.1%)( ) |
|
|
|
|
|
|
|
| Const.Interest ( 2 155) |
74023 |
67293 |
66092 |
64368 |
62731 |
61686 |
59218 |
| Const.Loan ( 2 220) |
|
|
|
|
|
|
|
| Orig.Mtge(s) ( 2 240) |
-1800000 |
-1636364 |
-1607143 |
-1565217 |
-1525424 |
-1500000 |
-1440000 |
| Mtge Interest ( 2 660) |
1,350,000 |
754106 |
681054 |
589160 |
514154 |
471653 |
385614 |
| Mtge Amortization ( 2 670) |
1,800,000 |
630889 |
517457 |
386898 |
291454 |
242258 |
154619 |
| Subtotal: Lender ( 8.1%)( ) |
1,424,023 |
-184075 |
-342540 |
-524792 |
-657084 |
-724403 |
-840549 |
| |
|
|
|
|
|
|
|
| Public ( ****)( 8.1%) |
|
|
|
|
|
|
|
| Const.Interest ( 5 155) |
48819 |
44381 |
43589 |
42452 |
41372 |
40683 |
39056 |
| Orig.Mtge(s) ( 5 240) |
-700000 |
-636364 |
-625000 |
-608696 |
-593220 |
-583333 |
-560000 |
| Mtge Interest ( 5 660) |
700000 |
391018 |
353139 |
305490 |
266598 |
244561 |
199948 |
| Mtge Amortization ( 5 670) |
700000 |
245346 |
201233 |
150460 |
113343 |
94212 |
60130 |
| Income Taxes (Annual) ( 5 850) |
-471333 |
-270456 |
-245834 |
-214849 |
-189537 |
-175180 |
-146063 |
| Inc.Taxes:Equity Residual ( 5 880) |
401893 |
140861 |
115535 |
86384 |
65074 |
54090 |
34522 |
| Subtotal: Public ( ****)( 8.1%) |
679379 |
-85213 |
-157339 |
-238758 |
-296369 |
-324968 |
-372408 |
| |
|
|
|
|
|
|
|
| Secondary Lender( )( ) |
|
|
|
|
|
|
|
| Equity Residual ( 6 196) |
1,066,799 |
373906 |
306679 |
229301 |
172735 |
143578 |
91637 |
| Income Taxes (Annual) ( 6 850) |
471333 |
270456 |
245834 |
214849 |
189537 |
175180 |
146063 |
| Inc.Taxes:Equity Residual ( 6 880) |
-401893 |
-140861 |
-115535 |
-86384 |
-65074 |
-54090 |
-34522 |
| Subtotal: Secondary Lender( )( ) |
1,136,239 |
503501 |
436979 |
357766 |
297198 |
264668 |
203178 |
| |
|
|
|
|
|
|
|
| Total |
5,623,274 |
901468 |
435497 |
-102389 |
-495766 |
-697897 |
-1053797 |
|