• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

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,
0
4ubest
Asked:
4ubest
  • 7
  • 5
  • 2
1 Solution
 
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
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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
 
felixdsouzaCommented:
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
 
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

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 7
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now