Using the AYK2_Data.xlsx data file, complete the cash flow statement for Gears, using Excel. Be sure...
Gears Cash Flow Statement January Cash on Hand (beginning of month) 67,173.13 CASH RECEIVED Cash Sales 10,288.28 Credit Sales Accounts 53,064.30 TOTAL CASH RECEIVED CASH PAID OUT Inventory 17,340.04 Payroll expenses 10,928.19 Supplies (office & oper.) 3,276.61 Repairs & maintenance 2,149.60 Advertising 566.82 Car, delivery & travel 332.61 Accounting & legal 88.60 Rent 3,063.66 Telephone 161.95 Utilities 369.35 Insurance 1,094.69 Taxes (real estate, etc.) 356.13...
prepare a cash flow statement
I want to compare my answered to my cash flow
statement very beginning chapters of accounting a cash flow
statement
Required information Problem 1-7A Analyzing transactions and preparing financial statements LO P1, P2, [The following information applies to the questions displayed below.] Gabi Gram started The Gram Co., a new business that began operations on May 1. The Gram Co, completed transactions during its first month of operations. May 1 G. Gram invested $42,000 cash...
Format of a cash flow statement-direct method following information to complete the statement of cash flows for Olympia, Inc. Place parentheses around those dollar amounts representing cash outlays. Purchases of marketable securities Proceeds from sales of marketable securities Interest and dividends received Interest paid Taxes paid Dividends paid Proceeds from short-term borrowing Payments to settle short-term debts (principal repaid) Cash received from customers Cash paid to suppliers and employees Proceeds from issuing capital stock Purchases of plant assets Proceeds from...
Gabi Gram started The Gram Co., a new business that began operations on May 1. The Gram Co. completed the following transactions during its first month of operations. May1G. Gram invested $45,000 cash in the company.1The company rented a furnished office and paid $2,100 cash for May’s rent.3The company purchased $5,220 of office equipment on credit.5The company paid $760 cash for this month’s cleaning services.8The company provided consulting services for a client and immediately collected $5,300 cash.12The company provided $3,000 of...
Cash Flow Statement: The Diversified Portfolio Corp provides investment advice to customers. A statement for the year ended December 31, 2018 is below condensed income Service Revenue Costs of Goods Sold Gross Profit Depreciation Expense Selling and Admin. Expenses Interest Expense Income before income taxes Income Tax Expense Net Income s 22,250 $ 14,250 1,600 6,250 Depreciation expense for the year was $1,600 The following balance sheet information is also available Cash Accounts Receivable Inventory Prepaid Rent Equipment $ 9,600...
Complete a income statement, balance sheet and cash flow
statement.
8. The following is the ending Balance Sheet for Part- Time Programmers Co. The company provides tem- porary computer and data processing help to orga nizations. It is a small, new organization. Part-Time Programmers Oct. 31, 20xx $1,800 2,000 500 14,200 $18,500 $4,500 Accounts Payable Cash Gov. Securities Supplies Equipment Total Assets 5,000 Wages Payable 1,000 Tax Payable 8,000 Net Worth $18,500Total Liabilities +N.W. a. Receive $800 from customer for...
Using the information provided, complete the cash flow statement
using the indirect method. MAKE USE OF EXCEL CAPABILITIES BY USING
AS MANY FORMULAS AND FUNCTIONS AS POSSIBLE.
Reference or given data section. 12/31/2015 Change STATEMENT OF CASH FLOWS (INDIRECT METHOD) The Group, Inc. Consolidated Balance Sheets (in thousands) 3/31/2016 ASSETS Current Assets: Cash and Cash Equivalents $92,069 Accounts Receivables, Net 55,947 Inventories 50,784 Prepaid Expenses 12,112 Total Current Assets 210,912 Equipment 145,444 Less: Accumulated Depreciation -50,515 Total Assets $305,841 $72,634...
Question 12-4A
Use the cash flow from operating activities using the indirect method. E2-44. Statement of Cash Flows (Indirect Method) Use the following information regarding the Surpa Corporation to (a) prepare a statement of cash flows using the indirect method and (b) compute Surpa's operating-cash-flow-to-current-liabilities ratio. LO2, Accounts payable increase. Accounts receivable increase, Accrued liabilities decrease Amortization expense. Cash balance, January 1 Cash balance, December 31 Cash paid as dividends Cash paid to purchase land Cash paid to retire bonds...
A cash-flow budget uses the same format as a cash-flow
statement. It is prepared on a monthly basis and it reflects
budgeted income and expenses.In addition to the cash-flow
statement, Deon and May made a list of budget assumptions:
. Deon's income will increase by 5%, effective January 1 . His bonus is generally 10% of his income in the previous year, and he receives it in January. . May's raise will be 3%, effective January 1, Interest and dividend...
Use the balance sheet and income statement on the backside of this page to calculate cash flows for operating, investing, and financing activities. Be sure to indicate if the cash flow is an inflow or outflow. Calculate operating activities using both the direct and indirect method. For the direct method. summarize the cash flows similar to the method used in class For example: Cash received from customers $ Cash paid for inventory $ Net cash flow from operating activities $...