Midwest Shocks Excel Spreadsheet final

Midwest Shocks Financial Ratios Mangament Group 12/31/2020 12/31/2021 12/31/2022 Forecast Forecast Profitability 12/31/2023 12/31/2023 Gross Profit Margin 12.77% 24.93% 26.97% 33.31% 33.30% Operating Profit Margin 0.35% 6.53% 4.70% 6.03% 5.30% Net Profit Margin -1.37% 33.89% 2.13% 3.81% 3.28% Efficiency A/R doh 58.15 46.84 45.75 45.80 Inventory doh 178.25 144.33 144.54 138.50 A/P doh 60.03 50.00 59.32 59.30 Total Asset turnover 1.17 1.45 1.46 1.50 Fixed Asset Turnover 4.89 5.55 5.52 5.65 Leverage Funded Debt/Equity 0.55 0.78 1.12 1.14 LTD/Total Capital 35.33% 43.97% 52.80% 53.36% Total Debt/Total Capital 35.33% 43.97% 52.80% 53.36% Funded Debt/EBITDA 2.51 2.85 2.77 2.99 Times Interest Earned 11.98 5.53 8.75 7.86 14.95 8.27 12.03 11.14 Liquidity Current Ratio 2.42 2.21 2.07 2.04 Quick Ratio 1.03 0.91 0.97 0.97 Cash Conversion Cycle 176.4 141.2 131.0 125.0 Returns ROE 90.59% 8.36% 18.59% 16.73% ROA 39.57% 3.08% 5.58% 4.93% ROC 6.67% 6.14% 10.41% 9.46% FCCR = EBITDAR/Int.+Leases+CMLTD

Midwest Shocks 2021 "PLAN" DuPont Model Profitabilit X Efficiency X Leverage = Return X X = X X = 22,125 X 580,000 X 396,193 = 22,125 580,000 396,193 119,031 119,031 3.81% X 1.464 X 3.328 = 18.59% Midwest Shocks 2020 DuPont Model Profitabilit X Efficiency X Leverage = Return X X = X X = 11,592 X 544,111 X 376,540 = 11,592 544,111 376,540 138,725 138,725 2.13% X 1.445 X 2.714 = 8.36% Midwest Shocks 2019 DuPont Model Income Revenue Revenue Assets Assets Equity Income Equity Income Revenue Revenue Assets Assets Equity Income Equity Income Revenue Revenue Assets Assets Equity Income Equity Income Revenue Revenue Assets Assets Equity Income Equity