Submit journal entries in an excel template

Assignment Help Accounting Basics
Reference no: EM131018961

Complete the following questions. Submit journal entries in an Excel Template, linked at the bottom of this page, and any written segments in Excel’s comments function. Do not submit two separate documents, as only one document can be accepted. For written answers, please make sure your responses are well written, formatted per CSU-Global Guide to Writing and APA Requirements and have proper citations, if applicable.

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

Inception date

January 1 2014

Annual lease payment due at the beginning of each year, beginning with January 1, 2014

$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, 2014

$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 Excel Template spreadsheet linked at the bottom of this page, prepare an amortization schedule that would be suitable for the lessee for the lease term.

Using the same spreadsheet set up an area for journal entries, prepare the journal entries for the lessee for 2014 and 2015 to record the lease agreement and all expenses related to the lease. Record them clearly in that spreadsheet. Assume the lessee’s annual accounting period ends on December 31 and that reversing entries are used when appropriate.

       

Bob Evans Farms - Lease Amortization Schedule

   
                 

Date

 

Lease Payment

 

Interest Expense

 

Reduction of Lease Liability

 

Balance of Lease Liability

                 

January 1 2014

             

$400,000

January 1 2014

               

January 1 2015

               

January 1 2015

               

January 1 2017

               

January 1 2018

               

January 1 2019

               

December 31 2019

               

December 31 2020

               

Prepare the journal entries to record the following.

Date

Account Title

Amount

Amount

Account Title

   
     

Provide a one line explanation for the reason why the journal entry has been made.

Date

Account Title

Amount

Amount

Account Title

   
     

Provide a one line explanation for the reason why the journal entry has been made.

Date

Account Title

Amount

Amount

Account Title

   
     

Provide a one line explanation for the reason why the journal entry has been made.

Date

Account Title

Amount

Amount

Account Title

   
     

Provide a one line explanation for the reason why the journal entry has been made.

Date

Account Title

Amount

Amount

Account Title

   
     

Provide a one line explanation for the reason why the journal entry has been made.

Date

Account Title

Amount

Amount

Account Title

   
     

Provide a one line explanation for the reason why the journal entry has been made.

Reference no: EM131018961

Questions Cloud

How to prepare seminar on the topic mobile technologies : How to prepare seminar on the topic "Mobile Technologies"? Complete the paper which should be approximately 3500 words in length (excluding appendices, tables, diagrams). Include all the technologies has revolutionized the field of Mobile.
How the degree of operating and financial leverage : What is the relationship between business risk, financial risk, and beta (systematic or market risk).
What is the power being dissipated in the device : A power transistor is specified to have a maximum junction temperature of 150C. When the device is operated at this junction temperature with a heat sink, the case temperature is found to be 97°C. The case is attached to the heat sink with a bond ..
What is the highest junction temperature you would expect : A power transistor operating at an ambient temperature of 50°C, and an average emitter current of 3 A, dissipates 20 W. If the thermal resistance of the transistor is known to be less than 3°C/W, what is the highest junction temperature you would ..
Submit journal entries in an excel template : Complete the following questions. Submit journal entries in an Excel Template, linked at the bottom of this page, and any written segments in Excel’s comments function.
Ranking on the latest un human development index : Identify one nation (not the USA or Canada) that falls under each classification and for each of the three nations, report: 1) their general geographic location, 2) per-capita GDP and 3) ranking on the latest UN Human Development Index.
Calculate the aggregate demand curve : Graph the market for movie tickets on three graphs. One for the total movie ticket demand, one for non-student demand, and one for student demand. Calculate the aggregate demand curve. Calculate the aggregate marginal revenue curve
Find the net gains from trade : Find the net gains from trade - What is the quantity of automobiles imported by Ireland and find the quantity of automobiles imported with the tariff program.
Discuss these fears and anxieties openly : During your first week, you may have experienced certain fears and some anxieties. Discuss these fears and anxieties openly. This will give you an opportunity to express yourself and hear from others.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Describe what the statute of limitations means to a

describe what the statute of limitations means to a taxpayer and the irs. also there are three primary periods or time

  What volume of sales in dollars must disk city achieve in

disk city inc. is a retailer for digital video disks. the projected net income for the current year is 2380000 based on

  Extra gui controls and functionality

In this HW are will be adding extra GUI controls and functionality to HW # 2. First, your calculator should be fully functional. This means that it should be able to accomplish all arithmetic operations on any set of numbers. The number buttons sh..

  Desire to reenergize the workforce

Given the board of directors' desire to reenergize the workforce, what advice would you provide for creating a leadership strategy? What leader behaviors should nursing home directors and nurse supervisors demonstrate?

  If canyon realty co paysweekly salaries of 12000 on friday

if canyon realty co paysweekly salaries of 12000 on friday for a five-day work weekending on that day. what is the

  Finished goods inventory at the end of september was 3000

1.toscano company makes all its sales on account. accounts receivable payment experience is as followspercent paid in

  How does accounting help the capital allocation process

Differentiate between "financial statements" and "financial reporting." and how does accounting help the capital allocation process?

  Governmental accounting standard board

Before the establishment of the Governmental Accounting Standard Board,which organization developed GAAP for governments?

  The following present value factors are provided for use in

the following present value factors are provided for use in this problem. periods present value of 1 at 9 present value

  Mcgriff requires an estimate of the cost of goods lost by

mcgriff requires an estimate of the cost of goods lost by fire on march 9. merchandise on hand on january 1 was 76000.

  Identify whether the following tests are substantive

identify whether the following tests are substantive analytical procedures tests of details of transactions or tests of

  Characteristic of absorption costing

What characteristic of absorption costing caused the drop in net operating income for the second quarter and what could the controller have said to explain the problem?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd