Practical Financial Modelling and Valuation

Programme Code: CRS-N-0046195 (Funding Validity Period: 16 May 2018 - 30 Sep 2020)

Overview

Financial modelling is a critical skill in business valuation for professionals working in corporate finance and investment. Modelling goes beyond number crunching and requires the ability to incorporate macroeconomic and business inputs into financial models. The output of these models are used in setting the stage for negotiations and decision making around buying or selling a business.

The Practical Financial Modelling and Valuation workshop aims to equip participants with the foundations of valuing a business, including hands-on practice using excel to build basic financial statements.

Participants will learn how to perform scenario analyses, structure discounted cash flow to derive the value of a business. The model developed in-class can be used as a basis for developing more advanced and bespoke models used for diverse industries.

Next Course Starts On16 Jan 2019 (Wed) See Full Schedule
Fee SGD1712.00* (as low as SGD193.60* after maximum funding) Learn more
Duration

2 days

Level
Basic
Venue

Singapore Management University

Learning Objectives
  • Understand the basic principles of financial modelling
  • Build a model based on the core financial statements
  • Learn to apply the different approaches to valuation
  • Simulate impact of corporate strategies on business valuation
  • Use financial modelling to support investment decision making

Topics/Structure

Underlying Principles to Modelling

Developing a financial model goes beyond simply putting numbers on a spreadsheet. It entails decision making at the management level and strategic thought processes involving the analysis of future performance of businesses.

 

Building Financial Models

It is important to acquire the necessary foundation and best practices for developing financial models. Learn to build the core elements of any financial model (P&L, balance sheet and cash flow statements).

 

Assessing Impact of Strategic Decisions

Carry out scenario and sensitivity analyses based on different business drivers. Overlay these decisions into the financial models, including equity/debt financing and adjusting revenue and cost drivers.

 

Using Valuation to Guide Negotiations and Decision Making

Know what are the common approaches to valuation (cost, market, and income) as well as their applications in market practices. Create visual discussion materials that can be used in negotiations to bridge valuation gaps and aid in decision making.

Who Should Attend

  • Financial and investment analysts
  • Investors, financial professionals involved in business and/or investment valuations
  • Fresh graduates and new entrants to the investment and corporate finance industry

Participants need to be proficient in using excel (basic mathematical operations) and have working knowledge of accounting and financial statements. A personal laptop with windows OS and Microsoft excel is also required. Admission to the programme is subject to approval.  

Assessment

Upon meeting the attendance requirement and passing the assessment, participants will receive a Certificate of Completion

Learning Activities

Classroom Training. The program adopts an interactive and practical oriented approach. Participants will gain hands-on practice using excel to build a financial model from scratch. 

 

 

Fees and Funding

Full Fee: S$1,712 per pax (incl GST)

Nett Fee payable after SkillsFuture Singapore (SSG) Funding:

  • S$513.60 (incl GST) for Singapore Citizens and Singapore Permanent Residents
  • S$193.60 (incl GST) for Singapore Citizens aged 40 years and above
  • S$193.60 (incl GST) for Singapore Citizens and Singapore Permanent Residents on Enhanced Training Support for SMEs (ETSS)
  • S$113.60 (incl GST) for Singaporeans on Workfare Training Support (WTS)

• All self-sponsored Singaporeans aged 25 and above can use their $500 SkillsFuture Credit to pay for the programme. Visit the SkillsFuture Credit website (www.skillsfuture.sg/credit) to select the programme.

• Mid-Career Enhanced Subsidy - Singaporeans aged 40 and above may enjoy subsidies up to 90% of the programme fee

• Workfare Training Support (WTS) - Singaporeans aged 35 and above (13 years and above for persons With disabilities) and earn not more than S$2,000 per month, may enjoy subsidies up to 95% of the programme fee.

• Enhanced Training Support for SMEs (ETSS) - SME-sponsored employees (Singaporean Citizens and PRs) may enjoy subsidies up to 90% of the programme fee. For more information, visit www.ssg.gov.sg/programmes-and-initiatives/training/enhanced-training-support-for-smes.html.

• Eligible organisations (excluding government entities) may apply for the absentee payroll funding via SkillsConnect at www.skillsconnect.gov.sg for Singaporean/permanent resident participants attending the programme during working hours. The absentee payroll funding is computed at 80% of hourly basic salary capped at $4.50 per hour or $7.50 per hour for SME or 95% of hourly basic salary for WTS. For more information, visit https://www.skillsconnect.gov.sg/sop/portal/e-Services/For%20Employers/AbsenteePayroll.jsp

Schedule

Start Date(s)
Intake Information

16 & 17 Jan 2019 (Wed & Thu) 

Program is held from 9am - 5pm

Speaker/Trainer Bio

Kenny Ng

Kenny is an Executive Director of IJK Capital Partners focusing on cross-border investment and advisory deals. Based out of Singapore and Shanghai, he also spent his time working on fundraising, deal evaluation and execution at one of the largest private equity growth funds. He has over 12 years of investment banking and corporate finance experience at BNP Paribas, Standard Chartered and KPMG Corporate Finance, executing numerous M&A and capital markets transactions in various sectors such as industrials, consumer, energy, etc. A banker by profession and engineering-trained, Kenny holds a Bachelor of Engineering in Computer Engineering from the National University of Singapore.

Policies

Share this course