Need Help Please! Last minute assignment
Cash Flows Statments
Part I: You are to complete the attached Cash Flow Worksheet. Review the comprehensive cash flow spreadsheet example in the textbook before completing this assignment. You are to complete the same type of analysis here. *Please note that the Problem Data can be found on the 3rd tab. *The Cash Flow Worksheet where you will be completing this assignment is on the 2nd tab. To complete a Cash Flow Statement you must have comparative Balance sheets, the Income Statement, and some additional information to assist in the analysis. The Income Statement and additional information are on the Problem Data tab. The Balance Sheet amounts are on the Cash Flow Worksheet. To complete the worksheet: * Enter analysis entries in Column D and F. *Label each analysis entry with a letter (a, b, c, d, ...). Put the letter labeling each analysis entry in columns C and E. *(You are to enter formulas in the 12/31/14 balance column (Column G). For the formula you must take the beginning 12/31/13 balance and add or subtract the analysis entries in columns D and F. (See the textbook example put into a demonstration excel spreadsheet at eLearn. This will help you understand how to set up the excel spreadsheet.) The correct 12/31/14 balance is shown in the Column labeled Check Figure (Column H). After entering all of the analysis entries (in Columns D and F) the balance in the 12/31/14 Balance column (where you entered the formulas) should equal the number in Check Figure column if the entries in the analysis columns are correct. If the 12/31/14 Balance column does not equal the Check Figure, either an analysis entry is missing or the amount is incorrect. Sum each of the analysis columns. The balances should agree. Part II: Complete the written analysis. Cash Accounts Receivable Merchandise Inventory Prepaid expenses Equipment Buildings Trademark 4,000 97,000 54,000 6,000 43,000 121,000 83,000 408,000 2,500 105,000 91,000 4,000 94,000 171,000 79,000 546,500 23.500 Credit Accounts Accumulated Depreciation-Mach Accumulated Depreciation - Bldg Accounts Payable Income Taxes Payable Wages Payable Short-term Notes Payable-to bank Long-Term Note Payable Common Stock, no par Retained Earnings 18,000 10,000 65,000 15,700 9,000 12,000 82,200 21,800 4,000 23,500 75,000 170,000 134,500 546,500 125,000 120,000 45,300 408,000 Operating Activities Operating Activities Investing Activities Financing Activities Income Statement Yr ended 12/31/14 Sales 570,200 Cost of Goods Sold (302,000) Gross Profit 268,200 Operating Expenses (94,000) Income from Operations 174,200 Interest Expense (20,500) Loss on Sale of Equipment (4,000) Income before Income Taxes 149,700 Income Tax Expense (40,500) Net Income $ 109,200 Additional information: 1. Dividends in the amount of $20,000 were declared and paid during 2014. 2. Depreciation expense and amortization expense are included in operating expenses. 3. Equipment with a cost of $25,000 and was 20% depreciated was sold during 2014. 4. A Building was purchased and paid for by issuing $50,000 of Common Stock. ** When analyzing the changes in balance sheet accounts, if there is no additional information, always assume the obvious change
