Price: USD 137
- Duration: 5 Hours
Course details
When done well, Financial Models are powerful tools that can be used to help organisations make good business decisions. But building robust and relevant financial models is not always easy.
This course provides a solid introduction to financial modelling - exploring why and how they are used by businesses, and how the standards (FAST) that exist can ensure that the financial models you develop work for your businesses. It also looks in detail at how the models are set-up, how concept diagrams can be useful and the different considerations that feed into building calculations.
This course will enable you to:
- Understand what constitutes a financial model, why businesses use models and some of the inherent limitations
- Recognise what standards are, why they are used and examples of commonly accepted standards
- Establish how to set up and structure input sheets, working sheets and output sheets
- Understand how to make concept diagrams
- Learn the best practice calculation block structure and key excel functions that are commonly used
Learning Outcomes
What is a Financial Model?
- What is a financial model?
- Why do businesses use models?
- How do we do financial modelling?
- What do we use models for?
- What skills do I need to do financial modelling?
- Where can things go wrong?
Standards
- What are standards?
- Why do we use standards?
- When should I use a standard?
- Why is FAST significant?
- What are the key characteristics of FAST?
Setting up a Model
- How do I set up a model?
- Why have a standard structure for each model?
- What goes on the input sheet?
- What goes on the working sheet?
- What goes on the output sheet?
- What is the standard recommended format for each sheet?
Concepts Diagrams
- What are concept diagrams?
- Why use concept diagrams?
- What am I trying to model?
- When should I use concept diagrams?
- How are concept diagrams used?
Building a Calculation
- What are we trying to model?
- What are the ingredients?
- How shall I lay out the calculation block?
- What are the operators I could use?
- What functions are commonly used in financial modelling?
- What Excel shortcuts can I use?
- What other FAST principles should I use to build the block?
- How can I produce a graph to show the balance?
Updated on 08 November, 2015
About Institute of Chartered Accountants of Ireland
Chartered Accountants Ireland (The Institute) is a membership body representing 23,000 influential members throughout the globe. their role is to educate, represent and support their members. their members work in senior positions in practice and industry. they are committed to restoring confidence at every level of the economy. they work with governments and businesses to raise awareness of the importance of sound financial advice.
Chartered Accountants Ireland was established as the Institute of Chartered Accountants in Ireland by Royal Charter in 1888. Its activities and those of its members are governed by its Bye-Laws and by Rules relating to professional and ethical conduct. These provisions are contained in the Handbook which is available to all members.
Chartered Accountants Ireland is governed by a Council and it is responsible for determining policy and monitoring its implementation. Council is lead by the Officer Group and supported by the Management Team and staff. A number of committees with voluntary member involvement also play a key role.
See all Institute of Chartered Accountants of Ireland courses Are you from Institute of Chartered Accountants of Ireland ? Claim your course!
Courses you can instantly connect with... Do an online course on Accounting starting now.
- Accounting Diploma Brentwood Open Learning CollegeUSD 74
USD 820Duration: 1 To 260 Hours - Cost Control Process and Management StudyHubUSD 24
USD 480Duration: Upto 2 Hours
