The unadjusted trial balance of Data Solution at November 30, 2018, follows: DATA SOLUTION Unadjusted Trial Balance November 30, 2018 Account Title Prepaid Rent Cash Debit Credit Accounts Receivable Office Supplies Equipment Accumulated Depreciation—Equipment Accounts Payable Salaries Payable Common Stock Dividends Service Revenue Depreciation Expense—Equipment Salaries Expense Rent Expense Utilities Expense Supplies Expense Balance \( 4,400 \) 48,300 \( 48,300 5,100 \) 1,500 30,200 32,900 8,800 2,900 2,100 3,100 1,800 3,100 700 Additional information at November 30, 2018: a. Accrued Service Revenue, \(800. b. Depreciation, \)350. c. Accrued Salaries Expense, \(650. d. Prepaid Rent expired, \)700. e. Office Supplies used, $550. Requirements 1. Complete Data Solution’s worksheet for the month ended November 30, 2018. 2. How much was net income for November?

Short Answer

Expert verified

(1) Worksheet are as follows:

Prepaid

Rent

1,800

700

1,100

1,100

Office

Supplies

3,100

550

2,550

2,550

Equipment

30,200

30,200

30,200

Accumulated Depreciation—Equipment

$1,500

$350

$1,850

$1,850

Accounts Payable

5,100

5,100

5,100

Salaries Payable

650

650

650

Common Stock

32,900

32,900

32,900

Dividends

2,900

2,900

2,900

Service Revenue

8,800

800

9,600

$9,600

Depreciation Expense—Equipment

350

350

$350

Salaries Expense

2,100

650

2,750

2,750

Rent

Expense

700

700

700

Utilities Expense

700

700

700

Supplies Expense

550

550

550

Total

$48,300

$48,300

$3,050

$3,050

$50,100

$50,100

$5,050

$9,600

$45,050

$40,500

Net Income

4,550

4,550

Total

$9,600

$9,600

$45,050

$45,050

(2) Net Income is $4,550.

Step by step solution

01

Explanation on Worksheet

Worksheet is a document which is prepared internally that represents the summary of data, which is used in preparation of financial statements.

02

Calculation of net Income

Net income is calculated as follows:

NetIncome=TotalRevenues-TotalExpenses=$9,600-$5,050=$4,550

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

The adjusted trial balance for Green Advertising Services is presented below: Account Title Office Supplies Cash Debit Credit Accounts Receivable Building Accumulated Depreciation—Building Furniture Accumulated Depreciation—Furniture Land Salaries Payable Accounts Payable Unearned Revenue Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Supplies Expense Depreciation Expense—Building Balance \( 14,000 \) 195,200 \( 195,200 18,400 14,100 \) 36,100 19,600 7,200 10,600 30,000 31,400 16,000 18,300 49,800 8,400 28,600 2,900 1,300 13,500 15,800 6,500 47,900 Depreciation Expense—Furniture Advertising Expense Total GREEN ADVERTISING SERVICES Adjusted Trial Balance December 31, 2018 Requirements 1. Prepare the income statement for the year ending December 31, 2018. 2. Prepare the statement of retained earnings for the year ending December 31, 2018. 3. Prepare the classified balance sheet as of December 31, 2018. Use the report form

Answer the following questions: Requirements 1. What type of normal balance does the Retained Earnings account have—debit or credit? 2. Which type of income statement account has the same type of balance as the Retained Earnings account? 3. Which type of income statement account has the opposite type of balance as the Retained Earnings account? 4. What do we call the difference between total debits and total credits on the income statement section of the worksheet?

The adjusted trial balance of Melanie O’Mallie Dance Studio Company follows:MELANIE O'MALLIE DANCE STUDIO COMPANY Trial Balance August 31, 2018 Account Title Prepaid Rent Cash Debit Credit Office Supplies Equipment Accumulated Depreciation—Equipment Accounts Payable Salaries Payable Unearned Revenue Notes Payable (long-term) Dividends Common Stock Retained Earnings Service Revenue Salaries Expense Rent Expense Depreciation Expense—Equipment Supplies Expense Utilities Expense Balance \( 16,000 \) 76,100 \( 76,100 100 \) 5,700 4,800 49,000 5,400 18,100 5,000 18,000 19,000 1,100 1,100 3,600 1,800 1,500 500 400 1,100 Requirements 1. Prepare the classified balance sheet of Melanie O’Mallie Dance Studio Company at August 31, 2018. Use the report form. You must compute the ending balance of Retained Earnings. 2. Compute O’Mallie’s current ratio at August 31, 2018. One year ago, the current ratio was 1.76. Indicate whether O’Mallie’s ability to pay current debts has improved, deteriorated, or remained the same.

On December 1, Bob Waldo began an auto repair shop, Waldo’s Quality Automotive. The following transactions occurred during December: Dec. 1 Waldo contributed \(70,000 cash to the business in exchange for shares of common stock. 1 Purchased \)12,000 of equipment paying cash. 1 Paid \(1,750 for a five-month insurance policy starting on December 1. 9 Paid \)20,000 cash to purchase land to be used in operations. 10 Purchased office supplies on account, \(2,800. 19 Borrowed \)15,000 from the bank for business use. Waldo signed a note payable to the bank in the name of the corporation. The note is due in five years. 22 Paid \(1,300 for advertising expenses. 26 Paid \)900 on account. 28 The business received a bill for utilities to be paid in January, \(280. 31 Revenues earned during the month included \)16,000 cash and \(3,600 on account. 31 Paid employees’ salaries \)3,800 and building rent \(1,200. Record as a compound entry. 31 The business received \)1,440 for auto screening services to be performed next month. 31 Paid cash dividends of \(5,500 to stockholders. The business uses the following accounts: Cash; Accounts Receivable; Office Supplies; Prepaid Insurance; Land; Equipment; Accumulated Depreciation—Equipment; Accounts Payable; Utilities Payable; Interest Payable; Unearned Revenue; Notes Payable; Common Stock; Retained Earnings; Dividends; Income Summary; Service Revenue; Salaries Expense; Rent Expense; Utilities Expense; Advertising Expense; Supplies Expense; Insurance Expense; Interest Expense; and Depreciation Expense—Equipment. Adjustment data: a. Office Supplies used during the month, \)1,800. b. Depreciation for the month, \(200. c. One month insurance has expired. d. Accrued Interest Expense, \)75. Requirements 1. Prepare the journal entries, and post to the T-accounts. 2. Prepare an unadjusted trial balance. 3. Complete the worksheet for the month ended December 31, 2018 (optional). 4. Prepare the adjusting entries, and post to the T-accounts. 5. Prepare an adjusted trial balance.6. Prepare the income statement, the statement of retained earnings, and the classified balance sheet in report form. 7. Prepare the closing entries, and post to the T-accounts. 8. Prepare a post-closing trial balance.

Ocean Breeze Associates accrued \(8,500 of Service Revenue at December 31. Ocean Breeze Associates received \)14,500 on January 15, including the accrued revenue recorded on December 31. Requirements 1. Record the adjusting entry to accrue Service Revenue. 2. Record the reversing entry. 3. Journalize the cash receipt.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free