Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Help See Table 5 showing financial statement data and stock price data for Mydeco Corp. a. How did Mydeco's accounts receivable days change over

Please Help

image text in transcribed

image text in transcribed

See Table 5 showing financial statement data and stock price data for Mydeco Corp. a. How did Mydeco's accounts receivable days change over this period? b. How did Mydeco's inventory days change over this period? c. Based on your analysis, has Mydeco improved its management of its working capital during this time period? (Note: Use a 365-day year.) a. How did Mydeco's accounts receivable days change over this period? The accounts receivable days for 2012 is days. (Round to one decimal place.) The accounts receivable days for 2016 is days. (Round to one decimal place.) b. How did Mydeco's inventory days change over this period? Inventory days for 2012 is days. (Round to one decimal place.) Inventory days for 2016 is days. (Round to one decimal place.) c. Based on your analysis, has Mydeco improved its management of its working capital during this time period? (Select the best choice below.) Between 2012 and 2016, Mydeco's working capital management was by both accounts receivable days and inventory days. Income Statement 2012 2013 2014 2015 2016 Revenue 402.9 368.3 423.3 513.9 602.9 Cost of Goods Sold (187.4) (178.3) (207.0) (251.3) (295.3) Gross Profit 215.5 190 216.3 262.6 307.6 Sales and Marketing (67.9) (65.4) (83.4) (103.0) (125.3) Administration (59.5) (59.3) (59.8) (66.2) (77.0) Depreciation & Amortization (28.9) (28.3) (35.2) (38.7) (36.7) EBIT 59.2 37 37.9 54.7 68.61 1 Interest Income (Expense) (35.5) (34.0) (34.0) (37.3) (39.4) 2 Pretax Income 23.7 3 3.9 17.4 29.2 B Income Tax (8.3) (1.1) (1.4) (6.1) (10.2) - Net Income 15.4 1.9 2.5 11.3 19 Shares outstanding (millions) 53.1 53.1 53.1 53.1 53.1 5 Earnings per share $0.29 $0.04 $0.05 $0.21 $0.36 - Balance Sheet 2012 2013 2014 2015 2016 B Assets e Cash 50.4 68.1 81.1 73.7 79.4 Accounts Receivable 87.5 70.2 71.3 76.3 84.3 1 Inventory 32.2 31.2 27.2 31.7 35.6 Total Current Assets 170.1 169.5 179.6 181.7 199.3 3 Net Property, Plant & Equip. 247.8 245.3 307.1 342.6 345.7 Goodwill & Intangibles 365.3 365.3 365.3 365.3 365.3 6 Total Assets 783.2 780.1 852 889.6 910.3 5 Liabilities & Stockholders' Equity - Accounts Payable 18.1 16.9 20.6 25.7 32.6 B Accrued Compensation 6.8 6.8 6.5 8.8 10.6 Total Current Liabilities 24.9 23.7 27.1 34.5 43.2 Long-term Debt 499.4 499.4 575 598.8 598.8 Total Liabilities 524.3 523.1 602.1 633.3 642 2 Stockholders' Equity 258.9 257 249.9 256.3 268.3 Total Liabilities & Stockholders' Equi 783.2 780.1 852 889.6 910.3 Statement of Cash Flows 2012 2013 2014 2015 2016 6 Net Income 15.4 1.9 2.5 11.3 19 Depreciation & Amortization 28.9 28.3 35.2 38.71 36.7 Chg. in Accounts Receivable 3.9 17.3 -1.1 (5.0) (8.0) Chg. in Inventory (2.9) 1 4 (4.5) (3.9) Chg. in Pay. & Accrued Comp. 2.6 (1.2) 3.4 7.4 8.7 Cash from Operations 47.9 47.3 44 47.9 52.5 Capital Expenditures (23.3) (24.5) (101.5) (74.0) (39.7) 2 Cash from Investing Activ. (23.3) (24.5) (101.5) (74.0) (39.7) Dividends Paid (5.1) (5.1) (5.1) (7.1) Sale (or purchase) of stock 5 Debt Issuance (Pay Down) 75.6 23.8 - 5 Cash from Financing Activ. (5.1) (5.1) 70.5 18.7 (7.1) - Change in Cash 19.5 17.7 13 (7.4) 5.7 3 Mydeco Stock Price $8.35 $3.73 $5.69 $9.56 $11.57 (5.1) - See Table 5 showing financial statement data and stock price data for Mydeco Corp. a. How did Mydeco's accounts receivable days change over this period? b. How did Mydeco's inventory days change over this period? c. Based on your analysis, has Mydeco improved its management of its working capital during this time period? (Note: Use a 365-day year.) a. How did Mydeco's accounts receivable days change over this period? The accounts receivable days for 2012 is days. (Round to one decimal place.) The accounts receivable days for 2016 is days. (Round to one decimal place.) b. How did Mydeco's inventory days change over this period? Inventory days for 2012 is days. (Round to one decimal place.) Inventory days for 2016 is days. (Round to one decimal place.) c. Based on your analysis, has Mydeco improved its management of its working capital during this time period? (Select the best choice below.) Between 2012 and 2016, Mydeco's working capital management was by both accounts receivable days and inventory days. Income Statement 2012 2013 2014 2015 2016 Revenue 402.9 368.3 423.3 513.9 602.9 Cost of Goods Sold (187.4) (178.3) (207.0) (251.3) (295.3) Gross Profit 215.5 190 216.3 262.6 307.6 Sales and Marketing (67.9) (65.4) (83.4) (103.0) (125.3) Administration (59.5) (59.3) (59.8) (66.2) (77.0) Depreciation & Amortization (28.9) (28.3) (35.2) (38.7) (36.7) EBIT 59.2 37 37.9 54.7 68.61 1 Interest Income (Expense) (35.5) (34.0) (34.0) (37.3) (39.4) 2 Pretax Income 23.7 3 3.9 17.4 29.2 B Income Tax (8.3) (1.1) (1.4) (6.1) (10.2) - Net Income 15.4 1.9 2.5 11.3 19 Shares outstanding (millions) 53.1 53.1 53.1 53.1 53.1 5 Earnings per share $0.29 $0.04 $0.05 $0.21 $0.36 - Balance Sheet 2012 2013 2014 2015 2016 B Assets e Cash 50.4 68.1 81.1 73.7 79.4 Accounts Receivable 87.5 70.2 71.3 76.3 84.3 1 Inventory 32.2 31.2 27.2 31.7 35.6 Total Current Assets 170.1 169.5 179.6 181.7 199.3 3 Net Property, Plant & Equip. 247.8 245.3 307.1 342.6 345.7 Goodwill & Intangibles 365.3 365.3 365.3 365.3 365.3 6 Total Assets 783.2 780.1 852 889.6 910.3 5 Liabilities & Stockholders' Equity - Accounts Payable 18.1 16.9 20.6 25.7 32.6 B Accrued Compensation 6.8 6.8 6.5 8.8 10.6 Total Current Liabilities 24.9 23.7 27.1 34.5 43.2 Long-term Debt 499.4 499.4 575 598.8 598.8 Total Liabilities 524.3 523.1 602.1 633.3 642 2 Stockholders' Equity 258.9 257 249.9 256.3 268.3 Total Liabilities & Stockholders' Equi 783.2 780.1 852 889.6 910.3 Statement of Cash Flows 2012 2013 2014 2015 2016 6 Net Income 15.4 1.9 2.5 11.3 19 Depreciation & Amortization 28.9 28.3 35.2 38.71 36.7 Chg. in Accounts Receivable 3.9 17.3 -1.1 (5.0) (8.0) Chg. in Inventory (2.9) 1 4 (4.5) (3.9) Chg. in Pay. & Accrued Comp. 2.6 (1.2) 3.4 7.4 8.7 Cash from Operations 47.9 47.3 44 47.9 52.5 Capital Expenditures (23.3) (24.5) (101.5) (74.0) (39.7) 2 Cash from Investing Activ. (23.3) (24.5) (101.5) (74.0) (39.7) Dividends Paid (5.1) (5.1) (5.1) (7.1) Sale (or purchase) of stock 5 Debt Issuance (Pay Down) 75.6 23.8 - 5 Cash from Financing Activ. (5.1) (5.1) 70.5 18.7 (7.1) - Change in Cash 19.5 17.7 13 (7.4) 5.7 3 Mydeco Stock Price $8.35 $3.73 $5.69 $9.56 $11.57 (5.1)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance Theory And Practice

Authors: Anne Marie Ward

2nd Edition

1907214259, 978-1907214257

More Books

Students also viewed these Finance questions