Prepare a ten-column work sheet using the trial balance

Assignment Help Financial Accounting
Reference no: EM132631300

O'Connell's Air Service operates several small airplanes providing passenger and freight service to small towns. Oil fields fishing lodges and other remote locations in Alaska. The company adjusts and closes its accounts at the end of each month. At April 30, the following trial balance was prepared from the ledger.

O'CONNELL'S AIR SERVICE

Trial Balance April 30,19
Cash $22,950
Accounts receivable 25,800
Prepaid rent 8,100
Unexpired Insurance 37,900
Airplanes 845,000
Accumulated depreciation: Airplane $231,780
Notes payable 423,040
Unearned passenger revenue 181,680
Maggle O'Connell, Capital 171,850
Maggle O'Connell, Drawing 7,750
Freight revenue 54,250
Fuel expense 45,600
Salaries expense 60,800
Maintenance expense 8,700

$1,062,600

Other Data:

a. One of O'Connell's regular customers is Yukon Oil Company. The airline keeps track of the number of trips carrying freight for the oil company and sends a bill shortly after month end. No entry has yet been made in the airline's accounting records to record $11,750 freight revenue earned in April form Yukon Oil Company.

b. Three months' rent $8,100 had been prepaid on April 1.

c. On January 1, a 12-month insurance policy had been purchased for $49,200.

d. O'Connell's depreciates its airplanes over a period of 15 years (180 months).

e. Accrued interest on notes payable amounts to $4,500 at April 30 and has not yet been recorded.

f. The amount shown as unearned passenger revenue represents the price of tickets sold to customers

In advance of flights. During April, $94,750 of this amount was earned by the airline.

g. Salaries earned by airline employees but not yet recorded or paid amount to $1,625 at April 30.

Required:

Problem 1: Prepare a 10-column work sheet using the trial balance and adjusting data provided. Include at the Bottom of the work sheet a brief explanation keyed to each adjusting entries.

Reference no: EM132631300

Questions Cloud

Describe ways that you could improve your dissertation : In 250-300 words outline your dissertation topic and goals for this semester as they relate to your dissertation course. If you do not have a dissertation.
Example of a recent merger-acquisition : Give an example of a recent merger/acquisition analyze and assess the situation as it relates to the consolidated company.
Explain does the published set of group financial statements : Explain Does the published set of group financial statements reveal the company's policy on corporate governance, Audit committees, Sustainability, Solvency
Analyze the given case study on security breach : Analyze the given case study on security breach. Recommend controls to avoid an enterprise security breach. Read the text sheet named.
Prepare a ten-column work sheet using the trial balance : Prepare a 10-column work sheet using the trial balance and adjusting data provided. Include at the Bottom of the work sheet a brief explanation keyed
What stages of activity did you undertake : Reflect on your most recent visualisation project and try to sketch or write out the approach you took. What stages of activity did you undertake and in what.
Topic-managing flexible work arrangements : Do you think employee personality plays any role while they try to adjust with this pandemic work pattern?
Do you think employee personality plays any role : Do you think employee personality plays any role while they try to adjust with this pandemic work pattern? Explain. (Broad question)
Compute the missing Asset amount : Compute the missing Asset amount that would appear in the corporation's trial balance according to the basic accounting equation

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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