Related questions with answers

See Table down below showing financial statement data and stock price data for Mydeco Corp.

a. What were Mydeco's retained earnings each year?

b. Using the data from 20122012, what was Mydeco's total stockholders' equity in 20112011?

2012–2016 Financial Statement Data and Stock Price Data for Mydeco Corp

Mydeco Corp. 2012–2016 \hspace{30mm} (All data as of fiscal year end; in million)million)

Income statement20122013201420152016Revenue401.9361.6429.6513.6602.6Cost of Goods Sold(192.1)(175.4)(207.1)(248.3)(295.8)Gross Profit209.8186.2222.5265.3306.8Sales and Marketing(65.0)(64.4)(84.3)(104.9)(121.1)Administration(61.8)(57.1)(59.0)(66.9)(79.8)Depreciation & Amortization(27.5)(26.3)(32.5)(38.3)(40.1)EBIT55.538.446.755.265.8Interest Income (Expense)(32.4)(31.8)(32.0)(37.0)(40.9)Pretax Income23.16.614.718.224.9Income Tax(8.1)(2.3)(5.1)(6.4)(8.7)Net Income15.04.39.611.816.2Shares outstanding (millions)56.856.856.856.856.8Earnings per share$0.26$0.08$0.17$0.21$0.29Balance Sheet20122013201420152016AssetsCash49.468.091.780.483.6Accounts Receivable87.670.669.377.484.2Inventory33.532.227.330.235.8Total Current Assets170.5170.8188.3188.0203.6Net Property, Plant & Equip.244.3243.3306.1349.6347.9Goodwill & Intangibles365.5365.5365.5365.5365.5Total Assets780.3779.6859.9903.1917.0Liabilities & Stockholders’ EquityAccounts Payable18.818.822.427.130.3Accrued Compensation7.66.37.57.79.4Total Current Liabilities26.425.129.934.839.7Long-term Debt498.9498.9572.2597.5597.5Total Liabilities525.3524602.1632.3637.2Stockholders’ Equity255.0255.6257.8270.8279.8Total Liabilities & Stockholders’ Equity780.3779.6859.9903.1917.0Statement of Cash Flows20122013201420152016Net Income15.04.39.611.816.2Depreciation & Amortization27.526.332.538.340.1Chg. in Accounts Receivable3.917.01.3(8.1)(6.8)Chg. in Inventory(2.9)1.34.9(2.9)(5.6)Chg. in Payables & Accrued Comp.1.7(1.3)4.84.94.9Cash from Operations45.247.653.144.048.8Capital Expenditures(26.6)(23.8)(97.5)(75.4)(40.0)Cash from Investing Activities(26.6)(23.8)(97.5)(75.4)(40.0)Dividends Paid(5.2)(5.2)(5.2)(5.2)(5.6)Sale (or purchase) of stockDebt Issuance (Pay Down)73.325.3Cash from Financing Activities(5.2)(5.2)68.120.1(5.6)Change in Cash13.418.623.7(11.3)3.2Mydeco Stock Price$7.02$3.55$5.86$8.33$11.57\begin{array}{lccccc} \text{Income statement} & 2012 & 2013 & 2014 & 2015 & 2016 \\ \text{Revenue} & 401.9 & 361.6 & 429.6 & 513.6 & 602.6 \\ \underline{\text{Cost of Goods Sold}} & (192.1) & (175.4) & (207.1) & (248.3) & (295.8)\\ \text{Gross Profit} & 209.8 & 186.2 & 222.5 & 265.3 & 306.8\\ \text{Sales and Marketing} & (65.0) & (64.4) & (84.3) & (104.9) & (121.1)\\ \text{Administration} & (61.8) & (57.1) & (59.0) & (66.9) & (79.8)\\ \underline{\text{Depreciation $\And$ Amortization}} & (27.5) & (26.3) & (32.5) & (38.3) & (40.1)\\ \text{EBIT} & 55.5 & 38.4 & 46.7 & 55.2 & 65.8\\ \underline{\text{Interest Income (Expense)}} & (32.4) & (31.8) & (32.0) & (37.0) & (40.9)\\ \text{Pretax Income} & 23.1 & 6.6 & 14.7 & 18.2 & 24.9\\ \underline{\text{Income Tax}} & (8.1) & (2.3) & (5.1) & (6.4) & (8.7)\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Shares outstanding (millions)} & 56.8 & 56.8 & 56.8 & 56.8 & 56.8\\ \text{Earnings per share} & \$0.26 & \$0.08 & \$0.17 & \$0.21 & \$0.29\\ \text{Balance Sheet} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Assets}\\ \text{Cash} & 49.4 & 68.0 & 91.7 & 80.4 & 83.6\\ \text{Accounts Receivable} & 87.6 & 70.6 & 69.3 & 77.4 & 84.2\\ \text{Inventory} & 33.5 & 32.2 & 27.3 & 30.2 & 35.8\\ \text{Total Current Assets} & 170.5 & 170.8 & 188.3 & 188.0 & 203.6\\ \text{Net Property, Plant $\And$ Equip.} & 244.3 & 243.3 & 306.1 & 349.6 & 347.9\\ \text{Goodwill $\And$ Intangibles} & 365.5 & 365.5 & 365.5 & 365.5 & 365.5\\ \text{Total Assets} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Liabilities $\And$ Stockholders’ Equity}\\ \text{Accounts Payable} & 18.8 & 18.8 & 22.4 & 27.1 & 30.3\\ \text{Accrued Compensation} & 7.6 & 6.3 & 7.5 & 7.7 & 9.4\\ \text{Total Current Liabilities} & 26.4 & 25.1 & 29.9 & 34.8 & 39.7\\ \text{Long-term Debt} & 498.9 & 498.9 & 572.2 & 597.5 & 597.5\\ \text{Total Liabilities} & 525.3 & 524 & 602.1 & 632.3 & 637.2\\ \text{Stockholders’ Equity} & 255.0 & 255.6 & 257.8 & 270.8 & 279.8\\ \text{Total Liabilities $\And$ Stockholders’ Equity} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Statement of Cash Flows} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Depreciation $\And$ Amortization} & 27.5 & 26.3 & 32.5 & 38.3 & 40.1\\ \text{Chg. in Accounts Receivable} & 3.9 & 17.0 & 1.3 & (8.1) & (6.8)\\ \text{Chg. in Inventory} & (2.9) & 1.3 & 4.9 & (2.9) & (5.6)\\ \underline{\text{Chg. in Payables $\And$ Accrued Comp.}} & 1.7 & (1.3) & 4.8 & 4.9 & 4.9\\ \text{Cash from Operations} & 45.2 & 47.6 & 53.1 & 44.0 & 48.8\\ \underline{\text{Capital Expenditures}} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Cash from Investing Activities} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Dividends Paid} & (5.2) & (5.2) & (5.2) & (5.2) & (5.6)\\ \text{Sale (or purchase) of stock} & — & — & — & — & —\\ \underline{\text{Debt Issuance (Pay Down)}} & — & — & 73.3 & 25.3 & —\\ \text{Cash from Financing Activities} & (5.2) & (5.2) & 68.1 & 20.1 & (5.6)\\ \text{Change in Cash} & 13.4 & 18.6 & 23.7 & (11.3) & 3.2\\ \text{Mydeco Stock Price} & \$7.02 & \$3.55 & \$5.86 & \$8.33 & \$11.57\\ \end{array}

