Finance Modeling

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 practice 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.

Adults

Certificate Awarded

Financial calculations:

Applications Time value of money:

• Present Value Future Value and Net Present Value -NPV
• Internal Rate of Return -IRR- and Multiple IRR -MIRR
• Using XNPV and XIRR
• Amortization of loan schedule
• Effective yields and returns
• Corporate financial analysis
• Profit and loss versus balance sheet analysis
• Vertical trend and horizontal analysis
• Liquidity
• Current quick and cash ratios
• Asset management and activity
• AR inventory and AP turnover and Asset turn

The Accountants & Auditors Association (AAA) is the national accountancy body of the United Arab Emirates. We are a not-for-profit organization and have Undertaken Key strategic initiatives to develop the accountancy and finance profession in the country. The Association was established in 1997 through a federal mandate with the key objective of building capacity of the national accountancy and finance profession in line with best global practices and standard. We actively work with related authorities to propose the accounting and auditing standards in the country , suggest new regulatory standards for the profession. We deploy the highest standards of ethical and professional conduct to our members.

AAA's mission is to serve our members, the profession and society. We support the Ministry of Economy ‘s vision of achieving 100 professionally qualified UAE nationals in the field of accounting practice by the year 2021. Our core values are: credibility and transparency, professionalism, continuing professional development, effective relationship and partnership management, and community & public service.