/    Sign up×
Community /Pin to ProfileBookmark

compound interest calculation with regular deposits over different periods

Copy linkTweet thisAlerts:
Sep 26.2011

Hi there,

I am putting together a calculator which does compound interest calculation with regular deposits over different periods.

Full html code in text format below is of working solution based upon changing all periods to weekly and calculating totals weekly. However I want to instead of doing it this way have different periods calculated only in their respected period length ie if 4 year selected than the inflated amount is only added every 4 years.

Basically I want pic 1 to look like pic 2 or excel attachment

Can someone please please help me im am stuck with how to do this.

Thank you in advance

to post a comment
JavaScript

2 Comments(s) ↴

Copy linkTweet thisAlerts:
@peterM03Sep 18.2013 — That's a good idea. I have seen many online calculators. It's truly helpful as we can't all be good with numbers. Several of us have struggled with math since early school days. Yet, adults need to build certain math skills if we want to make healthy financial choices. We have to know throw to calculate simple interest, as well as compound interest. Likewise, those seeking to invest have to know how to compute dividend returns.
Copy linkTweet thisAlerts:
@wbportSep 19.2013 — To do simple interest for a year, the formula is trivial. Convert the interest from percent to decimal (e.g., 5% = 0.05) and the formula is (1 + i) * amount to be compounded. For more years compounded annually, it's Amt * (1 + i) ** years. To compound it more often than once a year, divide the interest by the number of periods and multiply [B]years[/B] by the same amount. If you compound it monthly, divide [B]i[/B] by 12 and replace [B]years[/B] by [B]months[/B] in the exponent.

In mortgage.htm, that value is calculated as [B]x[/B] on line 75 to be used in a mortgage calculation on line 77. On line 71, the interest rate percentage is divided by 100 [B]and[/B] 12 to make it a decimal value and determine the monthly interest rate.

HTH
×

Success!

Help @ironmurph spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.24,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...