Evaluate the following investment proposal.

All-Sweets Inc. is considering developing a new product, Stay-Slim-Choclate bars. To produce the choclate bars, a $150,000 investment in machinery is necessary. Machinery will be depreciated to a salvage value of zero. The lifetime of the newly introduced product is 5 years. Machinery is expected to be sold at the end of the lifetime for $10,000.

In the first year, an annual revenue of $90,000 is expected from the sale of Stay-Slim chocholate bars. Annual cash expense (expenses excluding depreciation) are expected to be 30% of revenues. Annual revenues are expected to increase by inflation rate, which is expected to be 5% annually over the next five years.

Before product launch, an investment in working capital is required (before the start of operations) and it is estimated to be 10 percent of next years sales level. Working capital will be recovered at the end of the product lifetime. In order to investigate the market response to the Stay-Slim product, an additional $18,000 was spent before seriously considering the investment alternative.

The firms tax rate is 25% and the required rate of return for this new product is 12%.

1. Calculate the total cash flows of the project. Show your work on a table consisting of cash flows from capital investments; cash flows from investments in working capital; cash flows from operations and resulting total cash flows as of the investment year and each of the five years of project lifetime.

2. Calculate the NPV and the IRR of the project.

3. Taking this form as the expected base case, design a sensitivity and a scenario analysis for the project and find the NPVs under your predictions. According to the results of your sensitivity and scenario analysis advise on the feasibility of the project.