MODULE 6 - SPREADSHEET

MODULE 6 - SPREADSHEET - Branscome expected dividend Fill...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Branscome expected dividend Fill in numbers in the blue according to problem. ??? Percent per year rate of return on investment. --> 24 the end of her investment (holding) period in ???? Years. --> 1 1/2 52 1/2 The expected growth rate is a nominal ??% annualized quarterly rate. --> 21% End of Question Enter 2 for Semi, 4 for Quarterly, 12 for Monthly, etc. --> 4 Answer 71.37 Example Problem ??? Percent per year rate of return on investment. --> 24 the end of her investment (holding) period in ???? Years. --> 1 1/2 52 1/2 The expected growth rate is a nominal ??% annualized quarterly rate. --> 21% End of Question Enter 2 for Semi, 4 for Quarterly, 12 for Monthly, etc. --> 4 Answer 71.37 Sharon Branscome is considering buying the common stock of Altria Group (previously named Philip Morris). requires a nominal ???? percent per year rate of return on investment in stocks with Altria's beta of (I dont th She expects the stock price to be (doesnt matter) at the end of her investment (holding) period in ??? years . The most recent quarterly dividend (at time t=0) was ??? . The expected growth rate is a nominal ???% a rate. The most recent quarterly dividend (at time t=0) was ??? cents --> The most recent quarterly dividend (at time t=0) was ??? cents --> . Ms. Branscome think matters 1.05). . nnualized quarterly Branscome PV of dividends Enter numbers in blue as you see them in your problem. ??? Percent per year rate of return on investment. --> the end of her investment (holding) period in ???? Years. --> and she expects the dividend to grow at a nominal ??% annualized XXXXXX-ly rate. --> End of Question Enter 2 for Semi, 4 for Quarterly, 12 for Monthly, etc. --> Answer Example Problem Enter numbers in blue as you see them in your problem. ??? Percent per year rate of return on investment. --> the end of her investment (holding) period in ???? Years. --> and she expects the dividend to grow at a nominal ??% annualized XXXXXX-ly rate. --> End of Question Enter 2 for Semi, 4 for Quarterly, 12 for Monthly, etc. --> Answer Sharon Branscome is considering buying the common stock of Altria Group. She requires a nominal ??? percent per year rate of return on investment in stocks with a Aaltria's beta of (doesnt matter I think 1.05). Ms. Branscome expects the stock price to be (doesnt matter I think $97.88) at the end of her investment (holding) period in ??? years ....
View Full Document

This note was uploaded on 05/10/2010 for the course FINA 3770 taught by Professor Chandy during the Fall '08 term at North Texas.

Page1 / 40

MODULE 6 - SPREADSHEET - Branscome expected dividend Fill...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online