A project has the following cash flows: 1/1 Year Cash Flow points awarded 0 -$ 16,900 1 7,600 Scored 2 3 8,900 7,400 eBook Print 口 References a. What is the NPV at a discount rate of zero percent? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. b. What is the NPV at a discount rate of 12 percent? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. c. What is the NPV at a discount rate of 21 percent? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. d. What is the NPV at a discount rate of 28 percent? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. a. NPV $ 7,000 b. NPV $ 2,247.91 c. NPV -363.08 d. NPV -2,001.78 Explanation Note: Intermediate answers are shown below as rounded, but the full answer was used to complete the calculation. The NPV of a project is the PV of the inflows minus the PV of the outflows. At a zero discount rate (and only at a zero discount rate), the cash flows can be added together across time. So, the NPV of the project at a zero percent required return is: NPV = $16,900 + 7,600 + 8,900 + 7,400 = $7,000 The NPV at a required return of 12 percent is:
A project has the following cash flows: 1/1 Year Cash Flow points awarded 0 -$ 16,900 1 7,600 Scored 2 3 8,900 7,400 eBook Print 口 References a. What is the NPV at a discount rate of zero percent? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. b. What is the NPV at a discount rate of 12 percent? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. c. What is the NPV at a discount rate of 21 percent? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. d. What is the NPV at a discount rate of 28 percent? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. a. NPV $ 7,000 b. NPV $ 2,247.91 c. NPV -363.08 d. NPV -2,001.78 Explanation Note: Intermediate answers are shown below as rounded, but the full answer was used to complete the calculation. The NPV of a project is the PV of the inflows minus the PV of the outflows. At a zero discount rate (and only at a zero discount rate), the cash flows can be added together across time. So, the NPV of the project at a zero percent required return is: NPV = $16,900 + 7,600 + 8,900 + 7,400 = $7,000 The NPV at a required return of 12 percent is:
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 16EB: Project Y cost $8,000 and will generate net cash inflows of $1,500 in year one, $2,000 in year two,...
Related questions
Question
100%
Would you kindly input this problem into Excel and use the NPV function and IRR function in Excel? Thank You
Transcribed Image Text:A project has the following cash flows:
1/1
Year
Cash Flow
points awarded
0
-$ 16,900
1
7,600
Scored
2
3
8,900
7,400
eBook
Print
口
References
a. What is the NPV at a discount rate of zero percent?
Note: Do not round intermediate calculations and round your answer to the
nearest whole number, e.g., 32.
b. What is the NPV at a discount rate of 12 percent?
Note: Do not round intermediate calculations and round your answer to 2
decimal places, e.g., 32.16.
c. What is the NPV at a discount rate of 21 percent?
Note: A negative answer should be indicated by a minus sign. Do not round
intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.
d. What is the NPV at a discount rate of 28 percent?
Note: A negative answer should be indicated by a minus sign. Do not round
intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.
a. NPV
$
7,000
b. NPV
$
2,247.91
c. NPV
-363.08
d. NPV
-2,001.78
Explanation
Note: Intermediate answers are shown below as rounded, but the full answer was used
to complete the calculation.
The NPV of a project is the PV of the inflows minus the PV of the outflows. At a zero
discount rate (and only at a zero discount rate), the cash flows can be added together
across time. So, the NPV of the project at a zero percent required return is:
NPV = $16,900 + 7,600 + 8,900 + 7,400 = $7,000
The NPV at a required return of 12 percent is:
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 4 images
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College