The below given are income statement balance sheet and cash flow statement

Using that please calculate the financial ratios and do sensitivity analysis the ones that are yellow in color are to be solved

Please check carefully and everything is mentioned

Midwest Shocks Consolidated Statement of Cash Flows $ in OOOs) Actual Actual Management Forecast Group Forecast Operating Activities 2018 2019 12/30/2021 12/30/2021 Net Income 160.911 1 1,592 22.125 421,300 Depreciation 7,687 12,654 13.100 13,100 Loss On Sale of PP&E 143 0 Bargain Purchase Option (147,220) 0 0 Other Non-Cash Items 1,453 692 0 0 Deferred Income Tax (901) 2.294 1,242) 1,242) Mis 0 Accounts Receivable 17,259 5,825 2,874) 69,829 Inventories 16,681 16,932 3.962 157,134 Prepaid Expenses and Other 7,105 (1,893) (16,593) (16,593) Accounts Payable and Accruals 18,938 5,956 6,972 55,886 Income Taxes Payable 3,180 (9,288) 6.664 6.664 Accrued Compensation 3.406 (260) 3.608 3.608 Other Current 0 Other Long-Term Assets/Liab 2,509 (2.726) 641 5.641 CEFO 91.008 41.921 41.363 603.555 Investing Activities Capital Expenditures (11,451) (16, 157) (20,102) 51,162 Proceeds From Sales of PP&E 6,785 2,550 Other (37.602) (4, 102 CFFIA (42,268 17.709) (20.102) 61.162 Free Cash Flow (levered) 24,212 21.261 664.717 Financing Activities ABL Revolver (31,000) (7,000) 24.247 24,247 Senior Debt (foreign) 0 0 Senior Debt #1 0 35,122 (2, 146) Senior Debt #2 0 20,981 0 Capital Contributions 37,602 Dividends (34,400) (45,000) (40,000) 0 Repayment of Preferred Stock (31,099) Other (418) (3,433) 1.819) (1.819) CEFFA 24.193) (36.598) 17.572) Effect of Foreign Currency 1,1 19) 22.428 (1,739) CHANGE IN CASH 23.428 (14,125) 3.689 Check 687.145 0 683.456Midwest Shocks Consolidated Statement of Cash Flows ($ in OOOs) Actual Actual Management Forecast Group Forecast Operating Activities 2018 2019 12/30/2021 12/30/2021 Net Income 160,911 11.592 22,125 421.300 Depreciation 7,687 12.654 13,100 13.100 Loss On Sale of PP&E 143 0 Bargain Purchase Option (147,220) 0 Other Non-Cash Items 1.453 692 0 Deferred Income Tax (901) 2,294 (1,242) (1,242) Misc. 0 Accounts Receivable 17,259 5.825 2.874) 69.829 Inventories 16,681 16,932 3,962 157,134 Prepaid Expenses and Other 7,105 (1,893) (16,593) (16,593) Accounts Payable and Accruals 18.938 5,956 6.972 55,886 Income Taxes Payable 3,180 (9,288) 6,664 Accrued Compensation 6,664 3.406 (260) Other Current 3,608 3.608 0 Other Long-Term Assets/Liab 2,509 (2,726) 5.641 5.641 CEFO 91,008 41,921 41,363 603,555 Investing Activities Capital Expenditures (11,451) (16,157) (20, 102) Proceeds From Sales of PP&E 61,162 6.785 2.550 Other 37.602 (4, 102) CEFIA (42,268) (17,709 sh Flow (levered) (20.102) 61,162 24.212 Financing Activities 21,261 664.717 ABL Revolver 31,000) Senior Debt (foreign) (7,000) 24.247 24,247 10 Senior Debt #1 35,122 (2, 146) 0 0 0 Senior Debt #2 0 20,981 Capital Contributions 37.602 10 Dividends 0 (34.400) 0 Repayment of Preferred Stock (45,000) (40,000) 31,099 Other (418 0 (3.433) CEFFA (1.819) (24,193) (36,598 1.819) Effect of Foreign Currency (1.119) 17.572) 22.428 CHANGE IN CASH (1,739) 23.428 (14,125) Check 3.689 687.145 683.45612/30/2021 These are the key variables that influence free cash flow and, therefore. DRIVE VALUE Value Drivers As part of this exercise, these "holes" are cells that participants must fill with FORMULAS that include value drivers in collumns H and X plus accounting for Midwest Shocks Consolidated Balance Sheet Math For The Math For The Management Forecast Group Forecast Management Group Management (S in 000s) Actual Actual 12/30/2021 Assumptions Assumpitions Assets 12/31/2019 2/30/2020 12/30/2021 Assumptions Plug Cash 38,349 24.224 27,913 27.913 A/R Net 75.654 69.829 72.703 46 doh 45.8 45.8 57.134 153.172 145 doh 144. 144.5 Inventory 174.066 Other Current Assets 14.828 16.721 33.314 33.314 100% growth Total Current Assets 302.897 67,908 287.102 61.227 Land and Improvements 20.06 8,486 18.486 18,486 No additions Buildings 43.84 37.805 37.805 17.805 No additions Capital Expenditure Equipment 10.644 $1.162 81.264 CanEx Forecast 20.102 20.102 Accum. Depreciation 7.360 19.450 32.550 $2.550 Deprec. Schedule PP&E - Net 97.193 98.003 105.005 23.741 Intangibles 3.088 2.779 2.779 S/L Amort. Other L/T Assets 6.527 7.541 1,307 1.307 Disposition Total Non-Current Assets 103.720 108.632 109.091 27.827 Total Assets 106.617 376.540 396.193 89.054 Liabilities and Equity Accounts Payable 58.626 54.431 62.858 59 doh 59.3 59.3 Accrued Compensation 15.593 15.333 18.941 18.941 based on Day date Other Accrued Expenses 40.550 50.701 49.246 9.246 no meaningful che. Taxes Payable 10.200 912 7.576 7.576 from Tax Attorney CMLTD 0 0 TOTAL CURRENT 24.969 121.377 38.621 75.763 ABL - Revolving Loan 50,000 43,000 67,247 67.247 Plug Senior Debt (foreign) 11.928 11.928 11.928 11.928 No change Senior Debt (#1) 35.122 32.976 32.976 32.976 No change Senior Debt (#2) 20.981 20.981 20.981 No change Other Long-Term Liabilities 4.434 2.722 1.820 1.820 No meaningful che Deferred Income Taxes 2,537 4,831 3,589 3,589 From Tax Attorney TOTAL NON-CURRENT 104,021 116,438 138,541 138,541 TIADIS TOTAL LIABILITIES 228.990 237.815 277.162 214.304 EQUITY Common Stock 29 29 29 29 Additoninal Paid-In Capital No change 37.870 38.232 38.232 38.232 Retained Earnings 136.521 103.113 No change 85.238 Accum. Other Comp 3.207 (2.649) (4.468) (4.468) Derivative estimate Total Shareholder's Equity 177.627 138.725 19.03 33.793 TOTAL LIABILITIES AND 406.617 $76.540 396.193 Check 248.097 0.00 $ (159),043.00)financial stater financial statements o The Sensitivity Analysis is to be completed as described in the co cannot (the GREEN column in the template) is to itinn As describe Math For The Math For The Management Group Assumptions Assumptions 6.595897% 6.595897% 66.689655% 66.689655% 23.19% 23.19% 5,000.00 $ 5,000.00 25% 25% $ (40,000.00) $ (40,000.00) C WI . phoMidwest Shocks Consolidated Income Statement ($ in 000s) Actual Actual Actual Management Forecas Group Forecast 12/31/2018 12/31/2019 12/30/2020 2/30/2021 12/30/2021 Net Sales 628,800 474,831 544, 111 580,000 580,000 Cost of Sales 548.499 356,435 397,386 386,800 Gross Profit 80.301 118,396 146,725 193,200 580,000 Gross Profit Margin 12.77% 24.93% 26.97% 33.31% 100.00% SG&A Expense 50, 100 55,971 92,205 134,502 134,502 Depreciation Expense 13,600 7,687 12,654 13,100 13,100 Other expenses 14,400 5,280 3,000 3,000 Restructuring 19,764 9.431 2.598 2,598 Management fees 3.976 1,591 5,000 Total Operating Expenses 78,100 37,398 121,161 58,200 153,200 Earnings Before Int. & Tax 2,201 30,998 25,564 35,000 426,800 Interest Expense (2,100) (2,588) (4,620 (4,000) (4,000) Interest Income 620 857 0 0 Dividend on Preferred Stock ( 1,099) 0 FX Exchange 1.500 (4,772 2,307) (1,500) (1,500) Earnings Before Tax 1,601 23,159 19,494 29.500 421,300 Income Tax Expense 10,200 9.468 7,902 7,375 Effective Tax Rate 637.1% 40.9% 40.5% 25.0% 0.0% Earnings Before Exo Item (8,599) 13,691 11,592 22,125 421,300 Bargain Purchase Gain 147,220 0 Net Earnings (8,599) 160,911 11,592 22,125 421,300 Dividends - Common (34,400) (45,000) (40,000) EBITDA 15,801 38,685 38,218 48,100 NOPAT (11,822) 18,325 15,201 26,250 Midwest Shocks Financial Ratios Mangament 12/31/2018 Group 12/31/2019 12/30/2020 Profitability Forecast Forecast Gross Profit Margin 12/30/2021 12/30/2021 Operating Profit Margin Net Profit Margin Efficiency A/R doh Inventory doh A/P doh Total Asset turnover Fixed Asset Turnover Leverage Funded Debt/Equity LTD/Total Capital Total Debt/Total Capital Funded Debt/EBITDA Times Interest Earned FCCR = EBITDAR/Int. + Leases+CMLTD.:an only 1~ in the DZ Liquidity Current Ratio Quick Ratio Cash Conversion Cycle Returns ROE ROA ROC Midwest Shocks Sensitivity Analysis FCF Before Sensitiztacn FCF After Sensitization Difference Sales Growth 6.59590% 21,261 21,261 GPM (actually COGS %) 66.68966% 21,261 21,261 OPM (actually SG&A Expense) 23.19000% 21,261 21,261 Effective Tax Rate 25.00000% 21,261 21,261 A/R doh 45.8 21,261 21,261 Inventory doh 144.5 21,261 21,261 A/P doh 59.3 21,261 21,261 CapEx 20, 102 21,261 21,261 Dividends (40,000) 21.261 21,261 Management Fees 5,000 21,261 21,261 Other? 21,261 21,261