Amortization Calculations
I am trying to calculate mortgage payments in Podio. The formula is P=((r(1+r)^n)/((1+r)^n1)). My issue is Podio will not raise to a certain power. I have a field number of units = 10. When I input @number of units^2 the result is 8. When I change the 2 to a 5, it equals 15. Does anyone have a workaround for this? Also, is there a better way to calculate mortgage payments? Thank you.

HELP*  I need calculations for mortgage loans 
If I know the following:
1) Loan Amount = $100,000
2) Interest Rate = 1%
3) Loan Amortization Period = 30 years
4) Loan Term = 5 yearsI need calculations to produce the following results:
1) Monthly Payment
2) Total Interest Paid during "Loan Term"
3) Amortized Loan Balance at the end of "Loan Term" 
Hey Gang, I have tried to use this and for some reason everything comes up 0.00
var p = @Offer
var r = .06/12
var n = 20*12
var r1 = 1+r
var r2 = r*r1
var n1 = n1
var c1 = Math.pow(r2, n)
var c2 = Math.pow(r1, n1)
var result = p*(c1/c2)
result.toFixed(2)I have also tried
var p = @Offer
var r = .06
var n = 20
var r1 = 1+r
var r2 = r*r1
var n1 = n1
var c1 = Math.pow(r2, n)
var c2 = Math.pow(r1, n1)
var result = p*(c1/c2)
result.toFixed(2)this is a bit out of my wheel house. any help is much appreciated

Hey gang,
just an update. I rewrote the equation and got it to work. I seemed to have a problem with the script and had to delete the calculation field and start over, but all in all below is my info for group benefit.
p = principle
r = rate
n = years
The Formula that I used was:
p * ( (r/12) / (1(1+(r/12) )^(n*12) ) )
The code was:
var p = @Offer
var r = .06
var n = 20
var r1 = (r/12)
var n1 = (n*12)
var r2 = 1+r1
var c1 = Math.pow(r2, n1)
var result = (p*(r1/(1c1)))
resultthanks guys
Please sign in to leave a comment.
Comments
15 comments