Tesla is planning to produce an all$-$electric family car and expects the following cash flows $($in $ million$)$ at the end of each year:

Year $012345$

Cash flow $-1301020408080$

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

Create an Excel spreadsheet with the present value of each cash flow. What is the project's NPV $($in $ million$)?$

There's an easier way: What is the NPV using Excel's NPV$()$ function? Note that Excel's NPV function discounts all the cash flows in the range, even the first one.