Lecture 5 Excel Exercises v2

.xlsx
School
University of Kentucky **We aren't endorsed by this school
Course
FIN 410
Subject
Finance
Date
Oct 13, 2023
Pages
22
Uploaded by ElderFinchPerson853 on coursehero.com
Stock Valuation: DDM k 10% Time Dividend PV 1 $ 100 =C8/(1+$C$5)^B8 2 $ 105 3 $ 110 4 $ 115 5 $ 120 NPV NPV (2)
Stock Valuation: DDM k 10% Time Dividend PV 1 $ 100 $ 90.91 =C8/(1+$C$5)^B8 2 $ 105 $ 86.78 =C9/(1+$C$5)^B9 3 $ 110 $ 82.64 =C10/(1+$C$5)^B10 4 $ 115 $ 78.55 =C11/(1+$C$5)^B11 5 $ 120 $ 74.51 =C12/(1+$C$5)^B12 NPV $ 413.39 =SUM(D8:D12) NPV (2) $413.39 =NPV(C5,C8:C12)
Page1of 22
Uploaded by ElderFinchPerson853 on coursehero.com