The cash account in the general ledger of Hendry Corporation shows a balance of 96900 at December 31 2009 (prior to performing a bank reconciliation). The company's bank statement shows a balance of $100,560 at the same date. An examination of the bank statement reveals the following:
1. Deposits in transit amount to $24,600
2. Bank Service charges total $200.
3. Outstanding checks total $31,700
4. A $3,600 check marked 'NSF' from Kent Company (one of Hendry Corporation's customers) was returned to Hendry Corporation by the bank. This was the only NSF check that Hendry Corporation received during 2009.
5. A canceled check (no. 244) written by Hendry Corporation in the amount of $1,250 for office equipment was incorrectly recorded in the general ledger as a debit to Office Equipment of $1,520, and a credit to Cash of $1,520.
In addition to the above information, Hendry Corporation owns the following assets at December 31, 2009: (1) money market accounts totaling $75,000, (2) $3,000 of high grade, 90 day commercial paper, and (3) highly liquid stock investments valued at $86,000 at December 31, 2009 (these investments originally cost Hendry Corporation $116,000).
On December 1, 2009, Hendry Corporation sold an unused warehouse to Moran Industries for $100,000. Hendry accepted a six month, $100,000, 6 percent note receivable from Moran. The note, plus accrued interest, is due in full on My 31, 2010. Hendry Corporation adjusts for accrued interest revenue monthly.
Hendry Corporation uses the income statement approach to compute its uncollectible accounts expense. The general ledger had reported Accounts Receivable of $2,150,000 at January 1, 2009. At that time, the allowance for doubtful accounts had a credit balance of $40,000. Throughout 2009, the company wrote off actual accounts receivable of $140,000 and collected $21,213,600 on account from credit customers (this amount includes the $3,600 NSF check received from Kent Company). Credit sales for the year ended December 31, 2009, totaled $20,000,000. Of these credit sales, 2 percent were estimated to eventually become uncollectible.
A. Prepare Hendry Corporation's bank reconciliation dated December 31, 2009, and provide the journal entry necessary to update the company's general ledger balances.
B. Compute cash and cash equivalents to be reported in Hendry Corporation's balance sheet dated December 31, 2009.
C. Prepare the adjusted entry necessary to account for the note receivable from Moran Industries at December 31 2009.
D. Determine the net realizable value of Hendry Corporations accounts receivable at December 31 2009.
E. Determine the total dollar amount of financial assets to be reported in Hendry Corporation's balance sheet dated December 3, 2009
F. Assume that it is normal for firms similar to Hendry Corporation to take an average of 45 days to collect an outstanding receivable. Is Hendry Corporation's collection performance above or below average?
-This problem must be completed in Excel. You may complete different parts of the problem on different sheets.
-Each part of the question should be appropriately labeled and the individual answers must be fully documented. All supporting calculations must be shown.
Cash and cash equivalents on 12/31/09 (part b) = $171,460
The expert prepares a bank reconciliation, journal entries and cash equivalents.