Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Accounting Basics Expert

Oxcom Enterprises:

A Case of Cash-Based to Accrual Accounting

Abstract

The significance of students understanding process of converting cash based accounting information to accrual-based accounting financial statements could not be emphasized enough.  This concept is introduced in first financial accounting class and then expanded upon in first intermediate accounting class. Oxcom Enterprises is typical small business which maintains limited financial records and relies on its accountant to accumulate this information into accrual based financial statements at year-end. The case needs the student to use previous year financial statements and some extra information to create adjusting entries and prepare financial statements. Students also receive practice in use of the accounting work sheet. The case format is flexible and could be easily expanded to include, or exclude particular facets.  The case format here includes lease type transaction, an indirect method statement of cash flows but excludes issues relating to deferred taxation. It also includes a requirement to draft in suitable format the footnote for long term debt.

OXCOM ENTERPRISES INC.

Oxcom Enterprises Inc. (Oxcom) sells personalized items like mugs, key chains and plaques to the public. Company was started by two high school friends 8 years ago.  Oxcom was organized by issuing 40,000 shares of $0.25 par stock to a number of investors.  At that time they also got start-up capital from a loan from a financial institution.  During the present year they have sought further capital by issuing an additional 10,000 shares to new investors.

Like many other small companies, Oxcom is required to create accrual basis financial statements at the end of the year for submission to its bank and to stockholders. Since the size of the company and fact that it does not have the accountant on its payroll, Oxcom has maintained simple records of its transactions based on cash basis of accounting. They have come to you as the accountant for assistance and have provided you with the box of records containing which contain information essential to record transactions which occurred for the year.  These records must provide enough information to create a worksheet summarizing year’s transactions and adjusting journal entries essential to prepare financial statements for the 2013 fiscal year. From 2012 accounts of Oxcom Enterprises which were filed with bank you have obtained the following audited balance sheet (post closing trial balance) as of December 31, 2012.

                                                           Dr.                Cr.
Cash                                               $56,000    
Accounts receivable                            13,000    
Inventory                                          32,000    
Prepaid insurance                                   900    
Land                                                   40,000    
Buildings                                             50,000    
Accumulated depreciation – buildings                     $15,000
Equipment                                           32,000    
Accumulated depreciation- equipment                        6,000
Accounts payable                                                    27,400
Advances from customers                                          1,100
Salaries payable                                                        2,100
Taxation payable                                                       5,000
Interest payable                                                        1,200
Long term loan payable                                            60,000
Capital stock $0.25 par                                             10,000
Paid in capital                                                           16,000
Retained earnings                                                     80,100
               
                                                         $223,900     $223,900
 
From the analysis of the company’s 2013 bank account and related vouchers and invoices you have determined the following:

Cash receipts:
Sales and other collections from customers              $331,200
Proceeds from sale of equipment                                  5,000
Issue of 10,000 $0.25 par shares                                12,500
Interest income                                                           1,200
Total cash receipts                                                  $349,900

Included in cash collections is deposit of $4,800 made by the customer for a job to be performed in 2014. The jobs relating to the 2012 deposits in advance were completed in 2013.

The proceeds from sale of equipment arose from sale of a piece of equipment on December 31, 2013. The original cost of the equipment was $6,000, and the accumulated depreciation on this equipment at the start of the year was $3,000.

Cash disbursements:
Payments relating to purchase of merchandise            $163,000
Extension to building                                                     11,000
Payment for purchases of equipment                              10,000
Payment of salaries and wages including payroll taxes     88,600
Payment of utilities                                                         4,600
Payment of telephone                                                     3,400
Payment of insurance bills                                               1,500
Payment of interest and principal on bank loan                14,600
Van payments                                                               11,000
Payment of dividend to shareholders                               11,000
Payment for income taxes including tax deposits               13,400
Total disbursements                                                    $332,100

You also have determined the following facts:

1. At December 31, 2013 outstanding accounts receivable totaled $30,000. In previous years, uncollected accounts receivable have been small and company used direct prepare-off method for bad debt.  Though, Oxcom has started to offer more credit in the attempt to bring in more corporate business. At December 31, 2013, 10% of the outstanding accounts receivable are considered to be doubtful as to collectibility.

2. Merchandise inventory at December 31, 2013 was counted and valued at cost of $51,500.

3. The insurance policy paid during the year covered the period from September 1, 2013 to August 30, 2014.  The previous year payment covered earlier part of the year.

4. Accounts payable at December 31, 2012 and 2013 were $25,400 and $21,200, respectively. An analysis of these accounts payable balances revealed the following:

    Relating to                        2012          2013
    Merchandise purchases    24,000        20,000
    Equipment                        2,000             -
    Telephone                           500             400
    Utilities                               900           1,800
                                          27,400          22,200

5. Accrued salaries and wages at December 31, 2013 are to be established on following basis. Payroll was paid for the two weeks to December 26, 2013 on December 28, 2013.  Payroll for two week period to January 9, 2014 was paid on January 11, 2014.  The total of this payroll and employees benefits was $14,000.  (Suppose a seven day work week)

