This course is suitable for anyone new to Financial Modelling.
Unit 1 – Setting up a cop
Unit 2 – Good Excel practice and circularity
Unit 3 – Entering historical data and simplifying the balance sheet
Unit 4 – Income statement – above the line
Unit 5 – Income statement – below the line
Unit 6 – Balance sheet accounts that don’t change
Unit 7 – Balance sheet – calculations for PP&E and retained profit
Unit 8 – Balance sheet – operating working capital
Unit 9 – Balance sheet – long-term debt, ‘other’ assets & liabilities
Unit 10 – Balance and joint ventures
Unit 11 – Non-controlling interests
Unit 12 – Cash flow statement – operating cash flows
Unit 13 – Investing cash flows and financing cash flows
Unit 14 – Balancing the balance sheet
Unit 15 – Cash available to repay debt
Unit 16 – Adding a revolving facility
Unit 17 – Interest calculations
Unit 18 – Circularity switch
Unit 19 – Fixed and variable costs
Unit 20 – Scenario analysis
Unit 21 – Ratio analysis
We are thought leaders in instructional and learning journey design and holistic solution architects. We have extensive finance and investments experience combined with skills application to deliver performance improving results. We develop immersive learning environments that maximize time to productivity, support talent retention and added value to improving quality of hires.
We are focused on mining the embedded organisational intellectual capital for the benefit of the next generation. We create and curate best in class practice gathered from our experience with the leading financial institutions. We design our programmes with the end in mind – what results are you trying to achieve with this intervention? What metrics will we set ourselves to achieve that?
Quality and innovation, using current market and industry best practices, have made us a trusted partner in delivering dynamic and motivating training for the financial and capital markets. Our programmes are generation proof and responsive to evolving learner needs and styles. Our solutions use a multi-stakeholder engagement strategy that expands beyond relationships between the learner and learning provider. We create connections with managers, peers and the wider business to drive impactful return on investment..
"*" indicates required fields
The team are so friendly and pleasant to work with, everyone is very professional and keen to help us. Building a relationship over the past couple of years helps us to feel like the Alpha team are even more able to understand our needs and provide more proactive solutions.
