Please show full solutions with calculations on excel, and please do it on excel. I will put good review and upvote
Captain America Corporation is a small private corporation that sells desktop printers to local businesses and schools. On May 1, 2022, the following were the account balances of Captain America Corporation: During May 2022, the following transactions took place: May 1: Bought 200 desktop printers for $180 each on account. May 1: Bought a van, paying $10500 cash as a down payment and signed a 10 month $32000,9% note payable for the balance. The company paid $750 to have its company logo printed on the side of the van. The residual value is $7500. The old van was sold for $7500; it cost $32000 and acculumated depreciation up to the date of disposal was $30000. May 10: Sold 150 printers to Falcon Inc. on account. May 12: Advanced Idea Mechanics agreed to sign a 90 -day note receivable to replace a $1500 accounts receivable due that day. The interest rate on the note is 9.5%. May 20: Sold 12 printers to Iron Man Inc. using a VISA card to pay for the transaction. A 4.5\% service fee is charged by VISA. May 22: Sold 85 printers to Sam Wilson Public School on account. May 24: Retumed for credit 3 damaged printers from Falcon Inc., costing $180 each. May 28: Received payment in full from Falcon Inc. for tha balance owing. May 28: Wrote off as uncollectable $3250 of accounts receivable. May 29: Paid accounts payable, \$12000. May 30: Recovered an accounts receivable that was written off in April, $900. May 31: Paid operating expenses totalling $45500. May 31: Recorded depreciation on the van and the fumiture \& fixtures. The company uses straight-line depreciation for the van. The van is estimated to be used for 8 years. The fumiture \& fixtures are depreciated using the straight-line method over 6 years. There is no residual value on the fumiture 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 $450. 2) Captain America Corporation uses the FIFO method under the perpetual inventory system to account for inventory. 3) In the past, Captain America 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 Retums, Sales Revenue. Not all accounts have been used each period. Required: 1) Prepare the joumal entries for the transactions including any adjusting joumal entries for the month of May 31, 2022. 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, 2022. 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 2022. 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, 2022. 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 Captain America Corporation overstated its ending inventory by $1000. 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 54 in the "Answer" tab using the drop down menus. Enter any type responses in the designated spots. 6) Assume that Captain America Corporation used the LCNRV to report inventory on the balance sheet. The NRV of $550 is less than the FIFO cost. Prepare the joumal entry. Place your answer under "Requirement 6 " in the "Answer" tab. Ensure your spelling is accurate. Do
