In cell B20, enter a formula that adds the initial investment amount of buying the shuttle bus (cell F3) to the result of the NPV function. In the NPV function, use the monthly discount rate (cell B19) as the rate of return and the Buy Scenario values for months 1–36 and the ending value (range F4:F40) as the cash flows for owning and using the shuttle bus.
