Description
OVERVIEW - Updated October 2021. Financial Modeling is an essential skill for accounting and finance professional. It is very much in demand in the job market and is highly valued by employers. Our Financial Modeling training takes you from basics to professional level. This sixteen hours training is based on practical exercisesThe course focuses 40% on honing the participants MS Excel skills and 60% focus on application of MS Excel in Accounting and FinanceDETAILED CONTENT1. Introduction to Excel2. Useful tips and tools for your work in Excel3. Keyboard shortcuts in Excel4. Excel's key functions and functionalities made easy5. Update! SUMIFS6. Financial functions in Excel7. Microsoft Excel's Pivot Tables8. Building a complete P & L in Excel - Case Study9. Introduction to Excel charts10. Profit and Loss - Case Study11. Statement of Financial Position - Case Study12. Statement of Cash Flows - Case Study13. Financial modeling fundamentals14. Introduction to Company Valuation and Introduction to Mergers & Acquisitions15. Learn how to build a Discounted Cash Flow model in Excel - NPV and IRR16. Investment Appraisal - Case Study17. Business Valuation - Case Study18. Capital Budgeting - The theory19. Capital Budgeting - Case Study20. Impact of interest rates and exchange rates on NPV21. Sensitivity Analysis in Capital BudgetingPREREQUISITES1. Participants are expected to have basic knowledge of MS Excel. This could be measured as an MS Excel user for more than one year.2. Basic knowledge of financial accounting. 3. Microsoft Office 2013 or later installed on your computer.
