Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

****PLEASE SHOW EXCEL FORMULA**** You are provided with the projected income statements for a project: Year 1 2 3 4 Revenues $25,000 $26,250 $27,563 $28,941

****PLEASE SHOW EXCEL FORMULA****

You are provided with the projected income statements for a project:

Year

1

2

3

4

Revenues

$25,000

$26,250

$27,563

$28,941

- Cost of Goods Sold

13,750

14,438

15,160

15,918

- Depreciation

6,800

5,100

3,400

1,700

equals EBIT

$4,450

$6,712

$9,003

$11,323

The tax rate is 40%. The project required an initial investment of $17,000 and an additional investment of $1,000 at the end of year 2. The working capital is anticipated to be 5% of revenues, and the working capital investment has to be made at the beginning of each period. Assume that the cost of capital is 9%. What is the IRR? (answer format: 12.34%, 0.1234, or .1234)

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

Labour Finance And Inequality

Authors: Suzanne J. Konzelmann, Simon Deakin, Marc Fovargue-Davies, Frank Wilkinson

1st Edition

1138919721, 978-1138919723

More Books

Students also viewed these Finance questions

Question

Identify the different methods employed in the selection process.

Answered: 1 week ago

Question

Demonstrate the difference between ability and personality tests.

Answered: 1 week ago