Question
*I'm not sure how to compute IRR or NPV and I don't know what to do with the $220,000 in the second part of the
*I'm not sure how to compute IRR or NPV and I don't know what to do with the $220,000 in the second part of the question*
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%.
With this information, answer in the order given:
- 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?
*I'm not sure how to compute IRR or NPV and I don't know what to do with the $220,000 in the second part of the question*
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started