Financial spreadsheets - P&L, or other?
I need a better way to project income and expenses. I have a great spreadsheet to track expenses and rent coming in. I'm looking for something similar to project future numbers. For example, if I have $5k in a bank account today. How much will be in that account in 15, 30, 45, or 90 days, based on $x per month in water, electric, etc. as well as $100 a month for capex. And be able to say, oh, after 180 days I'll have $600 in Capex, but it's in the general account total.
That way I can better plan. For example - I need a new fridge in the unit, turnover happens in 3 months. What will be in the capex account?
Does anyone have a spreadsheet they can share? I tried google, but did not find what I was looking for.