PLEASE EXPLAIN IN EXCEL. MAKE SURE TO USE THE NUMBERS I PUT, NOT TO COPY FROM SOME OTHER PLACE.(Calculating free cash flows)

You are considering new elliptical trainers and you feel you can sell 6,000of these per year for 5years (after which time this project is expected to shut down when it is learned that being fit is unhealthy).

The elliptical trainers would sell for $1,600each and have a variable cost of $800each.

The annual fixed costs associated with production would be $1,000,000.

In addition, there would be a $3,000,000initial expenditure associated with the purchase of new production equipment.

It is assumed that this initial expenditure will be depreciated using the simplified straight-line method down to zero over 5years.

This project will also require a one-time initial investment of $1,500,000in net working capital associated with inventory, and that working capital investment will be recovered when the project is shut down.

Finally, assume that the firm's marginal tax rate is 35percent.

a.What is the initial outlay associated with this project?

b.What are the annual free cash flows associated with this project for years 1 through 4?

c.What is the terminal cash flow in year 5(that is, what is the free cash flow in year 5plus any additional cash flows associated with the termination of the project)?

d.What is the project'sNPV given a required rate of return of 9percent?