I was just wondering how difficult it would be to get FMP to generate a 
mortgage amortization table.  I did a brief search and it seems that it 
involves some sort of iterative process...which I assume means that you 
would have to use a script that generates e.g. 360 records to do a 30 
year mortgage.

Recently we have been shopping for a townhouse for our daughter to stay 
in while she is in college (why pour $18000 down the drain in rent?) and 
I whipped up a little FMP solution to compare the bottom line for 
various loans, room mate rent, etc.  However, I had to generate the 
payments, total interest, equity etc in Loan Calculator (Mac freeware) 
and then manually enter those values into FMP.  It would be "cool" to be 
able to grab the value from a separate FMP file so I just thought I 
would ask if an amortization table is possible in FMP.

Bill

in article maslin-9B9360.12325415072003@nntp.msstate.edu, William Maslin at
maslin@cvm.msstate.edu wrote on 15/7/03 6:32 pm:

> I was just wondering how difficult it would be to get FMP to generate a
> mortgage amortization table.  I did a brief search and it seems that it
> involves some sort of iterative process...which I assume means that you
> would have to use a script that generates e.g. 360 records to do a 30
> year mortgage.
> 
> Recently we have been shopping for a townhouse for our daughter to stay
> in while she is in college (why pour $18000 down the drain in rent?) and
> I whipped up a little FMP solution to compare the bottom line for
> various loans, room mate rent, etc.  However, I had to generate the
> payments, total interest, equity etc in Loan Calculator (Mac freeware)
> and then manually enter those values into FMP.  It would be "cool" to be
> able to grab the value from a separate FMP file so I just thought I
> would ask if an amortization table is possible in FMP.
> 
> Bill


Have a look at the Finacial Functions in the Specify Calculation dialogue
box.

Regards

Chris

In article 
<200307162325392518184@toulouse-2-a7-62-147-211-16.dial.proxad.net>,
 pmanet@invivo.edu (manet) wrote:

> William Maslin <maslin@cvm.msstate.edu> wrote:
> 
> > It would be "cool" to be 
> > able to grab the value from a separate FMP file so I just thought I 
> > would ask if an amortization table is possible in FMP.
> 
> 
> why not the financial formulas of Appleworks'spreadsheet ?
> 
> this works really fine

You are correct.  However, I was trying to find a way to get FMP to do 
it so that I could keep the solution "all in the family."  In order to 
get the info I need from from Appleworks into FMP, I would have to use 
(and learn) Applescript.

However, I downloaded an old freeware Clarisworks amortization 
spreadsheet from the web yesterday, and it has all the formulas in it, I 
think.  In addition, some information on the formulas can be found here:

http://www.interest.com/hugh/calc/formula.html

Next step is trying to implement those formulas in a script.

Thanks, 

Bill

William Maslin wrote:
> 
> I was just wondering how difficult it would be to get FMP to generate a
> mortgage amortization table.  I did a brief search and it seems that it
> involves some sort of iterative process...which I assume means that you
> would have to use a script that generates e.g. 360 records to do a 30
> year mortgage.
> 
> Recently we have been shopping for a townhouse for our daughter to stay
> in while she is in college (why pour $18000 down the drain in rent?) and
> I whipped up a little FMP solution to compare the bottom line for
> various loans, room mate rent, etc.  However, I had to generate the
> payments, total interest, equity etc in Loan Calculator (Mac freeware)
> and then manually enter those values into FMP.  It would be "cool" to be
> able to grab the value from a separate FMP file so I just thought I
> would ask if an amortization table is possible in FMP.
> 
> Bill

Undoubtedly you can do this in FileMaker, but a spreadsheet is really a
better tool for this. The AppleWorks spreadsheet, Excel, or others will
do it.

Bill C