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
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L
Principles of Management
Principles of Management
Management
ISBN:
9780998625768
Author:
OpenStax
Publisher:
OpenStax College
Management, Loose-Leaf Version
Management, Loose-Leaf Version
Management
ISBN:
9781305969308
Author:
Richard L. Daft
Publisher:
South-Western College Pub