Question

In: Accounting

Create Trial Balace with T-Accounts. Then Create Income Statement, Statement of Retained Earnings, and finaly a...

Create Trial Balace with T-Accounts. Then Create Income Statement, Statement of Retained Earnings, and finaly a Balance Sheet.

CASH A/C
DEBIT $ AMT CREDIT $ AMT
TO COMMON STOCK 45000 BY PREPAID RENT 9000
TO NOTE PAYABLE 18000 BY PREPAID INSURANCE(9MONTHS) 3600
TO ACCOUNTS RECEIVABLE 4000 BY REFREIGATOR 13000
BY SALES TAX PAYABLE 760 BY DELIVERY VAN 25000
BY SALES TAX PAYABLE 240 BY ADVERTISING EXPENSE 1200
BY SALES TAX PAYABLE 360 BY PREPAID ADVERTISING EXPENSE 300
BY SALES 9500 BY LEGAL EXPENSE 2000
BY SALES 3000 BY ACCOUNTS PAYABLE 850
BY SALES 4500 BY CREDIT CARD EXPENSE 675
BY ACCOUNT PAYABLE 2400
BY ACCOUNTS PAYABLE 21900
BY DIVIDEND 50
INTEREST PAYABLE 22.5
BY NOTE PAYABBLE 452.5
BY CLOSIN BALANCE 4910
85360 85360
COMMON STOCK
DEBIT $ AMT CREDIT $ AMT
BY CLOSING STOCK 45000 BY CASH 45000
45000 45000
PREPAID RENT A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 9000 BY RENT EXPENSE 1500
BY CLOSING BALANCE 7500
9000 9000
PREPAID INSURANCE A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 3600 BY INSURANCE EXPENSE 400
BY CLOSING BALANCE 3200
3600 3600
COMPUTER EQUIPMENT A/C
DEBIT $ AMT CREDIT $ AMT
TO NOTE PAYABLE 2700 BY PROVISION FOR DEPRECIATION 45
BY CLOSING BALANCE 2655
2700 2655
NOTE PAYABLE A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 475 BY COMPUTER EQUIPMENT(OFFICE MART) 2700
BY CASH(WELLS FARGO) 18000
TO CLOSING BALANCE 20225
20700 20700
REFREIGARATOR A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 13000 BY PROVISION FOR DEPRECIATION 100
BY CLOSING BALANCE 12900
13000 12900
DELIVERY VAN A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 25000 BY PROVISION FOR DEPRECIATION 350
BY CLOSING BALANCE 24650
25000 25000
PREPAID ADVERTISING A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 300 BY ADVERTISING EXPENESE 275
BY CLOSING BALANCE 25
300 300
CREDIT CARD EXPENSE A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 675 BY PROFIT AND LOSS A/C 675
675 675
LEGAL EXPENSE A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 2000 BY PROFIT AND LOSS A/C 2000
2000 2000
ADVERTISNG EXPENSE A/C
TO CASH 1200
TO INVENTORY FRUIT 600
TO INVENTORY BASKET 25
TO PREPAID ADVERTISING 275 BY PROFIT AND LOSS A/C 2100
2100 2100
ACCOUNTS PAYABLE A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 850 BY INVENTORY (FRUIT) 16400
TO CASH 2400 BY INVENTORY (BASKETS) 2400
TO CASH 21900 BY SUPPLIES 850
TO CLOSIN BALANCE 250 BY INVENTORY 5500
BY UTILITY EXPENSE 250
25400 25400
INVENTORY A/C
DEBIT $ AMT CREDIT $ AMT
ACCOUNT PAYABLE 16400 BY COGS 2500
ACCOUNT PAYABLE 2400 BY COGS 250
ACCOUNT PAYABLE 5500 BY ADVERTISING 625
BY COGS 3850
BY COGS 3000
BY COGS 3095
BY CLOSING STOCK 10980
24300 24300
ACCOUNT RECEIVABLE A/C
DEBIT $ AMT CREDIT $ AMT
TO SALES 4000 TO CASH 4000
4000 4000
COGS A/C
DEBIT $ AMT CREDIT $ AMT
TO INVENTORY FRUIT 2500
TO INVENTORY BASKETS 250
TO INVENTORY FRUIT 3500
TO INVENTORY BASKETS 350
TO INVENTORY FRUIT 2700
TO INVENTORY BASKETS 300 BY PROFIT AND LOSS ACCOUNT 12695
TO INVENTORY FRUIT 2815
TO INVENTORY BASKETS 280
12695 12695
SALES A/C
DEBIT $ AMT CREDIT $ AMT
CASH 9500
TO PROFIT AND LOSS ACCOUNT 21000 CASH 3000
CASH 4500
ACCOUNT RECEIVABLE 4000
21000 21000
SALES TAX PAYABLE A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 1360 CASH 760
CASH 240
CASH 360
1360 1360
UTILITY EXPENSE A/C
DEBIT $ AMT CREDIT $ AMT
TO ACCOUNT PAYABLE 250
BY PROFIT AND LOSS ACCOUNT 250
250 250
DIVIDEND A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 50
BY PROFIT AND LOSS ACCOUNT 50
50 50
SUPPLIES EXPENSE A/C
DEBIT $ AMT CREDIT $ AMT
TO ACCOUNTS PAYABLE 850
TO SUPPLIES PAYABLE 835 BY PROFIT AND LOSS ACCOUNT 1685
1685 1685
SUPPLIES PAYABLE A/C
DEBIT $ AMT CREDIT $ AMT
BY CLOSING BALANCE 835 BY SUPPLIES 835
835 835
WAGES EXPENSE A/C
DEBIT $ AMT CREDIT $ AMT
TO WAGES PAYABLE 1500 TO CLOSING BALANCE 1500
1500 1500
WAGES PAYABLE A/C
DEBIT $ AMT CREDIT $ AMT
BY CLOSING BALANCE 1500 BY WAGES EXPENSE 1500
1500 1500
DEPRECIATION A/C
DEBIT $ AMT CREDIT $ AMT
TO ACCUMATED DEPRECIATION COMPUTER 45
REFRIGARATOR 100
DELIVERY VAN 350 BY PROFIT AND LOSS ACCOUNT 495
495 495
PROVISION FOR DEPRECIATION A/C
DEBIT $ AMT CREDIT $ AMT
BY ACCUMATED DEPRECIATION COMPUTER 45
TO COMPUTER 45 REFRIGARATOR 100
REFREIGARATOR 100 DELIVERY VAN 350
DELIVERY VAN 350
495 495
INSURANCE EXPENSE A/C
DEBIT $ AMT CREDIT $ AMT
TO PREPAID INSURANCE 400 BY PROFIT AND LOSS A/C 400
400 400
INTEREST EXPENSE A/C
DEBIT $ AMT CREDIT $ AMT
TO INTEREST PAYABLE 120
BY PROFIT AND LOSS A/C 120
120 120
INTEREST PAYABLE A/C
DEBIT $ AMT CREDIT $ AMT
TO CASH 22.5 BY INTEREST EXPENSE 120
TO PROFIT AND LOSS A/C 120 BY NOTE PAYABLE 22.5
142.5 142.5
RENT EXPENSE A/C
DEBIT $ AMT CREDIT $ AMT
TO PREPAID RENT 1500 BY PROFIT AND LOSS A/C 1500
1500 1500

