Quantcast

Quarterly Payments (Yearly Rate, Quarterly compounding)

Last modified by
on
Jul 24, 2020, 6:28:07 PM
Created by
on
Nov 18, 2014, 9:41:39 PM
`"quarterly payment" = (( 0.039 /4) * 200000 ) / (1- (1+( 0.039 /4))^-( 10 *4))`
`"Number of Years"`
`"Principal"`
`"Yearly Interest Rate"`
Share Result
Tags
UUID
acf2aa73-6f6b-11e4-a9fb-bc764e2038f2

This equation computes the quarterly payments on a fixed rate.  

INPUTS

The quarterly payment is defined by the following inputs:

  • r - the annual interest rate entered as a decimal value; i.e., enter 0.049 for a 4.9% interest rate
  • n - the number of years of the loan term
  • P - the principal amount borrowed.

Notes

This equation is defined to compute payments which will pay off the entire loan amount within some fixed period -- like the common 30 year mortgage term.

The entire balance of the loan includes the interest paid on the borrowed amount and is included in the monthly payment.

For example:

Assume you buy a home loan for $200,000 with a fixed yearly interest rate of 6.5% and plan to pay it off over 30 years, 

  • the principal is P=200,000
  • the yearly interest r (entered as  0.065)  will be calculated to a quarterly interest rate of quarterly rate = (0.065/4)
  • the number of quarterly payments is n=30 years * 4 quarters/year = 120 payment periods

The fixed quarterly payment will then be calculated to equal  $3,799.04.


  • Comments
  • Attachments
  • Stats
No comments
This site uses cookies to give you the best, most relevant experience. By continuing to browse the site you are agreeing to our use of cookies.