Purchase Solution

Computation of Cash Flow: Sources and Uses of Cash

Not what you're looking for?

Ask Custom Question

From the financial data from three competitors in the same industry, the attached formatted MS Excel spreadsheet performs a comparative analysis of the companies.

Attachments
Purchase this Solution
Solution Summary

This posting contains a formatted MS Excel spreadsheet that contains an example on the calculation of a company's cash flow.

Solution Preview

For your convenience, I have attached a formatted MS Excel file containing the information below.

Financial data from three competitors in the same industry follow.
1. Which of the three competitors is in the strongest position as shown by its statement of cash flows?
2. Analyze and discuss the strength of Z-Best's cash flow on total assets ratio to that of Lopez.

Note: Since the column headers were missing from your original post, I named the columns A, B, and C for identification purposes.

Company A Company B Company C

Cash provided (used) by operating activities 80,000 70,000 (34,000)
Proceeds from sale of operating assets 36,000
Purchase of operating assets (38,000) (35,000)
Cash provided (used) by financing activities
Proceeds from issuance of debt 33,000
Repayment of debt (700)
Net increase (decrease) in cash 35,000 35,000 35,000
Average total assets 800,000 650,000 400,000

Financial
Condition
1) BEST Company A has a postive cash flow from its operating activities. It used some of its
available ...

Purchase this Solution
Free BrainMass Quizzes
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

View More Free Quizzes
Related BrainMass Solutions

  • Statement of Cash Flow and Statement of Sources and Uses

    105970 Statement of Cash Flow and Statement of Sources and Uses I need to create a statement of cash flow for the year ending 2004 and sources and uses of funds statement for the year ending 2004. See attached file for the dataset.

  • Project's cash flows

    Computation of Depreciation: Depreciation = Cost of the Asset / Life of the Asset = 90000/5 18000 Its Operating Cash flow from year 1 to year 5 is: EBDT 20000 Less Depreciation 18000

  • Sources and Uses of Cash

    541121 Sources and Uses of Cash What are some examples of sources of cash and uses of cash that arise from assets and liabilities. Sources of cash A source of cash is one that increases cash flow in the period.

  • Advanced Accounting: Journal Entries

    Remember that GCA is used to account for purchases of capital asses and the sale of these assets which are recorded as other financing sources while GLTL is used to account for the issuance of debt which is recorded as other financing sources and the

  • Free Cash Flow, Ratio Analysis, and Cash Referencing

    Therefore it is not always possible to have standard ratio comparisons and there is always some amount of error. 3. The balance sheet can be analyzed in terms of sources and uses of cash. Liabilities and net worth are sources of cash.

  • Computation of Cash Flow of Corporate Earnings

    216485 Computation of Cash Flow of Corporate Earnings Assume a corporation has earnings before depreciation and taxes of $90,000, depreciation of $40,000, and that it is in a 30 percent tax bracket. Compute its cash flow using the format below.

  • Operations Cash Flow

    The cash flow statement shows the uses and sources of cash during a financial period. Operating cash flow should be positive. A company isn't profitable if it doesn't report strong positive cash flow. How much is enough?

  • Dell cash provided by operating activities, free cash flow

    cash flows, computation of free cash flows, and discussion of how free cash flow was used using the 2005, 2004 and 2003 years for Dell Inc.

  • Dynamic Mattress Statement of cash flows

    For your review, I have attached a formatted MS Excel spreadsheet, which lists the various sources and uses of cash in Dynamic Mattress's cash flow statement. The solution provides an income statement of 2008.

  • How are Uses and Sources of Funds Calculated?

    568400 How are Uses and Sources of Funds Calculated? How are "uses and sources" of funds are calculated? The sources and uses of funds both flow through from other places.

View More Related Solutions