Lookups

Cashflow positive for the month

For Financial planning and analysis models you often need to:

• Calculate growth based on previous months
• Find the point in your model where you break even

You can achieve this using lookupand previous.

Here's how to find in what month you turn cashflow positive.

Break even

Sometimes however you need to keep count of profits, or headcount.

You can use the previous function and find the month when you break even.

If you want to calculate how much of a interest free loan or extra investment you need: