Can you provide the solutions and calculations for a), b), and c) of the attached excel sheet? This is for my homework for Financial Accounting for MBAs.

E10-20 Financial Accounting for MBAs Module 10 Verizon Communications, Inc., provides the following footnote relating to leasing activities in its 10-K report. The aggregate minimum rental commitments under noncancelable leases for the periods shown at December 31, 2012, are as follows: Years (dollars in millions) 2013 2014 2015 2016 2017 Thereafter Total Minimum Rental Commitments Less Interest and Executory Costs Present Value of Minimum Lease Payments Less Current Installments Long-Term Obligation at Dec 31, 2012 Capital Leases Present Value $ 86.00 $ 67.00 $ 57.00 $ 54.00 $ 44.00 $ 99.00 $ 407.00 $ 109.00 $ 298.00 64 234 Operating Leases $ 2,038.00 $ 1,840.00 $ 1,572.00 $ 1,280.00 $ 992.00 $ 4,119.00 $ 11,841.00 a) Using your financial calculator or excel spreadsheet, confirm that verizon capitalized its capital leases using a rate of 9.44% b) What effect does the failure to capitalize operating leases have on Verizon's Balance Sheet? Over the life of its leases, what effect does the lease classification have on net income? c) Compute the present value of Verizon's operating leases, assuming a 9.44% discount rate and rounding the remaining lease life to three decimal places. How might we use this additional in our analysis of the company