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
SiteLock