Question

In: Accounting

The Income Statement and Balance Sheet columns below are from the work sheet of the Mandle...

The Income Statement and Balance Sheet columns below are from the work sheet of the Mandle Company for the year ended December 31, 20--.

Mandle Company
Work Sheet (partial)
For the year ended December 31, 20--
Income Statement Balance Sheet
Account Title Debit Credit Debit Credit
Cash 24,000
Accounts Receivable 12,500
Merchandise Inventory 8,000
Store Supplies 550
Office Supplies 1,200
Prepaid Insurance 750
Store Equipment 33,000
Accumulated Depreciation—Store Equipment 19,000
Office Equipment 9,000
Accumulated Depreciation—Office Equipment 5,000
Accounts Payable 9,900
Salaries Payable 200
Long-Term Notes Payable 18,000
H. Mandle, Capital 45,300
H. Mandle, Drawing 16,000
Income Summary 8,500 8,000
Sales 31,000
Sales Returns and Allowances 250
Purchases 13,500
Purchases Returns and Allowances 350
Purchases Discounts 200
Sales Salary Expense (selling) 4,600
Office Salary Expense (general) 3,500
Store Supplies Expense (selling) 150
Office Supplies Expense (general) 200
Insurance Expense (general) 400
Depreciation Expense-Store Equipment (selling) 400
Depreciation Expense-Office Equipment (general) 450
31,950 39,550 105,000 97,400
Net Income 7,600 7,600
39,550 39,550 105,000 105,000

Required:

Prepare a multi-step income statement for Mandle Company for the current fiscal year. Include separate sections for selling expenses and general expenses under the heading "Operating Expenses" by using the classifications provided in the Account Title column of the work sheet.

Mandle Company
Income Statement
For the year ended December 31, 20--
Revenue:
Sales $
Less Sales returns and allowances
Net sales $
Cost of goods sold:
Merchandise inventory, January 1, 20-- $
Purchases $
Less Purchases returns and allowances $
Less Purchases discounts
Net purchases
Goods available for sale $
Less merchandise inventory, December 31, 20--
Cost of goods sold
Gross profit $
Operating expenses:
Selling expenses:
Sales salary expense $
Store supplies expense
Depreciation expense-store equipment
Total selling expenses $
General expenses:
Office salary expense $
Office supplies expense
Insurance expense
Depreciation expense-office equipment
Total general expenses
Total operating expenses
Net income $

Solutions

Expert Solution

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!

Mandle Company
Income Statement Amount $ Amount $
Sales    31,000.00
Less: Sales returns and allowances         250.00
Net sales    30,750.00
Cost of goods sold:
Merchandise inventory, January 1, 20--      8,500.00
Add: Purchases    13,500.00
Less: Purchases returns and allowances         350.00
Less: Purchases discounts         200.00
Net purchases    12,950.00
Goods available for sale    21,450.00
Less merchandise inventory, December 31, 20--      8,000.00
Cost of goods sold    13,450.00
Gross profit    17,300.00
Operating expenses:
Selling expenses:
Sales salary expense      4,600.00
Store supplies expense         150.00
Depreciation expense-store equipment         400.00
Total selling expenses      5,150.00
General expenses:
Office salary expense      3,500.00
Office supplies expense         200.00
Insurance expense         400.00
Depreciation expense-office equipment         450.00
Total general expenses      4,550.00
Total operating expenses      9,700.00
Net income      7,600.00

Related Solutions

