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$4B 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 ;)

✔ 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

message edited by mmcconaghy

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

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 ;)

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-Towhich 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

Here's a screenshot with the values

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

http://prnt.sc/d1lifvAgain, 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 ;)

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

message edited by mmcconaghy

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History