Answered step by step
Verified Expert Solution
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
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 projectStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started