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.
The post General Mills in a group project and I need help with the following 4 questions. All questions are focused around General Mills appeared first on BlueOrigin EssayWriters.