Intro

Tesla is planning to produce an all$-$electric family car and expects the following cash flows

$($in $ million$)$ at the end of each year:

The required return for this project is $15\%.$

Part $1$

Create an Excel spreadsheet with the present value of each cash flow. What is the project's

NPV $($in $ million$)?$

Part $2$

There's an easier way: What is the NPV using Excel's NPV$0$ function? Note that Excel's

NPV function discounts all the cash flows in the range, even the first one.