general mills in a group project and i need help with the following 4 questions all 494674

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.

Attachments:

spreadsheet_0….xls

0.xls