N4 A 2 3 5 6 B fx Macon Machines F H D E G Company...

Transcribed Image Text:

N4 A 2 3 5 6 B fx Macon Machines F H D E G Company mummalIVIT & JUMmmmary vi significant ACCOUNTCTORICIES J K Macon Machines Company began operations on November 1, 2024. The main operating goal of the company is to sell high end robots. Customers may pay using cash or if appropriate, credit is extended to customers with terms 3/15, n/30. 4 The company uses the perpetual inventory method and a FIFO cost system. The company follows a calendar year, with all adjusting entries made at the end of the accounting period, December 31. The company uses the straight-line depreciation for all depreciable assets. The company has decided to use the Allowance method to account for uncollectible accounts. At the end of the period, based on industry standards, the company believes 2% of the balance in accounts recievable will be uncollectible. The company purchases robots for resale only as such they carry them as inventory. 7 8 9 10 The company has two employees, one is a sales technician, salary of $5000 per month and the other employee is the office 11 manager with a salary of $6000 per month. Payroll is processed on the last day of the month, and paid on the first day of the 12 following month. This means the November 30 payroll with accrue into Salaries Payable and then be paid on Decemember 1. 13 14 Required: 15 16 17 L M Liner yo 1) Make sure your student ID is correct, this will change the information. Macon Machines Company engaged in the following transactions for November and December. Record the following transactions on the Daily Transactions tab. Note: Place debits first, credits second but do NOT indent credits. If more than one debit or credit, please list in alphabetical order to receive full credit. Round to the penny unless otherwise noted. 1-Nov The owner invested $520000 into the company in exchange for 5,000 shares of common stock. 1-Nov The company purchased a computer system for $60000 and signed a one-year note for the entire balance. The note is due on November 1, 2025 and has an annual rate of interest of 3%. Company Ma Product 18 19 2-Nov Paid for two years rent on the office space, $10400. 20 3-Nov Purchased 10 robots at a total cost of $5000 each for cash, FOB Destination. 21 4-Nov Purchased $2500 of supplies on account, term n/30. 22 23 34 15-Nov Purchased 12 robots at a total cost of $5500 each on account, terms n/30, FOB Destination. Shipping of $150 was paid to the shipping company by the appropriate party. 17-Nov Paid for the supplies purchased on November 4. 18-Nov Paid for a two-year insurance policy for the store, $6000. The policy was effective beginning December 1, 2024. 20-Nov Sold 15 robots for $8500 each on account, terms 3/15, n/30, the company uses FIFO to find the cost of goods sold. The robots chinned COD Chinning Daint. Danned the colon n 24 25 > = Low (Green) Workbook Statistics fiunt Instructions Daily Transactions Adjusting Entries Ledger Adjusted Trial Balance Income Statement Equity Sta N4 A 25 B fx Macon Machines C D E F G H 20-Nov Sold 15 robots for $8500 each on account, terms 3/15, n/30, the company uses FIFO to find the cost of goods sold. The robots were shipped FOB Shipping Point. Record the sales revenue first. 28-Nov Received payment in full on account from the November 20 sale. 26 27 29-Nov Paid for November's utilities bill $5200. 28 Prepared payroll for the month of November, the first payroll for the company. Record the Salares Expense entry first. The tax 30-Nov rates are as follows: 29 30 31 32 23 33 34 35 36 69 Federal Income Tax Rate - 15%. NC State Income Tax Rate - 10%. FICA Tax Rate - 7.65%. Unemployment Tax Rate 6% on the first $7000 of each employees earnings per year. 1-Dec Paid the employees the amount due to them from the November 30 payroll, taxes will be paid in January. 1-Dec The company borrowed $65000 from Bank of America by signing a 15-year, 6% note. The note requires annual payments of $6693 beginning December 1, 2025. 1-Dec Purchased a new delivery truck to save customers on shipping. The total cost of the Delivery Truck was $60000. 4-Dec Paid the amount due from the November 15 purchase. 37 38 5-Dec Declared and paid $2000 in cash dividends to the stockholders of the company. 39 6-Dec Purchased $3000 of supplies on account, term n/30. 40 21 41 42 23 43 44 45 46 47 48 M N 7-Dec Purchased 20 robots at a cost of $6050 each on account, terms n/30, FOB Destination. 15-Dec Sold 22 robots for $9350 each on account, terms 2/10, n/30, FOB Shipping Point, the company uses FIFO to find the cost of goods sold. Record the sales revenue first. 18-Dec Paid for an ad in the local newspaper, $5000. 24-Dec Received $74800 payment for 8 robots to be shipped on January 8, 2025. 31-Dec Prepared payroll for the month of December, the first payroll for the company. Record the Salaries Expense entry first. The tax rates are as follows: Federal Income Tax Rate - 15%. NC State Income Tax Rate - 10%. FICA Tax Rate - 7.65%. Unemployment Tax Rate 6% on the first $7000 of each employees earnings per year. Instructions Daily Transactions Adjusting Entries Ledger Adjusted Trial Balance Income Statement Equity Statement Low (Green) Workbook Statistics 49 A B C D E F G H | J K L M 51 52 53 50 2) Post all the Daily Transactions to the Ledger on the Ledger tab. 3) As of December 31, a search revealed the following information. Record any necessary adjusting entries for the year on the Adjusting Entries tab. 1 The computer equipment purchased on November 1 has a 5-year life and an expected residual (salvage) value of $6000. 54 2 Record any interest that has accrued on the note signed on November 1 for the computer system. 55 3 The rent paid on November 2 is for two years beginning on November 1. 56 4 The insurance policy purchased on November 18 is effective beginning December 1. 57 5 Supplies on hand as of December 31 totaled $1100. 58 59 6 The delivery truck purchased on December 1 has a 10-year life and an expected residual (salvage) value of $6000. 7 Accrue the interest, if needed, on the note signed on December 1. 60 61 8 Record any bad debt expense for the year ended December 31. Round answer to the whole dollar if needed. 9 Utilites accrued but not yet paid as of December 31 totaled $5600. 62 63 4) Post all the Adjusting Entires to the Ledger on the Ledger tab. 645) Based on the account balances in the ledger, create an adjusted trial balance on the Adjusted Trial Balance tab. 65 6) Based on the adjusted trial balance, prepare a multi-step income statement on the Income Statement tab. 66 7) Based on the adjusted trial balance, prepare the statement of stockholders' equity on the Equity Statement tab. 67 8) Based on the adjusted trial balance, prepare the balance sheet on the Balance Sheet tab. 68 9) Prepare the closing entries (DO NOT POST them to the ledger, just produce the entries). When journaling, close the accounts in the order they appear on the Trial Balance. Do one entry for revenue accounts, one for expense accounts and one for dividend accounts. 69 10) Calculate the ratios on the Ratios tab. 70 71 72 73 74 = Low (Green) Instructions Workbook Statistics Daily Transactions Adjusting Entries A Ledger Adjusted Trial Balance Income Statement Equity Stater B28 X fx A B C 1 2 3 4 Cash 5 Accounts Receivable Adjusted Trial Balance December 31, 2024 Account Name Debit Credit 568,966.50 205,700.00 6 Allowance for Uncollectible Accounts 6,664.00 7 Inventory 30,250.00 8 Supplies 9 Prepaid Rent 10 Prepaid Insurance 11 Computer Equipment 1,100.00 9,533.33 5,750.00 60,000.00 12 Accumulated Depreciation - Computer 1,800.00 13 Delivery Truck 60,000.00 14 Accumulated Depreciation - Delivery Truck 15 Accounts Payable 450.00 129,600.00 625.00 16 Interest Payable 17 Deferred Revenue 18 Salaries Payable 19 Notes Payable 20 Federal Income Tax Payable 21 NC State Income Tax Payable > Instructions 74,800.00 7,408.50 125,000.00 3,300.00 2,200.00 Daily Transactions Adjusting Entries Ledger Adjusted Trial Bala J24 A X fx B D E F G H K L 1 2 Cash Accounts Receivable General Ledger (T-Account) Allowance for Uncollectible 3 520,000.00 10,400.00 127,500.00 127,500.00 4 123,675.00 50,000.00 205,700.00 5 65,000.00 2,500.00 16 74,800.00 6,000.00 Inventory Accounts 50,000.00 77,500.00 6,664.00 66,000.00 129,250.00 121,000.00 6,664.00 30,250.00 7 5,200.00 8 7,408.50 205,700.00 6 60,000.00 10 66,000.00 Supplies Prepaid Rent Prepaid Insurance 11 2,000.00 2,500.00 4,400.00 10,400.00 866.67 6,000.00 250.00 12 5,000.00 3,000.00 13 14 1,100.00 9,533.33 5,750.00 15 568,966.50 16 Accumulated Depreciation - 17 Computer Equipment Computer 18 60,000.00 Accumulated Depreciation - Delivery Truck Delivery Truck 1,800.00 60,000.00 450.00 19 20 60,000.00 60,000.00 21 > > Instructions Daily Transactions 1,800.00 Adjusting Entries Ledger Adjusted Trial Balance Income Statement Equity Statem 450.00 A B C D 22 Accounts Payable 23 2,500.00 2,500.00 24 66,000.00 66,000.00 E Interest Payable 300.00 325.00 FL G H Deferred Revenue K L Salaries Payable 74,800.00 7,408.50 7,408.50 7,408.50 25 3,000.00 26 121,000.00 27 28 5,600.00 129,600.00 625.00 74,800.00 7,408.50 29 30 Notes Payable Federal Income Tax Payable NC State Income Tax Payable FICA Tax Payable 31 60,000.00 1,650.00 1,100.00 841.50 32 65,000.00 1,650.00 1,100.00 841.50 33 841.50 34 841.50 35 125,000.00 2,200.00 3,366.00 36 3,300.00 Common Stock Retained Earnings 660.00 520,000.00 180.00 840.00 520,000.00 37 Unemployment Tax Payable 38 39 40 41 21 > Cash Dividends 2,000.00 2,000.00 > = Instructions Daily Transactions Adjusting Entries A Ledger Adjusted Trial Balance Income Statement Equity Stateme Low (Green) Workbook Statistics 23 42 43 44 A B C D Sales Revenue 127,500.00 205,700.00 E F G H Sales Discounts 3,825.00 Service Revenue K Cost of Goods Sold 129,250.00 77,500.00 45 16 46 333,200.00 3,825.00 206,750.00 47 48 Advertising Expense Utilities Expense Salaries Expense 49 5,000.00 5,200.00 11,000.00 50 5,600.00 11,000.00 51 5,000.00 10,800.00 22,000.00 Depreciation Expense 1,800.00 450.00 2,250.00 52 53 Rent Expense Interest Expense Supplies Expense Bad Debt Expense 54 866.67 300.00 4,400.00 6,664.00 55 325.00 56 866.67 625.00 4,400.00 6,664.00 57 58 Payroll Tax Expense 59 60 56 1,502.00 Insurance Expense 250.00 1,022.00 61 2,524.00 250.00 > Instructions Daily Transactions Adjusting Entries NOTE: Three accounts have check figures. After posting the Daily Transactions, your Cash, Accounts Receivable, and Cost of Goods Sold balance will show GREEN if it is correct. Ledger Adjusted Trial Balance A Income Statement Equity State Low (Green) Workbook Statistics N4 A 2 3 5 6 B fx Macon Machines F H D E G Company mummalIVIT & JUMmmmary vi significant ACCOUNTCTORICIES J K Macon Machines Company began operations on November 1, 2024. The main operating goal of the company is to sell high end robots. Customers may pay using cash or if appropriate, credit is extended to customers with terms 3/15, n/30. 4 The company uses the perpetual inventory method and a FIFO cost system. The company follows a calendar year, with all adjusting entries made at the end of the accounting period, December 31. The company uses the straight-line depreciation for all depreciable assets. The company has decided to use the Allowance method to account for uncollectible accounts. At the end of the period, based on industry standards, the company believes 2% of the balance in accounts recievable will be uncollectible. The company purchases robots for resale only as such they carry them as inventory. 7 8 9 10 The company has two employees, one is a sales technician, salary of $5000 per month and the other employee is the office 11 manager with a salary of $6000 per month. Payroll is processed on the last day of the month, and paid on the first day of the 12 following month. This means the November 30 payroll with accrue into Salaries Payable and then be paid on Decemember 1. 13 14 Required: 15 16 17 L M Liner yo 1) Make sure your student ID is correct, this will change the information. Macon Machines Company engaged in the following transactions for November and December. Record the following transactions on the Daily Transactions tab. Note: Place debits first, credits second but do NOT indent credits. If more than one debit or credit, please list in alphabetical order to receive full credit. Round to the penny unless otherwise noted. 1-Nov The owner invested $520000 into the company in exchange for 5,000 shares of common stock. 1-Nov The company purchased a computer system for $60000 and signed a one-year note for the entire balance. The note is due on November 1, 2025 and has an annual rate of interest of 3%. Company Ma Product 18 19 2-Nov Paid for two years rent on the office space, $10400. 20 3-Nov Purchased 10 robots at a total cost of $5000 each for cash, FOB Destination. 21 4-Nov Purchased $2500 of supplies on account, term n/30. 22 23 34 15-Nov Purchased 12 robots at a total cost of $5500 each on account, terms n/30, FOB Destination. Shipping of $150 was paid to the shipping company by the appropriate party. 17-Nov Paid for the supplies purchased on November 4. 18-Nov Paid for a two-year insurance policy for the store, $6000. The policy was effective beginning December 1, 2024. 20-Nov Sold 15 robots for $8500 each on account, terms 3/15, n/30, the company uses FIFO to find the cost of goods sold. The robots chinned COD Chinning Daint. Danned the colon n 24 25 > = Low (Green) Workbook Statistics fiunt Instructions Daily Transactions Adjusting Entries Ledger Adjusted Trial Balance Income Statement Equity Sta N4 A 25 B fx Macon Machines C D E F G H 20-Nov Sold 15 robots for $8500 each on account, terms 3/15, n/30, the company uses FIFO to find the cost of goods sold. The robots were shipped FOB Shipping Point. Record the sales revenue first. 28-Nov Received payment in full on account from the November 20 sale. 26 27 29-Nov Paid for November's utilities bill $5200. 28 Prepared payroll for the month of November, the first payroll for the company. Record the Salares Expense entry first. The tax 30-Nov rates are as follows: 29 30 31 32 23 33 34 35 36 69 Federal Income Tax Rate - 15%. NC State Income Tax Rate - 10%. FICA Tax Rate - 7.65%. Unemployment Tax Rate 6% on the first $7000 of each employees earnings per year. 1-Dec Paid the employees the amount due to them from the November 30 payroll, taxes will be paid in January. 1-Dec The company borrowed $65000 from Bank of America by signing a 15-year, 6% note. The note requires annual payments of $6693 beginning December 1, 2025. 1-Dec Purchased a new delivery truck to save customers on shipping. The total cost of the Delivery Truck was $60000. 4-Dec Paid the amount due from the November 15 purchase. 37 38 5-Dec Declared and paid $2000 in cash dividends to the stockholders of the company. 39 6-Dec Purchased $3000 of supplies on account, term n/30. 40 21 41 42 23 43 44 45 46 47 48 M N 7-Dec Purchased 20 robots at a cost of $6050 each on account, terms n/30, FOB Destination. 15-Dec Sold 22 robots for $9350 each on account, terms 2/10, n/30, FOB Shipping Point, the company uses FIFO to find the cost of goods sold. Record the sales revenue first. 18-Dec Paid for an ad in the local newspaper, $5000. 24-Dec Received $74800 payment for 8 robots to be shipped on January 8, 2025. 31-Dec Prepared payroll for the month of December, the first payroll for the company. Record the Salaries Expense entry first. The tax rates are as follows: Federal Income Tax Rate - 15%. NC State Income Tax Rate - 10%. FICA Tax Rate - 7.65%. Unemployment Tax Rate 6% on the first $7000 of each employees earnings per year. Instructions Daily Transactions Adjusting Entries Ledger Adjusted Trial Balance Income Statement Equity Statement Low (Green) Workbook Statistics 49 A B C D E F G H | J K L M 51 52 53 50 2) Post all the Daily Transactions to the Ledger on the Ledger tab. 3) As of December 31, a search revealed the following information. Record any necessary adjusting entries for the year on the Adjusting Entries tab. 1 The computer equipment purchased on November 1 has a 5-year life and an expected residual (salvage) value of $6000. 54 2 Record any interest that has accrued on the note signed on November 1 for the computer system. 55 3 The rent paid on November 2 is for two years beginning on November 1. 56 4 The insurance policy purchased on November 18 is effective beginning December 1. 57 5 Supplies on hand as of December 31 totaled $1100. 58 59 6 The delivery truck purchased on December 1 has a 10-year life and an expected residual (salvage) value of $6000. 7 Accrue the interest, if needed, on the note signed on December 1. 60 61 8 Record any bad debt expense for the year ended December 31. Round answer to the whole dollar if needed. 9 Utilites accrued but not yet paid as of December 31 totaled $5600. 62 63 4) Post all the Adjusting Entires to the Ledger on the Ledger tab. 645) Based on the account balances in the ledger, create an adjusted trial balance on the Adjusted Trial Balance tab. 65 6) Based on the adjusted trial balance, prepare a multi-step income statement on the Income Statement tab. 66 7) Based on the adjusted trial balance, prepare the statement of stockholders' equity on the Equity Statement tab. 67 8) Based on the adjusted trial balance, prepare the balance sheet on the Balance Sheet tab. 68 9) Prepare the closing entries (DO NOT POST them to the ledger, just produce the entries). When journaling, close the accounts in the order they appear on the Trial Balance. Do one entry for revenue accounts, one for expense accounts and one for dividend accounts. 69 10) Calculate the ratios on the Ratios tab. 70 71 72 73 74 = Low (Green) Instructions Workbook Statistics Daily Transactions Adjusting Entries A Ledger Adjusted Trial Balance Income Statement Equity Stater B28 X fx A B C 1 2 3 4 Cash 5 Accounts Receivable Adjusted Trial Balance December 31, 2024 Account Name Debit Credit 568,966.50 205,700.00 6 Allowance for Uncollectible Accounts 6,664.00 7 Inventory 30,250.00 8 Supplies 9 Prepaid Rent 10 Prepaid Insurance 11 Computer Equipment 1,100.00 9,533.33 5,750.00 60,000.00 12 Accumulated Depreciation - Computer 1,800.00 13 Delivery Truck 60,000.00 14 Accumulated Depreciation - Delivery Truck 15 Accounts Payable 450.00 129,600.00 625.00 16 Interest Payable 17 Deferred Revenue 18 Salaries Payable 19 Notes Payable 20 Federal Income Tax Payable 21 NC State Income Tax Payable > Instructions 74,800.00 7,408.50 125,000.00 3,300.00 2,200.00 Daily Transactions Adjusting Entries Ledger Adjusted Trial Bala J24 A X fx B D E F G H K L 1 2 Cash Accounts Receivable General Ledger (T-Account) Allowance for Uncollectible 3 520,000.00 10,400.00 127,500.00 127,500.00 4 123,675.00 50,000.00 205,700.00 5 65,000.00 2,500.00 16 74,800.00 6,000.00 Inventory Accounts 50,000.00 77,500.00 6,664.00 66,000.00 129,250.00 121,000.00 6,664.00 30,250.00 7 5,200.00 8 7,408.50 205,700.00 6 60,000.00 10 66,000.00 Supplies Prepaid Rent Prepaid Insurance 11 2,000.00 2,500.00 4,400.00 10,400.00 866.67 6,000.00 250.00 12 5,000.00 3,000.00 13 14 1,100.00 9,533.33 5,750.00 15 568,966.50 16 Accumulated Depreciation - 17 Computer Equipment Computer 18 60,000.00 Accumulated Depreciation - Delivery Truck Delivery Truck 1,800.00 60,000.00 450.00 19 20 60,000.00 60,000.00 21 > > Instructions Daily Transactions 1,800.00 Adjusting Entries Ledger Adjusted Trial Balance Income Statement Equity Statem 450.00 A B C D 22 Accounts Payable 23 2,500.00 2,500.00 24 66,000.00 66,000.00 E Interest Payable 300.00 325.00 FL G H Deferred Revenue K L Salaries Payable 74,800.00 7,408.50 7,408.50 7,408.50 25 3,000.00 26 121,000.00 27 28 5,600.00 129,600.00 625.00 74,800.00 7,408.50 29 30 Notes Payable Federal Income Tax Payable NC State Income Tax Payable FICA Tax Payable 31 60,000.00 1,650.00 1,100.00 841.50 32 65,000.00 1,650.00 1,100.00 841.50 33 841.50 34 841.50 35 125,000.00 2,200.00 3,366.00 36 3,300.00 Common Stock Retained Earnings 660.00 520,000.00 180.00 840.00 520,000.00 37 Unemployment Tax Payable 38 39 40 41 21 > Cash Dividends 2,000.00 2,000.00 > = Instructions Daily Transactions Adjusting Entries A Ledger Adjusted Trial Balance Income Statement Equity Stateme Low (Green) Workbook Statistics 23 42 43 44 A B C D Sales Revenue 127,500.00 205,700.00 E F G H Sales Discounts 3,825.00 Service Revenue K Cost of Goods Sold 129,250.00 77,500.00 45 16 46 333,200.00 3,825.00 206,750.00 47 48 Advertising Expense Utilities Expense Salaries Expense 49 5,000.00 5,200.00 11,000.00 50 5,600.00 11,000.00 51 5,000.00 10,800.00 22,000.00 Depreciation Expense 1,800.00 450.00 2,250.00 52 53 Rent Expense Interest Expense Supplies Expense Bad Debt Expense 54 866.67 300.00 4,400.00 6,664.00 55 325.00 56 866.67 625.00 4,400.00 6,664.00 57 58 Payroll Tax Expense 59 60 56 1,502.00 Insurance Expense 250.00 1,022.00 61 2,524.00 250.00 > Instructions Daily Transactions Adjusting Entries NOTE: Three accounts have check figures. After posting the Daily Transactions, your Cash, Accounts Receivable, and Cost of Goods Sold balance will show GREEN if it is correct. Ledger Adjusted Trial Balance A Income Statement Equity State Low (Green) Workbook Statistics