financial calculator loan mortgage investment savings
Featuring Active Server Pages Technology
financial calculator loan mortgage investment savings
HOME     Financial Calculator      Unit Conversion Tools       Contact Ron       Downloads       Guest Book       Domains

Navigate
Domain Registration and DNS Management, Active Server Pages ASP

SEARCH
(This site or
Entire Web)


Website Design
and Computer
Services


Domain
Management

(secure server)
Your Account

New Domain
Registration


Downloads
FTP Software

Guest Book
Source Code


Animated GIFs

ASCII Character
Code Chart


Application
Demos

Financial Calculator

Conversion Calculators

Guest Book

Other
Tutorials

LINKS

What is Hard?

Awards

Resume
Ron's
Resume


Contact
Contact Ron

Ron's
Guest Book


About This Site



Calculator Examples

This Calculator accepts and returns positive values for almost all calculations.  I figure most people dont think, "I get positive 50,000 from the bank, so I have to pay negative 800 back a month."  I have tried to eliminate that kind of confusion as much as possible.  (see complete list of examples below)

The major exception is for computing a payment where there is a remaining balance, or Future Value (FV), at the end of the period (Future Value is typically $0 at the end of a loan period, you would owe nothing).   For example, if you put $1 million in the bank, and want to compute payments based on living off of the interest, then you need to include a FV in the payment calculation.  The FV in this case would be $1 million of course, and that value must have a sign opposite Present Value (PV).

So, if you invested the $1 million and you know you can get 7%, and you want to have a million bucks left over at the end of 20 years, you would enter $1,000,000 for PV, 20 for Period (n), 7 for interest (i) and $-1,000,000 for FV.  If you use a positive value for FV in this example, you would not get an accurate result (the result is accurate mathematically, but it is probably not the true answer to the question you are asking).



Loans and Mortgages

To compute a loan or mortgage payment you need to have the loan amount (PV), the annual interest rate (i), the period of time for the loan (n), and the frequency of payments. For example, if the loan amount is 180,000, the interest rate is 6.75%, the period of time for the loan is 30 years and you will make payments monthly, enter the following information in the calculator...

  • Enter 180,000 in the Present Value (PV) field.
  • Enter 30 in the Periods (n) field, and make sure the years (yrs) option is selected, or enter 360 and make sure the months (mths) option is selected
  • Enter 6.75 in the Interest (i) field.
  • Select Monthly (12), in the Payment Frequency field
  • Choose the (Pmt) option to calculate the payment
  • Click Compute

After you click compute you will see a message on the calculator telling you what your payment will be (in this case $1,167.48). The payment amount will also be in the Payment field on the calculator.

You can use this to calculate how long it will take to pay off the loan if you make extra payments. For example, after you calculate the loan, change Payment Frequency to "Two Extra Payments (14)". Then select (n) to calculate the number of periods. Click Compute. Look at the amount in the Periods (n) field and you will see that with just two extra payments you would pay off the loan in a little over 20 years.

For normal loans I suggest you always compare Bi-weekly payments to monthly payments. It will always result in a lower total monthly payment amount, and often times, significantly lower.

Calculator List of Examples

The Future Value (FV) of Money

The Future Value (FV) calculation can tell us how much we will have in the future if we invest a certain amount at a certain Interest Rate (i). For example, suppose I put away 20,000 dollars, and my stock broker tells me I will get a 12% return on that investment over the long term (we are assuming the rate is constant). We can calculate what the initial investment will be in 20 years...

  • Enter 20,000 in the Present Value (PV) field.
  • Enter 20 in the Periods (n) field and make sure the years (yrs) option is selected
  • Enter 12 in the Interest (i) field.
  • Payment Frequency will not affect the Future Value (FV) calculation (it will affect the Future Value of an Annuity (FVa) calculation)
  • Choose the (FV) option to calculate the Future Value
  • Click Compute

As you see, the money will grow to $217,851.07 in 20 years with an Interest Rate (i) of 12%.

Calculator List of Examples

Payment (Pmt) Calculation Based on Future Value (FV)

To determine how much to put away to have a certain amount in the future you need the Future Value (FV) , or amount you want to have in the future, and the rate of interest (i) you expect to get over the Period (n) of time you are saving. So, if you need to have $150,000 in 10 years and you expect to get 12% or so on your investment...

  • Enter 150,000 in the Future Value (FV) field
  • Enter 10 in the Periods (n) field and make sure the years (yrs) option is selected
  • Enter 12 in the Interest (i) field.
  • For Payment Frequency use Monthly (12)
  • Choose the (Pmt) option to calculate the Payment
  • Click Compute

The calculator returns $652.06, which is the amount you need to save each month for 10 years at 12% to have $150,000 in your account. Try this calculation with the Bi-weekly Payment Frequency, and you will see that if you put money away every two weeks, instead of monthly, you will need to put away $299.58, or $600 a month. A $50 dollar savings. Although it is not a true savings, it does allow you to pay less per pay check, if you are getting paid bi-weekly.

Calculator List of Examples

Present Value of an Annuity (PVa) calculation

If you figure you need about $1500 a week to retire comfortably and you want to know how much you need in your account to be able to withdraw that amount each week for 20 years, assuming you will get 12% interest...

  • Enter $1500 in the Payment (Pmt) field
  • Enter 20 in the Periods (n) field and make sure the years (yrs) option is selected
  • Enter 12 in the Interest (i) field.
  • For Payment Frequency use Weekly (52)
  • Choose the (PVa) option to calculate the Payment
  • Click Compute

The amount you need in your account if you are getting a Rate of 12%, to pay yourself $1500 per week for 20 years is $590,870.06. You can verify this if you enter 590,870.06 in the Present Value (PV) field, enter 20 in the Period (n) field, enter 12 in the Interest Rate (i) field, choose the Weekly (52) Payment Frequency choose the (Pmt) option for the calculation and click Compute. As you can see, this amount will pay $1,500.00 per week.

Calculator List of Examples











Back To
Calculator
Page







Donations
& Tips
Send Ron a Donation
Send Ron a DonationSend Ron a Donation
Send Ron a DonationSend Ron a Donation
Problems, Questions, FeedBack, Suggestions?
Please Email Ron

© 2002 - 2005 Ron Williams

You are 1 of 801 current visitors
Total visitors since 1/1/2003: 1,228,153

64.71.40.22