Please help.Thank you. How do I use excel PV formula? ...
90.2K
Verified Solution
Link Copied!
Question
Accounting
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)
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!