Question

Your company had the following balance sheet and income statement information for 2003: Balance sheet: Cash                        &nb

Your company had the following balance sheet and income statement information for 2003:

Balance sheet:

Cash                                        $    20

A/R                                         1,000

Inventories                           5,000

Total C.A.                              $ 6,020                       Debt          $ 4,000

Net F.A.                                  2,980                        Equity          5,000

Total Assets              $ 9,000                       Total claims $ 9,000

Income statement:

Sales                                       $10,000

Cost of goods sold    9,200

EBIT                                       $   800

Interest (10%)                         400

EBT                                         $   400

Taxes (40%)                             160

Net Income                           $   240

The industry average inventory turnover is 5. You think you can change your inventory control system so as to cause your turnover to equal the industry average, and this change is expected to have no effect on either sales or cost of goods sold. The cash generated from reducing inventories will be used to buy tax-exempt securities which have a 7 percent rate of return.

What will your profit margin be after the change in inventories is reflected in the income statement?

Homework Answers

Answer #1

1. Current Inventory = $5000

2. New Inventory proposed = Cost of goods Sold / average inventory turnover

New Inventory proposed = 9200 / 5

New Inventory proposed = $1840

3. Cash generated from proposed plan = Current Inventory - New Inventory = 5000 - 1840 = $3160

4. New Profit after changed Inventory policy = Current Net Income + Cash generated * Interest rate

New Profit after changed Inventory policy = 240 + 3160 * 7%

New Profit after changed Inventory policy = $461.20

5. profit margin = New Profit / Sales

profit margin = 461.20 / 10000

profit margin = 4.612%

Know the answer?
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
Similar Questions
#4. Profit margin a). Your company had the following balance sheet and income statement information for...
#4. Profit margin a). Your company had the following balance sheet and income statement information for 2002: Balance Sheet: Cash $ 20 A/R 1,000 Inventories 5,000 Total current assets $6,020 Debt $4,000 Net fixed assets 2,980 Equity 5,000 Total assets $9,000 Total claims $9,000 Income Statement: Sales $10,000 Cost of goods sold 9,200 EBIT $ 800 Interest (10%) 400 EBT $ 400 Taxes (40%) 160 Net income $ 240 \ The industry average inventory turnover is 5. You think you...
Balance Sheet: Cash $       20 A/R 1,000 Inventories     2,000 Total current assets $ 3,020 Net...
Balance Sheet: Cash $       20 A/R 1,000 Inventories     2,000 Total current assets $ 3,020 Net fixed assets     2,980 Total assets $ 6,000 Income Statement: Sales $10,000 Cost of goods sold     9,000 EBIT $ 1,000 Interest (10%)        600 EBT $     400 Taxes (40%)        160 Net Income $     240 The industry average DSO is 18 (360-day basis). Collins plans to change its credit policy so as to cause its DSO to equal the industry average, and this...
The balance sheet and income statement for the A. Thiel Mfg. Company are as follows: Balance...
The balance sheet and income statement for the A. Thiel Mfg. Company are as follows: Balance Sheet ($000) Cash $ 500 Accounts receivable 2,000 Inventories 1,000 Current assets $3,500 Net fixed assets 4,500 Total assets $8,000 Accounts payable $1,100 Accrued expenses 600 Short-term notes payable 300 Current liabilities $2,000 Long-term debt 2,000 Owners’ equity 4,000 Total liabilities and owners’ equity $8,000 Income Statement ($000) Sales (all credit) $8,000 Cost of goods sold (3,300) Gross profit $4,700 Operating expenses (includes $500...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.3x Days sales outstanding: 38 daysa Inventory turnover ratio: 4x Fixed assets turnover: 2.5x Current ratio: 2.3x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 30% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $   Current liabilities $   Accounts receivable    Long-term debt 65,000...
Muscarella Inc. has the following balance sheet and income statement data: Cash $ 14,000 Accounts payable...
Muscarella Inc. has the following balance sheet and income statement data: Cash $ 14,000 Accounts payable $ 42,000 Receivables 70,000 Other current liabilities 28,000 Inventories 210,000 Total CL $ 70,000 Total CA $294,000 Long-term debt 70,000 Net fixed assets 126,000 Common equity 280,000 Total assets $420,000 Total liab. and equity $420,000 Sales $280,000 Net income $ 21,000 The new CFO thinks that inventories are excessive and could be lowered sufficiently to cause the current ratio to equal the industry average,...
You have the following balance sheet and income statement information for Epic Corp.: Balance sheet $...
You have the following balance sheet and income statement information for Epic Corp.: Balance sheet $ Accounts receivable (A/R) 2,200 Inventory 3,400 Accounts payable (A/P) 870 Income statement $ Sales 6,800 Cost of goods sold (COGS) 5,440 All sales and purchases were on credit. 1. How long is the days' sales in inventory (in days)? 2. How long is the average collection period (in days)? 3. How long is the average payment period (in days)? 4.How long is the cash...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Karen's Beauty​ Products, Inc.: ​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Karen's Beauty​ Products, Inc.: Total asset turnover 1.6 times Average collection period​ (assume 365-day​ year) 14 days Fixed asset turnover 6 times Inventory turnover​ (based on cost of goods​ sold) 3 times Current ratio 1.9 times Sales​ (all on​ credit)...
Kellogg had the following information in its most recent balance sheets and income statements. Balance Sheet...
Kellogg had the following information in its most recent balance sheets and income statements. Balance Sheet January 2, 2016 January 3, 2015 Cash and cash equivalents $251 $443 Accounts receivable, net of allowance for uncollectible accounts $1344 $1276 Inventories $1250 $1279 Total assets $15265 $15153 Accounts payable $1907 $1528 Income Statement 2016 2015 Sales $13525 $14580 Cost of sales $8844 $9517 Calculate the accounts payable turnover for Kellogg for 2016. Round your answer to three decimals places.
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash...
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 31,000 Accounts receivable 72,000 Notes payable 25,000 Inventory 53,000 Total current assets 135,000 Total current liabilities 56,000 Fixed assets 81,000 Long-term debt 30,000 Equity 130,000 Total assets $ 216,000 Total liabilities and equity $ 216,000 Income Statement Sales (all on credit) $ 290,000 Cost of goods sold 180,000 Gross margin 110,000 Selling and administrative expenses 43,000 Depreciation 7,000 EBIT...
Complete the balance sheet and sales information in the table that follows for J. White Industries...
Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.8 Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% Total liabilities-to-assets ratio: 50% Quick ratio: 0.80 Days' sales outstanding (based on 365-day year): 36.5 days Inventory turnover ratio: 3.50 Do...