Create an account on the HP Community to personalize your profile and ask a question
07-22-2018 12:18 PM
07-23-2018 03:23 AM
I cannot see an issue with the equation as far as I can tell. The number of "(" and ")" seem correct.
I have questions about the variables:
SPPV & USPV : built in HP17BII+ functions
LVLPMT: equation name
EQPCST: Equipment cost
#ADV: number of advanced payments (not value)
PMT: Payment (that you wish to solve for)
I : interest rate
N: number of payments (term)
I do know which variable to associate with "Buy Out", also there are other variables that will need data.
Also, as indicated above, #ADV is the number of advance payments, not the value of the advance payment. The formula assumes that there are a total of N payments, some of which may be advance payments.
Also remember that the interest rate must be consistent with the payment period (e.g. interest per month for monthly payments, interest per year for annual payments).
07-23-2018 04:48 AM
I am trying to calculate a correct formula but not having any luck and this was so helpful for me to calculate a monthly payment.
Would you by any chance have a formula I could use for:
Equipment Cost, Advance Payment, Interest, Term, Buy Out & Payment
07-31-2018 03:20 AM
I have tried to look into this further, but as that type of financing is not my field of expertise I have been unable to find a solution.