Follow by those detailed instructions to complete all the spreadsheets on attached file PZZA: "How to build the model's forecasts A.Begin with guesses for Check What should the forecast drivers turn out to be? B.Detail your 5-year assumptions on ForecastST & Inputs C. Build Income Statement & Balance Sheet 5-year forecast Retained earnings add to book equity Cash is residual to make A=L+MI+E D.Copy formulas for 5 years of Operating, Financing, Ratios E.Create medium-term (years 6-15) assumptions on Ratios F.Build medium-term forecasts on Operating G.Finish medium-term formulas on Ratios H.End with formulas for Check Did your forecast drivers turn out to be what you expected?" After you finish forecasting all the spreadsheets, please write a 3 pages paper to answer those questions:
1. Evaluate strategic position: customers, business system, industry
2. Consider and describe 3 possible performance scenarios 3. For only the most likely scenario, forecast individual line items using the template Include summary comments for each table, emphasizing how you expect patterns to change from the historical data
4. Describe why the overall forecast is reasonable and how the patterns reach steady and consistent growth See Check sheet comparing 5-year history and forecast intervals
5. Describe how free cash flows will be distributed or paid for How will the firm keep or distribute positive free cash flows or utilize excess cash balances and raise capital to fund negative free cash flows? Fill in the Financing Flows to Investors and from Investments section of the Free Cash Flow on the Financing Sheet.