I have a lot of calculations to do and really need to know how to figure the multiplier to simplify my work in excel.
You’re using Excel?
Cool. Then it’s easy.
Use =Pmt(Rate, Nper,PV) formula
where
Rate is your periodic rate
Nper= number of payments
PV is your present value.
For example, $10,000 loan with monthly payments for 10 yrs at 5% interest would be
Rate = .05/12 = monthly rate (and yes you can enter it like that)
Nper = 120 = 12 months x 10 yrs
PV = -10,000 (cash going out)
or pmt(0.05/12,120,-10000) = 106.07
You can use the Shift-F3 button in excel to find the other financial formulas as well if you need to determine interest rate, future value, number of payments, etc. 
Hope that helps!
Be more specific.. what calcualtion code are you looking for?
References :
Just dont pay them back. They will contact you and do your math.
References :
Don’t remember the formula, but some Excel programs have them already available. You just have to give values to the variables.
References :
I need to know more. What type of loans? Real estate? Credit card…….
You multiply your loan amount X interest rate, etc.
Please provide more info. or just ask for my web site and I will provide a link and it will allow you to plug in what numbers you have and you can figure all the loans that you want. Don’t worry. It does not let anyone see your personal info and contact info uness you want them to. Good luck……Robbin’ Points
References :
commercial real estate broker
You’re using Excel?
Cool. Then it’s easy.
Use =Pmt(Rate, Nper,PV) formula
where
Rate is your periodic rate
Nper= number of payments
PV is your present value.
For example, $10,000 loan with monthly payments for 10 yrs at 5% interest would be
Rate = .05/12 = monthly rate (and yes you can enter it like that)
Nper = 120 = 12 months x 10 yrs
PV = -10,000 (cash going out)
or pmt(0.05/12,120,-10000) = 106.07
You can use the Shift-F3 button in excel to find the other financial formulas as well if you need to determine interest rate, future value, number of payments, etc.
Hope that helps!
References :