The amounts below appeared in the Income Statement and Balance Sheet columns of a company's December...
The amounts below appeared in the Income Statement and Balance Sheet columns of a company's December 31 work sheet. In the space provided give without explanation the closing entries on December 31.                                                                                             Trial Balance                                                                            Debit           Credit                                                 Assets other than merchandise                 7500                                                     Accounts receivable                                  4500                                                     Liabilities                                                                       3000                                                   Common Stock                                                              7500                               Dividends                                                 1500                                 Sales                                                                           19,500             Salaries expense                                    11,250             Other operating expenses                        5,250           _____                                                               Total                                           30000          30,000                     
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a private company reporting under ASPE, for the year ended December 31. Martinez Inc. Comparative Balance Sheet, at December 31 2017 2016 Cash                                                                                 $92,150                $46,150 Accounts receivable 90,700                  36,150 Inventory                                                                           122,000                102,550 Investments in land 85,100                  107,150 Property, plant, and equipment 285,200                201,000 Accumulated depreciation (48,260)               (40,000)                                                                                         $626,890             $454,000 Accounts payable                                                             52,700                   48,410 Accrued liabilities                                                            ...
Below are numbers from a balance sheet and income statement. Based on these numbers calculate the...
Below are numbers from a balance sheet and income statement. Based on these numbers calculate the financial ratios requested below. All answers must be rounded to TWO decimal places including percentages Sales 421756 Operating Costs 313053 Depreciation Expense 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 52175 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 62175 Based on these values calculate: Current ratio Quick ratio NWC-to-total-Assets (Working capital to assets)...
From the information below prepare, in proper accounting form the, Income Statement, Balance Sheet, and Statement...
From the information below prepare, in proper accounting form the, Income Statement, Balance Sheet, and Statement of Changes in Owners’ Equity, and Statement of Cash Flows for 2016 and 2017. In your Income Statement Calculation, include Subtotals for EBITDA, EBIT, and EBT in addition to Net Income. You must submit your answers in either a MS Word or an MS Excel file. TANDY COMPANY Year Ending 6/30/2017 6/30/2016 6/30/2015 Common Stock 100,000 shares outstanding $460,000 $460,000 $460,000 Net Receivables 632,160...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 443555 Operating Costs 326133 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 54355 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 64355 Prepare an income statement and a balance sheet for is company using the information provided. Calculate: 1. Current ratio 2. Quick ratio 3. NWC-to-total-Assets (Working capital to assets) 4. Ratio...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 499891 Operating Costs 359935 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 59989 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 69989 6. Interest coverage 7. Net profit margin 8. Sales to total assets (Asset turnover) 9. Return on assets 10. Equity multiplier 11. Return on equity
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $...
The balance sheet and income statement shown below are for Byrd Inc. BALANCE SHEET Cash $ 140.0 Accounts payable $800.0 Accts. Receivable 880.0 Notes payable ` 600.0 Inventories 1,320.0 Accruals 400.0 Total current assets 2,340.0 Total current liabilities 1,800.0 Long-term bonds 1,000.0 Total debt 2,800.0 Common stock 200.0 (50,000 shares) Retained earnings 1,000.0 Net plant & equip 1,660.0 Total common equity 1,200.0 Total assets $4,000.0 Total liabilities & equity $4,000.0 INCOME STATEMENT Net sales $6,000.0 Operating costs 5,599.8 Depreciation 100.2...
Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the...
Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the year 2012. Please show your workings for the related questions below (yes, all together!). If your final answers (below) are incorrect, I'll review your workings to grant partial credit. Trial Balance as at 31st December 2012 Trial Balance Dr Cr Sales 240,000 Purchases 150,000 Returns inwards 5,000 Returns outwards 6,000 Carriage Inwards 3,000 Inventory 1.1.2012 80,000 Salaries 25,000 Electricity and telephone 4,000 Rent 5,000...
Using the information presented below, prepare an income statement and the balance sheet from the adjusted...
Using the information presented below, prepare an income statement and the balance sheet from the adjusted trial balance of McTangy Spices. McTangy Spices. Adjusted Trial Balance December 31 Cash %bodyamp;nbsp; 3,050 Accounts receivable 400 Prepaid insurance 830 Office supplies 80 Office equipment 4,200 Accumulated depreciation–office equipment $ 1,100 Buildings 98,000 Accumulated depreciation–buildings 28,000 Land 115,000 Wages Payable 880 Property taxes payable 1,400 Interest payable 2,200 Unearned rent 460 Notes payable 150,000 McTangy Spices, Capital Stock 40,340 McTangy Spices, Dividends 21,000...
Below are balance sheet and income statement data for Howard Bannister Company.  Note: For the balance sheet...
Below are balance sheet and income statement data for Howard Bannister Company.  Note: For the balance sheet data, the end-of-year information is in the left column. Balance Sheet Data   20X2   20X1 Accounts Payable................................................................................................ 95............................................................. 165 Accumulated Depreciation................................................................................ 520 ...........................................................339 Cash      ................................................................................................................ 130 ..........................................................100 Common Stock ..............................................................................................    1,000......................................................... 700 DIVIDENDS PAYABLE......................................................................................... 40............................................................ 25 Equipment......................................................................................................... 2,395....................................................... 2,700 Income Tax Payable ..........................................................................................100............................................................ 135 Inventory.......................................................................................................... 1,120........................................................... 890 Mortgage Payable.............................................................................................. 900......................................................... 1,500 Prepaid General Expenses............................................................................... 300............................................................. 350 Retained Earnings (ending balance, after closing)...................................... 1,240...................................................... 1,098 Unearned Sales Revenue.....................................................................................
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT