Back to Acctg 455 Home Page

Download files for Chapter 11 (Right-click link, then click SAVE to download):

Download Excel files:
ACCTG455-Ch11.xlsx
ExcelShort57-59.xlsx (Goes with the three 2 minute short videos)

Download PowerPoint Slides: ACCTG455-Ch11.pptx (notes for this chapter)

Homework Template That You Complete And Upload In The Home Area of Canvas: ACCTG45-Ch11-Homework.xlsx

Videos to watch for chapter 11:

ACCTG 455: Excel Finance Class 103: 2 Ways To Calculate Geometric Mean (5 mins)

ACCTG 455: Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock (12 mins)

ACCTG 455 104.1: Expected Return & Standard Deviation for 2 Stocks: Single Cell Excel Spilled Array Formula #Short 57 (2 mins)

ACCTG 455: Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio (11 mins)

ACCTG 455: 105.1: Expected Return & Standard Deviation 4 Portfolio of Stocks Single Cell Excel Array Formula #Short 58 (2 mins) 

ACCTG 455: Excel Finance Class 106: Market & Asset Specific Risk, Diversification, Beta (14 mins)

ACCTG 455: Excel Finance Class 107: Calculating Beta (2 Methods) (11 mins)

ACCTG 455: Excel Finance Class 108: Reward To Risk Ratio - Treynor Index (6 mins)

ACCTG 455: Excel Finance Class 109: Beta For Portfolio (4 mins)

ACCTG 455 109.1: Stock Portfolio Expected Return & Beta with single cell array formula. Bonus Trick Too! #Short 59 (2 mins)

ACCTG 455: Excel Finance Class 110: Security Market Line (SML) & Capital Asset Pricing Model (CAPM) (9 mins)

ACCTG 455: Excel Finance Class 111: Treynor Index & CAPM (3 mins)