Question

In: Accounting

The adjusted trial balance of Coastal Carolina Corporation at December 31, 2018 are shown as follows:...

The adjusted trial balance of Coastal Carolina Corporation at December 31, 2018 are shown as follows:

Coastal Carolina Corporation

Adjusted Trial Balance

December 31, 2018

Account Title

Debit

Credit

Accounts Payable

        75,000

Accounts Receivable

      150,000

Accumulated Depreciation

        30,000

Bonds Payable (due in 2020)

        90,000

Cash

        85,000

Common Stock

        30,000

Cost of Goods Sold

      280,000

Depreciation Expense

        17,000

Dividends

        20,000

Equipment

      170,000

Interest Expense

          3,000

Interest Payable

          5,000

Inventory

        61,000

Land

      100,000

Notes Payable (18 months)

      105,000

Paid-in Capital in Excess of par-Common

      145,000

Patents, net of amortization

        40,000

Prepaid Rent

          4,000

Rent Expense

        55,000

Retained Earnings, January 1, 2018

        30,000

Salaries Expense

      130,000

Sales Revenue

      600,000

Utilities Expense

        15,000

Wages Payable

        20,000

Total

$1,130,000

$1,130,000

From the adjusted trial balance above, use Excel to prepare the following financial statements of Coastal Carolina Corporation in good form:

a.       Multistep Income Statement

b.      Statement of Retained Earnings

c.       Classified Balance Sheet

Solutions

Expert Solution

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

The adjusted trial balance for Tybalt Construction as of December 31, 2018, follows. TYBALT CONSTRUCTION Adjusted...
The adjusted trial balance for Tybalt Construction as of December 31, 2018, follows. TYBALT CONSTRUCTION Adjusted Trial Balance December 31, 2018 No. Account Title Debit Credit 101 Cash $ 7,500 104 Short-term investments 22,000 126 Supplies 9,200 128 Prepaid insurance 8,600 167 Equipment 55,000 168 Accumulated depreciation—Equipment $ 27,500 173 Building 162,000 174 Accumulated depreciation—Building 54,000 183 Land 64,470 201 Accounts payable 16,000 203 Interest payable 2,000 208 Rent payable 3,200 210 Wages payable 2,700 213 Property taxes payable 900...
The adjusted trial balance for Tybalt Construction as of December 31, 2018, follows. TYBALT CONSTRUCTION Adjusted...
The adjusted trial balance for Tybalt Construction as of December 31, 2018, follows. TYBALT CONSTRUCTION Adjusted Trial Balance December 31, 2018 No. Account Title Debit Credit 101 Cash $ 7,500 104 Short-term investments 22,000 126 Supplies 9,200 128 Prepaid insurance 8,600 167 Equipment 55,000 168 Accumulated depreciation—Equipment $ 27,500 173 Building 162,000 174 Accumulated depreciation—Building 54,000 183 Land 64,470 201 Accounts payable 16,000 203 Interest payable 2,000 208 Rent payable 3,200 210 Wages payable 2,700 213 Property taxes payable 900...
The adjusted trial balance of Monona Inc. as of December 31, 2020, follows. Adjusted Trial Balance...
The adjusted trial balance of Monona Inc. as of December 31, 2020, follows. Adjusted Trial Balance December 31, 2020 Acct. No. Account Debit Credit 100 Cash $18,000 $ 104 Accounts receivable 35,000 105 Allowance for doubtful accounts 1,775 106 Inventory 40,000 108 Prepaid insurance 2,400 150 Land 5,725 155 Building 100,000 156 Equipment 30,000 162 Accumulated depreciation 6,250 202 Accounts payable 37,500 204 Salaries payable 2,250 208 Deferred service revenue 1,000 210 Interest payable 250 240 Note payable 75,000 302...
The adjusted trial balance for Cowboy Company follows: Cowboy Company Adjusted Trial Balance December 31, 2019...
The adjusted trial balance for Cowboy Company follows: Cowboy Company Adjusted Trial Balance December 31, 2019 ACCOUNT NAME DEBIT CREDIT Cash       101,100 Accounts Receivable           5,000 Prepaid Rent           2,200 Building       120,000 Accumulated Depreciation - Building         80,000 Accounts Payable           3,000 Salaries Payable           5,600 Interest Payable           4,500 Unearned Revenue           9,500 Notes Payable         50,000 Cowboy, Capital         70,000 Cowboy, Withdrawals         30,000 Fees Earned       115,000 Wages Expense         40,000 Rent Expense         26,400...
The adjusted trial balance of Karise Repairs on December 31, 2017, follows.
  The adjusted trial balance of Karise Repairs on December 31, 2017, follows. KARISE REPAIRSAdjusted Trial BalanceDecember 31, 2017 No. Account Title Debit   Credit 101 Cash $ 113,000           124 Office supplies   1,800           128 Prepaid insurance   2,850           167 Equipment   54,000           168 Accumulated depreciation—Equipment         $ 5,400   201 Accounts payable        ...
