Venue:
In-Person Venue TBC
Note:
Thursday 6th February
Gain a thorough understanding of how accounts are constructed and how to record transactions using Excel.
Course Outline:
- Basic Financial Statements and understanding
- Profit and Loss Account explained and demonstrated
- Cost of Sales, Margin & Mark Up
- Cash Flow – managing cash, debtors, creditors, stock, bank etc
- Difference between Profit and Cashflow
- Limited Company v’s Sole Trader
- Balance Sheet
- Budgeting – Principles of and how to use
- Cashflow Management – Simple forecasts and complex Excel sheets
- Useful ratio’s, what they mean and how to calculate
Participants will be challenged during the course of the day to complete exercises, both individually and as part of groups around activities such as:
- Financial Accounts Model – will be asked to build their own book-keeping system using Excel from beginning to end.
- How to record and update the accounts – as part of a group they will be asked to input data for different headings of their business (ie Sales, Cost of Sales, Overheads, Assets etc).
You have sucessfully added an event to your cart
Are you sure you want to remove this event?