1. Using the CEO's program, prepare a schedule that shows the appropriate data for the years 2017, 2018, and 2019 for the items numbered 1 through 7 on the preceding schedule. Enter answers in dollars rounded to the nearest cent. To enter ratios, round your answer to four decimal places before converting to a percentage and enter your percentage answer rounded to two decimal places. For example, .88349 would be rounded to.8835 and entered as 88.35 Enter all amounts as positive numbers. Sunrise Corp. Schedule of Financial Data For the Years 2017, 2018 and 2019 2019 2018 2017 1. Sales 2. Net income $ $ $ $ $ $ 3. Dividends declared and paid $ 4. Owners' equity, December 31 $ ' , 5. Debt, December 31 $ 6. Return on owners' equity 7. Debt to total assets $ $ % % % % % % 2. Can the CEO meet all of her requirements if a 10% per-year growth in income and sales is achieved? Explain your answer. 3. The CEO can improve the return on equity by doing a. all of these. b. reduce costs to improve profit margins. c. focus on more profitable product lines. d. increase total asset turnover. 4. What reason(s) might prevent the CEO from raising the debt-equity ratio to a very high level? a. Resulting higher cost of debt due to increased risk and a potential drop in stock price. b. Potential increase in cost of goods sold. C. All of these. d. Reduction in total asset turnover ratio. Soals for Sales and Income Growth Sunrise 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. Sunrise Corp. 2016 2015 2014 $201,000 $193,000 $188,000 6,030 5,790 5,640 2,500 2,500 2,500 68,120 71,790 28,710 64,830 29,170 28,380 1. Sales 2. Net Income 3. Dividends declared and paid December 31 balances: 4. Owners' equity 5. Debt Selected year-end financial ratios Net income to sales Asset turnover 5. Return on owners' equity * 7. Debt to total assets *Based on year-end balances in owners' equity 3.0 % 3.0 % 2 times 8.4 % 28.6 % 3.0 % 2 times 8.5 % 2 times 8.7 % 31.0 % 29.4 % 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, she wants to improve the return on equity and dividends. She 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 50% of earnings or $3,000, whichever is larger. The 10% annual sales increase will be accomplished through a new promotional 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. She expects that the ompany 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 35% of total liabilities and owners' equity