Solutions

Expert Solution

In the given problem, some of the accounts like Equity / Capital account, opening retained earnings balance etc are missing . It is not possible to prepare Balance Sheet and Statemnt of retained earnings without that information. The trail balance also cannot be tallied without those accounts. However, a trail balance with the given balances is prepared. The difference which is attributable to the missing accounts is transferred to Suspense account.

Trial Balance
Particulars Debit Credit
CASH A/C                      4,910.00
COMMON STOCK
PREPAID RENT A/C                      7,500.00
PREPAID INSURANCE A/C                      3,200.00
COMPUTER EQUIPMENT A/C                      2,700.00
NOTE PAYABLE A/C                       20,225.00
REFREIGARATOR A/C                    13,000.00
DELIVERY VAN A/C                    25,000.00
PREPAID ADVERTISING A/C                            25.00
CREDIT CARD EXPENSE A/C                          675.00
LEGAL EXPENSE A/C                      2,000.00
ADVERTISNG EXPENSE A/C                      2,100.00
ACCOUNTS PAYABLE A/C                             250.00
INVENTORY A/C                    10,980.00
ACCOUNT RECEIVABLE A/C                                   -  
COGS A/C                    12,695.00
SALES A/C                       21,000.00
SALES TAX PAYABLE A/C                                      -  
UTILITY EXPENSE A/C                          250.00
DIVIDEND A/C                               50.00
SUPPLIES EXPENSE A/C                      1,685.00
SUPPLIES PAYABLE A/C                             835.00
WAGES EXPENSE A/C                      1,500.00
WAGES PAYABLE A/C                                      -  
DEPRECIATION A/C                          495.00
PROVISION FOR DEPRECIATION A/C
INSURANCE EXPENSE A/C                          400.00
INTEREST PAYABLE A/C                             120.00
RENT EXPENSE A/C                      1,500.00
Suspense account                       48,135.00
                   90,615.00                       90,615.00

Related Solutions

