how to resolve this using excel fomula please show your the formulas next to each answer please i can understand how you get each part please

} 3 The Balance Sheet of Allied Food Products (In millions of U.S. dollar): Ratios of Assets 2019 Ratios Sales Calculation 2020 (Forecast) 4 3.000 5 Cash and equivalents 0.33% 3,300x0.0033 - 3.000 6 Accounts receivable 12.50% 3,300x0.125 - 615 Inventories 3.000 20.50% 3,300x0.205 - Total current assets $ 1.000 1000 3,000 9 Net plant and equipment 1,000 33.33% 3,300x0.3333 = 10 Total asstes $ 2,000 11 12 Llabilities and Equity 60 3,000 13 Accounts payable 60 2.00% 3,300x0.02 = Are assumed to stay initially constant 14 Notes payable 110 140 15 Accruals 140 3.000 4.67% 3,300.x0.0467 = 16 Total current liabilities $ 310 Are assumed to stay initially constant 17 Long-term bonds 750 18 Total debt $ 1,060 19 Common stock 130 plus additional retained earnings from forecasted 310 (2020) income statement 20 810 + 69.8 = Retained earnings 21 Total common equity 940 22 Total liabilities and equity $ 2.000 24 Liquidity Ratio 25 Debt Ratio 3.23 53.00% } 3 The Balance Sheet of Allied Food Products (In millions of U.S. dollar): Ratios of Assets 2019 Ratios Sales Calculation 2020 (Forecast) 4 3.000 5 Cash and equivalents 0.33% 3,300x0.0033 - 3.000 6 Accounts receivable 12.50% 3,300x0.125 - 615 Inventories 3.000 20.50% 3,300x0.205 - Total current assets $ 1.000 1000 3,000 9 Net plant and equipment 1,000 33.33% 3,300x0.3333 = 10 Total asstes $ 2,000 11 12 Llabilities and Equity 60 3,000 13 Accounts payable 60 2.00% 3,300x0.02 = Are assumed to stay initially constant 14 Notes payable 110 140 15 Accruals 140 3.000 4.67% 3,300.x0.0467 = 16 Total current liabilities $ 310 Are assumed to stay initially constant 17 Long-term bonds 750 18 Total debt $ 1,060 19 Common stock 130 plus additional retained earnings from forecasted 310 (2020) income statement 20 810 + 69.8 = Retained earnings 21 Total common equity 940 22 Total liabilities and equity $ 2.000 24 Liquidity Ratio 25 Debt Ratio 3.23 53.00%