Feature Requests
It occurs to me that the blog format isn’t entirely conducive to conversations initiated by you folks out there in big wide world. If you’d like to see particular features implemented for the calculator, this page can be a home to those requests. Tack your comment onto this page for easy reference.
73 Responses to “Feature Requests”
By kbudnick on Jul 24, 2008
Hi, Brett-
I work in a call center that uses your amort calculator about a bazillion times a day. When we print we have to highlight and only print selection to get just one page- otherwise it prints with extra blank pages. A bazillion times 2 adds up to a lot of wasted trees and I am sure that not all of us are using the selection feature. Can you adjust your amort page to just print one sheet? Thanks for helping conserve if possible.
Kimberly
By Bret Whissel on Jul 25, 2008
Hi, Kimberly. The page-printing mechanism is a function of the web browser you’re using, not a function of the calculator itself. I will make what adjustments I can, but please let me know what browser you’re using (and which operating system) so that I can test changes (if I have a similar setup).
By Bret Whissel on Jul 31, 2008
Hi again, Kimberly. While I was testing out some minor calculator formatting changes on Internet Explorer, I saw the blank page behavior that you were describing. I don’t know how to get around this, since it’s something that IE does that my own browser (Firefox) does not do. If you have the option of using a different browser to print amortization schedules, then using Firefox will save paper.
I will still attempt to play around with things to see if I can make IE behave, but since I don’t do development in a Microsoft environment, it isn’t always easy.
By Linda R S on Aug 5, 2008
I can’t get the amortization schedule to print out at all. I never had any trouble with your old format.
Help!!!
Linda
By Bret Whissel on Aug 5, 2008
Hi, Linda. Can you tell me which browser and version, and operating system version you’re using? Printing is really a function of the browser, not the calculator itself, and I try to test things on several browsers, but I don’t have access to everything that’s out there.
By Chappin4tay on Aug 7, 2008
Bret, I love your calculator and use it all the time to analyze commercial real estate scenarios. One feature that would be convenient for me would be to have a debt constant tabulated in the Summary area. Could you make that happen? -Thanks
Kevin
By R Michael on Aug 11, 2008
Your amortization calculator helped me to meet a need for two friends in a used-car deal. Thanks for making this utility available.
By Bret Whissel on Aug 11, 2008
Hi, Kevin. I’ve added a calculation for a debt service constant to the summary calculations, expressed as a percentage. The value is adjusted if the loan is less than a full year, and the debt service constant is not calculated at all if there is a balloon payment as it’s unclear exactly how this case should be handled. (If any industry person wishes to contribute some guidance for how this value should be calculated in such a case, please let me know.)
By Bret Whissel on Aug 11, 2008
To R Michael: You’re welcome, and thanks for the props!
By Trailerman on Aug 13, 2008
Bret,
Can you add a date option so the date of the final payment shows (based on the loan start date)?
Thanks,
Michael
By Bret Whissel on Aug 13, 2008
Hi, Michael. See the FAQ, Question #12 for part of the answer.
With that said, I do now intend to make some major improvements to the calculator over time, including the ability to print dates. As this requires an overhaul of the user interface, I can’t say exactly when that will happen, but it’s on the docket.
By Trailerman on Aug 13, 2008
Bret, Thanks for the (very) quick response. I hope that when you make changes to the calculator I don’t lose the ability to solve for the term in months since that is what I use most and is so hard to find in an amortization schedule calculator. I like to have the interest and payment set as nice easy to remember numbers and to solve for the term (with an odd figure for the last payment only).
Thanks again,
Michael
By Bret Whissel on Aug 13, 2008
No problem, Michael. I don’t intend to remove features. The real challenge is to avoid adding too much complexity to the user interface (though some additional input will be required).
By thantorp on Aug 19, 2008
I have been using your calculator for years and it is nice to now be able to thank the creator of it. Thanks for a great tool. If you do any additions, the ability to have interest only payments for a time and then start the principal reduction after a set time would be nice. Thanks again. Your calculator makes my job much easier.
By Bret Whissel on Aug 19, 2008
You’re welcome, thantorp. I’ll keep your suggestion in mind as I consider improvements to the calculator.
By tzerrilla on Aug 20, 2008
Bret, thank you for the availability of your calculator. I was using it to figure amortization on a $ 300 million financing,
and it seemed to have trouble performing the calc; it appears to me (although I am probably wrong) that the threshhold for a principal amount is 21,474,836.48 Was trying for 300 million, 20 year, 40 payments, 5% money, no balloon payment. Please advise what I am doing wrong. Best regards, Tony
By tzerrilla on Aug 20, 2008
Bret, I meant a $ 30 million loan, not $ 300 million. Thank you. Tony
By Bret Whissel on Aug 20, 2008
Hi, Tony. Yes, there is an upper bound of about $21 million. The limit is imposed by the CPU’s native word size, which overflows when rounding to pennies around that point.
I have plans to do away with this limit, which requires using an “infinite-precision” library. All input, output and all the calculations will need to be re-written, so it’s not trivial. But when it’s done, we’ll be able to do amortizations of the national debt (if we were so inclined, and not prone to despair).
By rjhancock on Aug 26, 2008
You stated in your FAQ that you did not know how the US banks handled bi-weekly payments.
The only time the payments effect the principal is when it is either a bi-weekly amortization or a simple interest loan. Otherwise, splitting the payment in half and paying twice a month is the same as paying once a month to the bank. They treat it the same.
Most banks use either a monthly or annual re-amortization schedule.
By Bret Whissel on Aug 29, 2008
Hi, RJHancock. I appreciate the input. Do you work for a bank or other financial institution?
By Jeanine on Aug 30, 2008
Hello,
I have checked out several amortization schedules and I like yours the best.
Thank you for making that available to the general public for free. I am learning to create websites and I know how time consuming entering all the correct code is.
The only thing I would love to see (like Trailerman suggested above), would be a date field so I could see the final date when my home will be paid off without counting the lines (although you do have them divided in monthly segments).
Again, thanks so much!
By angelideet on Dec 30, 2008
Hi Bret!
I’m an FSU grad and I use your calculator all the time.
One feature I can’t find on any amortization calculator on the web is one that would calculate the number of payments and amount of interest saved if the borrower pays the following month’s principal with their monthly payment.
I used to work for a financial institution that had a program that could run that calculation, so I know it can be done.
Thanks!
By Bret Whissel on Jan 4, 2009
That’s an interesting idea, angelideet, but I’m not convinced it’s a generally useful calculation, though it may have a small bit of marketing appeal.
In the beginning of the loan, the principal may be a small amount compared to the interest portion of a payment, so paying the next month’s principal in advance does not pose too big an additional burden. But toward the end of the loan, the principal portion is substantially larger. In addition, since the principal portion is always changing, the payment amount under this acceleration scheme would be constantly changing as well. My feeling is that people would prefer to budget for some sort of fixed payment amount by which they may evaluate various acceleration plans.
Of course, one could always set up a spreadsheet to do the calculation you have suggested, if that’s useful to someone.
It’s great to hear from an FSU grad! Spring semester starts up on Tuesday.
By angelideet on Jan 5, 2009
Thanks for the answer, Bret.
I’d love to have a spreadsheet for this calculation and payoff date for that very reason. It would be helpful to see how large my payment will become while factoring in the early payoff date.
My situation may be unique, but I have an 80/20 loan and I plan to complete payments on the second early and then roll over my budgeted amount for the second mortgage just in time for those substantially larger principal payments.
I have been accelerating my payments this was for about four years and since the payment goes up about $1 per month, I’ve found that it’s pretty easy to budget for it.
Thanks for the note!
By JackieJoy on Jan 19, 2009
Hi Bret!
In using your amortization schedule I can’t seem to make it work for me because I just need the schedule printed with no balloon payment. I have the principal, interest rate, pymts per yr, no. of pymts, and what I want my payment too be and just need a schedule printed out for me. Is that possible? I tried just putting 1.00 in the balloon payment slot but thought there must be a better way. I’m borrowing from my mom and wanted a printed copy for each of us.
By Bret Whissel on Jan 22, 2009
Hi, Jackie. The calculator is designed to fill in whatever field has been left blank. If you fill in all the blanks and there’s nothing left but the balloon payment, it dutifully fills in that value given all the other data.
If you don’t want the balloon payment amount to be filled in, leave one of the other fields blank (like the payment amount field). If the payment amount turns out to be not what you expected, perhaps you might leave the interest rate field blank instead.
By shopnodeb on Feb 15, 2009
Hi Bret,
The calculator is designed to fill in whatever field has been left blank. Cant u omit one the fields??? or cant u show us the way how we can customize it..???
By Bret Whissel on Feb 15, 2009
I don’t understand your question, shopnodeb.
By jimsturdevant on Apr 2, 2009
Hi Bret:
Great calculator. Maybe you can help me with a problem? I need to figure out a amoritization schedule where the first payment is delayed for 3 months and a ballon is due at 84 months. The current schedule covers all of the other variables I need to deal with.
Keep up the great work!!
Thanks,
Jim
By Bret Whissel on Apr 3, 2009
Hi, Jim.
I don’t work in finance in any way, so I don’t know how the industry typically handles such scenarios as the one you’re suggesting. Also, the calculator has no provision for a delay in the payment schedule. However, with a minimal amount of additional calculation, it may be possible to make it work out.
One reasonable approach is to allow the accrued interest during the non-payment period to be added to the principal amount when regular payments begin. For the sake of example, let’s choose some round numbers for convenience: $12,000 loan at 6%. For monthly payments, the periodic interest rate might be 0.5% (6%/12 months).
Method One, Simple Interest: Before payments have begun, the monthly interest due on the outstanding principal is 0.5%×$12,000=$60 per month. If payments are to begin 3 months from the beginning of the loan, then 2 additional months have been added, so add $120 to the principal amount (e.g., $12,120), and run the amortization.
Method Two, Compound Interest: Should the lender require a compounded interest calculation, the math is slightly more complicated. The formula is P×(1+i)n, where P is the principal amount, i is the periodic interest rate (0.5% here) and n is the number of non-payment periods (2, in this case). Using our numbers, the new principal amount when payments begin is $12,120.30.
The lender may have even more creative ways of handling this payment moratorium stuff. Again, I’m no authority!
Best wishes,
Bret
By carolinesmith@netspace.net.au on May 20, 2009
Hi Bret
I am an accountant.
Just wondering if the calculator can accomodate the following situation;
I have a client with a 5 year Chattel Mortgage and repayments are made monthly. I have 2 balloon payments though. One payment made in month 4 and another at payment 60.
Many Thanks
Caroline
By Bret Whissel on May 20, 2009
Hi, Caroline. I’m sorry, but the calculator has not been designed to handle this particular case. I would think a well-designed spreadsheet would be the right tool for this problem.
Regards,
Bret
By Jack on Jun 3, 2009
Bret – My company uses your calculator exclusively and we think it is the best out there…well done! The only problem is that our competitors (other mortgage cos) are listed in the Google Ads. When we print the calculator results to a pdf and email them to a prospective client we’re unintentionally advertising for the competition! I know you like the income from the ads but is there a way that they can be excluded when printing? Thanks!
By Bret Whissel on Jun 3, 2009
Hi, Jack.
In fact, ads should be excluded from printing already. If you are using recent versions of Firefox, Internet Explorer, or Safari, and if you are using the browser’s print function, ads should not be printed at all because a different style sheet is used.
It may be that you are using an older browser, or a browser that isn’t aware of stylesheets, or perhaps your browser is configured to ignore alternate stylesheets for printing. Or maybe you’re printing a screen capture rather than using your browser’s print function.
Bret
By dakotaslim on Oct 22, 2009
I love your calculator but I often find I’m taking out loans for very short periods of time such as 2-3 months. It would be nice if I could do calculations for less than one year.
By Bret Whissel on Oct 22, 2009
Hi, dakotaslim. You can do these calculations. In such cases, if the payments are to be monthly, then you still set the Payments per Year to be 12; or if weekly, set this box to 52, etc. The Number of Regular Payments does not have to run out to a full year, so if the loan is for 3 months, just enter 3 here. However, the periodic interest rate is calculated as if it’s a full year, so if the rate is entered as 6%, that’s assumed to be an annual rate with a 0.5% monthly periodic rate (for example), not a 6% interest over the 3 months of the loan.
By jimechols on Oct 26, 2009
Hi Bret, your calculator is a great tool and I use it often. With that in mind, any chance that a “date” column be added? This would make it easier to determine the payback date on a refinance. Thanks, Jim
By Bret Whissel on Oct 27, 2009
Hi, Jim. Dates may get added someday. For a more complete response, see the FAQ, question 12.
Bret
By kimmer on Jan 8, 2010
Hi Bret –
Do you know of a program that can track actual mortgage payments and late fees and calculate interest? I can’t seem to find anything like this on the market.
The Co I work for holds approx 6 mortgage notes and when someone doesn’t pay on time or skips a month and pays twice the next month we add a late fee, but don’t know how to calculate the interest and in the end… we are losing big time.
I think if something like this were on the market, it would be very profitable.
Thanks!
Kim
By Bret Whissel on Feb 15, 2010
Hi, Kim. I don’t keep up on what’s available on the market, so I’m not aware of such a program. I’m sure there’s a large degree of variability in how lenders deal with the situation you’ve described. Doing the calculations would probably involve a bit of in-house customization.
By jcfinc on Feb 27, 2010
How can I get the code to add this really neat calculator on my website?
By Bret Whissel on Mar 1, 2010
Hi. I have not released the source code to the calculator. It was written in the earliest days of the web, and there are better ways of implementing the program with newer technologies. However, I have released the equations on which the calculator is based, so a competent programmer should be able to implement the calculator suited to your environment.
By imaginemuskoka on Apr 7, 2010
Hi Bret, fabulous calculator, I’m not a competent programmer – is there any way at all to get the calculator.
By Bret Whissel on Apr 7, 2010
Hi, IM. Sorry, but the calculator is not available in any form at this time.
By cbblalock on Jul 15, 2010
I have used your Mortage-Loan Calculator many times..what a wonderful tool for me in my work. Thank you from South Dakota.
By groo on Jul 23, 2010
I don’t mean to be a bastard, I know you’d like to make a few bucks off you great tool, but the flash advertisements are just too much for me to handle. It’s your page, you do as you like, but just thought I’d let you know!
By Bret Whissel on Jul 23, 2010
Are there particular ads that you find offensive or annoying? I do occasionally block ads that I personally find too distracting.
By groo on Aug 14, 2010
It was a video advertisement. Just too much motion on the screen when I’m trying to figure out how the hell I’m going to pay off my car loan
By Adagio512 on Sep 29, 2010
I have two simple interest loans that I need to pay off. As far as I can tell you only have compound interest calculators. I really need the amitorization schedule since I will be tranferring principal payments as I pay off a credit card and the first simple interest loan i.e. many different scenarios. Your interface is so convenient and easy to use. What say you?
By Bret Whissel on Oct 6, 2010
Hi, Adagio. I am planning some future updates to the calculator, and I will consider your request as a potential feature enhancement. However, it’s not likely to happen soon enough for your needs.
By Adagio512 on Oct 11, 2010
I will be using the tools you create for a while so I look forward to your enhancements. Thank you for considering my request.
By goaway on Oct 18, 2010
Can you create a standalone version of this calculator?
By Bret Whissel on Oct 18, 2010
Creating a stand-alone calculator is a matter of resources and time. At present, I have neither. However, it is a project I hope to accomplish “someday”. But please don’t hold your breath waiting for it.
By Ken on Jan 15, 2011
Hi Bret,
I love your amortization calculator, because it is powerful; yet, easy to use! Our mortgages up here in Canada are similar to yours in the USA; however, they compound semi-annually instead of monthly.
Is there any chance that you might someday add a Canadian amortization calculator?
Keep up the great work, and God bless you!!!
By Mark on Jan 15, 2011
Bret – Love the Amortization Calculator. Thanks so much for your devotion to it! Any chance for an IPhone app? I particularly like being able to specify the payment amount and calculate an odd last payment. I’ve not found that in an app with all of the other features (like printing an amortization schedule) that you provide.
By mmm on Jan 16, 2011
Like Angidileet, I have set a goal of doubling my principal payment each month. Since my total minimum monthly payment (principal interest AND escrow) is fairly small, it’s likely my income will grow to the point where I can afford to double that payment (more or less what the last payment would be under such a scenario, with some variation to account for the escrow).
It would sure be great if your calculator could calculate this! If not, perhaps you could provide me with the equation?
Thanks so much for putting this up–its the easiest-to-use mortgage calculator I’ve found on the internet yet.
By Bret Whissel on Jan 28, 2011
Hi, Ken. I do have plans for upgrading the calculator to allow for different compounding periods. I’m not sure when this feature will be added, but it will happen someday.
By Bret Whissel on Jan 28, 2011
Hi, Mark. I’m always glad to know that people find the calculator useful, and I have thought about how to make it available as an iPhone and Android app. I may have some time this summer to make it all happen.
By Bret Whissel on Jan 28, 2011
Hi, MMM. There are any number of ways to accelerate mortgage payments. The method you’re proposing is just one more. Finding a closed-form solution to the recurrence relation that would arise is probably not generally applicable to any other scenario, and as such, it isn’t a feature I’m likely add to the calculator.
You can certainly play around with this sort of thing in a spreadsheet, however.
By todylynne on Jan 30, 2011
Hi I have ask a question before but it doesn’t seem to be there. Your amortization used to subtract monthly payment and show the interest as to what was paid as of now. Now it is showing it backwards is there a way to calculate it opposite to how you have it now.
By Bret Whissel on Jan 30, 2011
Hi, Lynne. Your previous question was under “Questions”, not “Feature Requests”. I did not understand your previous question, and I’m afraid I still don’t know what you’re asking: the calculations have remained the same for quite a number of years, so I don’t really understand what you mean by “backwards” from what it used to be. Perhaps it would help me to understand if you gave me the calculation parameters you have been using.
By smartin1234 on Apr 7, 2011
Hi Bret, I have found your calculator so useful that I would like to make a donation. Do you have a pay pal account?
By Bret Whissel on Apr 7, 2011
How kind! I greatly appreciate the sentiment. I am not set up to accept donations for use of the calculator. If you feel strongly about this, you could make a contribution to a charity of your own choosing instead. I could recommend Heifer International, Doctors Without Borders, the Electronic Frontier Foundation, or your own local public radio and television stations (to name just a few organizations of many thousands).
Thanks!
Bret
By smartin1234 on Apr 30, 2011
Hi Bret,
Sure, I will make a donation to a charity.
Thanks again,
Scott
By Mike on Aug 22, 2011
Bret, I have looked for and used many online calculators and found yours to be the best. Do you create other online calculators?
By Bret Whissel on Aug 22, 2011
Hi, Mike. I haven’t made any other calculators. What is it that you’re looking for?
By Mike on Aug 25, 2011
I am looking for a simple calculator that tallies orders and calculates the profit and cost at the same time. I am a wholesaler for fundraising products and I currently use a homemade excel file. Which works nice for people who have the correct software. Often times people are not able to download the file making it useless anyway. I would like something like yours that is web based, is this possible? Thanks for your time.
By Mike on Aug 29, 2011
Bret, I could email the calculator if you would like. Thanks.
By Mike on Sep 8, 2011
Perhaps you could suggest someone else or point me in the right direction? Thank you.
By Mike on Sep 19, 2011
hello??????????
By Bret Whissel on Sep 26, 2011
Hi, Mike. Sorry for the delay in responding: the start of a new school year always kicks my butt, and I don’t have much spare time for a few weeks.
What you’re looking for is certainly possible, but would require some custom programming if you want a web app. If you’re going that route, you might consider a smart phone app (iPhone and Android are the most popular platforms) over a web app. Unfortunately, I don’t have the time right now for doing this kind of development.
The advantage of a spreadsheet is that you can do the work yourself and share it, though as you say, people would need the software to run it themselves. One option would be to look at the Google web apps (they have a spreadsheet). If you developed your spreadsheet there, anyone with web access would be able to use your spreadsheet online (theoretically). Another option is to point people to some free software, such as OpenOffice or LibreOffice which supply a whole suite of standard office applications, or Gnumeric, an open source spreadsheet (which has a build for Windows).
Good luck!
Bret
By Mindi_1227 on Dec 8, 2011
Good Morning,
I’ve used your amort calculator several times and it is a dream! However, I do have one loan that is an oddity and I cannot find a amort schedule to help me. Here’s my scenario…
Loan amount is $240,000 at 4% interest beginning 10/05/2011 with the first annual payment due 12/30/2012. After that payment is made, the payments increase to $20,000 annually at the same interest rate due every 12/30 until the loan is paid in full. I work at a title agency and our system is cannot produce an amort schedule where the first pmt is due the following year. Any help is greatly appreciated!
Thanks, Mindi
By Bret Whissel on Dec 11, 2011
Hi, Mindi. This isn’t just a math problem, but a matter of how the extra time is handled by a contract. There are several reasonable possibilities, I think, and as I do not work in the finance industry, I am not qualified to help you answer this question.
Bret