Develop a spreadsheet model for determining value, using the simple valuation function Value = D/(r - g),
Question:
Develop a spreadsheet model for determining value, using the simple valuation function Value = D/(r - g), where r is the discount rate =10% and g is the growth rate = 4% and D is dividend = 1.25. Use a two-way data table to determine value if g varies from 1% to 5% in increments of 1, and r varies from 8% to 16% in increments of 2%.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Question Posted: