1. Use the information and assumptions in the Analysis Data tab for forecasting the financial statements for J Young and Sons.
Provide your 5-year projections for the Income Statement, Cash Flow Statement, and Balance Sheet on the Forecasted Statements tab. * Sales volume (demand) should be the basis for your revenue determination.
2. Provide basic margin and ratio analysis for forecasted financials, including ratios pertaining to liquidity and productivity.
3. Based upon your projections and analysis, provide a 2-page synopsis of findings and sources of potential improving cash flow and operating
efficiency.