Financial Analysis Modeling and Forecasting

The course is a hands-on workshop that applies MS Excel to model financial analysis and forecasting through different exercises and case studies.

By the end of the course, participants will be able to:

• Interpret organizational financial performance and position using financial ratios
• Analyze and advise on the health of the cash flow statement
• Evaluate future cash flows by utilizing Microsoft Excel time value of money functions
• Apply advanced MS Excel modeling tools and functions in financial projections models
• Build a financial forecasting model for the financial statements' projections

Financial controllers, analysts, finance and accounting managers, supervisors, and finance professionals who need to interpret and analyze financial statements and use them to create financial forecast models in their organizations.

• Understanding and performing financial analysis
• Performing vertical, horizontal, and trend analysis
• Financial forecasting
• Modeling financial statements
• Applying Excel functions and tools
• Building Dynamic Financial Models