« 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 ×
cinema
model building
94655
Views
16/05/2020 Last update