Calcor Company has been a wholesale distributor of automobile parts for domestic automakers for 20 years. Calcor has suffered through the recent slump in the domestic auto industry, and its performance has not rebounded to the levels of the industry as a whole.
Calcor's single-step income statement for the year ended November 30, 2011, follows:
Calcor's return on sales before interest and taxes was 5% in fiscal 2011 compared with the industry average of 9%. Calcor's turnover of average assets of four times per year and return on average assets before interest and taxes of 20% are both well below the industry average.
Joe Kuhn, president of Calcor, wishes to improve these ratios and raise them nearer to the industry averages. He established the following goals for Calcor Company for fiscal 2012:
|
Return on sales before interest and taxes
|
8%
|
|
Turnover of average assets
|
5 times per year
|
|
Return on average assets before interest and taxes
|
30%
|
For fiscal 2012, Kuhn and the rest of Calcor's management team are considering the following actions, which they expect will improve profitability and result in a 5% increase in unit sales:
1. Increase selling prices 10%.
2. Increase advertising by $420,000 and hold all other selling and administrative expenses at fiscal 2011 levels.
3. Improve customer service by increasing average current assets (inventory and accounts receivable) by a total of $300,000, and hold all other assets at fiscal 2011 levels.
4. Finance the additional assets at an annual interest rate of 10% and hold all other interest expense at fiscal 2011 levels.
5. Improve the quality of products carried; this will increase the units of goods sold by 4%.
6. Calcor's 2012 effective income tax rate is expected to be 40%-the same as in fiscal 2011.
Required
a. Prepare a single-step pro forma income statement for Calcor Company for the year ended November 30, 2012, assuming that Calcor's planned actions would be carried out and that the 5% increase in unit sales would be realized.
b. Calculate the following ratios for Calcor Company for the 2011-2012 fiscal year and state whether Kuhn's goal would be achieved:
1. Return on sales before interest and taxes.
2. Turnover of average assets.
3. Return on average assets before interest and taxes.
c. Would it be possible for Calcor Company to achieve the first two of Kuhn's goals without achieving his third goal of a 30% return on average assets before interest and taxes? Explain your answer.