HP Forum Archive 15

[ Return to Index | Top of Index ]

HP 17B calculation request Message #1 Posted by David G on 3 May 2005, 11:17 p.m. Hello Folks, I am in serious trouble. I lost about 1/2 of a calculation in my 17B. I am in the equipment leasing business. About 12 yrs ago I was given a calculation that has made my life very easy. Unfortunately somehow I just lost 1/2 the calculation. The hard copy I had in my house burned to the ground along with my house 2 years ago. So I beg someone to help me. Here is what I am trying to accomplish: Catagories: Payment / Cost / Interest / Residual value Percentage / Points / Term / Advance Payments Here's an example: I have a $50,000.00 deal. I get an approval from a bank at 8%. I want to make 6 points (%) or $3,000.00 on the deal. The residual value at the end of the term is a 10% Put (balloon). The customer would like a 60 month term and is paying first and last payment in advance leaving 58 payments remaining in the stream. This is how I used to plug it in to the calculator: pmt: This is what I am solving CST: $50,000.00 INT%: 8% RV%: -10 pts: 6 N: 60 #adv: 2 I would then solve for payment. This is what I have left of my calculation: ADV:PMT=(-(1+PTS *DIVIDED BY* 100)xCST-(RV% *DIVIDED BY*)xCSTx(SPPV(I%YR *DIVIDED BY* 12:N))) *DIVIDED BY* (U That's where I lose it. The *divided by* is the actual symbol. I could not figure out how to express it in any other way. So can anybody solve this major problem for me? Please help.

Re: HP 17B calculation request Message #2 Posted by Bob Wang on 4 May 2005, 2:34 p.m., in response to message #1 by David G PMT=(- (1+PTS÷100) × CST – (RV%÷100)×CST × (SPPV ( I%YR ÷ 12 : N ) ) ) ÷ (USPV ( I%YR ÷ 12 : N - #ADV) + #ADV)

Re: HP 17B calculation request Message #3 Posted by David G on 4 May 2005, 9:56 p.m., in response to message #2 by Bob Wang Thank you Bob Wang. You are a good man!

[ Return to Index | Top of Index ]

Go back to the main exhibit hall