please help with adjusted trial balance and income statement.
A D N1 XV ft E G H Company Information & Summary of Significant Account Polides 2 Madison Machines Company began operations on November 1, 2023. The main operating goal of the company is to sell high end 3 robots. Customers may pay using cash or if appropriate, a credit is extended to customers with terms 3/15,1/30. The company uses the perpetual inventory method and a FIFO cost system. The company follows a calendar year with all 5. austing entries made at the end of the accounting period, December 31. The company uses the straight line depreciation 6 for all depreciable assets. The company has decided to use the Allowance method to account for uncollectible accounts. At 7 the end of the period, based on Industry standards, the company belleves 1% of the balance in accounts recevable will be uncollectible. The company purchases robots for resale only as such they carry them as inventory 9 10 The company has two employees, one is a sales technician, salary of S4000 per month and the other employee is the office 11 manager with a salary of $6000 per month. Payroll ts 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 Salarles Payable and then be paid on Decemember 1. 13 14 Required: 151) Madison Machines Company engaged in the following transactions for November and December. Record the following transactions on the Dally Transactions tab 16 Note: Plan detaliu fort, credits second but do NOT Indent credits. more than one deblt or credit, please list in alphabetical order to receive full credit. 1. Nov The owner invested $100000 into the company in exchange for 5000 shares of common stock 1. Nov The company purchased a computer system for $10000 and signed a one-year note for the entire balance. The note is due on November 1, 2024 and 13 has an annual rate of interest of 3 19 2. Now Paid for two years rent on the office space, $12000, 20 3- No Purchased 10 robots at a total cost of $1000 each for cash FOB Destination 21 4-Now Purchased $1600 of supplies on account, term 1/30 15-Nov Purchased 12 robots at a total cost of $1100 each on account, terms 1/30, FOB Destination. Shipping of $150 was paid to the shipping company by the 2 appropriate party 17-Nov Pald for the supplies purchased on November 4 4 18 Now Paid for two year insurance policy for the store $6000. The policy was effective beginning December 1, 2023. 20-Nov Sold 16 ridots for $3100 each on account, terms 3/15, 1/30, the company uses FIFO to find the cost of goods sold. The printers were shipped FOB 5 Shipping Point. Record the sales revenue first 28-Nov Received payment in full on account from the November 20 sale. 7 23-Now Paid for November's utilities bil $1500. 30-Now Prepared payroll for the month of November, the first payroll for the company. Record the Salares 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 57000 of each employees eamings per year. 1-Dec Paid the employees the amount due to them from the November 30 payroll, taxes will be paid in January The company borrowed 560000 from Bank of Amerka by signing a 10 year, 4% note. The note requires annual payments of $7397 beginning December Instructions Daily Transactions Adjusting Entries Ledger Adjusted 1-Dec 1-Dec. Pald the employees the amount due to them from the November 30 payroll, taxes will be paid in January. The company borrowed $60000 from Bank of America by signing a 10-year, 4% note. The note requires annual payments of S7397 beginning December 1-Dec 1, 2024 1-Dec Purchased a new delivery truck to save customers on shipping. The total cost of the Dellvery Truck was $40000. 4-Dec Paid the amount due from the November 15 purchase. 5-Dec Declared and paid $2000 in cash dividends to the stockholders of the company 6-Dec Purchased $1100 of supplies on account, term 1/30. 7-Dec Purchased 20 robots at a cost of $1210 each on account, terms n730, FOB Destination. 15-Dec Sold 22 robots for $3410 each on account, terms 2/10, r/30, the company uses FIFO to find the cost of goods sold. Record the sales revenue first. 18-Dec Pald foran ad in the local newspaper, $1500. 24-Dec Received $27280 payment for robots to be shipped on January 8, 2024. 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. 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 $1000. 2. Record any interest that has accrued on the note signed on November 1 for the computer system. 3. The rent pakd on November 2 is for two years beginning on November 1 4 The Insur policy purchased on November 18 is effective beginning December 1 S Supplies on hand as of December 31 totaled $40S. 6 The delivery truck purchased on December 1 has a 10 year life and an expected residual (salvage) value of 54000 Acore the interest needed on the note skened on December 1 & Record any bad debt expense for the year ended December 31. If needed, round to the nearest dollar 9 Ultes accrued but not yet paid as of December 31 totaled S1800, 4) Post all the Adjusting Entires to the Ledger on the Ledger tab. 5) Based on the account balances in the ledger, create an adjusted trial balance on the Adjusted Trial Balance tab. 6) Based on the adjusted trial balance, prepare a multi-step Income statement on the income Statement tab. 7) Based on the adjusted trial balance, prepare the statement of stockholders' equity on the Equity Statement tab. 8) Based on the adjusted trial balance, prepare the balance sheet on the Balance Sheettah 9 Prepare the desing 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 A D N1 XV ft E G H Company Information & Summary of Significant Account Polides 2 Madison Machines Company began operations on November 1, 2023. The main operating goal of the company is to sell high end 3 robots. Customers may pay using cash or if appropriate, a credit is extended to customers with terms 3/15,1/30. The company uses the perpetual inventory method and a FIFO cost system. The company follows a calendar year with all 5. austing entries made at the end of the accounting period, December 31. The company uses the straight line depreciation 6 for all depreciable assets. The company has decided to use the Allowance method to account for uncollectible accounts. At 7 the end of the period, based on Industry standards, the company belleves 1% of the balance in accounts recevable will be uncollectible. The company purchases robots for resale only as such they carry them as inventory 9 10 The company has two employees, one is a sales technician, salary of S4000 per month and the other employee is the office 11 manager with a salary of $6000 per month. Payroll ts 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 Salarles Payable and then be paid on Decemember 1. 13 14 Required: 151) Madison Machines Company engaged in the following transactions for November and December. Record the following transactions on the Dally Transactions tab 16 Note: Plan detaliu fort, credits second but do NOT Indent credits. more than one deblt or credit, please list in alphabetical order to receive full credit. 1. Nov The owner invested $100000 into the company in exchange for 5000 shares of common stock 1. Nov The company purchased a computer system for $10000 and signed a one-year note for the entire balance. The note is due on November 1, 2024 and 13 has an annual rate of interest of 3 19 2. Now Paid for two years rent on the office space, $12000, 20 3- No Purchased 10 robots at a total cost of $1000 each for cash FOB Destination 21 4-Now Purchased $1600 of supplies on account, term 1/30 15-Nov Purchased 12 robots at a total cost of $1100 each on account, terms 1/30, FOB Destination. Shipping of $150 was paid to the shipping company by the 2 appropriate party 17-Nov Pald for the supplies purchased on November 4 4 18 Now Paid for two year insurance policy for the store $6000. The policy was effective beginning December 1, 2023. 20-Nov Sold 16 ridots for $3100 each on account, terms 3/15, 1/30, the company uses FIFO to find the cost of goods sold. The printers were shipped FOB 5 Shipping Point. Record the sales revenue first 28-Nov Received payment in full on account from the November 20 sale. 7 23-Now Paid for November's utilities bil $1500. 30-Now Prepared payroll for the month of November, the first payroll for the company. Record the Salares 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 57000 of each employees eamings per year. 1-Dec Paid the employees the amount due to them from the November 30 payroll, taxes will be paid in January The company borrowed 560000 from Bank of Amerka by signing a 10 year, 4% note. The note requires annual payments of $7397 beginning December Instructions Daily Transactions Adjusting Entries Ledger Adjusted 1-Dec 1-Dec. Pald the employees the amount due to them from the November 30 payroll, taxes will be paid in January. The company borrowed $60000 from Bank of America by signing a 10-year, 4% note. The note requires annual payments of S7397 beginning December 1-Dec 1, 2024 1-Dec Purchased a new delivery truck to save customers on shipping. The total cost of the Dellvery Truck was $40000. 4-Dec Paid the amount due from the November 15 purchase. 5-Dec Declared and paid $2000 in cash dividends to the stockholders of the company 6-Dec Purchased $1100 of supplies on account, term 1/30. 7-Dec Purchased 20 robots at a cost of $1210 each on account, terms n730, FOB Destination. 15-Dec Sold 22 robots for $3410 each on account, terms 2/10, r/30, the company uses FIFO to find the cost of goods sold. Record the sales revenue first. 18-Dec Pald foran ad in the local newspaper, $1500. 24-Dec Received $27280 payment for robots to be shipped on January 8, 2024. 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. 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 $1000. 2. Record any interest that has accrued on the note signed on November 1 for the computer system. 3. The rent pakd on November 2 is for two years beginning on November 1 4 The Insur policy purchased on November 18 is effective beginning December 1 S Supplies on hand as of December 31 totaled $40S. 6 The delivery truck purchased on December 1 has a 10 year life and an expected residual (salvage) value of 54000 Acore the interest needed on the note skened on December 1 & Record any bad debt expense for the year ended December 31. If needed, round to the nearest dollar 9 Ultes accrued but not yet paid as of December 31 totaled S1800, 4) Post all the Adjusting Entires to the Ledger on the Ledger tab. 5) Based on the account balances in the ledger, create an adjusted trial balance on the Adjusted Trial Balance tab. 6) Based on the adjusted trial balance, prepare a multi-step Income statement on the income Statement tab. 7) Based on the adjusted trial balance, prepare the statement of stockholders' equity on the Equity Statement tab. 8) Based on the adjusted trial balance, prepare the balance sheet on the Balance Sheettah 9 Prepare the desing 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
