Price: USD 137
- Duration: 5 Hours
Course details
Every financial model is built on the same foundations: an understanding of its purpose, who it is for, and its scope. This course explains how to set up the Excel spreadsheet and complete the initial steps of building a financial model, structuring calculations, and looking into costs and revenues, time periods, cash balances and reporting.
This course will enable you to:
- Set up and build a comprehensive financial model
- Calculate costs and revenues
- Decide which time periods you need to use and when and where to use flags
- Create understandable and useful reports
Learning Outcomes
Setting up a Financial Model
- Who uses a financial model?
- How should I set up a financial model?
- What are the MS Excel settings for financial model build?
- What should be included in a template?
- How should I incorporate FAST principles?
Costs and Revenues
- What are the different ingredients required to calculate the operating costs?
- What would the concept diagram look like?
- How do I build a calculation that I can use to quickly model the operating costs?
- What would be different in the calculation on the revenue?
- How do I build a calculation to quickly model the revenue?
Time Periods
- What time periods should I use?
- What do I need to know about flags?
- Which ingredients are required to calculate the forecast period flag?
Cash Balances
- Why is the cash balance particularly important?
- What is a “balance corkscrew”?
- What should I know about interest?
- How is interest calculated?
Reporting
- What will the recipient want from the summary report?
- Should I use the same rules for building output sheets?
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 - 60 Minutes to Fundamental Accounting Skills Course CentralUSD 23
USD 180Duration: Upto 2 Hours
