As the financial vice president for Apex Enterprises, you have the following information: Expected net income after tax next year before new financing R40 million

Sinking-fund payments due next year on existing debt R14 million

Interest due next year on existing debt R15 million

Company tax rate 36%

Common stock value, per share R20

Common shares outstanding 18 million

PLEASE HELP ME WORK THIS OUT, CAN YOU SHOW ME FORMULAE YOU USED IN EXCEL FOR ME TO FOLLOW HOW?

1. Calculate Apex's times-interest-earned ratio for next year assuming the firm raises R40 million of new debt at an interest rate of 7 percent.
2. Calculate Apex's times-burden-covered ratio for the next year assuming annual sinking-fund payments on the new debt will equal R8 million.
3. Calculate next year's earnings per share assuming Apex raises the R40 million of new debt.
4. Calculate next year's times-interest-earned ratio, times-burden-covered ratio, and earnings per share if Apex sells 2 million new shares at R20 a share instead of raising new debt.

THANK YOU