(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  book-img-for-question

Introduction To Data Analytics For Accounting

ISBN: 9781266358234

2nd Edition

Authors: Vernon Richardson, Katie Terrell And Ryan Teeter

Question Posted: