please show all work using excel

Check my work Exercise 15-13 (Algo) Lessee; operating lease; effect on financial statements [LO 15-4) At January 1, 2021, Caf Med leased restaurant equipment from Crescent Corporation under a nine-year lease agreement. The lease agreement specifies annual payments of $30,000 beginning January 1, 2021, the beginning of the lease, and at each December 31 thereafter through 2028. The equipment was acquired recently by Crescent at a cost of $225,000 (its fair value) and was expected to have a useful life of 13 years with no salvage value at the end of its life. (Because the lease term is only 9 years, the asset does have an expected residual value at the end of the lease term of $127,481.) Crescent seeks a 12% return on its lease investments. By this arrangement, the lease is deemed to be an operating lease. (FV of $1. PV of $1. EVA of $1. PVA of $1. EVAD OLS1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Required: 1. What will be the effect of the lease on Caf Med's earnings for the first year (ignore taxes)? (Enter decreases with negative sign.) 2. What will be the balances in the balance sheet accounts related to the lease at the end of the first year for Caf Med (ignore taxes)? (For all requirements, round your intermediate calculations and final answers to the nearest whole dollar.) 1. Effect on earnings 2. Lease payable balance (end of year) Right-of-use asset balance (end of year)