Practical Management Science
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
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
A power producing company wants to purchase a natural gas futures contract. It will use the natural gas to generate electricity. The company's position in natural gas is futures position should be underlying __, so its a) long, short; b) long, long; c) short, long; d) short, short
(True, False) Stagflation happens when the economy is experiencing a bust and deflation. Stagflation occurs when the (AD, SR-AS) curve shifts to the (right, left). In the short-run, this shift would cause the overall price level to (increase, decrease) and output to (increase, decrease). Workers may see the short-run effect on the overall price level and negotiate for (higher, lower) wages, resulting in a price-wage spiral. Given that 1) output has (increased, declined) in the short-run, there is a (negative, positive, zero) output gap and that there is a (negative, positive, zero) cyclical unemployment, workers will eventually (accept, fight for) (higher, lower) wages. When this happens, the (AD, SR-AS, LR-AS) curve will shift to the |(right, left), reaching the long-run equilibrium.
Hh1. Account
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