Housing Values, Loans and Structured Finance in U.S. Housing Crisis

 

Many case studies can be introduced by working through analytical mistakes that were made in the U.S. housing crisis. As for all of the cases, a write-up is provided followed by videos and excel files. The excel exercises for the housing crisis discussion include techniques to download economic data into spreadsheets and how to create a financial model. Videos that demonstrate the analytical analysis are included in the table above.  The first file below is a database that can be updated and includes various statistics used to evaluate the sub-prime crisis that brought down the whole world economy.

 

Database with Real Estate Prices Including Pricing, Suppy and Demand Data for Evaluating U.S. Subprime Crisis

 

 

Chapter 2.pdf

CDO Exercise 1.xlsm

CDO Exercise 2.xlsm

CDO Exercise 3 – Break Even.xlsm

Housing Data.xlsm

Subject Excel File Video Link Chapter Reference Page Reference
Creating Structured Finance Model CDO Exercise 1 https://www.youtube.com/watch?v=6giYxjcmCUU Chapter 2 40
Two Way Data Table with Structured Finance Model CDO Exercise 2 https://www.youtube.com/watch?v=iGnjWYW-zIc Chapter 2 40
One Way Data Table with Structured Finance Model CDO Exercise 2 https://www.youtube.com/watch?v=Tip6i7pYEt4 Chapter 2 40
Break Even Analysis with Structured Finance Model CDO Exercise 3 https://www.youtube.com/watch?v=TSDpLt0-k3I Chapter 2 40
Scenario Analysis with Structured Finance Model CDO Exercise 4 Chapter 2 40
Tornado Analysis with Structured Finance Model CDO Exercise 5 Chapter 2 40
Downloading Data on Saudi Stock Bubble Saudi Stocks https://www.youtube.com/watch?v=C_Sz6-iO-OQ Chapter 2 40
Downloading Data on House Prices and Demand 1 Housing Data 1 https://www.youtube.com/watch?v=U-EJ2D1JVpM Chapter 16 193
Clearing Sheets to Enable Updating of Data Housing Data 1 https://www.youtube.com/watch?v=z-e1zefhZoc Chapter 16 193
Using Match, Index and Indirect to Summarize Downloaded Data Housing Data https://www.youtube.com/watch?v=PgLSc2AvU-Y Chapter 16 193
Creating Single Graph with #N/A and Index Housing Data https://www.youtube.com/watch?v=sGDDr7egXuo Chapter 16 193
Adjusting Nominal Data for Inflation Housing Data https://www.youtube.com/watch?v=L2TM2VG72MU Chapter 16 193
Creating Graph with multiple Series with TRUE/FALSE Housing Data https://www.youtube.com/watch?v=c8k8LrJobX4 Chapter 16 193
…………………………………………………………………………………………………….. ….. ………………………………….. …. …………………………………………………………………………………… …. ………………….. ……………….