Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Will upvote for excel formulas and explanations, green cells are what is needed B D E F Assumptions General Mills ($ millions) 1 2 Projection

Will upvote for excel formulas and explanations, green cells are what is needed

image text in transcribedimage text in transcribed

B D E F Assumptions General Mills ($ millions) 1 2 Projection Assumptions: 3 Terminal Growth Rate 4 Discount rate (WACC) 5 Net nonoperating obligations (NNO) 6 Noncontrolling interest 7 Shares outstanding 1.5% 5.89% 14,591.7 313.2 601.9 8 2019 Reported 9 10 General Mills ($ millions) 11 12 Sales rounded 13 Growth 14 NOPAT 15 NOA 16 17 Discounted Cash Flow Model 18 NOPAT 2020 Estimated 17,118.2 1.5% 2,396.5 22,231.4 Forecast Horizon Period 2021 2022 Estimated Estimated 17,375.0 17,635.6 1.5% 1.5% 2,432.5 2,469.0 22,564.9 22,903.4 2023 Estimated 17,900.1 1.5% 2,506.0 23,246.9 Terminal Period 18,168.6 1.5% 2,543.6 23,595.6 2,368.7 21,959.4 19 Increase in NOA 20 Free cash flows to the firm (FCFF) 21 Present value of horizon FCFF 22 Cum present value of horizon FCFF 23 Present value of terminal FCFF 24 Total firm value 25 Less (plus) NNO 26 Less noncontrolling interest 27 Firm equity value 28 Shares outstanding 29 Stock value per share 30 Actual price 31 32 Overpriced or underpriced $52.81

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions