Graph and download economic data for Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks (TMBACBW027NBOG) from 2009-07-01 to 2025-11-19 about mortgage-backed, agency, Treasury, securities, banks, depository institutions, and USA.

United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks was 2709.00150 Bil. of U.S. $ in November of 2025, according to the United States Federal Reserve. Historically, United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks reached a record high of 2995.76070 in February of 2022 and a record low of 958.72110 in October of 2009. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks - last updated from the United States Federal Reserve on December of 2025.

United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Foreign-Related Institutions was 20.60000 % Chg. at Annual Rate in September of 2025, according to the United States Federal Reserve. Historically, United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Foreign-Related Institutions reached a record high of 253.10000 in December of 2017 and a record low of -217.60000 in January of 2023. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Foreign-Related Institutions - last updated from the United States Federal Reserve on November of 2025.

Graph and download economic data for Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks (H8B1301NCBCQG) from Q4 2009 to Q3 2025 about mortgage-backed, agency, Treasury, securities, banks, depository institutions, and USA.

United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Foreign-Related Institutions was 30.00000 % Chg. at Annual Rate in July of 2025, according to the United States Federal Reserve. Historically, United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Foreign-Related Institutions reached a record high of 89.40000 in April of 2015 and a record low of -104.30000 in January of 2023. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Foreign-Related Institutions - last updated from the United States Federal Reserve on November of 2025.

The year 2021 saw the peak in issuance of residential mortgage backed securities (MBS), at *** trillion U.S. dollars. Since then, MBS issuance has slowed, reaching *** trillion U.S. dollars in 2023. What are mortgage backed securities? A mortgage backed security is a financial instrument in which mortgages are bundled together and sold to investors. The idea is that the risk of these individual mortgages is pooled when they are packaged together. This is a sound investment policy, unless the foreclosure rate increases significantly in a short amount of time. Mortgage risk Since mortgages are loans backed by an asset, the house, the risk is often considered relatively low. However, the loan maturities are very long, sometimes decades, meaning lenders must factor in the risk of a shift in the economic climate. As such, interest rates on longer mortgages tend to be higher than on shorter loans. The ten-year treasury yield influences these rates, since it is a long-term rate that most investors accept as risk-free. Additionally, a decline in the value of homeowner equity could lead to a situation where the debtor is “underwater” and owes more than the home is worth.

United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks was 1.70000 % Chg. at Annual Rate in July of 2025, according to the United States Federal Reserve. Historically, United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks reached a record high of 27.30000 in October of 2020 and a record low of -10.30000 in October of 2022. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks - last updated from the United States Federal Reserve on November of 2025.

United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks was 3.70000 % Chg. at Annual Rate in October of 2025, according to the United States Federal Reserve. Historically, United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks reached a record high of 40.80000 in July of 2010 and a record low of -17.50000 in October of 2023. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), All Commercial Banks - last updated from the United States Federal Reserve on December of 2025.

Graph and download economic data for Assets: Securities Held Outright: Mortgage-Backed Securities: Wednesday Level (WSHOMCB) from 2002-12-18 to 2025-10-29 about outright, mortgage-backed, securities, assets, and USA.

United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Domestically Chartered Commercial Banks was 1.20000 % Chg. at Annual Rate in July of 2025, according to the United States Federal Reserve. Historically, United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Domestically Chartered Commercial Banks reached a record high of 27.70000 in October of 2020 and a record low of -10.50000 in October of 2022. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Domestically Chartered Commercial Banks - last updated from the United States Federal Reserve on November of 2025.

DESCRIPTION

A banking institution requires actionable insights into mortgage-backed securities, geographic business investment, and real estate analysis. The mortgage bank would like to identify potential monthly mortgage expenses for each region based on monthly family income and rental of the real estate. A statistical model needs to be created to predict the potential demand in dollars amount of loan for each of the region in the USA. Also, there is a need to create a dashboard which would refresh periodically post data retrieval from the agencies. The dashboard must demonstrate relationships and trends for the key metrics as follows: number of loans, average rental income, monthly mortgage and owner’s cost, family income vs mortgage cost comparison across different regions. The metrics described here do not limit the dashboard to these few. Dataset Description

Variables

Description Second mortgage Households with a second mortgage statistics Home equity Households with a home equity loan statistics Debt Households with any type of debt statistics Mortgage Costs Statistics regarding mortgage payments, home equity loans, utilities, and property taxes Home Owner Costs Sum of utilities, and property taxes statistics Gross Rent Contract rent plus the estimated average monthly cost of utility features High school Graduation High school graduation statistics Population Demographics Population demographics statistics Age Demographics Age demographic statistics Household Income Total income of people residing in the household Family Income Total income of people related to the householder Project Task: Week 1

Data Import and Preparation:

Import data.

Figure out the primary key and look for the requirement of indexing.

Gauge the fill rate of the variables and devise plans for missing value treatment. Please explain explicitly the reason for the treatment chosen for each variable.

Exploratory Data Analysis (EDA):

Perform debt analysis. You may take the following steps:

Explore the top 2,500 locations where the percentage of households with a second mortgage is the highest and percent ownership is above 10 percent. Visualize using geo-map. You may keep the upper limit for the percent of households with a second mortgage to 50 percent

Use the following bad debt equation:

Bad Debt = P (Second Mortgage ∩ Home Equity Loan) Bad Debt = second_mortgage + home_equity - home_equity_second_mortgage Create pie charts to show overall debt and bad debt

Create Box and whisker plot and analyze the distribution for 2nd mortgage, home equity, good debt, and bad debt for different cities

Create a collated income distribution chart for family income, house hold income, and remaining income

Perform EDA and come out with insights into population density and age. You may have to derive new fields (make sure to weight averages for accurate measurements):

Use pop and ALand variables to create a new field called population density

Use male_age_median, female_age_median, male_pop, and female_pop to create a new field called median age

Visualize the findings using appropriate chart type

Create bins for population into a new variable by selecting appropriate class interval so that the number of categories don’t exceed 5 for the ease of analysis.

Analyze the married, separated, and divorced population for these population brackets

Visualize using appropriate chart type

Please detail your observations for rent as a percentage of income at an overall level, and for different states.

Perform correlation analysis for all the relevant variables by creating a heatmap. Describe your findings.

Project Task: Week 2

Data Pre-processing:

The economic multivariate data has a significant number of measured variables. The goal is to find where the measured variables depend on a number of smaller unobserved common factors or latent variables.

Each variable is assumed to be dependent upon a linear combination of the common factors, and the coefficients are known as loadings. Each measured variable also includes a component due to independent random variability, known as “specific variance” because it is specific to one variable. Obtain the common factors and then plot the loadings. Use factor analysis to find latent variables in our dataset and gain insight into the linear relationships in the data.

  Following are the list of latent variables:

Highschool graduation rates

Median population age

Second mortgage statistics

Percent own

Bad debt expense

Data Modeling :

