Needing help with ratios (boxes) 3-20. Great review upon help!

SC TTM Cash Flow Statement ($MM UON) Cash Flow (Ops) NI Dprec Other Operating Flows CF Ops Q8 16.539 90.000 6.003 112.542 Q7 18.143 93.039 1.321 112.502 Q6 18.524 94.965 1.310 114.799 Q5 19.238 97.419 3.064 119.721 Q4 20.484 100.824 7.279 128.587 Q3 21.047 104.257 2.675 127.979 Q2 19.620 108.103 2.452 130.175 Q1 20.350 110.813 3.932 135.094 81.502 423.996 16.338 521.836 Cash Flow (Inv) CAPX Other Investing Flows Q8 - 100.000 0.000 -100.000 Q7 -122.232 0.000 -122.232 Q6 -130.958 0.000 -130.958 Q5 -130.056 0.000 -130.056 Q4 -132.266 0.000 -132.266 Q3 - 139.440 0.000 -139.440 Q2 -146.711 0.000 -146.711 Q1 -148.955 0.000 -148.955 TTM -567.372 0.000 -567.372 CF Inv Cash Flow (Fin) Dividends Paid in Capital (PIC) Other Financing Flows CF Fin Q8 0.000 0.000 0.000 0.000 Q7 -0.364 0.000 13.805 13.805 Q6 -0.750 0.000 -5.862 22.021 Q5 0.000 10.824 -6.689 17.024 Q4 -3.851 0.000 -5.759 9.438 Q3 -4.422 0.000 -5.529 16.990 02 0.000 4.936 -4.590 21.125 Q1 0.000 7.538 -6.577 20.438 TTM -8.273 12.474 -22.455 67.991 12.542 4.076 5.862 6.689 5.759 5.529 4.590 6.577 22.455 Change in Cash from CFS Check: Change in Cash from BS's NA 4.076 5.862 6.689 5.759 5.529 4.590 6.577 22.455 As an analyst intern at JP Morgan Chase, your boss has asked you to complete the ratio analysis shown below for SuperCycles (SC) and a comparable company ("the comp" AKA Zero Motorcycles). Because of their international reach, these companies are virtually non-seasonal. Financial Statements for SC are provided below the incomplete ratio analysis. For questions 3-20 below, fill in the missing ratio by calculating it from the financial statements. Ignore the rest of the missing ratio-analysis-computations. Do not report any of your answers as a percent. (This confuses Canvas). For each ratio shown below as a percent (%), report your answer to 4 decimal places. IE 0.2133, not 21.33%. For each below ratio that is shown as a decimal, report your answer to 2 decimal places. IE: 10.23 or 5.17. Note that Canvas will record an answer of 2.10, for example, as 2.1. This is fine because 2.1 = 2.10. Answer the remaining questions based on the wording of each question. SuperCycles SC Ratio Analysis for Q1 Ending: 3/31/20X1 Q3 Q2 Q1 TTM Q8 Q7 Q6 05 Q4 Sales ($MM) Comps Sales 250.000 80.000 259.883 83.316 267.549 87.619 274.232 92.264 281.908 97.308 291.093 104.510 297.664 110.395 306.681 118.540 1,177.347 430.752 1 25.51% Sales Growth (Quarterly Y on Y, except TTM) Comps Sales Growth Sales Growth (Q on Q, except TTM) Comps Sales Growth 3.95% 4.15% 2.95% 5.16% 2.50% 5.30% 2.80% 5.47% 3.26% 7.40% 2.26% 5.63% 2 7.38% 11.95% 25.51% 3 Profit Margin = NI/Sales % Comps Profit Margin 6.62% -8.65% 6.98% -8.28% 6.92% -6.54% 7.02% -4.70% 7.27% -3.18% 7.23% -0.32% 6.59% 1.05% 4 0.58% 4.03% COGS Margin = COGS/Sales (%) Comps COGS Margin 5 50.00% 31.68% 49.67% 31.66% 48.73% 31.67% 47.49% 31.55% 46.31% 31.44% 44.26% 31.60% 43.54% 31.32% 41.50% 31.48% 43.78% Tax Rate = Tax Expense/EBT (%) Comps Tax Rate 31.09% 30.83% 32.38% 30.36% 34.24% 31.39% 33.40% 33.99% 30.56% 32.80% 30.82% 30.17% 31.33% 34.12% 34.67% 33.98% 6 35.92% 8 Asset Efficiency Ratio = Sales/Assets(bop) Comps AER 0.69 0.39 0.69 0.40 0.68 0.41 0.68 0.42 0.68 0.44 0.68| 0.45 7 0.47 0.46 ROA = NI/Assets(bop) % 4.81% 4.77% 4.80% 4.95% 4.95% 14 4.48% 10 2601 con on 47 4 non 070 8 Asset Efficiency Ratio = Sales/Assets(bop) Comps AER 0.69 0.39 0.69 0.40 0.68 0.41 0.68 0.42 0.68 0.44 0.68 0.45 7 0.47 0.46 4.48% ROA = NI/Assets(bop) % Comps ROA 4.81% -3.25% 4.77% -2.60% 4.80% -1.93% 4.95% -1.33% 4.95% -0.14% 9 1.89% 10 0.27% 0.47% ROE = NI/E(bop) % Comps ROE 10.71% -5.28% 10.65% -4.22% 10.79% -3.14% 11.02% -2.17% 11.08% -0.23% 10.11% 0.76% 11 3.09% 10.96% 0.44% 4.08 12 INV-E = COGS/INV(bop) Comps INV-E 4.12 3.31 4.07 3.27 4.01 3.25 3.99 3.24 3.95 3.26 3.88 3.25 3.29 3.40 AR-T = AR(eop)/Sales % Comps AR-T 1.00% 3.13% 0.99% 3.07% 0.99% 3.00% 0.99% 2.93% 0.99% 2.87% 13 2.76% 1.00% 2.68% 1.00% 2.56% 14 2.82% 46.95% DtA = Total Debt/Total Assets % Comps DLA 46.36% 35.29% 46.47% 35.10% 46.72% 35.35% 46.33% 35.47% 46.58% 35.70% 47.00% 35.68% 15 35.66% 35.63% 16 35.66% DtC = Total Debt/(Total Debt + Equity) % Comps DtC 50.81% 36.49% 50.94% 36.29% 51.23% 36.55% 17 36.66% 51.04% 36.91% 51.44% 36.82% 51.49% 36.88% 51.29% 36.85% 18 36.85% 0.0.70. DEBIT = Total Debt(eop)/EBIT Comps DEBIT 5.15 -18.75 4.87 -20.87 4.84 -41.28 4.84 1,120.29 4.89 38.87 4.92 13.47 5.271 10.07 19 6.36 20 11.54 22 SDItC = (SGA + Deprec + Interest)/COGS % Comps SDIC 1.75 1.15 1.76 1.15 1.75 1.15 1.75 1.15 1.76 1.16 1.77 1.17 1.79 1.16 21 1.16 1.16 24 CR = Current Assets/Current Liabilities Comps CR 2.34 1.74 23 1.74 2.32 1.75 2.32 1.75 2.32 1.75 2.32 1.75 2.31 1.74 2.30 1.75 1.75 WCR = Working CapitalAssets/WCLiabilities Comps WCR 89.58% 92.50% 89.52% 92.52% 89.55% 92.51% 89.55% 92.54% 89.47% 92.56% 89.48% 92.54% 89.42% 92.57% 89.36% 92.58% 89.36% 92.58% 3.40 3.68 25 Fixed Coverage Ratio = EBIT/Interest Comps FCR 3.61 -0.60 3.68 -0.30 3.70 0.01 3.67 0.93 3.43 1.24 3.57 1.97 -0.67 0.32 1.14 EBITDA-S = EBITDA/(Interest + CAPX) Comps EBITDA-S 26 0.67 0.98 0.51 0.94 0.62 0.97 0.58 0.99 0.67 0.97 0.65 0.94 0.80 0.96 0.75 0.96 0.72 Interest Rate = INT/Total Debt (bop) Comps Interest Rate 5.86% 8.27% 5.81% 8.31% 5.72% 8.35% 5.74% 8.24% 5.76% 8.24% 5.71% 8.18% 27 8.27% 28 8.63% Balance Sheet ($MM UON) Assets Cash Q8 200.000 Q7 204.076 Q6 209.938 Q5 216.627 Q4 222.386 Q3 227.915 Q2 232.505 01 239.082 SC TTM 239.082 Balance Sheet ($MM UON) Assets Cash Accounts Receivable Short-Term Investments Inventory Other Current Assets Total Current Assets Q8 200.000 10.000 0.000 80.000 20.000 310.000 Q7 204.076 10.255 0.000 82.988 20.408 317.726 Q6 209.938 10.552 0.000 85.296 20.872 326.657 Q5 216.627 10.871 0.000 88.649 21.684 337.831 Q4 222.386 11.133 0.000 91.776 22.439 347.734 Q3 227.915 11.450 0.000 95.301 22.900 357.566 Q2 232.505 11.895 0.000 99.049 23.754 367.203 Q1 239.082 12.251 0.000 102.414 24.535 378.282 SC TTM 239.082 12.251 0.000 102.414 24.535 378.282 Net PPE Other Long Term Assets Total Assets 1,000.000 1,029.193 1,065.186 1,097.823 1,129.265 1,164.448 1,203.056 1.241.198 200.000 207.080 211.887 219.328 223.951 229.949 238.468 244.574 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,241.198 244.574 1,864.054 Liabilities Accounts Payable Short-Term Debt Other Current Liabilities Total Current Liabilities Q8 20.000 100.000 12.300 132.300 Q7 20.550 102.760 12.742 136.052 Q6 21.126 106.461 13.012 140.599 Q5 21.837 110.162 13.472 145.471 Q4 22.626 113.236 13.995 149.858 Q3 23.311 116.296 14.304 153.910 Q2 24.179 120.246 14.659 159.083 Q1 25.023 124.429 15.243 164.695 TTM 25.023 124.429 15.243 164.695 Long-Term Debt Other Liabilities Total Liabilities 600.000 100.000 832.300 619.443 103.025 858.520 642.805 107.071 890.476 656.619 109.576 911.666 679.133 112.010 941.001 706.270 729.941 748.387 115.209 118.573 121.954 975.388 1,007.597 1,035.036 748.387 121.954 1,035.036 Q8 677.700 Q7 695.479 Q6 713.254 Q5 743.316 Q4 759.950 Q3 776.575 Q2 801.131 Q1 829.018 TTM 829.018 Shareholder's Equity Equity = A -L Check: Equity (BOP) + NI + PIC - DIV = Equity (EOP) NA 16.539 677.700 677.700 17.779 695.479 695.479 17.775 713.254 713.254 30.062 743.316 743.316 16.634 759.950 759.950 16.625 776.575 776.575 24.556 801.131 27.888 829.018 801.131 27.888 801.131 829.018 Total Liabilities + Shareholder's Equity 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,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 1,864.054 Income Statement ($MM UON) Revenues COGS Depreciation SGA INT Other Expenses/(Income) Pretax Income Tax After Tax Expenses/(Income) Net Income Q8 250.000 80.000 90.000 40.000 10.000 6.000 24.000 7.461 0.000 16.539 Q7 259.883 82.330 93.039 41.251 10.262 6.172 26.829 8.687 0.000 18.143 Q6 267.549 84.719 94.965 42.840 10.492 6.362 28. 171 9.646 0.000 18.524 Q5 274.232 86.857 97.419 43.852 10.718 6.497 28.888 9.650 0.000 19.238 Q4 281.908 88.947 100.824 44.932 10.996 6.711 29.499 9.015 0.000 20.484 Q3 291.093 91.518 104.257 46.644 11.403 6.847 30.426 9.378 0.000 21.047 Q2 297.664 94.075 108.103 48.167 11.749 6.998 28.573 8.952 0.000 19.620 Q1 306.681 96.037 110.813 49.393 12.133 7.153 31.151 10.802 0.000 20.350 SC TTM 1,177.347 370.577 423.996 189.135 46.281 27.709 119.649 38.147 0.000 81.502 Cash Flow Statement ($MM UON) Cash Flow (Ops) SC TTM Q8 Q7 Q6 Q5 04 Q3 Q2 Q1 doda dor doa