Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you explain this in detail how to do the calculations in excel. please! As an owner of a chocolate factory, you are considering an

Can you explain this in detail how to do the calculations in excel. please!

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?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sport Finance

Authors: Gil Fried, Timothy D. DeSchriver, Michael Mondello

4th Edition

1492559733, 978-1492559733

More Books

Students also viewed these Finance questions

Question

Compare value orientations among cultures

Answered: 1 week ago

Question

Discuss the relationship between culture and the built environment

Answered: 1 week ago