You recently accepted the controller position for Java the Hut, a regional coffee chain. The owner informs you that a complete financial statement package will be required for a new bank loan package. Prior to your arrival, the company had one accountant and relied heavily on the auditors in the preparation of financial statements. With the new controller position, the expectation is that you will assume the preparation of financial statements. On your first day of work on April 1, 2012, the Java the Hut accountant informs you that there were a number of transactions in the first quarter of 2012 that she was unsure of the appropriate accounting. Consequently, she recorded the cash activity in Other Assets Holding account as a temporary holding account. The good news is that the Java the Hut accountant maintained excellent detail of the various transactions and has a series of supporting schedules for you. Project Requirements 1. Prepare the appropriate journal entries to recognize the first quarter transactions, currently reported in Other Assets Holding in the balance sheet. 2. Prepare consolidating worksheets for the income statement for the first quarter of 2012, the retained earnings for the first quarter of 2012, for the balance sheet as of March 31, 2012, and the cash flow statement for the first quarter of 2012. Adjusting entries from 1 above should be reflected in the appropriate company general ledger. All inter-company transactions and balances should be eliminated. Consolidating worksheets should utilize Excel. Calculations supporting eliminations should be included. 3. Prepare consolidated financial statements for the bank reporting, including: Income Statement for the first quarter of 2012 (Multi-Step Format) Balance Sheet as of March 31, 2012 (Classified Format) Statement of Retained Earnings as of March 31, 2012. Statement of Cash Flows for the first quarter of 2012. Financial Statements should utilize Excel. Schedules Attached Schedule 1 Other assets - holding analysis Schedule 2 Trial Balance of New Castle Coffee as of 01/01/12. Schedule 2A New Castle Coffee Acquisition Support. Schedule 3 Trial Balance of New Castle Coffee as of 03/31/12. Schedule 4 Trial Balance of Java the Hut as of 12/31/11. Schedule 5 Trial Balance of Java the Hut as of 03/31/12. Schedule 6 Intercompany Transactions first quarter 2012.

