Answered step by step
Verified Expert Solution
Question
1 Approved Answer
It will be great if I can have the working for the following answer if it is right (The answer might not be correct) My
It will be great if I can have the working for the following answer if it is right (The answer might not be correct)
My answer might not be correct but it will be great if someone else can correct me and show their working on how to get the answer
II (30) Points) Tiffany's financial advisor, Centerview Partners, performed a DCF valuation of Tiffany in its fairness opinion analysis. Centerview used an EBITDA multiple to compute the terminal value as of 2024. The high end of the EBITDA multiple it used was 18x management's expected EBITDA of $1,503 million in 2024. The revenue expected in 2024 was $6,042 million. You have been asked to compute the growth in perpetuity of net cash flows implied by the terminal value computed by Centerview. Centerview used a discount rate for its DCF analysis of 6%, which you have been asked to adopt in your analysis In perpetuity, the long-run EBITDA margin is expected to be 22%, the tax rate is 35%, deprecation is expected to 7% of EBITDA, the working capital ratio is --35, the nominal Return On Investment is 22%, and expected inflation is 2%. (Hint, you need to model the terminal value with a growth in perpetuity model and then use excel GOAL SEEK to solve for the G that yields the same Terminal value as computed by Centerview's multiple analysis. (your score on Question Il is based on the percentage deviation between your answer and the correct answer) Net cash flow = EBITDA* (1-tax rate) Sweet help Since, depreciation is not actual cash flow, that is not be considered, given figure is misleading. WC is also not required, above inputs are inserted into excel for goal seek. Real return = nominal - inflation = 22% -2% = 20% Terminal Value #1 (Perpetual Growth Method) [FCFN x (1 + g)] TV= (WACC - g) And asnwer is: 16.28% II (30) Points) Tiffany's financial advisor, Centerview Partners, performed a DCF valuation of Tiffany in its fairness opinion analysis. Centerview used an EBITDA multiple to compute the terminal value as of 2024. The high end of the EBITDA multiple it used was 18x management's expected EBITDA of $1,503 million in 2024. The revenue expected in 2024 was $6,042 million. You have been asked to compute the growth in perpetuity of net cash flows implied by the terminal value computed by Centerview. Centerview used a discount rate for its DCF analysis of 6%, which you have been asked to adopt in your analysis In perpetuity, the long-run EBITDA margin is expected to be 22%, the tax rate is 35%, deprecation is expected to 7% of EBITDA, the working capital ratio is --35, the nominal Return On Investment is 22%, and expected inflation is 2%. (Hint, you need to model the terminal value with a growth in perpetuity model and then use excel GOAL SEEK to solve for the G that yields the same Terminal value as computed by Centerview's multiple analysis. (your score on Question Il is based on the percentage deviation between your answer and the correct answer) Net cash flow = EBITDA* (1-tax rate) Sweet help Since, depreciation is not actual cash flow, that is not be considered, given figure is misleading. WC is also not required, above inputs are inserted into excel for goal seek. Real return = nominal - inflation = 22% -2% = 20% Terminal Value #1 (Perpetual Growth Method) [FCFN x (1 + g)] TV= (WACC - g) And asnwer is: 16.28%Step 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