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.
WhatsApp us