A20 x Se D G Styles Call M N 4 5 6 7 2 1 MILESTONE 2 METRICS SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, or to the side or below-d- All your work must be shown on this sheet, not on a separate tab. 1 (10 points) Based upon your financial forecast for the years 2023-2027, compute the following ratios, placing your final results in the yellow hi 8 9 Industry Averages 2023 2024 2025 2026 2027 10 a Profit Margin 11 b ROA 12 C ROE 12.20% 8.75% 22.42% 13 d Current ratio 2.33X 14 e Quick ratio 1.45X 15 f Debt-to-Total Assets 43.05% 16 B TIE 10.28X 17 18 2 19 20 (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. Forecasted Financials Milestone 2 Metrics Milestone 2 Questions Milestone 3 Metrics Mile C