COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Generating amortization table with FMPro

• Email
• Follow

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   0 Reply William 7/15/2003 5:32:54 PM See related articles to this posting 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


 0

In article
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.

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

 0

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   0 Reply B 7/17/2003 10:17:26 PM 3 Replies 402 Views Similar Articles 12/8/2013 3:14:08 AM page loaded in 47972 ms. (0)  Reply: Similar Artilces: Table Title Within Table I would like to get the table title within the table itself, i.e. have it look like the following: ============================= Table x.x: This is my table \caption ------------------------------ Col 1 | Col 2 | Col 3 | -------------------------------- x x x y z x =============================== Is this possible? I'm quite a newbie at this whole thing, but it seems to be that the table environment only allows you have the caption either before or after the tabular environment, and does not itself allow any of the \hline features. Is there another package I could use? Just to be awkward, I am using the \textsf{} font in the table column titles: is there a way to get the Table: x.x bit that appears as a result of \caption to also appear in the sans-serif font? Thanks a lot for any help! Iggy Dear Iggy What do you mean by table title within the table itself''. Kindly explain me briefly and then I'll try to solve your problem. Thanks and Regards Saravanan,M. Ignacy Sawicki <spam@barrier.com> wrote in message news:<Xns93C5C5F0DDB6Bsawickiipocztaonetpl@127.0.0.1>... > I would like to get the table title Table format I have 3 files which look like: file a is: a b c file b is: a0 a1 a2 file c is: d0 d1 d2 How can I output a file which combine the three files and look like a table as: a a0 d0 b a1 d1 c a2 d2 Thank for your reply. AE86 wrote: > I have 3 files which look like: > > file a is: > a > b > c > > file b is: > a0 > a1 > a2 > > file c is: > d0 > d1 > d2 > > How can I output a file which combine the three files and look like a table > as: > a a0 d0 > b a1 d1 > c a2 d2 > > Thank for your reply. > > man paste PDF::Table Hello, I have written a module, tenatively called PDF::Table, for creating tabular reports in PDF format. It is essentially a utility class for use with the PDF::API2 module. This module has one core method that takes a 2D array of data and creates a table layout. You can specify formatting parameters - things such as font, font color and background color per column and/or per even/odd row. By default, it also handles some tedious things automatically, like determining column widths based on the content of each column and adding as many pages to the pdf as needed. Any comments are welcome. Here is the pod: * NAME * SYNOPSIS * DESCRIPTION * METHODS o new o table($pdf, $page_obj,$data, %opts) o text_block($txtobj,$string,-x => $x, -y =>$y, -w => $width, -h =>$height) * AUTHOR * VERSION * LICENSE * PLUGS * SEE ALSO NAME PDF::Table -- A utility class for building table layouts in a PDF::API2 object. SYNOPSIS use PDF::API2; use PDF::Table; my $pdftable = new PDF::Table; my$pdf = new PDF::API2(-file => "table_of_lorem.pdf"); my $page =$pdf->page; # some data to layout my

MSA Table
Isn't there an MSA table within Enterprise Guide and/or Base SAS? How can I access it? Any assistance would be greatly appreciated. On Oct 4, 12:28=A0pm, greg6363 <gregtlaugh...@gmail.com> wrote: > Isn't there an MSA table within Enterprise Guide and/or Base SAS? =A0How > can I access it? =A0Any assistance would be greatly appreciated. Check the Map or SAShelp Library. Map.uscity might be what your looking for... HTH, Reeza

Lock Table
Hello. Let me know if you can know if a table is locked by a lock Type: Begin Work Lock Table MySchema.MyTable IN ACCESS EXCLUSIVE MODE ..... Unlock Table or Commit For example: select * from islock(TableName) Thanks Enzo Original Message: Ciao. Vorrei sapere se � possibile sapere se una tabella � bloccata da un Lock del tipo: Begin Work Lock table MySchema.MyTable IN ACCESS EXCLUSIVE MODE ..... Unlock Table o Commit per esempio: select * from islock(tablename) Grazie Enzo Thanks to all. I found the solution: SELECT pg_class.relname, pg_database.datname, transactionid, pid, mode, granted FROM pg_locks, pg_class, pg_database WHERE pg_locks.relation = pg_class.oid AND pg_locks.database = pg_database.oid and relname='MyTable' Enzo.

Timing of Table
Dear Mathematica Users, Can someone explain the timing difference between the following two code samples. I am guessing it has to do with the auto-compiler, but even if I am correct, I would like to know more. Slow version: n=m=100; Timing[Do[Table[1,{i,1,n},{j,1,m}],{1000}];] Fast version: n=m=100; Timing[Do[Table[1,{i,1,n},Evaluate[{j,1,m}]],{1000}];] which is as fast as Timing[Do[Table[1,{i,1,100},{j,1,100}]],{1000}];] I also noticed that only the outermost iterator needs to be wrapped in Evaluate. Why(?) Thanks, Mariusz Mariusz, The difference in timing comes from the use of packed arrays. When Table can determine that the number of elements it will generate is at least 250, and that it's output will be an array of numbers, then it will use packed array code, which is quite a bit faster. Now, remember that Table has the attribute HoldAll, so that it shouldn't evaluate the iterators before doing the Table operation, which means that Table shouldn't be able to figure out that it's result will be greater than 250 elements long, and so Table shouldn't use packed arrays. This basically explains

