*I'm not sure how to calculate NPV or IRR in the problem below or what to do with the $220,000 in the second question at the end to tell if the NPV or IRR has changed. Also, how do you tell if you should approve the project or not by looking at the NPV and IRR.* Please help!!

John Smith is looking to open an ice-cream parlor place in the neighborhood where he resides. He has been thinking about this project for a while. He has completed the technical, legal, and economic feasibility studies in order to decide properly. The economic study presented him with the following financial forecasts:

• The project will last 5 years.

• The price of an average creamery ice-cream cone should be $6 per unit. Under the current conditions, it is not expected that the price will change over the life of the project.

• The store is expected to sell 20,000 units the first year, with an annual growth of 5% in the units sold.

• The main variable costs are waffle cones, ice-cream, toppings, whipped cream, chocolate fudge, disposable cups, napkins and plastic spoons. The economic study has also found that the variable costs should be 40% of the sales revenues.

• The main fixed costs are rent ($10,000/year), utilities ($5,000/year), and gross salaries for two part-time employees ($10,000/year). In summary, it is expected that the fixed costs will be $25,000 per year. It is not expected that those fixed costs will change considerably over the life of the project.

• The initial investment has to finance the purchase of the refrigerators, freezers, furniture for customers (tables and chairs), the cash register, and some long-term kitchen tools. It is expected that the capital expenditures should cost $200,000.

• The project has to purchase its first batch of inventory (waffle cones, ice-cream, napkins, etc.) in order to begin selling ice-cream units as soon as the business starts to operate. At the moment of the inventory purchase (t=0), the creamery has not generated any income, because it is not in operation yet, but still it has to pay to its providers in the short-term. The required initial investment in inventory (change net operating working capital) is expected to be $20,000 and it will be fully financed with cash.

• The IRS has stated that the refrigerator and freezer and other long-term assets should be depreciated linearly in 5 years, that is, 20% each year.

• The corporate income tax rate is 40% of profits.

• The residual inventory at the year of closing the project should be sold at the same price of its purchase. Therefore, it does not generate taxable capital gains.

• The salvage value of the capital expenditures at the closing year is $100,000. That is, the market price at which the business can expect to receive for selling the refrigerator, the freezer and the furniture, at the moment of closing the project.

• The weighted average cost of capital (WACC) is 8%.

I need help with these | | |

v v v

• Compute NPV and IRR of the project. Would you approve this project?
• If you ask a bank for a loan (with interest) of $220,000 in order to pay for your initial investments, does it change the NPV and IRR of the project?