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.

i am in the process of selling mobile homes to tenants in my mobile home park. I will be owner financing at 5% with set payments of $375.00 per month. I will be keeping the land and will be collecting ongoing lot rent. i will keep these two payments separate. Your

Ultimate Financial Calculator seems to be perfect fit but I need something i can download for 84 multiple buyers. Does any of the products in your store tract payments when actually paid, fixed payment amount, Fixed interest rate, allow for late charges if more than five days late? i can do a spreadsheet for each buyer but would prefer to have one of your calculators.

If you have a computer running Windows 7 or newer, I sell a program called C-Value!. $49.95.

It works the same way as this calculator. One of it’s big advantages is, it gives the user the ability to save each loan to a file. It is designed for tracking payments as they are made for any number of loans. It will certainly work for 84 buyers, but understand, each loan will be stored in a different file. The software does not create reports summing up the various loans. It will however export directly to Excel. Perhaps if you also wanted a summary you could to that.

About late charges – they are not specifically supported at startup. However, the user has the ability to add and name "Events" (same as "Series" on this calculator). So what you would want to do is add a "Late Fee" event.

Hope this helps.

Thanks, I will C-value form your store, Don

I am trying to structure a construction loan and need the whole amortization schedule.

Here are the details of the loan.

Loan Value: $4,665,000

Interest: 5.5%

Term: 15 years

Payment Period: monthly based on 365 days

The first 15 months will be interest only payment. After which the remaining 165 months will be normal interest and principal payment.

Can you guide me. Thanks

Sure. I think tutorial #14, Interest Only Loan Calculation will get you started, if not tell you everything you need to know. Please review that, and then if you have questions, please ask. This tutorial sets up an initial number of periods that are interest only payments followed by a series of principal and interest payments until the balance is 0.

I made a Hard Money Loan to my Brother in law June 24,2008.My brother in law gave me a deed of trust

to secure the loan.The loan was for $325,000 at an interest rate of 12% per annum .He’s made 4 payments

4/11/2012 $30,000 – 8/12/2012 $30,000 – 7/29/2015 $50,000 – 9/29/2015 $50,00.What calculator should i use to track the interest and loan balance.Iv been subtracting the payments to adjust the balance.I then

put the 12% interest on the unpaid balance.Is this the correct way of calculating.Please advise.

Thanks Wayne

Hi, please use the Ultimate Financial Calculator. This calculator will let the user enter payments on any date, for any amount. You can also adjust interest rates if that ever became an issue. On that page, scroll down and look at tutorial #1 for an overview and then tutorial #25 for your specific need to track loan payments.

It sounds as if your calculation is correct.

I now see that you were using the calculator suggested. (I replied to your messages from an admin feature and did not notice what calculator you were using). Did you see the tutorials? Do you have any questions?

I would like to say that your ultimate financial calculator is very accurate! I used it to help me pay off a 3 year car note early. I finished the note in 21 payments and your calculator was only off by $2.66! Great job, thank you for your hard work!

Thanks! But how do you know this calculator is off? I think it is best to say it "differs" from the other calculation you are using by $2.66. 🙂

Kidding aside, my guess is, if you are talking about the difference at the last payment, that may have been due to the way the rounding options on this calculator were set. The user has a few choices and they impact the final payment. So you know, whenever I make a change to this calculator, I run code that tests nearly 1,500 calculations which have all been verified against other sources. Of course, there could still be an error. If you’re interested, I will check into it, but I would need all your details, including how the various options under "settings" are set.

Congrats on getting that car loan paid off early.

Hahahaha, I guess I should have worded that better! I was comparing it to the actual statements generated by Wells Fargo Dealer Services. There were slight differences in the interest that had accumulated between payments. I entered the exact date and amount of each payment and compared the two together.

I have another car note and it differs by $1.33 so far after 14 payments. The interest is off by a few cents (the largest was 10 cents) each time as well. Again, I am comparing it to the actual loan statements generated by my bank which is different than the Wells Fargo. My bank seems to use a .05452 daily rate if that even matters since its still 1.99%.

And I did use a 365 days per year calculation method on your calculator and the rounding option was the default, open balance

Now I understand. Interest amount varies slightly period to period. I think you may have hit upon the reason. My guess is, the bank is rounding the daily interest rate and this calculator isn’t. The other thing you could try if you ever have to plug the numbers back in again, is try different compounding settings. The most efficient way to do that is to enter the payment until the row where there is the first difference. Then set the amount to unknown and change compounding and calculate. See if one compounding gives you spot on interest – the best choices to try would be daily, exact or monthly.

Eureka! You figured it out. I changed the compounding to exact and it produced the correct amounts of interest. I previously had it set for daily. Thanks again!

Cool. Good to hear and thanks for letting me know.

I am surprised a bit at the outcome. Your interest rate seems very competitive and Wells Fargo could have taken the opportunity to increase their profitability slightly by advertising the low headline rate while improving their return by using daily compounding.