6. Depreciation of original buildings is on the straight-line basis assuming a 25-year useful life with no residual value. Depreciation on the building extension is to be over a remaining life of 18 years.  Depreciation of equipment and vehicles is on a straight-line basis assuming a 5-year useful life with no residual value.  A half year’s depreciation is taken on assets acquired or disposed of in the current year.  No assets are fully depreciated by December 31, 2013.

7. The loan principal on the 8% fixed rate bank loan will be repaid in ten equal principal payments (12 from the start of the year) of $5,000 every six months on March 31 and September 30 each year plus the accumulated interest for that period based on the outstanding principal balance..  The principal payments and the correct amount of interest have been paid so far on the due dates.  The next principal payment is due on March 31, 2014.  The loan is secured on the land and buildings of the company.

8. On June 30th of the current year, the company purchased a delivery van.  It made a down payment of $3,000 on the date of purchase and financed the balance of the vehicle with the vendor.  Oxcom will make eight quarterly payments of $4,000 each commencing September 30, 2013.  A reasonable market rate of interest on this loan would be 10%.  The September and December payments were made on the due dates.  The loan is secured on the delivery van. You will have to determine the cost price of the van and how to deal with the loan finance.

9. The issue of shares occurred on June 30 .2013.

10. Taxation at a rate of 30% of net profits before tax is to be provided for.  Deferred tax is not applicable to this case.

11. All matters above are deemed to be material.

REQUIRED

1. Create in good form the classified comparative balance sheet, and the multi-step single year income statement and statement of stockholders’ equity for Oxcom Enterprises for the 2013 year.

In order to achieve this you must perform this exercise in an excel spreadsheet formatted and linked as you wish.  The following is a suggestion:

(a) Enter the opening balances for 2013 into the multi-column Excel spread sheet (work sheet) using following column headings:

1. Account

2. Opening Trial Balance)

3. Adjustments (with columns for Dr and Cr)

4. Corrected Trial Balance

(b) Post essential entries to the work sheet to record cash transactions for the year (adjustments column).  Keep a separate record of the journal entries posted with a short description in the general journal.

(c) Post essential entries to the work sheet to record adjustments to the accounts required to create the financial statements (adjustments column).  Keep a separate record of journal entries posted with a short description in general journal.

(d) Create the financial statements from worksheet.

This spreadsheet must be available for my review if requested.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M92727
  • Price:- $70

Priced at Now at $70, Verified Solution

Have any Question? 


Related Questions in Accounting Basics

Assignment expected value and consumer choicesconsumers

Assignment: Expected Value and Consumer Choices Consumers' choices are prey to subtle discrepancies that arise in cognitive accounting. Learning how and when you are prey to these discrepancies is an important step in im ...

Business assignmentthe comany i have choosen is upsresearch

Business Assignment The comany i have choosen is UPS. Research a company that interests you from the Fortune 500. (A list will be provided). Analyze what they do. What business are they in? What industry? How have they b ...

You are starting your own internet business you decide to

You are starting your own Internet business. You decide to form a company that will sell cookbooks online. Justcookbooks.com is scheduled to launch 6 months from today. You estimate that the annual cost of this business ...

Accounting and societyrequirementsbackgroundin their annual

Accounting and Society Requirements: Background: In their annual report, companies are required to include a remuneration report that documents the remuneration packages of the chief executive officer, other key executiv ...

Accounting assignmenttransfer pricing decisionsas a manager

Accounting Assignment Transfer Pricing Decisions As a manager, you may be tasked with making recommendations as to how your organization should structure its transfer pricing. This is especially true in cases when both v ...

Company name is chevronapply ifrs 1 adopting ifrs and rev

Company name is Chevron Apply IFRS 1, "Adopting IFRS" and "Rev Rec" to your U.S. company used in the "Comparison Project" for the final effort in class which is to develop a plan for the transition to both IFRS and Rev R ...

This assignment will assess the following learning

This assignment will assess the following learning outcomes: - Demonstrate the impact on the financial statements and the implication for different users of accounts of alternative ways of treating controversial accounti ...

Problemin an annual audit on december 31 2016 novelty

Problem In an annual audit on December 31, 2016, Novelty company provided the following transactions: 1. Merchandise was received on January 8, 2017, and related purchase invoice recorded on January 5, 2017. The invoice ...

Question 1the accounts receivable account has total debit

Question 1 The Accounts Receivable account has total debit postings of $1,900 and credit postings of $1,100. The balance of the account is a/an A. $800 debit. B. $800 credit. C. $2,600 credit. D. $2,600 debit. Question 2 ...

To understand the accounting equation and its

To understand the accounting equation and its elements QUESTION Mr. "A" starts a new business. Before to start the business operation, he has purchased vehicle Rs. 1,500,000, office premises Rs. 3,000,000, stock of goods ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen