Skip to content
  • Cart
  • My Account
  • Log In
  • Sign up Free!
  • My Courses
  • Shop FRM
  • Shop CFA
  • Forum
  • FAQs
  • Blog

Learning Spreadsheet: Mortgages and Mortgage-Backed Securities

Topic Progress:
← Back to Lesson

This learning spreadsheet covers the concepts in Part 1, Topic 3: Tuckman

  • Chapter 20: Mortgages and Mortgage-Backed Securities

Download Sample

Shop Courses
    

← Previous Topic

Upgrade Your Account <br />to Access More Content Upgrade Your Account
to Access More Content

Course Progress

0% Complete
0/301 Steps

Course Navigation

Course Home Expand All
Foundations of Risk Management
Introduction to Foundations of Risk Management
2 Topics
Instructional Video: Intro to Foundations of Risk
Learning Spreadsheet: Intro to VaR
Chapter 1: The Building Blocks of Risk Management
3 Topics
Study Notes: The Building Blocks of Risk Management
Practice Question Set: The Building Blocks of Risk Management
Instructional Video: The Building Blocks of Risk Management
Chapter 2: How Do Firms Manage Financial Risk?
2 Topics
Study Notes: How Do Firms Manage Financial Risk?
Practice Question Set: How Do Firms Manage Financial Risk?
Chapter 3: The Governance of Risk Management
2 Topics
Study Notes: The Governance of Risk Management
Practice Question Set: The Governance of Risk Management
Chapter 4. Credit Risk Transfer Mechanisms
2 Topics
Study Notes: Credit Risk Transfer Mechanisms
Practice Question Set: Credit Risk Transfer Mechanisms
Chapter 5: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
6 Topics
Study Notes: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Practice Question Set: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Instructional Video 1 of 2: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Instructional Video 2 of 2: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Learning Spreadsheet 1 of 2: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Learning Spreadsheet 2 of 2: Modern Portfolio Theory (MPT) and the Capital Asset Pricing Model (CAPM)
Chapter 6: The Arbitrage Pricing Theory and Multifactor Models of Risk and Return
4 Topics
Study Notes: APT and Multifactor Models of Risk and Return
Practice Question Set: APT and Multifactor Models of Risk and Return
Instructional Video: APT and Multifactor Models of Risk and Return
Learning Spreadsheet: APT and Multifactor Models of Risk and Return
Chapter 7: Principles for Effective Data Aggregation and Risk Reporting
2 Topics
Study Notes: Principles for Effective Data Aggregation and Risk Reporting
Practice Question Set: Risk Data Aggregation and Reporting Principles
Chapter 8: Enterprise Risk Management and Future Trends
2 Topics
Study Notes: Enterprise Risk Management (ERM) and Future Trends
Practice Question Set: ERM and Future Trends
Chapter 9: Learning from Financial Disasters
3 Topics
Study Notes: Learning from Financial Disasters
Practice Question Set: Learning from Financial Disasters
Instructional Video: Learning from Financial Disasters
Chapter 10: Anatomy of the Great Financial Crisis
3 Topics
Study Notes: Anatomy of the Great Financial Crisis
Practice Question Set: Anatomy of the Great Financial Crisis
Instructional Video: Anatomy of the Great Financial Crisis
Chapter 11: GARP Code of Conduct
2 Topics
Study Notes: GARP Code of Conduct
Practice Question Set: GARP Code of Conduct
Foundations of Risk Topic Review
4 Topics | 1 Quiz
Foundations of Risk Focus Review Video 1 of 2
Foundations of Risk Focus Review Video 2 of 2
Foundations of Risk Global Topic Review Question Set
Learning Spreadsheets: P1.T1.XLS Bundle
Foundations of Risk Management Interactive Quiz
Quantitative Analysis
Chapter 1: Fundamentals of Probability
4 Topics
Study Notes: Fundamentals of Probability
Practice Question Set: Fundamentals of Probability
Instructional Video: Fundamentals of Probability
Learning Spreadsheet: Fundamentals of Probability
Chapter 2: Random Variables
4 Topics
Study Notes: Random Variables
Practice Question Set: Random Variables
Instructional Video: Random Variables
Learning Spreadsheet: Random Variables
Chapter 3: Common Univariate Random Variables
4 Topics
Study Notes: Common Univariate Random Variables
Practice Question Set: Common Univariate Random Variables
Instructional Video: Common Univariate Random Variables
Learning Spreadsheet: Common Univariate Random Variables
Chapter 4: Multivariate Random Variables
2 Topics
Study Notes: Multivariate Random Variables
Practice Question Set: Multivariate Random Variables
Chapter 5: Sample Moments
2 Topics
Study Notes: Sample Moments
Practice Question Set: Sample Moments
Chapter 6: Hypothesis Testing
4 Topics
Study Notes: Hypothesis Testing
Practice Question Set: Hypothesis Testing
Instructional Video: Hypothesis Testing
Learning Spreadsheet: Hypothesis Testing
Chapter 7: Linear Regression
5 Topics
Study Notes: Linear Regression
Practice Question Set: Linear Regression
Instructional Video 1 of 2: Linear Regression
Instructional Video 2 of 2: Linear Regression
Learning Spreadsheet: Linear Regression
Chapter 8: Regression with Multiple Explanatory Variables
4 Topics
Study Notes: Regression with Multiple Explanatory Variables
Practice Question Set: Regression with Multiple Explanatory Variables
Instructional Video 1 of 2: Regression with Multiple Explanatory Variables
Instructional Video 2 of 2: Regression with Multiple Explanatory Variables
Chapter 9: Regression Diagnostics
2 Topics
Study Notes: Regression Diagnostics
Practice Question Set: Regression Diagnostics
Chapter 10: Stationary Time Series
4 Topics
Study Notes: Stationary Time Series
Practice Question Set: Stationary Time Series
Instructional Video: Stationary Time Series
Learning Spreadsheet: Stationary Time Series
Chapter 11: Nonstationary Time Series
4 Topics
Study Notes: Nonstationary Time Series
Practice Question Set: Nonstationary Time Series
Instructional Video: Nonstationary Time Series
Learning Spreadsheet: Nonstationary Time Series
Chapter 12: Measuring Return, Volatility, and Correlation
5 Topics
Study Notes: Measuring Return, Volatility, and Correlation
Practice Question Set: Measuring Return, Volatility, and Correlation
Instructional Video 1 of 2: Measuring Return, Volatility, and Correlation
Instructional Video 2 of 2: Measuring Return, Volatility, and Correlation
Learning Spreadsheet: Measuring Return, Volatility, and Correlation
Chapter 13: Simulation and Bootstrapping
4 Topics
Study Notes: Simulation and Bootstrapping
Practice Question Set: Simulation and Bootstrapping
Instructional Video: Simulation and Bootstrapping
Learning Spreadsheet: Simulation and Bootstrapping
Quantitative Analysis Topic Review
8 Topics | 1 Quiz
Quantitative Analysis Global Topic Review Question Set
Quantitative Focus Review Video (1 of 3)
Quantitative Focus Review Video (2 of 3)
Quantitative Focus Review Video (3 of 3)
Learning Spreadsheets: P1.T2.a XLS Bundle
Learning Spreadsheets: P1.T2.b XLS Bundle
Learning Spreadsheets: P1.T2.c XLS Bundle
Learning Spreadsheets: P1.T2.d XLS Bundle
Quantitative Analysis Quiz
Financial Markets & Products
Chapter 1: Banks
4 Topics
Study Notes: Banks
Practice Question Set: Banks
Instructional Video: Banks
Learning Spreadsheet: Banks
Chapter 2. Insurance Companies and Pension Plans
4 Topics
Study Notes: Insurance Companies and Pension Plans
Practice Question Set: Insurance Companies and Pension Plans
Instructional Video: Insurance Companies and Pension Plans
Learning Spreadsheet: Insurance Companies and Pension Plans
Chapter 3: Fund Management
4 Topics
Study Notes: Fund Management
Practice Question Set: Fund Management
Instructional Video: Fund Management
Learning Spreadsheet: Fund Management
Chapter 4. Introduction to Derivatives
4 Topics
Study Notes: Introduction to Derivatives
Practice Question Set: Introduction to Derivatives
Instructional Video: Introduction to Derivatives
Learning Spreadsheet: Introduction to Derivatives
Chapter 5: Exchanges and OTC Markets
3 Topics
Study Notes: Exchanges and OTC Markets
Practice Question Set: Exchanges and OTC Markets
Instructional Video: Exchanges and OTC Markets, Central Clearing & Futures Markets
Chapter 6: Central Clearing
3 Topics
Study Notes: Central Clearing
Practice Question Set: Central Clearing
Instructional Video: Central Clearing
Chapter 7: Futures Markets
3 Topics
Study Notes: Futures Markets
Practice Question Set: Futures Markets
Learning Spreadsheet: Futures Markets
Chapter 8: Using Futures for Hedging
4 Topics
Study Notes: Using Futures for Hedging
Practice Question Set: Using Futures for Hedging
Instructional Video: Using Futures for Hedging
Learning Spreadsheet: Using Futures for Hedging
Chapter 9: Foreign Exchange Markets
4 Topics
Study Notes: Foreign Exchange Markets
Practice Question Set: Foreign Exchange Markets
Instructional Video: Foreign Exchange Markets
Learning Spreadsheet: Foreign Exchange Markets
Chapter 10: Pricing Financial Forwards and Futures
4 Topics
Study Notes: Pricing Financial Forwards and Futures
Practice Question Set: Pricing Financial Forwards and Futures
Instructional Video: Pricing Financial Forwards and Futures
Learning Spreadsheet: Pricing Financial Forwards and Futures
Chapter 11: Commodity Forwards and Futures
4 Topics
Study Notes: Commodity Forwards and Futures
Practice Question Set: Commodity Forwards and Futures
Instructional Video: Commodity Forwards and Futures
Learning Spreadsheet: Commodity Forwards and Futures
Chapter 12: Options Markets
4 Topics
Study Notes: Options Markets
Practice Question Set: Options Markets
Instructional Video: Options Markets
Learning Spreadsheet: Options Markets
Chapter 13: Properties of Options
4 Topics
Study Notes: Properties of Options
Practice Question Set: Properties of Options
Instructional Video: Properties of Options
Learning Spreadsheet: Properties of Options
Chapter 14: Trading Strategies
3 Topics
Study Notes: Trading Strategies
Practice Question Set: Trading Strategies
Instructional Video: Trading Strategies
Chapter 15: Exotic Options
3 Topics
Study Notes: Exotic Options
Practice Question Set: Exotic Options
Instructional Video: Exotic Options
Chapter 16: Properties of Interest Rates
4 Topics
Study Notes: Properties of Interest Rates
Practice Question Set: Properties of Interest Rates
Instructional Video: Properties of Interest Rates
Learning Spreadsheet: Properties of Interest Rates
Chapter 17: Corporate Bonds
3 Topics
Study Notes: Corporate Bonds
Practice Question Set: Corporate Bonds
Instructional Video: Corporate Bonds
Chapter 18: Mortgages and Mortgage-Backed Securities
4 Topics
Study Notes: Mortgages and Mortgage-Backed Securities
Practice Question Set: Mortgages and Mortgage-Backed Securities
Instructional Video: Mortgages and Mortgage-Backed Securities
Learning Spreadsheet: Mortgages and Mortgage-Backed Securities
Chapter 19: Interest Rate Futures
4 Topics
Study Notes: Interest Rate Futures
Practice Question Set: Interest Rate Futures
Instructional Video: Interest Rate Futures
Learning Spreadsheet: Interest Rate Futures
Chapter 20: Swaps
4 Topics
Study Notes: Swaps
Practice Question Set: Swaps
Instructional Video: Swaps
Learning Spreadsheet: Swaps
Financial Markets & Products Topic Review
8 Topics | 1 Quiz
Financial Markets & Products Global Topic Review Question Set
Financial Markets & Products Focus Review Video (1 of 3)
Financial Markets & Products Focus Review Video (2 of 3)
Financial Markets & Products Focus Review Video (3 of 3)
Learning Spreadsheets: P1.T3.a XLS Bundle
Learning Spreadsheets: P1.T3.b XLS Bundle
Learning Spreadsheets: P1.T3.c XLS Bundle
Learning Spreadsheets: P1.T3.d XLS Bundle
Financial Markets & Products Quiz
Valuation & Risk Models
Chapter 1: Measures of Financial Risk
3 Topics
Study Notes: Measures of Financial Risk
Practice Question Set: Measures of Financial Risk
Instructional Video: Measures of Financial Risk
Chapter 2: Calculating and Applying VaR
4 Topics
Study Notes: Calculating and Applying VaR
Practice Question Set: Calculating and Applying VaR
Instructional Video: Calculating and Applying VaR
Learning Spreadsheet: Calculating and Applying VaR
Chapter 3: Measuring and Monitoring Volatility
3 Topics
Study Notes: Measuring and Monitoring Volatility
Practice Question Set: Measuring and Monitoring Volatility
Instructional Video: Measuring and Monitoring Volatility
Chapter 4. External and Internal Ratings
3 Topics
Study Notes: External and Internal Ratings
Practice Question Set: External and Internal Ratings
Instructional Video: External and Internal Ratings
Chapter 5: Country Risk: Country Risk: Determinants, Measures, and Implications
3 Topics
Study Notes: Country Risk: Country Risk: Determinants, Measures, and Implications
Practice Question Set: Country Risk: Country Risk: Determinants, Measures, and Implications
Instructional Video: Country Risk: Country Risk: Determinants, Measures, and Implications
Chapter 6: Measuring Credit Risk
2 Topics
Study Notes: Measuring Credit Risk
Practice Question Set: Measuring Credit Risk
Chapter 7: Operational Risk
1 Topic
Study Notes: Operational Risk
Chapter 8: Stress Testing
3 Topics
Study Notes: Stress Testing
Practice Question Set: Stress Testing
Instructional Video: Stress Testing
Chapter 9: Pricing Conventions, Discounting, and Arbitrage
4 Topics
Study Notes: Pricing Conventions, Discounting, and Arbitrage
Practice Question Set: Pricing Conventions, Discounting, and Arbitrage
Instructional Video: Pricing Conventions, Discounting, and Arbitrage
Learning Spreadsheet: Pricing Conventions, Discounting, and Arbitrage
Chapter 10: Interest Rates
3 Topics
Study Notes: Interest Rates
Practice Question Set: Interest Rates
Instructional Video: Interest Rates
Chapter 11: Bond Yields and Return Calculations
3 Topics
Study Notes: Bond Yields and Return Calculations
Practice Question Set: Bond Yields and Return Calculations
Instructional Video: Bond Yields and Return Calculations
Chapter 12: Applying Duration, Convexity, and DV01
3 Topics
Study Notes: Applying Duration, Convexity, and DV01
Practice Question Set: Applying Duration, Convexity, and DV01
Instructional Video: Applying Duration, Convexity, and DV01
Chapter 13: Modeling and Hedging Non-Parallel Term Structure Shifts
3 Topics
Study Notes: Modeling and Hedging Non-Parallel Term Structure Shifts
Practice Question Set: Modeling and Hedging Non-Parallel Term Structure Shifts
Instructional Video: Modeling and Hedging Non-Parallel Term Structure Shifts
Chapter 14: Binomial Trees
4 Topics
Study Notes: Binomial Trees
Practice Question Set: Binomial Trees
Instructional Video: Binomial Trees
Learning Spreadsheet: Binomial Trees
Chapter 15: The Black-Scholes-Merton Model
4 Topics
Study Notes: The Black-Scholes-Merton Model
Practice Question Set: The Black-Scholes-Merton Model
Instructional Video: The Black-Scholes-Merton Model
Learning Spreadsheet: The Black-Scholes-Merton Model
Chapter 16: Option Sensitivity Measures: The “Greeks”
4 Topics
Study Notes: Option Sensitivity Measures: The “Greeks”
Practice Question Set: Option Sensitivity Measures: The “Greeks”
Instructional Video: Option Sensitivity Measures: The “Greeks”
Learning Spreadsheet: Option Sensitivity Measures: The “Greeks”
Valuation & Risk Models Topic Review
8 Topics | 1 Quiz
Valuation & Risk Models Global Topic Review Question Set
Valuation and Risk Models Focus Review Video (1 of 3)
Valuation and Risk Models Focus Review Video (2 of 3)
Valuation and Risk Models Focus Review Video (3 of 3)
Learning Spreadsheets: P1.T4.a XLS Bundle
Learning Spreadsheets: P1.T4.b XLS Bundle
Learning Spreadsheets: P1.T4.c XLS Bundle
Learning Spreadsheets: P1.T4.e XLS Bundle
Valuation & Risk Models Quiz
PART I REVIEW
Mock Exams
2 Quizzes
Part 1 Full Length Interactive Mock Exam 1
Part 1 Full Length Interactive Mock Exam 2
Formula Sheets
1 Topic
Part 1 Formula Sheets
Return to FRM Part 1 Professional
  • About Us
  • Your Bionic Turtle Team
  • Testimonials
  • FAQs
  • Contact Us
  • Why Take the Exam?
  • FRM Exam Overview, Registration Guide and Deadlines
  • Why is FRM Certification Important?
  • FRM Study Guide
  • Comparison of the FRM and CFA Designations
  • The Vast Selection of FRM Jobs
  • Exam Preparation
  • Using an FRM Course
  • My Courses
  • Shop FRM
  • Shop CFA

Stay connected

We'll keep you informed on new forum posts, relevant blog articles, and everything you'll need to prepare for your exam.
  • This field is for validation purposes and should be left unchanged.
  • Privacy Policy
  • Terms of Use
  • Affiliate Disclosure
  • Become an Affiliate

© Copyright 2021 – Bionic Turtle