You are considering expanding your product line that currently consists of skateboards to include gas-powered skateboards, and you feel you can sell 8,000 of these per year for 10 years (after which time this project is expected to shut down with solar-powered skateboards taking over). The gas skateboards would sell for $80 each with variable costs of $45 for each one produced, while annual fixed costs associated with production $190,000. In addition, there would be a $1,200,000 initial 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 10 years. This project wil also require a one-time initial investment of $80,000 in 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 32 percent. 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 9? c. What is the terminal cash flow in year 10 (that is, what is the free cash flow in year 10 plus and additional cash flows associated with termination of the project? d. What is the project's NPV given a 9 percent required rate of return?

Please use my figures or post the excel spreadsheet so I can better understand