Answered step by step
Verified Expert Solution
Link Copied!

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!!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Franchising An Accounting Auditing And Income Tax Guide

Authors: Ross A. McCallum

2011edition

1460906179, 978-1460906170

More Books

Students also viewed these Accounting questions

Question

Find k such that x + 3 is a factor of x3 + kx2 + kx - 15?

Answered: 1 week ago