New for 2020: Added support for over 90 additional currencies including Japanese Yen (¥12,345,679), Indian Rupee/Lakh/Crore (₹1,23,45,678.99) & Swiss Franc (CHF12’345’678.99). Click on "More" above.
a tvm financial calculator
Ultimate Financial Calculator™

Time-value-of-money calculations with regular or irregular cash flows. Solve for:

  • Present Value (PV)
  • Future Value (FV)
  • Payment amount, rate or term
  • Exact loan payoff amount
  • 25 step-by-step tutorials

The Ultimate Financial Calculator (UFC) is the most sophisticated, most flexible calculator on 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.


For best results, turn your device   
Idx No Series Date Amount # Periods Frequency End Date Series Options cmpFreq specialSeriesType SpecialSeriesStruct


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

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?
C-Value!, A TVM Calculator for Windows

An extremely flexible time-value-of-money calculator for Windows computers.

  • Loan or investment calculations.
  • Cash flows can be regular or irregular
  • Create and print schedules.
  • Save your data to disk for later use.

Suitable for auditors, accountants, lawyers and you!

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

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

270 Comments on “Ultimate Financial Calculator”

financial online calculator Join the conversation. Tell me what you think.
  • Buying an RV and the dealer is trying to show me the savings by financing through them. His offer is:

    $25,131 loan @ 6.74% 180 months. ($222/month).

    My credit union offers 3% for 72 months if I put a little extra down $24,131 loan @ 3% 72 months ($366/month)

    He is trying to tell me that if I finance through them and yet make a payment of $366/month that I would be paying through my lender anyway ($222 + $144 additional each month), the loan will actually be paid off faster (69 payments) and will be less expensive than my credit union. He says this is because it is a simple interest loan and interest is compounded daily.

    Using your calculator I am not finding this to be true. Using his method of extra payments, I am coming up with 88 payments and much more interest than if I went with my credit union. Either I am using the calculator incorrectly or this guy is trying to just get more $ out of me. Any thoughts? I am not “fluent” with financial numbers/terminology but I just cannot help but feel that I am being “had”. Any info you could provide would be appreciated. Thank you!

    • Your instincts are good. Think of it this way, When shopping for a loan, you are making a purchase. What are you buying? A loan. The cost of the loan is the interest due. If you are coming up with paying more interest to the dealer’s lender, then you certainly wouldn’t want to do that.

      If you are not sure that you used the calculator correctly, then you’ll need to ask questions relating to your concerns.

      Did you see the tutorials listed on this page about how you can enter extra payments?

      • I did see the tutorials and I believe did it correctly. Basically he sent me a screen shot of a TVM calculator he used that showed:

        Present Value $-25131
        Payment $366
        Annual Rate 6.74%
        Periods 69.11 months
        Compounding Daily
        Mode Beginning

        I do not see how he comes up with 69 months.

        When I input that same info on this calculator I come up with 87 months with total interest of $6,871. I guess my only concern was the whole “compounding daily” thing. Is that the same at your “initial compounding”? That is where I selected “Daily”

        Getting the 3% loan for 72 months at $366/month through my bank I am only paying $2300 in interest. So I believe thats the way I will go.

        Sorry for the confusion – this is all new to me and a little foreign. Thank you for your assistance.

        • A couple of things…

          "Beginning Mode" normally means that the 1st payment is due on the same date that the loan originates, meaning on the day the money is borrowed. If that’s the case, using this calculator, the total interest would be $6,637. My guess is you had the 1st payment due one month after the loan date.

          More importantly, I think I know what the dealer is doing. If you take the loan amount, $25,131 and divide by $366, you’ll get 68.66. Call that 69 months. The problem is, that’s not the way to solve for term because it’s not allowing for the interest to accrue!

          Hopefully they are just ignorant about the calculation and not being outright dishonest.

        • Oh, and about the "Initial Compounding", I use that phrase to indicate to users that it is possible to change the compounding later in the cash flow stream. (See "Rate Change") In your case, set it to daily and I assume that does not change.

  • What calculator would you recommend to calculate $200,000 as initial investment on 8-7-15, with a withdrawal on 8-22-16 of $70,000 and ending balance of $109,645 on March 27, 2018?

    • Thanks for your follow-up on the other web page.

      If you want to calculate a rate-of-return for this cash flow using this calculator, follow these steps:

      1. Click on "Settings" and then "Analytics". Check "Include internal rate of return (IRR) on schedule" option.
      2. Set "Initial Interest Rate" to "0".
      3. Set "Schedule Type" "Savings"
      4. Enter 3 rows:
        1. Set Series to "Deposit" Date to 08/07/2015 and Amount to 200,000.
        2. Set Series to "Withdrawal" Date to 08/22/2016 and Amount to 70,000
        3. Set Series to "Withdrawal" Date to 03/27/2018 and Amount to 109,645
      5. Click on the "Schedule" button. Scroll down the schedule to the footer are and check "Internal Rate of Return (IRR):"

      There is no need to click on the "Calc" button. The "Schedule" button also calculates.

  • Beverly Dominguez says:

    Hi, thanks for this great site! I’ve learned so much, but I still don’t know which calculator to use to figure out whether the people buying a property from my dad under a real-estate contract are not paying him what he is owed or if the interest being charged is excessive. The escrow company is no help, they wouldn’t provide a payment or amortization schedule, but they did give me the entire payment history including date paid, interest paid, principal paid and new principal balance and new total balance. I tried using your loan payment calculator to figure out how much has really been paid and how much future payments should be. The buyer’s payment history has been very variable (to be nice about it) with late payments and occasional extra payments which have all gone toward interest. At one point there was a year of missed payments followed by a $5000 “make-up” payment. Since they “gave” their son the property, he has been making regular monthly payments, but he feels as I do that my dad might be owed some more money, but we don’t know how much and he says he is willing to make extra payments. My dad will probably agree to forgive money owed him if the son doesn’t pay money owed by his parents, but we still want to know. BTW they are friends of my dad and he really doesn’t want to ruin the relationship over a few grand and it is against our religion to sue people. Anyway, do you have a calculator that can produce a payment or amortization table from historical payment information, maybe a reverse engineering in which one plugs in date of payment, interest paid, principal paid and balance? I tried calculating this with the UFC as a loan repayment problem, but values don’t match the amounts paid and balance from Escrow company’s info. If there is a calculator please help me figure out how to use it: here are the loan terms: 70K at 5% p/a with daily interest and a $500 dollar monthly payment and “if not sooner paid pursuant to this contract, the entire balance due Seller shall be due and payable 30 yrs from effective date of the contract.

    • Thanks, Beverly, I’m happy to hear you’ve learned a lot.

      If you want to find the exact balance of a loan, this calculator is the one to use. You can enter individual payments or a series of payments on the exact date made. Please scroll down the page and read tutorial #1 to get an overview of the calculator and then see tutorial #25 for a specific example of calculating the balance.

      I am a bit confused with your question, however. Are you saying there is escrow amount paid as well? If so, you’ll want to ignore them for the purposes of calculating the balance on a loan.

      Escrow payments should be tracked separately from the loan. This calculator has no provision for entering escrow payments. You could keep the payments and disbursements in a spreadsheet.

  • Hi Karl,
    I’m trying to use your UFC to reconcile a home mortgage with a redraw facility.

    The initial funding amount was settled mid-month(17-Nov), but the interest calculation is done at end of month (31-Nov), with the first repayment due one month after initial settlement (15-Dec).

    Initial funding amount was $345,500
    Interest rate is 3.79%
    Bank charged interest of $502.25 on 30-Nov
    Loan repayment of $1607.36 made on 15-Dec (this is the required periodic payment monthly)
    Bank charged interest of $1110.91 on 31-Dec

    Closing balance on 31-Dec was $345,505.80

    How do I handle this situation with your calculator to ensure bank reconciliation?
    Thank you,

    • Hi Bronwyn, it looks to me as if you’ll be glad you double checked. I think the interest amount is too high.

      I do have a couple of questions though, so I might be wrong. On Nov. 30th, the bank is just posting the accrued interest charge I assume. That is, you are not making an interest-only payment. If that’s the case, you set up the calculation this way:

      Row 1. Date: Nov 17. Loan amount.
      Row 2. Date: Nov 30. Payment amount 0.00. (Anytime you indicate a 0.00 payment, the interest is calculated and added to the balance.)
      Row 3. Date: Dec 15. Payment amount: $1,607.36. (I wasn't sure if you wanted to confirm this amount or if you are accepting it as the payment. To confirm the amount, that is, that it is the "normal" payment amount, you would need to enter the number of monthly payments and set the amount to "Unknown".)
      Row 4. Date: Dec. 31 Payment amount: 0.00

      Don’t forget to enter the required values in the top part of the calculator.

      Does that at least get you started?

      • Thank you so much Karl!
        Your assumptions were correct and I was accepting the payment amount as this is the contracted value.
        When I added in subsequent payments for January and February, and then the interest accruals, the balances shown (between the UFC and my bank statement) are within a few dollars, so I think it’s probably just a timing issue. I’m ok with that.
        I’ll definitely be using your UFC going forward to keep my bank honest! I’ve bookmarked your page. I wish I had this for the last 20 years of home loans!
        Thanks again for your help.

        • You’re welcome.

          Interesting though that you get only a couple dollars difference. I had about $30. Perhaps I had a typo.

          Since you get only a few dollars difference, if you’re interested, you can probably back into the same number the bank gets by changing either the "Initial Compounding" or, under the "Settings" menu, the number of days per year i.e. 360, 364 or 365.

  • Hello, GREAT SITE! Many, many thanks!

    Quick question – we carried back a loan of our business to our buyer, and as we approach the date upon which he begins making payments (was initially deferred for 2 years), he’d like to know the payoff amount on a particular date. The loan was created with monthly compounding, however how would we get to an exact amount, say 10 days into the next (monthly) term, such as last payment date + 10 days?

    thanks again

    • You’re very welcome. And thanks for the compliment.

      This calculator is the correct one to use. Have you seen the links to the tutorials on this page? #25 deals specifically with loan payoffs.

      For your particular case, the last row will be for an "Unknown" payment amount on the date that the borrower wants to know the balance. Calculate that unknown, and that would be the balance of the loan due.

      Hope this is clear. If not, just ask for more detail.

  • I think the spreadsheet is great once you figure out which one works best for your needs; however, I’m not sure what happened, but I loaded info and then thought I’d better save it. I purchased and now it’s in a format that my computer says is dangerous. I wanted to mAke some changes but can’t find the original spreadsheet. I would like my money back if this cannot be resolved. So frustrated.

    • Hi Cheryle, thank you for your C-Value! purchase. We should be able to gets things sorted out quickly.

      First, the inputs are saved in an XML file. That’s just a text file. You could use notepad to open it and view it’s contents.

      As to how to save and then reload the file you’ve saved, that process works just like saving a word processing file.

      The easiest thing at this point, to find the file you’ve saved, is to go to the file menu and do a "Save As…". This will open the file save window and you should be able to see the folder when the files are being saved. (You can subsequently change to any folder you desire.)

      Please let me know if this does or doesn’t help.

  • I entered a present value deposit = 200,000. I am only going to begin with new monthly deposit in one year. When I do calculate its not providing what the interest would accrue for the 1st year on just the initial deposit. It shows the interest calculating once the monthly deposits start. I must be enterting it wrong

    deposit = 200,000 (left all other columns blank)
    deposit = 1250. = 12 = monthly = (dated to start one year later)
    It only calculates the interest after the one year? I wanted the interest of the initial deposit (as it will earn interest in the first year)

    Let me know what I am entering wrong as I am sure there is a way to make it calculate.

    (BTW: awesome calculate you created)

    • I’m not sure that I understand exactly, but I’ll try answering your question.

      If you enter a present value and then an additional deposit one year later and you want to show the interest for the first year, you should see that interest on the schedule in the row where the deposit is entered after the first year.

      Another way to show interest is to enter a 0 amount for either a deposit or withdrawal. The interest will be calculated from the time of the last deposit or withdrawal.

      Thank you for the compliment.

  • David R. Marshall says:


    I loaned a guy $20,000.00 on July 28, 2011. Interest was simple at 5%/annum. He paid $1,000/mo. for the first three months, then didn’t pay until months 6-8 at $1,000/mo., then didn’t pay for another 9 months, when he paid $500, skipped a month, then paid $500/mo. for two months, skipped a month, paid $500/mo. for two months, skipped two months, then paid for four more months in a row at $500/mo.

    He hasn’t paid since, despite many promises.

    I can’t figure out how to determine the current balance using your ultimate calculator. Can you?

    Thank you!

    David R. Marshall

    • Hi David, the calculator definitely can calculate the balance for you, even with the different payment amounts and missed and late payments.

      Did you notice the links to the tutorials on this page. Tutorial #25 directly addresses exact day balance calculations. Please give it a read, and then let me know if you have any questions. I would also suggest that you read tutorial #1 for an overview of how this calculator works.

  • Hi Karl, On the Ultimate Financial Calculator (UFC) Setting tabs, there is no selection available for Year end Month selection. The basic Loan Amortization calculator has this selection available.

    I would be interested in this UFC but I need the Year End Month selection for my reports. Would you be able to add this selection on the Settings?

    Let me know.


    • Hi Murat,

      I plan to give users the ability to pick a fiscal year end, but I will be a while until I can get to it.

      If you are running Windows and would consider a Windows program, my C-Value! is like this calculator and it already supports the feature, plus a host of other features like the ability to save your entries.

      C-Value! for Windows $49.95.

  • I need a calculator that can calculate payments made EVERY 28 DAYS, not monthly, not 4 weeks, but every 28 Days. Do you have a calculator that can do this?

    • This calculator will do it, but you have to enter the payments on the dates they are due with the amount set to "Unknown". As you enter the payments, set the frequency to 4 weeks and then the next row’s payment date will be one day after the end date of the previous row. That should result in payments paid every 28 days.

      The calculator, will calculate the payment amount required for a level schedule and create the schedule.

    • I rethought my answer a bit and I also left out a detail. You can set the payment frequency to "Daily," which I had forgotten. So set a row to 28 days. Tab to the next row, and that row will automatically have the date correctly set. Enter "Unknown" for the payment amount. Then go back to the prior row and set the "# Periods" to 1. This will leave the 28 days between payments.

    • I’m going to change my answer again. (I guess it’s too early in the morning here :-). Every 4 Weeks, which this calculator supports, is payments every 28 days. A payment due on the 1st of the month followed by a payment due 4 weeks later falls on the 29th of the month. That’s 28 days between payments or a payment with 28 days of interest due.

  • Karl,

    A borrower $100,000.00 on with interest rate at 10.5 % for 2 years with repayment frequency as “monthly” and compounding frequency as “Quarterly”.
    1. How to calculate the repayment amount every month with different payment frequency and compounding interest value?

    I am finding difficult to calculate the repayment amount. Can you just help to solve this?

    Thank you

    • This is a hard question to answer, only because you’ve not told me what you’ve done and why you are having a problem.

      A basic loan has 2 rows in this calculator. The loan row and the payment row. The payment row has a frequency. Are you having problems changing that? To recalculate a payment amount, you set the amount in row 2 to "Unknown"

      Please scroll down the page and take a look at tutorial #1 and if something there is not clear, then please ask for further explanation of those instructions.

        • I thought you meant how to calculate the repayment using the calculator.

          I provide support for two types of questions. What calculator should I use? and How do I use it?

          I do not discuss equations or formulas. That too open ended and it’s my IP.

          • Thanks Karl. I got information to convert intrest rate into effective interest rate. I was not struggling to solve this, thats the reason to ping you.. You are doing good and keep it up.. Good luck

    • Strange. Do you get any error messages? Are you typing in the date or are you using the calendar? Have you left the date format set to the US convention i.e. mm/dd/yyyy? Is this on a desktop computer or tablet or phone? What browser?

      There should be no reason why you can’t set the date to any day you need.

  • It’s no doubt here, but I can’t find it. I have a 30 year mortgage that began on 11/01/1998 for $224,500 at 7.65%. On 11/01/2013 the interest rate changed to 4.25%. I want to calculate the end date while adding extra to the monthly payment.

    • This calculator will solve the problem for you. You can change the interest rate and have extra payments.

      Did you notice the tutorial section below the calculator? Tutorials 9 and 10 have extra payment examples. Tutorial 4 is about interest rate changes.

      From what I know about the loan it is easiest to do the calculation in two steps.

      The first row is the loan amount and date the loan originated.
      The second row is the normal payment amount, the date of the first payment and number of payments prior to the interest rate change.

    • I’m wondering if you noticed the tutorials? If not, please scroll down the page and check out tutorial #1 for an overview and the specifically #25 – Calculate Loan Balance which will let you calculate the loan balance on a specific date.

      Or maybe I’m misunderstanding your question? If I did, please ask again.

  • Hi Thanks so much for these great tools.

    I was running some balloon payment calculations in your balloon payment calculator:

    and in your Ulimate Financial Calculator:

    In the Ultimate financial calculator, I followed the directions for a Balloon payment calculation, and I came up with a different balloon payment amount than in the Balloon Payment Calculator. Did I enter some info incorrectly or is there some difference between the two?

    The loan amount is 38,750, Monthly payment of 1,000, loan term of 30 months, First payment is due when the loan is issued 10/1/2018.

    The Balloon Loan Calculator shows a Balloon Payment of 13,724 and the Ultimate Financial Calculator shows a balloon payment of $12,500.

    Thank you for any clarification you can offer.

    • You’re welcome.

      And thank you for sending me the screenshots. I would never have been able to figure out the answer to your question without them.

      If you give the calculators the exact same information, you’ll get the exact same results. 🙂

      There are two things going on. First, notice with the UFC, the loan date, and the first payment date are the same. With the Balloon Payment calculator, leaving the amortization method set to arrears tells the calculator to make the first payment due one period (in this case month) after the loan date. If in fact, the first payment is due on the day the loan is advanced, then change this setting to "Advance." Unlike many calculators found around the internet, nearly all calculators on this website are date sensitive. They have to be to give truly accurate results.

      The other difference is the number of payments. Notice the Balloon Payment calculator asks the user "Balloon Due at Payment? (#):" to which you answered 30. With the UFC, your screenshot is showing 30 regular payments and the balloon payment is being paid at the 31st payment.

      Hope this helps.

      • Thank you so much for your answer and help! I’ve written another email with more screenshots. I changed the date and number of period parameters and I’m closer to getting the same answer on both calculators, but they are still different. Not sure if I need to keep posting here in the comments or not, so please let me know if you want to continue the communication by email.

        • Sorry not to have replied earlier. I didn’t have access to a desktop and I was not able to see the PDF that you sent. Glad you got it figured out.

          As a pointer, when following a regular payment (or any cash flow type) frequency, the next date entered should be one period after the "End Date" in the previous row.

Comments, suggestions & questions welcomed...

Leave a Reply to Karl Cancel reply

to calculator
to tutorials
to questions/comments