Question: Question 1. Calculate the corporate value and equity value for JD by using shareholder value analysis. Data have shown below: Sales Growth 15% per annum

Question 1. Calculate the corporate value and equity value for JD by using shareholder value analysis. Data have shown below:

Sales Growth	15%	per annum
Operating Profit Margin	13%	of sales
Change in CAPEX	12%	of the change in sales
Change in Net Working Capital	10%	of the change in sales
Planning Horizon	5	years

Sales in 2020 were 3,000,000 and face a tax rate of 25%. Risk free rate =3%, market risk premium = 6%, equity beta = 1.5, debt rate = 7%, target capital gearing level of 30% debt in its capital structure, marketable securities = 500,000, debt = 1,750,000.

Assumed that growth will stop after year 5 and there will be no more Capex nor net working capital requirements. Sales growth will be zero and the profit margin and tax rate will remain the same. Assume that the cash flows will continue forever.

If using excel, with formulas, please.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

2 21-39 Replacement of a machine, income taxes, sensitivity. (CMA, adapted) The Kuhl Brothers own a frozen custard ice cream shop. The brothers currently are using a machine that has been in use for...

mostly needing part two the three questions being solved:-) GameShop is going through a fast growth period, which is expected to end after 5 years. The GameShop value drivers are shown below; Sales...

GameShop is going through a fast growth period, which is expected to end after 5 years. The GameShop value drivers are shown below; Sales Growth 15% per annum Operating profit margin 13% of sales...

1 question (70%) The Bergeson Corporation sold its shares to the general public in 2019. The firm's estimated free cash flow for the next four year is as follows: Given: Sales growth for years 1-3...

3. Question (35%). The company Twist Again PLC (data are given below) needs to know Market Value added (MVA); Shareholders' value added (SVA), Economic Value Added (EVA), Firm Value, and future price...

Step 1: Data Collection Please locate and record the following pieces of information using Yahool Finance. Though you may record the information below for now, it will eventually need to be...

Part C:WACC and Capital Budgeting Calculate the firm's WACC (using 2018 numbers). (You will need to collect information on the long-term debt and common stock equity from the Balance Sheet. The firm...

i humbky request anybody to help me with these questions and provide answers. At the stated yield to maturity, what was a fair value as of December 17th2017(ex coupon price)? HOME DEPOT INC As of...

Please answer Question 1 (max loan, max down payment/ equity and Total offering price using) using information in parts 1-7(first image) as well as the diagram I have attached (second image). Then...

Details and Rubric Prepare this Assignment responding to the problems as a Word document. Number each question, followed by your answer. Problems: 1. Complete problem: Total Net Operating Capital...

Rollins Publishing needs to decide what textbooks from the table at the top of the next column to publish. For each book, the maximum demand, fixed cost of publishing, variable cost, and selling...

Assume at 30th June 2020, Assets, Liability, Equity, Income and Expense amounts for Giraffe Building Renovation are presented below: Cash in Bank 70,000 Accounts receivable 251,000 Supplies 300,000...

An investor may demand a higher yield on a bond if: The bond is perceived as lower risk. The bond has a very short time to maturity. There are higher inflation expectations that could erode returns....

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".