Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Go to Yahoo Finance, and search for MSFT (MSFT). Click on the historical Data tab, and pull the last 5 years of dividend (not stock
- Go to Yahoo Finance, and search for MSFT (MSFT). Click on the historical Data tab, and pull the last 5 years of dividend (not stock price) data into excel. Calculate the yearly dividend payout using the trailing 12-months (does not have to correspond to calendar year).
- If you use the most recent annual growth rate (not the average calculated in part a), what is the required rate that yields a price closest to the current trading price?
- If MSFT decides to not increase their dividend anymore, and keep it at $5 a year indefinitely, what is the price of the stock if investors require an 18% return?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Financial Analysis And Modeling Using Excel And VBA
Authors: Chandan Sengupta
2nd Edition
047027560X, 978-0470275603
