Zero To Pro in Microsoft Excel: Financial Modeling and Valuation (Advanced) - SkillsFuture Approved - 1 Day

Course Code: CRS-N0044134

Course Overview

This 1-day Microsoft Excel course is suitable for individuals with non-finance backgrounds to learn industry standard valuation methods for investments. Through this course, you will have a basic understanding of how valuation models and projections are built on.

The course will start off with an introduction to the different valuation methodologies, and then to an overview of the accounting 3FS and its significance. A good accounting statement, together with advanced excel knowledge, will enable individuals to make informed decisions before investing.

After an overview of the accounting, the programme will go hands-on with students constructing various valuation models from scratch.

By the end of the course, attendees will be expected to know how to build a discounted cash flow model, and develop other valuation models to support their valuation. This will allow them to be equipped with the industry standard knowledge for making appropriate investments.

The course will include detailed step by step instructions and hands-on sessions to maximise the results of your learning.

Skills you learn

  • How to create financial valuation models in Excel
  • You will get Done For You Excel templates for financial modeling work
  • Understand how pros in private equity funds value companies
  • Gain confidence in financial modeling that is required in most top financial firms

Course Outline

Module 1: Introduction to fundamental analysis

  • Introduction to different valuation methodologies.
  • Introduction to accounting 3FS and its significance.

Module 2: Setting up accounting statements

  • Principles of a good accounting statement.
  • Introduction to advanced excel functions.

Module 3. Income Approach

  • Construct discounted cash flow (DCF) model from scratch.
  • Cost of capital analysis.

Module 4. Public Comparables Approach

  • Construct comparables model.

Module 5. Valuation Analysis

  • Develop sensitivity analysis models.
  • Construct football field for valuation analysis.

Module 6. Advanced DCF models

  • Debt projections.
  • Testing & documentation of model.

Course Details

Course Duration: 1 day (10am-5.30pm)

Course Fee: $590 $298

Course Fee  (After $298 skills future credit): $0

Course Code: CRS-N0044134

Location: Paya Lebar / Macpherson / Email info@surged.co for Corporate training at your office 

People wanting to learn how to use Excel for most finance related jobs.

People interested to get a job in banks, hedge funds, private equity firms and other related financial institutions

If you are looking to gain confidence in financial modeling by learning one of the most powerful skills in finance

Participants will be required to bring a laptop with Microsoft Excel installed. You also should have basic Excel and Finance Knowledge.

$ Bil
Worth of digital economy by 2025 in ASEAN alone
New jobs infocomm jobs available by 2018
$
Avg salary per year of a digital marketer (According to Payscale)

FAQ

Yes, there will be hands-on application in the course. Please bring your laptops.

Fill up this form for class dates

+65 8155 5088

Call or Whatsapp

Contact Us

For any enquires, you may contact us​ at info@surged.co