amortization math

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? Is it possible to use an equation
rather than a table?
If you CAN help, please EMAIL ME!
I appreciate any help. Thanks.

.

Relevant Pages

  • 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)
  • Re: new water softener needs adjusting?
    ... I TOTALLY agree with your math. ... That is 21 months of payments at $25 per ... savings, your net cost over 2 years is $237, less than 10 of ... Don't tell me that you cannot afford to have ...
    (misc.consumers.house)
  • 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)