Prepare Balance Sheet The following is the adjusted trial balance at December 31, 2018 for the...
Prepare Balance Sheet The following is the adjusted trial balance at December 31, 2018 for the Farmer Enterprises. Account Title Debits Credits   Cash 105,000   Investments 274,000   Accounts receivable 161,000   Inventories 234,000   Loans to employees 59,000   Prepaid expenses (for 2019) 35,000 Rent expense 84,000   Land 299,000   Building 1,740,000   Machinery and equipment 656,000 Trademark 171,000 Copyright 59,000 Bad debt expense 6,200 Depreciation expense 98,750 Dividends 40,000   Note receivable 345,000   Interest receivable 31,000 Cost of goods sold 242,000   Accumulated depreciation—building 639,000   Accumulated depreciation—equipment...
A partial trial balance of Julie Hartsack Corporation is as follows on December 31, 2018. Dr....
A partial trial balance of Julie Hartsack Corporation is as follows on December 31, 2018. Dr. Cr. Supplies $2,700 Salaries and wages payable $1,500 Interest Receivable 5,100 Prepaid Insurance 90,000 Unearned Rent 0 Interest Payable 15,000 Additional adjusting data: 1. A physical count of supplies on hand on December 31, 2018, totaled $1,100. 2. Through oversight, the Salaries and Wages Payable account was not changed during 2018. Accrued salaries and wages on December 31, 2018, amounted to $4,400. 3. The...
The December 31, 2018, adjusted trial balance for the Blueboy Cheese Corporation is presented below. Account...
The December 31, 2018, adjusted trial balance for the Blueboy Cheese Corporation is presented below. Account Title Debits Credits Cash 22,700 Accounts receivable 330,000 Prepaid rent 13,000 Inventory 51,000 Office equipment 610,000 Accumulated depreciation—office equipment 254,000 Accounts payable 72,000 Note payable (due in six months) 63,000 Salaries payable 7,500 Interest payable 2,100 Common stock 400,000 Retained earnings 150,000 Sales revenue 750,000 Cost of goods sold 450,000 Salaries expense 112,500 Rent expense 39,000 Depreciation expense 61,000 Interest expense 4,200 Advertising expense...
Financial Statements Project The adjusted trial balance of Midwest Marvels Corporation at December 31, 2018 is...
Financial Statements Project The adjusted trial balance of Midwest Marvels Corporation at December 31, 2018 is shown as follows: Midwest Marvels Corporation Adjusted Trial Balance December 31, 2018 Account Title Debit Credit Accounts Payable 80,000 Accounts Receivable 120,000 Accumulated Depreciation 29,000 Cash 75,000 Common Stock 125,000 Cost of Goods Sold 280,000 Depreciation Expense 21,000 Dividends 20,000 Equipment 150,000 Interest Expense 3,000 Interest Payable 5,000 Inventory 56,000 Land 115,000 Notes Payable (18 months) 100,000 Paid-in Capital in Excess of par-Common 145,000...
The December 31, 2018, adjusted trial balance for the Blueboy Cheese Corporation is presented below. Account...
The December 31, 2018, adjusted trial balance for the Blueboy Cheese Corporation is presented below. Account Title Debits Credits Cash 55,000 Accounts receivable 275,000 Prepaid rent 7,500 Inventory 40,000 Office equipment 500,000 Accumulated depreciation—office equipment 210,000 Accounts payable 50,000 Note payable (due in six months) 30,000 Salaries payable 6,500 Interest payable 1,000 Common stock 400,000 Retained earnings 95,000 Sales revenue 650,000 Cost of goods sold 390,000 Salaries expense 97,500 Rent expense 22,500 Depreciation expense 50,000 Interest expense 2,000 Advertising expense...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT