#### Details of this Paper

##### Please, answer these three problems in one Exel fi...

**Description**

Solution

**Question**

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,Please, I want to emphasize that is one excel file and one problem per sheet. One more thin; please leave the three first rows of every sheet in blank in order to identify each problem at the beginning of the sheet. Thank you

Paper#8475 | Written in 18-Jul-2015

Price :*$25*