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.

2 Clipboard B20 X fx A B D C $ 1,320 75.0% $ $ 4,000.00 700 10 Tax on sale 11 Resale percent 12 13 Lease Scenario 14 Security deposit 15 Monthly payment 16 17 Buy or Lease 18 Annual discount rate 19 Monthly discount rate 20 Buy: Net present value 21 Lease: Net present value 22 Recommendation 23 7.00% 0.58% LEASE 24 25 26 27 OR Documentation Business Plan Loan Details Buy or Lease Deprecia Ready 12 Type here to search