Home » Spreadsheets and Other Material

Spreadsheets and Other Material

 

If you are having difficulty opening the Word or Excel documents on this website, click on the circle just to the left of the URL in the address bar. Select “Site Settings”. Scroll down to “Insecure Content” and change it from “Block” to “Allow”. This should solve the problem. 

Maximizing Utility (There is a Video for this Spreadsheet)
Two Risky Assets (There is a Video for this Spreadsheet)
The MVE Portfolio with 2 Risky Assets (There is a Video for this Spreadsheet)
Efficient Frontier for 8 Stocks (There is a Video for this Spreadsheet)
Fama-French Monthly Data thru 2024
Fama-French Weekly data thru 2024
Calculating Beta for JPM with Monthly Data thru 12-24 (There is a Video for this Spreadsheet and the next one)
Calculating Beta for JPM with Two Years of Weekly Data thru 12-24
Fama French Tables
FF and CAPM for AAPL with Monthly Data thru 12-24 (There is a Video for this Spreadsheet)
Basic Bond Price and Yield    (There is a Video for this Spreadsheet)
Bond Price and Yield Using Excel (There is a Video for this Spreadsheet)
Treasury Quotes
Yield Curve
TIPS Quotes
Bond Ratings
Factors Affecting Int. Rate Risk Example (There is a Video for this Spreadsheet)
Duration and Modified Duration Examples (There is a Video for this Spreadsheet)
BF Questions
Finding Beta (There is a Video for this Spreadsheet)