The files that accompany this book contains information for Kellogg. Use this information and the template of
Question:
The files that accompany this book contains information for Kellogg. Use this information and the template of section 4.1 to value Kellogg.
Transcribed Image Text:
B C D E I F BASIC CASH FLOW VALUATION TEMPLATE A 2 Current free cash flow (FCF) 3 Growth rate of FCF, years 1-5 4 Long-term FCF growth rate 5 Weighted average cost of capital (WACC) 1,000 8.00% 5.00% 11.00% 6. 7 Year 8 Future FCFS 9 Terminal value 10 Total 1,080 1,166| 1,260 1,469 <-- =F8"(1+$B$3) 25,713 <-- =G8"(1+B4)/(B5-B4) 27,183 <-- =G8+G9 1,360 1,080 1,166 1,260 1,360 11 12 Enterprise value 13 Add back initial cash 14 Subtract out debt 15 Equity value 16 Per share (1,000 shares) 20,933 <- =NPV(B5,C10:G10)*(1+B5)^0.5 2,000 <-- From current balance sheet 10,000 <-- From current balance sheet 12,933 <- =B12+B13-B14 12.93 <-- =B15/1000
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 87% (8 reviews)
1 Calculate the free cash flows FCFs for years 15 using the current FCF and the growth rate of FCF Y...View the full answer
Answered By
Adrian Kenneth De Vera
I've a lot of experience in different fields specifically in accounting, . mathematical analysis and creating poems besides other personal experiences.
0.00
0 Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
For the Dupit Corp. case study introduced in Section 11.4, the management science team was able to apply a variety of queueing models by making the following simplifying approximation. Except for the...
-
To make some extra money, youve started preparing templates of business forms and schedules for others to download from the Internet (for a small fee). After relevant information is entered into each...
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
Vito Co.'s next dividend is expected to be $4.50. Dividend growth is estimated at 20%, 15%, 8% for the following three years, and then stabilize to 2%. How much are you willing to pay to buy one...
-
In hypothesis testing, the common level of significance is = 0.05. Some might argue for a level of significance greater than 0.05. Suppose that web designers tested the proportion of potential web...
-
Liquid oxygen is stored in a thin-walled, spherical container 0.8 m in diameter, which is enclosed within a second thin-walled, spherical container 1.2 m in diameter. The opaque, diffuse, gray...
-
Determine which of 101 and 98 is larger, and express that using both the greater than and the less than notations.
-
The adjusted trial balance of Eastwood Company and other related information for the year 2012 are presented on the next page. Additional information:1. The LIFO method of inventory value is used.2....
-
Portsmouth Company makes upholstered furniture. Its only variable cost is direct materials. The demand for the company's products far exceeds its manufacturing capacity. The bottleneck (or...
-
Snookers Restaurant is open from 8:00 am to 10:00 pm daily. Besides the hours that they are open for business, workers are needed an hour before opening and an hour after closing for setup and...
-
The template for exercise 14 gives the 10-year history of Intels quarterly dividends. Compute Intels cost of equity r E using the Gordon dividend model. Compare the cost of equity computed on the...
-
Heres a basic exercise that will help you understand whats going on in the modeling of financial statements. Replicate the model in section 5.1. That is, enter the correct formulas for the cells and...
-
Refer to the Hamiltons Data Set. a. Compute the debt ratio at December 31, 2014. b. Is Hamiltons ability to pay its liabilities strong or weak? Explain your reasoning. Hamiltons Data Set Hamiltons, a...
-
On a peaceful neighborhood in Glendale live two types of people: those who like buying a Regular number of grapes, and those who like buying Many grapes. On any given day, any of the many stores in...
-
A manufacturing company submits the following information on 31.03.2013. Particulars Rs. Sales for the year 275,000 Inventories as on 1.4.2012 Materials 3,000 WIP 4,000 FG 8,000 Raw materials...
-
Allan and Hardyare in partnership. The following are the additional information and extracts from the Trail Balance at 31 December 2020and after the Gross profit had been calculated. Additional...
-
MARINA Bottlers Inc, a leading softdrinks company is producing their bottle requirements. For each case of 24 eight-ounce bottles, the company prescribed the following standard product mix: Material...
-
On July 1 , 2 0 2 3 the Meredith company signed a $ 4 0 , 0 0 0 noninterest - bearing note to purchase equipment. The $ 4 0 , 0 0 0 payment is due on September 1 , 2 0 2 5 . Assume that 8 % is a...
-
Suppose Becky has her choice of $10,000 at the end of each month for life or a single prize of $1.5 million. She is 35 years old and her life expectancy is 40 more years. (i) Find the present value...
-
Cleaning Service Company's Trial Balance on December 31, 2020 is as follows: Account name Debit Credit Cash 700 Supplies Pre-paid insurance Pre-paid office rent Equipment Accumulated depreciation -...
-
In your own words, explain economic needs and how they relate to the economic-buyer model of consumer behavior. Give an example of a purchase you recently made that is consistent with the economic...
-
Cut out or photocopy two recent advertisements: one full-page color ad from a magazine and one large display ad from a newspaper. In each case, indicate to which needs the ads appeal.
-
Explain how an understanding of consumers learning processes might affect marketing strategy planning. Give an example.
-
10. Energy from garbage using a black hole Define an advanced civilization as one that can carry out any engineering task not forbidden by the laws of physics. An advanced civilization wants to use a...
-
Dallas Jett Armstrong (Student section: 730) PHY184B, Spring 2024 - Physics for Scientists and Engineers II Main Menu Contents Grades Chat Syllabus Course Contents Chapter 28 28.86 2r 3r The loop...
-
When actions that squeeze or push on a rock are stronger in some directions than others, we call this Group of answer choices weathering. pressure. shear stress. differential stress
Study smarter with the SolutionInn App