Please tell a friend about us. Thank you.

The Ultimate Financial Calculator (UFC) is the most sophisticated, most flexible calculator on financial-calculators.com and I think on the entire internet. It works extraordinarily well as both a time value of money calculator and as a loan or mortgage payoff calculator.

See the tutorials below for step-by-step instructions.

If you are someone who needs date accurate results with irregular cash flows (loans, payments, deposits, withdrawals, investments), this is the calculator you should study and use. Questions? Remember, I'm here to help. More below...»

Need a Mortgage Calculator with Support for Taxes, Insurance and PMI?
Check out the Mortgage Payment Calculator with PMI.
It too creates a printable amortization schedule.
Need an Investment Calculator that Takes Into Account Inflation, Taxes and Fees?
Here's an Investment Growth Calculator that does just that.
IdxNoSeriesDateAmount# PeriodsFrequencyEnd DateSeries OptionscmpFreqspecialSeriesTypeSpecialSeriesStruct
©2016 financial-calculators.com, all rights reserved
$ : mm/dd/yyyy
  Original Size  

What is Time Value of Money?

Time Value of Money (TVM) is the concept that the value of money itself changes over time. Having a dollar today is worth more than a dollar tomorrow. Solving for present value, future value, amount, interest rate and term are some standard time value of money (Wikipedia) calculations. The UFC is capable of performing any of these calculations with regular or irregular amounts as of any date for investment, savings or loan cash flow.

Time value of money example

As a time value of money calculator, UFC can calculate unknown amounts for complex and irregular cash flows. The below example answers the question, "How much do I need to invest for 48 quarterly periods to have a total future value that will then let me withdrawal $1,000 monthly for 180 months?"

To answer this question, set the calculator up as shown:

time value of money calculation setup
Time value of money unknown cash flow setup
time value of money calculator result
TVM calculator showing unknown investment cash flow amount result

If you are someone who regularly needs to do TVM calculations, then it is worth your time to study the features this calculator offers. It can replace easily three-quarters of the calculators found on this site — and on other websites too!

Calculator's Features

Solve for any unknown

  • Payment or loan amount
  • Deposit or withdrawal
  • Yields: APR, APY or IRR
  • Balance as of a specific date
  • Date a specific balance is reached *
  • Present value (PV)
  • Future value (FV)
  • Balloon payment amount
  • Payment required to reach a specific balloon
  • Number of payments
  • Interest rates - nominal or effective *
  • Discounted values
  • Remaining balance
  • Deposit required

Any type of calculation method

  • Normal amortization or investment
  • Rule-of-78s
  • Canadian methods
  • US Rule — simple interest
  • Supports 360, 364 and 365 day years
  • Exact day or periodic interest calculations

Scheduled (but adjustable) Payment Frequencies

  • Daily
  • Weekly
  • Bi-weekly
  • Twice monthly (Half-month)
  • Every 4 weeks
  • Monthly
  • Bi-monthly (every two months)
  • Quarterly
  • Every 4 months
  • Semi-annual
  • Annual

 * Feature only available in C-Value! ™,
our cash flow calculator for Windows™

Flexible Reports & Schedules

  • Amortization & investment schedules
  • Schedules with details or totals only *
  • Custom headers and labels *
  • Change fonts, colors *
  • Select a fiscal year end *
  • Reg. Z APR disclosure report *

Handles any type of cash flow

  • Normal
  • Interest only
  • Enter your own payment amount
  • Negative amortization
  • Skipped payments or deposits
  • Fixed principal + interest
  • Percent step amounts
  • Dollar step amounts
  • Balloon payments
  • Extra payments — principal only
  • Payments to interest
  • Cash flow amounts set to any random date

Compounding Frequencies

  • Exact day simple
  • Daily compounding
  • Weekly
  • Bi-weekly
  • Twice monthly (Half-month)
  • Every 4 weeks
  • Monthly
  • Bi-monthly (every two months)
  • Quarterly
  • Every 4 months
  • Semi-annual
  • Annual
  • Continuous
  • Change the frequency of compounding during a cash flow
  • No compounding option when rate changes

Using UFC as a Mortgage or Loan Payoff Calculator

