Question

In: Finance

Bargains, Inc. manufactures and markets toys. Selected income statement data from 2010 and 2009 appear below:...

Bargains, Inc. manufactures and markets toys. Selected income statement data from 2010 and 2009 appear below:

Bargains, Inc.

Selected Income Statement data

Fiscal year end

12/31/2010

12/31/2009

(amounts in thousands of dollars)

Net sales

$5,320,185

$4,980,000

Cost of Goods Sold

-3,520,415

-3,340,290

Gross profit

1,799,770

1,639,710

Required:

a.

An analyst can sometimes estimate the variable cost as a percentage of sales for a particular cost by dividing the amount of the change in the cost item between two years by the amount of the change in sales for those two years. The analyst can then multiply the variable cost percentage times sales to determine the total variable cost. Subtracting the variable cost yields the fixed cost for that particular item. Follow this procedure to determine the cost structure for costs of goods sold for Bargains, Inc.

b.

Bargains, Inc. projects sales to grow at the following percentages in future years: 2011, 10percent; 2012, 12 percent; 2013, 16 percent. Using this information, project sales, cost of goods sold and gross profit for Bargains, Inc. for 2011 to 2013.

Solutions

Expert Solution

2010 2009 Change over the period
Sale revenue $            5,320,185.00 $                   4,980,000.00 $              340,185.00
Cost of goods sold $          (3,520,415.00) $                  (3,340,290.00) $             (180,125.00)
Variable cost %age= 180125/340185
Variable cost %age= 52.95%
Cost of goods sold $            3,520,415.00 $                   3,340,290.00
Variable cost =5320185*52.94% =4980000*52.94%
Variable cost $            2,816,991.70 $                   2,636,866.70
Fixed cost =3520415-2816991.7 =3340290-2636866.7
Fixed cost $               703,423.30 $                       703,423.30
2011 2012 2013
Revenue =5320185*110% =5320185*112% =5320185*116%
Revenue $            5,852,203.50 $                   5,958,607.20 $           6,171,414.60
Variable cost 52.95% 52.95% 52.95%
Variable cost =5852203.5*52.94% =5958607.2*52.94% =6171414.6*52.94%
Variable cost $            3,098,690.88 $                   3,155,030.71 $           3,267,710.38
Income statement 2011 2012 2013
Revenue $            5,852,203.50 $                   5,958,607.20 $           6,171,414.60
Less: Variable cost $          (3,098,690.88) $                  (3,155,030.71) $          (3,267,710.38)
Contribution $            2,753,512.62 $                   2,803,576.49 $           2,903,704.22
Less: Fixed cost $             (703,423.30) $                     (703,423.30) $             (703,423.30)
Gross profit $            2,050,089.33 $                   2,100,153.20 $           2,200,280.93

Related Solutions

