Survival Cash (personal or business) - Free Google Sheet Template

Description
Note, the product is a Google Sheet template. The download is for Microsoft Word and the Google Sheet link is found on that along with instructions. A free google account is required to use this template.


The tracker is fairly simple, but really useful. The user can enter up to 6 sources of funds i.e. credit cards, cash in bank, or any other possible way that cash can be acquired. Then, the user will enter total cash in and total cash out per month.


The model will then show the depletion of each cash source over time based on the monthly cash flow. The idea is that you stabilize before all the cash runs out.There are two visuals that show the total cash available over time as well as the total cash available by source over time.


The advanced logic in here is the way that each source is depleted. It took a bit of work so that the cash burn will flow against each source until it runs out and then automatically start drawing from the next source until there is nothing left.


Some advanced color scaling was also used to make the raw numbers easier to understand and see when certain sources will run out.


Want Even More Templates? Check out My Max Bundle:
- All Templates: https://www.eloquens.com/tool/P8Y4TX4v/finance/financial-forecasting-models/financial-models-120-useful-and-usable-logic