View Single Post
  #6  
Old October 9th, 2008, 11:34 AM
TKHunny TKHunny is offline
MHF Contributor
 
Join Date: Aug 2007
Location: USA
Posts: 1,608
Country:
Thanks: 9
Thanked 354 Times in 326 Posts
TKHunny is a splendid one to beholdTKHunny is a splendid one to beholdTKHunny is a splendid one to beholdTKHunny is a splendid one to beholdTKHunny is a splendid one to beholdTKHunny is a splendid one to behold
Default

Now we're talkin'. The notation is a little rough, but I think I have it.

You must be careful with the interest rates, but even a good guess will get you in the ballpark. Generally, you are given an annual rate. It should be called "APR" or "Nominal". If this is so, there is no problem using a variant of this formula.

Here's the general version:

\frac{1 - \left(\frac{1}{1+\frac{i}{m}}\right)^{n*m}}{\frac{i}{m}}

n = Number of Years
m = Number of Periods per year
i = Annual Nominal Interest Rate

It's an easy enough cut-and-past task. I'll just type in a bunch...

Annual: m = 1 -- After a little algebra, this should look familiar.

\frac{1 - \left(\frac{1}{1+\frac{i}{1}}\right)^{n*1}}{\frac{i}{1}} = \frac{1 - \left(\frac{1}{1+i}\right)^{n}}{i}

Semi-Annual: m = 2

\frac{1 - \left(\frac{1}{1+\frac{i}{2}}\right)^{n*2}}{\frac{i}{2}}

Quarterly: m = 4

\frac{1 - \left(\frac{1}{1+\frac{i}{4}}\right)^{n*4}}{\frac{i}{4}}

Monthly: m = 12

\frac{1 - \left(\frac{1}{1+\frac{i}{12}}\right)^{n*12}}{\frac{i}{12}}

Weekly: m = 52

\frac{1 - \left(\frac{1}{1+\frac{i}{52}}\right)^{n*52}}{\frac{i}{52}}

Daily: m = 365 (You may want 360 or 366, sometimes.)

\frac{1 - \left(\frac{1}{1+\frac{i}{365}}\right)^{n*365}}{\frac{i}{365}}
Reply With Quote