How to get the PV in this excel? What the equation for this PV? I use the PV(0.08, lease term, - monthly payment, 0, 1), but I can get the number on this picture. The borrowing rate is 8% and monthly basis pay at the beginning.

Lease Term at Inception (Months) Bargain Purchase Option No No No 84 No 60 No Lease Termination Year 2022 2019 2020 2021 2021 2023 2021 2022 2020 2019 2019 2020 2020 2020 60 60 Estimated Economic Life Fair Value (Months) at Inception 240 $ 71,014 240 $ 119,988 240 $ 85,873 240 $ 57,641 240 $ 49,460 240 $ 48,320 240 $ 98,441 240 S 107,251 60 S 21,558 60 $ 23,631 60 $ 20,482 60 $ 24,095 60 $ 22,263 60 S 25.926 Transfer at Renewal Lease Option Termination Period 5 years No 5 years No 5 years No 5 years No 5 years No 5 years No 5 years No 5 years Yes NA Yes NA NA Yes NA Yes NA Yes NA Exceeds 75%? Monthly Lease Term (Yes or PV of Lease Rental / Life (%) No) Payments ($) $ 974 35% No $62,907.73 $ 969 25% No $48,108.16 $ 1,225 25% No $60,817.85 $ 935 25% No $46,420.15 $ 895 25% No $44,434.26 $ 862 25% No $42,795.91 $ 1,250 25% No $62,059.03 $ 1,135 35% No $73,306.23 $ 225 80% Yes $9,277.87 $ 355 80% Yes $14,617.80 $ 338 80% Yes $13,949.80 $ 346 80% Yes $14,267.31 $ 350 80% Yes $14,432.25 $ 252 80% Yes $10.391.22 Exceeds PV/Fair 90%? Value (Yes or (%) No) 89% No 40% No 71% No 81% No 90% No 89% No 63% No 68% No 43% No 62% No 68% No 59% No 65% No 40% No No No No No Yes Yes Yes Yes Yes Yes Classification (operating or capital) Operating Operating Operating Operating Operating Operating Operating Operating Capital Capital Capital Capital Capital Capital 60 84 48 48 Yes 48 48