Fill out complete forecast for the year 2022 and show how you got calculations. 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. IFR, the short-term portion of long-term debt and long-term debt. 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.) What are some additional considerations that do you think a credit agency would take into account before assigning a credit rating to a company similar to R\&E Supplies, but much larger in operational scale and sales (such as Lowes or Home Depot) and a below investment grade rating, i.e., as a junk bond issuer? What does history say about the challenges credit agencies are facing when issuing credit ratings, especially about their performance before the 2008 financial crisis? Please reference the arguments referenced in Ch. 5 when answering this