Trial Balance (Balance Sheet Accounts Only) Cash and Cash


Question Description:

35

Hello again! I need your help for my week 5 assignment. I put the minimum for the price and will wait for your suggestion. Also, here is a note posted by my professor about the assignment: “Just a reminder that all the information needed to do the indirect method cash flow statement is at the bottom of the data sheet (excel) provided. That means no computations are required to do the direct method cash flow statement. Only that you set the cash flow statement in good form and properly categorize the numbers provided in the excel sheet. Again this is the direct method.” I look forward to hearing from you. Thank you! Resource: ABC Company History and ABC Financial Data Excel® spreadsheet and Adjusted Balance Sheet and Income Statement from the Week 4 individual assignment Prepare the Direct and Indirect Statements of Cash Flow using the Adjusted Balance Sheet and Income Statement from the Week 4 Individual Assignment. Submit the Direct and Indirect Cash Flow Statements in a Microsoft® Excel® spreadsheet. ABC Financial Data.xls Trial Balance (Balance Sheet Accounts Only) Cash and Cash Equivalents Receivables, net Inventory Inventory Correction Other Current Assets Property and Equipment, at cost Accumulated Depreciation and Amortization Accumulation Depreciation Correction Goodwill Deferred Tax Asset Accounts Payable Accrued Salaries and Related Expenses Sales Taxes Payable Deferred Revenue Income Taxes Payable Current Installments of Long-Term Debt Other Accrued Expenses Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Tax Liability Paid-In Capital Retained Earnings Accumulated Other Comprehensive Income Treasury Stock Common stock Total 2013 1,929.00 1,398.00 11,057.05 1,285.00 895.00 39,064.00 (15,715.95) (1,505.00) 1,289.00 690.00 (5,797.00) (1,428.00) (396.00) (1,337.00) (12.00) (33.00) (1,746.00) (14,691.00) (2,042.00) (514.00) (8,402.00) (23,048.00) (46.00) 19,194.00 (88.00) 0.10 2012 2,494.00 1,413.00 11,512.00 Legend: Desiginates Change Required from JE in Week 2 I am showing this account but it can and should be added to the above account Inventory 900.00 38,491.00 (17,473.00) I am showing this account but it can and should be added to the above account AD&A 1,046.00 473.00 (5,192.00) (1,200.00) (472.00) (1,262.00) 107.00 783.00 (1,794.00) (9,475.00) (2,029.00) (545.00) (7,948.00) (20,038.00) (397.00) 10,694.00 (88.00) – .10 due to rounding of 32 depreciation expense Data Needed For Preparation of Week 2 Income Statement Net Sales Cost of Sales Selling, General and Administrative Depreciation and Amortization Interest and Investment Income Interest Expense Provision for Income Taxes 78,812.00 51,421.80 16,597.00 1,626.95 (12.00) 711.00 (3,082.00) 74,754.00 48,912.00 16,508.00 1,568.00 (87.00) 632.00 (2,686.00) Additional Data needed for week 3-6 Foreign Currency Translation Adjustments Cash Flow Hedges, net of tax Other Comprehensive Income Dividends Tax rate Shares Issued Under Employee Stock Plans Tax Effect of Stock-Based Compensation Restricted Stock Repurchases of Common Stock (12.00) (10.00) (2,243.00) 40% 103.00 123.00 228.00 (8,500.00) 100.00 5.00 (1.00) (1,743.00) 40% 678.00 82.00 222.00 (4,000.00) 4,523.00 6,739.00 (1,332.00) (987.00) (1,028.00) (275.00) (12.00) (1,389.00) (206.00) 88.00 5,222.00 (1,289.00) (8,546.00) 241.00 (2,243.00) (37.00) 4,356.00 6,038.00 (1,276.00) (905.00) (1,121.00) (204.00) (10.00) (1,312.00) (170.00) 50.00 (32.00) (3,984.00) 784.00 (1,743.00) (59.00) Additional Info: Cash Sales Collections on Receivables Purchases Wages Payments to Suppliers Tax Payments Interest payments Capital Expenditures Payments for Businesses Acquired Proceeds from Sales of Property and Equipment Proceeds from Long-Term Borrowings Repayments of Long-Term Debt Repurchases of Common Stock Proceeds from Sales of Common Stock Cash Dividends Paid to Stockholders Other Financing Activities Curtis: The data below is what you need for the W

Answer

35