Question

($ m) 200X Stryker, Dec 31 ($ m) Assets Cash Marketable securities AR Inventories Other current $1,395 2,890 1,430 1,265 1,168 $8,148 $1,339 2,641 1,518 1,422 1,415 24 Total CA $8,335 $2,232 1,284 $948 $2,497 1,416 $1,081 Gross PPE less Accumulated dep Net PPE Goodwill & intangible, net Other long term Total Assets 3,566 ,8332,26? 494 $13,206 $15,743 544 Liabilities & SH Equity Accounts payable Taxes payable ST portion of LT debt Accrued compensation Accrued expenses $288 70 16 467 1,035 $1,876 $314 131 25 535 1,652 $2.657 Total CL LT Debt other LT liabilities $1,746 987 $4,609 $2,739 1,300 Total iabilities $6,696 Common Stock Additional paid-in capital Retained earnings $38 1,098 7,461 $8,597 $38 1,160 7,849 $9,047 Total SH Equity Total Liab. &SH Equity $13,206 $15,743
Stryker, 200Y (m) $9,021 2,762 $6,259 Net Sales COGS Gross Profit Selling, gen. & admin expenses R&D expenses Dep. & Amort $4,077 536 307 $4,920 Total operating expenses Operating Income (EBIT) Interest expense $1,339 $83 $127 other nonoperating expenses Total nonoperating exp Income before taxes Taxes Net Income $1,212 206 $1,006 Use Excel to complete the following:- Prepare a Sources & Uses statement for Stryker for the year 200Y. Prepare a Statement of Cash Flows for Stryker for the year 200Y. 1. 2. 3. Calculate the FreeCash ow for Stryher for the year 200Y. Comment of any figures that you consider to be significant or unusual in any of the statements or calculations above. 4.
Please answer all the questions and show the formulas please.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer

Answer 1 Sources of Cash: Decrease in cash and securities Decrease in long term assets Increase in accounts payable Increase in taxes payable Increase in current portion long-term debt Increase in long term debt Increase in other long term liabilities Increase in accrued compensation Increase in accrued expense Increase in paid in capital Increase in retained earnings Total 305 50 26 61 9 993 313 68 617 62 388 2,892 debt in long term debt Bill Uses of Cash: Increase in accounts receivable Increase in inventories- Increase in other current assets Increase in net fixed asset Increase in net intangible asset Total 157 247 133 2,267 2,892

Answer 2 Statement of cash Flow Cash Flows from Operating Activities Amount Net Income Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities 1,006 Depreciation Expense Increase in accounts payable Increase in taxes payable Increase in accrued compensation Increase in accrued expense Increase in accounts receivable Increase in inventories- Increase in other current assets Decrease in marketable securities 307 26 61 68 617 (88) (157) (247) 249 Cash generated from operations 836 1,842 Net Cash Provided by Operating Activities Cash Flows from Investing Activities Cash payment for acquisition of equipment Cash payment for acquisition of Intangible assets (265) (2,442) 50 Decrease in long term assets Net Cash provided by (used in) Investing Activities (2,657) Cash Flows from Financing Activities Increase in paid in capital Increase in current portion long-term debt Increase in long term debt Increase in other long term liabilities 62 9 993 313 (618) Cash payment of Dividends Purchase of treasury Stock Net Cash provided by (used in) Financing Activities Net Increase/Decrease in Cash and Cash Equivalents Cash and Cash Equivalents-Opening Cash and Cash Equivalents-Ending 759 (56) 1,395 1,339

Working Notes Beginning Retained Earnin Add: Net Income Less: Dividend Ending Balance 7,461 1,006 618 7,849 Depreciation & Amortisation Expense Depreciation expense: Movement in Accumulated depreciation Amortisation expense Movement in Goodwill & Intangibles net Addition to Intangibles 307 A 132 B 175 |C=A-B 2,267 D 2,442 E-C+D Answer 3 Year Free cash flow Net Cash Provided by Operating Activities Less: Capital expenditure Free cash flow before dividend 200Y 1,842 2,657 815 Answer 4 A company with negative free cash flow indicates an inability to generate enough cash to support the business. Free cash flow tracks the cash a company has left over after meeting its operating expenses and capital expenditure It is important to note that negative free cash flow is not bad in itself; on the face of it. If free cash flow is negative, it could be a sign that a company is making large investments. If these investments earn a high return, the strategy has the potential to pay off in the long rurn

Add a comment
Know the answer?
Add Answer to:
Please answer all the questions and show the formulas please. ($ m) 200X Stryker, Dec 31...
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
  • Please answer 1-4 ($ m) 200X Stryker, Dec 31 ($ m) Assets Cash Marketable securities AR...

    Please answer 1-4 ($ m) 200X Stryker, Dec 31 ($ m) Assets Cash Marketable securities AR Inventories Other current $1,395 2,890 1,430 1,265 $1,339 2,641 1,518 1,422 1681415 4 Total CA $8,148 $8,335 $2,232 1,284 $948 $2,497 1,416 $1,081 Gross PPE less Accumulated dep Net PPE Goodwill & intangible, net Other long term Total Assets 3,566 5,833 (2,26 494 $13,206 $15,743 544 Liabilities & SH Equity Accounts payable "Taxes payable" ST portion of LT debt Accrued compensation Accrued expenses $288...

  • Please show all working and answer all the questions if possible 1. Construct a balance sheet...

    Please show all working and answer all the questions if possible 1. Construct a balance sheet given the following data. What is shareholders' equity? Cash Inventory Plant and property Accounts receivable Accounts payable Long-term debt = $180,000 = $270,000 = $1,340,000 = $256,000 = $186,000 = $450,000 2. Lennox Furniture Company's 2016 balance sheet showed total current assets of $1,500,000. All of the current assets were required in operations, and its current liabilities consisted of $300.000 of accounts payable, $200,000...

  • Please show me the formulas as well, and not only the answer. Thank you. More information if you ...

    Please show me the formulas as well, and not only the answer. Thank you. More information if you need: G25 0 Statement of Cash Flows For the Year Ended December 31, 20x2 Additional information for 20X2 1. Assumethat all increases and decreases in long term assets, long term liabilities, and common stock are as a result of cash transactions 2. Land costing $46,500 was sold, resulting in again of $6,500. No other Cash Flows from Operating Activities: Net Income Adjustmentsto...

  • use the income and balance sheet above to answer the questions below. (please show work, id...

    use the income and balance sheet above to answer the questions below. (please show work, id appreciate it) Done Coco Cola Income and Balance Sheet (4 of 11) 12 Months Ended CONSOLIDATED STATEMENTS OF INCOME-USD (S)shares in Millioas, S in Millions Dec. 31, 2018 Dec. 31, 2017 Dec. 31, 2016Dee.3,2015 Dec. 31, 2014 Dec. 31, 2013 31856 35410 3255 41863 16465 Cost of Goods and Services Sold GROSS PROFIT Selling, General and Administrative Expense Other Cost and Expense, Operating OPERATING...

  • please show work as needed and be neat Use the following information to answer Questions 22-26...

    please show work as needed and be neat Use the following information to answer Questions 22-26 Selected financial data for Wilmington Corporation is presented below. WILMINGTON CORPORATION Balance Sheet As of December 31, 2017 Dec. 31, 2017 Current Assets Cash and cash equivalents Marketable securities Accounts receivable (net) Dec 31, 2016 $ 576,843 $ 305,088 166,106 187,064 289,100 391,135 258,387 Inventories 424,493 Prepaid expenses Other current assets 55,369 25,509 83,053 85,029 Total Current Assets 1,564,251 1,282,925 Property, plant and equipment...

  • Please answer all questions and make answers very clear. Thank you so much and I will...

    Please answer all questions and make answers very clear. Thank you so much and I will make sure to give a good rating!!! Use the information contained in these financial statements and notes to complete this case. All answers should be for the most current year (September 24, 2016) unless asked otherwise. Many companies show amounts in the thousands or millions please state amounts as shown on the financial statements. Do not add zeros. You do not need to include...

  • Please answer all questions listed. Whatever I can do to help, by giving a positive rating,...

    Please answer all questions listed. Whatever I can do to help, by giving a positive rating, thumbs up, etc. Let me know! Very desperate for help! Use the information contained in these financial statements and notes to complete this case. All answers should be for the most current year (September 24, 2016) unless asked otherwise. Many companies show amounts in the thousands or millions please state amounts as shown on the financial statements. Do not add zeros. You do not...

  • Please show ALL work, including formulas used and equations for excel You have been engaged as...

    Please show ALL work, including formulas used and equations for excel You have been engaged as a consultant to design a master budget model and then to assist Helping Hand Corp. in making some management decisions based on that master budget. Helping Hand is a small, rapidly growing wholesaler of consumer electronic products. The company’s main product lines are small kitchen appliances and power tools. The marketing manager has recently completed a sales forecast. She believes the company’s sales will...

  • ( please answer all the questions) The Trolley Trolley Toy Company manufactures toy building block sets...

    ( please answer all the questions) The Trolley Trolley Toy Company manufactures toy building block sets for children. Trolley Trolley is planning for 2019 2019 by developing a master budget by quarters. Trolley Trolley​'s balance sheet for December December 31 31​, 2018 2018​, ​follows: Trolley Toy Company Balance Sheet December 31, 2018 Assets Current Assets: Cash 58,000 Accounts Receivable 22,000 Raw Materials Inventory 1,200 5,400 Finished Goods Inventory Total Current Assets 86,600 Property, Plant, and Equipment Equipment 142,000 (47,000) 95,000...

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