CapitalStackAnalysisFormat.xlsx
Sheet3
| Structure A | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Cumulative | | | Project Cost |
| Cash Flow |
| Debt Service | | | | | | | | | | | Acquisition | $ 24,000,000 |
| Equity A | | | | | | | | | | | Renovation | $ 750,000 |
| Equity B | | | | | | | | | | | Working Capital | $ 200,000 |
| Equity C | | | | | | | | | | | Closing Costs | $ 2,000,000 |
| Equity C Mezannine | | | | | | | | | | | Total | $ 26,950,000 |
| Your Company Basic |
| Net Excess Cash Flow | | | | | | | | | | | | Structure A | Structure B | Structure C |
| Your Company Incentive | | | | | | | | | | | Debt | 60% | 50% | 40% |
| | | | | | | | | | | | Equity A | 25% | | 25% |
| Structure B | | | | | | | | | | | Equity B | | 25% |
| Cash Flow | | | | | | | | | | | Equity C | | | 10% |
| Debt | | | | | | | | | | | Your Company | 15% | 15% | 25% |
| Equity A | | | | | | | | | | | Mezannine | | 10% |
| Equity B | | | | | | | | | | | Total | 100% | 100% | 100% |
| Equity C |
| Equity C Mezannine | | | | | | | | | | | | Structure A | Structure B | Structure C |
| Your Company Basic | | | | | | | | | | | Debt | $ 16,170,000 | $ 13,475,000 | $ 10,780,000 |
| Net Excess Cash Flow | | | | | | | | | | | Equity A | $ 6,737,500 | $ - 0 | $ 6,737,500 |
| Your Company Incentive | | | | | | | | | | | Equity B | $ - 0 | $ 6,737,500 | $ - 0 |
| | | | | | | | | | | | Equity C | $ - 0 | $ - 0 | $ 2,695,000 |
| Structure C | | | | | | | | | | | Your Company | $ 4,042,500 | $ 4,042,500 | $ 6,737,500 |
| Cash Flow | | | | | | | | | | | Mezannine | $ - 0 | $ 2,695,000 | $ - 0 |
| Debt | | | | | | | | | | | Total | $ 26,950,000.0 | $ 26,950,000.0 | $ 26,950,000.0 |
| Equity A |
| Equity B | | | | | | | | | | | ` | $ 16,170,000 | $ 13,475,000 | $ 10,780,000 |
| Equity C | | | | | | | | | | | Interest Rate | 8.0% | 8.0% | 6.0% |
| Equity C Mezannine |
| Your Company Basic | | | | | | | | | | | Structure A | Principal Bal | Principal Pmt | Interest | Total PMT |
| Net Excess Cash Flow | | | | | | | | | | | Year 1 | $ 16,170,000 | $ 808,500 | $ 1,293,600 | $ 2,102,100 |
| Your Company Incentive | | | | | | | | | | | Year 2 | $ 15,361,500 | $ 768,075 | $ 1,228,920 | $ 1,996,995 |
| | | | | | | | | | | | Year 3 | $ 14,593,425 | $ 729,671 | $ 1,167,474 | $ 1,897,145 |
| | | | | | | | | | | | Year 4 | $ 13,863,754 | $ 693,188 | $ 1,109,100 | $ 1,802,288 |
| | | | | | | | | | | | Year 5 | $ 13,170,566 | $ 658,528 | $ 1,053,645 | $ 1,712,174 |
| | | | | | | | | | | | Year 6 | $ 12,512,038 | $ 625,602 | $ 1,000,963 | $ 1,626,565 |
| | | | | | | | | | | | Year 7 | $ 11,886,436 | $ 594,322 | $ 950,915 | $ 1,545,237 |
| | | | | | | | | | | | Structure B | Principal Bal | Principal Pmt | Interest | Total PMT |
| | | | | | | | | | | | Year 1 | $ 13,475,000 | $ 673,750 | $ 1,078,000 | $ 1,751,750 |
| | | | | | | | | | | | Year 2 | $ 12,801,250 | $ 640,063 | $ 1,024,100 | $ 1,664,163 |
| | | | | | | | | | | | Year 3 | $ 12,161,188 | $ 608,059 | $ 972,895 | $ 1,580,954 |
| | | | | | | | | | | | Year 4 | $ 11,553,128 | $ 577,656 | $ 924,250 | $ 1,501,907 |
| | | | | | | | | | | | Year 5 | $ 10,975,472 | $ 548,774 | $ 878,038 | $ 1,426,811 |
| | | | | | | | | | | | Year 6 | $ 10,426,698 | $ 521,335 | $ 834,136 | $ 1,355,471 |
| | | | | | | | | | | | Year 7 | $ 9,905,363 | $ 495,268 | $ 792,429 | $ 1,287,697 |
| | | | | | | | | | | | Structure C | Principal Bal | Principal Pmt | Interest | Total PMT |
| | | | | | | | | | | | Year 1 | $ 10,780,000 | $ 539,000 | $ 646,800 | $ 1,185,800 |
| | | | | | | | | | | | Year 2 | $ 10,241,000 | $ 512,050 | $ 614,460 | $ 1,126,510 |
| | | | | | | | | | | | Year 3 | $ 9,728,950 | $ 486,448 | $ 583,737 | $ 1,070,185 |
| | | | | | | | | | | | Year 4 | $ 9,242,503 | $ 462,125 | $ 554,550 | $ 1,016,675 |
| | | | | | | | | | | | Year 5 | $ 8,780,377 | $ 439,019 | $ 526,823 | $ 965,842 |
| | | | | | | | | | | | Year 6 | $ 8,341,359 | $ 417,068 | $ 500,482 | $ 917,549 |
| | | | | | | | | | | | Year 7 | $ 7,924,291 | $ 396,215 | $ 475,457 | $ 871,672 |