# Ultimate Financial Calculator™

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 either regular or irregular cash flows (loans, payments, deposits, withdrawals, investments), this is the calculator you should study and use.

Questions?

#### Info...

C-Value!™ CV1 or TValue™ TV5

files here to load...

**File save and open are new beta test features.**

If you happen to get a different calculated result, do not assume that this calculator is making an error. Most likely, the problem is with the new file load feature. Please check that all settings got loaded as expected.

## 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 free 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 free 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!

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

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

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

- 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 Calculator
- 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 Calculator
- 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 an 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

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

TValue is a trademmark of TimeValue Software.

## mark says:

can i record more than 9 payments our do i have to buy the program

## Karl says:

The only limit to the number of individual payments you can enter is your patience.

Use the "Next" button at the bottom of the page once the first nine are entered. (Or click on the page 2 button.)

If you reach the end, you can click on the "Insert" button to add more empty rows.

## gerry giovanelli says:

Do you have a calculator to calculate the Adjusted Cost Base for a financial REIT investment with monthly dividends re invested?

Thank you for your reply

## Karl says:

No, sorry, not at this time.

## Dawn says:

Is there any way to save data in calculator to use later?

## Karl says:

Not with the web version. If you want to save your inputs, and if you are running Windows, then take a look at the C-Value! program. $49.95, one-time purchase price. C-Value! is functionally equivalent to the online Ultimate Financial Calculator.

## Mark says:

I have pretty much tried pretty much every bi-weekly Loan amortization schedule on the web. Yours is the most accurate by a long shot. Thank you!!!!!!

## Karl says:

You’re welcome! And thanks for letting me know how the competition is stacking up. 🙂

If you used this calculator to create the biweekly amortization schedule, you might also be interested in this dedicated biweekly payment calculator. It will create a single schedule incorporating both a monthly and a biweekly loan so that you can easily compare the two scenarios.

## jp DZahr says:

Hello Karl,

This is JP I emailed you last week regarding our calculations above that when entering a higher mortgage payment than required, your calculator drops it back down to a minimum required monthly payment. How do we get your calculator to accept our higher monthly payment so we can see the term shorten?

Am I using the correct calculator?

Thanks

JP @ NextGen

## Karl says:

Hi, I thought I had replied but i can’t find it, so I must not have. Sorry.

I wouldn’t use the balloon calculator for that calculation since there is no balloon payment. I would use this calculator.

