I am building a proforma for a project which has an exit for the investor at 5 years with a refinance of the loan. Can I calculate the payoff balance for a 30 year loan at 5 years? I am using FileMaker Pro 15 if that matters.

I am building a proforma for a project which has an exit for the investor at 5 years with a refinance of the loan. Can I calculate the payoff balance for a 30 year loan at 5 years? I am using FileMaker Pro 15 if that matters.

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.

Yes, FileMaker has an entire category of financial functions:

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.