Math Problem Statement

​(Calculating NPV) Big​ Steve's Swizzle Sticks is considering the purchase of a new plastic stamping machine. This investment will require an initial outlay of ​$100 comma 000 and will generate net cash inflows of ​$20 comma 000 per year for 8 years. a. What is the​ project's NPV using a discount rate of 12 percent​? Should the project be​ accepted? Why or why​ not? b. What is the​ project's NPV using a discount rate of 13 ​percent? Should the project be​ accepted? Why or why​ not? c. What is this​ project's IRR? Should the project be​ accepted? Why or why​ not? Question content area bottom Part 1 a. If the discount rate is 12 ​percent, then the​ project's NPV is ​$    enter your response here. ​(Round to the nearest​ dollar.) Part 2 The project ▼ should not be should be accepted because the NPV is ▼ positive negative ​and, therefore, ▼ does not add adds value to the firm.  ​(Select from the​ drop-down menus.)      Part 3 b. If the discount rate is 13 ​percent, then the​ project's NPV is ​$    enter your response here. ​(Round to the nearest​ dollar.) Part 4 The project ▼ should not be should be accepted because the NPV is ▼ positive negative ​and, therefore, ▼ does not add adds value to the firm.  ​(Select from the​ drop-down menus.)      Part 5 c. This​ project's internal rate of return is    enter your response here​%. ​(Round to two decimal​ places.) Part 6 If the​ project's required discount rate is 12​%, then the project ▼ should not be should be accepted because the IRR is ▼ lower than higher than the required discount rate.  ​(Select from the​ drop-down menus.)      Part 7 If the​ project's required discount rate is 13​%, then the project ▼ should not be should be accepted because the IRR is ▼ lower than higher than the required discount rate.  ​(Select from the​ drop-down menus.)  

Solution

To solve this, let's work through each part step by step.

Part a: NPV with a 12% discount rate

The Net Present Value (NPV) formula is:

NPV=Ct(1+r)tC0NPV = \sum \frac{C_t}{(1 + r)^t} - C_0

Where:

  • CtC_t = Cash inflow at time tt
  • rr = Discount rate (12% = 0.12)
  • tt = Time period
  • C0C_0 = Initial investment (100,000)

We know the following:

  • Initial outlay: C0=100,000C_0 = 100,000
  • Cash inflows per year: Ct=20,000C_t = 20,000
  • Project duration: 8 years
  • Discount rate: 12%

The formula for NPV becomes:

NPV=100,000+t=1820,000(1+0.12)tNPV = -100,000 + \sum_{t=1}^{8} \frac{20,000}{(1 + 0.12)^t}

Let's calculate this sum:

NPV=100,000+20,000(11.121+11.122++11.128)NPV = -100,000 + 20,000 \left( \frac{1}{1.12^1} + \frac{1}{1.12^2} + \dots + \frac{1}{1.12^8} \right)

We can use the present value of an annuity formula since the cash inflows are constant:

PVannuity=C×1(1+r)nrPV_{\text{annuity}} = C \times \frac{1 - (1 + r)^{-n}}{r}

Where:

  • C=20,000C = 20,000 (cash inflow)
  • r=0.12r = 0.12 (discount rate)
  • n=8n = 8 (years)

Substituting these values into the formula:

PVannuity=20,000×1(1.12)80.12PV_{\text{annuity}} = 20,000 \times \frac{1 - (1.12)^{-8}}{0.12}

Now let's calculate:

PVannuity=20,000×10.40390.12=20,000×0.59610.12=20,000×4.9675=99,350PV_{\text{annuity}} = 20,000 \times \frac{1 - 0.4039}{0.12} = 20,000 \times \frac{0.5961}{0.12} = 20,000 \times 4.9675 = 99,350

Now, subtract the initial investment of 100,000100,000:

NPV=99,350100,000=650NPV = 99,350 - 100,000 = -650

Part a Answer:

The NPV is -650.

Since the NPV is negative, the project should not be accepted because it does not add value to the firm.


Part b: NPV with a 13% discount rate

Now, we repeat the same process using a discount rate of 13%:

PVannuity=20,000×1(1.13)80.13PV_{\text{annuity}} = 20,000 \times \frac{1 - (1.13)^{-8}}{0.13}

Let's calculate the present value factor:

PVannuity=20,000×10.39700.13=20,000×0.60300.13=20,000×4.6385=92,770PV_{\text{annuity}} = 20,000 \times \frac{1 - 0.3970}{0.13} = 20,000 \times \frac{0.6030}{0.13} = 20,000 \times 4.6385 = 92,770

Subtract the initial investment of 100,000100,000:

NPV=92,770100,000=7,230NPV = 92,770 - 100,000 = -7,230

Part b Answer:

The NPV is -7,230.

Since the NPV is negative, the project should not be accepted because it does not add value to the firm.


Part c: IRR

To find the IRR, we set NPV to zero and solve for the discount rate:

0=100,000+20,000×1(1+IRR)8IRR0 = -100,000 + 20,000 \times \frac{1 - (1 + IRR)^{-8}}{IRR}

We need to solve this equation for IRR. This typically requires trial and error or a financial calculator, but we can estimate the IRR by trying different rates.

Using an iterative process (or financial calculator), the IRR is approximately 12.8%.

Part c Answer:

The IRR is 12.8%.

Since the IRR (12.8%) is greater than the required discount rate of 12%, the project should be accepted because the IRR adds value to the firm.


Final Answers:

  1. a: NPV at 12% = -650 → The project should not be accepted because it does not add value.
  2. b: NPV at 13% = -7,230 → The project should not be accepted because it does not add value.
  3. c: IRR = 12.8% → The project should be accepted because the IRR is higher than the required discount rate.

Would you like more details on any of these calculations or concepts? Here are some related questions you might find useful:

  1. How does changing the discount rate impact the NPV of a project?
  2. What are the advantages and disadvantages of using IRR as a decision-making tool?
  3. How do you calculate NPV for a project with varying cash inflows over time?
  4. What are the assumptions underlying the NPV method?
  5. How can you interpret a project with an IRR lower than the required rate?

Tip: Always ensure the discount rate used for NPV and IRR reflects the project's risk and opportunity cost of capital.

Ask a new question for Free

By Image

Drop file here or Click Here to upload

Math Problem Analysis

Mathematical Concepts

Net Present Value (NPV)
Internal Rate of Return (IRR)
Present Value of Annuities

Formulas

NPV = Σ (C_t / (1 + r)^t) - C_0
PV_annuity = C × [(1 - (1 + r)^-n) / r]
IRR: NPV = 0 and solve for r

Theorems

Time Value of Money
Present Value Annuity Formula

Suitable Grade Level

Undergraduate Finance or Business Students