Welcome Guest!
 VB Helper Q & A
 Previous Message All Messages Next Message 
(no subject)  Robert DiRosa
 Aug 01, 2010 09:59 PDT 

Please Help with this calculation

I am currently writing a subroutine that calculates monthly loan
payments and I am having trouble with the formula which are:

<table width="60%" border="1">
<tr>
<td width="20%" rowspan="3" align="center">Monthly Rate=</td>
<td width="60%" align="center">Rate</td>
<td width="20%" rowspan="3" align="center">x principle</td>
</tr>
<tr>
<td align="center">Rate + -------------------------------- </td>
</tr>
<tr>
<td align="center">[[1 + Rate] months] -1</td>
</tr>
</table>

The rate which is 8% or .08 divided by 12 months by calculator comes out
to 0.0066666666666666666666666666666667. The formula calculates it as
0.0066666666 but I no matter how I format the number it keeps ending up
with the 7 on the end, which changes the end result. Does anyone have
any suggestions


Thank you in advance
Bobby D
	
 Previous Message All Messages Next Message 
  Check It Out!

  Topica Channels
 Best of Topica
 Art & Design
 Books, Movies & TV
 Developers
 Food & Drink
 Health & Fitness
 Internet
 Music
 News & Information
 Personal Finance
 Personal Technology
 Small Business
 Software
 Sports
 Travel & Leisure
 Women & Family

  Start Your Own List!
Email lists are great for debating issues or publishing your views.
Start a List Today!

© 2001 Topica Inc. TFMB
Concerned about privacy? Topica is TrustE certified.
See our Privacy Policy.