I have been assigned General Mills in a group project and I need help with the following 4 questions. All questions are focused around General Mills

I have been assigned General Mills in a group project and I need help with the following 4 questions. All questions are focused around General Mills. Please show work. 


Q1. Forecasting 
• List of Specific Assumptions used in forecasts 
• Forecasts for a 5 year time horizon 

Need explanation for time and specific assumption used in forecast. Must be done on word doc. Need to show references. 

Q2. Valuation 
• Components of the WACC (with sources referenced) 
• DCF Model - Optimistic, Pessimistic & Expected 
• DAE Model - Optimistic, Pessimistic & Expected 
• DAROE Model - Optimistic, Pessimistic & Expected 

I will need a written explanation to why the company is Optimistic, Pessimistic & Expected for each of the models and the WACC analysis. Must be done on word doc. Need to show references. 

Q3. Assessment of Solvency 
• Calculation of Altman's Z 
• Estimate of Bond Rating based on ratios 
• Actual Bond Rating (if applicable) 

Will need explanation for each item. Must be done on the word doc. Need to show references.

Q4. Spreadsheets

• Buffet spreadsheet 

Must substitute Nike with General Mills answer the questions highlighted in yellow. Instructions are in the first 3 spreadsheets and the fourth is the actual spreadsheet to complete. 

FYI: year 1 is last year and year 8 is 8 years ago. Government bond is based on long term. 

• Valuation spreadsheet (DCF&EVA)
This assignment has 2 parts. First Spreadsheet FCFF valuation, second spreadsheet feeds off the first spreadsheet, please check to make sure that second spreadsheet is reflecting the answers from the first spreadsheet.