Solved

# SpreadSheet Calculations Help..  .08528% per day compounded. and taking 20% out each day..

Posted on 2008-06-19
310 Views

I with the help of you got my spreadsheet working that is compounding ,05828%/day   but now I would like to add more columns that would calculate the daily amounts after  20% of each day was taken out leaving the 80% of what was there to be compounded daily.

The figures will be changed quite a bit I am sure but I need help adding to the existing spreadsheet.

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
• 5
• 2

LVL 92

Expert Comment

ID: 21823842
Hello 4ubest,

Please post a link to the previous question you allde to, and please give us an example of what you mean
with the "take out 20% each day".

Regards,

Patrick
0

Author Comment

ID: 21823996
Patrick

http://www.experts-exchange.com/Storage/Misc/Q_23499467.html

now here is the story,... this is an "investment" that pays out on the initial investment .08528%/day and you will compound it daily.  I figured it for 3700 days,

NOW  I want to figure out what the daily amounts would be if I was to cash out 20% per day and keep the  remaining 80%  compounding.

Here is a picture of what I have for first 15 days with  \$10K  invested and that is compounding 100% each day.. I want to have other columns showing what would happen if I compounded 80% each day.

http://screencast.com/t/sLTgDUHFHyO

0

LVL 92

Expert Comment

ID: 21826158
If I get your meaning, you want to see the end balance if you allow x% of the interest to stay in the
account and accumulate, and take out (1-x)% each day to buy hats or something.  This formula
does it:

=BeginBalance*(1+RatePerDay*PercLeftInAcct)^NumberOfDays
0

Author Comment

ID: 21827527
I do not know about that but I want to see the effect and result each day for the 3700 days of compounding 80% of the normal number.

Again I want to see each day the #,,

0

LVL 9

Expert Comment

ID: 21829439
Is this what you were looking for ?
Sample.xls
0

Author Comment

ID: 21829557
Hi Felix,,

No it is not. as the numbers should get larger every day as the daily compounding takes place.

I am looking for the pure daily compounding of  X dollars at  a rate of  .8528%   and then   if  80% of the daily interest is  compounded as opposed to 100% ,  what would be the numbers each day and I am going 3700 days.

similar to what I have here but I do not know if I have it correct:

http://screencast.com/t/om1E24mHQQF

0

LVL 9

Expert Comment

ID: 21829576
Hi,  You've got me confused.  Could you upload that XLS file ?
0

Author Comment

ID: 21829613
This is the spreadsheet I have so far but I do not know if it is correct..   Again  I want to see the results of compounding at   .8528% daily for 3700 days and the corresponding daily interest earned    AND

then    instead of daily compounding 100% of the interest earned  to compound 80% of it and I want to see values for the daily interest earned AND the daily totals...

Ideally I really want to modify it so I can take more out each time than 20 %  but I am starting there.
asd10yrsMod.xls
0

LVL 9

Expert Comment

ID: 21829653
As per my understanding this is probably what you are looking for.  If not, let me know what is wrong with it.  I have only put in 10 days worth of lines to reduce file size
Sample.xls
0

LVL 9

Expert Comment

ID: 21829724
I forgot to mention that changing the value 20% in cell H1 will result in different scenarios like you require - eg. change it to 25% and cell I1 will change to 75% and the calculations will happen accordingly.
0

Author Comment

ID: 21830040
That looks good..  How do I expand it myself to 3700 days ?
0

LVL 9

Accepted Solution

felixdsouza earned 500 total points
ID: 21830130
just copy the last line down till line number 3701 and update the Day No column.  However I have done it for you... here is your file.

btw... i'm off for the day... will respond to any further messages (if any) tomorrow.  Hope this works for you.
Sample.xls
0

Author Comment

ID: 21830215
Thank you that is great   ..
0

Author Closing Comment

ID: 31468865
Thank you for your help.. I wish I understood these things as they sure save a lot of paper and ink.
0

## Featured Post

Question has a verified solution.

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

### Suggested Solutions

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.