orecasted Balance Sheet ( 30 points: 5 for showing work, 25 for accuracy) (S paints: 1 pt for gram:nar/spelling, 4 pts for thought-out, carrect answers) a. Are your profitability ratios better or worse than the Industry Averages shown on your Milestone 2 Metrics vorksheet? b. Are the sharks likely to challenge your figures? Why or why not? (5 points: 1 pe for grammar/spelling, 4 pts for thought-out, correct answers) c. Are your liquidity tatios better or worse than the Industry Averages shown on your Milestone 2 Metrics worksheet? d. Regardless of your answer to question 15 , what can happen to a company with poor liquidity? (S points: 1 pe for gramimar/spelling, 4 pts for thought-out, correct answers) e. Are your debs utilization ratios better or worse than the industry Averages shewn on your Milestone 2 Metrics worksheet? f. What is the difference between what a debt utilization ratio measures and what a liquidity ratio measures? Fill in the yellow highlighted cells with your forecasted figures. SHOW ALI YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both - cl 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) Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) (S points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) e. Are your debt utilization ratios better or worse than the Industry Averages shown on your Milestone 2 Metrics worksheet? f. What is the difference between what a debt utilization ratio measures and what a liquidity ratio measures? Required New Funds (RNF) (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) a. You asked the sharks for \$1M. Looking at your RNF results, is it enough? How do you know? b. Regardless of your answer to 2a, where you could pull funds from if you needed extra funds? (HINT: Look at your Assumptions to see where you could change a deckion and free up funds.) HOW ALI YOUR SUPPORTING CALCULATIONSI 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 occuracy 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 occuracy Compute Required New funds (RNF) for each year enevr Sce formula 4:1 in your Week 3 Chapter reodings) ASSUMPTIONS NOTE: You will use a cambination of Proforma, Ratios, and the Percent-of-Sales methods to create your forecasted financials. orecasted Balance Sheet ( 30 points: 5 for showing work, 25 for accuracy) (S paints: 1 pt for gram:nar/spelling, 4 pts for thought-out, carrect answers) a. Are your profitability ratios better or worse than the Industry Averages shown on your Milestone 2 Metrics vorksheet? b. Are the sharks likely to challenge your figures? Why or why not? (5 points: 1 pe for grammar/spelling, 4 pts for thought-out, correct answers) c. Are your liquidity tatios better or worse than the Industry Averages shown on your Milestone 2 Metrics worksheet? d. Regardless of your answer to question 15 , what can happen to a company with poor liquidity? (S points: 1 pe for gramimar/spelling, 4 pts for thought-out, correct answers) e. Are your debs utilization ratios better or worse than the industry Averages shewn on your Milestone 2 Metrics worksheet? f. What is the difference between what a debt utilization ratio measures and what a liquidity ratio measures? Fill in the yellow highlighted cells with your forecasted figures. SHOW ALI YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both - cl 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) Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) (S points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) e. Are your debt utilization ratios better or worse than the Industry Averages shown on your Milestone 2 Metrics worksheet? f. What is the difference between what a debt utilization ratio measures and what a liquidity ratio measures? Required New Funds (RNF) (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) a. You asked the sharks for \$1M. Looking at your RNF results, is it enough? How do you know? b. Regardless of your answer to 2a, where you could pull funds from if you needed extra funds? (HINT: Look at your Assumptions to see where you could change a deckion and free up funds.) HOW ALI YOUR SUPPORTING CALCULATIONSI 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 occuracy 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 occuracy Compute Required New funds (RNF) for each year enevr Sce formula 4:1 in your Week 3 Chapter reodings) ASSUMPTIONS NOTE: You will use a cambination of Proforma, Ratios, and the Percent-of-Sales methods to create your forecasted financials