- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
431 Financial Modelling & Analysis courses in Cardiff delivered Online
Best Practice Financial Modelling
By F1F9 Academy
Building an Excel spreadsheet model that forecast profits and cash flows across a regular series of future dates is a common requirement for the financial analyst and professional modeller. Modellers undertaking such assignments require sound commercial and accounting knowledge, and need to make important design and construction decisions in relation to their models. Modellers using the FAST Standard will have made the task considerably easier for themselves by following a standard approach that is recognised by others. Financial Statement Modelling reminds you of the basic construction and design skills you need and applies them to the complexities that arise from a case study - in this instance the acquisition of a concession to run an airport over a 30 year period. The financial statements - income statement, balance sheet and cash flow statement - form the core content around which the course fits. In addition, you will cover valuation techniques, sensitivities and scenario managers. On completing the course and its assessments, you will be in a position to start building models that are FAST compliant and meet all the requirements of a financial statement forecast model. Videos are ordered in such a way as to build up your learning in layers. By all means ignore the videos where you have the knowledge already. Here is a quick guide to the different categories: QUICK REMINDERS - knowledge that you should have picked up from our introductory courses. Quick Reminder videos are there just in case you need them. HOW TO - knowledge that is specific to Excel and - in particular - Excel functions. How To videos are there to build up your spreadsheet engineering abilities. ROUGH WORK - knowledge that is specific to the case study being modelled. In Rough Work videos look out for heavy use of placeholders and template coding. CASE STUDY - in Case Study videos, an experienced FAST modeller will model the case study solution. There is no audio accompaniment to Case Study videos. ANALYSIS - knowledge that is specific to reviewing models and obtaining insight. In Analysis videos expect lots of charting and lots of talking. To get started, please work through Excel Proficiency Skills and then Model Construction Skills if you are new to F1F9 training. Then you'll be ready to start the Financial Statement Modelling sub-courses. Do remember we're here to support you - you can use the "Discuss" tab to post in the forums, the "Feedback" button to send us questions, or simply email us at support@f1f9.com.
Online Options
Show all 431The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Excel Skills for Financial Modelling
By Capital City Training & Consulting Ltd
Enroll today and gain the Excel modelling skills needed for corporate finance roles, investment analysis, business planning, and data-driven decision making. 2+ Hours of Video 4+ Hours to Complete10+ Interactive Exercises1 Recognised Certificate Course Overview Our comprehensive Excel Financial Modelling program teaches the essential Excel skills needed to build flexible and dynamic financial models. Financial modelling is a vital skill for business analysts, investment bankers, corporate financiers, and other finance professionals. Through step-by-step video lessons and over 30 hands-on exercises, this course will teach you Excel best practices to analyse financial data, forecast business performance, and evaluate strategic decisions. The self-paced online format is ideal for busy professionals looking to expand their financial analysis skillset. With over 7 hours of content, our program covers everything you need to become an expert in using Excel to build financial models. “I was previously unsure of all the financial jargon and concepts, now I feel I have taken steps towards getting the big picture of finance. I really liked the Excel web integration!” Rachel Crawford Course Highlights Time Value of Money Principles and Calculations Net Present Value and Internal Rate of Return Metrics Calculating Averages and Statistical Measures Understanding and Measuring Financial Risk 16+ Practice Exercises and Applications Certificate Upon Successful Course Completion
