Prepare a detailed income statement

Assignment Help Accounting Basics
Reference no: EM131714680

PROBLEM

Le Bere Office Supplies Company
Work Sheet
For the Year Ended September 30, 19x4

Account Name

Trial Balance

Adjustments

Income Statement

Balance Sheet

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Cash

Accounts Receivable

21,150'

74,490

 

 

 

 

 

21,150
74,490

 

Merchandise Inventory

214,200

 

 

 

214,200

266,700

266,700

 

Store Supplies

11,400

 

 

(a)          9,750

 

 

1,650

 

Prepaid Insurance

14,400

 

 

(b) 7,200

 

 

7,200

 

Store Equipment

253,900

 

 

 

 

 

253,900

 

Accumulated Depreciation Store Equipment

 

76,500

 

(c) 15,000

 

 

 

91,500

Accounts Payable

 

116,850

 

(e)             300

 

 

 

117,150

Grace Le Bere, Capital

 

484,050

 

 

 

 

 

484,050

Grace Le Bere, Withdrawals

72,000

 

 

 

 

 

72,000

 

Sales

 

1,225,750

 

 

 

1,225,750

 

 

Sales Returns and
Allowances

25,440

 

 

 

25,440

 

 

 

Purchases

754,800

 

 

 

754,800

 

 

 

Purchases Returns and Allowances

 

18,150

 

 

 

18,150

 

 

FreisEht In

31,200

 

 

 

31,200

 

 

 

Sales Salaries Expense

193,800

 

(d)          1,950

 

195,750

 

 

 

Rent Expense

144,000

 

 

 

144,000

 

 

 

Other Selling Expenses

98,730

 

 

 

98,730

 

 

 

Utilities Expense

11,790

 

(e)             300

 

12,090

 

 

 

 

L921,300

1,921,300

 

 

 

 

 

 

Store Supplies Expense

 

 

(a)          9,750

 

9,750

 

 

 

Insurance Expense

 

 

(b) 7,200

 

7,200

 

 

 

Depreciation Expense,
Store Equipment

 

 

(c) 15,000

 

15,000

 

 

 

Sales Salaries Payable

 

 

 

(d) 1,950

 

 

 

1,950

 

 

 

34,200

34,200

1,508,160

1,510,600

697,090

694,650

Net Income

 

 

 

 

 

 

 

 

1. Complete the totals in columns 5 through 8 of the worksheet.

2. Prepare a detailed Income Statement [see the format on page 281 (Exhibit 10) and 291 (Exhibit 16) of the textbook as an example]. Prepare both Exhibits for your quiz.

3. Compute 'the Gross Profit (GP) ratio and the Inventory Turnover. See pgs 340 - 344 (Chp 7). (a) GP =Net Sales - COGS (pages 265 & 282). GP ratio = "Gross Profit' / "Net Sales" .

4. Prepare the closing entries (assume periodic inventory). See pages 291 - 292. [ Bonus; 6 pts

NOTE: The Merchandise Inventory amounts in the Income Statement and Balance Sheet of the worksheet ; $214,200 (Beg Inv.) and $266,700 (End Inv). See pages 289-292 of textbook.

Verified Expert

I have completed the assignment of worksheet of Le Bere office company for the year ended September 30, 19x4 on my best knowledge and skill and palagrism free. In this assignment I have completed the total column worksheet, compute the Gross profit and Inventory turnover Ratio and Prepared detailed Income and statement along with closing entries.

Reference no: EM131714680

Questions Cloud

Number of heads and the number of tails : Then repeat that trial eleven more times for a totalof twelve trials and 120 tosses. Did you ever get seven (or more) heads in a trial often tosses?
The manager of deli section of grocery superstore : The manager of the deli section of a grocery superstore has just learned that the department has 112 pounds of mayonnaise,
What characteristics must an effective counselor possess : Why are counseling theories important to professional counselors? What characteristics must an effective counselor possess?
Examination in mathematics and statistics : In an entrance examination in Mathematics and Statistics, of the 120 students appeared for the examination, 65 passed in Mathematics, 75 passed in Statistics
Prepare a detailed income statement : Prepare a detailed Income Statement - Compute the Gross Profit (GP) ratio and the Inventory Turnover - Prepare the closing entries
Describe the landlord duty to mitigate damages : Describe the landlord’s duty to mitigate damages as set for this in this provision. Provide an example of when landlord’s duty to mitigate damages is triggered
Report on accounting information system for organisation : Write a report as the accounts manager for an organisation looking at purchasing an accounting information system
Estimate a population proportion p : Suppose you need to estimate a population proportion p with a 95% confidence interval of total width 0.06.
How your choices highlight the historical points : What would you highlight? You must include a paragraph explaining how your choices highlight the historical points you are trying to make.

Reviews

inf1714680

4/1/2018 5:56:16 AM

Good I got nice marks and I have recommended my friends to use this site for their assignment and there projects. thank you i was really afraid during the submission but the result was too good. thanks a lot.

Write a Review

Accounting Basics Questions & Answers

  Actual materials and supplies for the month

For the month of November, the company planned for activity of 85 vehicles, but the actual level of activity was 50 vehicles. The actual materials and supplies for the month was $2,530.

  How would that income be measured

Can you explain how to determine whether gallery should treat the donation as income? Further if donation is treated as income, how would that income measured

  Prepare the consolidation worksheet journal entries

Prepare the consolidation worksheet journal entries for the year ended 30 June 2017. Include narrations and show any relevant workings also in the narrations

  Is a companys pbo reported in the balance sheet

Is a company's PBO reported in the balance sheet? Its plan assets? Explain.

  Assignment on aggression and violence in the media

Identify the context in which the character(s) demonstrated aggression or violence. Include the gender, age, and culture of the character(s) involved in the aggressive or violent act(s).

  What is the net operating income for the month under

A manufacturing company that produces a single product has provided the following data concerning its most recent month of operations. What is the net operating income for the month under variable costing?

  Baker winery manufactures a fine wine in two departments

baker winery manufactures a fine wine in two departments fermenting and bottling. in the fermenting department grapes

  Assume that canes customers would buy a maximum of 83000

cane company manufactures two products called alpha and beta that sell for 240 and 162 respectively. each product uses

  Business process management principles

Business Process Management Principles

  How are equivalent units of production, unit costs

How are equivalent units of production, unit costs, and inventory values determined using the standard costing method of process costing?

  Analyze the advantages and disadvantages of each method

Analyze the advantages and disadvantages of each method. Provide support for your response.

  Financial information for year ended january 31 2009 is

financial information for year ended january 31 2009 is presented in the text of the chapter. financial information for

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