Financial: Savings plan calculation
05-16-2018, 08:02 PM (This post was last modified: 05-17-2018 04:36 AM by cortopar.)
Post: #2
 cortopar Junior Member Posts: 15 Joined: May 2018
RE: Financial: Savings plan calculation
Pseudo Pascal-ish code for the brute force method...
Code:
 EXPORT FindInterest(years,monthly,bonus,goal); LOCAL interest:=0.001; LOCAL increment:=0.002; LOCAL i:=0; LOCAL month:=0; LOCAL balance:=0; WHILE balance<goal DO   balance:=0;   FOR i:=1 to years DO     FOR month:=1 to 12 DO       balance:=balance+(balance * (interest / 12))+monthly;     END;        balance:=balance+bonus;   END;   interest:=interest+increment; END; RETURN interest; END;

Now this is going to return the interest at which balance exceeds goal. To get it exact would need additional processing at finer precision.

I’m sure there’s a formulaic way to solve this easier, but it exceeds my math abilities.

Edited to Prime-compliant HP-PPL. Tested on my Prime. It is slow as you’d expect. It could be sped up by providing or calculating a starting guess and larger increment before refining.
 « Next Oldest | Next Newest »

 Messages In This Thread Financial: Savings plan calculation - cds - 05-16-2018, 09:11 AM RE: Financial: Savings plan calculation - cortopar - 05-16-2018 08:02 PM RE: Financial: Savings plan calculation - KeithB - 05-21-2018, 04:49 PM RE: Financial: Savings plan calculation - cds - 05-23-2018, 08:28 AM RE: Financial: Savings plan calculation - KeithB - 05-23-2018, 02:06 PM

User(s) browsing this thread: 1 Guest(s)