The below tutorials will step you through the indicated calculation. I recommend that you right click on a link and select Open in New Window so you can have the calculator available to do the steps as you read.
For the Ultimate Financial Calculator™ (UFC)
- 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
- Not available - planned.
- 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
- Calculate the penny perfect pay off amount
14 Comments on “Tutorials”
Hi, this is a great site & tool. Thank you very much for making this available. Can you please let me know if there is a way to set the amortization term?
Hi, thank you!
If you set the “# Periods,” that sets the term. Or is that not what you meant?
For what you want to do, please see this pay-off calculator and tutorial.
Thank you Karl. This worked out fantastic! Appreciate your calculators & quick assistance
You’re welcome! Glad to hear that it is useful for you.
is there an option for missed payments that increments the new interest and principal amounts automatically
or a way to input the actual payment amount received each month?
my issue is we have 8 missed payments due to me and need to see the new schedule
Yes. Please use this loan payoff calculator.
It allows the user to record payments as of any date and change interest rates on any date.
Mike Cleveland says:
Greetings, is there a way to see monthly balance of savings, starting with $10,000.00 and earning 20% per year for 3 years with monthly compounding?
Hello, please give this Savings Calculator a try. It should quickly give you what you need. If not, please let me know and I’ll make other suggestions.
I love your calculator and I have been using it for a while but today when I clicked “schedule” it did not respond for some reason 🙁
Can you look at it please because your calculator is the best on the web!
I’m glad you like the calculator, and I’m sorry you are now having a problem.
Unfortunately, I don’t experience the same thing. That is, I’m able to see the schedule. Can you please try it from this page?.
Also, perhaps you can close your browser and try again? Or try a different browser?
If you still have a problem, please save your inputs to a file and send me the file. (Email address is on the "Contact" page.) I’ll take a look. Perhaps there’s a bug and your particular settings are impacted by it.
Terry Erwin says:
I am trying to print a report and each time I try to go to Amortization to export to Excel, I get a message that the dates are out of order, do I want to sort the cash flows?- the dates are NOT out of order but it won’t allow me to go further unless I agree to do it. When I click yes, to sort that, on the amortization it has entered Loan Amount over and over, pretty much every other line. I have to go back and delete those lines. I am sure there is something simple I am missing, can you please help me? I love this program, just can’t find what I need to groom my reports like I need.
I’m lost. Where do you see "Export to Excel"?
The way you print a schedule is click on the "Schedule" button. You can then either "Skip the title page" or "Continue" after you have provided the details you want for the title page.
The schedule will open in a window. There, at the bottom of the window, you should see a "Print" button.
If this is not working for you, please let me know more details. What device (desktop/mobile) and browser are you using? Can you send me your inputs in a saved file?
I would appreciate it if this works for you that you let me know where the confusion was. I want to clarify it for others. Thanks.
Also, I need to check, but I think you might be getting the date out of order message if you’ve entered a row with a number of payments cause an overlap in dates with the next row.
For example, say row 2 has 12 monthly payments starting January 1, 2023.
Then if you enter in row 3, an extra payment with a date of say June 1, 2023, then I think the calculator might see these as out of order. You can enter 5 payments, then 1 extra payment followed by 7 payments.
However, to fix the out of order issue, please try clicking on the "Expand" button and then the "Collapse" button. I think that will fix the problem.
Again, please let me know.
Comments, suggestions & questions welcomed...