Please help with the columns and rows that I am missing???? The analysis column, coverage ratio rows, Du Ponte ROE and z-score for public firms.

Thank you in advance!

1. Sweet Candy Corp. has prepared the following financial statements: Sweet Candy Corp. Sweet Candy Corp. Income Statement Balance Sheet For the Year Ended Dec. 31 2019 As of Dec. 31 2019 2019 2018 Assets 2019 Sales 3,074,000 2,567,000 Cash 431,000 Cost of Goods Sold 2,088,000 1,711,000 Accounts Receivable 503,000 Gross Profit 986,000 856,000 Inventories 289,000 Selling and G&A Expenses 294,000 295,000 Total Current Assets 1,223,000 Fixed Expenses 35,000 35,000 Gross Fixed Assets 4,669,000 Depreciation Expense 239,000 223,000 Accumulated Depreciation 2,295,000 EBIT 418,000 303,000 Net Fixed Assets 2,374,000 Interest Expense 93,000 91,000 Total Assets 3,597,000 Earnings Before Taxes 325,000 212,000 Liabilities and Owners' Equity Taxes 94,000 64,000 Accounts Payable 382,000 Net Income 231,000 148,000 Short-term Notes Payable 79,000 Accrued Expenses 159,000 Total Current Liabilities 620,000 Long-term Debt 1,023,000 Total Liabilities 1,643,000 Common Stock 819,000 Retained Earnings 1,135,000 Total Shareholder's Equity 1,954,000 Total Liabilities and Owners' Equity 3,597,000 2018 339,000 365,000 300,000 1,004,000 4,322,000 2,056,000 2,266,000 3,270,000 270,000 99,000 114,000 483,000 967,000 1,450,000 808,000 1,012,000 1,820,000 3,270,000 a) Use the template posted and set up a worksheet, and calculate all the ratios in the template for Sweet Candy Corp. A B C D E F Analysis 1 Sweet Candy Corp. Industry 2 Ratios 2019 2018 2019 3 Liquidity Ratios 4 Current Ratio 1.97 2.08 2.50x 5 Quick Ratio 1.51 1.46 0.60x 6 Efficiency Ratios 7 Inventory Turnover Ratio 7.22 5.70 6.50x 8 Accounts Receivable Turnover Rati 6.11 7.03 8.00x 9 Average Collection Period 59.73 51.90 40.00 days 10 Fixed Asset Turnover 1.29 1.13 2.00x 11 Total Asset Turnover 0.85 0.79 2.00x 12 Leverage Ratios 13 Total Debt Ratio 45.68% 44.34% 50.00% 14 Long-Term Debt Ratio 28.44% 29.57% 20 % 15 LTD to Total Capitalization 34.36% 34.70% 30.00% 16 Debt to Equity 0.84 0.80 0.90x 17 Long-Term Debt to Equity 52.35% 53.13% 40.00% 18 Coverage Ratios 19 Times Interest Earned 2.50x 20 Cash Coverage Ratio 3.50x 21 Profitability Rati 22 Gross Profit Margin 32.08% 33.35% 20.00% 23 Operating Proft Margin 13.60% 11.80% 7.00% 24 Net Proft Margin 7.51% 5.77% 5.00% 25 Return on Total Assets 6.42% 4.53% 5.00% 26 Return on Equity 11.82% 8.13% 8.00% 27 Return on Common Equity 28.21% 18.32% 10.00% 28 29 Du Pont ROE 30 Market Value of Equity 1,200,000 1,200,000 31 Z-Score for Public Firms 32 33 Sweet Candy Corp. 34 Economic Profit Calculations 35 2019 2018 36 Tax Rate 28.92% 30.19% 37 NOPAT 231,000 148,000 38 Total Operating Capital 603,000 521,000 39 After-tax Cost of Capital 12% 12% 40 Dollar Cost of Capital 72,360 62,520 41 Economic Profit 158,640 85,480 42 43 1. Sweet Candy Corp. has prepared the following financial statements: Sweet Candy Corp. Sweet Candy Corp. Income Statement Balance Sheet For the Year Ended Dec. 31 2019 As of Dec. 31 2019 2019 2018 Assets 2019 Sales 3,074,000 2,567,000 Cash 431,000 Cost of Goods Sold 2,088,000 1,711,000 Accounts Receivable 503,000 Gross Profit 986,000 856,000 Inventories 289,000 Selling and G&A Expenses 294,000 295,000 Total Current Assets 1,223,000 Fixed Expenses 35,000 35,000 Gross Fixed Assets 4,669,000 Depreciation Expense 239,000 223,000 Accumulated Depreciation 2,295,000 EBIT 418,000 303,000 Net Fixed Assets 2,374,000 Interest Expense 93,000 91,000 Total Assets 3,597,000 Earnings Before Taxes 325,000 212,000 Liabilities and Owners' Equity Taxes 94,000 64,000 Accounts Payable 382,000 Net Income 231,000 148,000 Short-term Notes Payable 79,000 Accrued Expenses 159,000 Total Current Liabilities 620,000 Long-term Debt 1,023,000 Total Liabilities 1,643,000 Common Stock 819,000 Retained Earnings 1,135,000 Total Shareholder's Equity 1,954,000 Total Liabilities and Owners' Equity 3,597,000 2018 339,000 365,000 300,000 1,004,000 4,322,000 2,056,000 2,266,000 3,270,000 270,000 99,000 114,000 483,000 967,000 1,450,000 808,000 1,012,000 1,820,000 3,270,000 a) Use the template posted and set up a worksheet, and calculate all the ratios in the template for Sweet Candy Corp. A B C D E F Analysis 1 Sweet Candy Corp. Industry 2 Ratios 2019 2018 2019 3 Liquidity Ratios 4 Current Ratio 1.97 2.08 2.50x 5 Quick Ratio 1.51 1.46 0.60x 6 Efficiency Ratios 7 Inventory Turnover Ratio 7.22 5.70 6.50x 8 Accounts Receivable Turnover Rati 6.11 7.03 8.00x 9 Average Collection Period 59.73 51.90 40.00 days 10 Fixed Asset Turnover 1.29 1.13 2.00x 11 Total Asset Turnover 0.85 0.79 2.00x 12 Leverage Ratios 13 Total Debt Ratio 45.68% 44.34% 50.00% 14 Long-Term Debt Ratio 28.44% 29.57% 20 % 15 LTD to Total Capitalization 34.36% 34.70% 30.00% 16 Debt to Equity 0.84 0.80 0.90x 17 Long-Term Debt to Equity 52.35% 53.13% 40.00% 18 Coverage Ratios 19 Times Interest Earned 2.50x 20 Cash Coverage Ratio 3.50x 21 Profitability Rati 22 Gross Profit Margin 32.08% 33.35% 20.00% 23 Operating Proft Margin 13.60% 11.80% 7.00% 24 Net Proft Margin 7.51% 5.77% 5.00% 25 Return on Total Assets 6.42% 4.53% 5.00% 26 Return on Equity 11.82% 8.13% 8.00% 27 Return on Common Equity 28.21% 18.32% 10.00% 28 29 Du Pont ROE 30 Market Value of Equity 1,200,000 1,200,000 31 Z-Score for Public Firms 32 33 Sweet Candy Corp. 34 Economic Profit Calculations 35 2019 2018 36 Tax Rate 28.92% 30.19% 37 NOPAT 231,000 148,000 38 Total Operating Capital 603,000 521,000 39 After-tax Cost of Capital 12% 12% 40 Dollar Cost of Capital 72,360 62,520 41 Economic Profit 158,640 85,480 42 43