Re: amortization math

In article <1189022419.676271.93240@xxxxxxxxxxxxxxxxxxxxxxxxxxx>,
<realestatequestioner@xxxxxxxxx> wrote:
I have studied a lot of math, so I am familiar with a lot of different
types of equations, but I still can't figure out where the
amortization tables get their values. I have used logarithm and
exponential equations, but I can't figure out the tables. When I look
at (1) the initial principal I borrowed, (2) the number of payments I
make each year, (3) the amount of each payment, (4) the total number
of payments I am required to make, it seems that I should be able to
calculate (5) the APR. But my attempts at calculating the APR never
seem to match the APR that the lender has quoted me. He is just using
a computer program, and doesn't understand the math himself. I don't
want to accuse him of anything until I am sure I am doing this right.
Can anyone help me find an equation that l can use to calculate the
APR from: the principal, payment amount, number of payments per year,
and total number of payments?
If you CAN help, please EMAIL ME!
I appreciate any help. Thanks.



http://mortgage-x.com/library/answers/amortization.asp




http://www.richmore.com/mortgage/excel/





A+rtKamlet@xxxxxxx remove +
--


ArtKamlet at a o l dot c o m Columbus OH K2PZH
.

Relevant Pages

  • Re: Amortization Calculation in Excel worksheet
    ... amount, the interest rate, the number of payments per ... & the scheduled payment amount. ... the template will not work unless I enter the loan period ... There is no determined loan period for these ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help!! Combine two identical columns in a table.
    ... i think you can first make a union query in order to put 2 columns in one, ... Method of Payments and Method of ... > Is it possible on a form or report to pull identical payments in the same ... > the Method of Payment Amount and Method of Payment #2 Amount would pull ...
    (microsoft.public.access.modulesdaovba)
  • Re: amortization math
    ... at the initial principal I borrowed, the number of payments I ... the principal, payment amount, number of payments per year, ... It is the nominal annual rate. ... Calculate the periodic rate (probably ...
    (sci.econ)
  • amortization math
    ... I have studied a lot of math, so I am familiar with a lot of different ... at the initial principal I borrowed, the number of payments I ... a computer program, and doesn't understand the math himself. ... the principal, payment amount, number of payments per year, ...
    (misc.taxes)
  • amortization math
    ... I have studied a lot of math, so I am familiar with a lot of different ... at the initial principal I borrowed, the number of payments I ... a computer program, and doesn't understand the math himself. ... the principal, payment amount, number of payments per year, ...
    (sci.econ)