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

SpreadSheet Calculations Help..

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,
4ubestAsked:
Who is Participating?
 
felixdsouzaConnect With a Mentor Commented:
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
 
Patrick MatthewsCommented:
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
 
4ubestAuthor Commented:
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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Patrick MatthewsCommented:
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
 
4ubestAuthor Commented:
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
 
felixdsouzaCommented:
Is this what you were looking for ?
Sample.xls
0
 
4ubestAuthor Commented:
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
 
felixdsouzaCommented:
Hi,  You've got me confused.  Could you upload that XLS file ?
0
 
4ubestAuthor Commented:
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
 
felixdsouzaCommented:
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
 
felixdsouzaCommented:
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
 
4ubestAuthor Commented:
That looks good..  How do I expand it myself to 3700 days ?
0
 
4ubestAuthor Commented:
Thank you that is great   ..
0
 
4ubestAuthor Commented:
Thank you for your help.. I wish I understood these things as they sure save a lot of paper and ink.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.