|
Provided by: Amplios Academy Financial Modeling Workshop 3 DayBudget Management |
 |
Certificate Program
Provided by Amplios Academy
Course Overview
Financial Modeling and Corporate Planning skills are now essential for both finance and non-finance professionals. The powerful functions available in Excel and other spreadsheets improve the quality of the decision support process far beyond those available from other methods. The Visual Basic (VBA) programming language built into Excel provides tools for simplifying the user interface to encourage participation in performance improvement programs by all personnel.
Whereas many employees are able to build simple models and to use macros, much potential benefit and management productivity improvement is left unrealized as the simple steps to the next level of improvement of the solutions developed are unknown.
In this course, participants learn the principles behind accounting, finance and statistics and how to use functions and macros to represent them in Excel. The VBA facility is then used to create forms and to develop customized functions.
For this workshop, participants are required to bring their own laptops.
Related Software Programs or Products: Microsoft Excel,VBA
Related Jobs or Careers: Finance Managers,Financial Analysts,Corporate Planners,Budgeting Officers,
|
|
||||||||||||||||||
Financial Modeling Workshop 3 Day
DAY 1
Fundamentals Refresher
> Accounting for non-Accountants
> Formal Logic and Truth Tables
> Philosophy of Economics
> Long-wave Macroeconomics
> Statistical Inference
> The dangers of Charting
> Crowd behavior in stock markets
Financial Modeling in Excel - 1
- Basics: The difference between Rules and Data
- Advanced Features
- Financial Analysis Functions
- Conditional Logic
- Building Formulas from Formulas
- When to stop using Excel and go to OLAP
Financial Modeling in Excel - 2
- Features of efficient and effective Excel models
- Analyzing and forecasting financial statements:
- Profit & Loss
- Balance Sheet
- Cash Flow
- Ratio Analysis
> Financial Planning and Equity Valuation
> Identifying the market drivers
DAY 2
Financial Modeling in Excel - 3
> The Cost of Capital for Shareholder Value Added
> Bond markets and prices
> Share prices modeling - short term and long term
> Options and Option Portfolios
Financial Modeling in VBA - 1
> Introduction to VBA in Excel
> The architecture of VBA and its essential components
> Subroutines and Functions
DAY 3
Financial Modeling in VBA - 2
> Choosing between investment alternatives
> Discounted Cash Flow, Net Present Value, Payback
> Financial Planning and Equity Valuation (review)
> Risk management
> Portfolio Management
Financial Modeling in VBA - 3
> Share prices modeling - short term and long term (review)
> Asset Pricing
> Binomial Option Pricing
> Application Management
> Maintaining the application built in Excel / VBA
> Documenting the application
> Corporate Governance - Cross checking models, independent proof, alarms
> Intellectual Property Protection
Fundamentals Refresher
> Accounting for non-Accountants
> Formal Logic and Truth Tables
> Philosophy of Economics
> Long-wave Macroeconomics
> Statistical Inference
> The dangers of Charting
> Crowd behavior in stock markets
Financial Modeling in Excel - 1
- Basics: The difference between Rules and Data
- Advanced Features
- Financial Analysis Functions
- Conditional Logic
- Building Formulas from Formulas
- When to stop using Excel and go to OLAP
Financial Modeling in Excel - 2
- Features of efficient and effective Excel models
- Analyzing and forecasting financial statements:
- Profit & Loss
- Balance Sheet
- Cash Flow
- Ratio Analysis
> Financial Planning and Equity Valuation
> Identifying the market drivers
DAY 2
Financial Modeling in Excel - 3
> The Cost of Capital for Shareholder Value Added
> Bond markets and prices
> Share prices modeling - short term and long term
> Options and Option Portfolios
Financial Modeling in VBA - 1
> Introduction to VBA in Excel
> The architecture of VBA and its essential components
> Subroutines and Functions
DAY 3
Financial Modeling in VBA - 2
> Choosing between investment alternatives
> Discounted Cash Flow, Net Present Value, Payback
> Financial Planning and Equity Valuation (review)
> Risk management
> Portfolio Management
Financial Modeling in VBA - 3
> Share prices modeling - short term and long term (review)
> Asset Pricing
> Binomial Option Pricing
> Application Management
> Maintaining the application built in Excel / VBA
> Documenting the application
> Corporate Governance - Cross checking models, independent proof, alarms
> Intellectual Property Protection
About The Training Provider: Amplios Academy
Amplios Academy - Amplios Academy is the management training unit of Amplios Consultants Pte Ltd, established in Singapore in the year 2000. Based on the experience of our founder, Wilson Fyffe, the company provides training and consulting services to assist our client to improve their performance by using the major management tools. Of particular concern is the provision of assistance to those in need during...
