how to slove this with excel formula? and please show the excel formulas next to each result you get so i can understand how you did it please

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