MILESTONE 2 FORECASTED FINANCIALS Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! YOu may do this either within the cell by us ing 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) Forecasted Balance Sheet ( 30 points: 5 for showing work, 25 for accuracy) 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. 115 points: 5 for showing work, 10 for accurocy Based upon your financial forecast for the years 20232027, compute the following ratios, placing your final results in the yellow highlighted area: (9 points: 1 pt for grammar/spelling, 4 ptsfor thought-out, correct answers) c. Are your liquidity ratios better or worse than the Industry Averages shown on your Milestone 2 Metrics worksheet? d. Regardless of your answer to question 1c, what can happen to a company with poor liquidity? (5 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 workshe f. What is the difference between what a debt utilization ratio measures and what a liquidity ratio measures? MILESTONE 2 FORECASTED FINANCIALS Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! YOu may do this either within the cell by us ing 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) Forecasted Balance Sheet ( 30 points: 5 for showing work, 25 for accuracy) 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. 115 points: 5 for showing work, 10 for accurocy Based upon your financial forecast for the years 20232027, compute the following ratios, placing your final results in the yellow highlighted area: (9 points: 1 pt for grammar/spelling, 4 ptsfor thought-out, correct answers) c. Are your liquidity ratios better or worse than the Industry Averages shown on your Milestone 2 Metrics worksheet? d. Regardless of your answer to question 1c, what can happen to a company with poor liquidity? (5 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 workshe f. What is the difference between what a debt utilization ratio measures and what a liquidity ratio measures
