Question
Using the AYK2_Data.xlsx data file, complete the cash flow statement for Gears, using Excel. Be sure to create formulas so the company can simply input numbers in the future to determine cash flow.


57% .. AT&T < Back 4:04 PM AYK2_Data_Version_1.xlsx H AYK 2 Cash Flow Gears Cash Flow Statement January Cash on Hand (beginni
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Gears cash flow statement January Cash on Hand ( beginning of month) | 18,456 CASH RECEVED Cash Sales Credit Sales Accounts T

File Home Insert Page Layout Formulas Data Review V iew Developer Power Pivot Sign in fx 2 62 A DO Defi Calculate Now Tell me

Add a comment
Know the answer?
Add Answer to:
Using the AYK2_Data.xlsx data file, complete the cash flow statement for Gears, using Excel. Be sure...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Gears Cash Flow Statement January Cash on Hand (beginning of month)                 67,173.13 CASH RECEIVED Cash...

    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...

    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...

    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...

  • Accounting Question asking for Income Sheet, Equity Statement, Balance sheet, and Cash Flow statement

    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...

    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...

    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...

    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...

    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...

    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...

    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 $...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT