Claudia,

If you have Microsoft Excel on your computer, you have all the calculator 
you need.

For example: To just calculate the basic payment for a mortgage use the 
=pmt function.  Let's say you have a 30 year fixed mortgage at 5% per 
year, compounded monthly and the principal is $100,000 you would just type 
the following into any cell in an Excel spreadsheet.

=pmt(5.0%/12,360,100000)

There are also functions to calculate how much principal or interest has 
been paid over a period of time.  And, as someone else has mentioned, you 
can get Excel functions that will produce the entire amortization table, 
but the three functions I mentioned above give you all the same 
information.

Hope that helps.


  -- 
Blue skies.
Dan Rossi
Carnegie Mellon University.
E-Mail: [email protected]
Tel:    (412) 268-9081

Reply via email to