Question: 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:

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 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. $16.39 b. $14.21 c. $13.09 d. $15.33

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!

Required information Appendix A Continuing Payroll Project: Wayland Custom Woodworking (1 Month, Part 2) (Static) [The following information applies to the questions displayed below] Wayland Custom...

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...

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...

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...

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 opera...

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

Hi I was hoping to get help with question 7 Based on the following information, what is the stock price per share according to the equity free cash flow model? Year 0 1 Revenue 600.00 Fixed costs...

text Based on the following information, what is the stock price per share according to the equity free cash flow model? Year 0 1 Revenue 600.00 Fixed costs 100.00 Variable costs 200.00 Add....

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Estimate a current stock price for Montana Corporation using the following information. Projected free cash flows for the next three years are shown in the table below. Assume the growth rate in...

What Canadian products can be sold in Mongolia, based on Mongolia's culture, environment, values, and beliefs?

The purchase of an intangible asset is classified in the statement of cash flows as

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...