Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please assist with solving problem in excel: Year 0 1 Revenue 630.00 Fixed costs 120.00 Variable costs 200.00 Add. investment in NWC 10.00 Add. investment

Please assist with solving problem in excel:

Year 0 1
Revenue 630.00
Fixed costs 120.00
Variable costs 200.00
Add. investment in NWC 10.00
Add. investment in operating long-term assets 70.00
Depreciation 60.00
Interest expenses 35.00
Newly issued debt 25.00
Principle repayments 15.00
Market value of the firm: Price
per share No. of shares Market value
Short-term debt 100.00
Long-term debt 600.00
Preferred stock 10.00 10 100.00
Common stock 18.00 100 1,800.00
Total 2,600.00
Cost of equity (Rs) 0.1400
Tax rate 0.40
Growth rate per year from year 1 through year 5 0.12
Growth rate after year 5 0.05

Based on the equity free cash flow model, what is the price per share for the common stock?

Select one:

a. 10.98

b. 14.34

c. 12.45

d. 16.39

Correct answer is 16.39

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

The Handbook Of Equity Market Anomalies

Authors: Leonard Zacks

1st Edition

0470905905, 978-0470905906

More Books

Students also viewed these Finance questions

Question

Assess three steps in the selection process.

Answered: 1 week ago

Question

Identify the steps in job analysis.

Answered: 1 week ago