Schedule 1 Java the Hut Account Analysis Other Assets - Holding account analysis Acquisition Costs of New Castle Coffee on 1/1/12 Purchase price at settlement Professional fees Debt set-up (revolving credit renegotiation) Acquisition Costs of New Castle Coffee on 1/1/12 Equity investment in Newark Coffee on 1/1/12 Purchase of 40% interest Dividends received Equity investment in Newark Coffee on 1/1/12 Other Assets - Holding account analysis 125,000 12,000 6,000 143,000 44,000 (2,000) 42,000 185,000 qattachments_f9cca7356712ec9a616868d75c4ffa4c6ad94c74.xlsx 12/15/2012 01:52:40 Schedule 2 Trial Balance of New Castle Coffee as of 01/01/12 Accounts WTC Checking WTC money market account Accounts Receivable Allowance for uncollectible accounts Inventory Prepaids rent - current Land Building Equipment Accumulated Depreciation Debt set up costs, net Accounts payable Accrued payroll and benefits Accrued expenses Note payable 2015 Common stock 1,000 shares, par $1.00 Additional paid in capital Retained earnings(loss) Total Debit 1,000 4,000 15,000 Credit 2,000 8,000 5,000 50,000 85,000 48,000 15,000 5,000 12,000 3,000 2,000 100,000 1,000 74,000 12,000 221,000 221,000 - qattachments_f9cca7356712ec9a616868d75c4ffa4c6ad94c74.xlsx 12/15/2012 01:52:40 Schedule 2A New Castle Coffee Acquisition Support Appraisal Results The appraisal of the fixed assets resulted in the following fair market values: Land Building Equipment Fixed Assets Fair Market Value 60,000 92,000 45,000 197,000 Due Diligence Review As part of the due diligence process, it was determined that New Castle Coffee was not accruing for income taxes. The following balances were indicated. Income tax payable Deferred tax liability (long-term) 2,500 3,800 qattachments_f9cca7356712ec9a616868d75c4ffa4c6ad94c74.xlsx 12/15/2012 01:52:40 Schedule 3 Trial Balance of New Castle Coffee as of 03/31/12 Accounts WTC Checking WTC money market account Accounts Receivable Allowance for uncollectible accounts Inventory Prepaids rent - current Land Building Equipment Construction in progress Accumulated Depreciation Debt set up costs, net Accounts payable Accrued payroll and benefits Accrued expenses Note payable - Long term Advance payable Common stock 1,000 shares, par $1.00 Additional paid in capital Retained earnings(loss) - beginning Retained earnings(loss) - current year Sales - coffee Sales - beans Sales - other Allowance for returns - beans Allowance for returns - other Cost of goods sold - coffee Cost of goods sold - beans Cost of goods sold - other Selling expenses Professional fees Depreciation - Buildings (30 years) Depreciation - Equipment (10 years) Bad debt expense Administrative salaries Other SG&A expenses Interest income - money market Interest expense Amortization of debt set up Income tax provision Total Debit 1,500 3,000 21,000 Credit 2,875 13,765 3,750 50,000 85,000 48,000 16,000 16,281 4,687 12,800 6,000 5,673 100,000 8,000 1,000 74,000 12,000 65,000 25,000 8,000 1,000 400 39,000 10,000 3,600 6,000 4,800 31 1,250 600 12,000 4,000 15 2,000 313 4,948 336,644 336,644 - qattachments_f9cca7356712ec9a616868d75c4ffa4c6ad94c74.xlsx 12/15/2012 01:52:40 Schedule 4 Trial Balance of Java the Hut as of 12/31/11 Accounts DNB Checking T. Rowe money market account Accounts Receivable Allowance for uncollectible accounts Inventory Deferred tax asset Land Building Equipment Construction in progress Accumulated Depreciation Debt set up costs, net Accounts payable Accrued payroll and benefits Accrued expenses Note payable - Long term Revolving credit loan Deferred tax liability (long term) Common stock 10,000 shares, par $10.00 Additional paid in capital Retained earnings(loss) Total Debit 800 18,600 46,800 Credit 936 51,250 3,000 185,000 155,000 98,000 4,800 54,275 12,000 47,250 13,200 8,900 175,000 27,749 4,440 100,000 125,000 18,500 575,250 575,250 - qattachments_f9cca7356712ec9a616868d75c4ffa4c6ad94c74.xlsx 12/15/2012 01:52:40 Schedule 5 Trial Balance of Java the Hut as of 03/31/12 Accounts DNB Checking T. Rowe money market account Accounts Receivable Allowance for uncollectible accounts Inventory Deferred tax asset Land Building Equipment Construction in progress Accumulated Depreciation Debt set up costs, net Advance receivableOther assets - holding Accounts payable Accrued payroll and benefits Accrued expenses Note payable - Long term Revolving credit loan (committed to 2011) Deferred tax liability (long term) Common stock 10,000 shares, par $10.00 Additional paid in capital Retained earnings(loss) - beginning Retained earnings(loss) - current year Sales - coffee Sales - beans Sales - other Allowance for returns - beans Allowance for returns - other Cost of goods sold - coffee Cost of goods sold - beans Cost of goods sold - other Selling expenses Professional fees Depreciation - Buildings (30 years) Depreciation - Equipment (10 years) Bad debt expense Administrative salaries Other SG&A expenses Interest income - money market Interest expense - note due 2005 Interest expense - revolving credit Amortization of debt set up Income tax provision Debit 1,500 8,000 48,000 Total 965,565 Credit 960 54,024 3,197 185,000 155,000 98,000 25,200 58,017 11,000 8,000 185,000 48,200 11,000 13,196 175,000 223,852 4,900 100,000 125,000 18,500 105,000 65,400 16,500 3,500 650 68,250 29,430 7,425 14,800 8,017 1,292 2,450 200 26,500 9,396 40 3,500 5,037 1,000 2,197 qattachments_f9cca7356712ec9a616868d75c4ffa4c6ad94c74.xlsx 12/15/2012 01:52:40 965,565