Question: Please help.Thank you. How do I use excel PV formula? Umbrella Travel enters into an agreement with Destinations Inc. to lease a car on December
Please help.Thank you.
How do I use excel PV formula?

Umbrella Travel enters into an agreement with Destinations Inc. to lease a car on December 31,2019 . The following information relates to this agreement. 1. The term of the non-cancelable lease is 3 years with no renewal or bargain purchase option. The remaining economic life of the car is 3 years, and it is expected to have no residual value at the end of the lease term. 2. The fair value of the car was $15,000 at commencement of the lease. 3. Annual payments are required to be made on December 31 at the end of each year of the lease, beginning December 31,2020 . The first payment is to be of an amount of $5,552.82, with each payment increasing by a constant rate of 5% from the previous payment (i.e., the second payment will be $5,830.46 and the third and final payment will be $6,121.98 ). 4. Umbrella Travel's incremental borrowing rate is 8%. The rate implicit in the lease is unknown. 5. Umbrella Travel uses straight-line depreciation for all similar cars. Instructions a. Prepare Umbrella Travel's journal entries for 2019, 2020, and 2021. Present Value of Rental Payments (Use Excel PV formulas) PV of first payment PV of second payment PV of third payment PV of rental payments $ (Use Excel Rounding formula to zero digits)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
