Question

Calculating net present value, internal rate of return, and simple rate of return for a project question

Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 24% each of the last three years. Casey is considering a capital budgeting project that would require a $5,050,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 20%. The project would provide net operating income each year for five years as follows:Sales $ 4,700,000
Variable expenses 2,120,000
Contribution margin 2,580,000
Fixed expenses:
Advertising, salaries, and other fixed out-of-pocket costs $ 830,000
Depreciation 1,010,000
Total fixed expenses 1,840,000
Net operating income $ 740,000


Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor(s) using tables.

FireShot Capture 146 -  - ezto-cf-media.mheducation.com.png

FireShot Capture 145 -  - ezto-cf-media.mheducation.com.png

0 0
Add a comment Improve this question Transcribed image text
Answer #1

To calculate the net present value (NPV), internal rate of return (IRR), and simple rate of return for the project, we need to consider the cash flows for each year and apply the relevant formulas. Let's go step by step:


Step 1: Calculate the annual cash flows for each year (Net Operating Income + Depreciation):

Year 1: $740,000 + $1,010,000 = $1,750,000

Year 2: $740,000 + $1,010,000 = $1,750,000

Year 3: $740,000 + $1,010,000 = $1,750,000

Year 4: $740,000 + $1,010,000 = $1,750,000

Year 5: $740,000 + $1,010,000 = $1,750,000


Step 2: Calculate the NPV using the discount rate of 20%:

NPV = (Annual Cash Flow / (1 + Discount Rate)^Number of Years) + ... + (Annual Cash Flow / (1 + Discount Rate)^Number of Years)


NPV = ($1,750,000 / (1 + 0.20)^1) + ($1,750,000 / (1 + 0.20)^2) + ($1,750,000 / (1 + 0.20)^3) + ($1,750,000 / (1 + 0.20)^4) + ($1,750,000 / (1 + 0.20)^5)


NPV = $1,458,333.33 + $1,215,277.78 + $1,012,731.48 + $843,943.73 + $703,286.44


NPV ≈ $6,243,572.76


Step 3: Calculate the IRR using the trial and error method or a financial calculator. In this case, the IRR is approximately 26.2%.


Step 4: Calculate the Simple Rate of Return:

Simple Rate of Return = (Total Cash Inflows - Total Cash Outflows) / Initial Investment


Total Cash Inflows = Net Operating Income * Number of Years

Total Cash Inflows = $740,000 * 5 = $3,700,000


Total Cash Outflows = Initial Investment = $5,050,000


Simple Rate of Return = ($3,700,000 - $5,050,000) / $5,050,000

Simple Rate of Return ≈ -0.2624 or -26.24%


Based on the calculations:


- The net present value (NPV) of the project is approximately $6,243,572.76, which indicates a positive NPV and suggests that the project is financially viable.


- The internal rate of return (IRR) is approximately 26.2%, which is higher than the discount rate of 20%. This means that the project's return on investment exceeds the cost of capital, further supporting its viability.


- The simple rate of return is approximately -26.24%, indicating that the project is not expected to achieve a positive return based on this metric. However, it is important to note that the simple rate of return can sometimes be misleading and is not as comprehensive as NPV or IRR in evaluating the financial viability of a project.


answered by: Aratrika
Add a comment
Know the answer?
Add Answer to:
Calculating net present value, internal rate of return, and simple rate of return for a project question
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined...

    Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 24% each of the last three years. Casey is considering a capital budgeting project that would require a $5,050,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 20%. The project would provide net operating income each year for five years as follows:...

  • Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined...

    Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 24% each of the last three years. Casey is considering a capital budgeting project that would require a $5,050,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 20%. The project would provide net operating income each year for five years as follows:...

  • Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined...

    Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 24% each of the last three years. Casey is considering a capital budgeting project that would require a $5,050,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 20%. The project would provide net operating income each year for five years as follows:...

  • Problem 12-17 Net Present Value Analysis; Internal Rate of Return; Simple Rate of Return (L012-2, LO12...

    Problem 12-17 Net Present Value Analysis; Internal Rate of Return; Simple Rate of Return (L012-2, LO12 3, L012-6) Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division's return on investment (ROI), which has been above 23% each of the last three years. Casey is considering a capital budgeting project that would require a $5,620,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company's...

  • PROBLEM 13-17 Net Present Value Analysis; Internal Rate of Return; Simple Rate of Return [LO13-2, LO13-3,...

    PROBLEM 13-17 Net Present Value Analysis; Internal Rate of Return; Simple Rate of Return [LO13-2, LO13-3, L013-6] Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely deter- mined by his division's return on investment (ROI), which has been above 20% each of the last three years. Casey is considering a capital budgeting project that would require a $3,500,000 invest- ment in equipment with a useful life of five years and no salvage value, Pigeon...

  • Exercise 14-9 (Algo) Net Present Value Analysis and Simple Rate of Return [LO14-2, LO14-6]

    Exercise 14-9 (Algo) Net Present Value Analysis and Simple Rate of Return [LO14-2, LO14-6]Derrick Iverson is a divisional manager for Holston Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 20% each of the last three years. Derrick is considering a capital budgeting project that would require a $3,700,000 investment in equipment with a useful life of five years and no salvage value. Holston Company’s discount rate is 16%. The...

  • Exercise 12-15 Internal Rate of Return and Net Present Value [LO12-2, LO12-3] Henrie’s Drapery Service is...

    Exercise 12-15 Internal Rate of Return and Net Present Value [LO12-2, LO12-3] Henrie’s Drapery Service is investigating the purchase of a new machine for cleaning and blocking drapes. The machine would cost $126,175, including freight and installation. Henrie’s estimated the new machine would increase the company’s cash inflows, net of expenses, by $35,000 per year. The machine would have a five-year useful life and no salvage value. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate...

  • Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined...

    Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 24% each of the last three years. Casey is considering a capital budgeting project that would require a $6,100,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 20%. The project would provide net operating income each year for five years as follows:...

  • Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined...

    Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 23% each of the last three years. Casey is considering a capital budgeting project that would require a $4,700,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 19%. The project would provide net operating income each year for five years as follows:...

  • Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined...

    Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division’s return on investment (ROI), which has been above 24% each of the last three years. Casey is considering a capital budgeting project that would require a $5,850,000 investment in equipment with a useful life of five years and no salvage value. Pigeon Company’s discount rate is 20%. The project would provide net operating income each year for five years as follows:...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT