Solved [EXCEL]Calculate account balance with intervals and interest

Various / CUSTOM BUILT
October 31, 2016 at 04:59:04
Specs: Windows 10, Intel i7 4770k, 32GB 1600MHz RAM
I'm trying to calculate an account balance after, say 10 years.

I want the sheet to display balances with a given intervals, say an interval of two which would display balances for 2016, 2018, 2020, 2022 and 2024.

I can easily make formula which calculates total account value with interests and stuff, but only if the interval is one (displaying each year between say 2015 and 2020), I can't seem to figure out how to make one that also takes the interval into consideration.

What I have right now is this:

=SUM(B4:D4)
B4 being what is already in the account, C4 is what is being added to the account, and D4 is the interest.
=(B4+C4)*G$4
B and C4 I've already explained, and G4 contains the interest percentage.

What would I have to change/add to make it calculate the values when taking the interval into consideration?

Don't worry if plan A fails, there are 25 more letters in the alphabet ;)


See More: [EXCEL]Calculate account balance with intervals and interest

Report •

✔ Best Answer
November 1, 2016 at 08:18:11
Try here for calculating Daily Interest:

http://www.wikihow.com/Calculate-Da...

For Daily Interest compounded Monthly, try here:

http://money.stackexchange.com/ques...

Also the Excel Function CUMIPMT()

https://support.office.com/en-us/ar...


MIKE

http://www.skeptic.com/

message edited by mmcconaghy



#1
October 31, 2016 at 07:46:51
What would I have to change/add to make it calculate the values when taking the interval into consideration?

Some type of Date function, like DATEDIF() so something along the lines of:

IF(DATEDIF (start_date, end_date, "Y") = 10 , do calculation , do something else)

MIKE

http://www.skeptic.com/


Report •

#2
October 31, 2016 at 11:09:08
So there's no sort of mathematical expression to use?

like, newbalance=oldbalance+income+(interest*interval)*interval

Idk how it'd work, It's not a very complicated sheet. There's a starting year you can input, and an interval, then based on the starting balance and yearly income (which is constant) it shows the account balance across the years as far down as the rows are made.

Don't worry if plan A fails, there are 25 more letters in the alphabet ;)


Report •

#3
October 31, 2016 at 14:16:30
There are some 55 different financial functions coded into Excel most of which I have never used.

Here is a list that you can look over and see if anything fits your situation:

https://support.office.com/en-us/ar...

If nothing fits, post a small sample of your spread sheet, after reading this
How-To which explains the use of < PRE > tags to align your data:

http://www.computing.net/howtos/sho...

Please include Column Letters and Row Numbers
and we'll see what we can come up with.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
November 1, 2016 at 02:35:06
Here's a screenshot with the values
http://prnt.sc/d1li1o

Here's one displaying the formulas
http://prnt.sc/d1lifv

Again, my problem is I neeed to make excel calculate the balances for the years between the intervals, not just when an interval has completed.

Don't worry if plan A fails, there are 25 more letters in the alphabet ;)


Report •

#5
November 1, 2016 at 08:18:11
✔ Best Answer
Try here for calculating Daily Interest:

http://www.wikihow.com/Calculate-Da...

For Daily Interest compounded Monthly, try here:

http://money.stackexchange.com/ques...

Also the Excel Function CUMIPMT()

https://support.office.com/en-us/ar...


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

Ask Question