Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assumptions Tax Rate Discount Rate Perpetural Growth Rate EVIEBITDA Mulliple Current Price Shares Outstanding 30% 11% 5% 8.5x 19.50 30,000 10 Discounted Cash Flow Year
Assumptions Tax Rate Discount Rate Perpetural Growth Rate EVIEBITDA Mulliple Current Price Shares Outstanding 30% 11% 5% 8.5x 19.50 30,000 10 Discounted Cash Flow Year 1 Year 2 Year 3 Year 4 Year 5 Exit Terminal Value EV/EBITDA Perp. Growth Average 306/2018 31/12/2018 31/12/2019 31/12/2020 31/12/2021 31/12/2022 31/12/2022 12 13 14 15 16 Time period Year frac EBIT EBITDA Unlevered FCFF Transaction FCFF 0.5 14,258 31,490 13,762 6,881 1.0 26,390 39,248 21,856 21.856 41,903 69,830 34,935 34,935 15,637 35,426 14,378 14,378 25,710 52,478 25,421 25,421 18 19 20 21 Intrinsic Enterprise Value Calculating terminal value and intrinsic value Please use the attached Excel file to answer the following questions. Business_Valuation Modeling Assessment.xlsx 18 Calculate the terminal value using the EV/EBITDA multiple method. Review Later 611,363 631,470 585,000 593,555 Calculating terminal value and intrinsic value Please use the atached Exce lie t answ the folowing questons Business_Valuation_Modeling Assessment.xlsx 9 Calculate the terminal value using the perpetual growth method. 611,363 593,555 631,470 585,000
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