Practical Management Science
Practical Management Science
5th Edition
ISBN: 9781305250901
Author: Wayne L. Winston, S. Christian Albright
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 2, Problem 44P

The IRR is the discount rate r that makes a project have an NPV of $0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where “guess" is your best guess for the IRR. It is best to try a range of guesses (say, −90% to 100%). Find the IRR of the project described in Problem 34.

34. Consider a project with the following cash flows: year 1, −$400; year 2, $200; year 3, $600; year 4, −$900; year 5, $1000; year 6, $250; year 7, $230. Assume a discount rate of 15% per year.

  1. a. Find the project’s NPV if cash flows occur at the ends of the respective years.
  2. b. Find the project’s NPV if cash flows occur at the beginnings of the respective years.
  3. c. Find the project’s NPV if cash flows occur at the middles of the respective years.
Blurred answer
Students have asked these similar questions
What is a bottleneck? Would you try to reduce a bottleneck? Why or why not? Please provide a reference
Your firm has been the auditor of Caribild Products, a listed company, for a number of years. The  engagement partner has asked you to describe the matters you would consider when planning the audit for  the year ended 31January 2022. During  recent visit to the company you obtained the following information: (a) The management accounts for the 10 months to 30 November 2021 show a revenue of $260 million and profit before tax of $8 million. Assume sales and profits accrue evenly throughout the year. In the year ended 31 January 2021 Caribild Products had sales of $220 million and profit before tax of $16 million. (b) The company installed a new computerised inventory control system which has operated from 1 June  2021. As the inventory control system records inventory movements and current inventory quantities, the company is proposing: (i) To use the inventory quantities on the computer to value the inventory at the year-end (ii) Not to carry out an inventory count at the year-end (c)…
Develop and implement a complex and scientific project for an organisation of your choice. please include report include the following: Introduction Background research to the project The 5 basic phases in the project management process Project Initiation Project Planning Project Execution Project Monitoring and Controlling Project Closing Conclusion
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License