Description

Finance Course: Mastering Financial Analysis & Valuation

Our Finance Course is designed to help you understand and apply key financial concepts in a simple and practical way. You’ll start with the basics of accounting, learning how financial statements like income statements, balance sheets, and cash flow statements are created and analyzed. Also you’ll explore different methods to evaluate a company’s financial health using ratio analysis, trend analysis, and financial modeling in Excel.

The course covers valuation techniques like discounted cash flow (DCF), enterprise value (EV), and EBITDA, using real-world company data. You’ll also explore startup valuation, risk assessment, and financial visualization. To prepare for finance roles, resume-building and interview sessions are included, making this course ideal for careers in corporate finance, investment banking, and consulting.

 

Skills you will get

 

Basic Accounting Assumptions

• Accounting Cycle ( Journal, Ledger, Trial Balance and Final Accounts)
• Creation of Income Statement
• Balance Sheet
• Cash flow statement

 

Financial Statement Analysis and its methods

• Common size statement analysis
• Comparative statement Analysis
• Ratio Analysis
• Trend analysis

Creation of Three-Statement Model in Excel

• Interlinking of Profit & Loss Statement Balance Sheet, and Cash Flow Statement (Integrated Financial Model)
• Assumption Techniques (Extrapolation) Forecasting Future Income Statement Balance Sheet, and Cash Flow Statement in Excel (Forward-Looking Integrated Financial Model)

Forecasting Financial Statements Using Ratios in Excel

• Forecasting forward looking Balance sheet, income statement and cash flow statement by using Ratios in Excel.
• Determination of Unlevered Cash flow and concept of NOPAT(Net operating profit after tax).(Discounted Cash Flow Modeling in Excel)
• Time value of Money concept. Understanding of discounting future cash flows.
• CAPM concept and Basic understanding of Weighted Average Cost of Capital (WACC). Determining Terminal Value.

Methods of Valuation

• Book Value Method of Valuation
• Adjusted Book Value Method of Valuation

 

Enterprise Value and EBITDA

• Concept of Enterprise Value
• Calculation of Enterprise Value
• Concept of EBITDA
• Calculation of EBITDA

Relative Valuation Methods

• Introduction to Relative Valuation/Comparable Company Valuation
• EV/EBITDA Multiple
• EV/Revenue Multiple
• Price to EPS Valuation

 

Real Company Valuation Models in Excel

• EV/EBITDA Valuation Model
• EV/Revenue Valuation Model
• Price to EPS Valuation Model

Replacement Cost Method

• Introduction to Replacement Cost Method
• Replacement Cost Valuation in Excel(Real Company)

 

Beta and Startup Valuation

• Concept of Asset Beta and Equity Beta Methodology to Un-lever Beta and Re-lever Beta
• Valuation of a Startup

Excel Analysis Techniques and Data Visualization

• Sensitivity Analysis in Excel
• Data Visualization by Creating Charts in Excel
• Football Field Analysis

 

Internship or project

The completion certificate for courses, internships, or projects will be issued only to those who meet the eligibility criteria.

Placement Training

• Resume building – Professional & impactful CV
• Communication skills – Improve speaking & writing
• Interview prep – Ace personal interviews
• Group discussions – Stand out effectively
• Body language – Confidence & etiquette
• Job search tips – Find & apply smartly
• LinkedIn tips – Optimize for jobs