Question

In: Accounting

1. Design Your Own T-Shirt Trial Balance September 30, 2019 DR CR Cash 575,000 Prepaid Insurance...

1.

Design Your Own T-Shirt

Trial Balance

September 30, 2019

DR

CR

Cash

575,000

Prepaid Insurance

1,890,000

Office Equipment

4,500,000

Accumulated Depreciation, Office Equipment

680,000

Inventory

2,250,000

Accounts Receivable

1,500,000

Estimated Returns Inventory

175,000

Notes Payable (Due in 6 months)

339,900

Notes Payable (Due in 2025)

2,360,000

Office Supplies

395,000

Store Equipment

5,000,000

Accumulated Depreciation, Store Equipment

1,825,000

Accounts Payable

1,025,000

Salaries Payable

295,600

Customer Refunds Payable

210,000

Retained Earnings, January 1

3,000,000

Dividends

100,000

Cost of Goods Sold

5,000,000

Sales

12,500,000

Common Stock

3,500,000

Office Supplies Expense

65,000

Depreciation Expense, Store Equipment

225,000

Depreciation Expense, Office Equipment

80,000

Interest Expense

97,600

Miscellaneous Selling Expense

80,000

Sales Salaries Expense

950,000

Rent Expense

1,200,000

Office Salaries Expense

315,000

Advertising Expense

Insurance Expense

1,250,000

87,900

Totals

25,735,500

25,735,500

2.

Transactions for October-December:

October 5, the company purchased $35,000 of inventory on account from ABC Company. The invoice terms were 2/20, n/60. October 10, Design Your Own T-Shirt sold $185,000 of merchandise to Sony, Inc. The inventory cost was $74,000, and the invoice terms were 1.5/20, n/60. October 11, the company hired three additional workers for the office.

The employees will all be paid $200 each per day for a 5-day work week (pay date is the end of each month). October 15, returned $5,000 of the merchandise purchased from ABC Company. October 25, received the electric bill. The total bill was for $8,000 and is due on November 5. The company’s policy is to accrue for expenses at the end of each month. Also, October 25, paid for the ABC Company merchandise purchased less the return.

Two transactions occurred on October 30: received the total payment from Sony, Inc. and Design Your Own T-Shirt purchased merchandise from XYZ Company, the invoice amount was $50,000, terms FOB Shipping Point, 2/20 n/60. Prepaid freight of $500 was added to the invoice amount.

Two transactions occurred on October 31: paid the employee salaries for the month of October (employees worked for 15 days in October), and accrued for the monthly electric bill.

November 1, sold $250,000 of merchandise to Walt Disney. The cost of the merchandise was $100,000 with terms 1.5/20, n/60. November 5, paid for the accrued electric bill. November 19, paid the XYZ invoice. November 21, received the total amount due from Walt Disney. November 30, paid the monthly salaries (employees worked for 21 days in November).

Four transactions occurred in the month of December. December 5 purchased merchandise for $75,000 cash from ABC Company. December 10, Walt Disney returned merchandise, the customer was paid a cash refund of $45,000. The cost of the returned merchandise was $18,000. December 15 sold $110,000 of merchandise to Indy Film Group. The inventory cost was $44,000 with terms 1.5/20, n/60. December 31, paid the monthly salaries for the employees (employees worked for 22 days in December).

3

Instructions

Design Your Own T-Shirt has hired you to do the following [Please complete the steps in the order presented]:

1. Prepare a corrected Trial Balance for September 30, 2019 (see Exhibit 1).
2. Prepare the required journal entries for October, November & December (See the attached General Journal Working Papers).
3. After preparing the journal entries, open the following T Accounts. (Please note that all of the below accounts have a beginning balance on the September 30 Trial Balance). See the attached General Ledger Working Papers:

a. Cash
b. Accounts Receivable
c. Inventory
d. Estimated Returns Inventory

e. Accounts Payable

f. Customer Refunds Payable

g. Sales
h. Cost of Goods Sold

i. Office Salaries Expense

j. Utilities Expense

