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”

### Leave a Reply

You must be logged in to post a comment.

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.

I’m sorry, Ross, but I can’t speak at all to taxable values of anything.

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.

I’m always delighted to know that the calculator has been helpful to folks. Thanks for taking the time to write!

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?

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.

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

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.

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?

Hi. The calculator is only designed for fixed regularly-spaced payments. You would need a tool like the spreadsheet to assist you with the extra payments every quarter.

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?

I do not come from a finance background, so I’m not always familiar with the terminology and semantics. I don’t know the answer to this one.

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)

Hello. Your question is beyond my field of expertise. Sorry, I can’t help you with an answer.

Hello Bret,

Can this amortization program be modified to use for commercial loans based on 365/360? If it already is able please let me know how.

Thanks

Rob

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.

How do I run an Interest only calculator Schedule for my IRA?

Thank You

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.)

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

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%.

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

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.

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.