MODELING FOR FINANCIAL REPORTING AND ANALYSIS

Overview

The global business challenges integrated with the challenges in information technology requires astute managers with the knowledge and skills to advance the profitability and growth of any organization.

Project evaluation/finance and investment decision could be a mirage for managers without the required analytical skills. When looking at any financial opportunity, the ability to perform accurate and realistic analysis is imperative

KEY LEARNING OUTCOME

At the end of the course, participants should be able to:

• Understand the dos and don’ts in Building a Financial Model using Excel
• Prepare Financial Models using Excel systematically
• Leverage on some Excel Functions to enhance the Financial Models
• Prepare Financial Forecast by years with detail supporting worksheets for future changes

COURSE OUTLINE

• Introduction to MS-Excel
• Introduction to Advanced spread sheet
• Financial Models
• Impact of source of capital on model outcomes
• Ratio Analysis
• Risk Scenarios
• Enhancing The Model With More Creative Excel Functions
• Understand The Business Perspective And How To Effectively Use The Financial Model To Support Management For Better Decision Making
• Cash Flow Projections
• Fixed Assets
• Chart
• Supporting Work Sheets
• Macro Recording

TARGET PARTICIPANTS

• Equity and Credit analyst
• Research staff
• Financial analyst
• Investment analyst
• Stock Brokers
• Bankers
• Funds and Portfolio managers
• Trading and Risk Managers
• Accountants
• Pension Fund Managers
• Investor

COURSE DURATION: 3 Days