Forecasting and Budgeting

• Types of budgeting
• Master budget and budget preparation
• Budget revision and budgetary control
• Entering prepared budgets in Xero
• Budgeted versus actual variance analysis
• Budget factors and templates
• Budgeting working papers
• Budgeted Profit & Loss, Balance Sheet, and Cash Flows
• Smoothing techniques
• Trend analysis and regression analysis
• Expected values and evaluating forecasting techniques

Departmental Analysis

• Creating and managing departments in Xero and Sage
• Allocation of invoices and P&L entries to departments
• Generating departmental Profit & Loss and balance sheets
• Department expense analysis and variance reports

Product Costing

• Creating raw materials and finished products
• Bill of materials for finished products
• Stock movement within an organisation
• Product costing and pricing
• Purchasing trends

Company Performance Analysis

• Historical variance analysis and adjustments
• Use of fixed asset register
• Period-end wizard
• Company performance report
• Departmental report
• Product report
• Project report

Financial Modelling

• Budgeting, forecasting, and investment appraisal models
• Payback period, NPV, IRR, and profitability index

Business Analysis

• Working capital ratio
• Quick ratio
• Earnings per share
• Debt to equity ratio
• Return on equity
• Top and bottom line
• Profit margins
• Asset turnover ratio
• Interest coverage ratio

Project Analysis

• Creating and defining projects in Sage
• Allocation of invoices to projects
• Project profitability and cost analysis