4. Prepare the following statements for the Year Ended December 31, 2019:

a. Trial Balance

b. Multiple Step Income Statement

c. Retained Earnings Statement
d. Classified Balance Sheet

Solutions

Expert Solution

1.Trial Balance

Particulars Adjusted trail balance
Cash a/c 761775
Prepaid Insurance a/c 1890000
Office equipment a/c 4500000

Accumulated depreciation, office equipment a/c

680000
Inventory a/c 2205000
Accounts receivable a/c 1610000
Estimated returns inventory a/c 130000
payables(due in 6 months) a/c 339900
payables(due in 2025) a/c 2360000
Office aupplies a/c 395000
Store equipment a/c 5000000

2. Journal Entries

Date Particulars Debit (Dr) Credit (Cr)
05-Oct Inventory a/c 35000
To accounts payable a/c 35000
10-Oct Accounts receivable a/c 185000
To sales a/c 185000
10-Oct Cost of goods sold a/c 74000
To inventory a/c 74000
15-Oct Accounts payable a/c 5000
To inventory a/c 5000
15-Oct Accounts payable a/c 30000
To cash a/c 29400
To discount a/c 600
30-Oct Cash a/c 182225
Discount a/c 2775
To accounts receivable a/c 185000
30-Oct Inventory a/c 50000
Freight a/c 500
To accounts payable a/c 50500
31-Oct Salaries a/c 9000
To cash a/c 9000
.
31-Oct Electricity expenses a/c 8000
To Accured expenses a/c 8000
01-Nov Accounts receivable a/c 250000
To sales a/c 250000
01-Nov Cost of goods sold a/c 100000
To inventory a/c 100000
05-Nov Accrued expenses a/c 8000
To cash a/c 8000
19-Nov Accounts payable a/c 50500
To cash a/c 49500
To discount a/c 1000
21-Nov Cash a/c 246250
Discount a/c 3750
To accounts receivable a/c 250000
30-Nov Salaries a/c 12600
To cash a/c 12600
05-Dec Inventory a/c 75000
To cash a/c 75000
10-Dec Sales return a/c 45000

Estimated returns inventory a/c

45000
10-Dec Customer refunds payable a/c 45000
To cash a/c 45000
10-Dec Inventory a/c 18000
To cost of goods sold a/c 18000
15-Dec Accounts receivable a/c 110000
To sales a/c 110000
15-Dec Cost of goods sold a/c 44000
To inventory a/c 44000
31-Dec Salaries a/c 13200
To cash a/c 13200

3. T- accounts

a.Cash a/c

Particulars Debit (Dr) Particulars Credit (Cr)
Beginning balance 575000 accounts payable a/c 29400
accounts receivable a/c 182225 Salaries a/c 9000
accounts receivable a/c 246250 Accrued expense a/c 8000
accounts payable a/c 49500
Salaries a/c 12600
Inventory a/c 75000
Sales return a/c 45000
Salaries a/c 13200
Balance 761775
1003475 1003475
b. Accounts receivable a/c
Particulars Debit (Dr) Particulars Credit (Cr)
Beginning balance 1500000 Cash a/c 182225
Sales a/c 185000 Discount a/c 2775
Sales a/c 250000 Cash a/c 246250
Sales a/c 110000 Discount a/c 3750
balance 1610000
2045000 2045000
c. Inventory a/c
Particulars Debit (Dr) Particulars Credit (Cr)
Beginning balance 2250000 Cost of goods sold a/c 74000
accounts payable a/c 35000 accounts payable a/c 5000
accounts payable a/c 50000 Cost of goods sold a/c 100000
cash a/c 75000 Cost of goods sold a/c 44000
cost of goods sold a/c 18000 balance 2205000
2428000 2428000
d .Estimated returns inventory a/c
Particulars Debit (Dr) Particulars Credit (Cr)
Beginning balance 175000 sales return a/c. 45000
balance 130000
175000 175000
e. Accounts payable a/c
Particulars Debit (Dr) Particulars Credit (Cr)
inventory a/c 5000 Beginning balance 1025000
Cash a/c 29400 inventory a/c 35000
Discount a/c 600 inventory a/c 50000
Cash a/c 49500 freight a/c 500
Discount a/c 1000
balance 1025000
1110500 1110500
f. Customer refunds payable a/c
Particulars Debit (Dr) Particulars Credit (Cr)
cash a/c 45000 beginning balance 210000
balance 165000
210000 210000
g. Sales a/c
Particulars Debit (Dr) Particulars Credit (Cr)
Beginning 12500000
accounts receivable a/c 185000
accounts receivable a/c 250000
accounts receivable a/c 110000
0 13045000
h. Cost of goods sold a/c
Particulars Debit (Dr) Particulars Credit (Cr)
Beginnings 5000000 Inventory a/c 18000
Inventory a/c 74000
Inventory a/c 100000 balance 5200500
Inventory a/c 44000
Freight a/c 500
5218500 5218500
i.Office salaries expense a/c
Particulars Debit (Dr) Particulars Credit (Cr)
beginning 315000 balance 349800
Cash a/c 9000
Cash a/c 12600
Cash a/c 13200
349800
j. Utilities expense a/c
Particulars Debit (Dr) Particulars Credit (Cr)
beginning 0
accrued a/c 8000

