Categories: Business Technology CoursesLearning

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