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 ,