Using the spreadsheet information presented next, forecast the external funding required, TIE, TBC, TCC ratios for R\&E Supplies in 2021. Be sure to calculate all forecast values with formulas that are linked to the "Facts and Assumptions" cells (shaded in yellow) to receive credit. Use the "Comments" column to explain how the forecast figures were estimated when cells are shaded in blue. Please organize your answers by using paragraph breaks (Alt + Enter) as needed. \begin{tabular}{ll} $529 & \\ $238 & \\ \hline$291 & $0 \end{tabular} In Excel, make sure you enable "Iterative Calculations" under "File -> Options -> Formulas -> Calculation Options" if you're a Windows user, or under "Excel -> Preferences -> Formulas and Lists -> Calculation" if you're a Mac user. BALANCE SHEET Using the spreadsheet information presented next, forecast the external funding required, TIE, TBC, TCC ratios for R\&E Supplies in 2021. Be sure to calculate all forecast values with formulas that are linked to the "Facts and Assumptions" cells (shaded in yellow) to receive credit. Use the "Comments" column to explain how the forecast figures were estimated when cells are shaded in blue. Please organize your answers by using paragraph breaks (Alt + Enter) as needed. \begin{tabular}{ll} $529 & \\ $238 & \\ \hline$291 & $0 \end{tabular} In Excel, make sure you enable "Iterative Calculations" under "File -> Options -> Formulas -> Calculation Options" if you're a Windows user, or under "Excel -> Preferences -> Formulas and Lists -> Calculation" if you're a Mac user. BALANCE SHEET