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.

Hey Karl,

Just wanted to say Thanks! The attorney for the person doing an owner finance mortgage for me used your site to give me an amortization schedule, and now I have used it to print a schedule for the extra payments I plan to make. The tutorial for setting up the schedule was very easy to follow. I appreciate the use of your site!

Thanks, Kim! I appreciate hearing how it’s used.

Thank you! Is this at all available as an excel template?

You’re welcome.

It’s not. One of the features I’m thinking about adding is the ability to export the schedule to Excel. Would that help?

In the meantime, it is possible to select the schedule in the print preview and copy/paste to Excel. If you try it, you’ll probably need to do a Paste Special in Excel and paste without the formatting. (Generally works best with IE.)

Hi Karl,

This is a great resource for my financing business. Thank you!

I had a hard time finding something that accounts for the delay in 1st payment over the loan date.

If you do a template/export option, it would be even more appreciated.

Thanks again!

Daniel

Thank you. Setting loan date and first payment date separately is a popular feature.

I’m thinking about adding an export to Excel feature. But I have a lot of other items on the list to do first. In the meantime, it is possible to copy/paste to Excel (if that’s helpful) from the print preview window. You will most like have to use Excel’s "Paste Special"e feature without formatting. But each value will be in it’s own cell. From there, you can add back in any formatting you like.

Karl,

Your amortization schedule is wonderful.

I am a business law and real estate attorney . I have been practicing for 50 years.

I just came across your financial calculator web site. Where has it been for the last 50 years?

Oh yea, computers and software were in their infancy.

It is now in my “favorites” category.

Peter Abbo

Well, thank you! I appreciate the nice words. As you noted, I wouldn’t have been able to help you out 50 years ago, but I did write my first calculator in March 1983 (for an Apple IIe), and I’ve just not been able to stop. 🙂

Please tell your colleagues about this site. I could use the traffic for bragging rights.

I tried to use the shortcode for calculator plus so I use it to solve for the interest rate but it had another calculator? Could you tell me what is the correct shortcode?

Hi Chris, I see I have an error in the documentation that I need to fix.

For this plugin FC Loan Calculator Plus, this is the shortcode example:

[fcloanplusplugin sc_size="medium" sc_custom_style="no" sc_add_link="Yes" sc_brand_name="Your Brand Name Here If Desired" sc_hide_resize="No" sc_loan_amt="31500" sc_n_months="60" sc_rate="5.75" sc_pmt="0.0"]

This is the minimum:

[fcloanplusplugin]

Make sure you have downloaded the plugin from the above link (not from what’s in the WordPress Plugin directory).