SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, or to the side or below -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. 1 2 (10 points) Based upon your financial forecast for the years 2023 - 2027, compute the following ratios, placing your final results in the yellow highlighted area: Industry Averages a Profit Margin b ROA 12.20% 8.75% ROE 22.42% d Current ratio 2.33X e Quick ratio 1.45X f Debt-to-Total Assets 43.05% g TIE 10.28X 2023 2024 2025 2026 (10 points) Compute Required New Funds (RNF) for each year HINT: It may be helpful to fill out the table below identifying the necessary variables before attempting to compute RNF. A S change in S L P S2 D 2022 2023 2024 2025 2026 2027