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

The sanford company had the following balance sheet as of

The Sanford Company had the following balance sheet as of December 31, 20x2. The transactions for the first three months of 20x3 are also presented along with other information about specific accounts. Sanford Company Ba ...

Indeed it can be said that newspapers are facing tough

Indeed it can be said that newspapers are facing tough times, and yes, the Internet can offer many things that papers cannot. Even so, the death of newspapers has been predicted by many for decades. Radio, TV and now the ...

Accounting individual assignmentpart 1 - royal oak taxation

ACCOUNTING INDIVIDUAL ASSIGNMENT PART 1 - Royal Oak Taxation Advisory Service has the following transactions for the month of December 2016: Dec. 1 Commenced business by depositing $50 000 in a bank account in the name o ...

The purpose of this comprehensive project is to use a

The purpose of this comprehensive project is to use a variety of resources to research a corporation. You will also prepare a written paper describing your corporation and summarizing the findings you have developed in t ...

Question 1bringing account balances up to date before

Question 1 Bringing account balances up to date before preparing financial reports is called A. posting. B. adjusting. C. journalizing. D. analyzing. Question 2 The entry to record the expiration of part of the prepaid r ...

Reflectionbulldescribe and explain what you believe are the

Reflection • Describe and explain what you believe are the top three most important corporate taxation concepts you learned in this course. (Some of the topics, Enacting New Taxes, Calculating Tax Cost, Cash Method Versu ...

Assignmentapplication break-even analysiswhen expenses and

Assignment Application: Break-Even Analysis When expenses and revenues are equal, this is known as the "break-even point" or BEP. To determine break-even, an examination of fixed and variable costs (expenses) in relation ...

Question 1 ldquoaccountancy is an information systemrdquo

Question 1. “Accountancy is an Information System”. Do you agree? Substantiate your answer with reasons. How does an Accountant help in planning and controlling a large commercial organization? Explain.    Question 2. Th ...

Accounting for governmenttrue or false1 a fund in itself is

ACCOUNTING FOR GOVERNMENT True or False 1. A fund in itself is a separate legal entity that is established to comply with laws that require that certain transactions be segregated and accounted for as a separate "fund." ...

Ace lawn care module - mini practice problemjim graham

Ace Lawn Care Module - Mini Practice Problem Jim Graham started his career mowing lawns for neighbors while he was in junior high school. Jim worked summers for the local golf course while he was in high school and now t ...

  • 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