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,566
Country:
Thanks: 9
Thanked 348 Times in 320 Posts
TKHunny is a name known to allTKHunny is a name known to allTKHunny is a name known to allTKHunny is a name known to allTKHunny is a name known to allTKHunny is a name known to all
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