Question: can you help with this on excel i am trying...
Can you help with this on excel? I am trying to figure out the actual calculations.
For each item above, indicate the dollar amounts to be reported as a current liability and as a long-term liability, if any.
E5-9 (L02,3) (Current Assets and Current Liabilities) The current assets and current liabilities sections of the balance sheet
of Allessandro Scarlatti Company appear as follows.
ALLESSANDRO SCARLATTI COMPANY
BALANCE SHEET (PARTIAL)
DECEMBER 31, 2017
Cash $ 40,000 Accounts payable $ 61,000
Accounts receivable $89,000 Notes payable 67,000
Less: Allowance for $128,000
doubtful accounts 7,000 82,000
Prepaid expenses 9,000
The following errors in the corporation’s accounting have been discovered:
1. January 2018 cash disbursements entered as of December 2017 included payments of accounts payable in the amount of
$39,000, on which a cash discount of 2% was taken.
2. The inventory included $27,000 of merchandise that had been received at December 31 but for which no purchase invoices
had been received or entered. Of this amount, $12,000 had been received on consignment; the remainder was purchased
f.o.b. destination, terms 2/10, n/30.
3. Sales for the first four days in January 2018 in the amount of $30,000 were entered in the sales journal as of December 31,
2017. Of these, $21,500 were sales on account and the remainder were cash sales.
4. Cash, not including cash sales, collected in January 2018 and entered as of December 31, 2017, totaled $35,324. Of this
amount, $23,324 was received on account after cash discounts of 2% had been deducted; the remainder represented the
proceeds of a bank loan.
(a) Restate the current assets and current liabilities sections of the balance sheet in accordance with good accounting
practice. (Assume that both accounts receivable and accounts payable are recorded gross.)
(b) State the net effect of your adjustments on Allessandro Scarlatti Company’s retained earnings balance.