Build a linear Regression model to predict the total monthly expenditure for home mortgages loan.

  Please refer deplotment_RE.xlsx. Column hc_mortgage_mean is predicted variable. This is the mean monthly mortgage and owner costs of specified geographical location.

  Note: Exclude loans from prediction model which have NaN (Not a Numb...

Other-Cashflows-From-Financing-Activities Time Series for PennyMac Mortgage Investment Trust. PennyMac Mortgage Investment Trust, through its subsidiary, primarily invests in residential mortgage-related assets in the United States. The company operates through: Credit Sensitive Strategies, Interest Rate Sensitive Strategies, Correspondent Production segments. The Credit Sensitive Strategies segment invests in credit risk transfer (CRT) agreements and subordinate mortgage-backed securities (MBS). The Interest Rate Sensitive Strategies segment engages in investing in mortgage servicing rights, base servicing and excess servicing spreads, and agency and senior non-agency MBS, as well as related interest rate hedging activities. The Correspondent Production segment is involved in purchasing, pooling, and reselling newly originated prime credit quality loans directly or in the form of MBS. The company primarily sells its loans to government-sponsored entities. The company qualifies as a real estate investment trust for federal income tax purposes. It generally would not be subject to federal corporate income taxes if it distributes at least 90% of its taxable income to its shareholders. The company was incorporated in 2009 and is headquartered in Westlake Village, California.

Track real-time 10 Year Treasury Rate yields and explore historical trends from year start to today. View interactive yield curve data with YCharts.

United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Small Domestically Chartered Commercial Banks was 5.80000 % Chg. at Annual Rate in July of 2025, according to the United States Federal Reserve. Historically, United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Small Domestically Chartered Commercial Banks reached a record high of 40.10000 in April of 2021 and a record low of -14.60000 in April of 2023. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Small Domestically Chartered Commercial Banks - last updated from the United States Federal Reserve on November of 2025.

Graph and download economic data for Treasury and Agency Securities: Mortgage-Backed Securities (MBS), Large Domestically Chartered Commercial Banks (H8B1301NLGCAG) from 1997 to 2024 about charter, mortgage-backed, agency, large, Treasury, domestic, securities, banks, depository institutions, and USA.

Other-Long-Term-Assets Time Series for ARMOUR Residential REIT Inc. ARMOUR Residential REIT, Inc. invests in residential mortgage-backed securities (MBS) in the United States. Its securities portfolio primarily consists of the United States Government-sponsored entity's (GSE) and the Government National Mortgage Administration's issued or guaranteed securities backed by fixed rate, hybrid adjustable rate, and adjustable-rate home loans; and unsecured notes and bonds issued by the GSE and the United States treasuries, as well as money market instruments. The company has elected to be taxed as a real estate investment trust. As a result, it would not be subject to corporate income tax on that portion of its net income that is distributed to shareholders. ARMOUR Residential REIT, Inc. was incorporated in 2008 and is based in Vero Beach, Florida.

Total-Other-Finance-Cost Time Series for MFA Financial Inc. MFA Financial, Inc., together with its subsidiaries, operates as a real estate investment trust in the United States. It invests in residential mortgage securities, including non-agency mortgage-backed securities, agency MBS, and credit risk transfer securities; residential whole loans, including purchased performing loans, purchased credit deteriorated, and non-performing loans; and mortgage servicing rights related assets. The company qualifies as a real estate investment trust for federal income tax purposes. It generally would not be subject to federal corporate income taxes if it distributes at least 90% of its taxable income to its stockholders. MFA Financial, Inc. was incorporated in 1997 and is based in New York, New York.

Graph and download economic data for Repurchase Agreements: Mortgage-Backed Securities Purchased by the Federal Reserve in the Temporary Open Market Operations (RPMBSD) from 2000-01-03 to 2025-11-28 about mortgage-backed, repurchase agreements, purchase, trade, securities, and USA.

Change-In-Working-Capital Time Series for ARMOUR Residential REIT Inc. ARMOUR Residential REIT, Inc. invests in residential mortgage-backed securities (MBS) in the United States. Its securities portfolio primarily consists of the United States Government-sponsored entity's (GSE) and the Government National Mortgage Administration's issued or guaranteed securities backed by fixed rate, hybrid adjustable rate, and adjustable-rate home loans; and unsecured notes and bonds issued by the GSE and the United States treasuries, as well as money market instruments. The company has elected to be taxed as a real estate investment trust. As a result, it would not be subject to corporate income tax on that portion of its net income that is distributed to shareholders. ARMOUR Residential REIT, Inc. was incorporated in 2008 and is based in Vero Beach, Florida.

Defensive-Intrval-Ratio Time Series for Two Harbors Investments Corp. Two Harbors Investment Corp. invests in, finances, and manages mortgage servicing rights (MSRs), agency residential mortgage-backed securities (RMBS), and other financial assets through RoundPoint in the United States. The company target assets include agency RMBS collateralized by fixed rate mortgage loans, adjustable rate mortgage loans, hybrid mortgage loans, or derivatives; and other assets, such as financial and mortgage-related assets, comprising non-agency securities and non-hedging transactions. It qualifies as a REIT for federal income tax purposes. As a REIT, the company must distribute at least 90% of annual taxable income to its stockholders. Two Harbors Investment Corp. was incorporated in 2009 and is headquartered in Saint Louis Park, Minnesota.