Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Green cells are needed with upvote for formulas and explanation on how to calculate. Thank you A B D E F G Assumptions General Mills
Green cells are needed with upvote for formulas and explanation on how to calculate. Thank you
A B D E F G 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 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 15 NOA 16 17 Discounted Cash Flow Model 18 NOPAT 19 Increase in NOA 20 Free cash flows to the firm (FCFF) 2,396.5 272.0 2,124.5 2,432.5 333.5 2,099.0 2,469.0 338.5 2,130.5 2,506.0 343.5 2,162.5 2,543.6 348.7 2,194.9 B D E F G 2,396.5 272.0 2,124.5 2,432.5 333.5 2,099.0 2,469.0 338.5 2,130.5 2,506.0 343.5 2,162.5 2,543.6 348.7 2,194.9 16 17 Discounted Cash Flow Model 18 NOPAT 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.81Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started