Download files for Chapter 07 (Right-click link, then click SAVE to download):
Download Excel files:
ACCTG455-Ch07.xlsx
ExcelShort49-50.xlsx (Goes with the two one minute short videos)
Download PowerPoint Slides: ACCTG455-Ch7.pptx (notes for this chapter)
Helpful one page PDF Handout With Stock Valuation Formulas: ACCTG455-Ch07-StockValuationFormulaModels.pdf
Videos to watch for chapter 07:
ACCTG 455: Excel Finance Class 59: Common & Preferred Stock (
Only watch up through minute mark 05:30: ACCTG 455: Excel Finance Class 60: Basics Of Financial Markets then watch:
An Inside Look At The New York Stock Exchange (16 mins)
Why the NYSE Trading Floor Is a Lot Quieter These Days (2 mins)
ACCTG 455: Excel Finance Class 61: Stock Value Based on Present Value of Future Dividend Cash Flows. (9 mins)
ACCTG 455: Excel Finance Class 62: Preferred Stock Valuation as A Perpetuity (3 mins)
ACCTG 455: Excel Finance Class 63: Stock Valuation with Dividend Growth Model (5 mins)
ACCTG 455 #63.1: Visualize How Stock Values Changes as Dividend Growth Rate Changes. #Short 49 (1 min)
ACCTG 455 #63.2: Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50 (2 min)
No Video 64.
ACCTG 455: Excel Finance Class 65: Calculate Stock Price at Time t using Dividend Growth Model (7 mins)
ACCTG 455: Excel Finance Class 66: Calculate Implied Return using Dividend Growth Model (4 mins)
ACCTG 455: Excel Finance Class 67: Irregular Dividend PMTs and Constant Growth: Stock Valuation. (13 mins)