Using the information in the t-accounts classified balance

Assignment Help Cost Accounting
Reference no: EM13849969


Purpose of Quiz: This take-home quiz has been designed to help you assess your level of accounting knowledge relative to our  expectations of a student entering ACTG 381. This quiz focuses on understanding T-accounts, recording basic accounting transactions/journal entries and creating a set of financial statements. It is also intended as an opportunity to practice using basicExcel  functions. The accounting issues included in this quiz are assumed to have been covered in your prerequisite financial accounting course. If you need a reference, you could refer to the textbook from your prerequisite accounting course or Chapter 3 in the textbook   for this class. Students who are unable to successfully complete this quiz should at a minimum take ACTG 281 concurrent with ACTG 381.


1. Using the Excel spreadsheet "ACTG 381 - Fall 2015 Intro Mechanics Quiz (WS)", record the transactions listed below and the necessary month-end adjusting journal entries in the appropriate T-accounts (see Required A. and B. below). Please also place the  number of each transaction next to T-account entry (see transaction "1" below and in the Excel T-account sheet for an example). TIP:   Set up your spreadsheet to have debit and credit control totals so that you can check after each entry to see if you are in balance.

2. In Excel, prepare a "classified" balance sheet as of September 30, 2015 and a "multiple-step"income statement for the year ended   September 30, 2015 (see Required C. below).

You do not need to prepare a Statement of Shareholders' Equity or a Statement of Cash Flows.

Due Date: Your Excel solution must be posted to the class D2L website Dropbox by Tuesday,October 6, 2015, 7:00 AM. Late assignments will receive a score of zero as we will be going over the solution in class on Tuesday.

Background: Multi Step Running, Inc. ("MSR") was established in 2005 and is owned by Shannon and Kirk Smith. The store caters to both new and experienced runners and offers everything from running shoes, clothes and supplies to fun runs as well as a sponsored  running club. The company considers its product sales to be its primary business and its annual Labor Day 10-K (run in early September)  and any coaching revenue to be other non-operating revenue. The company has ahandful of sales employees and one  person in the office, Claudia, who handles most administrative matters including best-efforts accounting. In September 2015 MSR hires you as an accounting intern (running and accounting, your two favorite things!). The company has a September 30th year end. 


A. Claudia has just provided you with the attached preliminary unadjusted trial balance for August31, 2015. Except for any adjustments  noted below, assume this trial balance has been correctly prepared. Claudia likes to work with T-accounts. She asks that you record   each of the August 31, 2015 unadjusted trial balance amounts in the attached T-account worksheet as beginning balances. The first beginning balance and transaction has been recorded for you.

B. The following September 2015 transactions should be recorded in the T-accounts, using the template provided:

1) $26,000 of vendor invoices were paid during September. These invoices had already been accrued into accounts payable in August

2) The company received a shipment of shoes on September 12th. The invoice cost totaled $25,800 and the shipping costs were an     additional $500. Both are expected to be paid in October.

3) The following invoices totaling $22,410 were also received and recorded (to be paid in October):
- $4,360 for banners and other supplies related to the 10-K run (all expenses associated with the 10-K are considered promotion expense)

- $2,200 for insurance expense for the month of September

- $3,850 for utilities expense for the month of September

- $12,000 for rent for the month of September

4) $64,913 of product was sold for cash. This product had a cost of goods sold of $31,850.

5) On September 1st Oregon City High School placed an order for shoes for cross-country season and paid a deposit of $5,000. The  School will take delivery of half of the shoes in September and the other half in October. The sale had a gross margin of 50%.

6) Total September wages were $5,400 and associated payroll taxes were $415. Of the total payroll, $5,000 was paid in September and the remainder will be paid in October. All of  payroll taxes were to be accrued. Claudia also provided you the following information   that she thought may be helpful in preparing the entries for September and the year-end financial statements.

7) On June 30th, the company had acquired new furniture for $3,000. It was incorrectly entered in the accounting records as office  supplies expense.

8) On January 1, 2015, "We be losin' Weight Loss & Running Club" had paid MSR $12,000 advance fee to provide coaching services for all of 2015. Claudia had been properly recording the revenue to coaching revenue each month (up through August).

9) It is company's  policy to follow GAAP and record sales when the product is shipped. You discover that a product which is scheduled to be shipped on October 1, 2015 was recorded as a sale on September 30 (sale on account - no cash received). The amount of the sale and associated cost of goods sold are $2,600 and $1,350, respectively.

10) Bad debt expense has been estimated at $103 for the current year (no charge-off of oldreceivables at this time).

11) The Prepaid Expense account includes a two-year insurance policy purchased on January1, 2015 for $12,000. Claudia has been properly recognizing insurance expense eachmonth (up through August).

12) The building has a useful life of 30 years with no salvage value. The equipment has auseful life of 10 years with an estimated salvage value is $2,250. Depreciation is providedusing the straight line depreciation method. Company policy requires that any equipmentpurchased during the first year will receive a full year of depreciation in the year of acquisition. Claudia had not recorded any depreciation expense during this fiscal year.

