posted 14 years ago
Ok, I know what you're doing wrong, you have a few problems here.
First this formula:
is wrong.
if my deposit is 500 and my annual % yield is 2% then this returns 500.83333333, this is the total i accumulated not the amount yield per month.
the correct formula is:
Second, you don't need to redefine monthlyYield as monthlyYield1, because it doesnt change from month to month, its constant.
Third, you dont need two for loops, you only need one.
declare a new variable to hold to total cd value;
example:
hope this helps
Hunter.
"If the facts don't fit the theory, get new facts" --Albert Einstein