willing to pay extra just need all forms completed

credit. Required: 1) Madison 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 1-Nov The owner invested S100000 into the company in exchange for 5.000 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 has an annual rate of interest of 3%. 2.Now Paid for two years rent on the office space, S12000 3-Nov Purchased 10 robots at a total cost of $1000 each for cash, FOB Destination. 4-Now Purchased S1600 of supplies on account, term n/30. 15-Nov Purchased 12 robots at a total cost of 1100 each on account, terms n/30, FOB Destination. Shipping or iso 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, 56000. The policy was effective beginning December 1, 2023. 20-Nov Sold 16 robots for $3100 each on account, terms 3/15. n/30, the company uses FIFO to find the cost of goods sold. The printers were shipped FOB Shipping Point. Record the sales revenue first 28-Nov Received payment in full on account from the November 20 sale. 29. Nov Paid for November's utilities bill $1500 30-Nov 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 $7000 of each employees earnings per year. 1-Dec 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 America by signing a 10-year, 4% note. The note requires annual payments of S7397 beginning December 1, 2024 1-Dee Purchased a new delivery truck to save customers on shipping. The total cost of the Delivery 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-Dee Purchased S1100 of supplies on account, term n/30 7-Dec Purchased 20 robots at a cost of $1210 each on account, terms n/30, FOB Destination 15-Dec sold 22 robots for $3410 each on account, terms 2/10, 1/30, 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, S1500 24-Dec Received $27280 payment for 8 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 I 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 I for the computer system. 3 The rent paid on November 2 is for two years beginning on November I. 4 The insurance policy purchased on November 18 is effective beginning December I. 5 Supplies on hand as of December 31 totaled $405 6 The delivery truck purchased on December 1 has a 10-year life and an expected residual (salvage) value of $4000 7 Accrue the interest, if needed, on the note signed on December 1. 8 Record any bad debt expense for the year ended December 31. If needed, round to the nearest dollar. Utilites accrued but not yet paid as of December 31 totaled $1800. 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 Sheet tab. 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. 10) Calculate the ratios on the Ratios tab. IN IN 4. 19- 11 Adjusting Entries Journal Page Account DR CR 2 6 8 9 Grenada Account Revale ntary Supplies Prepaid Rear Prepaid Insurance Mermalaiad buparations - Camp Computer Equipment Datens Track Accumulated Depreciative Delivery Track Accounts Payable Interest Payable Deler Salaries Payable HE Notes Payable Federal Income Tax Palle NC State Tu Pahle FICAT Payable L'employmeal Tus Pale Reading Cash Divided 1 Sales Reven Service Revue Sales Custod Gods Sold Athening up Expo Salles Depreciati per Rent Expres Interest Express Bad Debt Expense Payroll Tas Espese Bere Expense NOTE: The bowe checker. After posting the Daily Track Aceh Rabie and Cost of Goods Salle GREEN Adjusted Trial Balance December 31, 2022 Account Name Debit Credit Cash Accounts Receivable Allowance for Uncollectible Accounts Inventory Supplies Prepaid Rent Prepaid Insurance Computer Equipment Accumulated Depreciation - Computer Delivery Truck Accumulated Depreciation - Delivery Truck Accounts Payable Interest Payable Deferred Revenue Salaries Payable Notes Payable Federal Income Tax Payable NC State Income Tax Payable FICA Tax Payable Unemployment Tax Payable Common Stock Retained Earnings Dividends Sales Revenue Service Revenue Sales Discounts Cost of Goods Sold Advertising Expense Utilities Expense Salaries Expense Depreciation Expense Rent Expense Interest Expense Supplies Expense Bad Debt Expense Payroll Tax Expense Insurance Expense Totals Multiple-Step Income Statement For the Year Ended, December 31, 2023 Gross Profit Total Operating Expenses Operating Income Net Income Madison Machines Company Statement of Stockholders' Equity For the Year Ended, December 31, 2023 Common Stock Retained Earnings Total Stockholders' Equity Balance, January 1 Balance, December 31 Madison Machines Company Classified Balance Sheet At December 31, 2023 Total Current Assets Total Assets Total Current Liabilities Total Liabilities Total Stockholders' Equity Total Liabilities & Stockholders' Equity Closing Entries Journal Page Date DR CR Account 31-Dec 31-Dec 31-Dec For each ratio, in the answer cell, use FORMULAS to calculate the ratio, do not type in the answer. Ratio Formula Answer Current Ratio Current Assets/Current Liabilities Use A Formula Debt to Equity Total Liabilities/Stockholders Equity Use A Formula Gross profit ratio GP/Net Sales Use A Formula Profit margin Net income/Net sales Use A Formula Return on Assets Net income/Average total assets Use A Formula