Excel template - Saved File Home Insert Data Review View Help Tell me what you want to do OComments X Cut Arial v 10 v A* A" ab wrap Text S AutoSum v A Copy в IUD ab E== E E E Merge & Center v $ • % , 8 8 Paste Conditional Format Insert Delete Format O Clear Sort & Find & S Format Painter Formatting as Table v Filter - Select v Undo Clipboard Font Alignment Number Tables Cells Editing C14 fe A Н K M. 1 Nonconstant growth 3 Year 3 Dividend, D3 4 Supernormal growth rate, g, 5 Normal growth rate, g, 6 Required return, r, $0.50 28.00% 10.00% 16.00% 28.00% 28.00% 10.00% 9. Dividends $0.50 10 Ps 11 Cash flows to common stockholders 12 13 PV of cash flows to common stockholders 14 Stock Price, P. 15 16 Alternatively, using Excel NPV function: 17 Stock Price, P. 18 19 20 Formulas 21 28.00% 28.00% 10.00% 22 3 4 #NIA 6. 23 nividends In $n 5000 #N/A #NIA File Home Insert Data Review View Help Tell me what you want to do OComm X Cut Arial v 10 A* A ab Wrap Text > AutoSum A Copy в IUDab $ - % 9 58 Paste | Merge & Center v 8 Formatting - as Table Conditional Format Insert Delete Format Sort & Find & .00 A. O Clear v S Format Painter Filter - Select v ndo Clipboard Alignment Number Cells Editing Font Tables 14 fx A н K. O Ps 1 Cash flows to common stockholders 2 3 PV of cash flows to common stockholders 4 Stock Price, Po 6 Alternatively, using Excel NPV function: 7 Stock Price, P. Formulas 28.00% 28.00% 10.00% 1 4 6 3 Dividends $0.5000 #N/A #N/A #N/A 4 P5 5 Cash flows to common stockholders #N/A #N/A #N/A #N/A 7 PV of cash flows to common stockholders 8 Stock Price, P. #N/A #N/A #N/A #N/A #N/A #N/A -0 Alternatively, using Excel NPV function: 1 Stock Price, P. 2 #N/A
Dividend Valuation
Dividend refers to a reward or cash that a company gives to its shareholders out of the profits. Dividends can be issued in various forms such as cash payment, stocks, or in any other form as per the company norms. It is usually a part of the profit that the company shares with its shareholders.
Dividend Discount Model
Dividend payments are generally paid to investors or shareholders of a company when the company earns profit for the year, thus representing growth. The dividend discount model is an important method used to forecast the price of a company’s stock. It is based on the computation methodology that the present value of all its future dividends is equivalent to the value of the company.
Capital Gains Yield
It may be referred to as the earnings generated on an investment over a particular period of time. It is generally expressed as a percentage and includes some dividends or interest earned by holding a particular security. Cases, where it is higher normally, indicate the higher income and lower risk. It is mostly computed on an annual basis and is different from the total return on investment. In case it becomes too high, indicates that either the stock prices are going down or the company is paying higher dividends.
Stock Valuation
In simple words, stock valuation is a tool to calculate the current price, or value, of a company. It is used to not only calculate the value of the company but help an investor decide if they want to buy, sell or hold a company's stocks.
Computech Corporation is expanding rapidly and currently needs to retain all of its earnings; hence, it does not pay dividends. However, investors expect Computech to begin paying dividends, beginning with a dividend of $0.50 coming 3 years from today. The dividend should grow rapidly - at a rate of 28% per year - during Years 4 and 5; but after Year 5, growth should be a constant 10% per year. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.
If the required return on Computech is 16%, what is the value of the stock today? Round your answer to the nearest cent. Do not round your intermediate calculations.
$
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
