Question description:
This user has given permission to use the problem statement for this
blog.
how do I calculate daily interest in excel? for instance if I have $20,000 in a bank that gives .5% interest and calculates it daily, I want to create a spreadsheet that will show what I will have at the end of a 30 day month
Solved by O. A. in 21 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/03/2018 - 09:24
Hello
Excelchat Expert
02/03/2018 - 09:28
Hello
User
02/03/2018 - 09:28
What I'm looking for is a formula that get's me to the end result of 30 days without having to have a separate row for each day
Excelchat Expert
02/03/2018 - 09:28
Ok
User
02/03/2018 - 09:28
thanks
Excelchat Expert
02/03/2018 - 09:33
The formula is FV()
Excelchat Expert
02/03/2018 - 09:33
Which mean the Future Value
Excelchat Expert
02/03/2018 - 09:35
Are you there
Excelchat Expert
02/03/2018 - 09:35
?
User
02/03/2018 - 09:35
ok, so =FV(B1,B3,0,B2,end)
User
02/03/2018 - 09:35
it looks like the FV is for payment and I entered 0 for payments
User
02/03/2018 - 09:36
I see the value in B5, but can't see your formula
Excelchat Expert
02/03/2018 - 09:36
Yes because you don't need to pay every day
Excelchat Expert
02/03/2018 - 09:36
=FV(B1,B3,0,-B2,1)
Excelchat Expert
02/03/2018 - 09:37
This is the formula at B5
User
02/03/2018 - 09:37
and B1 should be the daily interest rate correct?
User
02/03/2018 - 09:37
so if 5% were the interest rate it would actually be =5%/365
Excelchat Expert
02/03/2018 - 09:38
Yes
User
02/03/2018 - 09:38
were you going to share the formula at B5 before I broke in>
User
02/03/2018 - 09:38
?
Excelchat Expert
02/03/2018 - 09:39
What do you mean?
User
02/03/2018 - 09:40
I only see the end result in B5 not the actual formula that you have there.
Excelchat Expert
02/03/2018 - 09:40
click the cell and the formula appears.
Excelchat Expert
02/03/2018 - 09:40
This is the formula
Excelchat Expert
02/03/2018 - 09:41
=FV(B1,B3,0,-B2,1)
User
02/03/2018 - 09:41
LOL - didn't realize I could interact with it. thanks
Excelchat Expert
02/03/2018 - 09:41
You can copy and paste it
Excelchat Expert
02/03/2018 - 09:41
Or you can download the file above this chat
User
02/03/2018 - 09:42
why is B2 a -B2 in this formula?
Excelchat Expert
02/03/2018 - 09:42
To get the result positive.
User
02/03/2018 - 09:42
ok, thanks
Excelchat Expert
02/03/2018 - 09:43
and the 20000$ you pay it to the bank
User
02/03/2018 - 09:43
Actually will use this to find out how much bank is paying me in a saving account, but same principal. thanks for your help
Excelchat Expert
02/03/2018 - 09:44
ok
Excelchat Expert
02/03/2018 - 09:44
thanks
Excelchat Expert
02/03/2018 - 09:44
Is there anything else you want to know regarding this issue?
User
02/03/2018 - 09:45
nope, you got me over the hump. thanks again. have a great weekend
Excelchat Expert
02/03/2018 - 09:45
same for you
Excelchat Expert
02/03/2018 - 09:45
bye
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.