REQUEST
REQUEST A CALL BACK

Business Valuation Using Spreadsheets

22 Hrs Live Course with 11 Sessions Covered in 2 Months(1 hours/session) 

Weekends or  Weekdays

Private:  For 1:1 ₹28,320  (Inc. GST) 
Group: For 1:7 ₹14,160  (Inc. GST) 

50+ IELTS course have already been purchased by your peers so far.
You will learn
Deliverables
Share This

To enroll into Entrepreneurship: Building Your Start Up Course

Request A CallBack

Course description

Valuation using spreadsheets is the main component of business decision-making program. This is a base and highly useful for many critical decisions such as Initial public offerings, Merger and Acquisition- Buy side and sell side, Leverage buyout, Venture Capital & Private Equity- Start up financing of different series etc.

Course Objective

  • Analyzing of financial statements in MS Excel
  • Developing quantitative models for firm and equity valuation based on DCF and multiples
  • Identifying and interpreting key value drivers for valuation
  • Identifying and interpreting the key value drivers
  • Analysis of valuation models
  • Creating Football field
  • Creating scenario analysis

Skills covered in this course

  • Understanding and Analysis of Financial Statements
  • Advanced MS Excel
  • Financial Modeling
  • Valuation Techniques- DCF, Comparable company, Comparable transactions.

Course Highlight

Certificate
12 Hours of Engaging Interactive Live Classes
Learning through Live Discussions & Case Studies
Learn from Founder of Startups with 12+ years of Experience

Meet the Instructor

Kapil Madan (Assistant Professor of Finance at the Amity Business School)

Kapil Madan is an Assistant Professor of Finance at the Amity Business School. He is having 15 Years (13.5 years in Academic & 1.5 Years in Financial Services Industry)of experience. He teaches Corporate Finance, Security analysis and Asset valuation. He received his CFA from ICFAI. Prior to that he did his MBA from MDU Rohtak and B.Com from Kurukshetra University. His primary research interests are in the areas of Financial Statement analysis, Corporate Finance, and Asset valuation. Degree Awarded: CFA ICFA, MBA and B.Com

View GG Profile

Who Should Attend

  • Current/Completed MBA Finance, CFA students
  • Career shifters towards Investment banking, Private Equity, Corporate Finance
  • Knowledge enhancers in the areas of MS excel, Financial statements, valuation.

Certificate of Completion

GrabGuidance Live Courses
  • Download or print out as PDF to share with others.
  • Share as image online to demonstrate your skill.
  • Attach the PDF version of the certificate with your resume to get more visibility.

What will be the training syllabus?

Session 1

Introduction to Valuation- Price vs Value, need of valuation- IPO, M&A, start up financing etc.

Session 2

Introduction to Financial Statements- BS, IS, CFS, integration of Financial Statements.

Session 3

Analysis of Financial statements- Ratios (Case study)

Session 4

Basics of MS excel, charting in Ms excel etc

Session 5

Advance Ms excel- Look up, Index, match, if and or.

Session 6

 Advance Ms excel- Pivot table, conditional formatting, logical functions etc.

Session 7

Discounted cash flow (case study)

Session 8

Comparable company analysis (private company case study)

Session 9

Comparable transactions (M&A case study)

Session 10

 Merger and acquisitions (case study)

Session 11

LBO and LBO modelling (case study)

Request A Call Back


Other courses you might be interested in