1) Calculate the operating cash flow for each year of the project

2) calculate the initial investmest of the project

3)calculate the terminal cash flow of the project

4) calculate the cash flow from assets for each year of the project

5) calculate the projects NPV and IRR

please attach the excel formulas. Thank you

Your company produces candy and considers introducing a new flavor. A year ago, the company spent $15,900 on a marketing survey to learn about consumer interest in this flavor. If this new type of a candy is produced and offered for sale, the estimated revenue in Year 1 is $380,000. Sales are forecasted to grow at a rate of 2.70% per year. Incremental variable costs are expected to be 60% of incremental revenues. The net working capital in Year 0 is expected to be $72,000 with a full recovery at the end of the project. This project requires an immediate investment of $367,000 in equipment. The equipment is to be depreciated over 10 years on a straight-line basis to zero value. The new candy flavor will be discontinued in 5 years, and the project will end. At the end of this project, the equipment will be sold for $156,000. The tax rate is 22%, and the required rate of retum is 18%