Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

data below O Use the Terminal Tutorial to calculate Disney's weighted average cost of capital (WACC) for Q1 2019. Bloomberg includes more elements in the

image text in transcribed

data below

image text in transcribedimage text in transcribed

O Use the Terminal Tutorial to calculate Disney's weighted average cost of capital (WACC) for Q1 2019. Bloomberg includes more elements in the WACC calculation than the textbook does. For our purposes, use the textbook formula with the data points from Bloomberg. Use the Bloomberg Terminal to gather the necessary data to make a similar calculation for Q2 2019. WACC Cost of Capital Components Expected Return Risk Free Pre-Tax of Market Rate Tax Rate Debt Cost Bond Rating Capital Structure Components Short-Term Long-Term Equity Debt Debt Total Capital Beta Target Disney 0.96 9.6% 2.4% 21.8% 3.0% . 248,699 21,923 36.311 306,933 Parks and Resorts Six Flags B+ 19 0.89 0.77 9.6% 9.6% 2.4% 2.4% 24.2% 17.0% 4.2% 4.8% 4,190 2,699 2,467 2,150 6,676 4,857 Cedar Fair B+ 8 Studio Entertainment Lions Gate 1.21 9.6% 2.4% 0.0% 4.3% B- 2,666 439 2,838 5,943 Broadcasting and Media Viacom 1.1 Netflix 1.46 9.6% 9.6% 2.4% 2.4% 22.0% 17.7% 4.5% BBB- 2.6% BB- 12,059 160,826 320 138 8,638 13,541 21.017 174,505 Consumer Products ULTA Sally Beauty Game Stop 0.86 0.81 0.92 9.6% 9.6% 9.6% 2.4% 2.4% 2.4% 22.7% 25.7% 23.5% 2.5% 6.9% 5.9% BB BB- 20,034 1,603 918 211 21 250 1,654 1,560 1,022 21,899 3,184 2,190 WAAC ELEMENTS OF DISNEY Q2 2019 ALL DATA Metric Beta Expected Return of the Market Risk Free Rate Tax Rate Pre-Tax Cost of Debt Value 0.88 9.64% 2.41% 21.83% 2.99% Metric Equity Preferred Equity Short-Term Debt Long-Term Debt Total Capital Value 197,744 0 19,158 37,803 254,705 O Use the Terminal Tutorial to calculate Disney's weighted average cost of capital (WACC) for Q1 2019. Bloomberg includes more elements in the WACC calculation than the textbook does. For our purposes, use the textbook formula with the data points from Bloomberg. Use the Bloomberg Terminal to gather the necessary data to make a similar calculation for Q2 2019. WACC Cost of Capital Components Expected Return Risk Free Pre-Tax of Market Rate Tax Rate Debt Cost Bond Rating Capital Structure Components Short-Term Long-Term Equity Debt Debt Total Capital Beta Target Disney 0.96 9.6% 2.4% 21.8% 3.0% . 248,699 21,923 36.311 306,933 Parks and Resorts Six Flags B+ 19 0.89 0.77 9.6% 9.6% 2.4% 2.4% 24.2% 17.0% 4.2% 4.8% 4,190 2,699 2,467 2,150 6,676 4,857 Cedar Fair B+ 8 Studio Entertainment Lions Gate 1.21 9.6% 2.4% 0.0% 4.3% B- 2,666 439 2,838 5,943 Broadcasting and Media Viacom 1.1 Netflix 1.46 9.6% 9.6% 2.4% 2.4% 22.0% 17.7% 4.5% BBB- 2.6% BB- 12,059 160,826 320 138 8,638 13,541 21.017 174,505 Consumer Products ULTA Sally Beauty Game Stop 0.86 0.81 0.92 9.6% 9.6% 9.6% 2.4% 2.4% 2.4% 22.7% 25.7% 23.5% 2.5% 6.9% 5.9% BB BB- 20,034 1,603 918 211 21 250 1,654 1,560 1,022 21,899 3,184 2,190 WAAC ELEMENTS OF DISNEY Q2 2019 ALL DATA Metric Beta Expected Return of the Market Risk Free Rate Tax Rate Pre-Tax Cost of Debt Value 0.88 9.64% 2.41% 21.83% 2.99% Metric Equity Preferred Equity Short-Term Debt Long-Term Debt Total Capital Value 197,744 0 19,158 37,803 254,705

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Accounting Texts and Cases

Authors: Robert Anthony, David Hawkins, Kenneth Merchant

13th edition

978-1259097126

Students also viewed these Finance questions