.4.

a) Trial balance

Trial balance
Particulars Adjusted Trail balance
Cash a/c 761775
Prepaid Insurance a/c 1890000
Office equipment a/c 4500000
Accumulated depreciation, office equipment a/c 680000
Inventory a/c 2205000
Accounts receivable a/c 1610000
Estimated returns inventory a/c 130000
payables(due in 6 months) a/c 339900
payables(due in 2025) a/c 2360000
Office aupplies a/c 395000
Store equipment a/c 5000000
Accumulated depreciation, store equipment a/c 1825000
accounts payable a/c 1025000
Salaries payable a/c 295600
Customer refunds payable a/c 165000
Retained earnings, Jan1 a/c 3000000
Dividends a/c 100000
Cost of goods sold a/c 5200500
Sales a/c 13045000
Sales return a/c 45000
Common Stock a/c 3500000
Office supplies expense a/c 65000
Depreciation exp, store equipement a/c 225000
Depreciation exp,office equipement a/c 80000
Inerest exp a/c 97600
Misc selling exp a/c 80000
Sales Salaries exp a/c 950000
Rent exp a/c 1200000
Office salaries exp a/c 349800
Advertising exp a/c 1250000
Insurance exp a/c 87900
Utilities a/c 8000
Discount allowed a/c 6525
Discount received a/c 1600
26237100 26237100

b) Income statement

Particulars Amount Amount
Sales 13045000
Less: Sales Return 45000 13000000
Cost of goods sold (inc freight 500 rs) 5200500
Discount given 6525
Gross margin 7792975
Less: operating expenses
Office supplies expense 65000
Depreciation expense, store equipement 225000
Depreciation expense,office equipement 80000
Misc selling exp 80000
Sales Salaries expense 950000
Rent expense 1200000
Office salaries expense 349800
Advertising expense 1250000
Insurance expense 87900
Utilities 8000
Total operating expense 4295700
Other income: discount received 1600
Total operating income 3498875
Interest expense 97600
Profit before taxes 3401275

c) Retained Earnings Statement

Particulars Amount Amount
Beginning balance 3000000
Net income 3401275
Dividends -100000
Ending balance 6301275

d) Classified Balance Sheet

Particulars Amount Amount
Assets
Current assets
Cash 761775
Prepaid Insurance 1890000
Inventory 2205000
Accounts receivable 1610000
Estimated returns inventory 130000
Office aupplies 395000
Total current assets 6991775
Non-current assets
Office equipment 4500000
Accumulated depreciation, office equipment -680000
Store equipment 5000000
Accumulated depreciation, store equipment -1825000
Total non-current assets 6995000
Total assets 13986775
Liabilities
Current liabilities
Notes payable (due in 6 months) 339900
accounts payable 1025000
Salaries payable 295600
Customer refunds payable 165000
Total current liabilities 1825500
Non-current liabilities
Notes payable due in 2025 2360000
Total liabilities 4185500
Stockholders' equity
Common stock 3500000
Retained earnings 6301275
Total stockholders' equity 9801275
Total liabilities+stockholders' equity 13986775

