Invest or pay any amount. On any date. At any rate.

Original Size

Time Value of Money (TVM) is the concept that the value of money itself changes over time. Having a dollar today is worth more than a dollar tomorrow. Solving for present value, future value, amount, interest rate and term are some common time value of money calculations. The above online Ultimate Financial Calculator is capable of performing any of these calculations with regular or irregular amounts on any date for savings or loan cash flows.

- Payment or loan amount
- Deposit or withdrawal
- Yields: APR, APY or IRR
- Balance as of a specific date
- Date a specific balance is reached *
- Present value (PV)
- Future value (FV)
- Balloon payment amount
- Payment required to reach a specific balloon
- Number of payments
- Interest rates - nominal or effective *
- Discounted values
- Remaining balance
- Deposit required

- Normal amortization or investment
- Rule-of-78s
- Canadian methods
- US Rule — simple interest
- Supports 360, 364 and 365 day years
- Exact day or periodic interest calculations

- Daily
- Weekly
- Bi-weekly
- Twice monthly (Half-month)
- Every 4 weeks
- Monthly
- Bi-monthly (every two months)
- Quarterly
- Every 4 months
- Semi-annual
- Annual

* Feature only available in C-Value! ™,

our cash flow calculator for Windows™

- Amortization & investment schedules
- Schedules with details or totals only *
- Custom headers and labels *
- Change fonts, colors *
- Select a fiscal year end *
- Reg. Z APR disclosure report *

- Normal
- Interest only
- Enter your own payment amount
- Negative amortization
- Skipped payments or deposits
- Fixed principal + interest
- Percent step amounts
- Dollar step amounts
- Balloon payments
- Extra payments
- Payments to interest
- Cash flow amounts set to any random date

- Exact day simple
- Daily compounding
- Weekly
- Bi-weekly
- Twice monthly (Half-month)
- Every 4 weeks
- Monthly
- Bi-monthly (every two months)
- Quarterly
- Every 4 months
- Semi-annual
- Annual
- Continuous
- Change the frequency of compounding during a cash flow
- No compounding option when rate changes

The below tutorials walk you through the steps for setting up the indicated financial calculation. I recommend that you right click on a link and select "Open in New Window" so you can have the calculator handy in this window as you read.

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

- Investment Cash Flow
- calculating final value

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

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

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

- Calculate Loan Amount
- How much can I borrow?

- Balloon Payment Calculation
- Calculate the balloon amount

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

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

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

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

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

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

- Interest Only Loan
- Initial series of interest only payments

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

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

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

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

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

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

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

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

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

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

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

Feel free to let me know if you have an idea for an additional tutorial.

Hi Karl,

Just found your calculator.. looks very good!

I’m trying to help my daughter understand her student loan pay-back situation(mess). She has multiple loans with different rates and timings.

Will the Ultimate Financial Calculator handle multiple loans/different rates and timings? We are trying our best to help her make sure she is correctly allocating her payments to attack the most offensive loans first. Any help would be greatly appreciated!

Thanks & Regards,

Carl S

Hello Carl, the (Almost) Ultimate Financial Calculator is designed to handle one loan or investment cash flow at a time. It will allow the user however to do a lot of what-ifs. What-if I make a single extra payment in month 15? How much will I save over time? What if the interest rate changes? etc.

The calculator will handle interest rate changes but it won’t handle multiple loans with different interest rates with overlapping periods.

The way I would approach this problem is enter the details for each loan and print a schedule. (You can also use the Amortization Schedule Calculator on this site too which maybe faster.) The schedules will show you running interest due as well as interest for each year. Find the loan that accrues interest the fastest an try to pay that one off first. (Personal opinion – not advice).

Karl,

I downloaded the C-Value calculator to try and set up a loan with fixed principal payments. The person has skipped several payments and I need to let them know how much they owe including accrued interest. Does the C-Value calculator have the fixed principal loan option? I do not see this option for C-value only for the amortization schedules.

Thank you.

Lisa G.

Hi Lisa, yes, both C-Value! and this calculator support fixed principal. To activate, you’ll need to have 2 or more payments on a row. Then click in the right most column to open the special series settings window. There’s is an option there for “FIXED PRINCIPAL + INTEREST”.

