Can anyone help me build a CASH-FLOW BREAK-EVEN model?

[gloggnelson]

Hi all,

I'm that rare bird with formal finance training but not nearly enough experience with Excel. (Not sure what one without the other is worth at this point....) I'm currently trying to build a cash-flow break-even model for a startup, but having some trouble with it.

I've found How-To videos on building PROFIT-AND-LOSS breakeven models, but I'm really looking for a way to calculate the CASHFLOW break-even point, i.e. the point at which initial investors recoup their capital. I think I've got the cash revenue and expense projections figured out, but I'm not sure how to do the cash-flow break-even analysis.

If anyone has a simple template they can send, or a video they can point to, or any other help for that matter, I'd hugely appreciate it.

Many thanks in advance,

Brett

 

[RonB1111]

Try Google search - "cash flow projection excel template"

Microsoft office has such templates: here's a link to one:
Small business cash flow projection - Templates

Your terminology is a little confusing on exactly what you're trying to achieve. Suggest you read this article:
Confusion on Break Even and Cash Flow Positive Points | Startup DE

 

[gloggnelson]

Thanks for the quick reply, RonB! Will give that template a shot. (And, yes, the article captures the distinction I was trying to draw between P&L breakeven and cashflow breakeven.) Cheers, B