ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I want to create a savings cash flow according to what I spend/sav (https://www.excelbanter.com/excel-discussion-misc-queries/236033-i-want-create-savings-cash-flow-according-what-i-spend-sav.html)

Talitha

I want to create a savings cash flow according to what I spend/sav
 
My dad has been teaching me how to do cash flow analysis. Now I want to add
to that, and add a savings cash flow into this analysis, but I don't know how
to do it. For example, If I save 100 dollars a week, how do I make this add
up over time? And then, If I create a row that details what I have withdrawn
from savings, how can i create a formula that subtracts this number from the
added up total?

Talitha

I want to create a savings cash flow according to what I spend/sav
 
I figured it out.

What I did is I had the spendings in C3
The amount I saved in C24
And the total from the previous week in B29.

=B29+C24-C3

If anyone has a better way to do it, please let me know.


All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com