Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 −$ 361,504 −$ 16,050 1 28,700 5,368 2 51,000 8,456 3 53,000 14,000 4 423,000 9,699 Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A? b. What is the payback period for Project B? c. What is the discounted payback period for Project A? d. What is the discounted payback period for Project B? e. What is the NPV for Project A? f. What is the NPV for Project B ? g. What is the IRR for Project A? h. What is the IRR for Project B? i. What is the profitability index for Project A? j. What is the profitability index for Project B?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 21P
icon
Related questions
icon
Concept explainers
Topic Video
Question
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 −$ 361,504 −$ 16,050 1 28,700 5,368 2 51,000 8,456 3 53,000 14,000 4 423,000 9,699 Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A? b. What is the payback period for Project B? c. What is the discounted payback period for Project A? d. What is the discounted payback period for Project B? e. What is the NPV for Project A? f. What is the NPV for Project B ? g. What is the IRR for Project A? h. What is the IRR for Project B? i. What is the profitability index for Project A? j. What is the profitability index for Project B?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, marketing and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,