Over 50 years of mortgage rates analyzed in Excel

In this video, I demonstrate how to download 30-year mortgage loan data from the Federal Reserve Bank and analyze it using Excel. I guide you through the steps of formatting the data, creating charts, and performing various calculations, including averages, medians, and conditional formatting. I also discuss the impact of changing interest rates on mortgage payments and home prices and provide insights into historical mortgage rates over the past 53 years. Stay tuned for more updates following the Federal Reserve's upcoming meeting.

00:00 Introduction and Overview
00:26 Downloading Data from the Federal Reserve Bank
01:14 Preparing and Formatting Data in Excel
04:58 Creating and Customizing Charts
05:53 Analyzing Mortgage Rates
11:47 Conditional Formatting and Advanced Analysis
13:04 Calculating Mortgage Payments
17:08 Conclusion and Upcoming Content

And make sure you subscribe to my channel!

Data Source for Mortgage Rates - Federal Reserve Bank of ST. Louis
https://fred.stlouisfed.org/series/MO...

Blog Post https://chrismenardtraining.com/post/...

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!