Question
I have done the work I'm just wondering what I'm missing and because I can't attach an excel sheet it makes it hard to get
I have done the work I'm just wondering what I'm missing and because I can't attach an excel sheet it makes it hard to get it on here.
I'm not seeing what number I'm missing or if I put amount in the wrong spot? I have included the question and my answers for 1, 4 and 5.
1. The list of accounts below and the unadjusted balances of these accounts were taken from the ledger of the Manville Corporation at the end of their accounting period, March 31, 20X2: Cash $ 3,995 Accounts Receivable 13,240 Allowance for Doubtful Accounts 120 InventoryApril 1, 20X1 22,800 Prepaid Insurance 360 Supplies on Hand 520 Equipment 15,000 Accumulated DepreciationEquipment 4,500 Accounts Payable 11,870 Taxes Payable 390 Capital Stock 25,000 Retained Earnings 11,920 Dividends 9,000 Sales 89,490 Sales Returns and Allowances 920 Sales Discounts 1,330 Purchases 56,320 Purchase Returns and Allowances 490 Purchase Discounts 1,125 Transportation-In 880 Sales Salaries 11,800 Rent Expense 3,600 Advertising Expense 2,700 Utilities Expense 1,880 Maintenance Expense 560 Additional data: a. Merchandise inventory at March 31, 20X2, was $23,300. b. The Allowance for Doubtful Accounts should be increased by $600. c. Prepaid insurance represents a three-year policy purchased April 1, 20X1. d. Supplies on hand were estimated to be $170 on March 31, 20X2. e. The cost of the equipment is being depreciated over a 15-year estimated life using the straight-line method. Salvage value should be ignored. f. Unpaid sales salaries on March 31, 20X2, amounted to $200. REQUIRED: 1. Prepare a work sheet. (Adjusted trial balance columns may be omitted.) 2. Prepare an income statement. 3. Prepare a statement of retained earnings. 4. Prepare a balance sheet. 5. Prepare the closing entries.
Manville Corporation
Work Sheet
For the Month Ended March 31, 20X2
Trial Balance Adjustments Income StatementRetained Earnings Statement Balance Sheet
DR CR DR CR DR CR DR CR DR CR DR CR
Cash 3995 3995
Acc pay 13240 13240
All Doubtful 120 b)600
Mech inven
Manville Corporation
Work Sheet
For the Month Ended March 31, 20X2
Trial Adjustments Income Retained Balance Sheet
Balance Statement Earnings
DR CR DR CR DR CR DR CR DR CR
Cash 3995 3995
Account Rec 13240 13240
Allow Doubtful Acou 120 (b) 600 720
Merch Inventory22800 22800
Prepaid Insurance 360 (c)1080 720
Supplies on Hand 520 (d) 170 350
Equipment 15000 15000
Accum depr Equip4500 (e)300 4800
Account Payable 11870 11870
Taxes Payable 390 390
Capital Stock 25000 25000
Retained Earning 11920 11920
Dividends 9000 9000
Sales 89490 89490
Sales Ret & Allow920 920
Sales Discounts1330 1330
Purchases 56320 56320
Pur Retu & Allow490 490
Purchases Discounts 1125 1125
Transport-In 880 880
Sales Salaries11800 (f) 200 12000
Rent Expense3600 3600
Advertising 2700 2700
Utilities 1880 1880
Maint Exp 560 560
Totals 144905 144905
Mechandise Inventory March 31, 20X2 (a)23300 23300
Allowance For Doubtful Accounts (b) 600 600
Prepaid Insurance (c)1080 1080
Supplies on Hand (d) 170 170
Accumulated Depreciation Equip (e)300 300
Sales Salaries (f) 200
2350 2350 104540 121005
Net Income 16465 16465
121005 121005 9000 28385 56605 42780
Retained Earnings From March 31 19385 19385
28385 28385 56605 62165
4) Maniville Corporation
Balance Sheet
March 31, 20X2
Assets
Current Assets
Cash in Bank 3995
Accounts Receivable 13240
Less: Allowance for Doubtful Accounts 120 13120
Merchandise Inventory 23300
Supplies on Hand 520
Prepaid Insurance 360
Total Current Asset 41295
Property, Plant, & Equipment
Equipment 15000
Less: Accumulated Depreciation 4500
Total Property, Plant, & Equipment 10500 10500
Total Assents 51795
Liabilties & Stockholders' Equity
Current Liabilties:
Accounts Payable 11870
Taxes Payable 390
Total Current Liabilties 12260
Stockholders' Equity
Capital Stock 25000
Total Contributed Capital 25000
Retained Earnings 11920
Total Liabilties & Stockholders' Equity 13080
25340
77135
5General Journal
POST
DATE ACCOUNT TITLES AND EXPLANATION REF. DEBIT CREDIT
20X2 March
31 Insurance Expense 710 720
Prepaid Insurance 130 720
To record the insurance expense and adjust the
prepaid insurance account at year-end
31 Uncollectible Accounts Expense 712 600
Allowance for Doubtful Accounts 109 600
To record the estimated bad debits resulting from credit sales
31 Supplies Expense 708 350
Supplies on Hand 125 350
To record the supplies expense and adjust the Supplies on Hand
account at year-end
31 Payroll Tax Expense 703 390
Taxes Payable 312 390
To record the employer's taxes on the above payroll
31 Depreciation-Equipment 722 4800
Accumulated Depreciation-Equipment 211 4800
To record depreciation for the mont of March 20x2
31 Sales Salaries 700 12000
Sales Salaries 701 12000
To record earned but unpaid salaries of March 31, 20X2
31 Merchanise Inventory 120 22800
Sales 500 89490
Purchase Returns and Allowances 601 490
Purchase Discounts 602 1125
Dividend Income 761 9000
Income summary 499 122905
To record the ending merchandise inventory and
close all temporary accounts having credit balances
31 Income Summary 499 104540
Merchandise Inventory 120 22800
Sales Returns and Allowarnces 505 920
Sales Discounts 506 1330
Purchases 600 56320
Transport-In 603 880
Sales Salaries 700 12000
Rent Expense 705 3600
Payroll Tax Expense 703 390
Advertising Expense 706 2700
Utilities Expense 707 1880
Uncollectible Accounts Expense 712 600
Insurance Expense 710 720
Depreciation-Equipment 722 4800
Tor remove the beginning merchandise inventory
abd close all tempoary accounts having debit balances
31 Income Summary 499 16465
Retained Earnings 420 16465
To close the Income Summary account and transfer
the net income to the Retanined Earnings account
31 Retained Earning 420 9000
Dividends 451 9000
To close the dividend accounts to the Retained
Earnings accounts
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started