Financial Modelling Masterclass For SMEs

The drive into the course will look at how to write a feasible and fundable financial model through the following:

• Budgeting for your startup/expansion expenses and assets (building your beginning balance sheet) - What to watch out for
• Understanding different types of sales projections and how they are projected using excel as a tool (We look at four types of sales projections i.e unit based, recurring revenue, hourly billing, general revenue target)
• Understanding the difference between direct cost of sales and other running costs
• The interaction between Income Statements, Balance Sheets and Cash Flow Statements in financial models, and the necessity of utilising this approach
• Modelling all components of a typical Income Statement and Balance Sheet, including fixed assets and components of working capital
• Understanding the importance of departmental expense planning i.e separating the income statement into different expense categories for easier expense planning
• Understanding the main ratios of your business plan and what they mean about the feasibility of your business model
• Planning What if Scenarios and preparing them for your business plan

• Powerpoint Investor Pitch based on the business model canvas with the summary of your financial projections pasted in the right places within that pitch
• A complete financial projections model in excel with up to 5 years annual detail, 24 months monthly detail on the following:
  • Startup  Budget - (Your beginning balance sheet)
  • Sales Projections - (Your revenue streams with their direct costs)
  • Personnel Projections - (Planning for salaries and other worker related costs)
  • Income Statement
  • Cash Flow Statement
  • Balance Sheet
  • Financial Ratios
  • Return on Investment including IRR and NPV
  • Loan Repayment Schedules (If applicable)
  • There are 10 more detailed reports that are generated by the system to help you understand your model even further