Questions

If you have a question about the calculator or about amortization, attach a comment to this page. But please, be sure you’ve checked the FAQ Page first. (You’ll need to create an account to post a comment.)

183 Replies to “Questions”

  1. Hi Bret,

    Thank you for your loan amortization calculator. I have been using it for years. I have a question, but I’m not certain you can answer it. It is outside the parameters of loan amortization. I have an annuity, with a cost basis of $108,000.00 at 4.0%. It’s value right now is $176,000.00. I want to amortize it over 8 years. I calculated the payment to be $2,145.00 per month. Is there a way to determine the taxable amount, or the amortized amount over the original investment amount of $108,000.00.

    Thank you very much for your time and consideration. I don’t need a reply if this type of question is too specific.

  2. Thank you for your amortization tables. It’s been helpful and has given me a bit of peace of mind over the past several years.

    Very helpful when trying to decide to pay off one debt or pay down several debts simultaneously. (Debts are now erased, thank you).

    My new favorite word is amortization.

      1. Hi Bret
        I use your calculator all the time for Notes/ loans when I sell Real Estate but I have this guy now that wants to pay me back and pay down the note by including a few hundred extra whenever he can afford it each month and I don’t mind but screws up the amortization and just wondering if your schedule could be payment driven automatically generating a new amortization schedule automatically adjusting number of payments left balance I think you get the idea what say you?

        1. Since no single general-purpose formula can account for it, you would need a spreadsheet or special-purpose application to track random extra payments and adjust the amortization schedule accordingly. You can get started with the spreadsheet linked from this site.

  3. Hi Brett,
    I’ve been using your calculator for my business of quoting notes and buying and selling mortgages ( http://www.nicholasdicaro.com ) for the last 4 years as it is absolutely the best, most accurate, and versatile free version online. My business has grown so much that even a very intricate software like Tvalue won’t meet my needs so I am currently developing my own custom-made software to meet the needs of my business only to realize how complex and daunting this task can be (I’m the designer, I hired 2 javascript coders). Anyway, I was wondering if you could give/ sell me your API / code for the site/ calculator in exchange for money or something else? Any consideration is greatly appreciated. Best, Nic

    1. As a general answer to this sort of question, the current version of the calculator was written in the nascent days of the web: it is not in a form easily ported to current web technologies. I am considering updates which could be more useful to folks these days, but it’s a back-burner project that doesn’t get much time on the fire.

  4. Hi Bret,

    I am having trouble with an amortization schedule I’m hoping you can help with…
    loan amount- $117,000 at 6%
    monthly payment $750
    quarterly payment- $2500, all of this goes to the principal

    Can you help me or suggest how I go about calculating an amortization schedule and an effective interest rate for this?

      1. When one drafts a mortgage there is a category that says: Calculation Period. Usually the big banks say ‘semi-annually, not in advance’ but this is not correct using your program. How would you describe the calculation period?

  5. I am trying to figure out the following
    :
    a new $15 million loan at 4.25% interest (monthly interest only payments for 3 years)
    then: monthly P&I payments for 7 years at 4.25% on a 30 year amortization schedule

    Question is what is the overall yield to the lender if I only receive $13,300,000 of the loan proceeds(($1,700,000 buydown)

    1. Hi, Rob. I have researched some typical commercial loan scenarios in an effort to make the calculator more useful in such situations, but I haven’t had time to spend on the calculator in quite a while. If I ever do get to work on it again, this is certainly a feature I will be targeting.

    1. Hi, MJay. The calculator is only designed for amortization, so it cannot handle an interest-only scenario. (Since principal is not reduced in an interest-only scenario, the payments would never end. A hand-calculator can calculate the interest payment for you.)

  6. Bret – thanks for the calculator. I use it often. One number I can’t seem to find the formula for is what you call the Debt Service Constant. I have several loans, and when I ran them through your calculator, I took note of the DSC’s. They seemed to correlate to the more effective use of a dollar towards principal. Would you mind sharing the calculation so I can use it going forward to decide what gets paid off faster? Thanks, Steve

    1. Hi, Steve. What I refer to as the Debt Service Constant is also known as a loan constant or mortgage constant. It is calculated as the ratio of the total amount of the annual payments (including principal and interest) to the principal borrowed, expressed as a percentage.

      As an example, if you borrowed $120K and your total payments annually are $12K, the Debt Service Constant would be 12K/120K, or 10%.

  7. Hi Bret,
    Thanks very much for this great tool. Today (July 8, 2014)the amortization schedule did not appear following calculations in Firefox. It still worked fine in IE.
    Regards,
    Burque

  8. Hey Bret, I am a software developer and am currently working on an APR calculation for a client. Your calculator delivers the same results as their current system which uses a VB rate function, and I have been trying to achieve this, but have been unsuccessful thus far. I was wondering if you could explain the math behind being able to calculate the APR from the principal, the payments per year, the number of payments, and the periodic payment amount? Thank you for any help you can offer.

    1. Hi, Sean. As far as I know, there is no analytic solution for finding the APR: you can’t re-arrange the algebra to make it work. This is not an uncommon problem. The solution must be found numerically by guessing at the correct value for the APR, plugging it into the equation, evaluating whether the guess was too big or too small, and then revising the guess appropriately. One can keep doing this iteratively until the error of the guess is within some acceptable tolerance. This is how my calculator does it.

Leave a Reply