Symbol Table
Hi All, I am working in vxworks 6.4 version. In my programe I try to add a symbol to the symbol table and and try to find it by using SymFindByName Api but it is not working. The code i am using is as follows symTblId = symTblCreate (SYM_TBL_HASH_SIZE_LOG2, TRUE, memSysPartId); symAdd (symTblId, "app", 0, pType, 0); symFindByName(symTblId, "app", pValue, pType); but i am unable to find the symbol "app" Could you give me a hint how to use symFindByName to search a symbol from the table. Thanks pras symFindByName() may need a valid symbol type to work. What is the pType variable set to? Note that symAdd() takes a SYM_TYPE whereas symFindByName() takes a 'SYM_TYPE *'. In your example one of the calls is therefore missing an indirection. -- PAD On Feb 25, 3:41=A0am, PAD <pierre-al...@comcast.net> wrote: > symFindByName() may need a valid symbol type to work. What is the > pType variable set to? > > Note that symAdd() takes a SYM_TYPE whereas symFindByName() takes a > 'SYM_TYPE *'. In your example one of the calls is therefore missing an > indirection. > > -- > =A0 PAD Hi

Manipulating a table
Hi - This is my first post. I am a long time mathematica user, but I still end up getting stuck on some things... I have used the Table function to generate output from the Solve function for a range of values... f = f /. case1 This generates a list, but I end up with double {{ and I can not figure out how to get from here to a 1-D list such that I could use ListPlot, etc... {{5.71429}, {11.4286}, {17.1429}, {22.8571}, {28.5714}, {34.2857}, {40.}, {45.7143}, {51.4286}, {57.1429}, {62.8571}, {68.5714}, {74.2857}, {80.}, {85.7143}, {91.4286}, {97.1429}} I ideally want to generate three plots f(M), a(M), b(M) - I have all the data, but I am just not able to get it into the right format case1 = Table[sol3 = Solve[{ f == m*a, -M + f*r == I*b, a == b*r}, {f, a, b}], {M, 1, 17}]; I then use a replacement rule to extract a list of one of variables Any help would be greatly appreciated. Flatten[yourtable,1] Best, Harvey -----Original Message----- From: navillus5 [mailto:skelligs@gmail.com] Sent: Friday, August 13, 2010 6:56 AM Subject: Manipulating a table Hi - This is my first post. I am a long time mathematica user, but I

Transaction Table
I was discussing a project today and a question came up about using a transaction table. I need to recreate an input form with many different types of questions. The following is one type of question: 3) How would you characterize the racial/ethnic composition of the individuals served by your program? What is the percent for each? ___American Indian or Alaskan Native ___Asian ___Black/African-American ___Hispanic or Latino So what would be the best approach for this? Should I make a separate table for this question? Should I keep all questions with percentages for answers together in a table? Ecohouse wrote: > I was discussing a project today and a question came up about using a > transaction table. I need to recreate an input form with many > different types of questions. The following is one type of question: > > 3) How would you characterize the racial/ethnic composition of the > individuals served by your program? What is the percent for each? > > ___American Indian or Alaskan Native > ___Asian > ___Black/African-American > ___Hispanic or Latino > > So what would be the best approach for this? Should I make a separate

Renaming a table
The ability to rename a table (alter table X rename to Y) was there in 8.1.6... but was it there in 8.1.5, 8.0, or 7? Strangely, I don't have those CDs to hand to find out. Anyone remember that far back??! Regards HJR "Howard J. Rogers" <hjr@dizwell.com> wrote in message news:409a991d$0$20347$afc38c87@news.optusnet.com.au... > The ability to rename a table (alter table X rename to Y) was there in > 8.1.6... but was it there in 8.1.5, 8.0, or 7? Strangely, I don't have > those CDs to hand to find out. > > Anyone remember that far back??! > > Regards > HJR > On 7.3 it was rename table_a to table_b. hth. paddy_nyr wrote: > "Howard J. Rogers" <hjr@dizwell.com> wrote in message > news:409a991d$0$20347$afc38c87@news.optusnet.com.au... > >>The ability to rename a table (alter table X rename to Y) was there in >>8.1.6... but was it there in 8.1.5, 8.0, or 7? Strangely, I don't have >>those CDs to hand to find out. >> >>Anyone remember that far back??! >> >>Regards >>HJR >> > > On 7.3 it was rename table_a to table_b. hth. Well, you can