Skip Main Navigation
Eventbrite
Browse Events
Organize
Help
Log InSign Up
Menu
Page Content
This event has ended.
Financial Modeling in Excel

Actions Panel

Dec 13

Financial Modeling in Excel

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

By Riverstone Training Pte Ltd

When and where

Date and time

Tue, Dec 13, 2022, 9:00 AM – Wed, Dec 14, 2022, 5:00 PM WIB

Location

Pullman Jakarta Indonesia Thamrin CBD No 59 Jalan M.H. Thamrin Jakarta, Daerah Khusus Ibukota Jakarta 10350 Indonesia

Map and directions

How to get there

Refund Policy

No Refunds

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 info@riverstonetraining.com.sg

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

Tags

  • Indonesia Events
  • DKI Jakarta Events
  • Things to do in Jakarta
  • Jakarta Classes
  • Jakarta Business Classes
  • #course
  • #financialmodelling
  • #professional_development
  • #finance_training
  • #excel_course
  • #financial_training
  • #excel_training
Event ended

Financial Modeling in Excel


Follow this organizer to stay informed on future events

Riverstone Training Pte Ltd

Event creator

Events you might like

  • Financial Modeling & Analysis of Renewables Project

    Financial Modeling & Analysis of Renewables Project
    Financial Modeling & Analysis of Renewables Project

    Mon, Mar 20, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $3,698.27 - $4,006.37
  • Project Finance Modeling

    Project Finance Modeling
    Project Finance Modeling

    Wed, Sep 20, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $2,772.95
  • Project Finance Modeling

    Project Finance Modeling
    Project Finance Modeling

    Mon, Dec 4, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $2,772.95
  • Financial Modeling in Excel

    Financial Modeling in Excel
    Financial Modeling in Excel

    Thu, Feb 23, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $2,054.05
  • Project Finance Modeling

    Project Finance Modeling
    Project Finance Modeling

    Wed, Feb 15, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $2,772.95
  • Project Finance Modeling

    Project Finance Modeling
    Project Finance Modeling

    Wed, May 10, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $2,772.95
  • Financial Modeling in Excel

    Financial Modeling in Excel
    Financial Modeling in Excel

    Mon, Jul 3, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $2,054.05
  • Real Estate Modeling and Analysis

    Real Estate Modeling and Analysis
    Real Estate Modeling and Analysis

    Mon, Mar 13, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $2,772.95
  • Advanced Financial Analysis and Management

    Advanced Financial Analysis and Management
    Advanced Financial Analysis and Management

    Mon, Jun 19, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $2,772.95
  • Advanced Financial Analysis and Management

    Advanced Financial Analysis and Management
    Advanced Financial Analysis and Management

    Wed, Mar 15, 9:00 AM
    Pullman Jakarta Indonesia Thamrin CBD • Kec. Menteng, Daerah Khusus Ibukota Jakarta
    $2,772.95

Site Navigation

Use Eventbrite

  • Create Events
  • Pricing
  • Eventbrite Boost
  • Eventbrite Mobile Ticket App
  • Eventbrite Check-In App
  • Eventbrite App Marketplace
  • Event Registration Software
  • Content Standards
  • FAQs
  • Sitemap

Plan events

  • Sell Tickets Online
  • Event Planning
  • Sell Concert Tickets Online
  • Event Payment System
  • Solutions for Professional Services
  • Event Management Software
  • Community Engagement
  • Virtual Events Platform
  • QR Codes for Event Check-In
  • Post your event online

Find events

  • Browse Jakarta Events
  • Get the Eventbrite App

Connect with us

  • Report This Event
  • Help Center
  • Terms
  • Privacy
  • CA Privacy Notice
  • Accessibility
  • Community Guidelines
Eventbrite + Ticketfly

© 2023 Eventbrite