Hello
My base is begging for a PMT or Payment function, but there isn’t one I can find… I am hoping someone has found a workaround to calculate a mortgage payment. Kind of critical to our client and sales processes.
I realize this is not a spreadsheet, but other databases can do it. I see there are plenty of math functions… is anyone able to put them together in a way to “make” mortgage payment function?:
My Airtable Base is very depressed.
a spreadsheet example looks like this:
![Screen Shot 2018-11-28 at 9.45.37 AM.png Screen Shot 2018-11-28 at 9.45.37 AM.png](/t5/image/serverpage/image-id/2004i0F78B7D4A11E9DA6/image-size/large?v=v2&px=999)
…where the field “MONTHLY PAYMENT (PI)” in the middle is the result I’m talking about… because to get that payment I must use the fields before it and a PMT function … like this
![09%20AM 09%20AM](/t5/image/serverpage/image-id/2010iD81149E6C1A53EB8/image-size/large?v=v2&px=999)
So i ask, would anyone able to put together the mathematical functions in a way to “make” an amortized mortgage calculation based on %Rate, Term (in months or years), & principle… with the added bonus of a field for Extra monthly payment to add regular additional principle to the repayment.