Question

In: Accounting

Question 3: Please create a statement of cash flow with indirect method- Please provide answers to...

Question 3: Please create a statement of cash flow with indirect method- Please provide answers to each category and a one paragraph analysis of the cash flow using the indirect method.

Statement of Cash Flow with Indirect method

2011

2010

Difference

Operating

Investing

Financing

ASSETS:

Current Assets

Cash and equivalents

$ 2,291.1

$ 2,133.9

Short-term investments

   1,164.2

      642.2

Account receivable

   2,883.9

   2,795.3

Inventory

   2,357.0

   2,438.4

Prepaid expenses and other assets

      765.6

      602.3

Deferred income taxes, net

     272.4

      227.2

Total Current Assets

$ 9,734.0

$ 8,839.3

Property and equipment, gross

   4,255.7

   4,103.0

Accumulated depreciation

(2,221.9)

(2,298.0)

Property and equipment, net

$ 1,957.7

$ 1,891.1

Identifiable intangible assets

      467.4

      743.1

Good will

      193.5

      448.8

Deferred income taxes and other assets

      897.0

      520.4

Total Assets

$13,249.6

$12,442.7

Liabilities and Stockholders’ Equity

Current Liability :

Current portion of long-term debt

$       32.0

$          6.3

Note Payable

        342.9

       177.7

Account Payable

     1,031.9

    1,287.6

Accrued liabilities

     1,783.9

    1,761.9

Income taxes payable

          86.3

          88.0

Total Current Liabilities

$   3,277.0

$ 3,321.5

Long term debt

        437.2

       441.1

Deferred taxes and other long-term liabilities

        842.0

       854.5

Total Liabilities

$ 4,556.2

$ 4,617.1

Redeemable preferred stock

$         0.3

$         0.3

Common Shareholders’ Equity

Common stock

           2.8

           2.8

Capital in excess of stated value

$ 2,781.4

$ 2,497.8

Retained earnings

    5,451.4

   5,073.3

Accumulated other comprehensive income

       367.5

      251.4

Total Common Shareholders’ Equity

$ 8,693.1

$ 7,825.3

Total Liabilities and Shareholders’ Equity

$13,249.6

$12,442.7

Solutions

Expert Solution

2011 2010 Difference Operating Investing Financing
ASSETS:
  Current Assets
Cash and equivalents 2,291.10 2,133.90 157.2 0 0 0
Short-term investments 1164.2 642.2 522 -522
Account receivable 2,883.90 2,795.30 88.6 -88.6
Inventory 2,357.00 2,438.40 -81.4 81.4
Prepaid expenses and other assets 765.6 602.3 163.3 -163.3
Deferred income taxes, net 272.4 227.2 45.2 -45.2
Total Current Assets 9,734.00 8,839.30 894.7
Property and equipment, gross 4,255.70 4,103.00 152.7 -152.7
Accumulated depreciation -2,221.90 -2,298.00 76.1 76.1
Property and equipment, net 1,957.70 1,891.10 66.6
Identifiable intangible assets 467.4 743.1 -275.7 275.7
Good will 193.5 448.8 -255.3 255.3
Deferred income taxes and other assets 897 520.4 376.6 -376.6
Total Assets 13,249.60 12,442.70 806.9
0
Liabilities and Stockholders’ Equity 0
Current Liability : 0
Current portion of long-term debt 32 6.3 25.7 25.7
Note Payable 342.9 177.7 165.2 165.2
Account Payable 1,031.90 1,287.60 -255.7 -255.7
Accrued liabilities 1,783.90 1,761.90 22 22
Income taxes payable 86.3 88 -1.7 -1.7
Total Current Liabilities 3,277.00 3,321.50 -44.5
Long term debt 437.2 441.1 -3.9 -3.9
Deferred taxes and other long-term liabilities 842 854.5 -12.5 -12.5
Total Liabilities 4,556.20 4,617.10 -60.9
Redeemable preferred stock 0.3 0.3 0
Common Shareholders’ Equity 0
Common stock 2.8 2.8 0 0 0 0
Capital in excess of stated value 2,781.40 2,497.80 283.6
Retained earnings 5,451.40 5,073.30 378.1 378.1
Accumulated other comprehensive income 367.5 251.4 116.1 0 0 0
Total Common Shareholders’ Equity 8,693.10 7,825.30 867.8
Total Liabilities and Shareholders’ Equity 13,249.60 12,442.70 806.9

Related Solutions

