Plz calculate ratio 26 by using the sheet below (Ratio 26 is the Q8's EBITDA-S which = EBITDA/(Interest + CAPX)
Balance Sheet ($MM UON) SC Assets Q8 Q7 Q6 Q5 Q4 Q3 Q2 Q1 TTM 200.000 204.076 209.938 216.627 222.386 227.915 232.505 239.082 239.082 Accounts Receivable 10.000 10.552 10.871 11.133 11.450 11.895 Short-Term Investments 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Inventory 80.000 82.988 85.296 88.649 91.776 95.301 99.049 102.414 Other Current Assets 20.000 20.408 21.684 22.439 22.900 23.754 24.535 24.535 Total Current Assets 310.000 317.726 326.657 337.831 347.734 357.566 367.203 378.282 378.282 Net PPE 1,000.000 1,029. 193 1,065.186 1,097.823 1, 129.265 1, 164.448 1,203.056 1,241.198 1,241. 198 Other Long Term Assets 207.080 211.887 223.951 229.949 238.468 244.574 Total Assets 1,510.000 1,553.999 1,603.729 1,654.982 1,700.950 1,751.963 1,808.728 1,864.054 1,864.054 Liabilities Q8 Q7 Q6 Q5 Q4 TTM Accounts Payable 20.000 20.550 21.126 21.837 22.626 23.311 24.179 25.023 25.023 Short-Term Debt 100.000 102.760 106.461 110. 162 113.236 116.296 120.246 124.429 124.429 Other Current Liabilities 12.300 12.742 13.012 13.472 13.995 14.304 14.659 15.243 15.243 Total Current Liabilities 132.300 140.599 145.471 149.858 153.910 164.695 164.695 Long-Term Debt 600.000 619.443 656.619 679.133 706.270 748.387 Other Liabilities 100.000 103.025 107.071 109.576 112.010 115.209 118.573 121.954 121.954 Total Liabilities 832.300 858.520 890.476 911.666 941.001 975.388 1,007.597 1,035.036 1,035.036 Shareholder's Equity Q8 Q6 Q5 Q4 Q3 Q2 Q1 TTM Equity = A - L 677.700 695.479 713.254 743.316 759.950 776.575 801.131 829.018 Check: Equity (BOP) NA 677.700 695.479 713.254 743.316 759.950 776.575 801.131 801.131 + NI + PIC - DIV 16.539 17.779 17.775 30.062 16.634 16.625 24.556 27.888 = Equity (EOP) 677.700 695.479 743.316 759.950 776.575 801.131 829.018 829.018 Total Liabilities + Shareholder's Equity 1,510.000 1,553.999 1,603.729 1,654.982 1,700.950 1,751.963 1,808.728 1,864.054 1,864.054 Check: Total Assets 1,510.000 1,553.999 1,603.729 1,654.982 1,700.950 1,751.963 1,808.728 1,864.054 1,864.054 Income Statement SC ($MM UON) Q8 Q7 Q6 Q5 Q4 Q3 Q2 Q1 ITM Revenues 250.000 259.883 267.549 274.232 281.908 291.093 297.664 1,177.347 COGS 80.000 82.330 86.857 88.947 91.518 94.075 96.037 370.577 Depreciation 93.039 94.965 97.419 100.824 104.257 108.103 110.813 423.996 SGA 40.000 41.251 42.840 43.852 44.932 46.644 48. 167 49.393 189.135 INT 10.000 10.262 10.492 10.996 11.403 11.749 12.133 Other Expenses/(Income 6.000 6.172 6.497 6.711 6.998 7.153 27.709 Pretax Income 24.000 26.829 28.171 30.426 28.573 31.151 119.649 Tax 7.461 8.687 9.646 9.650 9.015 9.378 8.952 10.802 38. 147 After Tax Expenses/(Income) 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 Net Income 16.539 18.524 19.238 21.047 19.620 20.350 81.502
