Question

In: Finance

Soenen Inc. had the following data for last year (in millions). The new CFO believes that...

Soenen Inc. had the following data for last year (in millions). The new CFO believes that the company could improve its working capital management sufficiently to bring its net working capital and cash conversion cycle up to the benchmark companies' level without affecting either sales or the costs of goods sold. Soenen finances its net working capital with a bank loan at an 8% annual interest rate, and it uses a 365-day year. If these changes had been made, by how much would the firm's pre-tax income have increased?

Original
Data Related CCC Benchmarks' CCC
Sales $99,000
Cost of goods sold $80,000
Inventory (ICP) $20,000 91.25 38.00
Receivables (DSO) $16,000 58.99 20.00
Payables (PDP) $5,000 22.81 30.00
127.43 28.00

Solutions

Expert Solution

Solution

Cost of goods sold (COGS) = $80,000

Current inventory holding period = Inventory / COGS * 365 = 91.25 days

Inventory holding period to be brought down to 38 days

Putting this in above formula:

38 days = New Inventory / $80,000 * 365

So, new inventory value = 38*80000 / 365 = $8,329

Current Receivables credit period = Receivables / Sales * 365 = 58.99 days

Receivables credit period to be brought down to 20 days

Putting this in above formula:

20 days = New Receivables / $99,000 * 365

So, New Receivables value = 20 * 99,000 / 365 = $5,425

Current Payables credit period = Payables / COGS * 365 = 22.81 days

Payables credit period to be brought up to 30 days

Putting this in above formula:

30 days = New Payables / $80,000 * 365

So, New Payables value = 30 * 80,000 / 365 = $6575

Original Net Working Capital is Inventory + Receivables - Payables = $20,000 + $16,000 - $5000 = $31,000

The new Net Working capital would be = $8,329 + $5,425 - $6575 = $ 7,179

The decrease in the net working capital is = $31,000 - $ 7,179 = $ 23,821

Interest on the loan financing net working capital = 8%

Reduction in interest cost due to the decrease in net working capital = $23,821 * 8% = $ 1,906

So increase in the pre-tax income of Soenen Inc. is $ 1,906 milllion


Related Solutions

Kiley Corporation had the following data for the most recent year. The new CFO believes that...
Kiley Corporation had the following data for the most recent year. The new CFO believes that an improved inventory management system could lower the average inventory by $4000, that improvements in the credit department could reduce receivables by $2000, and that the purchasing department coudl negogite better credit termsanf thereby increase accounts payable by $2000. Futhermore, she thinks that these changes would not affect either sales or the costs of goods sold. If these changes were made by how many...
At the end of last year, Roberts Inc. reported the following income statement (in millions of...
At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars): Sales $3,000 Operating costs excluding depreciation 2,450 EBITDA $550 Depreciation 250 EBIT $300 Interest 124 EBT $176 Taxes (25%) 44 Net income $132 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 5% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal 80%...
At the end of last year, Edwin Inc. reported the following income statement (in millions of...
At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): Sales $4,190.00 Operating costs (excluding depreciation) 3,048.00 EBITDA $1,142.00 Depreciation 325.00 EBIT $817.00 Interest 150.00 EBT $667.00 Taxes (25%) 166.75 Net income $500.25 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 6% higher than $4.19 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to increase at the...
eBook At the end of last year, Roberts Inc. reported the following income statement (in millions...
eBook At the end of last year, Roberts Inc. reported the following income statement (in millions of dollars): Sales $3,000 Operating costs excluding depreciation 2,450 EBITDA $550 Depreciation 250 EBIT $300 Interest 124 EBT $176 Taxes (25%) 44 Net income $132 Looking ahead to the following year, the company's CFO has assembled this information: Year-end sales are expected to be 11% higher than the $3 billion in sales generated last year. Year-end operating costs, excluding depreciation, are expected to equal...
TSW Inc. had the following data for last year: Net income = $800; Net operating profit...
TSW Inc. had the following data for last year: Net income = $800; Net operating profit after taxes (NOPAT) = $700; Total assets = $3,000; and Total operating capital = $2,000. Information for the just-completed year is as follows: Net income = $1,000; Net operating profit after taxes (NOPAT) = $925; Total assets = $2,600; and Total operating capital = $2,500. How much free cash flow did the firm generate during the just-completed year?
Hartzell Inc. had the following data for 2017, in millions: Net income = $600; after-tax operating...
Hartzell Inc. had the following data for 2017, in millions: Net income = $600; after-tax operating income [EBIT (1-T)] = $700; and Total assets = $2,000. Information for 2018 is as follows: Net income = $825; after-tax operating income [EBIT (1-T)] = $825; and Total assets = $2,500. Assume the firm had no excess cash. How much free cash flow did the firm generate during 2018? a. $325 b. $367 c. $257 d. $286 e. $397
ou are on the staff of Camden Inc. The CFO believes project acceptance should be based...
ou are on the staff of Camden Inc. The CFO believes project acceptance should be based on the NPV, but Steve Camden, the president, insists that no project should be accepted unless its IRR exceeds the project’s risk-adjusted WACC. Now you must make a recommendation on a project that has a cost of $15,000 and two cash flows: $110,000 at the end of Year 1 and -$100,000 at the end of Year 2. The president and the CFO both agree...
JenSteel, Inc., had the following results for last year: Total Per Unit Sales $                 2,000,000 $  &nbsp
JenSteel, Inc., had the following results for last year: Total Per Unit Sales $                 2,000,000 $                         40.00 Variable Costs                     1,250,000                             25.00 Contribution Margin $                    750,000 $                         15.00 Fixed Costs                        400,000 Operating Income $                    350,000 Prepare a new income statement for each of the following scenarios. Consider each scenario independently. Sales volume increases by 10% The sales price decreases by 5%. Variable costs per unit decrease by $1.50. A new advertising campaign costing $90,000 increases sales volume by...
As assistant to the CFO of Boulder Inc., you must estimate the Year 1 cash flow for a project with the following data.
As assistant to the CFO of Boulder Inc., you must estimate the Year 1 cash flow for a project with the following data. What is the Year 1 cash flow? Do not round the intermediate calculations and round the final answer to the nearest whole number.. Cash Sales revenues = $13,100. Cash operating costs = $6,000. Depreciation = $4,000. Interest Expense = $1,400. Tax rate = 35.0%
Seashell Mfg., Inc. had $750 million of sales last year, and it had $435 million of...
Seashell Mfg., Inc. had $750 million of sales last year, and it had $435 million of fixed assets that were used at only 65% of capacity. What is the maximum sales growth rate Seashell could achieve before it had to increase its fixed assets?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT