You can now look at the "P&L Forecast" and "Cashflow Forecast" sheets to see the results of your changes, such as:
- What happens to your cash if you pay your suppliers 1 month later?
- Do you run out of money if your customers pay you a month more slowly?
- How quickly will you use up your cash if your costs go up and your sales go down?
The "P&L Forecast" sheet also shows how much your profit will change year-on-year, comparing the forecast to last year's figures, both in actual pounds and in percentages.
The "Cashflow Forecast" sheet contains a rough approximation of tax based on your monthly profit.
It also has yellow rows where you can enter cash receipts and payments that won't be on your P&L, for example, loan repayments, or money you've taken out if you're a sole trader or partner.
For the more visual person, the "Graphs" sheet enables you to see quickly how your sales, gross and net profit, and cashflow, will change.