Financial Modeling in Excel

Schedule

Thu Mar 13 2025 at 09:00 am to Fri Mar 14 2025 at 05:00 pm

UTC+08:00

Location

JW Marriott Hotel Kuala Lumpur | Kuala Lumpur, KL

Advertisement
The objective of this program is to provide knowledge and practical experience about the creation of comprehensive and flexible financial m
About this Event

The objective of this program is to provide knowledge and practical experience about the creation of comprehensive and flexible financial models used in financial planning and fundraising purposes.


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.


Overview


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.


Who should attend                          



  • All individuals who want to improve their financial modeling skills should attend this course
  • 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

Methodology                                                


The 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 objective is achieved.


We request you to please bring your laptop with Microsoft Excel installed to the class.


Trainer


All our trainers are carefully chosen by us and possess a rich and vast experience in the financial sector. This course conducted by an experienced training consultant having more than 16 years of industry experience with some of the world’s leading business institutions, specializing in corporate finance, investment banking, and private equity.


Course Content 


Module – 1


Setting up a financial model and building projections



  • Overview of best industry practices for financial modeling
  • Importance of historical information
  • Analysis of company and industry information
  • Steps for creating financial models
  • Proper presentation of various sheets and setting up the model input dashboard

Module – 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, modeling of historical ratios and trends
  • Shortlisting assumptions and applying adjustments
  • Applying various forecasting tools, etc

Module – 3


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 fundraising
  • Equity gap and funding

Module – 4


How to create working capital schedule



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

Module – 5


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

Module – 6


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

Module – 7


Establish scenario 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 critical pitfalls in the analysis

Module – 8


How to analyze the data



  • Data sorting and Data filtering
  • Creating, customizing Pivots Tables, advanced pivot tables, and analysis
  • V-LOOK UP and H-LOOK UP, Macros, and other analysis

Module – 9


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 multiple 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

Module – 10


Approaches to applying different valuation techniques in the model



  • Various 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 methods
  • Incorporate various adjustments to the publicly available versions of Company valuation


If you need further information, please visit www.riverstonetraining.com.sg or send mail at [email protected]


Riverstone – Corporate Training https://www.riverstonetraining.com.sg


Advertisement

Where is it happening?

JW Marriott Hotel Kuala Lumpur, 183 Jalan Bukit Bintang, Kuala Lumpur, Malaysia

Event Location & Nearby Stays:

Tickets

SGD 2054.56

Riverstone Training Pte Ltd

Host or Publisher Riverstone Training Pte Ltd

It's more fun with friends. Share with friends

Discover More Events in Kuala Lumpur

Tue Mar 18 2025 at 08:00 am (网页已关闭) 我想了解更多:全球华人启发大会 2025 Register your interest GCAC 2025

Mega Star Arena KL

BUSINESS CONFERENCES
Enterprise Risk Management
Tue Mar 18 2025 at 09:00 am Enterprise Risk Management

JW Marriott Hotel Kuala Lumpur

WORKSHOPS PARTIES
Experience the Power of the Alpha Level with the Silva Life System
Wed Mar 19 2025 at 09:00 am Experience the Power of the Alpha Level with the Silva Life System

Silva Method (M) Sdn. Bhd.

WORKSHOPS IT
Unlock Your Mind\u2019s Potential for Ultimate Self-Mastery
Wed Mar 19 2025 at 09:00 am Unlock Your Mind’s Potential for Ultimate Self-Mastery

B-10-1, Northpoint, Mid Valley City,

WORKSHOPS
Badminton Fit and Fabulous Buddies In Kuala Lumpur (Monday, Wednesday)
Mon Jan 09 2023 at 08:30 pm Badminton Fit and Fabulous Buddies In Kuala Lumpur (Monday, Wednesday)

Desa Petaling Sport Complex

SPORTS WORKSHOPS
Manager Management 1 Day workshop in Kuala Lumpur
Fri Mar 15 2024 at 09:00 am Manager Management 1 Day workshop in Kuala Lumpur

For venue details reach us at [email protected]

WORKSHOPS VIRTUAL
Leading Effective Teams 1 Day Effective workshop in Kuala Lumpur
Fri Mar 15 2024 at 09:00 am Leading Effective Teams 1 Day Effective workshop in Kuala Lumpur

For venue details reach us at [email protected]

WORKSHOPS VIRTUAL
Free Webinar: 2024 Melbourne Property Outlook ~ To Buy Or Rent In Melbourne
Mon Apr 01 2024 at 07:30 pm Free Webinar: 2024 Melbourne Property Outlook ~ To Buy Or Rent In Melbourne

Federal Territory of Kuala Lumpur

VIRTUAL WORKSHOPS
Outdoor Yoga - Kuala Lumpur
Sat May 04 2024 at 07:00 am Outdoor Yoga - Kuala Lumpur

Jalan Tasik Permaisuri 2

HEALTH-WELLNESS WORKSHOPS
Slime Workshop
Thu May 16 2024 at 10:00 am Slime Workshop

CREATIVESPACE.MY

WORKSHOPS KIDS
Outdoor Yoga - Kuala Lumpur
Sat Jun 01 2024 Outdoor Yoga - Kuala Lumpur

Jalan Tasik Permaisuri 1

SPORTS HEALTH-WELLNESS
Absolutely FREE Dance Classes, Salsa Bachata Kizomba Zouk & more
Sat Nov 16 2024 Absolutely FREE Dance Classes, Salsa Bachata Kizomba Zouk & more

Sky Lounge

PARTIES MEETUPS
Water Loss Asia 2024 - Conference and Workshop
Tue Nov 19 2024 at 09:30 am Water Loss Asia 2024 - Conference and Workshop

Royale Chulan Hotel

BUSINESS WORKSHOPS
Venture Capital Investing Masterclass
Wed Nov 20 2024 at 09:00 am Venture Capital Investing Masterclass

JW Marriott Hotel Kuala Lumpur

BUSINESS WORKSHOPS
Managing Corporate Treasury Risks
Wed Nov 20 2024 at 09:00 am Managing Corporate Treasury Risks

JW Marriott Hotel Kuala Lumpur

WORKSHOPS BUSINESS
Enhancing Cybersecurity Resilience
Thu Nov 21 2024 at 03:00 am Enhancing Cybersecurity Resilience

M Resort & Hotel Kuala Lumpur

WORKSHOPS BUSINESS
A Practical Guide to HR FOR BEGINNERS
Thu Nov 21 2024 at 09:00 am A Practical Guide to HR FOR BEGINNERS

Eastin Hotel Petaling Jaya

WORKSHOPS
CPD Seminar - AI Driven Innovations in Real Estate Branding & Marketing
Thu Nov 21 2024 at 09:00 am CPD Seminar - AI Driven Innovations in Real Estate Branding & Marketing

Bukit Jalil Golf & Country Resort

WORKSHOPS STORYTELLING
Business Expansion into the UK: What Should Malaysian Enterprises Consider?
Thu Nov 21 2024 at 03:00 pm Business Expansion into the UK: What Should Malaysian Enterprises Consider?

Hilton Kuala Lumpur

BUSINESS WORKSHOPS
Paradigm Shift+ | You are a UX designer for neurodiversity
Thu Nov 21 2024 at 06:00 pm Paradigm Shift+ | You are a UX designer for neurodiversity

Federal Territory of Kuala Lumpur

WORKSHOPS ART

What's Happening Next in Kuala Lumpur?

Discover Kuala Lumpur Events