Create the statement of cash-flow with indirect method Interpret the result of the statement of cash...
Create the statement of cash-flow with indirect method Interpret the result of the statement of cash flow with percentage Instruction: [1] Please use the balance sheet as follows to classify each activity (operating, investing, and financing) from the column of different. [2] please create a new statement of cash-flow from your classification on balance sheet. [3] The statement of cash flow will be provided to measure the company’s cash flow situation. Also, you need to interpret the result of your...
Indirect method vs. Direct method for Cash Flow Statement The indirect method considers the opening and...
Indirect method vs. Direct method for Cash Flow Statement The indirect method considers the opening and closing balance of ledger accounts in determining the movements and computing cash flows. If there are wrong postings in the ledger account the cash flows determined are not accurate since only opening and closing balances are considered. In direct method since each line item of ledger is classified into cash and non cash it leads to accurate computation of cash flows. The indirect method...
Create a cash flow statement for Whatchamacallit Corp. using the indirect method from the following information:...
Create a cash flow statement for Whatchamacallit Corp. using the indirect method from the following information:     2018                  2019 Accounts Payable                                    $123,000               $47,000              Accounts Receivable                               $450,000             $330,000 Bonds Payable                                          $80,000             $100,000 Buildings                                                  $672,000            $447,000 Common Stock                                        $250,000            $310,000 Inventory                                                  $325,000           $485,000 Land                                                        $428,000            $553,000        Prepaid Insurance                                    $72,000              $63,000 Unearned Revenue                                $210,000              $65,000 Beginning Cash = $82,000 Depreciation Expense = $56,000 Net Income = $260,000
Requirements: Create Baylor's 2023 Cash Flow Statement using the INDIRECT METHOD Baylor Company's 2023 income statement...
Requirements: Create Baylor's 2023 Cash Flow Statement using the INDIRECT METHOD Baylor Company's 2023 income statement and comparative balance sheets at December 31, 2022 and 2023 are shown below. Baylor Income Statement 2023 Sales        750,000 Dividend Income           15,000 Gain on Sale of Investments           10,000 Total Revenue        775,000 Cost of Goods Sold        440,000 Wages and Other Operating Expenses        130,000 Depreciation Expense           38,000 Patent Amortization Expense             8,000 Interest Expense           12,000 Income Tax Expense...
Prepare a cash flow statement using the indirect method Lomax Income Statement Sales . . ....
Prepare a cash flow statement using the indirect method Lomax Income Statement Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . $2,000,000 Cost of goods sold . . . . . . . . . . . . . . . . . 1,300,000 Gross margin . . . . . . . . . . . . . ....
Assuming a cash flow statement is prepared using the indirect method, indicate the reporting of the...
Assuming a cash flow statement is prepared using the indirect method, indicate the reporting of the transactions and events listed below by major categories on the statement. Use the following code letters to indicate the appropriate category under which the item would appear on the cash flow statement. Codes: A Cash flows from operating activities (Add to profit) D Cash flows from operating activities (Deduct from profit) IA Cash flows from investing activities FA Cash flows from financing activities Category...
What is a cash flow statement and a cash flow analysis? Please provide a visual example.
What is a cash flow statement and a cash flow analysis? Please provide a visual example.
C. Prepare a statement of cash flow on both the direct and indirect method 2017 2016...
C. Prepare a statement of cash flow on both the direct and indirect method 2017 2016 Change Assets: Cash 215,000 70,000 145,000 Accounts receivable, net 87,000 65,000 22,000 Inventory 54,000 60,000 -6,000 Property, plant & equipment 750,000 600,000 150,000 Accumulated depreciation -110,000 -60,000 -50,000 Total Assets 996,000 735,000 261,000 Liabilities & Equity Accounts payable 44,000 40,000 4,000 Accrued liabilities 41,000 40,000 1,000 Common stock 460,000 460,000 Retained earnings 451,000 195,000 256,000 Total liabilities and equity 996,000 735,000 261,000 Sales 1,450,000...
B. Prepare a statement of cash flow on both the direct and indirect method 2017 2016...
B. Prepare a statement of cash flow on both the direct and indirect method 2017 2016 Assets: Cash             245,000                 70,000 Accounts receivable, net               87,000                 65,000 Inventory               54,000                 60,000 Property, plant & equipment             650,000               600,000 Accumulated depreciation             (90,000)               (60,000) Total Assets             946,000               735,000 Liabilities & Equity Accounts payable               44,000                 40,000 Accrued liabilities               41,000                 40,000 Common stock             460,000               460,000 Retained earnings             401,000              ...
list the steps need to prepare the Cash Flow Statement using the Indirect Method. Which step...
list the steps need to prepare the Cash Flow Statement using the Indirect Method. Which step of the process do you think is the most important? Why?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT