1. Complete a common size statement for Dapper Dawg Industries for all three years using an excel spreadsheet.

2. Use the Dupont ratio to calculate the ROE and which ratio should the firm try to improve?

3. Using the ratios template for the forecast, complete the ratios. Do you observe any weakness or concerns in the firms forecast

Forecast 2021 2020 Dapper Dawg Industres Balance Sheet($ 000's) ASSETS 2019 Current Assets Cash 9,000 Short-term Investments 48,500 Accounts Receivable 351,200 Inventory 725, 200 Total Current Assets 1,124,000 Plant & Equipment 491,000 Accumulated Depreciation 145,200 Net Plant & Equipment 344,800 TOTALASSETS 1,458,800 LIABILITIES and SHAREHOLDERS' EQUITY Current Liabilities Accounts Payable 145,500 Notes Payable 200,000 Accrued Expenses 135,000 Total Current Liabilities 481,500 Long Term Debt 323,432 Common Shares 450,000 Retained Earnings 203,768 Total Equity 663,758 TOTAL LIABILITIES AND EQUITY 1,458, 800 7,282 20,000 632, 150 1,287,350 1,945, 802 1,202.950 263,150 939.790 2,886,592 14,000 71,632 878,000 1,715,480 2,680,112 1.220,000 383,150 835,840 3,515,952 324,000 720,000 284,950 1,328,950 1,000,000 450,000 97,532 557,532 359,800 300,000 380,000 1,039,800 500,000 1,580,935 295, 216 1,977, 152 2.886,592 3,516,952 Dapper Dawg Industries Income Statement ($000's) Sales Revenues Cost of Goods Sold Contribution Margin Operating Expenses Depreciation Interest Earnings B4 Taxes Taxes @ 40% Earnings After tax Other Data that may be helpful Stock Price Shares o/s EPS DPS Tax Rate Book Value per Share Lease Payments 2019 3,432,000.0 2,864,000.0 568,000.0 340,000.0 18,900.0 62,500.0 146,600.0 58,640.0 87,960.0 Forecast 2020 2021 5,834,400.0 7,035,600.0 4,980,000.0 5,800,000.0 854,400.0 1,235,600.0 720,000.0 612,960.0 116,960.0 120,000.0 176,000.0 80,000.0 158,560.0 422,640.0 63,424.0 169,056.0 95,136.0 253,584.0 $ $ $ 8.50 $ 100,000 0.880 $ 0.220 $ 40% 6.638 $ 40,000 $ $ $ 2.3 0.8 Ratios Current Quick Inventory Turnover Day's Sales Outstanding Fixed Assets Turnover Total Asset Turnover Total Debt Ratio TIE Ratio Profit Margin Ratio Return on Assets Return on Equity Price Earnings Ratio Price/Cash Flow Market to Book Ratio 6.00 $ 12.17 100,000 250,000 0.951 $ 1.014 0.110 $ 0.220 40% 40% 5.576 $ 7.909 40,000 $ 40,000 Industry Forecast Average 1.5 2.7 0.5 1.0 4.5 6.1 69.6 32.0 6.2 7.0 2.0 2.5 80.7 50.0 0.1 6.2 -1.6% 3.6% -3.3% 9.0% - 17.1% 17.9% N/A 16.2 27.5 7.6 4.8 37.3 10.0 2.3 54.8 3.3 2.6% 6.0% 13.3% 9.7 8.0 1.3 1.1 2.9 Forecast 2021 2020 Dapper Dawg Industres Balance Sheet($ 000's) ASSETS 2019 Current Assets Cash 9,000 Short-term Investments 48,500 Accounts Receivable 351,200 Inventory 725, 200 Total Current Assets 1,124,000 Plant & Equipment 491,000 Accumulated Depreciation 145,200 Net Plant & Equipment 344,800 TOTALASSETS 1,458,800 LIABILITIES and SHAREHOLDERS' EQUITY Current Liabilities Accounts Payable 145,500 Notes Payable 200,000 Accrued Expenses 135,000 Total Current Liabilities 481,500 Long Term Debt 323,432 Common Shares 450,000 Retained Earnings 203,768 Total Equity 663,758 TOTAL LIABILITIES AND EQUITY 1,458, 800 7,282 20,000 632, 150 1,287,350 1,945, 802 1,202.950 263,150 939.790 2,886,592 14,000 71,632 878,000 1,715,480 2,680,112 1.220,000 383,150 835,840 3,515,952 324,000 720,000 284,950 1,328,950 1,000,000 450,000 97,532 557,532 359,800 300,000 380,000 1,039,800 500,000 1,580,935 295, 216 1,977, 152 2.886,592 3,516,952 Dapper Dawg Industries Income Statement ($000's) Sales Revenues Cost of Goods Sold Contribution Margin Operating Expenses Depreciation Interest Earnings B4 Taxes Taxes @ 40% Earnings After tax Other Data that may be helpful Stock Price Shares o/s EPS DPS Tax Rate Book Value per Share Lease Payments 2019 3,432,000.0 2,864,000.0 568,000.0 340,000.0 18,900.0 62,500.0 146,600.0 58,640.0 87,960.0 Forecast 2020 2021 5,834,400.0 7,035,600.0 4,980,000.0 5,800,000.0 854,400.0 1,235,600.0 720,000.0 612,960.0 116,960.0 120,000.0 176,000.0 80,000.0 158,560.0 422,640.0 63,424.0 169,056.0 95,136.0 253,584.0 $ $ $ 8.50 $ 100,000 0.880 $ 0.220 $ 40% 6.638 $ 40,000 $ $ $ 2.3 0.8 Ratios Current Quick Inventory Turnover Day's Sales Outstanding Fixed Assets Turnover Total Asset Turnover Total Debt Ratio TIE Ratio Profit Margin Ratio Return on Assets Return on Equity Price Earnings Ratio Price/Cash Flow Market to Book Ratio 6.00 $ 12.17 100,000 250,000 0.951 $ 1.014 0.110 $ 0.220 40% 40% 5.576 $ 7.909 40,000 $ 40,000 Industry Forecast Average 1.5 2.7 0.5 1.0 4.5 6.1 69.6 32.0 6.2 7.0 2.0 2.5 80.7 50.0 0.1 6.2 -1.6% 3.6% -3.3% 9.0% - 17.1% 17.9% N/A 16.2 27.5 7.6 4.8 37.3 10.0 2.3 54.8 3.3 2.6% 6.0% 13.3% 9.7 8.0 1.3 1.1 2.9