Question

In: Accounting

create a trial balance in the proper order. Then prepare a multi-step income statement, statement of...

create a trial balance in the proper order. Then prepare a multi-step income statement, statement of retained earnings, and a classified balance sheet.

Company
Account Data
Account Name December 31, 2016
Accounts payable 25,309
Accounts receivable 8,576
Accumulated depreciation - PPE 13,327
Additional paid in capital 16,201
Allowance for uncollectable accounts 237
Bonds payable -long term 7,694
Cash 19,334
Common stock 5
Cost of goods sold 88,265
Depreciation expense 167
General and Administrative expense 2,432
Goodwill 3,784
Income tax expense 1,425
Interest expense 484
Interest income 100
Inventories 11,461
Long-term payables 12,607
Marketable securities 6,647
Marketing expense 7,233
Other assets (long term) 4,723
Other current liabilities (accrued expenses) 13,739
Other expense 96
Other income 90
Product Sales 94,665
Property Plant and Equipment 42,441
Retained earnings (1/1/2016) 2,545
Service Sales 41,322
Shipping expense (Fulfillment expense) 17,619
Technology expense 16,085
Treasury stock 1,837
Unearned Revenue 4,768
Check Figures:
Net Income     $         2,371
Ending Retained Earnings $         4,916
Total Assets   $      83,402

Solutions

Expert Solution

Part 1 - Trial Balance

Particulars Debit Credit
Accounts Payable 25309
Accounts Receivable 8576
Accumulated Depreciation - PPE 13327
Additional paid in capital 16201
Allowance for uncollectible accounts 237
Bonds Payable - Long term 7694
Cash 19334
Common stock 5
Cost of goods sold 88265
Depreciation 167
General and admin expenses 2432
Goodwill 3784
Income tax expenses 1425
Interest expenses 484
Interest Income 100
Inventories 11461
Long term payable 12607
Marketable securities 6647
Marketing expenses 7233
Other Assets (long term) 4723
Other Current Liabilities 13739
Other expenses 96
Other Income 90
Product sales 94665
Plant property and equipment 42441
Retained Earnings 2545
Service sales 41322
Shipping expenses 17619
Technology expenses 16085
Treasury stock 1837
Unearned Revenue 4768
Totalc $232609 $232609

Part 2 - Multi Step Income Statement

Particulars Amount
Product sales $94665
Service sales $41322 $135987
Less : Cost of Goods Sold ($88265)
Less : General and administrative expenses ($2432)
Less : Selling Expenses
Depreciation $167
Marketing Expenses $7233
Shipping Expenses $17619
Technology expenses $16085 ($41104)
Other Income $90
Other Expenses ($96)
Interest Expenses ($484)
Interest Income $100

Income Before Tax

Less : Income Tax

$4186

$1425

Net Income $2371

Part 3 - Statement of Retained Earnings

Particulars Amount
Beginning Retained Earnings Balance $2545
+ Net Income $2371
Ending Retained Earning Balance $4916

Part 4 - Classified Balance sheet

Assets Amount Liabilities & Equity Amount
Current Assets Current Liability
Cash $19334 Accounts Payable $25309
Accounts Receivable, Net of Allowance for uncollectible account ($8576 - $237) $8339 Other Current Liabilities $13739
Inventories $11461 $39134 Unearned Revenue $4768 $43816
Investments Long Term Liabilities
Marketable Securities $6647 Bond Payable $7694
Long Term Payable $12607 $20301
Long Term Assets
Other assets $4723 Equity
Retained Earnings $4916
Plant property and Equipment Common Stock $5
Plant Property and Equipment $42441 + Additional paid in capital $16201
Less : Accumulated Depreciatiom ($13327) $29114 - Treasury Stock ($1837) $14369
Intangible Assets
Goodwill $3784
Total Assets $83402 Total Equity and Liabilities $83402

Related Solutions

