I need to to perform functions that will calculate payments based on a loan amount, interest rate and term. This is an easy function in excel: =(MAX(Payments!M3:M32))/12 BUT, can I get some suggestions as to how to do this in Caspio?
Secondly, I'd like to get an amoritzation schedule showing payments and declining balance over a period of time such as 1 year, 5 years, etc.
Has anyone done this in Caspio?