Health Check Your Business
Using the Business Planning Tools
Profit and Loss Forecast
To use the P & L spreadsheet;
- Enter your start-up figures into the relevant columns.
- Section one calculates and summarises your gross profit
- Section two calculates and summarises your overheads
- Your Trading and Net profit fiigures are then calculated
At the far right hand side of the spreadsheet you get the cumulative monthly
and year-end figures.
You can run the spreadsheet with different sets of start-up figures to see the
impact of various options - e.g more opening stock.
Cashflow forecast
To use the Cashflow forecast spreadsheet;
- Enter your income figures which will be automatically summarised
- Enter your expenditure figures which will also be summarised
The initial calculations will display your income less your expenditure. You also
need to enter your opening bank balance. The closing bank balance at each end of month will be
calculated and transferred automatically as the next next month's opening balance. The model will
calculate your cashflow over the months specified.
At the far right hand side of the spreadsheet, the model displays the calculated, cumulative
monthly and year-end figures.
The model can be used to investigate different scenarios - for instance the impacts of late paying customers, reduced or
increased income effects, changes to costs etc.
Free Business Adviser review
When you have completed you spreadsheets you can submit them for a free review by an Accredited Business Adviser.
Use the enquiry service on this site, follow the instructions to create an enquiry and enter the following text in the enquiry
subject line.
"Business Plan Review request"
The enquiry service will identify an Accredited Business Adviser in your locality who will contact you by email within a day or
so and invite you to submit your plan for review (with instructions as to how to input your plans).
Your spreadsheets/business planning forms will be forwarded to the Adviser who will review them and provide you with feedback.
This service is completely free and confidential.