$

See Table down below showing financial statement data and stock price data for Mydeco Corp.

a. Compute Mydeco's ROE each year from 20122012 to 20162016.

b. Compute Mydeco's ROA each year from 20122012 to 20162016.

c. Which return is more volatile? Why?

2012–2016 Financial Statement Data and Stock Price Data for Mydeco Corp

Mydeco Corp. 2012–2016 \hspace{30mm} (All data as of fiscal year end; in million)million)

Income statement20122013201420152016Revenue401.9361.6429.6513.6602.6Cost of Goods Sold(192.1)(175.4)(207.1)(248.3)(295.8)Gross Profit209.8186.2222.5265.3306.8Sales and Marketing(65.0)(64.4)(84.3)(104.9)(121.1)Administration(61.8)(57.1)(59.0)(66.9)(79.8)Depreciation & Amortization(27.5)(26.3)(32.5)(38.3)(40.1)EBIT55.538.446.755.265.8Interest Income (Expense)(32.4)(31.8)(32.0)(37.0)(40.9)Pretax Income23.16.614.718.224.9Income Tax(8.1)(2.3)(5.1)(6.4)(8.7)Net Income15.04.39.611.816.2Shares outstanding (millions)56.856.856.856.856.8Earnings per share$0.26$0.08$0.17$0.21$0.29Balance Sheet20122013201420152016AssetsCash49.468.091.780.483.6Accounts Receivable87.670.669.377.484.2Inventory33.532.227.330.235.8Total Current Assets170.5170.8188.3188.0203.6Net Property, Plant & Equip.244.3243.3306.1349.6347.9Goodwill & Intangibles365.5365.5365.5365.5365.5Total Assets780.3779.6859.9903.1917.0Liabilities & Stockholders’ EquityAccounts Payable18.818.822.427.130.3Accrued Compensation7.66.37.57.79.4Total Current Liabilities26.425.129.934.839.7Long-term Debt498.9498.9572.2597.5597.5Total Liabilities525.3524602.1632.3637.2Stockholders’ Equity255.0255.6257.8270.8279.8Total Liabilities & Stockholders’ Equity780.3779.6859.9903.1917.0Statement of Cash Flows20122013201420152016Net Income15.04.39.611.816.2Depreciation & Amortization27.526.332.538.340.1Chg. in Accounts Receivable3.917.01.3(8.1)(6.8)Chg. in Inventory(2.9)1.34.9(2.9)(5.6)Chg. in Payables & Accrued Comp.1.7(1.3)4.84.94.9Cash from Operations45.247.653.144.048.8Capital Expenditures(26.6)(23.8)(97.5)(75.4)(40.0)Cash from Investing Activities(26.6)(23.8)(97.5)(75.4)(40.0)Dividends Paid(5.2)(5.2)(5.2)(5.2)(5.6)Sale (or purchase) of stockDebt Issuance (Pay Down)73.325.3Cash from Financing Activities(5.2)(5.2)68.120.1(5.6)Change in Cash13.418.623.7(11.3)3.2Mydeco Stock Price$7.02$3.55$5.86$8.33$11.57\begin{array}{lccccc} \text{Income statement} & 2012 & 2013 & 2014 & 2015 & 2016 \\ \text{Revenue} & 401.9 & 361.6 & 429.6 & 513.6 & 602.6 \\ \underline{\text{Cost of Goods Sold}} & (192.1) & (175.4) & (207.1) & (248.3) & (295.8)\\ \text{Gross Profit} & 209.8 & 186.2 & 222.5 & 265.3 & 306.8\\ \text{Sales and Marketing} & (65.0) & (64.4) & (84.3) & (104.9) & (121.1)\\ \text{Administration} & (61.8) & (57.1) & (59.0) & (66.9) & (79.8)\\ \underline{\text{Depreciation $\And$ Amortization}} & (27.5) & (26.3) & (32.5) & (38.3) & (40.1)\\ \text{EBIT} & 55.5 & 38.4 & 46.7 & 55.2 & 65.8\\ \underline{\text{Interest Income (Expense)}} & (32.4) & (31.8) & (32.0) & (37.0) & (40.9)\\ \text{Pretax Income} & 23.1 & 6.6 & 14.7 & 18.2 & 24.9\\ \underline{\text{Income Tax}} & (8.1) & (2.3) & (5.1) & (6.4) & (8.7)\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Shares outstanding (millions)} & 56.8 & 56.8 & 56.8 & 56.8 & 56.8\\ \text{Earnings per share} & \$0.26 & \$0.08 & \$0.17 & \$0.21 & \$0.29\\ \text{Balance Sheet} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Assets}\\ \text{Cash} & 49.4 & 68.0 & 91.7 & 80.4 & 83.6\\ \text{Accounts Receivable} & 87.6 & 70.6 & 69.3 & 77.4 & 84.2\\ \text{Inventory} & 33.5 & 32.2 & 27.3 & 30.2 & 35.8\\ \text{Total Current Assets} & 170.5 & 170.8 & 188.3 & 188.0 & 203.6\\ \text{Net Property, Plant $\And$ Equip.} & 244.3 & 243.3 & 306.1 & 349.6 & 347.9\\ \text{Goodwill $\And$ Intangibles} & 365.5 & 365.5 & 365.5 & 365.5 & 365.5\\ \text{Total Assets} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Liabilities $\And$ Stockholders’ Equity}\\ \text{Accounts Payable} & 18.8 & 18.8 & 22.4 & 27.1 & 30.3\\ \text{Accrued Compensation} & 7.6 & 6.3 & 7.5 & 7.7 & 9.4\\ \text{Total Current Liabilities} & 26.4 & 25.1 & 29.9 & 34.8 & 39.7\\ \text{Long-term Debt} & 498.9 & 498.9 & 572.2 & 597.5 & 597.5\\ \text{Total Liabilities} & 525.3 & 524 & 602.1 & 632.3 & 637.2\\ \text{Stockholders’ Equity} & 255.0 & 255.6 & 257.8 & 270.8 & 279.8\\ \text{Total Liabilities $\And$ Stockholders’ Equity} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Statement of Cash Flows} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Depreciation $\And$ Amortization} & 27.5 & 26.3 & 32.5 & 38.3 & 40.1\\ \text{Chg. in Accounts Receivable} & 3.9 & 17.0 & 1.3 & (8.1) & (6.8)\\ \text{Chg. in Inventory} & (2.9) & 1.3 & 4.9 & (2.9) & (5.6)\\ \underline{\text{Chg. in Payables $\And$ Accrued Comp.}} & 1.7 & (1.3) & 4.8 & 4.9 & 4.9\\ \text{Cash from Operations} & 45.2 & 47.6 & 53.1 & 44.0 & 48.8\\ \underline{\text{Capital Expenditures}} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Cash from Investing Activities} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Dividends Paid} & (5.2) & (5.2) & (5.2) & (5.2) & (5.6)\\ \text{Sale (or purchase) of stock} & — & — & — & — & —\\ \underline{\text{Debt Issuance (Pay Down)}} & — & — & 73.3 & 25.3 & —\\ \text{Cash from Financing Activities} & (5.2) & (5.2) & 68.1 & 20.1 & (5.6)\\ \text{Change in Cash} & 13.4 & 18.6 & 23.7 & (11.3) & 3.2\\ \text{Mydeco Stock Price} & \$7.02 & \$3.55 & \$5.86 & \$8.33 & \$11.57\\ \end{array}

$

See Table down below showing financial statement data and stock price data for Mydeco Corp.

a. What is Mydeco's market capitalization at the end of each year?

b. What is Mydeco's market-to-book ratio at the end of each year? Windows.

c. What is Mydeco's enterprise value at the end of each year?

2012–2016 Financial Statement Data and Stock Price Data for Mydeco Corp

Mydeco Corp. 2012–2016 \hspace{30mm} (All data as of fiscal year end; in million)million)

Income statement20122013201420152016Revenue401.9361.6429.6513.6602.6Cost of Goods Sold(192.1)(175.4)(207.1)(248.3)(295.8)Gross Profit209.8186.2222.5265.3306.8Sales and Marketing(65.0)(64.4)(84.3)(104.9)(121.1)Administration(61.8)(57.1)(59.0)(66.9)(79.8)Depreciation & Amortization(27.5)(26.3)(32.5)(38.3)(40.1)EBIT55.538.446.755.265.8Interest Income (Expense)(32.4)(31.8)(32.0)(37.0)(40.9)Pretax Income23.16.614.718.224.9Income Tax(8.1)(2.3)(5.1)(6.4)(8.7)Net Income15.04.39.611.816.2Shares outstanding (millions)56.856.856.856.856.8Earnings per share$0.26$0.08$0.17$0.21$0.29Balance Sheet20122013201420152016AssetsCash49.468.091.780.483.6Accounts Receivable87.670.669.377.484.2Inventory33.532.227.330.235.8Total Current Assets170.5170.8188.3188.0203.6Net Property, Plant & Equip.244.3243.3306.1349.6347.9Goodwill & Intangibles365.5365.5365.5365.5365.5Total Assets780.3779.6859.9903.1917.0Liabilities & Stockholders’ EquityAccounts Payable18.818.822.427.130.3Accrued Compensation7.66.37.57.79.4Total Current Liabilities26.425.129.934.839.7Long-term Debt498.9498.9572.2597.5597.5Total Liabilities525.3524602.1632.3637.2Stockholders’ Equity255.0255.6257.8270.8279.8Total Liabilities & Stockholders’ Equity780.3779.6859.9903.1917.0Statement of Cash Flows20122013201420152016Net Income15.04.39.611.816.2Depreciation & Amortization27.526.332.538.340.1Chg. in Accounts Receivable3.917.01.3(8.1)(6.8)Chg. in Inventory(2.9)1.34.9(2.9)(5.6)Chg. in Payables & Accrued Comp.1.7(1.3)4.84.94.9Cash from Operations45.247.653.144.048.8Capital Expenditures(26.6)(23.8)(97.5)(75.4)(40.0)Cash from Investing Activities(26.6)(23.8)(97.5)(75.4)(40.0)Dividends Paid(5.2)(5.2)(5.2)(5.2)(5.6)Sale (or purchase) of stockDebt Issuance (Pay Down)73.325.3Cash from Financing Activities(5.2)(5.2)68.120.1(5.6)Change in Cash13.418.623.7(11.3)3.2Mydeco Stock Price$7.02$3.55$5.86$8.33$11.57\begin{array}{lccccc} \text{Income statement} & 2012 & 2013 & 2014 & 2015 & 2016 \\ \text{Revenue} & 401.9 & 361.6 & 429.6 & 513.6 & 602.6 \\ \underline{\text{Cost of Goods Sold}} & (192.1) & (175.4) & (207.1) & (248.3) & (295.8)\\ \text{Gross Profit} & 209.8 & 186.2 & 222.5 & 265.3 & 306.8\\ \text{Sales and Marketing} & (65.0) & (64.4) & (84.3) & (104.9) & (121.1)\\ \text{Administration} & (61.8) & (57.1) & (59.0) & (66.9) & (79.8)\\ \underline{\text{Depreciation $\And$ Amortization}} & (27.5) & (26.3) & (32.5) & (38.3) & (40.1)\\ \text{EBIT} & 55.5 & 38.4 & 46.7 & 55.2 & 65.8\\ \underline{\text{Interest Income (Expense)}} & (32.4) & (31.8) & (32.0) & (37.0) & (40.9)\\ \text{Pretax Income} & 23.1 & 6.6 & 14.7 & 18.2 & 24.9\\ \underline{\text{Income Tax}} & (8.1) & (2.3) & (5.1) & (6.4) & (8.7)\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Shares outstanding (millions)} & 56.8 & 56.8 & 56.8 & 56.8 & 56.8\\ \text{Earnings per share} & \$0.26 & \$0.08 & \$0.17 & \$0.21 & \$0.29\\ \text{Balance Sheet} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Assets}\\ \text{Cash} & 49.4 & 68.0 & 91.7 & 80.4 & 83.6\\ \text{Accounts Receivable} & 87.6 & 70.6 & 69.3 & 77.4 & 84.2\\ \text{Inventory} & 33.5 & 32.2 & 27.3 & 30.2 & 35.8\\ \text{Total Current Assets} & 170.5 & 170.8 & 188.3 & 188.0 & 203.6\\ \text{Net Property, Plant $\And$ Equip.} & 244.3 & 243.3 & 306.1 & 349.6 & 347.9\\ \text{Goodwill $\And$ Intangibles} & 365.5 & 365.5 & 365.5 & 365.5 & 365.5\\ \text{Total Assets} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Liabilities $\And$ Stockholders’ Equity}\\ \text{Accounts Payable} & 18.8 & 18.8 & 22.4 & 27.1 & 30.3\\ \text{Accrued Compensation} & 7.6 & 6.3 & 7.5 & 7.7 & 9.4\\ \text{Total Current Liabilities} & 26.4 & 25.1 & 29.9 & 34.8 & 39.7\\ \text{Long-term Debt} & 498.9 & 498.9 & 572.2 & 597.5 & 597.5\\ \text{Total Liabilities} & 525.3 & 524 & 602.1 & 632.3 & 637.2\\ \text{Stockholders’ Equity} & 255.0 & 255.6 & 257.8 & 270.8 & 279.8\\ \text{Total Liabilities $\And$ Stockholders’ Equity} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Statement of Cash Flows} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Depreciation $\And$ Amortization} & 27.5 & 26.3 & 32.5 & 38.3 & 40.1\\ \text{Chg. in Accounts Receivable} & 3.9 & 17.0 & 1.3 & (8.1) & (6.8)\\ \text{Chg. in Inventory} & (2.9) & 1.3 & 4.9 & (2.9) & (5.6)\\ \underline{\text{Chg. in Payables $\And$ Accrued Comp.}} & 1.7 & (1.3) & 4.8 & 4.9 & 4.9\\ \text{Cash from Operations} & 45.2 & 47.6 & 53.1 & 44.0 & 48.8\\ \underline{\text{Capital Expenditures}} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Cash from Investing Activities} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Dividends Paid} & (5.2) & (5.2) & (5.2) & (5.2) & (5.6)\\ \text{Sale (or purchase) of stock} & — & — & — & — & —\\ \underline{\text{Debt Issuance (Pay Down)}} & — & — & 73.3 & 25.3 & —\\ \text{Cash from Financing Activities} & (5.2) & (5.2) & 68.1 & 20.1 & (5.6)\\ \text{Change in Cash} & 13.4 & 18.6 & 23.7 & (11.3) & 3.2\\ \text{Mydeco Stock Price} & \$7.02 & \$3.55 & \$5.86 & \$8.33 & \$11.57\\ \end{array}

$

Question

See Table down below showing financial statement data and stock price data for Mydeco Corp.

a. Compute Mydeco's PE ratio each year from 20122012 to 20162016. In which year was it the highest?

b. What was Mydeco's Enterprise Value to EBITDA ratio each year? In which year was it the highest?

c. What might explain the differing time pattern of the two valuation ratios?

2012–2016 Financial Statement Data and Stock Price Data for Mydeco Corp

Mydeco Corp. 2012–2016 \hspace{30mm} (All data as of fiscal year end; in million)million)

Income statement20122013201420152016Revenue401.9361.6429.6513.6602.6Cost of Goods Sold(192.1)(175.4)(207.1)(248.3)(295.8)Gross Profit209.8186.2222.5265.3306.8Sales and Marketing(65.0)(64.4)(84.3)(104.9)(121.1)Administration(61.8)(57.1)(59.0)(66.9)(79.8)Depreciation & Amortization(27.5)(26.3)(32.5)(38.3)(40.1)EBIT55.538.446.755.265.8Interest Income (Expense)(32.4)(31.8)(32.0)(37.0)(40.9)Pretax Income23.16.614.718.224.9Income Tax(8.1)(2.3)(5.1)(6.4)(8.7)Net Income15.04.39.611.816.2Shares outstanding (millions)56.856.856.856.856.8Earnings per share$0.26$0.08$0.17$0.21$0.29Balance Sheet20122013201420152016AssetsCash49.468.091.780.483.6Accounts Receivable87.670.669.377.484.2Inventory33.532.227.330.235.8Total Current Assets170.5170.8188.3188.0203.6Net Property, Plant & Equip.244.3243.3306.1349.6347.9Goodwill & Intangibles365.5365.5365.5365.5365.5Total Assets780.3779.6859.9903.1917.0Liabilities & Stockholders’ EquityAccounts Payable18.818.822.427.130.3Accrued Compensation7.66.37.57.79.4Total Current Liabilities26.425.129.934.839.7Long-term Debt498.9498.9572.2597.5597.5Total Liabilities525.3524602.1632.3637.2Stockholders’ Equity255.0255.6257.8270.8279.8Total Liabilities & Stockholders’ Equity780.3779.6859.9903.1917.0Statement of Cash Flows20122013201420152016Net Income15.04.39.611.816.2Depreciation & Amortization27.526.332.538.340.1Chg. in Accounts Receivable3.917.01.3(8.1)(6.8)Chg. in Inventory(2.9)1.34.9(2.9)(5.6)Chg. in Payables & Accrued Comp.1.7(1.3)4.84.94.9Cash from Operations45.247.653.144.048.8Capital Expenditures(26.6)(23.8)(97.5)(75.4)(40.0)Cash from Investing Activities(26.6)(23.8)(97.5)(75.4)(40.0)Dividends Paid(5.2)(5.2)(5.2)(5.2)(5.6)Sale (or purchase) of stockDebt Issuance (Pay Down)73.325.3Cash from Financing Activities(5.2)(5.2)68.120.1(5.6)Change in Cash13.418.623.7(11.3)3.2Mydeco Stock Price$7.02$3.55$5.86$8.33$11.57\begin{array}{lccccc} \text{Income statement} & 2012 & 2013 & 2014 & 2015 & 2016 \\ \text{Revenue} & 401.9 & 361.6 & 429.6 & 513.6 & 602.6 \\ \underline{\text{Cost of Goods Sold}} & (192.1) & (175.4) & (207.1) & (248.3) & (295.8)\\ \text{Gross Profit} & 209.8 & 186.2 & 222.5 & 265.3 & 306.8\\ \text{Sales and Marketing} & (65.0) & (64.4) & (84.3) & (104.9) & (121.1)\\ \text{Administration} & (61.8) & (57.1) & (59.0) & (66.9) & (79.8)\\ \underline{\text{Depreciation $\And$ Amortization}} & (27.5) & (26.3) & (32.5) & (38.3) & (40.1)\\ \text{EBIT} & 55.5 & 38.4 & 46.7 & 55.2 & 65.8\\ \underline{\text{Interest Income (Expense)}} & (32.4) & (31.8) & (32.0) & (37.0) & (40.9)\\ \text{Pretax Income} & 23.1 & 6.6 & 14.7 & 18.2 & 24.9\\ \underline{\text{Income Tax}} & (8.1) & (2.3) & (5.1) & (6.4) & (8.7)\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Shares outstanding (millions)} & 56.8 & 56.8 & 56.8 & 56.8 & 56.8\\ \text{Earnings per share} & \$0.26 & \$0.08 & \$0.17 & \$0.21 & \$0.29\\ \text{Balance Sheet} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Assets}\\ \text{Cash} & 49.4 & 68.0 & 91.7 & 80.4 & 83.6\\ \text{Accounts Receivable} & 87.6 & 70.6 & 69.3 & 77.4 & 84.2\\ \text{Inventory} & 33.5 & 32.2 & 27.3 & 30.2 & 35.8\\ \text{Total Current Assets} & 170.5 & 170.8 & 188.3 & 188.0 & 203.6\\ \text{Net Property, Plant $\And$ Equip.} & 244.3 & 243.3 & 306.1 & 349.6 & 347.9\\ \text{Goodwill $\And$ Intangibles} & 365.5 & 365.5 & 365.5 & 365.5 & 365.5\\ \text{Total Assets} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Liabilities $\And$ Stockholders’ Equity}\\ \text{Accounts Payable} & 18.8 & 18.8 & 22.4 & 27.1 & 30.3\\ \text{Accrued Compensation} & 7.6 & 6.3 & 7.5 & 7.7 & 9.4\\ \text{Total Current Liabilities} & 26.4 & 25.1 & 29.9 & 34.8 & 39.7\\ \text{Long-term Debt} & 498.9 & 498.9 & 572.2 & 597.5 & 597.5\\ \text{Total Liabilities} & 525.3 & 524 & 602.1 & 632.3 & 637.2\\ \text{Stockholders’ Equity} & 255.0 & 255.6 & 257.8 & 270.8 & 279.8\\ \text{Total Liabilities $\And$ Stockholders’ Equity} & 780.3 & 779.6 & 859.9 & 903.1 & 917.0\\ \text{Statement of Cash Flows} & 2012 & 2013 & 2014 & 2015 & 2016\\ \text{Net Income} & 15.0 & 4.3 & 9.6 & 11.8 & 16.2\\ \text{Depreciation $\And$ Amortization} & 27.5 & 26.3 & 32.5 & 38.3 & 40.1\\ \text{Chg. in Accounts Receivable} & 3.9 & 17.0 & 1.3 & (8.1) & (6.8)\\ \text{Chg. in Inventory} & (2.9) & 1.3 & 4.9 & (2.9) & (5.6)\\ \underline{\text{Chg. in Payables $\And$ Accrued Comp.}} & 1.7 & (1.3) & 4.8 & 4.9 & 4.9\\ \text{Cash from Operations} & 45.2 & 47.6 & 53.1 & 44.0 & 48.8\\ \underline{\text{Capital Expenditures}} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Cash from Investing Activities} & (26.6) & (23.8) & (97.5) & (75.4) & (40.0)\\ \text{Dividends Paid} & (5.2) & (5.2) & (5.2) & (5.2) & (5.6)\\ \text{Sale (or purchase) of stock} & — & — & — & — & —\\ \underline{\text{Debt Issuance (Pay Down)}} & — & — & 73.3 & 25.3 & —\\ \text{Cash from Financing Activities} & (5.2) & (5.2) & 68.1 & 20.1 & (5.6)\\ \text{Change in Cash} & 13.4 & 18.6 & 23.7 & (11.3) & 3.2\\ \text{Mydeco Stock Price} & \$7.02 & \$3.55 & \$5.86 & \$8.33 & \$11.57\\ \end{array}

$

Solution

Verified
Answered 1 year ago
Answered 1 year ago
Step 1
1 of 10

In this problem, we are asked to analyze and compute Mydeco's PE ratio and EV/EBITDA ratio.

Create an account to view solutions

Create an account to view solutions

More related questions

1/4