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

 

 

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
……………………………………………………………………………………………………..	…..	…………………………………..	….	……………………………………………………………………………………	….	…………………..	…	……………….