But if you want to use the balloon calculator, the issue it is having is, you’ve provide loan amount, rate, term and payment amount. You’ve also stated that there is no long period or odd day interest, even though it’s a long period. Since so many things are known, and are not compatible, the calculator is adjusting the payment amount (reducing it) so as to have a 0 balance at the end of the term. If the payment amount didn’t get adjusted then the term would not be what you specified. Something has to give. You could set the term to 0 so the calculator can calculate it with the payment amount you want. If you do that, enter $1,853,639.00 for the regular periodic payment as well as the final balloon payment (the final payment will be adjusted since the calculator calculate term by whole periods. That is, the term can not be 204 1/2 periods.

## krishnakant sharma says:

hi!

i want to embed financial calcualtors over my website….how can i do that

## Karl says:

If your website is built using WordPress, then you can use my WordPress plugins. There are seven of them here.

## Antonio says:

Hello! I have only one question, how can I calculate the initial Loan amount when I start to pay after a certain period? For example I made a Loan the 01/01/2019, with unknown amount, and I begin to pay the 01/01/2021. I have the final amount with each payment amount, the interest rate but I don’t have any other number. Thank you very much!

## Karl says:

Hi, do the loan payments vary in amount? If not, you need only create two rows. The first row, as you mentioned is for an unknown loan amount with the loan date set to 01/01/2019.

The 2nd row, enter the payment amount, payment frequency and number of payments. You can set the date for the payment row to 01/01/2021. Then check under "Settings" for long period interest options.

In your question, you didn’t mention the number of payments. If you don’t know that, then you can’t solve for the loan amount. When it comes to loan calculations, with respect to the four main variables, loan amount, interest rate, number of payments and payment amount, only one can be an unknown at a time. Think about it. If two are unknown, then the results are infinite.

## Faisal Halloum says:

This question relate to Leases. Do the calculators available online support Continuously Compounded Daily discounting for Quarterly lease payments. For example, 19 Quarterly payments of $51,300 starting from 25 March 2019 and ending 25 September 2023. Interest rate: 4.42%. I need to discount it back to 1 January 2019 with daily frequency and continuous compounding. I’ve done it on excel and the total PV is either $874,928.41 or $875,028.21 (depending on day count for the period between payment dates).

## Karl says:

Faisal, this calculator will do the calculation you need. However, the results are slightly different. The PV for the scenario you specified is $873,746.96 using a 360-day year, and $875,034.36 using a 365-day year. If you need to know how to set up the calculation, just ask.

## Faisal Halloum says:

Thank you Karl for your swift response, much much appreciated. Indeed it does and I got to the same results you noted above using the tool and manually using excel (including the digits). But I’m unable to match it exactly to how the oracle system does it. It is insignificant difference by all means but it is bugging me. But your tool gave me confidence in my excel workings.

## Laura says:

This is the best calculator I have ever found with all the inputs I have wanted, is there a way to save it and use it on a Mac please?

## Karl says:

Thank you!

My program C-Value! (link at the top of all web pages) works like this calculator and it allows users to save their inputs and settings. $49.95.

However, it only runs on Windows. There are programs for Mac that allow you to run Windows programs however. Parallels is one that I know about.

## Rob says:

Our contract initially had a 3 month month repayment schedule, and includes a 10% penalty for missed (not skipped), late, or short payments. How do you incorporate these types of situations in the calculator?

In this example, our customer had a $50,385 loan that was to be repaid in three monthly $17,019.43 installments based on an 8.00% annual interest rate. It seemed simple enough until they were late and short paid their first payment. Now I’m scrambling to figure out how much they owe.

## Karl says:

You can add the penalty to the loan balance as a new loan or fee. You’ll need to calculate the penalty. That is, calculator won’t calculate the penalty amount for you. (Is it 10% of the balance of the loan? Or 10% of the payment amount due?)

## Rob says:

Using a new fee seems to work. The penalty is 10% of the amount due.

## Karl says:

Yes, fee will work, mathematically. Entering a fee add to the balance of the loan. The only thing is some people might quibble about the label "fee" rather than "penalty."

## L P says:

Hi – this is great, thanks for it! How do I build in tax impact if I am doing a calculation of deposits and withdrawals for retirement?

## Karl says:

You’re welcome. The UFC is really for auditing purposes. It’s design for exact date cash flows and it does not consider taxes.

However, this investment calculator does.

## LP says:

Thanks!

## Erica Osborne says:

I have a note where the principal is $225,000.00 amortized over 72 months. Interest is 7.5% for the first 5 years and then 10% for the remaining year. Please help 🙂

## Erica Osborne says:

Never mind! I figured it out!! 🙂 Super easy tutorials!!

## Karl says:

🙂

## Maggie Watts says:

I am trying to set up a loan with irregular payments and payment amounts. How do I do that in the cavalue program. I don’t seem to get anything but to set a loan value

## Karl says:

The way you go about it will vary a bit depending on how irregular the payments are. If they are completely random, then what you’ll need to do is enter the first row as a loan amount, and then each following row will be a payment with a date and an amount.

For for more detail instructions, and another copy of this calculator, please see this page.

If you have, say 6 regular payments, followed by 1 single payment with a different amount followed by 6 more regular payments, then enter the first row as the loan, followed by a payment row with 6 in the "# Periods" column, followed by the single payment on the irregular date with or without an irregular amount, followed by 6 payments again.

If this isn’t clear, please ask again.

## Lp says:

Hi, I am trying to do a savings calculation where I have a monthly deposit that increases by 2 percent every 12 months, and then a yearly deposit that increased by a fixed amount each year. For some reason, when I make the cash flow adjustment for the annual deposit, it converts that deposit frequency to a monthly deposit even though the calculator input still shows I selected “annual” for frequency.

## Karl says:

You are right. Something is wrong. It seems that it is not possible to have two different series where one uses a percentage step and the other uses an amount step.

I’ll try to have a fix for this by Feb. 1.

Sorry for the problem.

## lp says:

Not a problem at all, appreciate it, thanks for letting me know!

## JB says:

Hi, I have a loan where there is a 9 month grace period between the date the loan was made and the first payment. When I enter the loan and payment information, the amortization schedule is showing a negative principal payment for the first payment to offset the interest that accrued during the first 9 months. Any recommendations on how to adjust the schedule?

## Karl says:

Yes. I assume you want to see a larger first payment to allow for the accrued interest?

Click on the settings button and select "Interest Options" At the top of the window that opens, you’ll see "If initial cash flow period is longer than the payment frequency:" with 4 options. Select "With First"

But, in confirming the steps for this answer, I see there is a bug in the calculation. The long period setting are only working if there is also at least one odd day’s interest. If you mean exactly 9 months, say April 1 to Jan 1, 2021, then the calculation is not adjusting the first payment. Please set the first date to March 31. Then it works.

If you want it to be exactly 9 months (this is assuming your payments are on a monthly schedule) then set up the screen with 3 rows. 1 loan row, followed by 1 payment row and then the 3rd row with the payment series. You can do some math based on the earlier schedule you mention to enter the payment amount for the 1st payment and then create the schedule.If this is not clear, let me know and I’ll give you an example.

## JB says:

Thank you for the quick response. No, the first payment would not be larger than the other payments. It ends up being a 60 month loan paid over 51 months in equal installments.

## JB says:

Thank you for the quick response. No, the first payment would not be larger than the other payments. It ends up being a 60 month loan paid over 51 months in equal installments.

## Karl says:

Oh, in that case there is no problem. The schedule is accurate.

For example, when this calculator first loads, as of today, it shows a loan row for $250,000 taken out on April 1 and a payment row with an unknown payment amount for 180 payments and a payment due on May 1.

You want the first payment due 9 months after the loan. So change the date to Jan 1, 2021. Can click Calc (or schedule).

The monthly payment is calculated to be $2,311.10. The payment is the same for all 179 payments, including the first payment. The 180th payment is round by $0.31.

However, note, the interest between April 1, 2020 and Jan 1, 2021 is $15,742.96. That’s a mathematical fact. But since the payment is only $2,311.10, the payment does not cover the interest and it’s added back to the loan balance (negative principal). In other words, by the time the first payment is paid, the loan balance (due to accrued interest) is greater then when the loan was taken out on April 1, 2020.

If you want to track accrued interest as a separate balance, that can be done.

Set the "Calculate Method" to "US Rule."