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