HP Forum Archive 14

[ Return to Index | Top of Index ]

Calcualtion help Message #1 Posted by David on 8 Mar 2004, 3:38 p.m. This is what I am trying to accomplish: CST = Cost of the equipment. PMT = monthly payment. I%YR = the interest rate I am buying my money at. RV% = This is always a negative # and is used when a balloon is due at the end of the term (10% is a typical buy out). N = the length of the term in months. #ADV = number of advances (due to the time value of money this could increase my profitability on a deal substantially). PTS = The amount of money I would like to make on a deal i.e. 10 points on a $20,000.00 deal would = $2,000.00 of gross margin. There used to be 2 pages to this equation which resulted in a "more" tab. HELP ME PLEASE!

Re: Calcualtion help Message #2 Posted by Eddie Shore on 8 Mar 2004, 4:04 p.m., in response to message #1 by David Depends on what calculator are you using. If you are using the HP17/19 Series, there will be a MORE option. If you are using the 48/49 Series, you will not see a MORE box (just press NEXT to go to page 2).

Re: Calcualtion help Message #3 Posted by David on 8 Mar 2004, 4:24 p.m., in response to message #2 by Eddie Shore Thanks for the response Eddie. It's a 17B II and I am in need of the calcuation to input. I deleted it accidentally changing batteries and the formula burned to the ground along with my house.

Re: Calcualtion help Message #4 Posted by Wayne Brown on 8 Mar 2004, 5:54 p.m., in response to message #3 by David David, What was the original source of this program? I don't have a 17bII myself and don't know anything about programming it, but if this was a published program, I'd be glad to try to help you find a copy. For instance, if it was printed in the manual, I can point you to an electronic (PDF) copy.

Re: Calcualtion help Message #5 Posted by David on 9 Mar 2004, 1:09 p.m., in response to message #4 by Wayne Brown Wayne, Thanks for your response. It's not in the manual. It was an equation put together by a guy that has long since disappeared. I know what the tabs look like and what I am trying to accomplish but alas I have not found anyone to help with the following need: CST = Cost of the equipment. PMT = monthly payment. I%YR = the interest rate I am buying my money at. RV% = This is always a negative # and is used when a balloon is due at the end of the term (10% is a typical buy out). N = the length of the term in months. #ADV = number of advances (due to the time value of money this could increase my profitability on a deal substantially). PTS = The amount of money I would like to make on a deal i.e. 10 points on a $20,000.00 deal would = $2,000.00 of gross margin. There used to be 2 pages to this equation which resulted in a "more" tab. I am willing to pay for this. I am in desperate need.

Re: Calcualtion help Message #6 Posted by Bob Wang on 9 Mar 2004, 9:41 p.m., in response to message #5 by David David: I'm not exactly sure what you are looking for, but it sounds like a modification of this formula: http://h20015.www2.hp.com/en/document.jhtml?lc=en&docName=bpia5201 Just change PV to CST, and modify FV to include RV% and PTS. Bob

Will SOMEone PLEASE fix the spelling of "Calculation"? Message #7 Posted by Paul Brogger on 9 Mar 2004, 10:23 p.m., in response to message #6 by Bob Wang ;^)

Calculation Message #8 Posted by Bob Wang on 9 Mar 2004, 10:41 p.m., in response to message #7 by Paul Brogger OK, I can't spell. Probably can't "calcualte" either ;-) But I think David is looking for something like: ADV: PMT=(- (1+PTS÷100) × PV – (RV%÷100)×FV × (SPPV ( I%YR ÷ 12 : N ) ) ) ÷ (USPV ( I%YR ÷ 12 : N - #ADV) + #ADV)

Re: Calculation Message #9 Posted by Bob Wang on 9 Mar 2004, 10:47 p.m., in response to message #8 by Bob Wang Yup, already saw one mistake. PV should be CST. ADV: PMT=(- (1+PTS÷100) × CST – (RV%÷100)×FV × (SPPV ( I%YR ÷ 12 : N ) ) ) ÷ (USPV ( I%YR ÷ 12 : N - #ADV) + #ADV)

Re: Calculation Message #10 Posted by Bob Wang on 9 Mar 2004, 10:49 p.m., in response to message #9 by Bob Wang David: Use this at your own peril! FV should have been replaced with CST also ADV: PMT=(- (1+PTS÷100) × CST – (RV%÷100)×CST × (SPPV ( I%YR ÷ 12 : N ) ) ) ÷ (USPV ( I%YR ÷ 12 : N - #ADV) + #ADV)

Bob Wang Message #11 Posted by David on 17 Mar 2004, 2:57 p.m., in response to message #10 by Bob Wang Is the master of the Universe. Thank you soooooo much for the formula. You are a life saver.

[ Return to Index | Top of Index ]

Go back to the main exhibit hall