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.