Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help with the general ledger and November worksheet (trial balance, adjustments, adjusted trial balance, income statement, and balance sheet)? Thank you! At the

Can someone help with the general ledger and November worksheet (trial balance, adjustments, adjusted trial balance, income statement, and balance sheet)? Thank you!

At the beginning of November, Madison decides to expand her business by selling fine European mixers. The owner of Batter Blender Supply Co. has approached Madison to become the exclusive distributor of these fine mixers in her state. The current cost of a mixer is $580, and Madison plans to sell each mixer for $1,200. Each appliance has a serial number and can be easily identified. Madison uses the perpetual inventory system to account for these fine mixers.

The following transactions occurred during the month of November.

Nov. 4 Bought five mixers on account from Batter Blender Supply Co. for $ 2,900, terms n/30.

6 Paid $75 freight on the November 4 purchase. Check 158.

9 Bought four mixers on account from Batter Blender Supply Co. for $ 2,320, terms n/30.

10 Madison is concerned that there is not enough cash available to pay for all of the mixers

purchased. She invests an additional $2,000 cash in Sweet Treats.

11 Paid $60 freight on the November 9 purchase. Check 159.

15 Madison issued a check 160 to her assistant for all the help at the elementary school on October 30. (Madison had a friend assist her with the Newbury Elementary School class. She decides to hire her friend as an employee. She owes her $45 for the October 30 class, which she will pay on November 15)

20 Paid a $155 cell phone bill (Hint: Use utility Expense). Check 161.

21 Paid Batter Blender the amount due from the November 4 purchase. Check 162.

22 Collected $300 from the October 30 transaction with Newbury Elementary School. (Madison prepared an invoice for $300 and left it with the school principal on Oct. 30.)

23 Three mixers are sold to Peters Pastries on account for $3,600, terms n/30. Invoice 1011.

(Hint: You must record both the revenue and expense components on all sales

transactions.)

26 Sold three mixers for $3,600 cash.

29 Paid Batter Blender the amount due from the November 9 purchase. Check 163.

30 Paid her assistant for the last two weeks of November in the amount of $960. Check 164

30 Madison withdrew $750 cash for personal use. Check 165.

As of November 30, the following adjusting entry data is available.

  1. Another months worth of depreciation needs to be recorded on the baking equipment bought in October. (equipment depreciates $10 per month)
  2. One months worth of insurance has expired. (pre-paid 1 year $1200)
  3. Madison records another month of accrued interest on her grandmas loan. (The $5000 cash note will be repaid in 24 months at 7.5% interest.)
