Difference between revisions of "User:Edema"

From Simulace.info
Jump to: navigation, search
(References)
 
Line 19: Line 19:
  
 
== Method ==
 
== Method ==
 
+
The method used involved create a model using real-life mortgage conditions in the Czech Republic and general principle of mortgage calculations. Some variables also used assumed values.
 
 
  
 
== Variables ==
 
== Variables ==

Latest revision as of 22:07, 22 January 2023

Introduction

A mortgage is a form of loan used to purchase or maintain a home, land, or other type of real estate. The borrower commits to repay the lender over time, often through a series of monthly payments divided into principal and interest repayments. These components are are influence by different factors and elements and for the purpose of this work, only factors relevant to the simulation were selected. Each component and their associated factors will be further explained under the variable section of this work. The monthly mortgage payment is made up of four key components: Principle, Interest, Taxes, and Insurance (PITI). Mortgages in the Czech Republic, like in the rest of the world, typically have a payback duration of 10 to 30 years, however this can be extended.

Borrowers can choose from a variety of mortgage loans, the most common of which are fixed-rate mortgages and adjustable-rate mortgages (ARMs).

Fixed-Rate Mortgages A fixed-rate mortgage is the most common form. The interest rate on a fixed-rate mortgage remains constant throughout the loan's duration, as do the borrower's monthly mortgage payments. A conventional mortgage is another name for a fixed-rate mortgage.

Adjustable-Rate Mortgages An adjustable-rate mortgage (ARM) has an interest rate that is fixed for a set length of time before changing based on market interest rates. The initial interest rate is frequently below market, making the mortgage more reasonable in the near term but potentially less affordable in the long run if the rate rises significantly.


This model simulates mortgage repayments based on the principal, interest, tax and insurance. This simulation will show how default, extra payments, and payback duration affect early or late repayment or inability to repay. This study is based on the Fixed-Rate Model and focuses on the mortgage market in the Czech Republic.

Simulation Tool Used

Vensim PLE

Method

The method used involved create a model using real-life mortgage conditions in the Czech Republic and general principle of mortgage calculations. Some variables also used assumed values.

Variables

Principal (Mortgage Loan Amount) The principle of your mortgage loan is the amount payable before interest is calculated. This is the property's worth less the down payment.

Principal (Mortgage Loan Amount) = Value of House - Down Payment

Interest An interest rate is a percentage that indicates how much you will pay your lender as a monthly fee for borrowing money. Interest is calculated by your mortgage lender as a proportion of your principle over time.

Interest = INTEG [(Interest Rate * "Principal (Mortgage Loan Amount)"), 0]

Tax The amount of property tax you will pay is decided by the state, city, and the value of your home.

Tax = INTEG [(Tax Rate * Value of House), 0]

Insurance Mortgage insurance protects the lender if a borrower defaults on the loan. For this work, it is approximated using a premium rate and the value of the house. Your credit score is also considered while calculating the premium rate.

Insurance = INTEG [(Premium Percentage * Value of House), 0]

Premium Percentage The premium percentage used here is based on a borrowers credit scores. Higher credit scores equal lower rate. A range of 10% to 40% was used. This value is a constant value.

Premium Percentage = 0.2

Insurance Per Month

This is the monthly amount of insurance which forms part on monthly loan repayment amount. This is amount collected is collected in escrow accounts and paid to the insurance company periodically.

Insurance Per Month = Insurance/12

Tax Rate This is the property tax rate of the Czech Republic.

Tax Rate = 0.04

Tax Per Month This is the monthly amount of tax which forms part on monthly loan repayment amount. This is amount collected is collected in escrow accounts and paid to the government periodically.

Tax Per Month = Tax / 12

Value of Property The is the price of the property a borrower is taking a loan to purchase. A range of 1,500,000 CZK to 10,000,000 CZK was used. This value is a constant value and the first simulation is done with 2,000,000 CZK

Value of Property = 2,000,000

Down Payment This is the percentage of the value of the property required before loan is given. In the Czech Republic, a down payment of 20% is usually required for mortgages.

Down Payment = 0.2 * Value of Property

Life of Loan (Years) This is the total number of years required to repay the entire loan amount. This ranges between 10 to 35 years. The first simulation is done with 30 years

Life of Loan (Years) = 30

Repayment Period This is the total number of months required to repay the entire loan amount.

Repayment Period = "Life of Loan (years)"* 12

Interest Rate Mortgage interest rates in the Czech Republic ranges from 6% to 7%. For this model, The first simulation is done with 6.5%.

Interest Rate = 0.065

Month Repayment Amount This is the monthly repayment amount for the total mortgage. This amount usually has four parts: loan principal, loan interest, taxes, and insurance.

Month Repayment Amount = (("Principal (Mortgage Loan Amount)" * Interest Rate/12) / 1 - (1 + Interest Rate/12)^(-Repayment Period)) + Tax Per Month + Insurance Per Month

Total Repayments This is the total monthly repayment at any given period. This can also include additional repayment amounts when a borrower wants to reduce the repayment period.

Total Repayments = ((Monthly Repayment Amount * Period Elapsed) - (Number of Default * Period Elapsed * Monthly Repayment Amount)) + Additional Repayment

