Milestone One: Time Value of Money * Dollar amounts are in millions $ (please fill in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Milestone One: Time Value of Money * Dollar amounts are in millions $ (please fill in YELLOW cells) Question 1. Interest Rate FCF Years FCF in dollars* Py* 5% Instructions and Explanations 2022 2021 2020 $ 5,855.00 $ 7,157.00 $ 6,428.00 $ (5,576.19) $ (6,491.61) $ (5,552.75) Free cash flows (FCF), for this exercise is difference between cash generated from operating income minus capital expenses at the end of your company's fiscal or calendar year. The present value of free cash flows is one method of determining a company's value to a potential buyer. Note: For Milestone One, please use the adjusted free cash flows calculated for your selected company on Tab 2 (Selected Co. for Project) of this Excel workbook. Use 5% as the interest rate for these questions. Total Pv* $ (17,620.55) *In millions Question 2. Interest Rate FCF-Years FCF in dollars* Pv* Total Pv* *In millions 5% 2022 $ 5,855.00 $ 2021 7,157.00 $ 2020 6,428.00 $ (5,576.19) $ (6,491.61) $ (5,552.75) $ (17,620.55) For the purpose of this exercise, what will happen to the total PV if your selected company's free cash flows for each year reported in Question 1 were reduced by 10%? Question 3. Interest Rate 7% Required Rate of Return for Risk Associated With Projected Future Three Year's Free Cash Flows. 2022 2021 2020 FCF - Years FCF in dollars* Pv* *In millions Total Pv* 5% Most Recent Year's Cash Flow fom Queston 1. 2023 $ 5,855.00 $ 7,157.00 $ 6,428.00 $5,855.00 $ (6,007.48) $ (6,251.20) $ (5,247.16) $ (5,576.19) $ (17,505.84) Your selected company is projecting that free cash flows for the next three (3) years will increase by 3% annually. Using the Most Recent Year's free cash flows from Question 1 above, increase each of the future free cash flows by 3% (will self-populate in the yellow highlighted cells). As there is a chance that these increases may not occur as projected, a buyer who may be willing to purchase the company before the increases occur, will account for this risk by using a required rate of return of 7%. What price would the potential buyer be willing to pay based upon the known free cash flows and the future projected free cash flows? Milestone One: Time Value of Money * Dollar amounts are in millions $ (please fill in YELLOW cells) Question 1. Interest Rate FCF Years FCF in dollars* Py* 5% Instructions and Explanations 2022 2021 2020 $ 5,855.00 $ 7,157.00 $ 6,428.00 $ (5,576.19) $ (6,491.61) $ (5,552.75) Free cash flows (FCF), for this exercise is difference between cash generated from operating income minus capital expenses at the end of your company's fiscal or calendar year. The present value of free cash flows is one method of determining a company's value to a potential buyer. Note: For Milestone One, please use the adjusted free cash flows calculated for your selected company on Tab 2 (Selected Co. for Project) of this Excel workbook. Use 5% as the interest rate for these questions. Total Pv* $ (17,620.55) *In millions Question 2. Interest Rate FCF-Years FCF in dollars* Pv* Total Pv* *In millions 5% 2022 $ 5,855.00 $ 2021 7,157.00 $ 2020 6,428.00 $ (5,576.19) $ (6,491.61) $ (5,552.75) $ (17,620.55) For the purpose of this exercise, what will happen to the total PV if your selected company's free cash flows for each year reported in Question 1 were reduced by 10%? Question 3. Interest Rate 7% Required Rate of Return for Risk Associated With Projected Future Three Year's Free Cash Flows. 2022 2021 2020 FCF - Years FCF in dollars* Pv* *In millions Total Pv* 5% Most Recent Year's Cash Flow fom Queston 1. 2023 $ 5,855.00 $ 7,157.00 $ 6,428.00 $5,855.00 $ (6,007.48) $ (6,251.20) $ (5,247.16) $ (5,576.19) $ (17,505.84) Your selected company is projecting that free cash flows for the next three (3) years will increase by 3% annually. Using the Most Recent Year's free cash flows from Question 1 above, increase each of the future free cash flows by 3% (will self-populate in the yellow highlighted cells). As there is a chance that these increases may not occur as projected, a buyer who may be willing to purchase the company before the increases occur, will account for this risk by using a required rate of return of 7%. What price would the potential buyer be willing to pay based upon the known free cash flows and the future projected free cash flows?
Expert Answer:
Answer rating: 100% (QA)
To calculate the present value PV of the future projected free cash flows and determine the price th... View the full answer
Related Book For
Using Financial Accounting Information The Alternative to Debits and Credits
ISBN: 978-1133161646
7th Edition
Authors: Gary A. Porter, Curtis L. Norton
Posted Date:
Students also viewed these finance questions
-
What variables (i.e., interest rates, inflation, unemployment, and so forth) impact PepsiCo financial decision and strategic objectives. Scenario: You have been hired by a prominent financial...
-
Find the magnitude of the reaction at A and the tension in cable CD using (a) the con- cepts of three-force bodies (closed polygon method discussed in chapter 2). (b) Check your answers by doing sum...
-
Write a balanced equation for each of the following reactions: (a) Diborane reacts with water to form boric acid and molecular hydrogen. (b) Upon heating, boric acid undergoes a condensation reaction...
-
As shown, water (15C) is flowing from a tank through a tube and then discharging to ambient. The tube has an ID of 8 mm and a length of L = 6 m, and the resistance coefficient is f = 0.015. The water...
-
Could an extend use case have a primary actor? Explain.
-
Refer to question 10. Suppose that the consultants fee is $5,000 and the utility function for the owner of Morley Properties can be approximated by the exponential utility function: U(x) = 1 e-x/R...
-
(b) What risk factors might pertain to a private equity investment in the pandemic? (9 marks) (c) Explain how a MBO deal is usually structured both in terms of its corporate/legal structure and its...
-
T.L. Franklin Corporation has three costs: A, which is variable; B, which is fixed; and C, which is semivariable. The company uses the high-low method and extracted the following data from its...
-
Using examples from business practice to illustrate your answer, what do you understand by: (a) an associative hierarchy; and (b) mnemonics?
-
Discuss the signifcance of workplace counselling as a technique for coping with stress.
-
Comment on the nature of confict between the organizational role and the family role and refer to the pressures related to dual-career households.
-
With reference to decision-making groups, explain the following with examples from business practice: (a) group discussion; (b) risky shift and cautious shift; (c) team think; and (d) groupthink.
-
Comment Briefy on the relevance of the following factors in the context of stress originating from within the organization: (a) machine-paced/repetitive work; (b) decision latitude/job control; (c)...
-
What is the opportunity cost?
-
Why should you not model a decision variable as a random variable with a probability distribution?
-
Has the concept of SD achieved the balance between all three pillars: environmental protection; economic development; and social issues?
-
Please reflect on and explain the role and usefulness of the concept of SD in relation to the protection of the environment.
-
How many dimensions of the PSNR principle can you enumerate? To which one does UN Resolution 1803(1962) refer?
Study smarter with the SolutionInn App