Course details
Course Overview:Finance modeling is crucial for investment decisions. This course will acquaint you with methods used to prepare and build financial models to cater to different types of investment decisions.
You get an opportunity to practise not only the accounting methods used in financial modeling such as time value, present value, WACC Weighted Average Cost of Capital; we also incorporate the excel techniques using pivot tables and VBA Programming used to create flexible, dynamic and professional models.
This an intensive 3 days workshop, which starts with basic and progresses in a logical step by step manner to evolve deeper understanding of developing a professional finance model. This program involves practical financial markets issues to emphasize some important financial concepts that will assist in building vigorous models. Participants will need some professional modeling and vba programming knowledge in excel.
Key Takeaways:
- Understand the accounting concepts of Finance Modeling
- Learn to make investment decision in practical financial market scenario
- Learn the tools used to build models that are less time and effort consuming
- Learn the application of Pivot Tables in Finance Modeling
- Learn the application of VBA Programming in Finance Modeling
- Certification of Completion awarded by AAA (UAE Government Body)
- Prepare effective financial statement models using Excel
- Determine value of project using free cash flow techniques
- Perform capital budgeting analysis using money value concepts, cost of capital calculations
- Stress test risk of developed financial model
performing sensitivity analysis - Review scenario analysis and recognize special
modeling and valuation considerations best
practices
Eligibility / Requirements
- Basic Accounting Knowledge
- Basic MS Office Knowledge specially Excel
- Secondary Qualification
Job roles this course is suitable for:
Accounting and Finance Professional , Finance Analysts , Venture Capitalists , Credit Analysts , Portfolio Manager , RISK MANAGER , Investment Banker , Government Finance Official , Investment decision making staff , AccountantCourse Location
About Accountants and Auditors Association
Accountants & Auditors Association (AAA) is the national accountancy body of the United Arab Emirates.The Association was established in 1997 through a federal mandate with the key objective of building capacity of the national accountancy and finance profession.
AAA work with authorities and suggests new regulatory standards for the profession.
AAA's Mission is to serve our members, the Profession and Society.
Strategic Partner
The UAE Accountants and Auditors Association (AAA) and the Association of Chartered Certitifed Accountants (ACCA), the global body for professional accountants, have signed a strategic partnership agreement to enhance the finance sector in the UAE by offering the UAE Chartered Accountant (UAECA) Qualification.
The new national chartered accountant qualification of UAE is based on the ACCA Qualification. The exciting opportunity allows you to gain an accountancy qualification which is both nationally and internationall recognized, awarded by two prestigious professional accountancy bodies and gain membership of both AAA and ACCA. See all Accountants and Auditors Association courses
- Financial analysis Level 5 Course LineAED 88
AED 1,763Duration: Upto 6 Hours - Financial Analysis John AcademyAED 90Duration: 4 To 5 Hours