Download files for Chapter 10 (Right-click link, then click SAVE to download):
Download Excel file: ACCTG455-Ch10.xlsx
Download PowerPoint Slides: ACCTG455-Ch10.pptx (notes for this chapter)
Videos to watch for chapter 10:
ACCTG 455: Excel Finance Class 90: Period (Holding) Returns For Stock (6 mins)
ACCTG 455: Excel Finance Class 91: Period (Holding) Nominal, Real & Dollar Returns For Coupon Bond (4 mins)
ACCTG 455: Excel Finance Class 92: Period (Holding) Returns For Zero Bond (4 mins)
ACCTG 455: Excel Finance Class 93: Period (Holding) Returns For Preferred Stock (3 mins)
ACCTG 455: Excel Finance Class 94: Period (Holding) Returns For Less Than 1 Year, APR and EAR (5 mins)
ACCTG 455: Excel Finance Class 95: Use Past Period Holding Returns to Estimate Future Returns: Mean (4 mins)
ACCTG 455: Excel Finance Class 96: Compare Geometric Mean & Arithmetic Mean For Average Stock Return (16 mins)
ACCTG 455: Excel Finance Class 97: Using Geometric Mean & Arithmetic Mean to Estimate Future Returns (4 mins)
ACCTG 455: Excel Finance Class 98: Stock Return Risk Measured with Standard Deviation (11 mins)
ACCTG 455: Excel Finance Class 99: US Capital Market History 5 Types Investments (2 Good Lessons) (21 mins)
ACCTG 455: Excel Finance Class 100: Real Rate and Inflation or Deflation For T-bills. (4 mins)
ACCTG 455: Excel Finance Class 101: Average Real Return For A Stock Based On Historical Data (3 mins)
ACCTG 455: Excel Finance Class 102: Short Run Financial Markets Can Be Inefficient Mispriced Assets (4 mins)
Extra (Not Required):
Excel's Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55 (2 mins)
Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56 (2 mins)
Download Excel file: ExcelShort55-56.xlsx