Seems to me it takes more brains to bounce a circle off another and keep it inside a frame that it does to do this, plug in numbers for formula:
Code: (Select All)
DefDbl A-Z
Input "Principal "; P
Input "Annual Interest Rate "; I
Input "Compunding Frequency (how many times per year) "; C
Input "Number of Years "; N
Input "Monthly Payment "; R
'FV = Future Value (inflation not considered)
FV = P * (1 + I / C) ^ (N * C) + R * ((1 + I / C) ^ (N * C) - 1) / (I / C)
For m = 1 To 12
N = m / 12
FV = P * (1 + I / C) ^ (N * C) + R * ((1 + I / C) ^ (N * C) - 1) / (I / C)
Print "Month "; m; " Future Value ="; FV
Next
b = b + ...