Related Solutions

Question 1 Trial balance extracts at 30 September 2019 $’000 Land at cost on 30 September...
Question 1 Trial balance extracts at 30 September 2019 $’000 Land at cost on 30 September 2018 50,000 Plant and equipment at cost 76,600 Accumulated depreciation at 30 September 2018 Plant 24,600 Capitalised development expenditure at 30 September 2018 20,000 Non-current assets – tangible: The land was acquired on the 30 September 2018. The company’s policy is to revalue its land at each year end and at 30 September 2019 it was valued at $53 million. On 1 October 2018...
Provide the closing entry for the following trial balance at year end: DR.                   CR. Cash          &n
Provide the closing entry for the following trial balance at year end: DR.                   CR. Cash                             $5,275 A/R                               $1,850 Equipment                   $56,480 A/P                                                       $12,350 Owners Capital                                     $70,405 Owners Withdrawals    $6,000 Revenue                                              $85,000 Cost of Goods Sold        $25,000 Salaries                        $50,000           Payroll Taxes                $8,900 Utilities                        $13,800
Account Dr Cr Cash 120,000 Accounts Receivable 45,000 Investments 50,000 Inventory 65,000 Prepaid Insurance 10,000 Note...
Account Dr Cr Cash 120,000 Accounts Receivable 45,000 Investments 50,000 Inventory 65,000 Prepaid Insurance 10,000 Note Receivable 50,000 Equipment 190,000 Patent 80,000 A/C Payable 58,000 Unearned Revenue 6,000 Bank Loan Payable 100,000 Common Stock 102,000 Retained Earnings 295,000 Dividends 5,000 Sales 1,620,000 Dividend income 3,000 Cost of Goods Sold 1,000,000 Salaries Exp 300,000 Accounting Exp 75,000 Advt Exp 70,000 Rent Exp 100,000 Utilities Exp 20,000 Miscellaneous Expense 4,000 Total 2,184,000 2,184,000 Prepare adjusting journal entries. a) Audit of cash in...
Trial balance March 31, 2019 Information Debit Credit Cash 10,800,000 Prepaid insurance 4,800,000 Equipment 120,000,000 Office...
Trial balance March 31, 2019 Information Debit Credit Cash 10,800,000 Prepaid insurance 4,800,000 Equipment 120,000,000 Office supplies 2,600,000 Accounts payable 79,200,000 Capital 58,000,000 Income 9,000,000 Salary expense 6,400,000 Electrical Load 1,600,000 AMOUNT 146,200,000 146,200,000 Additional customization information: The insurance premium rate is IDR 400,000 per month. The remaining equipment in the warehouse until March 31, 2019 is IDR 2,000,000. Equipment depreciation per month of IDR 1,800,000. The interest accrued by the company on trade payables on March 31, 2019 is...
Unadjusted Trial Balance December 31, 2019 Debit Credit Cash 165,200 Office Supplies/Lures 8,500 Prepaid Insurance 2,900...
Unadjusted Trial Balance December 31, 2019 Debit Credit Cash 165,200 Office Supplies/Lures 8,500 Prepaid Insurance 2,900 Equipment - Boat 17,000 Accounts Payable 4,500 Unearned Service Revenue 21,000 Notes Payable 15,000 Common Stock 14,000 Additional Paid in Capital - CS 134,000 Service Revenue 32,000 Unearned Revenue- Gain on Sale 400 Interest Expense 300 Salaries Expense 11,000 Utilities Expense 3,000 Boat Gas Expense 13,000 Total 220,900 220,900 Prepare Adjusting Journal Entries The 3/1/19 Notes Payable principle from First Hawaiian Bank is due...
Trial Balance 1. Prepare a trial balance for Kenny's Lawn Service as of September 30, 20--....
Trial Balance 1. Prepare a trial balance for Kenny's Lawn Service as of September 30, 20--. List the accounts in the order of Assets, Liabilities, Owner's equity, Revenue, and Expenses. If an amount box does not require an entry, leave it blank. The following accounts have normal balances. Cash $10,000 Accounts Receivable 6,000 Supplies 1,600 Prepaid Insurance 1,200 Delivery Equipment 16,000 Accounts Payable 4,000 Kenny Young, Capital 20,000 Kenny Young, Drawing 2,000 Delivery Fees 18,800 Wages Expense 4,200 Rent Expense...
West Laboratory provides service The trial balance at 30 September 2019, before adjustments is as follows:...
West Laboratory provides service The trial balance at 30 September 2019, before adjustments is as follows: Debit Credit Cash $174,450 Accounts Receivable 17,000 Prepaid Rent 28,000 Prepaid insurance 1,600 Supplies inventory 2,400 Equipment 183,600 Accumulated Depreciation: Equipment $68,850 Accounts Payable 18,100 Unearned revenue 14,000 Share Capital 200,000 Retained Earnings 44,700 Revenue 371,000 Salaries Expense 200,000 Rent expense 56,000 Insurance expense 3,200 Utilities Expense 9,600 Depreciation Expense       40,800               $716,650 $716,650 The following information relates to month end adjustments: The...
Prepare a trial balance sheet for Mia Stage, Interior Design, as of September 30, 2017. (15...
Prepare a trial balance sheet for Mia Stage, Interior Design, as of September 30, 2017. (15 Points) Mia Stage, Interior Design Adjusted Trial Balance Month Ending September 30, 2017 Debits Credits Cash 14,275 Accounts Receivable 3,650 Supplies 1,250 Prepaid Ins. 2,400 Automobile 12,500 Equipment 6,250 Accounts Payable 6,850 Notes Payable 9,800 MS, Capital 19,000 MS, Drawing 2,000 Fees Earned 15,650 Rent Expense 3,150 Salary Expense 2,300 Programming Expense 2,300 Equipment Expense 550 Misc. Expense 675 Total $51,300 51,300 Prepare Financial...
Prepare a Post-Closing Trial Balance Cash – 1,270,676 Accounts Receivable – 190,300 Prepaid Insurance – 17,400...
Prepare a Post-Closing Trial Balance Cash – 1,270,676 Accounts Receivable – 190,300 Prepaid Insurance – 17,400 Land – 75,000 Short-term Investments – 167,000 Fair value adjustment (Trading) – (8,000) Allowance for doubtful accounts – 25,000 LT (Debt) investments (HTM) – 177,824 Bonds Payable – 1,600,000 Premium on Bonds Payable – 118,630 Building – 150,000 Accumulated depreciation: building – 5,400 Equipment – 50,000 Accumulated depreciation: equipment – 29,359 Patent – 37,500 Accounts Payable – 65,340 Notes Payable – 236,175 Income Taxes...
How do I adjust my unadjusted Trial Balance? Date Acct Dr Cr 1/2/2016 Cash 175,000 Owners...
How do I adjust my unadjusted Trial Balance? Date Acct Dr Cr 1/2/2016 Cash 175,000 Owners Equity 175,000 1/2/2016 Cash 100,000 Common Stock 100,000 1/2/2016 Cash 60,000 Unearned rent revnue 60,000 Utilities 30,000 Cash 30,000 1/15/2016 Equipment 50,000 Cash 50,000 Depreciation exp 5000 Accumulated Dep 5,000 1/15/2016 Rent Expense 39,600 Cash 39,600 1/16/2016 Office Supplies 86000 Accounts Payable 86000 Supplies Expense 6700 Supplies 6700 1/2/2016 Wage Expenses 180000 12/31/2016 Federal Taxes Withheld 48000 State Taxes Withheld 14400 FICA 13770 FUTA...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT