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 with AI-Powered 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

Students also viewed these Finance questions