Question: Please show i can get this answer using excel. What is the price per share based on the equity free cash fl Year 1: Revenue:

Please show i can get this answer using excel. What is

Please show i can get this answer using excel.

What is the price per share based on the equity free cash fl Year 1: Revenue: 630 Fixed costs: 120 Variable costs: 200 Additional investments in NWC: 10 Additional investments in operating long-term assets: 70 Depreciation: 60 Interest expenses: 35 Newly issued debt: 25 Principal repayment: 15 Cost of equity, Rs: 0.14 Corporate tax rate: 0.40 Growth rate per year: From year 1 through year 5: 0.12 After year 5: 0.05 Market value: Short-term debt: 100 Long-term debt: 600 Common Stock: Market price per share: 18 Number of shares: 100 Select one: a. $13.09 b. $16.39 c. $15.33 d. $14.21 The correct answer is: $16.39

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!

Draw (approximately) the moment diagram for member ACE of the portal constructed with a rigid member EG and knee braces CF and DH. Assume that all points of connection are pins. Also determine the...

Can you show me using excel calculations please? What is the price per share based on the equity free cash flow model? Year 1: Revenue: 630 Fixed costs: 120 Variable costs: 200 Additional investments...

What is the price per share based on the equity free cash flow model? Year 1 Revenue: 630 Fixed costs: 120 Variable costs: 200 Additional investments in NWC: 10 Additional investments in operating...

What is the price per share based on the equity free cash flow model? Year 1: Revenue: 630 Fixed costs: 120 Variable costs: 200 Additional investments in NWC: 10 Additional investments in operating...

Based on the equity free cash flow model, what is the price per share for the common stock? Year 1 Revenue 630 Fixed costs 120 Variable costs 200 Add. investment in NWC 10 Add. investment in...

. What is the price per share based on the equity free cash flow model? Year 1: Revenue: 630 Fixed costs: 120 Variable costs: 200 Additional investments in NWC: 10 Additional investments in opera...

Need help finishing the excel document please !! (: (provided screenshots of the excel document, formulas, and statements for both companies) You are a bank loan manager and you have had two companys...

Based on the following information, what is the stock price per share according to the equity free cash flow model? Year 1: Revenue: 650 Fixed Costs: 120 Variable costs: 200 Additional investments in...

Need some assistance finishing the excel document please !! (: (provided screenshots of the excel document, formulas, and statements for both companies) You are a bank loan manager and you have have...

A recent new article, A Clunky Mask May Be the Answer to Airborne Disease and N95 Waste, describes how during the pandemic an incredibly large number of N95 masks were used and disposed of by medical...

Data from Aswath Damodaran, a New York University finance professor, shows that, since 1928, U.S. stocks returned about 9.5% per year, compared with only 4.9% for 10-year Treasury bonds and 3.5% for...

7 . Assume that Cane normally produces and sells 4 1 , 0 0 0 Betas per year. What is the financial advantage ( disadvantage ) of discontinuing the Beta product line? 8 . Assume that Cane normally...

You have a chance to buy an annuity that pays $6,917 at the beginning of each year for 4 years. You could earn 7% on your money in other investments with equal risk. What is the most you should pay...

6-17 Identify the five problems of a traditional file environment and explain how a database management system solves them.

6-15 Identify some of the business intelligence features included in SAPs business software suite. The Lego Group, which is headquartered in Billund, Denmark, is one of the largest toy manufacturers...

6-18 Discuss how the following facilitate the management of big data: Hadoop, in-memory computing, analytic platforms.