Could you please be more specific from where to get $7,600.000 in Yearly cash flow. Can you upload the excel spread sheet to see the formula.

XYZ Ltd. has developed a newproduct which is expected to have a life of five years before it becomes obsolete. The project would be terminated after five years. The plant and equipment isexpected to have a salvage value of $500,000 at the end of the project's life. The company is in the tax bracketof30 per cent andrequired return for this project is 15 per cent. XYZ Ltd. has put together the following information about the product:

Cost of new plant and equipment $7,900,000

Transport and installation costs $100,000.

Unit Sales:

Year Units Sold

170,000

2120,000

3140,000

480,000

560,000

Sales Price per Unit:

Years 1-4 $300

Year 5 $260

Variable Cost per Unit$180

Annual Fixed Costs $200,000

Net Working Capital:

An initial investment of $100,000 in net working capital is required to start the project. Additionally, net working capital equal to 10 per cent of the value of sales will be required each year including year one.

a) Calculate the yearly cash flows and the yearly net after-tax cash flow related tothe project

b) Calculate the Net Present Value

Answers:

Depreciation will be added back in Net income to calculate Cash flow

Yearly Cash flow

-7600000

6100000

10600000

12400000

7000000

3540000

Net After Cash flow

-7600000

4090000

6790000

7870000

4630000

2610000

Net Present Value

10210239