Financial Modelling Fundamentals

An Essential Guide to Building Efficient Models in Excel

10-11 Sep 2014 at Melbourne, Australia

Banking, Finance, Investing, Accounting

Submit new post
Thank you for posting.
Share it:

Learn to create professional models via a structured example that teaches how to incorporate & structure reams of information. Learn what to analyse & how to display the results via charts, data tables & conditional formatting. Key Learning OutcomesBuild a case study model and develop a straight-forward approach that can be used for all your financial modelling projectsThe skeleton structure, table of contents, calculations and error check pagesCreating the time series, checks, assumption, calculations and outputsUnderstand the difference between the three primary financial statementsDiscover how to get the balance sheet to balance in secondsAvoid common mistakes and pitfalls in model designReview key functions and functionalities for financial modellingAppreciate risk _ Model sensitivities and scenarios, incorporating breakeven, what-if and payback analysisLearn to document, summarise and present resultsPick up tips for using your new skills so you dont forget back at workAbout the CourseStarting with a blank Excel canvas, this 2-day course develops a small, straightforward model which enables the method to be demonstrated readily and comprehensively.The aim of the course is to help participants understand the underlying factors that formulate a model, and how to think about the task of developing a model in the first place. Where do I start?Understanding financial statements and how they are integrated into a model for analysis is explained and illustrated, then followed by a gradual introduction of other elements that are useful for analysis.What to analyse and how to analyse based on step-by-step examples and good practice is explained.By the end of the course, participants will have built a full set of financial statements and will be able to repeat this process and apply it to their ownmodel developments.
Speakers :Liam Bastick