I need help. If you don't mind can you please show how you got the answers that would be greatly appreciated. Only the yellow portioned needs to be answered.

AutoSave Ooff G C BUSN278 Course Project Milestone 3 TEMPLATE_2023 Home Insert Draw Page Layout Formulas Data Review View Developer @ Tell me Share Comments fx MILESTONE 3: Analysis of Forecasted Financials (60 points) DUE: WEEK 7 Milestone 3 is continuation of the Course Project scenario. However, in Milestone 3 , the forecasted financial statements are provided to you on the "Milestone 3 Financial Stmt data" worksheet. Do NOT use your forecasted financial statements from Milestone 2. Instead, use the data provided in this template to compute your metrics and answer questions. You have created forecasted financials making the assumption that the sharks will provide the $1M in funding you are requesting for expansion. Now you need to determine the profitability of your proposal. Required: 1 (40 pts) Using the "Milestone 3 Financial Stmt data" given in this template, compute several profitability measures as identified on the Milestone 3 Metrics worksheet. Place your answers to the following directly on the Milestone 3 Metrics worksheet: 2 (20 pts) Answer questions about your results on the Milestone 3 Questions tab. Scenario \& Requirements Milestone 3 Financial Stmt data Home Insert Draw Page Layout Formulas Data Review View Developer @ Tell me MILESTONE 3 METRICS 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. Showing your work is worth 5 points! 1 (14 pts) Based upon the figures below and the financial forecast for the years 2023 - 2027, compute 1a through 1d below, placing your final results in the yellow highlighted area. HINT: All formulas needed to solve 1a - 1 d come from your Week 4 Lesson and Week 4 Chapter readings. GIVEN: Quantity of windows sold (Q) Selling price per window (P) Variable Costs per window (VC) Total Fixed Costs (FC) Total Variable Costs (TVC) \begin{tabular}{|r|r|r|r|r|} \hline 2023 & \multicolumn{1}{|c|}{2024} & \multicolumn{1}{|c|}{2025} & \multicolumn{1}{c|}{2026} & \multicolumn{1}{c|}{2027} \\ \hline 4,000 & 5,000 & 6,000 & 7,000 & 8,000 \\ \hline$1,000 & $1,000 & $1,000 & $1,000 & $1,000 \\ \hline$500 & $600 & $583 & $571 & $625 \\ \hline$500,000 & $500,000 & $500,000 & $500,000 & $500,000 \\ \hline$2,000,000 & $3,000,000 & $3,500,000 & $4,000,000 & $5,000,000 \\ \hline \end{tabular} 2 (14 pts) Based upon your financial forecast for the years 2023 - 2027, compute 2a through 2d below FROM THE VIEWPOINT OF THE SHARK, placing your final results in the yellow highlighted area. (HINT: See Week 6 Lesson for 2b - 2d. No hint for 2a! !) GIVEN: NOTE 1: The shark's investment of $1,000,000 gave him 25% ownership of your company and its profits. NOTE 2: The shark requires a 9\% Rate of Return on his investment. NOTE 3: 2023 Cash Flows from Operations Home Insert Draw Page Layout Formulas Data Review View Developer @ Tell me AutoSave Ooff G C BUSN278 Course Project Milestone 3 TEMPLATE_2023 Home Insert Draw Page Layout Formulas Data Review View Developer @ Tell me Share Comments fx MILESTONE 3: Analysis of Forecasted Financials (60 points) DUE: WEEK 7 Milestone 3 is continuation of the Course Project scenario. However, in Milestone 3 , the forecasted financial statements are provided to you on the "Milestone 3 Financial Stmt data" worksheet. Do NOT use your forecasted financial statements from Milestone 2. Instead, use the data provided in this template to compute your metrics and answer questions. You have created forecasted financials making the assumption that the sharks will provide the $1M in funding you are requesting for expansion. Now you need to determine the profitability of your proposal. Required: 1 (40 pts) Using the "Milestone 3 Financial Stmt data" given in this template, compute several profitability measures as identified on the Milestone 3 Metrics worksheet. Place your answers to the following directly on the Milestone 3 Metrics worksheet: 2 (20 pts) Answer questions about your results on the Milestone 3 Questions tab. Scenario \& Requirements Milestone 3 Financial Stmt data Home Insert Draw Page Layout Formulas Data Review View Developer @ Tell me MILESTONE 3 METRICS 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. Showing your work is worth 5 points! 1 (14 pts) Based upon the figures below and the financial forecast for the years 2023 - 2027, compute 1a through 1d below, placing your final results in the yellow highlighted area. HINT: All formulas needed to solve 1a - 1 d come from your Week 4 Lesson and Week 4 Chapter readings. GIVEN: Quantity of windows sold (Q) Selling price per window (P) Variable Costs per window (VC) Total Fixed Costs (FC) Total Variable Costs (TVC) \begin{tabular}{|r|r|r|r|r|} \hline 2023 & \multicolumn{1}{|c|}{2024} & \multicolumn{1}{|c|}{2025} & \multicolumn{1}{c|}{2026} & \multicolumn{1}{c|}{2027} \\ \hline 4,000 & 5,000 & 6,000 & 7,000 & 8,000 \\ \hline$1,000 & $1,000 & $1,000 & $1,000 & $1,000 \\ \hline$500 & $600 & $583 & $571 & $625 \\ \hline$500,000 & $500,000 & $500,000 & $500,000 & $500,000 \\ \hline$2,000,000 & $3,000,000 & $3,500,000 & $4,000,000 & $5,000,000 \\ \hline \end{tabular} 2 (14 pts) Based upon your financial forecast for the years 2023 - 2027, compute 2a through 2d below FROM THE VIEWPOINT OF THE SHARK, placing your final results in the yellow highlighted area. (HINT: See Week 6 Lesson for 2b - 2d. No hint for 2a! !) GIVEN: NOTE 1: The shark's investment of $1,000,000 gave him 25% ownership of your company and its profits. NOTE 2: The shark requires a 9\% Rate of Return on his investment. NOTE 3: 2023 Cash Flows from Operations Home Insert Draw Page Layout Formulas Data Review View Developer @ Tell me