Mortgage Payment Analytics

achandle13
10/25/2015

Mortgage Payment Calculation with Prepayment Analysis

This app provides users with easy to-do mortgage analytics including:

  • Mortgage payment scenario analysis based on mortgage terms
  • Analyze how prepayments will affect your mortgage payment schedule
  • Mortgage investors can analyze prepayment risk

Mortgage Payment

Use the user interface to determine the ideal mortgage terms base on monthly payment.

Users can change:

  • Mortgage Size
  • Mortgage Rate
  • Payment Frequency
  • Mortgage Term

Example: A $150,000 with monthly payments for 30 years at a 6% annual rate would be:

[1] 899.3258

Conduct Prepayment Analysis

Homebuyers and investors alike can perform prepayment scenario analysis using two different models.

The first is the Public Securities Administration's PSA model, which is a standard industry benchmark. Users can change prepayment speed assumptions to compare faster or slower prepayment speeds to the base benchmark.

The second is the one the users can specify themselves.

The next slide shows an example of the graph.

Example: Prepayments at the Base and 150 PSA

plot of chunk unnamed-chunk-5

Next Steps

Users can go to: ShinyApps to access the app.

And they can look forward to:

  • enhanced charts of principal and interest payments under different prepayments scenarios
  • user defined prepayment models