image text in transcribed
image text in transcribed
Clipboard Font Alignment Number Styles M22 D H E 10.00 10.00 10.00 45.00 45.00 45.00 5,000.00 600.00 5,000.00 600.00 5,000.00 600.00 100.00 100.00 100.00 435.00 435.00 435.00 10 Accum. Depr.-Equipment 11 Accounts Payable 12 Salaries and Wages Payable B Interest Payable 14 Notes Payable 15 Owner's Capital 16 Owner's Drawings 17 Service Revenue 18 Sales Revenue 19 Cost of Goods Sold 20 Advertising Expense 21 Baking Supplies Expense 22 Depreciation Expense 23 Insurance Expense 24 Salaries and Wages Expense 25 Rent Expense 26 Utilities Expense 27 Interest Expense 75.00 45.00 10.00 75.00 45.00 10.00 75.00 45.00 10.00 45.00 45.00 45.00 79 TOTALS 30 6,035.00 6,035.00 100.00 100.00 435.00 5,915.00 6,090.00 6,090.00 Net Income TOTALS 175.00 260.00 435.00 5,655.00 260.00 5,915.00 51 435.00 5,915.00 AP Sub Ledger Inventory Ledger October Worksheet November Worksheet December Worksheet Multi-Step Income October Worksheet Adjustments Adjusted Trial Bal. Dr. Cr. Dr. Cr. Income Statement C. Dr. Balance Sheet Dr. 3,020.00 300.00 3,020.00 300.00 45.00 95.00 1,200.00 1,200.00 95.00 1,200.00 1,200.00 10.00 10.00 10.00 1 2 Trial Balance 3 Account Titles Dr. Cr. 4 Cash 3,020.00 5 Accounts Receivable 300.00 6 Inventory 7 Baking Supplies 140.00 6 Prepaid Insurance 1,200.00 9 Equipment 1,200.00 10 Accum. Depr.-Equipment 11 Accounts Payable 12 salaries and Wages Payable 13 Interest Payable 14 Notes Payable 5,000.00 15 Owner's Capital 600.00 16 Owner's Drawings 100.00 17 Service Revenue 435.00 18 Sales Revenue 19 Cost of Goods Sold 20 Advertising Expense 75.00 21 Baking Supplies Expense 22 Depreciation Expense Insurance Enonce AP Sub Ledger Inventory Ledger 45.00 45.00 45.00 5,000.00 600.00 5,000.00 600.00 100.00 100.00 435.00 435.00 45.00 10.00 75.00 45.00 10.00 75.00 45.00 10.00 October Worksheet November Worksheet December Worksheet Multi-Step Income Clipboard Font Alignment Number Styles M22 D H E 10.00 10.00 10.00 45.00 45.00 45.00 5,000.00 600.00 5,000.00 600.00 5,000.00 600.00 100.00 100.00 100.00 435.00 435.00 435.00 10 Accum. Depr.-Equipment 11 Accounts Payable 12 Salaries and Wages Payable B Interest Payable 14 Notes Payable 15 Owner's Capital 16 Owner's Drawings 17 Service Revenue 18 Sales Revenue 19 Cost of Goods Sold 20 Advertising Expense 21 Baking Supplies Expense 22 Depreciation Expense 23 Insurance Expense 24 Salaries and Wages Expense 25 Rent Expense 26 Utilities Expense 27 Interest Expense 75.00 45.00 10.00 75.00 45.00 10.00 75.00 45.00 10.00 45.00 45.00 45.00 79 TOTALS 30 6,035.00 6,035.00 100.00 100.00 435.00 5,915.00 6,090.00 6,090.00 Net Income TOTALS 175.00 260.00 435.00 5,655.00 260.00 5,915.00 51 435.00 5,915.00 AP Sub Ledger Inventory Ledger October Worksheet November Worksheet December Worksheet Multi-Step Income October Worksheet Adjustments Adjusted Trial Bal. Dr. Cr. Dr. Cr. Income Statement C. Dr. Balance Sheet Dr. 3,020.00 300.00 3,020.00 300.00 45.00 95.00 1,200.00 1,200.00 95.00 1,200.00 1,200.00 10.00 10.00 10.00 1 2 Trial Balance 3 Account Titles Dr. Cr. 4 Cash 3,020.00 5 Accounts Receivable 300.00 6 Inventory 7 Baking Supplies 140.00 6 Prepaid Insurance 1,200.00 9 Equipment 1,200.00 10 Accum. Depr.-Equipment 11 Accounts Payable 12 salaries and Wages Payable 13 Interest Payable 14 Notes Payable 5,000.00 15 Owner's Capital 600.00 16 Owner's Drawings 100.00 17 Service Revenue 435.00 18 Sales Revenue 19 Cost of Goods Sold 20 Advertising Expense 75.00 21 Baking Supplies Expense 22 Depreciation Expense Insurance Enonce AP Sub Ledger Inventory Ledger 45.00 45.00 45.00 5,000.00 600.00 5,000.00 600.00 100.00 100.00 435.00 435.00 45.00 10.00 75.00 45.00 10.00 75.00 45.00 10.00 October Worksheet November Worksheet December Worksheet Multi-Step Income

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions