Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

Recommended Textbook for

Alaskas Permanent Fund Dividend Examining Its Suitability As A Model

Authors: K. Widerquist, M. Howard

2nd Edition

0230112072, 9780230112070

More Books

Students also viewed these Accounting questions