Prepare an amortization schedule

Reference no: EM13330242

Complete the following exercise. Submit journal entries in an Excel file and written segments in an MS Word document. Label each question clearly. For written answers, please make sure your responses are well-written, formatted per CSU-Global guidelines for APA Style, and have proper citation(s), if needed.

Click here to download the Excel workbook containing the spreadsheets you will need for this exercise.

Assume that the following facts pertain to a noncancelable lease agreement between Fifth-Third Leasing Company and Bob Evans Farms, a lessee.

Inception date January 1, 2012
Annual lease payment due at the beginning of each year, beginning with January 1, 2012 $81,365
Residual value of equipment at end of lease term, guaranteed by the lessee $50,000
Lease term 6 years
Economic life of leased equipment 6 years
Fair value of asset at January 1, 2012 $400,000
Lessor's implicit rate 12%
Lessee's incremental borrowing rate 12%
The lessee assumes responsibility for all executory costs, which are expected to amount to $4,000 per year. The asset will revert to the lessor at the end of the lease term. The lessee has guaranteed the lessor a residual value of $50,000. The lessee uses the straight-line depreciation method for all equipment.

Using the spreadsheet Lease Amort Schedule, prepare an amortization schedule that would be suitable for the lessee for the lease term.
Using the spreadsheet Journal Entries, prepare the journal entries for the lessee for 2012 and 2013 to record the lease agreement and all expenses related to the lease. Assume the lessee's annual accounting period ends on December 31 and that reversing entries are used when appropriate.

Reference no: EM13330242

Questions Cloud

Critical thinking problems : Critical Thinking Problems

Define the pressure in atmospheres inside a container : What is the pressure in atmospheres inside a container of gas connected to a mercury-filled open-end manometer when the level in the arm connected to the container is 28.0cm higher than the level in the arm open to the atmosphere and the atmospher..

Find impulse was applied to the ball during the collision : A rubber ball of mass 39.0 g is dropped from a height of 1.80 m onto a floor. find impulse was applied to the ball during the collision

Explain the density of a gas mixture : What is the density (in grams per liter) of a gas mixture that contains 20.5% F2 and 79.5% He by volume at 793mm Hg and 28.5C

Prepare an amortization schedule : Prepare an amortization schedule that would be suitable for the lessee for the lease term

Explain appropriate and non zero formal charge for icl2- : Provide a Lewis structure, including resonance if appropriate, and non zero formal charge, for ICl2-

State the name of the half-neutralization point : Indicate the pH at (a) the beginning of the titration (0.0 mL titrant) and after the addition of (b) 12.5 mL, (c) 24.0 mL, (d) 24.9 mL, (e) 25.0 mL, (f) 25.1 mL, and (g) 30.0 mL of the titrant. Label the half-neutralization point and the equivalen..

What is the work done by tension : A mass m = 14 kg is pulled along a horizontal floor, with a coefficient of kinetic friction ?k = 0.09, for a distance d = 7.9 m. What is the work done by tension before the block gets to the incline

Educational incentives : Educational Incentives

User Account

All Pages