13) Interest expense accrued (but not yet  recorded) for the month of September on its longterm debt is $895.

Interest is accrued every month and is paid at the beginning of   each quarter (i.e. October).4) On September 1st MSR declared a dividend of $800, to be paid on October 15, 2015.ACTG 381, Fall 2015 Page 315) A review of the accounts at year-end revealed that fees runners had been payingthroughout the fiscal year for the 2015 run had been incorrectly recorded as goodwill. Atotal of $36,540 of fees had been collected so far this year.

16) The company has yet to receive an invoice, but legal fees for fiscal 2015 have totaled$3,000.17) MSR's income tax rate is 20% of pre-tax income (assume no differences between pre-taxncome for tax and financial statement purposes).

Claudia had not recorded any incometax expense or paid any income tax payments through August. The full amount due forthe 2015 fiscal year was paid on September 30th

.C. Using the information in the T-accounts, prepare the following financial statements "in goodform":- Income statement in "multiple-step" format for the year ended September 30, 2015.- "Classified" balance sheet at September 30, 2015.


Attachment:- ACTG 381 - Fall 2015 Intro Mechanics Quiz (WS).xlsx

Reference no: EM13849969

Previous Q& A

  A particle with the mass of a proton is trapped in a box

A particle with the mass of a proton is trapped in a box. The particle falls from the state to the state and emits 0.16 meV of energy. What is the size of the box?  (nm

  Determine the minimum electric potential difference

Determine the minimum electric potential difference (in volts) that must be applied to accelerate an a-particle so that on interaction with a hydrogen atom, a ground state electron will be excited to n = 6

  What is the value of the firm

You are going to value Lauryn’s Doll Co. using the FCF model. After consulting various sources, you find that Lauryn has a reported equity beta of 1.6, a debt-to-equity ratio of .3, and a tax rate of 30 percent. Assume a risk-free rate of 5 percent a..

  Summaries article relevant to immigrant or refugee group

At least five internet sites and/or articles that you have found to locate the necessary information about your chosen group; include a summary about each source that explains the information available from the source

  Zero estimated salvage value on straight-line basis

Mom’s Cookies, Inc., is considering the purchase of a new cookie oven. The original cost of the old oven was $41,000; it is now five years old, and it has a current market value of $18,000. The old oven is being depreciated over a 10-year life toward..

  Accumulated on the day that he retires

After retirement, Mario expects to live another 25 years. If he requires $120,000 at the end of each year and interest rates are 7%, how much will Mario need to have accumulated on the day that he retires?

  Critical components of the affordable care act

Use the Internet or Strayer databases to assess critical components of the Affordable Care Act, and predict the economic impact of those components on the overall U.S. healthcare system over the next decade

  Impact of the internet on working capital management

Explain and discuss the impact of the internet on working capital management based on the textbook reading and your own experience

  Communications is new firm in rapidly growing industry

Combined Communications is a new firm in a rapidly growing industry. The company is planning on increasing its annual dividend by 23 percent a year for the next 4 years and then decreasing the growth rate to 4 percent per year. The company just paid ..

  Discuss viable entry strategies that australian firms use

Discuss three viable entry strategies that Australian or New Zealand firms could use if they establish a presence in Indonesia.


Write a Review


Similar Q& A

  Describe how you would deal with his ethical dilemma

What should John do? Describe how you would deal with his ethical dilemma (considering the IMA code of ethics in your response).

  What amount of cash will brandy creditors receive

Define the term business liquidation and what amount of cash will Brandy creditors receive?

  Would you recommend the acceptance of this proposal

Would you recommend the acceptance of this proposal? Why or why not. Prepare a short double spaced Word paper elaborating and supporting your answer.

  Evaluate the cash balance

Evaluate the cash balance at the end of the first year for Alpaca Corporation

  What revenues are projected for march

Revenue projections for the coming year are $47,500 for January and $50,000 for February. Cash receipts of $50,600 are expected in March. What revenues are projected for March?

  Production of kicker speaker lines

Classify each of these transactions as an operating activity, an investing activity, or a financing activity. Also, indicate whether the activity is a source of cash or a use of cash.

  How much will net operating income increase

If the army's offer is accepted, by how much will net operating income increase or decrease from what it would be if the 9,300 pairs were sold through regular channels

  Using the indirect method

1. Using the indirect method, compute the net cash provided by operating activities for Year 2.2. Prepare a statement of cash flows for Year 2.

  Prepare a schedule of cost of goods manufactured

Gentry Print Shop prepares the schedule and financial statements on a yearly basis Cost of goods manufactured schedule - Income statement

  What is the balance in dowells lease liability

What is the balance in Dowell's lease liability? An amortization schedule will be helpful in determining this amount.

  Prepare a budgeted income statement for 2013

Prepare a budgeted income statement for 2013 and a budgeted balance sheet at December 31, 2013. In preparing the income statement, you will need to compute cost of goods manufactured

  Explain the primary ways in which finance leases

Evaluate whether ABC Wines should go ahead with the installation of the new irrigation system and whether they should use the purchase or the lease option.

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