Forecast Sales 2023 = W2*Actual Sales 2022 + W1*Actual Sales 2021 = 0.8*1875000 + 0.2*1500000 = $1,800,000

Forecast Sales 2024 = W2*Forecast Sales 2023 + W1*Actual Sales 2022 = 0.8*1800000 + 0.2*1875000 = $1,815,000

Forecast Sales 2025 = W2*Forecast Sales 2024 + W1*Forecast Sales 2023 = 0.8*1815000 + 0.2*1800000 = $1,812,000

Forecast Sales 2026 = W2*Forecast Sales 2025 + W1*Forecast Sales 2024 = 0.8*1812000 + 0.2*1815000 = $1,812,600

Forecast Sales 2027 = W2*Forecast Sales 2026 + W1*Forecast Sales 2025 = 0.8*1812600 + 0.2*1812000 = $1,812,480

HOW 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 (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: 2 (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. \begin{tabular}{l|l|l|l|l|l|} & 2022 & 2023 & 2024 & 2025 & 2026 \\ \hline A & & & & & \\ \hline S & & & & & \\ \hline change in S & & & & & \\ \hline L & & & & & \\ \hline P & & & & & \\ \hline S2 & & & & & \\ \hline D & & & & & \end{tabular} HOW 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 (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: 2 (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. \begin{tabular}{l|l|l|l|l|l|} & 2022 & 2023 & 2024 & 2025 & 2026 \\ \hline A & & & & & \\ \hline S & & & & & \\ \hline change in S & & & & & \\ \hline L & & & & & \\ \hline P & & & & & \\ \hline S2 & & & & & \\ \hline D & & & & & \end{tabular}