Number of Default This is when a borrower fails to fulfil repayment obligations. Defaults a due can be due to several conditions such Loss of Employment, Reduction in Income and Ill Health. For this model, we considered the effect of the a number of defaults on repayment time and ability to repay. Also, the max number of loan years is 35 years hence the max default period can be 420 months. The first simulation is done with 0 default.

Number of Default = 0

Total Mortgage This is the total value of the loan when interest is included.

Total Mortgage = ("Repayment Period (Months)" * Monthly Repayment Amount)

Additional Repayment This is any additional repayments the borrower makes outside the monthly repayment amount. For this model, this ranges from )CZK to 1,000,000CZK. The first simulation is done with 0CZK.

Additional Repayment = 10000

Period Elapsed This is a time period (in months) after loan was secured. The first simulation is done with 1 month after loan was taken.

Period Elapsed = 1

Total Mortgage Outstanding This the Total Mortgage value less Total Repayments made.

Total Mortgage Outstanding = Total Mortgage -Total Repayments


Model

The Stock Flow Diagram construct using the variables discussed is shown below.

Stock Flow Diagram.png

How to Use Model

The key outputs of this model are

1. The Monthly Repayment Amount 2. Total Mortgage Amount 3. Total Amount Repaid 4. Total Mortgage Outstanding

To simulate these outputs, a user will adjust the variables listed below. The resulting output depends on a combination of these inputs:

1. Premium Percentage 2. Tax Rate 3. Value of Property 4. Interest Rate 5. Life of Loan 6. Number of Defaults 7. Additional Repayments 8. Period Elapsed

The resulting outputs can be analyzed using the following tools available on Vensim:

1. Causes Strip 2. Graph 3. Table 4. Table Time Down


Results

The result of this model vary depending of various variable adjustments as discussed under the "How to Use Model" section.

Four graphical results showing Total Mortgage Outstanding are presented below to demonstrate how the model works. The scenario adopted are listed above the graph


Result One Loan life of 30 years, O CZK Additional Repayment, O CZK Additional Repayments, Repayment Period = 360 months, Period Elapsed = 360 months, No Defaults

MOrtgages Outstanding 2.png

From this simulation, and inputs, it is clear that when monthly repayments are paid on as scheduled with no defaults and no additional repayments, full amount is paid within expected repayment time.

Result Two Loan life of 30 years, 240,000 CZK Additional Repayment, O CZK Additional Repayments, Repayment Period = 360 months, Period Elapsed = 360 months, No Defaults

MOrtgages Outstanding 3.png

From this simulation, and inputs, it is clear that when monthly repayments are paid on as scheduled with no defaults and some additional repayments, full amount is paid ahead of repayment time. This can be shown by the negative graph

Result Three Loan life of 30 years, 240,000 CZK Additional Repayment, O CZK Additional Repayments, Repayment Period = 360 months, Period Elapsed = 360 months, 95 months of Defaults

MOrtgages Outstanding 4.png

From this simulation, and inputs, it is clear that when there are defaults and even with additional repayments, full amount cannot be paid within expected repayment time.

Conclusion

From the simulation, we can concluded that several factor contribute to the overall amount owed to a lender. Taxes, Insurance add to Interest to determine amount owed. A borrower must strife to avoid defaults. Defaults extend repayment period and make mortgage more expensive. In situations where defaults are unavoidable, a borrower should plan toward additional repayments.

References

Madison , L.F. (2019) Understanding the four parts of a mortgage payment, NCHFA. Available at: https://www.nchfa.com/news/home-matters-blog/understanding-four-parts-mortgage-payment (Accessed: January 18, 2023).

Shea, N. (2017) Seven factors that determine your mortgage interest rate, Consumer Financial Protection Bureau. Available at: https://www.consumerfinance.gov/about-us/blog/7-factors-determine-your-mortgage-interest-rate/ (Accessed: January 18, 2023).

Analyst Prep (2021) Determinants of interest rates, CFA, FRM, and Actuarial Exams Study Notes. Available at: https://analystprep.com/study-notes/actuarial-exams/soa/fm-financial-mathematics/determinants-of-interest-rates/ (Accessed: January 16, 2023).

Bieber, C. (2021) 5 factors that affect your mortgage rate, The Motley Fool. Available at: https://www.fool.com/the-ascent/mortgages/articles/5-factors-that-affect-your-mortgage-rate/ (Accessed: January 18, 2023).

Crace, M. (no date) What is a mortgage? the basics for beginners, What Is A Mortgage And How Do I Get One? | Rocket Mortgage. Available at: https://www.rocketmortgage.com/learn/what-is-a-mortgage#:~:text=A%20mortgage%20is%20a%20type,the%20collateral%20is%20the%20home. (Accessed: January 16, 2023).

Kagan, J. (2023) What is a mortgage? types, how they work, and examples, Investopedia. Investopedia. Available at: https://www.investopedia.com/terms/m/mortgage.asp (Accessed: January 17, 2023).

NerdWallet (no date) PMI Calculator, NerdWallet. Available at: https://www.nerdwallet.com/article/mortgages/pmi-calculator (Accessed: January 16, 2023).

Pexpats (no date) How to get a mortgage in the Czech Republic as a foreigner. Available at: https://pexpats.com/how-to-get-a-czech-mortgage (Accessed: January 15, 2023).

Source File

Media:Mortgage_Stock_Flow_Final.mdl