Instruction: Prepare a classified balance sheet, multi-step income statement and statement of Cash flows for the...
Instruction: Prepare a classified balance sheet, multi-step income statement and statement of Cash flows for the year ending 12/31/2018 The trial balances for the beginning of the year and End of the year, as well as Additional information, are provided below. The name of the company is: Rockford Plumbing Supply, Inc. Final (Ending) Trial Balance - 12/31/2018 Account Name Debit Credit 101 Cash 431,794 105 Petty Cash 150 112 Accounts Receivable 464,550 113 Allowance for Doubtful Accounts 40,178 115 Notes...
Instruction: Prepare a classified balance sheet, multi-step income statement and statement of Cash flows for the...
Instruction: Prepare a classified balance sheet, multi-step income statement and statement of Cash flows for the year ending 12/31/2018 The trial balances for the beginning of the year and End of the year, as well as Additional information, are provided below. The name of the company is: Rockford Plumbing Supply, Inc. Final (Ending) Trial Balance - 12/31/2018 Account Name Debit Credit 101 Cash 431,794 105 Petty Cash 150 112 Accounts Receivable 464,550 113 Allowance for Doubtful Accounts 40,178 115 Notes...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 84,000 Operating Expenses $ 77,000 Common Stock 100,000 Cash Flow from Investing Activities 93,400 Notes Receivable (short term) 39,000 Prepaid Rent 14,000 Allowance for...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 79,000 Operating Expenses $ 72,000 Common Stock 100,000 Cash Flow from Investing Activities 88,400 Notes Receivable (short term) 34,000 Prepaid Rent 13,500 Allowance for...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman...
Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 75,000 Operating Expenses $ 68,000 Common Stock 100,000 Cash Flow from Investing Activities 84,400 Notes Receivable (short term) 30,000 Prepaid Rent 13,100 Allowance for...
Prepare a multi step income statement, statement of retained earnings and classified balance sheet NFT Consulting...
Prepare a multi step income statement, statement of retained earnings and classified balance sheet NFT Consulting and Sales Inc PARTIALLY ADJUSTED TRIAL BALANCE October 31 2017 Part Adj T/B October Jes Trial Balance Adj Jes Adj T/B DR CR DR CR DR CR DR CR DR CR Cash $332,218         332,218         332,218 Accounts Receivable 146,800 16,275         163,075             4,109         158,966 Allowance for Uncollectible Accounts $3,689             3,689                388             4,077 Supplies 42,600           42,600           42,600...
Multi-step Income Statement & Classified Balance Sheet Presented below is information from the trial balance (out...
Multi-step Income Statement & Classified Balance Sheet Presented below is information from the trial balance (out of account order-had to give you a little bit of a challenge) for DDD Corporation for the year ended December 31, 2017. Prepare a multi-step income statement and classified balance sheet in proper form. DDD is a coffee company and has decided to discontinue its entire manugacturing division and retain its retail operations. Debit Credit Accounts Payable        70,000 Accounts Receivable           60,000 Accumulated...
For this project, we will prepare a multi-step income statement and statement of retained earnings, and...
For this project, we will prepare a multi-step income statement and statement of retained earnings, and a classified balance sheet. Make sure that each of your financial statements includes a heading with the appropriate date. Prepare the Financial Statements for the year for McDuck Corporation -- a multi-step income statement, a statement of retained earnings, and a classified balance sheet Below is the Trial Balance for McDuck Corporation on December 31, 2020 Accounts Payable 4,160 Accounts Receivable 3,250 Accum. Amort....
I need to create a multi step income statement and statement of retained earnings with the...
I need to create a multi step income statement and statement of retained earnings with the following information ( assume a 30% tax rate and 500,000 shares of common stock) Accounts Receivable                       $555,000 Accumulated Depr.-equipment          450,000 Accumulated Depr.-buildings            360,000 Allowance for doubtful accts.              36,000 Common Stock                           2,000,000 Depreciation Expense (equipment)      50,000 Depreciation Expense (buildings)         60,000 Dividends (common stock)               120,000 Dividends Payable                            30,000 Insurance Expense                             35,000 Interest Expense                               40,000 Interest Payable                          ...
I need to create a multi step income statement and statement of retained earnings with the...
I need to create a multi step income statement and statement of retained earnings with the following information ( assume a 30% tax rate and 500,000 shares of common stock) Accounts Receivable                       $555,000 Accumulated Depr.-equipment          450,000 Accumulated Depr.-buildings            360,000 Allowance for doubtful accts.              36,000 Common Stock                           2,000,000 Depreciation Expense (equipment)      50,000 Depreciation Expense (buildings)         60,000 Dividends (common stock)               120,000 Dividends Payable                            30,000 Insurance Expense                             35,000 Interest Expense                               40,000 Interest Payable                          ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT