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

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

Patrick

https://www.experts-exchange.com/questions/23499467/SpreadSheet-Calculations-Help-08528-per-day-compounded-and-taking-20-out-each-day.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

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

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 #,,

Is this what you were looking for ?
Sample.xls

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

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

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

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

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.

That looks good..  How do I expand it myself to 3700 days ?

Thank you that is great   ..

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