[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# Simple Excel Formula Help..  Daily interested Rate of  .008582

Posted on 2008-06-18
Medium Priority
309 Views
I need help with Excel formula... I want to make a spreadsheet that goes for at least 5 years on a daily basis
with a daily interest rate of  .08528%.    I would like to have a spread sheet that has this formula.

How do I make this as I am a beginner in  Excel.?

Thank you,
0
Question by:4ubest
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 7
• 6

LVL 39

Expert Comment

ID: 21817283
assuming you have a value in A1, the following formula will give you the value+compounded interest over 5 years.
=A1*(1+0.08528%)^(365*5+1)

Thomas
0

Author Comment

ID: 21817524
I think I messed up with my question...   Instead of 1% interest per day it is .85228%  per day.
0

LVL 39

Expert Comment

ID: 21817570
Do you want to calculate the total interest, the daily interest (it would vary daily due the compound effect) or the total at the end of 5 years?
My formula does take the 0.08528% per day, I'm adding 1 to calculate the compound effect, e.g. \$100+ 5%=\$100*(1+5%), i.e. 105\$, not just 5\$
0

Author Comment

ID: 21817768
You are the expert..  doing it longhand and using 1%/day  I got starting with \$7,000 after 30 days  \$9300 and after 60 days  \$12346  and after 120 days   \$21714   but I now need to calculate all these at  .8528%/day

0

LVL 39

Expert Comment

ID: 21817942
Try that
in cell A1, put .8528%
in cell A2, put your number of days =365*5
in cell A3, put your amount \$7000
in cell A4, put your result =A3*(1+A1)^A2
That way you can play with the different variables in cells A1 to A3

Warning, this is compound interest, meaning the interest gained in day 1 earns interest on day 2.
The simple interest formula is the following :
=A3*(1+A1*A2)
0

Author Comment

ID: 21818058
Hi.,.. I never felt so thick before... What I want to do is to put  X dollars in on Day 1 and at  .8528% interest to be able to see   the total for each day and the interest earned that day  for about 3700 days.

This is what I have started but I do not yet know how to carry the formula down the columns. so the computer does it automatically and not me.

http://screencast.com/t/i8c0Sc0sg
0

LVL 39

Expert Comment

ID: 21818090
take your excel file, go to cell a3701, click on cell A3701, do Ctrl+shift+Up Arrow, Tab, F2, Ctrl+Enter
Repeat from cell B3701. That should take care of copying the formulas.
0

Author Comment

ID: 21818174
This is what I get after the first step..

go to cell a3701, click on cell A3701, do Ctrl+shift+Up Arrow, Tab, F2, Ctrl+Enter

http://screencast.com/t/odQQNEDg

doing that for B3701  I made a huge mess:  I do not think I did this as you said but I tried  3x and got the same thing...

http://screencast.com/t/IipTBzKNBT

0

LVL 39

Expert Comment

ID: 21818198
change your formula in cell B6 and replace B1 by \$B\$1, thus changing your relative address to an absolute address, then redo the copy.
0

Author Comment

ID: 21818405
It has to be easier than this as I had a lady do it while we were on the phone a week ago and that is what I used until I tried to modify it from 1%/day to   .8528%/day  and ruined the spreadsheet.

What you are doing is too hard for this old brain to understand,
0

LVL 39

Accepted Solution

nutsch earned 2000 total points
ID: 21818433
well I assume that your formula in cell B2 is something like =A2*B1, isn't it? If you copy it down to the next cell, by one of the below means:
- Copy / Paste
- Ctrl + C / Ctrl + V
- get your pointer on the lower right corner of the cell until it turns into a little black cross and drag down
you will have the formula A3*B2  in cell B3. But that's not what you want. what you want is A3*B1. By changing the formula to A3*\$B\$1, when you copy it down, it will become A4*\$B\$1, A5*\$B\$1, etc.
Clear as mud?
0

Author Comment

ID: 21818523
That worked...  thank you.
0

LVL 39

Expert Comment

ID: 21818547
Thanks for the grade, sorry if I took a while to understand your problem.

Thomas
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A look at what happened in the Verizon cloud breach.
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns overâ€¦
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦
###### Suggested Courses
Course of the Month12 days, 17 hours left to enroll