Prepare each item: Journal Entries T-Accounts Trial Balance Adjusted Trial Balance Income Statement Retained Earnings Statement...
Prepare each item: Journal Entries T-Accounts Trial Balance Adjusted Trial Balance Income Statement Retained Earnings Statement Balance Sheet Dinah Soars, Biff Wellington and Duane Pipe are the stockholders of Sharpe Incorporated. The charter of the corporation authorized 500,000 shares of $2 par common stock, and 100,000 shares of $30 par, 4%, preferred stock. As of January 1, 2020, there were 24,000 shares of common stock issued and outstanding and 5,000 shares of preferred stock issued and outstanding. Selected transactions completed...
Prepare "T" Accounts in ACCRUAL and CASH basis the Income statement, Statement of Retained Earnings and...
Prepare "T" Accounts in ACCRUAL and CASH basis the Income statement, Statement of Retained Earnings and Balance Sheet, after reading the following information below. Richard Brandt graduated from York University with his BAS although he spent more time in the gym than in the classrooms and libraries. His parents and grandparents were very proud and happy of this achievement. As a graduation gift, Richard's Grandparents gave him $20,000 to start his own business. So, on September 1, 2015, Richard started...
income statement and retained earnings statement
Misclassifcations Roz Corporation's Multiple-Step income statement and retained earnings statement for the year ended December 31, 2019 as developed by its bookkeeper are shown here: Revenue StatementDecember 31, 2019   Sales (net)     $179,000 Plus: Income from operations of discontinued Division P (net of $960 income taxes)     2,240 Less: Dividends declared ($1.50 per common share)     (7,500) Net revenues     $173,740 Less: Selling expenses     (19,000) Gross profit     $154,740 Less Operating expenses:       Interest expense $4,100     Loss on sale of Division P (net of $1,200 income...
Based on the Trial Balance below and the Statement of Retained Earnings create a Balance Sheet...
Based on the Trial Balance below and the Statement of Retained Earnings create a Balance Sheet Statement: ACCT # Account Name Debit Credit 1000 Cash $402,575 1030 Treasury Bills $100,000 1031 Municiple Bonds $104,425 1032 Investments $770,500 1210 Accounts Receivable $30,000 1400 Inventory $20,000 1500 Furniture and Fixtures $0 1599 Accumulated Depreciation $30,000 2000 Accounts Payable $40,000 3000 Common Stock $0 3500 Retained Earnings $65,000 4000 Gross Sales $3,900,000 4100 Sales Returns $20,000 5000 Cost of Goods Sold $1,080,000 6000...
Please create a retained earnings statement, income statement, and a balance sheet for the month of...
Please create a retained earnings statement, income statement, and a balance sheet for the month of December following accounts and their ending balances. Cash (debit) : $37,308.90 Accounts Receivable (debit) : $11,700 Notes Receivable (debit) : $10,000 Interest Receivable (debit) : $41.67 Merchandise Inventory (debit) : $3,150 Prepaid Advertising (debit) : $250 Office Supplies Inventory (debit) : $180 Prepaid Insurance (debit) : $1,100 Land (debit) : $59,500 Equipment (debit) : $12,000 Accumulated Depreciation - Equipment (credit) : $116.66 Accounts 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                          ...
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                          ...
Create your own Income Statement, Retained Earnings Statement and Balance Sheet. Do not create a Statement...
Create your own Income Statement, Retained Earnings Statement and Balance Sheet. Do not create a Statement of Cash Flows. Make up the name of the company the accounts and the numbers. You will need to plug the cash (or other account) amount to make the Balance Sheet Balance. Assets = Liabilities + Owner's Equity.
Using the adjusted trial balance below, prepare an income statement, statement of retained earnings, and a...
Using the adjusted trial balance below, prepare an income statement, statement of retained earnings, and a balance sheet as of December 31. Download the Excel spreadsheet located in the instructions and use it as a template for your financial statements. Once you have completed the statements, save the file and upload the completed spreadsheet for grading. Parties Plus, Inc. Adjusted Trial Balance December 31 Debit Credit Cash $1,600 Accounts receivable 4,000 Office equipment 16,800 Accumulated depreciation $1,600 Income tax payable...
Using the adjusted trial balance given, prepare a(n) 1) income statement 2) statement of retained earnings...
Using the adjusted trial balance given, prepare a(n) 1) income statement 2) statement of retained earnings 3) balance sheet *in good form. 3 Cs Inc Adjusted Trial Balance December 31, 2017 Account Debit Credit Accounts Payable 120,000 Accounts Receivable 150,000 Accumulated Depreciation 20,000 Bonds Payable 100,000 Cash 70,000 Common Stock 20,000 Cost of Goods Sold 280,000 Depreciation Expense 10,000 Dividends 20,000 Equipment 200,000 Income Taxes Expense 40,000 Interest Payable 5,000 Inventory 60,000 Land 100,000 Note Payable (18 months) 105,000 Paid-in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT