(LO 9-3) Evaluate the future cash flows for the dataset, To MBA or Not To MBA, in...

Question:

(LO 9-3) Evaluate the future cash flows for the dataset, To MBA or Not To MBA, in Excel.

(Dataset is available via Connect Additional Student Resources.) Calculate the net present value (NPV) for those individuals deciding to pursue an MBA, or to not pursue an MBA. To do so, evaluate the future cash flows from age 25 to 60 for the two different scenarios. (Hint: Don’t worry about the initial outlay since the investment is made over two years, just use the NPV function for all cash flows with no initial outlay). Evaluate all cash flows using a 6% cost of capital.

Required 1. Calculate the NPV for the cash flows associated with getting an MBA. (Hint: Use

=NPV(0.06,B6:B41))

2. Calculate the NPV for the cash flows associated with not getting an MBA. (Hint: Use

=NPV(0.06,F6:F41))

3. What can you conclude from this analysis?

4. The NPV analysis is a type of quantitative analysis. What non quantitative (or qualitative) factors should also be considered?

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: