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.
