- مدة الدورة التدريبية: 5 Hours
تفاصيل الدورة
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?
نبذة عن معهد Institute of Chartered Accountants of Ireland
- Accounting Diploma Brentwood Open Learning College74 USD
820 USDمدة الدورة التدريبية: 1 To 260 Hours - Certified Credit Risk Manager Vskills41 USD
98 USDمدة الدورة التدريبية: 1 To 2 Months