If you are looking for a return of at least 10%, what would you invest in a company, given that its just paid a dividend of 1.80, and estimates a growth rate of 3%?
Please use calculations for excel

If you are looking for a return of at least 10%, what would you invest in...
A company just paid a dividend of 2.30 to its shareholders. It estimates that future growth will be at 2%. What is the value of the stock, if you are looking for an 8% return on your investment? What led you to this answer?
4. The preferred stock of You Corp pays a $3.75 dividend. What is the value of the stock of your required return is 8.5%? Look at valuation for preferred stock 5. You are looking to invest in a company that has 10.5% return on equity and retains 60% of its earnings for reinvestment purposes. The company recently paid a dividend of $3.75 and the stock is currently selling for $45. Look at valuation for common stock A) What is the...
Storico Co. just paid a dividend of $3.02 per share. The company will increase its dividend by 20 percent next year and will then reduce its dividend growth rate by 5 percentage points per year until it reaches the industry average of 5 percent dividend growth, after which the company will keep a constant growth rate forever. If the required return on Storico stock is 13 percent, what will a share of stock sell for today? (Do not round intermediate...
Principles of Finance-FIN 343 Ou-Chapter 10 Ac h os Return on Equity (ROE) of 15 ON and retains 60.0% of its earnings Clate the expected Constant Growth Rate (XXX): 19points) 2 A company paid a $3.00 dividend last year. Assume a constant growth rate of 5.0% anda required rate of return of 15.0% Calculate the Stock Price (SX.XX): 19 points) 3. A company paid a $4.00 dividend last year. Assume that the company's ROE is 20.0%, its retention rate is...
A. Company DBC has just paid a dividend of $3. As DBC is a young company and successful, it is estimated that they will grow at rate of 20% for 5 years and then at 3% in perpetuity. The company faces a required return on equity of 7%. What is the current price of the company’s stock using the DDM model? Use excel for all calculations. B.Describe how sensitive your calculation in part A is to changes in the perpetual...
5. What price would you pay for a stock that just paid a $1 dividend has a 6% growth rate, if your required rate of return is 15%?
You decided AAPL is a stock fit for using dividend discount model. You expect the company's dividend to growth at 15% for the next 3 years, follow by 12% for another 3 years. Then, the growth rate will slow down to 8% a year. The require return for the company is 11%. The company paid $2.8 in dividend last year. What should be the price for AAPL today? Please do this in Excel and show formulas.
Use the PV function in Excel to calculate what you would have to invest in a savings account today if you wanted to accumulate $1,216.65 in five years and could invest at 4% per year with interest paid and compounded annually.
Please show answer in excel format
Chapter 9, Fundamentals of Financial Management Storico Co. just paid a dividend of $2.65 per share. The company will increase its dividend by 20 percent next year and will then reduce its dividend growth rate by 5 percentage points per year until it reaches the industry average of 5 percent dividend growth, after which the company will keep a constant growth rate forever. If the required return on Storico stock is 12 percent, what...
please use excel formula to show work, Thank You
Maloney, Inc., has an odd dividend policy. The company has just paid a dividend of $3.50 per share and has announced that it will increase the dividend by $4.50 per share for each of the next five years, and then never pay another dividend. If you require a return of 11 percent on the company's stock, how much will you pay for a share today? Current dividend Dividend growth Required return...