July 2020: Major Update: Ultimate Financial Calculator    3 New Calculators: Refinance Calculator, Lease vs. Buy Calculator & Break-Even Calculator
advertisement

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?

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

Info...

  Original Size  
New! Drag & drop your...

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:

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

Financial Calculations Step-by-Step Tutorials

advertisement

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

TValue is a trademmark of TimeValue Software.

advertisement

82 Comments on “Ultimate Financial Calculator”

financial online calculator Join the conversation. Tell me what you think.
  • Hi Karl
    Thanks for the work done with this UFC calculator and others. I keep coming back to them time and again.

    One of the reasons I use it is because leasing companies don’t always provide up front schedules and then charge to get an extra statement!! Particularly when I want to get in front with my book work. 🙂

    One of my leasing companies is doing something a little bit different and the calculator is not quite matching. See how you go. Thanks in anticipation of a brilliant solution. David.

    =Scenario=
    Vehicle Loan = $56,409 (includes all other fees) @ 4.9500% over 60months but paid at $494.52 biweekly (fortnightly).
    Monthly admin fee of $8.25 charged to account.

    Question 1: When the monthly admin fee is applied it is not added to the principal and then extra interest calculated but the principal component of the next fortnightly pmt is reduced by that admin fee. Can this be accommodated by the calculator?

    Question 2: The calculator calculates the first Interest & Principal paid exactly. However, from then on the Interest calculated is consistently higher by up to $0.17 each repayment when compared to the leasing company’s statement. Where’s the best place to correct this?

    • Hi David, I’m happy to hear that you’ve found the calculators to be useful.

      I’m not sure that I understand exactly the term that you’ve outlined. And when it comes to a 0.17 difference, the details of the terms are important!

      But a few thoughts, the term of the loan is quoted in the number of months and the payments are scheduled every other week. What’s the compounding frequency?

      It seems to me that the monthly admin fee either is or isn’t being added to the balance. It would be easier to duplicate the calculation if we knew the answer to this question. Can the lender document this for you? Basically, the admin fee has me confused.

      • Hi Karl
        Please find below in CSV format the first 6 transactions as taken from the Statement of Account, which are representative of the cycle. Hopefully this might help.
        From my understanding of the contract the compounding frequency is monthly. I did try biweekly but that appeared to make the discrepancy worse.
        Regards
        David

        Date, TRXN, PmtRcvd, Interest, Principal, PrincipalBalance, DebitFees, CreditFees
        10/09/19, O/Bal, -, -, -, $56409.99, -, –
        20/09/19, Pmt, $494.52, $76.50, $418.02, $55990.98, -, –
        04/10/19, Pmt, $494.52, $106.31, $388.21, $55602.77, -, –
        10/10/19, AdminFee, -, -, -, $55602.77, $8.25, –
        18/10/19, Pmt, $494.52, $105.57, $380.70, $55222.07, -, $8.25
        01/11/19, Pmt, $494.52, $104.85, $389.67, $54832.40, -, –

        • David, I can’t even get the first interest payment to match. By my calculation, it should be about $1.00 more, depending on the compounding selected. What settings to you pick to match interest rates?

          • Karl, I set the days per year to 365. That gets the first TRXN to be exact.
            I don’t understand the 360days option – are there days in the year that interest is not calculated on?
            Regards David

          • There are so many (necessary) options, I forgot to try a different days-per-year setting.

            (Note to users: if you want me to help understand a calculation, I will be happy to do so, but please let me know of any changes to the options you make.)

            David, no, unfortunately, unless the lender is a relative, interest is accrued for every day of the year. The day-per-year option is used for calculating the daily interest rate. The annual rate is divided by either 360 or 365 days. The 360-day option came about with the rationale that a year would be divided by 12 equal months of 30 days each. It also results in a slightly higher daily interest rate and thus slightly higher interest charges.

            No to your problem.

            As I said, I am able to match the interest rate. However, this led me to notice a problem with what you sent me. Take the first payment:

                 Date            TRXN PmtRcvd   Interest   Principal  PrincipalBalance, DebitFees CreditFees
                 Sept. 10, 2019  Open Bal:                                   $56409.99,         -          –
                 Sept. 20, 2019, Pmt, $494.52     $76.50     $418.02         $55990.98,         -          –
            

            The calculator and above agree on these facts: interest due $76.50. Pmt 494.52 – 76.50 for interest gives us a principal pmt 418.02

            However, the details you are providing have a factual error. The opening principal balance 56409.99 minus the 418.02 principal payment does not equal $55990.98, it equals 55991.97.

            Since we do not agree on the principal balance after the first payment, the calculator will never match the interest payment you are showing as of Oct. 4, 2019.

            Is the lender providing you with the data? How do they arrive at their principal balance? Frankly, it looks as if they are cheating themselves. I would be very interested in hearing their explanation.

  • (Reply button has disappeared)
    Hi Karl. Sorry my mistake. The Opening principal balance is 56409.00 – I must have been half asleep when I did entered that. I have now checked to make sure that there are no other errors in what I sent you. Regards David

    • David, the correction makes a difference!

      Okay, I have the schedule matching to the penny through the last payment provided, i.e. Nov 1, 2019.

      The way the lender is providing the data might be confusing, but I don’t see any errors. The key is, the principal balance amount is prior to the impact of either the debit or credit fees. Think of it this way, the fee amount seems to be a notice of what’s going to be due on the next pay period. No interest it being charged on the fee.

      My entries are below. Of course the dates, here in the U.S. are in MM/DD/YYYY format:

      No	Series	Date	          Amount	# Periods Frequency	End Date	Series Options
      1	Loan	09/10/2019	$56,409.00	1	                 		Loan Options
      2	Payment	09/20/2019	$494.52	        1		                        Cash Flow Options
      3	Payment	10/04/2019	$494.52	        1		                        Cash Flow Options
      4	Fee	10/18/2019	$8.25	        1			
      5	Payment	10/18/2019	$494.52	        1		                        Cash Flow Options
      6	Payment	11/01/2019	$494.52	        1		                        Cash Flow Options
      7	Xtra Pmt11/01/2019	$8.25	        1			
      

      Under settings, I have the rounding option set to "Open Balance"

      I use the XPmt option to pay the fee, because this makes the entire payment be applied to the principal.

      I left compounding set to "Monthly."

      And since I’m entering the payments as made, one at a time, there is no payment frequency setting to worry about.

      I hope you can duplicate this. Good luck.

    • One more thought. The lender’s software (which probably cost them thousands of dollars to buy or develope 🙂 ) seems to have the capability of allowing them to enter fees that do not accrue interest. This calculator does not have that ability. I simulated it by advancing the fee from Oct 10 to Oct 18 (when I assumed that it was due), thus avoiding the interest charges.

      • Hi Karl. Thank you for the info. I had considered that it was something along those lines you discussed but I couldn’t quite prove it. Thank you for your time and effort in providing a solution. Much appreciated. Regards David

  • Hello Karl,
    I just found this calculator which is great. I have a client which I sold my RV to. The aggrement is $650 monthly with a late fee of 5% for payments paid after the 5th of every month. How would I add this additional fee? Could you help me out. Thank You

    • Thank you!

      In the "Series" column, one of the options in the dropdown is "Fee." The calculator is not going to calculate the 5% for you. You’ll need to calculate the amount, but you can enter the result using this fee option.

      When the borrower pays you, and if you want to show the fee as being paid specifically, then use the fee option and enter the amount as a negative value. That decreases the amount owed by the fee entered.

  • Glenn MacLaren says:

    . Hi Karl, thanks for the great calculator…I am a mortgage broker in Canada, and some of our lenders calculate Variable Rate mortgages with a monthly compounding(vs semi annual). Is there a way to have the Canadian version of compounding interest to have the option of selecting monthly compounding? I see right now, there is only annual and semi annual.

  • Hi Karl – This calculator is exactly what my company needs.
    I wanted to make sure I am doing this correctly
    One of our customers has a loan out for $232,114.20 that was invoiced on 2/10/20
    We are giving them a 6 month skip with a 5% interest for 24 months. The loan would start on 8/10/20. We are charging them the 6 month interest on the months they are skipping. I hope I did it correctly. I am getting a monthly rate of $10,408.48 and the interest would be $17,689.36. Can you clarify if this is correct?

    • Hi Diana, glad to hear that you think the calculator will be useful.

      To your specific question, I can’t tell from the information if the numbers adhere to the terms of the loan your firm is quoting the customer. But, the numbers are "right" in the sense that given whatever inputs and setting you used, they are accurate. 🙂

      Do you have a question about how to use the calculator? Or is there anything that looks off to you?

      I assume you set the first row as a loan with a date of 2/10/2020 and the second row as a payment with the date set to 8/10/2020. The second row includes the number of expected payments and their frequency.

      • Hi Karl,
        Yes those were the exact parameters I used. Loan date 2/10/20 $232,114.20. 6 month skip starting payments at 8/10/20 for 24 months.
        I ended up putting this info in again but I got a different interest/monthly loan amount from the last time I worked on this.
        Last week I got $10,408,48 monthly and interest total of $17,689.36
        I just did the same thing and I got $10,397.10 monthly and interest of $17,416.12

        1. why would I be getting a difference?
        2. What is the calculation to come up with the interest due for the 6 month skip?

        Thank you and Stay safe.

        • Hi Diana, The only reason the calculator would produce different results is that one or more settings or options was set differently. Did you happen to change days-per-year and then not set it back, for example? There are perhaps a dozen or more settings, and changing one will cause results to change. That’s why the options are available!

          Your loan has what we call a "long initial period." The payment frequency is monthly, but the first payment only happens after six months have passed. There are specific options available to the user for how long initial period interest is calculated and charged. To access, click on "Settings" and pick "Interest Options."

          Go here for details about how they can be set if you want more background. Scroll down the page a bit until you see "Long First Period."

  • Hi Karl, I just want to confirm I’m using the calculator correctly to solve a problem.
    The goal- I want to calculate my yield on the purchase of a real estate note.
    The note: 180,000 @8% 360 months- pmt-$1,320.78, rate changes to 12% after 84 months, new pmt- $1,778.72.
    The purchase: 90,000 now and 90,000 after 60 months.
    I originally setup the $180K loan to solve for initial pmt at 8%, then put in a rate change after 84 months to 12% and solved for new pmt for the balance of the term (276 mo).
    Once the above was in the calculator, I changed line 1 loan from $180K to 90,000 and inserted a new row (line 3) as a loan with a date 60 months later for 90,000. I put “unknown” in the initial interest rate box at the top and hit calculate to solve for the cash flows below. It returned 13.6324%. That appears correct, but is there a more direct or different way to get there with the calculator? Also, if I knew my initial purchase was 90,000 but wasn’t sure of the 2nd pmt in 60 months, could I put 12% (desired yield) in the initial interest box, and solve for needed pmt in the 2nd installment (ie loan) box?

    You mention a premium subscription coming in 2020- is this going to replace the downloadable windows version or will it be a separate online version? Thanks. Zach

    • Hi Zach, yes, there is a more direct way to calculate yield.

      Click on "Settings" and select "Analytics" and check the include IRR on schedule option. The IRR (yield) will be in the footer of the schedule. 🙂

      And yes, you can solve for the required payment as you describe.

      The premium version will be online, and will be separate from the downloadable C-Value! program. The Windows version of C-Value! will eventually go away, but probably not right away.

  • I am trying to calculate the interest only loan repayments for a construction loan. However I notice that the first interest only payment automatically calculates the cumulative accrued interest of the all previous loan withdrawals. I would like it to accumulate all previous loan withdrawals and their respective interest into one loan and calculate interest only payments from this new combined loan amount without trying to automatically pay off all previous accrued interest. Is this possible and how would i set this up?

    • I’m not sure I understand. But for example, you are saying there are 3 loan advances, say on April 15, May 12 and Jun 8 and you want to show them as one loan? Then you would enter them as one loan. This wouldn’t be particularly accurate, but you can do it. I think I’m missing something. Can you provide a simple example?

      • Construction Loan is for 100M at 6% interest rate with 7 drawdowns & 20 semiannual payments as follows:
        1) The initial loan drawdown is for 10M on 01/08/2020
        2) then 6 semiannual (covering 3 years) drawdowns for 15M each from 01/02/2021 to 01/08/2023
        3) then 20 semiannual (covering 10 years) interest only payments from 01/02/2024 to 01/08/2033
        4) Total principle is paid as a lump sum along with the final 20th semiannual interest only payment.

        So I would like to calculate the value of each of the 20 semiannual payments. However, when making this calculation the payment scheduled automatically pays off all accumulated interest form the initial 7 drawdowns along with the 1st semiannual interest payment together. This means that the 1st of the 20 semiannual interest only payments is several times larger that all the others. I would like the 1st and subsequent 19 semiannual interest only payments to be base on the combined value of the initial 7 drawdown and their cumulative accrued interest.

        Also the 20 semiannual interest only payments are paid each year as one payment in the Interest only column when when then should be recorded and 2 separate payment every 6 months in the interest only column of the payment schedule…. If the above is not clear I would be happy to call you and clarify further.

        Regards,

        Jason.

        • Thank you for the details.

          I think the default setting should give you what you need, so I’m wondering what’s different.

          Under "Setting" select "Interest Options" and for the long period options in the first group, "Amortized" should be selected.

          Your cash flows should show 7 loan series (assuming you mean an initial loan followed by 6 loans). First for 100M followed by 6 for 10M. And actually the 6 can be combined into one row since they are occur on a regular frequency.

          In the 3rd row, you can create an interest-only payment series (did you see how to set an interest-only series by clicking on the cash flow options and selecting interest-only?)

          The final row is an unknown, normal payment row.

          I tested this, not with your exact numbers, but what I got was the expanded amortization schedule with these columns:

          #/Year  Date  Payment  Interest Due  Interest Paid  Principal Paid  Interest Balance  Principal Balance Balance
          

          The calculator keeps track of the interest accruing in the interest due column but no interest is paid until the first interest payment is due (per your date selection) and then after that, all payments (interest only) are for the same amount, except for the final payment which is principal and interest.

          Please let me know if this is not what you see so we can figure this out. Or even if it works for you. I like to know that too. 🙂

        • Jason, I see that I had a data entry error, and there seems that the calculator does no amortize interest-only payments. Let me look at this a little bit more. I don’t want you to waste your time.

  • I note your observation regarding the amortisation of the interest. I look forward to the outcome of your investigation on this. Thanks!

    Separately, regarding the following:

    The calculator keeps track of the interest accruing in the interest due column but no interest is paid until the first interest payment is due (per your date selection) and then after that, all payments (interest only) are for the same amount, except for the final payment which is principal and interest…… For my 20 semiannual interest only payments there should be 2 payments in each year in the column titled “interest paid”. however my payment schedule only shows 1 payment (the 1st of the 2 semiannual interest only payments) in each year in the column titled “interest paid”. I also observed that the total value of this 1 payment is equivalent to that of the 2 payments that should be displayed for each year. So in summary: For my 20 semiannual interest only payments, in the scheduled payments table section, under the column titled “Interest paid”, for each year there is only 1 figure which represents the value of both semiannual interest only paid; this is not correct as there should be 2 separate figures representing each of the 2 semiannual interest only paid for each respective year.

  • Hi Karl,

    One other observation that I would like clarification on is the following:

    For construction loan where you have multiple loan drawdowns I have observed that on the Loan Schedule page (the summary above the table at the top of the page) “Total All Payments” should be equal to the “Loan Amount” + “Total Interest Paid” but this is not the case for me. Actually the “Loan Amount” only shows the initial loan drawdowns (not the total of all loan drawdowns) but despite this the actual total loan amount (total drawdowns) + total interest paid should be equal to the total all payments but this is not what I observe. Kindly investigate this also.

    Thanks again,

    Jason.

    • Hi Jason,

      To the 3 open items.

      • I agree, the "Loan Amount" needs to include all loan advances rather than just the first loan advance.
      • I understand your point about seeing one payment per year, however, I can’t duplicate this. Furthermore, this version of the calculator has been posted for four years, and I would have expected a bug report on this problem long before now. Are you sure you had the "Frequency" column set to "Semiannually" for the interest-only cash flow?
      • I’ve given the periodic interest amounts a lot of thought. What you need is a calculator that will calculate a pre-computed interest amount and divide the total among all expected payments. I thought about this a few years ago and decided not to offer such an option. The problem is, when total interest is paid this way, the lender is not getting his due. The unpaid interest that is due with the first payment is, in essence, an interest-free loan. For example, if the first interest-only payment is supposed to be 50,000 (using balance and actual time) and the other 19 are 30,000, but the borrower pays 31,000 for all payments, the 20,000 difference that had been due, amounts to an interest-free loan which means the interest rate is not really 6%. (This is fine, of course, if the lender agrees.)
      • Hi Karl,

        Firstly, thank you for taking the time to investigate and provide instructive responses to my questions.

        Now to your 3 responses:

        1) I agree, the “Loan Amount” needs to include all loan advances rather than just the first loan advance….. So can you change this so that the schedule page adequately reflects the total loan amount?

        2) The problem seems to have been resolved now… Perhaps yes my initial setting had an error.

        3) For example, if the first interest-only payment is supposed to be 50,000 (using balance and actual time) and the other 19 are 30,000, but the borrower pays 31,000 for all payments, the 20,000 difference that had been due, amounts to an interest-free loan which means the interest rate is not really 6%. (This is fine, of course, if the lender agrees.)…… The first interest only payment should treat the previous loan and accumulated interest as 1 single loan amount. In your example above the 20,000 difference should be compounded (interest on interest).

        • No problem, Jason.

          1. Yes, I will fix the loan total. (I think originally, the label had said "Initial Loan Amount.") I had meant to say so. I’ve not reviewed the programming code to see what is involved, but I should be able to have an update with the fix completed by the end of June.
          2. Good. I was worried there for a moment.
          3. See the below simple example. I thought I had understood. Forgetting about a specific interest rate, the first example is the traditional interest calculation. Interest calculated on amount and term. The first interest payment is twice the amount as the other interest payments because the term is twice as long. The 2nd calculation uses precomputed interest (much like the Rule-of-78s). The total interest, for both, as you can see, is the same. To have a level interest-only payment there can not be any compounding because the days on which interest payments are actually paid are not known in advance.
          	         pmt    int   prin    balance
          06/16/20				10,000
          06/16/21	2,000	2,000		10,000
          12/16/21	1,000	1,000		10,000
          06/16/22	1,000	1,000		10,000
          12/16/22	11,000	1,000	10,000	0
          total int:              5,000		
          
          	         pmt    int   prin    balance
          06/16/20				10,000
          06/16/21	1,250	1,250		10,000
          12/16/21	1,250	1,250		10,000
          06/16/22	1,250	1,250		10,000
          12/16/22	11,250	1,250	10,000	0
          total int:              5,000		
          
  • Hi Karl,

    The calculator is great! It saves me with Hire purchase reconciliation. Thanks for that.

    Just wondering is there any way I could export an excel version of the schedule?

    Thanks.

    Harrison

    • Thank you. I’m happy to hear that you find it useful.

      There’s no way to export the schedule. However, from the print preview, you should be able to select the text and copy and paste into Excel.

  • Hi,
    I have not read all of the post – sorry. The product looks good. I am comparing it to T-Value – trying to save some money. I used the website version. The website version does not seem to provide yearly totals. Does the final product provide this?
    Thank you,
    Tim

    • Hi, I assume you are referring to the schedule? All versions of the schedule will show two total rows. An annual total and a running total, unless the cash flow is an annual cash flow.

  • Hi,

    I’m trying to calculate a fixed rate note with a fixed semiannual payment plus interest with an unknown end date.

    $122,724.99 starting on 7/1/2020
    $20,000 payment PLUS INTEREST starting on 12/1/2020 and continuing semiannually until all principal is paid
    Loan is at 6% interest

    • Hello, this calculator can easily do that.

      Enter your interest rate in the top.

      The first row will be for the loan amount

      The 2nd row will be for the payments. Click on "Cash Flow Options," and pick "Fixed Principal + Interest." Make sure you check the box to activate and enter the $20,000 principal amount. Click "Save Changes." to close the window. Under "# Periods" in the payment row, type "U" for unknown. Look at your beautiful schedule. 🙂

      Let me know if you have any other questions.

  • Roland Wentzel says:

    Hello Karl,
    When an extra payment is inserted before the first scheduled payment the Loan Summary erroneously states the payment frequency to be monthly (it was entered as semiannually) and erroneously states the periodic payment amount to be the amount of the extra payment. The amortization schedule, however, correctly shows the semiannual scheduled payments at the correct periodic payment. Why is the Loan Summary incorrectly describing payment frequency and periodic payment amount?
    Thanks in advance,
    Roland

    • Hi Roland, you’re right. To answer your question, why? I guess because out of the approximately 1,500 test cases I run through this calculator, I don’t have a case that tests for an extra payment occurring before the regular payment with the payment frequency other than monthly. I expect to release an update to the site within the next 4 weeks or so. I’ll try to have this fixed by then.

      Thanks for pointing this out.

  • hi….full disclosure – I have NOT read thru all the strings (I will, I will….) but trying to do first 2 steps of entering date and $$, it will not stay in the box…keeps reverting to today….can you dope-slap me with what I am doing wrong, or…….

    I am trying to enter data from borrow date of 4Apr 18, $25,000….first payment of 800.00 was made Aug 18 2018…..

    thanks for any help, or just tell me to read the instructions AGAIN….

    vr
    iris eisenberg

    • Hello, no knowing how you are trying to set the date, makes it difficult to say what is going wrong.

      First, are you using the button/calendar, or the keyboard? If you are using the calendar, then try the keyboard. Just type the numbers in the date, not the separator characters.

      If you are typing, try the calendar.

      If it still does not work, then tell me what date format you are using. MM/DD/YYYY?

Comments, suggestions & questions welcomed...

Leave a Reply to jason Cancel reply

Scroll
to calculator
to tutorials
to questions/comments
advertisement