Hi! Need Excel solution to bottom two segments of below question, can you help?

Analyzing, Interpreting, and Capitalizing Operating Lease

Goldman Sachs SEC filing for the quarter ended March 31, 2019, report contains the following lease footnote.

Leases (ASC 842). In February 2016, the FASB issued ASU No. 2016-02, Leases (Topic 842). This ASU requires that, for leases longer than one year, a lessee recognize in the statements of financial condition a right-of-use asset and a lease liability. It also requires that for finance leases, a lessee recognize interest expense on the lease liability, separately from the amortization of the right-of-use asset in the statements of earnings, while for operating leases, such amounts should be recognized as a combined expense. The firm adopted this ASU in January 2019 under a modified retrospective approach.

The table below presents other assets by type.

What operating lease liability did Goldman Sachs report for the quarter ended March 31, 2019?

- Answer: $2,413 million

What right-of-use assets did Goldman Sachs report for the quarter ended March 31, 2019?

- Answer: $2,386 million

Use an Excel spreadsheet and the information on future operating lease payments to verify the total liabilities of $2,413 million on the 2019 Form 10-Q. Hint: The amount will not be exactly $2,413. Enter the amount computed in Excel. Round your final answer to the nearest million.

- Answer: $___________ million

Use the information on rental payments from the December 2018 Form 10-K, to calculate the present value of future payments at year-end. Use the same average weighted lease term and discount rate Goldman Sachs discloses in the 2019 Form 10-Q. Enter the amount computed in Excel. Round your final answer to the nearest million.

- Answer: $___________ million

$ in millions Property, leasehold improvements and equipment Held-to-maturity securities Goodwill and identifiable intangible assets Operating lease right-of-use assets Income tax-related assets Miscellaneous receivables and other Total Mar. 2019 Dec. 2018 $19,277 $18,317 5,841 1,288 4,092 4,082 2.386 1,729 1,529 4,358 $37,683 5,424 $30,640 The table below presents other liabilities by type. Mar. 2019 Dec. 2018 $6,834 3,080 2,864 $3,110 $ in millions Compensation and benefits Income tax-related liabilities Operating lease liabilities Noncontrolling interests Employee interests in consolidated funds Accrued expenses and other Total 2,413 1,565 122 5,884 $16,174 1,568 122 6,219 $17,607 The table below presents information about future operating lease payments. $ in millions Mar. 2019 Remainder of 2019 318 2020 341 2021 262 2022 235 2023 204 2024 193 2025-thereafter 2,494 Total undiscounted lease payments 4,047 Imputed interest (1,634) Total operating lease liabilities $2,413 Weighted average remaining lease term 18 years Weighted average discount rate 4.8596 Goldman Sachs's 10-K report for the year ended December 31, 2018, included the following table about future cash payments required under operating leases. $ in millions Dec. 2018 2019 $281 2020 271 2021 218 2022 177 2023 142 2024 - thereafter 1,310 $2.399 Total $ in millions Property, leasehold improvements and equipment Held-to-maturity securities Goodwill and identifiable intangible assets Operating lease right-of-use assets Income tax-related assets Miscellaneous receivables and other Total Mar. 2019 Dec. 2018 $19,277 $18,317 5,841 1,288 4,092 4,082 2.386 1,729 1,529 4,358 $37,683 5,424 $30,640 The table below presents other liabilities by type. Mar. 2019 Dec. 2018 $6,834 3,080 2,864 $3,110 $ in millions Compensation and benefits Income tax-related liabilities Operating lease liabilities Noncontrolling interests Employee interests in consolidated funds Accrued expenses and other Total 2,413 1,565 122 5,884 $16,174 1,568 122 6,219 $17,607 The table below presents information about future operating lease payments. $ in millions Mar. 2019 Remainder of 2019 318 2020 341 2021 262 2022 235 2023 204 2024 193 2025-thereafter 2,494 Total undiscounted lease payments 4,047 Imputed interest (1,634) Total operating lease liabilities $2,413 Weighted average remaining lease term 18 years Weighted average discount rate 4.8596 Goldman Sachs's 10-K report for the year ended December 31, 2018, included the following table about future cash payments required under operating leases. $ in millions Dec. 2018 2019 $281 2020 271 2021 218 2022 177 2023 142 2024 - thereafter 1,310 $2.399 Total