Please show calculations - Thank you!!!

SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Income Statement (20 points: 5 for showing work, 15 for accuracy) DURA-CLEAR WINDOWS, LLC Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet ASSUMPTIONS NOTE: You will use a combination of Proforma, Ratios, and the Percent-of-Sales methods to create your forecaste 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 -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. 115 points: 5 for showing work, 10 for accuracy Based upon your financial forecast for the years 2023 - 2027, compute the following ratios, placing your final results in the yellow highlighted area: 215 points: 5 for showing work, 10 for accuracy Compute Required New Funds (RNF) for each year (HINT: See Formula 4-1 in your Week 3 Chapter readings) OPTIONAL: It would be very helpful to fill out the table below identifying the necessary variables before attempting to compute RNF. SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Income Statement (20 points: 5 for showing work, 15 for accuracy) DURA-CLEAR WINDOWS, LLC Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet ASSUMPTIONS NOTE: You will use a combination of Proforma, Ratios, and the Percent-of-Sales methods to create your forecaste 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 -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. 115 points: 5 for showing work, 10 for accuracy Based upon your financial forecast for the years 2023 - 2027, compute the following ratios, placing your final results in the yellow highlighted area: 215 points: 5 for showing work, 10 for accuracy Compute Required New Funds (RNF) for each year (HINT: See Formula 4-1 in your Week 3 Chapter readings) OPTIONAL: It would be very helpful to fill out the table below identifying the necessary variables before attempting to compute RNF