Condensed balance sheet and income statement data for Landwehr Corporation appear below.
Condensed balance sheet and income statement data for Landwehr Corporation appear below.   Additional information: 1. The market price of Landwehr’s common stock was $4.00, $5.00, and $8.00 for 2016, 2017, and 2018, respectively. 2. All dividends were paid in cash.   Instructions (a) Compute the following ratios for 2017 and 2018. (1) Profit margin. (2) Asset turnover. (3) Earnings per share. (Weighted-average common shares in 2018 were 32,000 and in 2017 were 31,000.) (4) Price-earnings ratio. (5) Payout ratio....
Below is the 2009 contribution income statement of a company. Contribution Income Statement For Year Ended...
Below is the 2009 contribution income statement of a company. Contribution Income Statement For Year Ended December 31, 2009 Sales (12,000 units) $1,440,000 Less variable costs Cost of goods sold $480,000 Selling and administrative 132,000 (612,000) Contribution margin 828,000 Less fixed costs Manufacturing overhead 510,000 Selling and administrative 220,000 (730,000) Net income $98,000 During the coming year, the company expects an increase in variable manufacturing costs of $8 per unit and in fixed manufacturing costs of $72,000. (a) If sales...
Presented below are selected ratio for Sun Electronic Corporation for three periods 2009, 2010, 2011, and...
Presented below are selected ratio for Sun Electronic Corporation for three periods 2009, 2010, 2011, and its industry average. Industry 2009 2010 2011 Financial Ratios 2 2 2.13 3.7 Current Ratio 1.1 1.5 1.1 1.98 Acid-test Ratio 1.00 0.90 0.82 0.57 Cash ratio 4.1 5.25 4.82 2.8 Inventory turnover 6.00 6.3 5.8 6.50 Accounts Receivables Turnover 40% 43% 45% 40% Debt ratio 22% 20% 17% 15% Debt to Equity ratio 8% 8.50% 8.60% 8.70% Return on total assets 1.85 1.9...
A. Use the following selected balance sheet and income statement data for Mattel Inc. (in $...
A. Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands) to compute a) return on equity, b) profit margin (PM), c) asset turnover (AT), and d) financial leverage (FL) for fiscal 2016. Show that ROE = PM × AT × FL. (in thousands) 2016 2015 Net sales $5,456,650 $5,702,613 Operating income 619,233 640,922 Interest expense 95,118 85,270 Net income 318,022 369,416 Total assets 6,493,794 6,535,143 Total liabilities 4,086,012 3,901,889
Little Deer Industries gathered the following year-end data (in thousands) for 2010 and 2009: 2010 2009...
Little Deer Industries gathered the following year-end data (in thousands) for 2010 and 2009: 2010 2009 Current Assets $525 $465 Long-Term Assets 885 585 Current Liabilities 385 385 Long-Term Liabilities 575 575 Owners' Equity 575 265 Net Sales 975 775 Gross Margin 485 365 Net Income 255 100 The gross margin percentage for 2010 was: A) 35.0% B) 45.1% C) 49.7% D) 52.3%
Draw up an income statement and a balance sheet for NearPerfect for 2009 and 2010. The tax rate is 34%.
After-class Task #1 Financial Statements Use the information for NearPerfect Co. to work the problems.                                        2009               2010 Sales                          $1,145            $1,200 Depreciation                   128                 128 Cost of goods sold        450                 537 Other expenses             110                    98 Interest                              85                    96 Cash                                640                 735 Receivables                    912                 967 Notes payable                122                 103 Long-term debt           2,349              2,666 Net fixed assets          5,556              5,637 Accounts payable          664                 659 Dividends                        100                 110 Inventory                      1,440              1,489 Draw up an income statement and a balance sheet for NearPerfect for 2009 and 2010....
10.Balance sheet and income statement data for two affiliated companies for the current year appear below:...
10.Balance sheet and income statement data for two affiliated companies for the current year appear below: BALANCE SHEET As at December 31, Year 6 Albeniz Bach Cash $ 40,000 $ 21,000 Receivables 92,000 84,000 Inventories 56,000 45,000 Land 20,000 60,000 Plant and equipment 200,000 700,000 Accumulated depreciation (80,000 ) (350,000 ) Investment in Bach Company (cost) 272,000 Advances to Bach Company 100,000 Total assets $ 700,000 $ 560,000 Accounts payable $ 130,000 $ 96,500 Advances payable 100,000 Common shares 400,000...
Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands)...
Use the following selected balance sheet and income statement data for Mattel Inc. (in $ thousands) to compute a) return on equity, b) profit margin (PM), c) asset turnover (AT), and d) financial leverage (FL) for fiscal 2013. Show that ROE = PM × AT × FL. (in thousands) 2013 2012 Net sales $6,484,892 $6,420,881 Operating income 1,168,103 1,021,015 Interest expense 5,555 6,841 Net income 903,944 776,464 Total assets 6,439,626 6,526,785 Total liabilities 3,188,067 3,459,741
Condensed balance sheet and income statement data for Swifty Corporation appear below: SWIFTY CORPORATION Balance Sheet...
Condensed balance sheet and income statement data for Swifty Corporation appear below: SWIFTY CORPORATION Balance Sheet December 31 2021 2020 2019 Cash $ 27,500 $ 23,500 $ 18,500 Accounts receivable 50,500 50,000 48,500 Other current assets 94,500 95,500 65,000 Property, plant, and equipment (net) 530,000 471,500 401,000 $702,500 $640,500 $533,000 Current liabilities $ 71,500 $ 77,500 $ 70,000 Long-term debt 77,500 84,500 46,500 Common shares 318,000 280,000 287,000 Retained earnings 235,500 198,500 129,500 $702,500 $640,500 $533,000 SWIFTY CORPORATION Income Statement...
Condensed balance sheet and income statement data for Landwehr Corporation appear below. LANDWEHR CORPORATION Balance Sheets...
Condensed balance sheet and income statement data for Landwehr Corporation appear below. LANDWEHR CORPORATION Balance Sheets December 31 2018 2017 2016 Cash $ 25,000 $ 20,000 $ 18,000 Accounts receivable (net) 50,000 45,000 48,000 Other current assets 90,000 95,000 64,000 Investments 75,000 70,000 45,000 Plant and equipment (net) 400,000 370,000 358,000 Total Assets $640,000 $600,000 $533,000 Current liabilities $ 75,000 $ 80,000 $ 70,000 Long-term debt 80,000 85,000 50,000 Common stock, $10 par 340,000 310,000 300,000 Retained earnings 145,000 125,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT