Loan Constant

elisaleach

Board Regular
Joined
Aug 19, 2003
Messages
82
I am trying to back into the interest rate and term of a loan constant. and also go forward, however i am not coming up to what is supposedly the correct answer...
(.0625/12)/(1-(1/(1+(.0625/12))^300)) which is supposed to reflect 6.25% and 25 yr amortization to determine the constant. I am being told the answer is 7.916% however that is not what comes up in excel.. Any suggestions. i know i must have a paren in the wrong spot.
and why would i come up with something different than on just the annual basis - =(0.0625)/(1-(1/(1+(0.0625))^25))?

Thanks
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,747
Office Version
2010
Platform
Windows
=6.25% / (1 - 1/(1+6.25%)^25) returns 8.0095%

More simply, though, so does =PMT(6.25%, 25, -1)
 

elisaleach

Board Regular
Joined
Aug 19, 2003
Messages
82
=PMT(6.25%/12,25*12,-1)*12 returns 7.916033%. Is the difference between the two just that it is 7.916033% on a monthly compounding basis which equates to a 8.009462% annual basis?
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,747
Office Version
2010
Platform
Windows
Yes, because you make payments throughout the year rather than in a lump sum at the end of the year.

Edit: Maybe that wasn't clear -- you are paying less for the whole loan because you're paying monthly, so less interest accumulates on the outstanding balance.
 
Last edited:

MAP1168

New Member
Joined
Aug 29, 2011
Messages
11
You are getting a result of about .66%?

Multiply your result by 12.

Sorry it took so long.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,754
Messages
5,470,574
Members
406,707
Latest member
drkjz

This Week's Hot Topics

Top