Need help with solving requirements 1-6 on excel.

Black Widow Corporation is a small private corporation that sells desktop printers to local businesses and schools. On May 1 , 2023 , the following were the account balances of Black Widow Corporation: During May 2023, the following transactions took place: May 1: Bought 220 desktop printers for $198 each on account. May 1: Bought a van, paying $11550 cash as a down payment and signed a 10 month $35200, 9% note payable for the balance. The company paid $660 to have its company logo printed on the side of the van. The residual value is $8800. The old van was sold for $8250; it cost $35200 and acculumated depreciation up to the date of disposal was $33000. May 10: Sold 110 printers to Groot Inc. on account. May 12: Quinn Worldwide agreed to sign a 90 -day note receivable to replace a $3300 accounts receivable due that day. The interest rate on the note is 6.05%. May 20: Sold 10 printers to Hulk Inc. using a VISA card to pay for the transaction. A 4.95% service fee is charged by VISA. May 22: Sold 105 printers to Steve Rogers Public School on account. May 24: Returned for credit 8 damaged printers from Groot Inc., costing $231 each. May 28: Received payment in full from Groot Inc. for tha balance owing. May 28: Wrote off as uncollectable $4675 of accounts receivable. May 29: Paid accounts payable, $9900. May 30: Recovered an accounts receivable that was written off in April, $715. May 31: Paid operating expenses totalling $50050. May 31: Recorded depreciation on the van and the furniture \& fixtures. The company uses straight-line depreciation for the van. The van is estimated to be 9 years. The furniture \& fixtures are depreciated using the straight-line method over 4 years. There is no residual value on the furniture and fixtures. May 31: Recorded interest on the note payable. May 31: Recorded interest on the notes receivable. May 31: The company records the bad debt expense based on the aging of accounts receivables, which follows: ther Information: 1) The selling price for each of the printers is $495. 2) Black Widow Corporation uses the FIFO method under the perpetual inventory system to account for inventory. 3) In the past, Black Widow Corporation has used the following accounts on their financial statements: Bad Debt Expense, Cost of Goods Sold, Credit Card Fee, Depreciation Expense, Gain on Sale, Interest Expense, Interest Payable, Interest Receivable, Interest Revenue, Loss on Sale, Notes Payable, Notes Receivable, Operating Expenses, Sales Returns, Sales Revenue. Not all accounts have been used each period. 1) Prepare the journal entries for the transactions including any adjusting journal entries for the month of May 31 , 2023. Place your answer under "Requirement 1 " in the "Answer" tab. A reminder to round all final numbers to the nearest dollar. Do not round during calculations. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. Explanations are not required. 2) Prepare an adjusted trial balance as at May 31, 2023. Place your answer under "Requirement 2 " in the "Answer" tab. Place your account titles in column H, debits in column I and credits in column J. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. 3) Prepare the multi-step Income Statement for the month of May 2023. Ignore income taxes. Place your answer under "Requirement 3 " in the "Answer" tab. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. 4) Prepare a classified Balance Sheet at at May 31, 2023. Place your answer under "Requirement 4" in the "Answer" tab. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. 5) Assume Black Widow Corporation overstated its ending inventory by $1430. How does this affect cost of goods sold, gross profit, and net income in the year it was discovered? If the error is undetected, what is the impact on cost of goods sold, gross profit, and net income for the following year. Place your answer under "Requirement 5" in the "Answer" tab using the drop down menus. Enter any type responses in the designated spots. 6) Assume that Black Widow Corporation used the LCNRV to report inventory on the balance sheet. The NRV of $660 is less than the FIFO cost. Prepare the journal entry. Place your answer under "Requirement 6 " in the "Answer" tab. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. Explanations are not required. Black Widow Corporation is a small private corporation that sells desktop printers to local businesses and schools. On May 1 , 2023 , the following were the account balances of Black Widow Corporation: During May 2023, the following transactions took place: May 1: Bought 220 desktop printers for $198 each on account. May 1: Bought a van, paying $11550 cash as a down payment and signed a 10 month $35200, 9% note payable for the balance. The company paid $660 to have its company logo printed on the side of the van. The residual value is $8800. The old van was sold for $8250; it cost $35200 and acculumated depreciation up to the date of disposal was $33000. May 10: Sold 110 printers to Groot Inc. on account. May 12: Quinn Worldwide agreed to sign a 90 -day note receivable to replace a $3300 accounts receivable due that day. The interest rate on the note is 6.05%. May 20: Sold 10 printers to Hulk Inc. using a VISA card to pay for the transaction. A 4.95% service fee is charged by VISA. May 22: Sold 105 printers to Steve Rogers Public School on account. May 24: Returned for credit 8 damaged printers from Groot Inc., costing $231 each. May 28: Received payment in full from Groot Inc. for tha balance owing. May 28: Wrote off as uncollectable $4675 of accounts receivable. May 29: Paid accounts payable, $9900. May 30: Recovered an accounts receivable that was written off in April, $715. May 31: Paid operating expenses totalling $50050. May 31: Recorded depreciation on the van and the furniture \& fixtures. The company uses straight-line depreciation for the van. The van is estimated to be 9 years. The furniture \& fixtures are depreciated using the straight-line method over 4 years. There is no residual value on the furniture and fixtures. May 31: Recorded interest on the note payable. May 31: Recorded interest on the notes receivable. May 31: The company records the bad debt expense based on the aging of accounts receivables, which follows: ther Information: 1) The selling price for each of the printers is $495. 2) Black Widow Corporation uses the FIFO method under the perpetual inventory system to account for inventory. 3) In the past, Black Widow Corporation has used the following accounts on their financial statements: Bad Debt Expense, Cost of Goods Sold, Credit Card Fee, Depreciation Expense, Gain on Sale, Interest Expense, Interest Payable, Interest Receivable, Interest Revenue, Loss on Sale, Notes Payable, Notes Receivable, Operating Expenses, Sales Returns, Sales Revenue. Not all accounts have been used each period. 1) Prepare the journal entries for the transactions including any adjusting journal entries for the month of May 31 , 2023. Place your answer under "Requirement 1 " in the "Answer" tab. A reminder to round all final numbers to the nearest dollar. Do not round during calculations. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. Explanations are not required. 2) Prepare an adjusted trial balance as at May 31, 2023. Place your answer under "Requirement 2 " in the "Answer" tab. Place your account titles in column H, debits in column I and credits in column J. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. 3) Prepare the multi-step Income Statement for the month of May 2023. Ignore income taxes. Place your answer under "Requirement 3 " in the "Answer" tab. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. 4) Prepare a classified Balance Sheet at at May 31, 2023. Place your answer under "Requirement 4" in the "Answer" tab. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. 5) Assume Black Widow Corporation overstated its ending inventory by $1430. How does this affect cost of goods sold, gross profit, and net income in the year it was discovered? If the error is undetected, what is the impact on cost of goods sold, gross profit, and net income for the following year. Place your answer under "Requirement 5" in the "Answer" tab using the drop down menus. Enter any type responses in the designated spots. 6) Assume that Black Widow Corporation used the LCNRV to report inventory on the balance sheet. The NRV of $660 is less than the FIFO cost. Prepare the journal entry. Place your answer under "Requirement 6 " in the "Answer" tab. Ensure your spelling is accurate. Do not use abbreviations for your accounts. Spell them out in their entirety. A reminder to only use the accounts given in the question. Explanations are not required