I was hoping this calculator would help in providing an overview of my 2012 loan that had 2 balloon payments that I paid off early but it is not allowing me to put infomation in to calculate? I think it was overpaid 🙁

This is the calculator to use. Do you know why it’s not letting you put in information? Do you get an error message? The calculator will let a user enter every payment made on a loan and it will take that information to calculate a balance as of any date.

By the way, everyone should read tutorial #1 above to get an overview of how the calculator works. And then, for your needs, tutorial #25 is most appropriate.

If you have a specific question, I’ll try to help. Or if you can tell me what you are doing, I’ll try to figure out the problem.

Hi Karl:

I just finished the tutorial for the Ultimate Financial Calculator. I put in all the values I am working with on a student loan. How do I save these calculations from month to month until the loan is paid in full? Am I able to download the calculator to my computer?

Thank you,

Hi Lea,

With the online calculators, there isn’t anyway to save the inputs or calculations to disk. The software that will do that is C-Value! (see links/buttons at the top of every page). C-Value! is only for Windows however.

If you are interested in C-Value! give it a week or so. I’m moving the store from the old pine-grove.com site to this site, and I’ll need help testing the shopping cart. I expect to offer free copies after this weekend for a very brief testing period. Otherwise, the price will be $49.95.

Hi Karl:

Thank you for your reply. I will check this out next week! I really need the calculator to save my calculations.

I should let you know I have a mac computer and prefer to use it. I also have a windows computer if it is necessary in order to do a download of this calculator.

Can a column be added to the “Payment Schedule” ?

Such as “Additional Loan Amount”, “Description” or “Penalty” ?

If you mean can the user add a column, then no. If you mean as a new feature, I’m evaluating the possibilities for enhancements and how enhancements might be implemented.

As for “Additional Loan Amount”, it’s not clear to me why this would be needed. Currently the user can add as many loan amounts to a cash flow as they probably will ever need. Just add a new row and select “Loan” under series. The additional loan can occur on any date. See the tutorial (link on this page) for "Construction Loan" that provides an example of how to do this.

Also, a "Loan" can be a penalty as well. The only issue with that is, the labeling isn’t accurate, but the math would be if the penalty increases the balance owed.

Sir,

I have an Agricultural Loan Scenario where half-yearly loan installments are defined by seasons have due dates as 31st Jan & 30 Jun of the year. Half-Yearly Interest on Loan Schemes are calculated on 30th Sept. & 31 Mar.

A Loanee has availed a Rs. 500000/- for 7 years at roi of 12.80% on 16th Sept. 2015. The first installment amt of Rs. 55133/- (as per amortization chart) for the period 1st Feb to 30th Jun becomes due on 30th Jun, 2016. As the Loan amount was availed on 16th Sept. 2015, interest for the period 16th Sept. 2015 to 31st Mar. 2016 on the loan amount, which works out out to be 34718/- (simple intt. for 198 days) needs to be apportioned (or adjusted) in the amortisation schedule so that the complete Principal Amount is recovered. I am unable the locate the Calculator which could meet my above requirement.

Thanks

I believe this calculator will do what you need, but if you’ll notice, you haven’t actually asked a question. It’s hard for me to know what to answer. I also don’t understand the statement about the first installment amount of 55133 as being per the amortization chart. Is this a value calculated by this calculator or is this per the loan contract’s schedule. Once again, if you want some guidance, I’m happy to provide it, but please ask specific questions rather than implied ones. Thanks!

Hi Karl

Rs. 55133 is the half-yearly installment amount arrived from Amortisation Chart for Rs. 500000 at 12.80% for 7 years. I just need some guidance on Financial Calculator to use for apportioning/adjusting the pre EMI interest of 34718/-.

Thanks

Hi, I believe I understand. The first payment will be larger than the others because of the longer initial period will accrue more interest. If that’s the case, then the loan will have 3 rows in the calculator. 1st row is the loan amount. 2nd row is an unknown amount and the 3 row is the remaining regular payments that are already of a known amount. The calculator will calculate the larger 1st payment for you.