Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

0 Page
Value Of The Asset

...

Course

ACCA10533

Subject

Finance

University

Nottingham Trent University

Season

Spring

3 Pages
23418 Economics of Money and Finance

1. explain the role played by money in the macroeconomy, the forces that affect the demand and supply of money,and various perspectives on how interest rates are determined in financial markets2. outl ...

Type

Essays

Subject

Finance

20 Pages
Business Information

Task 1 Using relevant sources of information write a critical analysis of the senior citizen music market and include in your discussion an explanation of nostalgia marketing and whether the internet ...

Type

Assignment

Subject

Finance

3 Pages
FNCE3004 International Finance

The CEO considers the investment in South Africa by entering into an agreement with Electo Co to expand the existing plant by investing ZAR120,000,000. The CEO believes MidTech should borrow the funds ...

Course

FNCE3004

Type

Home Work

Subject

Finance

University

Curtin University

EMBA602-Capital Allocation and Valuation

Question

Answered

Task

1. This problem requires you to estimate the WACC of a real company using publicly available data as of the fall of 2019. The company is Home Depot (Ticker: HD). You need to collect information as directed below. Here are the sources for the various data:

Look up market data on any recent day (unless otherwise specified) and use those in your calculations. Assume that the market value of debt is equal to its book value and that the tax rate is 25%. No need for any size adjustments. Problem Intent: To compute WACC of a company from published data.

Some of the data for following problems are provided in a separate spreadsheet on Canvas.

2. This problem is intended to show you the relation between free cash flows that we derive using the template for financial analysis and the accounting cash flow statement. Working out a problem will clarify the issue in a way no amount of lectures and explanations can.

We will do this at the company level. The key difference is that the free cash flow is the cash flow generated by the company’s operations after reinvesting in capital expenditure and working capital for the future but before any payouts are made to capital providers. Payouts to stockholders include dividends or stock repurchases, payouts to creditors include interest (and its tax effect) and principal payments. “Additions to Cash” is the cash left over after payouts to capital providers.

The accounting cash flow statement of a company for 20xx is provided in a separate spreadsheet. In addition, interest earnings from short-term investments and interest expense from debt (both from income statement) are provided. You may assume the tax rate for this problem as 25%. Estimate the expected free cash flow for 20xx using this statement. In your answer, clearly indicate the following:

NOPAT

Operating cash flow Free

cash flow

Problem Intent: To illustrate the link between accounting Statement Cash Flows and Free Cash Flow Template

3. Home Depot’s year-ending financial statements for 2018 & 2019 are provided in a separate spreadsheet. Some additional information, such as number of shares outstanding and share prices are also provided for the same dates. Notes are provided in the spreadsheet to help you classify certain balance sheet items (when it is unclear) as either financial or operational. You need to classify the others by yourself.

a. Construct end-of-year economic balance sheets for 2018 and 2019 based on market data provided.

b. Calculate the FCF for 2019. Assume profit from asset sale is zero.

c. What perpetual growth in free cash flows (FCF) does the market price of Home Depot imply? For uniformity, use a long-run WACC of 8.0% for Home Depot, which is consistent with a long-run risk-free rate of 3-4%. Note that 2019 FCF will be the Year 0 CF

Problem Intent: To illustrate construction of economic balance sheet from market data; to illustrate the use of economic balance sheet for valuation. 

4. Whitemarble, a private equity firm, is considering the acquisition of Craft, Inc., a publicly held all-equity firm. Craft currently derives all its sales from the US market. Whitemarble expects to create value by expanding Craft’s sales to China and improving the efficiency of its US operations. Specifically, Whitemarble expects the following opportunities for value creation:

China segment This segment will create revenue of $800 one year after the acquisition, and this revenue is expected to increase at an annual rate of 4% in perpetuity. The pre-tax operating margin (i.e., EBITDA margin) on this increased revenue will be 20%. Pre-tax operating margin = (Revenue − Cash costs)/Revenue. Whitemarble estimates that the present value in Year 0 of future capital expenditures will be $1,800. There will be no need for additional working capital. The tax rate for this segment is zero.

U.S. segment Improving efficiency will reduce annual cash costs by $400, starting one year after the acquisition, and the decrease will be perpetual. That is, the difference between post- and pre-acquisition cash costs of US operations each year will be $400, and this difference will 

exist in perpetuity. There will be no changes in capital expenditure or working capital. The tax rate for this segment is 25%. The WACC for both segments is 8%. Craft’s pre-acquisition stock price (before any news of acquisition became public) is $75 and it has 200 shares outstanding. What is Whitemarble’s breakeven price per share for Craft? Note that at the breakeven price the NPV of the acquisition to Whitemarble is zero

Problem Intent: To evaluate the value proposition in an acquisition.

5.Your company is planning the acquisition of Aldebaran Co. and wishes to estimate potential offering prices based on various multiples. The multiples you wish to use are P/E, Price to Book, Price to Revenue, and Enterprise Value to EBITDA. You have identified the recent acquisition of Orion Co. by another acquirer as a comparable acquisition and plan to use the transaction multiples from the Orion acquisition to estimate potential offer prices for Aldebaran (in practice you will use several comparable acquisitions, but for the purposes of this assignment one will suffice). The financial statements of Aldebaran and Orion and other relevant information are provided in a separate spreadsheet. For Aldebaran, assume: 1) No surplus cash; 2) Market value of long-term financial investments equals book value.

Calculate potential offer prices using each of the four multiples.

Problem Intent: To illustrate the use of multiples for valuation.

EMBA602-Capital Allocation and Valuation

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

23 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com is diligent to fulfil students needs in the best possible manner by providing both thesis writing services and thesis editing services. We boast separate teams of thesis writing experts and editors who handle the students requests like can anyone do editing of my thesis online or can someone write my thesis online. Thus, we have gained the status of being the most efficient and reliable thesis help provider company in USA.

More EMBA602 EMBA602-Capital Allocation and Valuation: Questions & Answers

Q
icon

We aren't endorsed by this University

Value Of The Asset

...

View Answer
Q

23418 Economics of Money and Finance

1. explain the role played by money in the macroeconomy, the forces that affect the demand and supply of money,and various perspectives on how interest rates are determined in financial markets2. outline the major explanations for financial crises, their causes, and their effects on the real economy ...

View Answer
Q

Business Information

Task 1 Using relevant sources of information write a critical analysis of the senior citizen music market and include in your discussion an explanation of nostalgia marketing and whether the internet should play a major role in the marketing of Jonnie’s work in the future. Include a list of re ...

View Answer
Q
icon

We aren't endorsed by this University

FNCE3004 International Finance

The CEO considers the investment in South Africa by entering into an agreement with Electo Co to expand the existing plant by investing ZAR120,000,000. The CEO believes MidTech should borrow the funds in US$ at a fixed rate from a bank in the U.S.A. and convert it into ZAR for investment. For this p ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?