Question
Answered step-by-step

. Using the Base Case, calculate the annual sales growth for 2020E

using a weighted-moving average of the past three years' growth rates, with the most recent year given a weight of 3, the next given a weight of 2 and the oldest given a weight of 1. What is the growth rate? Use this rate (exact calculation) for the entire forecast period in the Base Case.
10.60%
9.40%
8.50%
7.60%
 
2.  Using the Base Case, calculate total depreciation expense for the year 2023E. Assume that depreciation expense on assets pre-2020E is $15,000 per year. Depreciation on capital expenditures made from 2020E-2024E assumes a 4-year useful life and a salvage value equal to 10% of the original cost.
$20,000
$30,000
$19,500
$33,000



3. Using the Base Case, calculate the change in non-cash working capital in 2024E.
-$2,446
$2,446
$1,322
-$1,322
 
 
 
 
 
4. Using the Low Case, calculate EBITDA in 2022E.
$25,634
$24,434
$43,634
$60,144
 
5. Using the Low Case, calculate the PP&E Turnover ratio for 2021E.
5.3x
0.5x
5.1x
2.4x
 
6. Using the High Case, calculate interest expense in 2021E.
$800
$1,200
$400
$829
 
7. Using the High Case, calculate the Debt-to-Total Capital ratio for 2020E.
0.10x
0.18x
0.15x
0.09x
8. Using the High Case, which of the following years has the lowest ROE?
2019
2018
2021E
2020E
 
9. 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
$599,446
$400,206
$454,756
$450,323
 
10. What is the weighted-average cost of capital (WACC) based on Company XYZ's current capitalization and comps values?
7.90%
9.00%
8.30%
9.50%
 
 
 
 
 
11. 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?
$314,050
$335,198
$342,156
$315,198
 
12. 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
$315,618
$305,618
$295,618
 
13. 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.51%
9.12%
8.88%
9.55%
 
14. What is the discount factor for a semi-annual coupon that will be received in 12 months if the quoted annual yield is 8%?
0.86
0.93
0.75
0.92

Answer & Explanation
Verified Solved by verified expert
<p>ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odi</p> Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer

, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacin


pulv

gue

facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pelle


ur laor


ipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus eff


inia p

gue

gue

gue

gue

gue

Step-by-step explanation

ia pulvinar tortor nec facilisis. Pellentesque da


risus

gue

icitur laoreet. Nam risus ante, dapibus a molestie consequat, ultri


ec f

squ

ng elit. Nam lacinia pulvinar tortor nec facilisis. Pellent


ipisci

gue

e vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit am


cong


, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis


ffici

gue

a. Fusce dui lectus, congue vel laoreet ac, dictum vi

s a molestie consequat, ultrices ac magna. Fusce dui lectus,

iscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam ri


ia pulvi

gue

usce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipi


nec

gue

gue

gue

gue

gue

m ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, da


ur laore

gue

a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit


Donec a

gue

entesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. P


ac,

gue

pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrice


e ve