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)
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.