Answered step by step
Verified Expert Solution
Question
1 Approved Answer
the following are the datas and the questions related to the given data. please help!! ASAP!! Model Inputs and Assumptions Al Figures in USscoo's uness
the following are the datas and the questions related to the given data. please help!! ASAP!!
Model Inputs and Assumptions Al Figures in USscoo's uness otheruse stared. Model Inputs and Assumptions General Assumptions Transaction Date Fiscal Year-End Days Per Year \begin{tabular}{|r|} \hline 01012020 \\ \hline 31122020 \\ \hline 365 \\ \hline \end{tabular} Current Capitalization Cash-on-Hand PP\&E Total Debt Total Equity \begin{tabular}{|r|} \hline$10.000 \\ \hline$30.000 \\ \hline$20.000 \\ \hline$60.000 \\ \hline \end{tabular} Valuation Assumptions Tax Rate Perpetual Growh Rate Fiscal Year-End Days Per Year Caporale Finance insthite. All rights reserved faluation Analysis 1 A Corpomes Finance insthte. All rictis reserved 2 Valuation Analysis 43 2 Weighted-Average Cost of Capital (WACC) 3 Ar figures in ussoows untess onencos nawed 54 Comparable Companies Beta Comparable Trating Metrics 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 assumption outlined on the "Control Panel" tab $400,206 5454,756 5450.323 5599,446 Actreate Window) What is the weighted-average cost of capital (WACC) based on Company XYZ's current capitalization and comps values? 7.90% 9.50% 8.30% 9.00% What is Company XYZ's intrinsic equity value using the WACC as the discount rate and assuming the terminal value is based on the EBITDA exit multiple? $320,048 $315,309 $328,445 $315,198 11 Based on comparable trading metrics, what is the implied enterprise value if the median P/E ratio is used as the basis for valuation? $325,618 $305,618$295,618 $315,618 12 If an investment using the value implied by the median EV/EBITDA multiple from the comps is made at the transaction date, what is the implied IRR? Assume the terminal value is the average of the values determined using the perpetual growth rate and an EBITDA exit multiple. 9.55% 9.12% 9.51% 8.88% Model Inputs and Assumptions Al Figures in USscoo's uness otheruse stared. Model Inputs and Assumptions General Assumptions Transaction Date Fiscal Year-End Days Per Year \begin{tabular}{|r|} \hline 01012020 \\ \hline 31122020 \\ \hline 365 \\ \hline \end{tabular} Current Capitalization Cash-on-Hand PP\&E Total Debt Total Equity \begin{tabular}{|r|} \hline$10.000 \\ \hline$30.000 \\ \hline$20.000 \\ \hline$60.000 \\ \hline \end{tabular} Valuation Assumptions Tax Rate Perpetual Growh Rate Fiscal Year-End Days Per Year Caporale Finance insthite. All rights reserved faluation Analysis 1 A Corpomes Finance insthte. All rictis reserved 2 Valuation Analysis 43 2 Weighted-Average Cost of Capital (WACC) 3 Ar figures in ussoows untess onencos nawed 54 Comparable Companies Beta Comparable Trating Metrics 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 assumption outlined on the "Control Panel" tab $400,206 5454,756 5450.323 5599,446 Actreate Window) What is the weighted-average cost of capital (WACC) based on Company XYZ's current capitalization and comps values? 7.90% 9.50% 8.30% 9.00% What is Company XYZ's intrinsic equity value using the WACC as the discount rate and assuming the terminal value is based on the EBITDA exit multiple? $320,048 $315,309 $328,445 $315,198 11 Based on comparable trading metrics, what is the implied enterprise value if the median P/E ratio is used as the basis for valuation? $325,618 $305,618$295,618 $315,618 12 If an investment using the value implied by the median EV/EBITDA multiple from the comps is made at the transaction date, what is the implied IRR? Assume the terminal value is the average of the values determined using the perpetual growth rate and an EBITDA exit multiple. 9.55% 9.12% 9.51% 8.88% 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