Question

In: Accounting

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

Patents, net of amortization

50,000

Prepaid Rent

4,000

Rent Expense

55,000

Retained Earnings, January 1, 2018

40,000

Salaries Expense

120,000

Sales Revenue

560,000

Utilities Expense

25,000

Wages Payable

10,000

Total

$1,094,000

$1,094,000

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

  1. Income Statement
  2. Statement of Retained Earnings
  3. Classified Balance Sheet

Solutions

Expert Solution

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

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...
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...
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...
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...
Q2. Both the unadjusted trial balance and adjusted trial balance for Smith Corporation on December 31,...
Q2. Both the unadjusted trial balance and adjusted trial balance for Smith Corporation on December 31, 2013, are listed below: Smith Corporation Trial Balance December 31, 2013 Unadjusted Adjusted Debit Credit Debit Credit Cash Accounts Receivables Supplies Prepaid Insurance Land Vehicles Accumulated Depreciation-Vehicles Notes Payable Wages Payable Common Stock Dividends Revenue Wages Expense Utilities Expense Insurance Expense Rent Expense Depreciation Expense Supplies Expense 8,000 19,000 6,000 10,000 13,000 20,000 4,000 12,000 4,000 0 4,000 0 0 4,000 13,000 0 46,000...
Vanguard Services had the following adjusted trial balance at December 31, 2018. VANGUARD SERVICES Adjusted Trial...
Vanguard Services had the following adjusted trial balance at December 31, 2018. VANGUARD SERVICES Adjusted Trial Balance For the year ended December 31, 2018 Account titles Debits Credits Cash $ 10,800 Interest Expense 900 Accounts Receivable 4,800 Equipment 60,900 Tax Expense             1,000 Accounts Payable $ 4,400 Accumulated Depreciation 7,400 Vanguard’s Capital 35,000 Rent Expense             5,000 Drawing 16,000 Salaries Expense 10,700 Prepaid rent 4,000 Service Revenue 65,000 Unearned Rent Revenue 8,300 Depreciation Expense 4,000 Supplies 4,000 Supplies Expense 200...
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 of Pacific Scientific Corporation on December 31, 2021, the end of the...
The adjusted trial balance of Pacific Scientific Corporation on December 31, 2021, the end of the company's fiscal year, contained the following income statement items ($ in millions): sales revenue, $2,105; cost of goods sold, $1,250; selling expense, $120; general and administrative expense, $110; interest expense, $35; and gain on sale of investments, $50. Income tax expense has not yet been recorded. The income tax rate is 25%. Prepare a multiple-step income statement for 2021. (Amounts to be deducted should...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT