Sunset Corp. is a major regional retailer. The chief executive officer (CEO) is concerned with the slow growth both of sales and of net income and the subsequent effect on the trading price of the common stock. Selected financial data for the past three years follow.

The CEO believes that the price of the stock has been adversely affected by the downward trend of the return on equity, the relatively low dividend payout ratio, and the lack of dividend increases. To improve the price of the stock, he wants to improve the return on equity and dividends. He believes that the company should be able to meet these objectives by (1) increasing sales and net income at an annual rate of 10% a year and (2) establishing a new dividend policy that calls for a dividend payout of 60% of earnings or $2,000,000, whichever is larger. The 10% annual sales increase will be accomplished through a product enhancement program. The president believes that the present net income to sales ratio of 3% will be unchanged by the cost of this new program and any interest paid on new debt. He expects that the company can accomplish this sales and income growth while maintaining the current relationship of total assets to sales. Any capital that is needed to maintain this relationship and that is not generated internally would be acquired through long-term debt financing. The CEO hopes that debt would not exceed 25% of total liabilities and stockholders€™ equity.
Required
1. Using the CEO€™s program, prepare a schedule that shows the appropriate data for the years 2011, 2012, and 2013 for the items numbered 1 through 7 on the preceding schedule.
2. Can the CEO meet all of his requirements if a 10% per-year growth in income and sales is achieved? Explain your answers.
3. What alternative actions should the CEO consider to improve the return on equity and to support increased dividend payments?
(CMA adapted)

Sunset Corp (in millions) 2010 $100.0 1.2 2009 2008 $93.3 1.2 1. Sales 2. Net income 3. Dividends declared and paid December 31 balances 4. Stockholders' equity 5. Debt Selected yearend financial ratios $96.7 2.9 1.2 40.0 10.0 38.2 10.2 36.5 10.2 3.0% 2 times 75% 20.0% 3.0% 2 times 7.7% 21.8% Net income to sales Asset turnover 6. Return on stockholders' equity* 7 Debt to total assets Based on year-end balances in stockholders' equity 3.0% 2 times 16% 21.1%