
1. Re: Balloon Payment Calculation
mikebeargie Mar 14, 2017 12:50 PM (in response to chipstock)Yes, FileMaker has an entire category of financial functions:
I would read into those and come up with a calculation that meets your needs.
You'll have to be a little tricky since payments will include interest.

2. Re: Balloon Payment Calculation
chipstock Mar 14, 2017 12:58 PM (in response to mikebeargie)Yes, I am aware of these functions. However none of them would provide me with the right calculation. For the calculation to work you have to include all of the following parameters; Begining Principal, Interest rate (Constant), Payment (constant), Term for full amortization and the term inwhich you want the balloon delivered for.

3. Re: Balloon Payment Calculation
mikebeargie Mar 14, 2017 1:09 PM (in response to chipstock)How about this custom function:

4. Re: Balloon Payment Calculation
chipstock Mar 14, 2017 1:20 PM (in response to mikebeargie)In description this looks like it would work. I am not using Filemaker Advance, how do I plug this script into a calculation? I'm pretty new at this stuff.

5. Re: Balloon Payment Calculation
chipstock Mar 14, 2017 1:22 PM (in response to chipstock)This is the exact description of what I am looking for, I just don't know how to plug it in to use.

6. Re: Balloon Payment Calculation
mikebeargie Mar 14, 2017 1:26 PM (in response to chipstock)Only FMP advanced can add/edit custom functions. In both the one I sent and the one you linked to, they are recursive custom functions (a function that calls itself), so you could not duplicate that in a calculation field type.

7. Re: Balloon Payment Calculation
chipstock Mar 14, 2017 1:39 PM (in response to mikebeargie)I have a developer I assume has the Advance version. Can he set it up to be used by my filemaker?

8. Re: Balloon Payment Calculation
philmodjunk Mar 14, 2017 1:49 PM (in response to chipstock)Yes he can. Advanced is needed to add a custom function to a file, but any copy of FileMaker can use the custom function once installed.
And a looping script could produce the same result as a recursive function.