How to get the PV value in this excel chart? What the equation of PV for this one in Excel?

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