Question
Q1 : Under the Base Case, what is the Terminal Value based on the average of: 1) The terminal value based on a perpetual growth
Q1 : Under the Base Case, what is the Terminal Value based on the average of:
1) The terminal value based on a perpetual growth rate, and;
2) The terminal value based on the EBITDA exit multiple assumptions outlined on the "Control Panel" tab
Q2: What is Company XYZ's intrinsic enterprise value under the High Case, using the WACC as the discount rate and assuming the terminal value is based on the perpetual growth rate assumption outlined on the "Control Panel" tab?
Q3: Fill out the Precedent Transaction table for missing data
Q4: Fill out the live case - $125 Mil Equity , $150 mil debt
Model Inputs and Assumptions General Assumptions Forecast Scenario Transaction Date Fiscal Year-End Days Per Year 8/1/2021 12/31/2021 365 Current Capitalization Cash-on-Hand $5,000 PP&E $60,000 Total Debt $35,000 Total Equity $100,000 Valuation Assumptions Tax Rate Perpetual Growth Rate EBITDA Exit Multiple Risk-Free Rate Equity Risk Premium Interest Rate Investment Amount 28% 2% 8.5x 3% 5% 4% $105,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