Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
ABC Corporation Trial Balance December 3 1 , 2 0 2 3 Additional information Receivables include: $ 3 5 0 , 0 0 0 Amount
ABC Corporation Trial Balance December Additional information Receivables include: $ Amount owed by customers Allowance for uncollectible accounts from customers Prepaid advertising Shortterm loan receivable due September $ Total receivables Payables consist of: $ note payable due June bonds payable maturing loan payable maturing May due to suppliers for merchandise and services on account received from a customer for merchandise to be provided in January $ Total payables On December the board of directors declared a cash dividend of $ per share on its common stocks outstanding payable January This transaction was not recorded in the company's accounts Cash includes the following: $ Cash in a checking account at Peoples Bank Cash in a savings account at First Bank representing a compensating balance for a longterm loan at this bank Restricted cash in a savings account to pay bonds maturing Undeposited customers' checks Currency and coins in the office $ Total cash The patent was purchased July with a year useful life. However, this asset was never amortized. Amortization of patents is considered a selling expense. Two million shares of $ par value common stock are authorized of which shares were issued and outstanding. On December a customer paid $ in advance for merchandise to be delivered January The cost of this merchandise is $ The accountant incorrectly recorded the amounts in sales revenue and cost of goods sold respectively. These amounts are considered significant. Assume an income tax rate of Required: Use Microsoft Excel to prepare the following financial statement for ABC Corporation: A Classified balance sheet.
ABC Corporation
Trial Balance
December
Additional information
Receivables include:
$ Amount owed by customers
Allowance for uncollectible accounts from customers
Prepaid advertising
Shortterm loan receivable due September
$ Total receivables
Payables consist of:
$ note payable due June
bonds payable maturing
loan payable maturing May
due to suppliers for merchandise and services on account
received from a customer for merchandise to be provided in January
$ Total payables
On December the board of directors declared a cash dividend of $ per share on its common
stocks outstanding payable January This transaction was not recorded in the company's
accounts
Cash includes the following:
$ Cash in a checking account at Peoples Bank
Cash in a savings account at First Bank representing a
compensating balance for a longterm loan at this bank
Restricted cash in a savings account to pay bonds maturing
Undeposited customers' checks
Currency and coins in the office
$ Total cash
The patent was purchased July with a year useful life. However, this asset was
never amortized. Amortization of patents is considered a selling expense.
Two million shares of $ par value common stock are authorized of which shares were issued
and outstanding.
On December a customer paid $ in advance for merchandise to be delivered January
The cost of this merchandise is $ The accountant incorrectly recorded the amounts in sales revenue
and cost of goods sold respectively. These amounts are considered significant.
Assume an income tax rate of
Required:
Use Microsoft Excel to prepare the following financial statement for ABC Corporation:
A Classified balance sheet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started