Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLease do it on excel with formulas included ! 6. You are provided with the projected income statements for a project: Year 1 2 2

image text in transcribed

PLease do it on excel with formulas included !

6. You are provided with the projected income statements for a project: Year 1 2 2 Revenues $10,000 $11,000 $12,000 $13,000 - Cost of goods sold $4,000 $4,400 $4,400 $4,800 $5,200 - Depreciation $4,000 $3,000 $2,000 $1,000 = EBIT $2,000 $3,600 $5,200 $6,800 The tax rate is 40%. The project required an initial investment of $15,000 and an additional investment of $2,000 at the end of year 2. The working capital is anticipated to be 10% of rev- enues, and the working capital investment has to be made at the beginning of each period. a. Estimate the free cash flow to the firm for each of the four years. b. Estimate the payback period for investors in the firm. c. Estimate the NPV to investors in the firm, if the cost of capital is 12%. Would you accept the project? d. Estimate the IRR to investors in the firm. Would you accept the project

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

Financial Management

Authors: P V V Satyanarayana

1st Edition

9350568012, 9789350568019

More Books

Students also viewed these Finance questions

Question

When and how will strategy reviews take place?

Answered: 1 week ago

Question

Do you know how you will monitor progress?

Answered: 1 week ago