Mortgage Excel Function

Excel function – which is used for calculating interest rate for annuity ?

Hi, i got a question concern with Excel function.

I’m trying to create the mortgage calculator through Excel for my assignment. For the Normal Mortgage, with the output is Present Value of a Loan amount, i use this formula:

PVoa = PMT [(1 - (1 / (1 + i)n)) / i]

where :
PVoa = Present Value of an Ordinary Annuity
PMT = Amount of each payment
i = Discount Rate Per Period
n = Number of Periods

What if I have PMT, n, PVoa as the inputs and i want to calculate the interest rate (i) ? Which function in Excel helps me to calculate (i) ?

Thanks a lot for your suggestions.
Hi Alfonso,
Could u please be more specific ?
Say, I already got these 3 input : payment, present value of a lump sum, numbers of payments ( years * frequency), what function in Excel i should use to calculate interest ?

Hi
Use Rate Function to Calculate i

i =RATE(n, -A, P,0, type, guess)

Guess (default : 0.1)

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>