please help me with this question and calculations.

i'd appreciate if it could be done on excel

Thank you!

i'll vote up

.

Thor 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 Thor Corporation: During May 2023, the following transactions took place: May 1: Bought 90 desktop printers for $135 each on account. May 1: Bought a van, paying $9900 cash as a down payment and signed a 10 month $13500,9% note payable for the balance. The company paid $630 to have its company logo printed on the side of the van. The residual value is $7200. The old van was sold for $9000; it cost $40500 and acculumated depreciation up to the date of disposal was $36000. May 10: Sold 90 printers to Kang Inc. on account. May 12: Roxxon Corporation agreed to sign a 90-day note receivable to replace a $2880 accounts receivable due that day. The interest rate on the note is 8.55%. May 20: Sold 5 printers to Captain America Inc. using a VISA card to pay for the transaction. A 4.05% service fee is charged by VISA. May 22: Sold 86 printers to Bucky Barnes Public School on account. May 24: Returned for credit 3 damaged printers from Kang Inc., costing \$189 each. May 28: Received payment in full from Kang Inc. for the balance owing. May 28: Wrote off as uncollectable $2925 of accounts receivable. May 29: Paid accounts payable, $9900. May 30: Recovered an accounts receivable that was written off in April, $810. May 31: Paid operating expenses totalling $40950. 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 used for 10 years. The furniture \& fixtures are depreciated using the straight-line method over 6 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: Other Information: 1) The selling price for each of the printers is $405. 2) Thor Corporation uses the FIFO method under the perpetual inventory system to account for inventory. 3) In the past, Thor 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. quired: 1) Prepare the joumal 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 Thor Corporation overstated its ending inventory by $1440. 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 5in the "Answer" tab using the drop down menus. Enter the amount of the over/understatement (if any) in the designated spots. 6) Assume that Thor Corporation used the LCNRV to report inventory on the balance sheet. The NRV of $585 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