Calculate the PV of the future minimum lease payments using any of the following methods:...
70.2K
Verified Solution
Link Copied!
Question
Accounting
Calculate the PV of the future minimum lease payments using any of the following methods: (1) factor tables, (2) a financial calculator, or (3) Excel functions. (Round factor values to 5 decimal places, e.g. 1.25124 and final answers to 0 decimal places, e.g. 1,452.) Present value \$ Oakridge Leasing Corporation signs an agreement on January 1, 2023, to lease equipment to Crane Limited. Oakridge and Crane follow ASPE. The following information relates to the agreement: 1. The term of the non-cancellable lease is five years, with no renewal option. The equipment has an estimated economic life of six years. 2. The asset's fair value at January 1,2023 , is $85,000. 3. The asset will revert to the lessor at the end of the lease term, at which time the asset is expected to have a residual value of $6,800, which is guaranteed. 4. Crane assumes direct responsibility for all executory costs, which include the following annual amounts: $900 to Rocky Mountain Insurance Ltd. for insurance and \$1,610 to James Township for property taxes. 5. The agreement requires equal annual rental payments of $19,006 to Oakridge, the lessor, beginning on January 1, 2023. 6. The lessee's incremental borrowing rate is 10%. The lessor's implicit rate is 9% and is known to the lessee. 7. Crane uses the straight-line depreciation method for all equipment. 8. Crane uses reversing entries when appropriate. Prepare all of Crane's journal entries for 2020 to record the lease agreement and the lease payments. LeBlanc's accounting period ends on December 31. Ignore payments of insurance and property taxes. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Round answers to 0 decimal places, e.g. 5,275.) 12 Prepare a schedule contrasting the journal entries prepared in part (c) with those using an unguaranteed residual value of $6,000. Ignore payments of insurance and property taxes. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Round answers to 0 derimal nlaces. e. 0.5 .275 .1 Prepare an amortization schedule for Crane Limited for the lease term. Use Excel. (Hint: You may find the ROUND formula helpful for rounding in Excel.) (Round factor values to 5 decimal places, e.g. 1.25124 and final answers to 0 decimal places, e.g. 1,452.)
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!