Invest or pay any amount, on any date, at any rate.

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

It too creates a printable amortization schedule.

Original Size

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.

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:

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!

- 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

- 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

- 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™

- 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 *

- 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

- 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

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

*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:*

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

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

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

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

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

*Calculate Payment*- loan or mortgage periodic payment calculation
- also an introduction to this calculator

*Investment Cash Flow*- calculating final value

*Calculate Income From An Investment*- How to calculate income you can expect from an investment

*Adjustable Rate Mortgage or Loan*- ARM with interest rate changes on any date you desire

*Calculate a Loan's Term*- How to solve for an unknown number of payments

*Calculate Loan Amount*- How much can I borrow?

*Balloon Payment Calculation*- Calculate the balloon amount

*Balloon Loan Calculation*- Calculate the periodic payment required to result in a specified balloon

*Random Extra Principal Payment*- How to prepay principal on any date

*Loan with Series of Extra Principal Payments*- How to calculate loan or mortgage with extra payments

*Construction Loan*- Generally a short term loan with multiple borrows

*Monthly Skipped Payments*- Loan or mortgage with scheduled skipped payments

*Odd Length First Period*- Interest payment options for initial period

*Interest Only Loan*- Initial series of interest only payments

*Biweekly Mortgage Payments*- Pay 1/2 the monthly payment every other week to reduce the total interest paid

*US Rule*- No interest charged on interest — separate tracking of interest balance

*How much do I have to save or invest?*- State your goal - calculate periodic investment amount needed to reach goal

*Paying for College*- You may have longer than you think
- Multiple investments with multiple, overlapping withdrawals
- Demonstrates solving for unknown in complex cash flow

*Future Value Calculation*- How to set up simple or complex cash flows to calculate FV

*Present Value Calculation*- How to discount a simple or complex cash flow to find its PV

*Calculate PV of Fixed Principal + Interest Loan*- Calculate PV of the declining payment amount
- Demonstrates the cash flow analytics of this calculator

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

*Calculate Time It Takes to Reach Investment Goal*- Set a goal and see how long it takes to reach it

*Calculate ROI for X Days*- Exact day return on investment calculation

*Calculate Loan Balance — Loan Payoff Calculation*- Enter payments for any amount on date made — audit balance due

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

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.

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!

You’re quite welcome. Thank you for the nice words and for taking the time to let me know.

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

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

The online calculators do not have the ability to save user inputs. If you are running a Windows computer, then C-Value will do what the Ultimate Financial Calculator will do and it gives the user the ability to save their inputs.

Karl,

Will the C-Value work with the random extra principal payments also?

Thank you for your help!

Yes. C-Value! works just like this calculator in that respect.

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.

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 theC-Value calculator. It is the calculator that this calculator is based on.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.)

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?

Yes.

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.

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.