Скачать
Dividend Discount Model Valuation in Excel
Автор: Jonathan Kalodimos, PhD
Загружено: 2017-02-27
Просмотров: 7032
Описание:
Suppose a company over the next five years is going to pay the following stream of dividends:
year 1 = $5
year 2 = $5
year 3 = $9
year 4 = $7
year 5 = $10
Starting in year 6 the company's dividend is going to grow at 6% until year 10, and then will grow at 2% forever. Suppose the company has a beta of 1.2, the risk-free rate is 2%, and the market risk premium is 6%. What is the price of the company's stock?
This is a supplement to my teaching. This is an example of how to setup a simple valuation problem in Excel. The spreadsheet is available here: https://goo.gl/HFGrPi
Не удается загрузить Youtube-плеер. Проверьте блокировку Youtube в вашей сети.
Повторяем попытку...
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
