Purchase Solution

Calculating the Cash Flows & Abbreviated Financial Statements

Not what you're looking for?

Ask Custom Question

1. (Answer using Excel): Calculating Cash Flows, Consider the following abbreviated financial statements for:

WESTON ENTERPRISES
2011 and 2012 Partial Balance Sheets
ASSETS
2011
Current assets $936
Net fixed assets $4,176

2012
Current assets $1,015
Net fixed assets $4,896

LIABILITIES AND OWNERS' EQUITY
2011
Current liabilities $382
Long-term debt $2,160

2012
Current liabilities $416
Long-term debt $2,477

WESTON ENTERPRISES
2012 Income Statement
Sales = $12,380
Costs = 5,776
Deprec = 1,150
Interest paid= 314

Answer using Excel:
a. What is owners' equity for 2011 and 2012
b. What is the change in net working capital for 2012
c. In 2012, Weston Enterprises purchased $2,160 in new fixed assets. How much in fixed assets did Weston Enterprises sell? What is the cash flow from assets for the year? (Tax rate is 40 percent)
d. During 2012,Weston Enterprises raised $432 in new long-term debt. How much long-term debt must Weston Enterprises have paid off during the year? What is the cash flow to creditors?

2. (Answer in Excel): Financial Statements, Draw up an Income Statement and Balance Sheet for Ingersoll, Inc. for 2011 and 2012 using the following information.

INGERSOL, INC. -----------------------2011_______________2012

Sales ______________________$7,835______________$8,409
Depreciation_________________ 1,125_______________ 1,126
Cost of goods sold_____________ 2,696______________ 3,060
Other expenses_________________639________________ 534
Interest _______________________ 525 ________________603
Cash________________________ 4,109 ______________ 5,203
Accounts receivable_____________5,439 ______________ 6,127
Short-term notes payable__________ 794 _______________ 746
Long-term debt________________ 13,460 _____________ 16,050
Net fixed assets________________34,455 _____________35,277
Accounts payable________________4,316______________4,185
Inventory_______________________9,670______________9,938
Dividents_________________________956_____________1,051

Purchase this Solution
Solution Summary

The expert calculates the cash flows and abbreviated financial statements.

Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

View More Free Quizzes
Related BrainMass Solutions

  • Impact of Discounting Future Cash Flows for Impairment

    In the case of impairment of assets, if the value in use is calculated by not discounting the cash flows to their present value, the asset will be overstated in the financial statements.

  • Accounting: Working capital management and Ratios

    Work out the statement of cash flows for 2008. Group these items into sources of cash and uses of cash. 8) The financial statements of Eagle Sport Supply are shown in Table 19.17 . For simplicity, Costs include interest.

  • Use of Cash Flow Information and Present Value

    The estimated future cash flows can be used for measuring liabilities by calculating the assets required to settle the liability with the company or to hand it over to another entity.

  • Direct and indirect methods of cash flow from operations

    Cash flow statement is one of the key financial statements. Financial Statements is designed primarily to assist investors and creditors in deciding where to place their scarce investment resources.

  • Financial Statement Analysis: Intel Annual Report

    Prepare a summary analysis of the Statements of Cash Flows for all three years. d. Analyze the Consolidated Statements of Cash Flows for Intel for 2010, 2009, and 2008. See attached for financial analysis a.

  • Dell Co. Financial Statements

    90806 Financial Statements C. Financial Statements 1) Income Statement: Is the format more like a single-step or multi-step format?

  • A company is considering a proposed new plant that would

    If interest were deducted when estimating cash flows, this would, in effect, 'double count' it. 2. Since depreciation is a non-cash expense, the firm does not need to deal with depreciation when calculating the operating cash flows. 3.

  • The Financial Statements

    629825 The Financial Statements Describe how the financial statements (the income statement, statement of retained earnings, balance sheet and statement of cash flows) are interrelated. Provide at least two examples.

  • Managerial accounting

    The solution explains P13-1A - Classification of transaction in the statement of cash flows P13-2A - Cash flow effects of changes in equity accounts of Gore Corp BYP13-1 - Financial reporting problem relating to Pepsico

View More Related Solutions