9. Next, calculate the net present value of leasing the shuttle bus. Elena has already entered the security deposit amount (cell G3) as the initial investment for leasing and the monthly payments in the range G4:G39. In cell B21, enter a formula that adds the security deposit amount (cell G3) 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 Lease Scenario values for months 1-36 and the ending value (range G4:G40) as the cash flows for leasing the shuttle bus. France - Encel Care for fr File Home Insert Page Layout Formules Data Review View Help A Detine Name Traert Autos Recently Fiscal Logical Text Date to Moth More Mme Function Tine Reference Tng functions Minege Create from Selection bude ACCOUNT NOIR Wewe unos problem wr your Micron 365 n deed your tot 821 - X6 Trace Weeden Slow Formula Trace Dondents Art Checking Ft Renaive Arrow ate Formule Forning Watch Window Galite Calculation Calculate the Options COM B D 75.0% E G H 10 $ $ 4,000.00 700 12 13 14 15 (700) (700) (700) (700) (700) (700) (700) (700) A 1 Resale percent 12 13 Lease Scenario 14 Security deposit IS 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 24 25 26 27 28 Donumentation Business 7.00% 0.58% (23.359.13) OENOSNO 37,814 37.549 37,287 37,026 36,766 36,509 36,253 36,000 35,748 35,197 35.249 35,002 34,757 34,514 34,272 34,032 33,794 33.558 (700) $ LEASE 19 20 (700) (700) (700) (700) (700) (700) (700) (700) (700) 22 23 24 25 Profit & Loss Loan Details Buy or Lease Depreciation B D E 75.0% F G H $ $ 4,000.00 700 13 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 24 25 26 27 28 Documentation 7.00% 0.58% (23,359.13) 37,814 37.549 37.287 37,026 36,766 36,509 36,253 36,000 35,748 35,497 35.249 35,002 34,757 34,514 34,272 34,032 33,794 33.558 $ XCESSOs (700) (700) (700) (700) (700) (700) (700) (700) (700) (700) (700) (700) (700) (700) (700) (700) (700) (700) LEASE 20 22 24 ness Plan Loan Petails Buy or Lease Depreciation Profit & Loss