Financial Modeling in Excel

« All Events
Financial Modeling in Excel
14 May - 15 May 2020
Event Navigation
«
Enterprise Risk Management
Project Finance Modelling
»
Start Date
May 14th
End Date
May 15th
Location
Singapore
Brochure
Download
The objective of Financial Modeling in Excel program is to provide knowledge and practical experience about the creation of comprehensive and flexible financial models that can be used in financial planning and fund raising purposes.
+ Google Calendar
+ iCal Export
Overview
Who Should attend
Methodology & Trainer
Agenda
The participants will gain insights into the step-by-step process of creating financial models using Microsoft Excel, putting checks and audits and finally analyzing the same.
This course will equip all participants with various tools to aid in complex business decision making by incorporating multiple factors operating in the dynamic business environment. At the end of the course, each participant will be able to create a financial model independently and carry out analysis to take best decision for their company.
All individuals who want to improve their financial modeling skills should attend this course.
Analysts/ Finance professionals like CPA, CFA, MBA, other graduates etc
Middle to senior managers from different industries
All professionals who want to deal or currently deal with financial modeling in their company
Consultants, advisors and other professionals who wish to improve their modeling skills
Non-theoretical methodology which includes interactive discussions, case studies, and assignments to understand the concepts and their applicability. As a policy, we limit the class size to 15 participants so that we can provide attention to each participant and ensure their individual objective is achieved.
We request you to please bring your laptop with Microsoft Excel installed to the class.
This course will be conducted by an experienced training consultant having more than 15 years of industry experience with some of the world’s leading financial institutions, specializing in corporate finance, investment banking and private equity.
Setting up a financial model and building projections
Overview of best industry practices for financial modeling
Importance of historic information
Analysis of company and industry information
Steps for creating financial models
Proper presentation of various sheets and setting up the model input dashboard
Preparation of Income statement, cash flow statements and balance sheet
Analysis of industry assumptions and their rationale for revenues & costs, assets and liabilities’ assumptions – operating cost, capex, leverage, modeling of historical ratios and trends
Short listing assumptions and applying adjustments
Applying various forecasting tools, etc
Importance of key schedules and their application
Working capital schedule
Fixed assets and depreciation
Schedule of amortization of intangible assets
Preparation of debt and interest
Taxation
Equity fund raising
Equity gap and funding
Importance of key schedules and their application
Components of cash and non-cash working capital
Working capital ratios and their interpretation
Forecasting working capital requirements
How to create Capex and funding schedules including multiple debts
Equity and debt fund raising and repayment structure
Debt waterfall mechanism
Checking debt repayment ratios, leverage and covenants
Integration of income statement, balance sheet and cash flow statement
Industry practices on handling exceptions
Integration of Cash Flows, Income Statement and Balance Sheet
How to handle Circular References in financial modeling
Establish scenarios and sensitivity analysis
Use of data for sensitivity analysis
Importance of scenario manager
Identifying suitable scenarios and sensitivities and their impact on financial analysis
Managing key pitfalls in the analysis
How to analyse the data
Data sorting and Data filtering
Creating, customizing Pivots Tables, advanced pivot tables and analysis
V-LOOK UP and H-LOOK UP, Macros, Goal Seek and other analysis
Solver function and its uses
How to apply different financial analysis techniques on the model
Importance of PV, NPV and IRR and their link with company valuation
How to analysis various capital budgeting decisions
Calculation of various ratios
Calculate the weighted average cost of capital using capital asset pricing model (CAPM)
Calculation of WACC
Investment and exit analysis – equity IRR, project IRR etc
Approaches to apply different valuation techniques in the model
Different methods of valuation – DCF, Multiples, comparables etc
Discounted Cash Flow valuation and different multiples based methodologies
Importance of terminal valuation
Current industry practices followed in company valuation using single or multiple methodologies
How to factor size and illiquidity discount in the final valuation
Incorporate various adjustments to the publicly available versions of company valuation
Related Events
Financial Modeling in Excel
Apr 16th
-
Apr 17th
|
Recurring Event
(See all)
One event on June 10, 2019 at 12:00am
One event on September 23, 2019 at 12:00am
One event on January 13, 2020 at 12:00am
One event on April 16, 2020 at 12:00am
Kuala Lumpur
Project Finance Modelling
Apr 1st
-
Apr 3rd
|
Recurring Event
(See all)
One event on April 24, 2019 at 12:00am
One event on October 7, 2019 at 12:00am
One event on January 29, 2020 at 12:00am
One event on April 1, 2020 at 12:00am
One event on October 29, 2019 at 12:00am
Jakarta
Financial Modeling in Excel
Mar 23rd
-
Mar 24th
|
Recurring Event
(See all)
One event on October 3, 2018 at 12:00am
One event on March 11, 2019 at 12:00am
One event on March 11, 2019 at 12:00am
One event on July 15, 2019 at 12:00am
One event on October 3, 2019 at 12:00am
One event on March 23, 2020 at 12:00am
One event on June 8, 2020 at 12:00am
Jakarta
Event Navigation
«
Enterprise Risk Management
Project Finance Modelling
»
To register kindly enter the participants details below or download the Brochure and fill out the form and send it to
info@riverstonetraining.com.sg
Enter Number of Participants:
Quantity
Unlimited
available
SGD
1,799.00
SGD
1,599.00
Please fill in all required fields
Enroll Now
Register and pay 30 days before and get early bird discount
Register 3 or more and get additional group discount
You must have JavaScript activated to purchase tickets. Please enable JavaScript in your browser.
Your Name (*)
Your Email (*)
Your Phone (*)
Country (*)
By proceeding you are agreeing to our
Terms & Conditions
.
Close ×