Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with the general ledger and November worksheet (trial balance, adjustments, adjusted trial balance, income statement, and balance sheet. Top priority is the

I need help with the general ledger and November worksheet (trial balance, adjustments, adjusted trial balance, income statement, and balance sheet. Top priority is the November worksheet! I provided the October worksheet that I completed. Thanks! image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Can someone help with the general ledger and November worksheet (frial balance, adjustments, adjusted trial balance, income statement and balance sheet)? October worksheet I completed is provided. 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 mocers in her state. The current cost of a mixer is S580, 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 1/30 6 Paid S75 freight on the November 4 purchase Check 158. 9 Bought four moers on account from Batter Blender Supply Co. for $ 2,320, terms r/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 to her assistant for all the help at the elementary school on October 30. (Recall this amount was accrued at the end of October.) Check 160. 20 Paid a $155 cell phone bill (Hint: Use Utilities 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 23 Three mixers are sold to Peter's Pastries on account for $3,600, terms 1/30. Invoice 1011 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 month's worth of depreciation needs to be recorded on the baking equipment bought in October (equipment depreciates $10 per month) 2. One month's worth of insurance has expired. (pre-paid 1 year $1200) Madison records another month of accrued interest on her grandma's loan. (The $5000 cash note will be repaid in 24 months at 75% interest) 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 4 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 20 29 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 435.00 5,915.00 AP Sub Ledger inventory Ledger October Worksheet November Worksheet December Worksheer Multi-Step Income 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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