A well-designed loan payoff calculator will answer any of these questions:

  • How many payments do I have left?
  • When will my loan be paid off if I make extra payments?
  • What payment is required to pay a loan off by a given date?
  • The borrower missed payments, paid late and paid additional amounts and there were interest rate changes, what is the exact loan balance due as of today?

Answering the first three questions is straightforward and takes but a second, but, as you may have guessed, calculating the payoff amount for the fourth scenario is more involved. For instructions on how to use the UFC as a tool for tracking a mortgage or loan balance with payment and interest rate changes, read my tutorial Calculate Loan Balance — Loan Payoff Calculation.

Mortgage or loan payoff examples

If you want to know how many payments are left or when the last payment is due, enter the current interest rate (4% for our example) and set compounding. Then in row one, enter the last known loan balance and the balance as of date ($250,000 and Sept. 1). In the 2nd row enter the due date of the next payment after the loan balance date in row one (this may also be the balance date), enter the scheduled payment amount, set "#Periods" to "Unknown" and set the payment frequency (monthly). Your screen will look like this:

loan payoff calculator setup
Loan payoff calculator setup

After clicking "Calculate," your screen should look like below. There are 143 remaining payments, and the last payment will be due on August 1.

loan payoff calculator result
Loan payoff result showing payments remaining and due date of the last payment.

Now, let's delve in a bit deeper. You plan to pay an extra $150 a month on your mortgage, and you want to know the payoff date. The UFC excels as an early payoff calculator. If we use the above example, all you need to do is change the payment amount to $2,350.00 and set "#Periods" to "Unknown" again.

mortgage payoff calculator setup
Example showing early loan or mortgage payoff calculator setup

Click "Calculate" once again. Your screen should look like below. Now only 132 payments are remaining, and the last payment will be due on September 1 a year earlier.

mortgage payoff calculator result
Early payoff result showing payments remaining and due date of the last payment.

Now, if you're lucky, the mortgage is paid off just as the first child is going off to college. :-)

NOTE: You can also specify the number of remaining payments and set the amount to "Unknown" in row two and the calculator will calculate the total payment amount required to have the loan paid off in the number of payments you specify.

Financial Calculations Step-by-Step Tutorials

The below tutorials walk you through the steps for setting up the indicated financial calculation. I recommend that you right click on a link and select "Open in New Window" so you can have the calculator handy in this window as you read.

  1. Calculate Payment
    • loan or mortgage periodic payment calculation
    • also an introduction to this calculator
  2. Investment Cash Flow
    • calculating final value
  3. Calculate Income From An Investment
    • How to calculate income you can expect from an investment
  4. Adjustable Rate Mortgage or Loan
    • ARM with interest rate changes on any date you desire
  5. Calculate a Loan's Term
    • How to solve for an unknown number of payments
  6. Calculate Loan Amount
    • How much can I borrow?
  7. Balloon Payment Calculation
    • Calculate the balloon amount
  8. Balloon Loan Calculation
    • Calculate the periodic payment required to result in a specified balloon
  9. Random Extra Principal Payment
    • How to prepay principal on any date
  10. Loan with Series of Extra Principal Payments
    • How to calculate loan or mortgage with extra payments
  11. Construction Loan
    • Generally a short term loan with multiple borrows
  12. Monthly Skipped Payments
    • Loan or mortgage with scheduled skipped payments
  13. Odd Length First Period
    • Interest payment options for initial period
  14. Interest Only Loan
    • Initial series of interest only payments
  15. Biweekly Mortgage Payments
    • Pay 1/2 the monthly payment every other week to reduce the total interest paid
  16. US Rule
    • No interest charged on interest — separate tracking of interest balance
  17. How much do I have to save or invest?
    • State your goal - calculate periodic investment amount needed to reach goal
  18. Paying for College
    • You may have longer than you think
    • Multiple investments with multiple, overlapping withdrawals
    • Demonstrates solving for unknown in complex cash flow
  19. Future Value Calculation
    • How to set up simple or complex cash flows to calculate FV
  20. Present Value Calculation
    • How to discount a simple or complex cash flow to find its PV
  21. Calculate PV of Fixed Principal + Interest Loan
    • Calculate PV of the declining payment amount
    • Demonstrates the cash flow analytics of this calculator
  22. Calculate Rate of Return (ROR) on Annuity
    • How to set up an annualized ROR calculation
  23. Calculate Time It Takes to Reach Investment Goal
    • Set a goal and see how long it takes to reach it
  24. Calculate ROI for X Days
    • Exact day return on investment calculation
  25. Calculate Loan Balance — Loan Payoff Calculation
    • Enter payments for any amount on date made — audit balance due

