File Homie Insert Page Layout Search Formulas Data Review X View Help Calibri 11 Paste Wrap Text B I U General E E Merge & Center Clipboard $ -% Font Conditional Format as Cell Formatting Table Styles i 5 Alignment D74 ly Y Number Styles A B CI D E H 48200 48200 12800 58 Investment in Newark Coffee 59 Goodwill 60 Differential 61 Other assets - holding 62 Total Assets 6B 64 Accounts payable 65 Accrued payroll and benefits 66 Accrued expenses 67 Income Tax Payable 68 Note payable 69 Advance payable 70 Revolving credit loan - committed to 13/31/15 71 Deferred tax liability (long term) 72 | Common Stock 73 Additional paid in capital 74 Retained earnings 75 Total Liabilities & Stockholders Equity 175000 100000 100000 1000 18500 5700 76 77 78 79 on Schlasan Sch 2A Sch3 Sch 5 Scho Worksheet Ready o Type here to search ED c 3 Data Review View Help Calibri 11 Paste Wrap Text BIU General A Merge & Center Clipboard $ %. Font Conditional Format as Cell Formatting Table Styles - D. FC Alignment D74 Number x Styles A 38 Balance Sheet B D E 3/1/2007 39 3/1/2007 G H Java Hut New Castle Coffee Adjusting Entries Adjusted T/B Consolidated Eliminating Entries 1500 Balance Sheet 1500 8000 3000 48000 21000 54024 40 Item 41 Checking 42 Money market account 43 Accounts Receivable 44 Allowance for uncollectible accounts 45 Notes Receivable 46 Inventory 47 Prepaids 48 Deferred tax asset 49 Advance receivable 50 Land 51 Building 52 Equipment 53 Construction in progress 54 Accumulated Depreciation 55 Debt set up costs, net 56 Advance Receivable 57 Investment in New Castle Coffee 58 Investment in Newark Coffee 59 Goodwill on nittornetist Sch Sch 2 Sch 2 185000 50000 155000 85000 98000 48000 -58017 - 16281 Sch 3 Sch 5 Sch 6 Worksheet Ready EL Type here to search hin AutoSave On Copy of Accounting 401 Proj... - Last Modified: Sun at 5:29 PM , Us Review View Data Help File Home Insert Formulas Page Layout X Custon Calibri v 11 *Wrap Text ' Paste BI U v A ++ Merge & Center Clipboard Font Alignment C5 fa A B D E F 30 Allowance for Returns - Beans 31 Allowance for Returns - Other 32 Cost of Goods Sold - Coffee 33 Cost of Goods Sold - Beans 34 Cost of Goods Sold - Other 35 Selling Expenses 36 Professional Fees 37 Depreciation - Building (30 years) 38 Depreciation - Equipment (10 years) 39 Bad Debt Expense 40 Administrative Salaries 41 Other SG&A Expenses 42 Interest Income - Money Market 43 Interest Expense - Notes Payable 44 Interest Expense - Amortization of Debt Set-Up 45 Income Tax Provision 46 $ 1,000 $ 400 $ 39,000 $ 10,000 $ 3,600 $ 6,000 $ 4,800 $ 31 $ 1,250 $ 600 $ 12,000 $ 4,000 S 15 $ 2,000 S 313 $ 4,948 47 Totals $336,644 $336,644 48 49 50 51 Sch Sch 2 Sch 2A Sch 3 Ready Sch 5 Sch 6 Worksheet Type here to search th AutoSave On Fas Copy of Accounting 401 Proj... - Last Modified: Sun at File Home Insert Page Layout Formulas Data Review View Hel Calibri v 11 5 Wrap Text Paste B I U v , Merge & Center Clipboard Font Alignment C5 fr A B C D E $ 1,000 $ 74,000 $ 5,700 $ 65,000 $ 25,000 $ 8,000 24 Common Stock (1,000 shares 0/s, $1 par) 25 Additional Paid-In Capital 26 Retained Earnings (Loss) - Beginning 27 Sales - Coffee 28 Sales - Beans 29 Sales - Other 30 Allowance for Returns - Beans 31 Allowance for Returns - Other 32 | Cost of Goods Sold - Coffee 33 | Cost of Goods Sold - Beans 34 Cost of Goods Sold - Other 35 Selling Expenses 36 Professional Fees 57 Depreciation - Building (30 years) 38 Depreciation - Equipment (10 years) 39 Bad Debt Expense 40 Administrative Salaries 41 Other SG&A Expenses 42 Interest Income - Money Market 43 Interest Expense - Notes Payable 44 Interest Expense - Amortization of Debt Set-Up 45 Income Tax Provision $ 1,000 S 400 $ 39,000 $ 10,000 $3,600 $ 6,000 $ 4,800 S 31 $ 1,250 $ 600 $ 12,000 $ 4,000 $ 15 2,000 to in un 313 4,948 Sch1 Sch 2 Sch 2A Sch 3 Ready Sch 5 Sch 6 Worksheet Type here to search o AutoSave On ES