cancel
Showing results for 
Search instead for 
Did you mean: 
g_schaefer
New member
2 1 0 0
Message 1 of 4
755
Flag Post

HP calculators

HP Recommended

Can an HP calculator solve for a "Discounted Yield Maintenance Prepayment Fee"?  This is a type of prepayment fee on a commercial property mortgage.  Which HP calculator will solve for this.  Thanks!

0 Kudos
3 REPLIES 3
cyrille
Level 6
Level 6
252 251 42 77
Message 2 of 4
Flag Post
HP Recommended

Hello,

 

Not that I know, unless this calculation goes by another name.

 

Most of the HP calculators are programmable and can probably be used to make this calculation, but they do not do it natively.

 

Cyrille

I am an HP Employee
0 Kudos
g_schaefer
Author
New member
2 1 0 0
Message 3 of 4
Flag Post
HP Recommended

Cyrille - Thanks!   I was looking for any easy way out, but I am just going to have solve it with pencil and paper.  I can get some help using Excel for long calculations.

0 Kudos
Jan_D
Level 6
305 297 32 76
Message 4 of 4
Flag Post
HP Recommended

I did some research on the internet and  I have the impression that there is a lot of confusion about the meaning of Yield Maintenance Prepayment Fees.

 

I do not know which formula or algorithm you want to use , but on this page I found some examples which seem rather logical to me:

http://albcommercialcapital.com/news/wp-content/uploads/2013/10/Yield_Maintenance.pdf

 

When I understand the method well you should add all future monthly payments from prepayment date until maturity, add this to the balloon payment at maturity, correcting all this for their present value at prepayment date, using the interest rate given by the treasury yield.

 

The result you have to subtract from the loan balance at prepayment date.

 

Some examples are worked out, but in my opinion they are not correct.

 

I calculated it on my Prime, but any financial calculator could do this and found a result which is the same as given by this online calculator:

http://www.crefcoa.com/yield-maintenance-calculator.html

 

 

0 Kudos
† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation