Confusion to Conclusion

Business_Valuation_Using_Spreadsheets-Thumbnail

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

Business Valuation 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.

Business Valuation 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

Business Valuation Skills Covered In This Course

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

Course Highlights

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


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