Please, answer these three problems in one Exel file and one problem per sheet.,1. You are to compute a five year average of the following ratios for these three companies: Coca Cola, Disney, and Noble Energy. These three companies cannot be the companies that you used in your week five discussion. The ratios to complete are:,a. Retention rate,b. Net profit margin,c. Equity turnover,d. Total asset turnover,e. Total assets/equity,,2. Indian River Citrus earned $6.00 per share last year and paid a dividend of $2.40 a share. Next year, you expect Indian River to earn $6.50 per share and continue its payout ratio. Assume you expect to sell the stock for $60 a year from now. If you require a 14% return on this stock, how much would you be willing to pay for it today?,,3. Currently, the dividend-payout ratio (D/E) for the aggregate market is 50 percent, the required return (k) is 8 percent, and the expected growth rate for dividends (g) is 3 percent. ,a. Compute the current earnings multiplier,b. You expect the D/E ratio to decline to 40 percent, but you assume there will be no other changes. What will be the P/E?,c. Starting with the initial conditions, you expect the dividend-payout ratio to be constant, the rate of inflation to increase by 3 percent, and the growth rate to increase by 2 percent. Compute the expected P/E. ,d. Starting with the initial conditions, you expect the dividend-payout ratio to be constant, the rate of inflation to decline by 3 percent, and the growth rate to decline by 1 percent. Compute the expected P/E. ,,Thank you ,
Regent Papers is a library of common essays on high school, college, undergraduate and postgraduate topics. We have collected top papers from various institution, students and professors. The papers are based on common essay topics in all subjects.
2922 Oak Grove Drive La Cañada Flintridge, CA 91521.