|
Provided by: Amplios Academy Financial Modeling Workshop 2 DayBudget Management |
 |
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.
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,
|
|
||||||||||||||||
Certificate Program
Provided by Amplios Academy
- T asked: Hi, i have a client looking for finance for non finance workshop for thier staffs. This is for the banking industry. this project is in Asia Pacific and it would be a day workshop. I am looking for a profesional trainer that has more than years of experience. Please do get back to me asap. Thank you.
- T asked: Greetings, Do you provide or know anyone that can provide funding to travel to your country in order to attend such a course. I would love to attend..
- J asked: when and how much the fee? tks
- J asked: I want to know the price, date and venue.
- I asked: interested to participate in the program.
- T asked: Sir, Groups of enthusiastice finance and budgeting officers wanted to attend your captioned subject. I want to contact for more information.
- I asked: Please let me know the fee and if any group discount is available that detail.
- D asked: May I ask how much is the training cost per pax? Thanks!
- H asked: i can not find the training schedule on the site.
- R asked: I would like to receive moe detailed info on the content of the course: . does the course cover financial modelling? . does the course cover budget management? etc. Thanks,
- S asked: When is the next course?
- asked: Location of the Workshop
Financial Modeling Workshop 2 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
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
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 since the...
