using for loops to calculate compound interest with yearly contributions

25 views (last 30 days)
Kayln Hess
Kayln Hess on 26 Apr 2022
Commented: Kayln Hess on 28 Apr 2022
My end goal is to calculate how many years it will take to reach a specified amount, when give an initial balance compounded annually with year contributions
I'd like to be able to specify
original account balance(P)
yearly contributions (C)
desired final amount(N)
rate of yearly interest (r)
I’d like to know what the account holds at each year. I was hoping to use an array and they count that numbers in the array (using numel(y)) to determine the number of years required to reach my final desired amount(N).
N=17804;
P=1000;
C=1000;
r=(10./100);
while P<=N
y(P)=(P*(1+r));
P=y+C;
end
x = numel(y)
The problem I am running into is that I the line “y(P)=(P*(1+r));” seems to create an array in which P always starts as 0 regardless of what value I assign to it.

Answers (3)

VBBV
VBBV on 27 Apr 2022
N=17804;
P=1000;
C=1000;
r=(10/100);
I = 1;
while P<=N
y(I)=(P*(1+r)); % use an index for desired amount,
P=y(I)+C;
I = I+1;
end
y(end)
ans = 1.7531e+04
plot(y) % calculated amount thru compounding
% hold on
% bar(N) % desired amount
x = numel(y)
x = 10
  2 Comments

Sign in to comment.


Prakash S R
Prakash S R on 27 Apr 2022
Edited: Prakash S R on 27 Apr 2022
The problem is as follows:
You are thinking of y(P) as "y-as-a-function-of-P'.
But when you write y(P), Matlab interprets it as 'vector y, at index number P'. And because P starts as 1000, it initializes a vector y whose first 999 elements are zero!
What you want is a loop counter that is used as the index into the vector y. Then you can count the number of elements in y as before:
N=17804;
P=1000;
C=1000;
r=(10./100);
ind = 1;
while P<=N
y(ind)=(P*(1+r));
P=y(ind)+C;
ind = ind+1;
end
x = numel(y)

ClementJ
ClementJ on 27 Apr 2022
Hi,
I think you need to add the cmp value in your loop and I think it is :
year_cmp = year_cmp + 1;
y(year_cmp) = (P*(1+r));
In your script, you have:
N=17804; % desired final amount(N)
P=1000; % original account balance(P)
C=1000; % yearly contributions (C)
r=(10./100); % rate of yearly interest (r)
year_cmp = 0;
while P<=N
year_cmp = year_cmp + 1;
y(year_cmp) = (P*(1+r));
P = y(year_cmp) + C;
end
x = numel(y); % You can use year_cmp also

Products


Release

R2021b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!