Calculators the Ultimate Financial Calculator Replaces

With this calculator's flexibility, it will meet the needs of anyone searching for:

  • loan repayment calculator
  • loan payoff calculator
  • mortgage payoff calculator
  • repayment calculator
  • student loan repayment calculator
  • home loan repayment calculator
  • car loan repayment calculator
  • debt payoff calculator
  • early mortgage payoff calculator
  • debt repayment calculator
  • individual or specialty TVM calculators

Tell us how you use the Ultimate Financial Calculator. And naturally, if you have any questions, feel free to ask them below.

201 thoughts on “ultimate-financial-calculator

  1. I love your calculator and it does exactly what I need to figure out a running balance and interest on a private loan. I want to be able to save the information though instead of re-entering it every time a payment is made. I’m happy to buy your software, but I only have Mac’s. Do you have anything that I can use? Or know of anything I can use? Thank you!

    • Both SolveIT! and C-Value! run only on Windows computers, I’m sorry to say.

      Do you know about Parallels? This software will allow you to run Windows on a Mac and then you can install and run software written for Windows.

      • Hello I will be Pricing Revenue Factoring arrangements. by leveraging a businesses future revenues
        I would need to be able to find total hold back on future receivables, and also calculate syndication RTR.Can a calculator ba made for those functions?

        • Hi Frank, I imagine one could be made. But currently, I have four calculators under development and then at least one more needs to be completed before I consider any other calculators. Also, would you know the math, and if so, can you share it? Or a paper about factoring?

          • Ty for replying quickly Karl , I would be able to write the math that would need to be expressed. It will be for proprietary underwriting formulas I implement , I will gladly share the math with you for others to be able to use also.

          • I’m happy to take a look, but as I mentioned, aside from planning, I can’t possibly start coding anything new until sometime next year.

  2. You are my hero! I love numbers and work in the divorce field, so I often need to do calculations of cash flow, note interest calculations, present value calculations, etc. Your online calculators are absolutely amazing – I really enjoy using them! Thank you for sharing your expertise with us!

  3. I have just discovered your site. I think it might solve my problems, but I am not sure.

    Essentially, I have made three cash advances to a third party during the last three years. It is now time to let them know how much they owe. Each loan has born annual compound interest of 6% p/a.

    The problems I have are two:

    First, there has been a part capital repayment made after a year on one loan.
    Second, there has been an interest payment made on all three loans a year ago. This reflected the amount owing at that time.

    If I sent you the data, do you think you could help? Or perhaps let me know how I might reflect these cash flows in your model?

    I should be enormously grateful if you could help.

    For fairly obvious reasons, I would prefer this was not posted publicly on your site

    Regards

    • This calculator will do exactly what you need. I’m wondering if you noticed the tutorials? Scroll down the page and there are three tutorial you should take a look at. Number 1 will provide a general overview. Then to see how to handle multiple loans within one schedule, see the construction loan tutorial. Finally, check the last tutorial about loan payoffs.

      If after reviewing these, if you have questions, please ask them here.

    • Hello John, I believe I can also help you out answering your questions. I underwrite financial products

  4. How can I save my info so I can use this calculator for the term of the loan? Is that possible?

  5. I see you have 2 programs to purchase. I need it for a home loan with the ability to put in random extra principal payments. I found the ultimate financial calculator had all of this is. Thanks again.

  6. I purchased solve it through your web-site. I would like to be able to change loan start date and first payment date within the program so that I can export to EXCEL and add my company data. I do not see a way to change start date and first payment date within the program.

    Am I missing something?

    Chris

    • Thanks for the purchase Chris.

      SolveIT! includes over 40 calculators. Not all will allow the user to set dates or export to Excel. Please use the C-Value calculator. It is the calculator that this calculator is based on.

  7. Karl,
    You helped me 10 days ago by pointing me to the ‘Ultimate Calculator’ and I want to say that upon figuring out how it actually works via some trial and error (and my old tired brain)….IT IS POWERFUL PRODUCT !!

    I would encourage all users to “just use it”

    Regards and Thanks,
    Mike

    • Hi Mike, great to hear and thanks for letting me know. You’re right, it definitely takes some time to learn how to use all the features. (So your brain probably isn’t the tired.)

  8. We are a church that sold it’s old property and is carrying the note for the buyers.
    The first year they agreed to pay $1000/mo then up the payment to $1500/mo on the 13th month and thereafter.

    They have been paying extra principle as they can, but not on a scheduled basis.

    What I need is be able to calculate the remaining balance after each payment so I will know when they have satisfied the loan repayment,

    The original loan was set to run 15 years and four months to satisfy their desired repayment monthly amounts.

    I would also like to keep a record of each payment so I suppose I would need the C Value Calculator product as well

    • Hi Larry, did you figure out how to do what you need to do? I’m not quite sure if you are telling me how you use the calculator or if you are asking a question since no actual question was asked. If how to do the calculation is not clear, please scroll down the page and read tutorial #25 Calculate Loan Balance — Loan Payoff Calculation. Check tutorial #1 as well for an overview.

      Yes, C-Value! will let you save your payments to disk.

      • I basically need a monthly record of their payment amounts including extra principal and the remaining balance of the loan each month.
        I would want that data in a file for a permanent record.

        Is C Value product what I would need to do both?

          • I tried to go to the Store and order C_Value but it keeps saying my cart is empty

            Is there another way I can order it? Also is it downloadable to my PC?

          • Sorry you had a problem Larry. By the price, there is an "add to cart" button. Did you click on that, and if so, did you get back any errors? I just tried it and the software was added to the cart.

  9. I am trying to order on a Windows 8.1 64 bit machine but it won’t let me. When I click on Add to Cart it keeps going back to the Financial Calculators Page saying Your Cart is currently Empty
    Return to Shop

    I can do it on another PC, but I don’t want the software on that PC

    • You can use any computer you desire for the purchase. After the purchase, you’ll be given the opportunity to download the full setup program. The download can be copied to the computer you want to run it on.

      If this becomes more of a problem for you than it has already been, I can call you and take the order over the phone if you wish. You can reach here.

  10. i would like to calculate yield to maturity of a bonds on your calculator but i dont understand how to use it, can you help me please

    • I’ve not tested that calculation using this calculator. Actually, I’m working on a dedicated bond calculator right now that should be finished before the first of the year. Over this coming weekend, i’ll see if I can validate this calculator for the yield calculation.

  11. I just found your site today and it’s great! Can you share the formulas that are used to calculate these schedules? I can’t seem to get my loan amortization schedule from my lender to exactly match your calculator (particularly the interest and principal on the initial payment) and was hoping to track down the discrepancy. Thanks!

    • Hi Todd, thanks for the compliment. Perhaps someone else reading these comments can provide an equation, but that’s beyond the scope of support I’m able to offer. It’s a bottomless pit.

      Generally, I will answer questions along the lines of either what calculator to use or how to use a particular calculator.

      However, if you want to post the details of the loan in question and the expected results for the first payment, I’ll see what it takes to get the result to match – assuming that the lender is not wrong. 🙂

      • Thank you Karl! I’ve been playing around with the settings/options, and on the first payment have been able to get either the interest to match or the payment, but not both at the same time.

        Rather than post my loan details publicly, is there a way to email them to you?

        • I work a full-time job and I have to leverage my time by only answering questions publicly. This way, I may not have to answer as many repeated questions. Also, since only the first name is publicly displayed, those individuals posting here are not very likely to be identified. That’s why I’ve setup support this way.

          Some pointers. If the interest matches, then that’s all you need because you can set the payment to match. That is, the payment does not have to be calculated. If the interest and payment amount match, then the principal has to match of course.

          • Understood. I was just hoping to not have to manually input the payment amount so that I could get the terms of my actual loan to match the numbers in your calculator. With that said, I did find the settings, along with manually inputting the payment amount, that match my actual loan.

  12. Does this calculator work for a daily loan? I’m looking to calculate the payments based on a one year loan with daily payments Monday- Friday, but include interest from Sat and Sunday.
    250k loan
    1767.68 daily payments

    thanks!

    • Of course it does! I wouldn’t be able to call it the "Ultimate Financial Calculator" if it didn’t. 🙂

      Kidding aside, this is a great question. I wanted to be sure the calculator will handle this so I tried it myself.

      I hope you have some idea about the basic workings of UFC (see tutorial #1 linked from this page if you don’t).

      What you’ll need to do, after setting the options in the header, is to enter 6 rows – 1 row with a loan, and 5 payment rows. The payment rows will be for 52 weekly payment. Each row will have a start date one day after the prior row.

      So, for example, I said the loan was dated today and the first payment will be due on Monday, Feb. 5th. I enter the 6 payment rows with initial dates of 02/05/2018, 02/06/2018, 02/07/2018, 02/08/2018, 02/09/2018. If you know the payment amount, you can enter it. Or you can set the payment amount to unknown. The calculator will calculate a level payment for all 5 unknown values.

      Interest accrues for Saturday and Sunday, as you want.

      You will need to tweak the number of periods. Some weeks will be 52 and some will need to be 53 to have the last payment fall at exactly the end of a year.

      Please let me know how you make out.

  13. I am looking for a calculator that will tell me the rate of return on my investments. I want to be able to indicate the date and amount of my initial investment, plus the date and amount of any additional contributions, less the date and amount of any withdrawals made, to arrive at an annual rate of return. Can you help?

    • Yes. You have at least 2 options on this site.

      This calculator will calculate a rate of return (ROR). In fact, there’s a tutorial that will walk you through the steps. Scroll down the page from the calculator and see:

           22. Calculate Rate of Return (ROR) on Annuity
               How to set up an annualized ROR calculation
      

      Also, you should check out tutorial #1 for a quick overview discussing how this calculator works.

      The other option is the internal rate of return calculator.

      The difference between the two calculators is the calculator on this page is more flexible as it does a lot of different calculations, but it has a steeper learning curve. However, if you need to do financial calculations on a somewhat regular basis, this one is worth the time to learn.

      The IRR calculator is a dedicated annualized rate of return calculator, and thus, it is probably easier to use at first.

  14. I have a personal loan at a fixed rate for 60 months. I plan to make extra payments, but I don’t have a fixed schedule of those payments nor do I have a fixed amount. I may pay $200 extra one month, then $100 extra the next, then $300 the next month. What I want to do is have an amortization schedule of my regular loan payment amount for the 60 months, then be able to input my extra payments as I make them each month and see how that affects my loan balance and payoff. I’m sure the UFC can do that, but I can’t seem to get that scenario to work. Please advise if that’s possible. Thank you!!

    • Hi Tom, you’re absolutely right. This can be done. If you scroll down the page from the calculator, you’ll see links to a number of tutorials. I suggest that everyone spend some time with tutorial #1 to become familiar with the calculator. Then the one that is specific for your needs is this one:

          9) Random Extra Principal Payment
             How to prepay principal on any date
      

      I should add, "…and for any amount."

  15. Hi Karl,

    Can you please advise what financial calculator i should be using to prepare an amortisation schedule for the below problem:

    1. Schedule totals need to be from 1st of July to 30th of June (Not Calendar Year).
    2. I do not know the interest rate of the equipment loan.
    3. Loan amount is $150,000.
    4. Start date is 2/12/2017.
    5. Total monthly payments = 60
    6. First monthly payment is made on 2/1/2018 for $2,937.84.
    7. Next 58 monthly payments start on 2/2/2018 and finish on 2/11/2022 for monthly payment amounts of $2,352.84.
    8. Final payment is a ballon payment for $45,000.

    On the amortisation schedule i need the following:

    – Date.
    – Interest expense for each financial year (1/7/xx – 30/6/xx).
    – Total principal amount paid for each financial year.
    – Balance of loan remaining

    • Hi Armi, None of the free calculators will do everything you need. The calculator on this page will let you set the dates and the payment amounts as needed but the scheduled totals only at calendar year-end.

      The loan calculator might might work for you as it will let you set the date and the fiscal year-end, but the user can’t override the calculated payment amount for just the first payment. It may calculate the payment you want, or it may not.

      The C-Value program $49.95 USD, will work like the calculator on this page and it will let you select any month for fiscal year-end.

Comments, suggestions & questions welcomed...

* Required