(LO 9-3) What would be the Excel formula to compute the net present value for this stream...
Question:
(LO 9-3) What would be the Excel formula to compute the net present value for this stream of cash flows for an initial $50,000 investment and cash inflows of $18,000 per year for Years 1–4 with a 10 percent cost of capital?
a. =NPV(0.1,18000,18000,18000,18000)-50000
b. =NPV(0.1,+50000,−18000,−18000,−18000,−18000)
c. =NPV(0.1,18000,18000,18000,18000,−50000)
d. =NPV(−50000,18000,18000,18000,18000)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Introduction To Data Analytics For Accounting
ISBN: 9781266358234
2nd Edition
Authors: Vernon Richardson, Katie Terrell And Ryan Teeter
Question Posted: