Related questions with answers

The Svenson Corporation manufactures cellular modems. It manufactures its own cellular modem circuit boards (CMCB), an important part of the cellular modem. It reports the following cost information about the costs of making CMCBs in 2017 and the expected costs in 2018:

Current Costs in 2017Expected Costs in 2018Variable manufacturing costsDirect material cost per CMCB$ 180$ 170Direct manufacturing labor cost per CMCB5045Variable manufacturing cost per batch for setups, materials handling, and quality control1,6001,500Fixed manufacturing costFixed manufacturing overhead costs that can be avoided if CMCBs are not made320,000320,000Fixed manufacturing overhead costs of plant depreciation, insurance, and administration that cannot be avoided even if CMCBs are not made800,000800,000\begin{matrix} & \text{Current Costs in 2017} & \text{Expected Costs in 2018}\\ \text{Variable manufacturing costs}\\ \text{Direct material cost per CMCB} & \text{\$ 180} & \text{\$ 170}\\ \text{Direct manufacturing labor cost per CMCB} & \text{50} & \text{45}\\ \text{Variable manufacturing cost per batch for setups, materials handling, and quality control} & \text{1,600} & \text{1,500}\\ \text{Fixed manufacturing cost}\\ \text{Fixed manufacturing overhead costs that can be avoided if CMCBs are not made} & \text{320,000} & \text{320,000}\\ \text{Fixed manufacturing overhead costs of plant depreciation, insurance, and administration that cannot be avoided even if CMCBs are not made} & \text{800,000} & \text{800,000}\\ \end{matrix}

Svenson manufactured 8,000 CMCBs in 2017 in 40 batches of 200 each. In 2018, Svenson anticipates needing 10,000 CMCBs. The CMCBs would be produced in 80 batches of 125 each. The Minton Corporation has approached Svenson about supplying CMCBs to Svenson in 2018 at 300perCMCBonwhateverdeliveryscheduleSvensonwants.1.CalculatethetotalexpectedmanufacturingcostperunitofmakingCMCBsin2018.2.SupposethecapacitycurrentlyusedtomakeCMCBswillbecomeidleifSvensonpurchasesCMCBsfromMinton.Onthebasisoffinancialconsiderationsalone,shouldSvensonmakeCMCBsorbuythemfromMinton?Showyourcalculations.3.NowsupposethatifSvensonpurchasesCMCBsfromMinton,itsbestalternativeuseofthecapacitycurrentlyusedfromCMCBsistomakeandsellspecialcircuitboards(CB3s)totheEssexCorporation.SvensonestimatesthefollowingincrementalrevenuesandcostsfromCB3s:300 per CMCB on whatever delivery schedule Svenson wants. 1. Calculate the total expected manufacturing cost per unit of making CMCBs in 2018. 2. Suppose the capacity currently used to make CMCBs will become idle if Svenson purchases CMCBs from Minton. On the basis of financial considerations alone, should Svenson make CMCBs or buy them from Minton? Show your calculations. 3. Now suppose that if Svenson purchases CMCBs from Minton ,its best alternative use of the capacity currently used from CMCBs is to make and sell special circuit boards (CB3s) to the Essex Corporation. Svenson estimates the following incremental revenues and costs from CB3s:

Total expected incremental future revenues$2,000,000Total expected incremental future costs$2,150,000\begin{matrix} \text{Total expected incremental future revenues} & \text{\$2,000,000}\\ \text{Total expected incremental future costs} & \text{\$2,150,000}\\ \end{matrix}

$ On the basis of financial considerations alone, should Svenson make CMCBs or buy them from Minton? Show your calculations.

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

a. Compare accounts payable days in 20122012 and 20162016.

b. Did this change in accounts payable days improve or worsen Mydeco's cash position in 20162016?

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. In what year was Mydeco's net income the lowest?

b. In what year did Mydeco need to reduce its cash reserves?

c. Why did Mydeco need to reduce its cash reserves in a year when net income was reasonably high?

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 6

In this problem, we are asked to analyze and identify Mydeco's lowest income and on what year did Mydeco reduce its cash reserves. But before that, let us first define relevant terms to be used in this problem.

Create an account to view solutions

Create an account to view solutions

More related questions

1/4