Intro

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

$S$ million$)$ at the end of each year:

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

Part $1$

Attempt $\frac{3}{10}$ for $6$ pts$.$

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

NPV $($in S million$)?$

Part $2$

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.