|
Scenario One: Equity
80% & Loan 20%
|
Ratios |
|
|
|
|
|
|
|
|
|
|
|
Liquidity |
|
|
|
|
|
|
|
|
|
|
|
Current |
21 |
|
|
|
|
|
|
|
|
|
|
Receivables turnover |
0
|
|
|
|
|
|
|
|
|
|
|
Profitability |
|
|
|
|
|
|
|
|
|
|
|
Profit margin |
-2451856.047 |
0.5233 |
0.5889 |
0.8843 |
0.8674 |
0.9216 |
0.9168 |
0.9471 |
0.9469 |
0.9512 |
|
Asset turnover |
2.3356 |
0.1420 |
0.1710 |
0.2612 |
0.3036 |
0.4396 |
0.5643 |
0.7125 |
0.7730 |
0.8414 |
|
Return on assets |
-0.0572 |
0.0743 |
0.1007 |
0.2310 |
0.2633 |
0.4052 |
0.5173 |
0.6749 |
0.7320 |
0.8004 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Solvency |
|
|
|
|
|
|
|
|
|
|
|
Debt to total assets ratio |
-0.0513 |
0.0007 |
0.0106 |
0.0547 |
0.0596 |
0.0923 |
0.1063 |
0.1241 |
0.1177 |
0.1135 |
|
Times interest earned |
-2,451,856 |
3,182,787 |
4,312,498 |
9,892,762 |
11,276,381 |
17,350,612 |
22,152,040 |
28,895,982 |
31,341,910 |
34,270,939 |
|
Cash debt coverage ratio |
-0.6238 |
-0.0983 |
-0.1081 |
1.3022 |
1.2410 |
2.8223 |
3.4124 |
5.1948 |
5.6632 |
6.3331 |
Scenario Two: Equity
85% & Loan 15%
|
Ratios |
|
|
|
|
|
|
|
|
|
|
|
Liquidity |
|
|
|
|
|
|
|
|
|
|
|
Current |
21 |
|
|
|
|
|
|
|
|
|
|
Receivables turnover |
0
|
|
|
|
|
|
|
|
|
|
|
Profitability |
|
|
|
|
|
|
|
|
|
|
|
Profit margin |
-2451856.047 |
0.5233 |
0.5889 |
0.8843 |
0.8674 |
0.9216 |
0.9168 |
0.9471 |
0.9469 |
0.9512 |
|
Asset turnover |
2.3356 |
0.1420 |
0.1710 |
0.2612 |
0.3036 |
0.4396 |
0.5643 |
0.7125 |
0.7730 |
0.8414 |
|
Return on assets |
-0.0572 |
0.0743 |
0.1007 |
0.2310 |
0.2633 |
0.4052 |
0.5173 |
0.6749 |
0.7320 |
0.8004 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Solvency |
|
|
|
|
|
|
|
|
|
|
|
Debt to total assets ratio |
-0.0440 |
0.0079 |
0.0174 |
0.0608 |
0.0652 |
0.0972 |
0.1106 |
0.1277 |
0.1209 |
0.1163 |
|
Times interest earned |
-2,451,856 |
3,182,787 |
4,312,498 |
9,892,762 |
11,276,381 |
17,350,612 |
22,152,040 |
28,895,982 |
31,341,910 |
34,270,939 |
|
Cash debt coverage ratio |
-0.3681 |
0.0598 |
0.0504 |
1.4063 |
1.3475 |
2.8677 |
3.4351 |
5.1487 |
5.5990 |
6.2430 |
Scenario Three:
Equity 90% & Loan 10%
|
Ratios |
|
|
|
|
|
|
|
|
|
|
|
Liquidity |
|
|
|
|
|
|
|
|
|
|
|
Current |
21 |
|
|
|
|
|
|
|
|
|
|
Receivables turnover |
0
|
|
|
|
|
|
|
|
|
|
|
Profitability |
|
|
|
|
|
|
|
|
|
|
|
Profit margin |
-2451856.047 |
0.5233 |
0.5889 |
0.8843 |
0.8674 |
0.9216 |
0.9168 |
0.9471 |
0.9469 |
0.9512 |
|
Asset turnover |
2.3356 |
0.1420 |
0.1710 |
0.2612 |
0.3036 |
0.4396 |
0.5643 |
0.7125 |
0.7730 |
0.8414 |
|
Return on assets |
-0.0572 |
0.0743 |
0.1007 |
0.2310 |
0.2633 |
0.4052 |
0.5173 |
0.6749 |
0.7320 |
0.8004 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Solvency |
|
|
|
|
|
|
|
|
|
|
|
Debt to total assets ratio |
-0.0368 |
0.0149 |
0.0241 |
0.0670 |
0.0708 |
0.1021 |
0.1148 |
0.1313 |
0.1240 |
0.1190 |
|
Times interest earned |
-2,451,856 |
3,182,787 |
4,312,498 |
9,892,762 |
11,276,381 |
17,350,612 |
22,152,040 |
28,895,982 |
31,341,910 |
34,270,939 |
|
Cash debt coverage ratio |
-0.1314 |
0.2063 |
0.1972 |
1.5027 |
1.4461 |
2.9098 |
3.4561 |
5.1060 |
5.5396 |
6.1596 |
Scenario Four: Loan
100%
|
Ratios |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
Liquidity |
|
|
|
|
|
|
|
|
|
|
|
Current |
20 |
|
|
|
|
|
|
|
|
|
|
Receivables turnover |
0
|
|
|
|
|
|
|
|
|
|
|
Profitability |
|
|
|
|
|
|
|
|
|
|
|
Profit margin |
-2451856.047 |
0.5233 |
0.5889 |
0.8843 |
0.8674 |
0.9216 |
0.9168 |
0.9471 |
0.9469 |
0.9512 |
|
Asset turnover |
2.3356 |
0.1420 |
0.1710 |
0.2612 |
0.3036 |
0.4396 |
0.5643 |
0.7125 |
0.7730 |
0.8414 |
|
Return on assets |
-0.0572 |
0.0743 |
0.1007 |
0.2310 |
0.2633 |
0.4052 |
0.5173 |
0.6749 |
0.7320 |
0.8004 |
|
Solvency |
|
|
|
|
|
|
|
|
|
|
|
Debt to total assets ratio |
-0.1697 |
-0.1158 |
-0.1000 |
-0.0459 |
-0.0312 |
0.0122 |
0.0377 |
0.0653 |
0.0668 |
0.0690 |
|
Times interest earned |
-2,451,856 |
3,182,787 |
4,312,498 |
9,892,762 |
11,276,381 |
17,350,612 |
22,152,040 |
28,895,982 |
31,341,910 |
34,270,939 |
|
Cash debt coverage ratio |
-12.5268 |
-7.4630 |
-7.4904 |
-3.5457 |
-3.7166 |
0.7059 |
2.3566 |
7.3420 |
8.6522 |
10.5258 |
Scenario Five: Equity
100%
|
Ratios |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
Liquidity |
|
|
|
|
|
|
|
|
|
|
|
Current |
21 |
|
|
|
|
|
|
|
|
|
|
Receivables turnover |
0
|
|
|
|
|
|
|
|
|
|
|
Profitability |
|
|
|
|
|
|
|
|
|
|
|
Profit margin |
-2451856.047 |
0.5233 |
0.5889 |
0.8843 |
0.8674 |
0.9216 |
0.9168 |
0.9471 |
0.9469 |
0.9512 |
|
Asset turnover |
2.3356 |
0.1420 |
0.1710 |
0.2612 |
0.3036 |
0.4396 |
0.5643 |
0.7125 |
0.7730 |
0.8414 |
|
Return on assets |
-0.0572 |
0.0743 |
0.1007 |
0.2310 |
0.2633 |
0.4052 |
0.5173 |
0.6749 |
0.7320 |
0.8004 |
|
Solvency |
|
|
|
|
|
|
|
|
|
|
|
Debt to total assets ratio |
-0.0225 |
0.0291 |
0.0375 |
0.0792 |
0.0818 |
0.1119 |
0.1232 |
0.1386 |
0.1303 |
0.1245 |
|
Times interest earned |
-2,451,856 |
3,182,787 |
4,312,498 |
9,892,762 |
11,276,381 |
17,350,612 |
22,152,040 |
28,895,982 |
31,341,910 |
34,270,939 |
|
Cash debt coverage ratio |
0.2928 |
0.4688 |
0.4604 |
1.6755 |
1.6229 |
2.9852 |
3.4937 |
5.0295 |
5.4331 |
6.0102 |
|