On December 31, 2005, The Walsh Company had the following balances in its balance sheet accounts: Cash $ 98,000 Gross Accounts Receivables $151,000 Allowance for Doubtful Accts. $ 12,000 Prepaid Expenses(Taxes/Insurance) $ 30,000 Inventory $689,000 Land $195,000 Plant/Property/Equipment (PPE) $912,000 Accumulated Depreciation on PPE $613,000 Trade Accounts Payable $123,000 Income Taxes Payable $230,000 Mortgage Notes Payable $560,000 Other Long-Term Debt $115,000 Retained Earnings $297,000 The following information pertains to the Walsh Company and its operations during calendar year 2006: 1. The company purchased $ 1,125,000 worth of inventory during the year, all on credit. Its ending inventory or 2006, totaled $ 667,000. 2. The company had sales totaled $1,900,000. All sales were on credit. 3. Company management assumed for the year that 1% of its credit sales would be uncollectible and recorded these credit sales as bad debt. (hint: the accounts impacted here are bad debt expenses and allowances for doubtful accounts). 4. For the year, the company paid $1,150,000 total cash towards its trade accounts payable. 5. During the year, $30,000 worth of accounts receivable were determined to be uncollectible. (hint: accounts impacted here are accounts receivable and reserve for doubtful accounts.) 6. The company collected cash on accounts receivable totaling $1,890,000. 7. The company recognized $20,000 worth of property tax expense and $10,000 worth of insurance expense for the year. Both of these expenses had previously been recognized as prepaid expenses. 8. Salary expenses totaled $$190,000. Office expenses totaled $$55,000; and Selling/ Administrative Expenses totaled $89,000. All these expenses were paid with cash 9. Interest expense, paid with cash, totaled $70,000. 10. The company made principal payments of $45,000 on its mortgage note and $15,000 on other long-term debts it owes. 11. The company recognized $42,000 of straight-lined depreciation expense. 12. The company paid off its income taxes payable totaling $230,000 using cash. 13. The income tax expense for the year 2006 is $100,000. The 2006 income taxes will be paid in 2007. (2006 income taxes are recorded as income taxes Payable in 2006). 14. The company declared and paid $100,000 in cash dividends to its owners. 15. Net Income for 2006 is $158,000. Using the information presented above and on the preceding page, complete the items below. A) Prepare a properly formatted Balance Sheet for the Walsh Company dated December 31, 2005. B) Determine the balance for Cash as of December 31. 2006. C) Determine the balance for Retained Earnings for December 31, 2006