please fill out spreadsheet with correct formulas explained thank you!

Using the spreadsheet information presented next, forecast the external funding required, TIE, Debt to Assets and ROIC ratios for R\&E Supplies in 2022. Be sure to calculate all forecast values with formulas that are linked to the "Facts and Assumptions" cells to receive credit. INCOME STATEMENT Net sales Cost of goods sold Gross profit Expenses: \begin{tabular}{llll} General, selling, and administrative expenses & $2.267 & $3,091.95 \\ \cline { 2 - 3 } Operating profit & $619 & $515 & Must be calculated iteratively based on the foreca \\ Net interest expense & $90 & \\ \cline { 2 - 3 } Earnings before tax & $529 & \\ Tax & $238 \\ \cline { 2 - 3 } Earnings after tax & $291 \end{tabular} BALANCE SHEET Based on the median financial ratios commonly used to rate a firm's credit quality in Table 6.5, if Armor Industries were to issue bonds, what rating would you expect the firm to receive if the rating was based solely on the firm's interest coverage ratio? (Note that you should pick the closest ratings to your calculated ratios. For example, if you find a TIE ratio of 4.5x, the bonds will be rated BBB, based on that ratio alone.)