**PLEASE SHOW HOW TO GET EXACT CALCULATIONS WITH EXCEL (EXCEL FORMULAS) - THANK YOU! I WILL GIVE GOOD RATING WITH THE FORMULAS.

As an owner of a chocolate factory, you are considering an investment in the production of a new candy bar called Coconut Freedom. The introduction of the candy bar requires an immediate investment in 400 new machines costing $10,000 each. Installing the machines costs an additional $2,000 per machine. The machines will be depreciated over the four years of projects life based on the following MACRS schedule: year 1: 33.33%; year 2: 44.45%; year 3: 14.81%; year 4: 7.41%.

The life of the project is estimated to be 4 years, after which each machine will be sold for $1,000 at the end of year 4.

The project also requires an immediate investment in net working capital in the amount of $500,000, which will be fully recovered at the end of year 4. To evaluate the appeal of Coconut Freedom to consumers, you have already completed a pilot tasting experiment, which cost you $100,000.

You expect to sell 2,000,000 chocolate bars each year during the projects life at the price of $2.50 per bar. Production costs are estimated to be $0.50 per candy bar.

In addition to these variable costs, you expect to incur $1,000,000 per year in advertising expenditures to support the sales of Coconut Freedom.

Finally, the results of your study indicate that the introduction of Coconut Freedom will cannibalize the sales of other chocolate bars currently produced by your firm and erode their combined after-tax cash flow by $200,000 per year. All cash flows occur at year-end.

If the discount rate is 15%, and the tax rate is 20%, please compute the NPV, the IRR, and the regular payback period (in years and months) for this project. Should the company go ahead with this investment?