Using the financial statement provided (an Excel spreadsheet with the data is available on Blackboard),. prepare...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the financial statement provided (an Excel spreadsheet with the data is available on Blackboard),. prepare a complete Statement of Cash Flows that shows both the direct method and the indirect method for summarizing cash flow from operating activities. Note to complete the assignment you will need to calculate items such as dividends paid (Retained Earnings & AOClar9 - Net income2019 - Retained Earnings & AOCI2018) and capital expenditures (Net PP&E2018 – Book Value of PP&E Sold019 - Depreciation Expense2019 - Net PP&E2019). Please submit your work via the assignment submission feature in Blackboard. Balance Sheets Income Statement (millions) Cash & equivalents Accounts receivable, net Inventories Other current assets Total current assets Property, plant, & equipment, gross Less: Accumulated depreciation Property, plant, & equipment, net Right-of-use leased assets Other long-term investments Goodwill Other intanqible assets Other noncurrent assets Total assets (millions) Sales 1,100.0 Less: Cost of goods sold Gross profit 2019 $2,577.0 $1,556.0 1,262.0 8,992.0 371.0 13,202.0 45,547.0 44,220.0 Operating profit (EBIT) 19,664.0 25,883.0 2,536.0 137.0 633.0 53.0 635.0 $43.079.0 $41.540.0 2018 2019 $78,112.0 54,864.0 23,248.0 16,163.0 2,357.0 4,728.0 467.0 (18.0) (41.0) 4,202.0 921.0 $3,281.0 9,497.0 366.0 Less: Selling, gen. & admin. expenses 12,519.0 Less: Depr. & amort, expenses 18,687.0 Less: Interest expense 25,533.0 2215.0 10.0 633.0 Other income (expense) Gain/(loss) on sale of assets Earnings before tax Less: Income tax expense Net income 66.0 564.0 Current portion of long-term debt Short-term debt (notes payable) Current operating lease liabilities Accounts payable Other accrued expenses Deferred revenue Other current liabilities Total current liabilities Long-term debt Long-term operating lease liabilities Deferred taxes Other long-term liabilities Total liabilities Common stock and add. paid-in capital Retained earnings Accum. other comp. income (loss) Less: Treasury stock Total equity Total liabilities and equity $94.0 41.0 261.0 9,920.0 1.983.0 1,135.0 1.053.0 14,487.0 10,035.0 2,275.0 1,122.0 3,027.0 30,946.0 29,993.0 6,268.0 11.677.0 (868.0) 4,944.0 12,133.0 $43.079.0 $41.540.0 $1,002.0 63.0 211.0 9,761.0 2,034.0 840.0 1.103.0 15,014.0 9,255.0 2,004.0 972.0 2,748.0 6,085.0 9,845.0 (805.0) 3,578.0 11,547.0 Footnotes During the year, the company received cash of $338.4 when it sold PP&E with a net book value of $379.4, which gave rise to the $41.0 loss that appears on the income statement. • Total depreciation and amortization expenses of $2,357.0 is made up of depreciation expense of $2.344.0 and amortization expense of $13.0. Check figures: cash flow from operations = $6,728.0; cash flow from investments = $(3,183.0); and cash flow from financing = $(2,524.0). Using the financial statement provided (an Excel spreadsheet with the data is available on Blackboard),. prepare a complete Statement of Cash Flows that shows both the direct method and the indirect method for summarizing cash flow from operating activities. Note to complete the assignment you will need to calculate items such as dividends paid (Retained Earnings & AOClar9 - Net income2019 - Retained Earnings & AOCI2018) and capital expenditures (Net PP&E2018 – Book Value of PP&E Sold019 - Depreciation Expense2019 - Net PP&E2019). Please submit your work via the assignment submission feature in Blackboard. Balance Sheets Income Statement (millions) Cash & equivalents Accounts receivable, net Inventories Other current assets Total current assets Property, plant, & equipment, gross Less: Accumulated depreciation Property, plant, & equipment, net Right-of-use leased assets Other long-term investments Goodwill Other intanqible assets Other noncurrent assets Total assets (millions) Sales 1,100.0 Less: Cost of goods sold Gross profit 2019 $2,577.0 $1,556.0 1,262.0 8,992.0 371.0 13,202.0 45,547.0 44,220.0 Operating profit (EBIT) 19,664.0 25,883.0 2,536.0 137.0 633.0 53.0 635.0 $43.079.0 $41.540.0 2018 2019 $78,112.0 54,864.0 23,248.0 16,163.0 2,357.0 4,728.0 467.0 (18.0) (41.0) 4,202.0 921.0 $3,281.0 9,497.0 366.0 Less: Selling, gen. & admin. expenses 12,519.0 Less: Depr. & amort, expenses 18,687.0 Less: Interest expense 25,533.0 2215.0 10.0 633.0 Other income (expense) Gain/(loss) on sale of assets Earnings before tax Less: Income tax expense Net income 66.0 564.0 Current portion of long-term debt Short-term debt (notes payable) Current operating lease liabilities Accounts payable Other accrued expenses Deferred revenue Other current liabilities Total current liabilities Long-term debt Long-term operating lease liabilities Deferred taxes Other long-term liabilities Total liabilities Common stock and add. paid-in capital Retained earnings Accum. other comp. income (loss) Less: Treasury stock Total equity Total liabilities and equity $94.0 41.0 261.0 9,920.0 1.983.0 1,135.0 1.053.0 14,487.0 10,035.0 2,275.0 1,122.0 3,027.0 30,946.0 29,993.0 6,268.0 11.677.0 (868.0) 4,944.0 12,133.0 $43.079.0 $41.540.0 $1,002.0 63.0 211.0 9,761.0 2,034.0 840.0 1.103.0 15,014.0 9,255.0 2,004.0 972.0 2,748.0 6,085.0 9,845.0 (805.0) 3,578.0 11,547.0 Footnotes During the year, the company received cash of $338.4 when it sold PP&E with a net book value of $379.4, which gave rise to the $41.0 loss that appears on the income statement. • Total depreciation and amortization expenses of $2,357.0 is made up of depreciation expense of $2.344.0 and amortization expense of $13.0. Check figures: cash flow from operations = $6,728.0; cash flow from investments = $(3,183.0); and cash flow from financing = $(2,524.0).
Expert Answer:
Answer rating: 100% (QA)
Answer t InDirut Hithod cash Flow statement Particutars CASH FLOW FROM OPE... View the full answer
Related Book For
Accounting
ISBN: 978-1337899451
27th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these accounting questions
-
Cynthia Billiards. Consider two identical billiard balls (I = mR) with mass 0.160 [kg] and radius 0.0250 [m] that have the same kinetic energy. If the first billiard ball is rolling without slipping...
-
Problem III: (15%) Juno Corporation's stockholders' equity section at December 31, 2016 appears below: Stockholders' equity Paid-in capital Common stock, $10 par, 60,000 outstanding Paid-in capital...
-
Using the financial statement data provided in Exhibits 2, 3, and 4, match the companies with their industry. I Since oppornunities and constraints tend to be different across industries, companies...
-
1. What is Ladures target market and retail strategy in the United States? 2. Explain the reasons Ladure owns its stores in some countries and uses franchising with local licensees in others. 3....
-
Measurements of the fuel efficiency of a car FE at various speeds v are shown in the table. (a) Curve-fit the data with a second-order polynomial. Use the polynomial to estimate the fuel efficiency...
-
According to Bustle.com, San Francisco has the most coffee shops of any American city (as of April 2016) with 2,613, with new shops opening regularly as the population grows. Suppose the city decides...
-
If your course involves exercises with a CFD code, study the manual to determine whether the discretization uses staggered or colocated grids. Does the manual say anything about the exact mass...
-
PAR AND NO-PAR, COMMON AND PREFERRED STOCK Hernandez Company had the following stock transactions during the year: (a) Issued 25,000 shares of $1 par common stock for $25,000 cash. (b) Issued 20,000...
-
ANSWER THIS QUESTION *P3-6A Givens Graphics Company was organized on January 1, 2010, by Sue Givens financial statements using At the end of the first 6 months of operations, the trial balance...
-
The Chartered Financial Analyst (CFA) designation is the de facto professional certification for the financial industry. Employers encourage their prospective employees to complete the CFA exam....
-
. Class Activity 4 In a decision about whether to accept or reject a special order, explain why it is important to know whether this is a distinction between tactical decisions and long-term...
-
How does maintaining a consistent tone and voice across various business documents benefit an organization? Discuss the potential impact of inconsistency on a company's brand identity .
-
How do you access the personal tax calculator on Knotia? Please provide step by step on what to click. You must access knotia to answer.
-
Potassium bromide (KBr) has a molar mass of 119 g/mol. If I want to make 82.0 mL of a 0.766 M solution, how many grams of KBr do I need? Report your answer with three significant figures.
-
Match the characteristics with the correct type of receivable ( Accounts Receivable or Notes Receivable ). An informal agreement between customer and company accounts receivable. Includes interest...
-
Last year's freshman class at Big State University totaled 5,330 students. Of those, 1,258 received a merit scholarship to help offset tuition costs their freshman year (although the amount varied...
-
Luke posee acciones de L Co., una corporacin canadiense depequeas empresas. L Co. quiebra durante el ao y las acciones deLuke que originalmente costaban $20,000 ahora no tienen valor. Lukepue 1 answer
-
Ask students to outline the reasons why the various elements of culture (social structures and control systems, language and aesthetics, religion and other belief systems, educational systems, etc.)...
-
The Filling Department of Eve Cosmetics Company had 4,000 ounces in beginning work in process inventory (60% complete). During the period, 46,000 ounces were completed. The ending work in process...
-
On December 31, 2019, the balances of the accounts appearing in the ledger of Wyman Company are as follows: Instructions 1. Does Wyman Company use a periodic or perpetual inventory system? Explain....
-
A corporation issued $2,000,000 of common stock in exchange for $2,000,000 of fixed assets. Where would this transaction be reported on the statement of cash flows?
-
You are presented with the following summarised information relating to Block plc for the year to 30 September 2008: Additional information: 1 Block purchased 80 per cent of the share capital of Chip...
-
Pop and Mom Ltd bought 120,000 of the 200,000 issued ordinary 1 shares of Sonny Ltd for 300,000 on 31 July 2004. Sonny Ltd financial statements are drawn up annually to 31 December. The balance sheet...
-
On 1 January 2008, Sons and Co Ltd had an issued share capital of 200,000 ordinary 1 shares. The balance on the profit and loss account was 20,000 and there was also a general reserve of 16,000....
Study smarter with the SolutionInn App