10times
logo
5.0/5

1 ratings

Conference

Financial Modeling in Excel

16 - 17 Apr 2020 Add To Calendar
JW Marriott, Kuala Lumpur, Malaysia

About Users 86 Reviews Exhibitors Photos 2 Speakers Travel Deals

"Best Financial Modeling Training in Kuala Lumpur"
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 the best decision for their company.


Timings

9:00 AM - 5:00 AM (General)

Entry Fees

Paid Ticket Starts from 1799 SGD View Details

Participants

500 - 1000
Delegates

10 - 50 Exhibitors Estimated Count

Category & Type

Conference
Education & Training
Banking & Finance

Editions

16 - 17 Apr 2020 Interested
23 - 24 Sep 2019
10 - 11 Jun 2019
08 - 09 Apr 2019
29 - 30 Jan 2019
08 - 09 Oct 2018
06 - 07 Aug 2018
View More

Frequency One-time

Official Links

WebsiteContacts


Report Error
Claim this event

Organizer

Logo Send Stall Book Request

Riverstone Training Singapore

Top Rated 70 Total Events / 54 Upcoming Events
+ Add me as user

User Community [ Users who have shown interest for this Event ]

Tan Chew Boon

Tan Chew Boon

Consultant at Self employed

Kuala Lumpur, Malaysia
Hanifah Tri Kinanti

Hanifah Tri Kinanti

Student at Jenderal Soedirman University

Purwokerto, Indonesia
Rizal

Rizal

Senior Executive at Megajana

Cyberjaya, Malaysia
Ahmad

Ahmad

Student at Iukl

Kuala Lumpur, Malaysia
Michael

Michael

Medan, Indonesia
Prem Moktan

Prem Moktan

CFO at Bankk of Bhutan

Thimphu, Bhutan
Dr Haji Arriffin Mansor

Dr Haji Arriffin Mansor

chief consultant at ABM consult

Kuala Lumpur, Malaysia

Audience Profile


Student
Manager
Physician
CEO
Accountant

Audience Spread

loading...
62

Write a Review

Add Your Review
gallery
gallery
User Rating

5.0/5

1 Ratings
5
1
4
3
2
1

User Reviews

Schedule & Agenda

Thu, 16 Apr 09:00 AM - 09:30 AMSession 1

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


Thu, 16 Apr 09:30 AM - 10:30 AMSession 2

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, modelling of historical ratios
  • Short listing assumptions and applying adjustments
  • Applying various forecasting tools, etc

Thu, 16 Apr 10:30 AM - 11:00 AMSession 3

COFFEE BREAK

Thu, 16 Apr 11:00 AM - 12:00 PMSession 4

Importance of key schedules and their application

  • Fixed assets and depreciation
  • Preparation of debt and interest
  • Taxation and Equity fund raising

Thu, 16 Apr 12:00 PM - 01:00 PMSession 5

LUNCH BREAK

Thu, 16 Apr 01:00 PM - 02:00 PMSession 6 Session

How to create working capital schedule

  • Components of cash and non-cash working capital
  • Working capital ratios and their interpretation
  • Forecasting working capital requirements


Thu, 16 Apr 02:00 PM - 03:00 PMSession 7 Session

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


Thu, 16 Apr 03:00 PM - 03:30 PMSession 8 Session

COFFEE BREAK

Thu, 16 Apr 03:30 PM - 05:00 PMSession 9 Session

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

Fri, 17 Apr 09:00 AM - 10:30 AMSession 1 Session

How to analyze the data

  • Use of data for sensitivity analysis
  • 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
  • Calculation of WACC

Fri, 17 Apr 10:30 AM - 11:00 AMSession 2 Session

COFFEE BREAK

Fri, 17 Apr 11:00 AM - 12:00 PMSession 3 Session

Q&A on Modelling

Fri, 17 Apr 12:00 PM - 01:00 PMSession 4 Session

LUNCH BREAK

Fri, 17 Apr 01:00 PM - 02:00 PMSession 5 Session

Approaches to apply different valuation techniques in the model

  • Introduction to Business Valuation
  • Various types of valuation methods and their applicability for different industries and companies
  • Approach to Asset Value vs. Equity Value
  • Intrinsic valuation, Book Value and other methods
  • Discounted Cash Flow valuation and different multiples based methodologies
  • Importance of terminal valuation
  • Understanding of PV, FCFF, FCFE, UFCF, LFCF, Terminal Value
  • How to factor size and illiquidity discount in the final valuation
  • Incorporate various adjustments to the publicly available versions of Company valuation and Key pitfalls

Fri, 17 Apr 02:00 PM - 03:00 PMSession 6 Session

Valuation - Relative and Multiples based method

  • Process of valuation based on comparative multiples - Compilation, adjustments and rationalization
  • How to calculate and apply key multiples for valuation - Price Earning multiple, Price to Book multiple, Enterprise value to EBIDTA, EV/FCF, FCF/BV, EV/EBITDA, EV/Subscriber, EV/EBITDAR, EV/Capacity etc
  • How to choose comparable companies and past transaction
  • Key adjustments in compilation and analyzing precedent transactions
  • Application of control or leadership premium, synergies, cash flows, illiquidity and minority discounts, etc

Fri, 17 Apr 03:30 PM - 04:00 PMSession 7 Session

COFFEE BREAK

Fri, 17 Apr 04:00 PM - 05:00 PMSession 8 Session

Approaches to apply different valuation techniques in the model

  • 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

Visitor Ticket Price Buy Now

1799 SGDParticipant
3.139003 101.686855

Venue Map & Directions

map of JW Marriott

JW Marriott

183 Jalan Bukit Bintang, 55100 Kuala Lumpur
Malaysia

Featured Hotels

More Hotels