• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer
EDUCBA

EDUCBA

MENUMENU
  • Resources
        • Investment Banking

          • Investment Banking Jobs Offer
          • Current Ratio
          • Discounted Cash Flows
        • Investment Banking
        • Finance Formula

          • CFA vs FRM
          • Net Working Capital Formula
          • Free Cash Flow to Firm
        • Finance Formula
        • Valuation

          • Equity Research Career
          • Return on Equity
          • Methods to calculate WACC
        • Finance Valuation
        • Others

          • Resources (A to Z)
          • Accounting Fundamentals
          • Corporate Finance Basics
          • Financial Modeling in excel
          • Credit Research Fundamentals
          • Asset Management Tutorial
          • Trading for dummies
          • View All
  • Free Courses
  • All Courses
        • Certification Courses

          Financial Analyst Course
        • All in One Bundle

          Financial-Analyst-Bundle
        • Investment Banking Training

          Investment-Banking-Training
        • Others

          • Financial Modeling Course
          • Equity Research Course
          • Private Equity Training Course
          • Business Valuation Course
          • Mergers and Acquisitions Course
          • View All
  • 250+ Courses All in One Bundle
  • Login

Valuation Project # 2 – HDIL

Home » Courses » Finance » Equity Research » Valuation Project # 2 – HDIL
0 Shares
Share
Tweet
Share
Course Overview

This is a online course is to gain understanding of Equity Valuation of Real Estate Sector. The aim is to gain understanding of valuing the equity. The tutorials will help you learn the Basic and Advanced Excel, Corporate Valuation and Report Writing Technique.

320
12 hours + 19h 14m | 189 Videos | 38031 Views | Appropriate for all  All Levels| English[Auto-generated]
trigger text
hidden content

Valuation – Real Estate Course

One of the main decisions of undertaking corporate valuation is that it helps in business planning and future decision making. Valuation is a versatile tool which can be used effectively by analysts and managers in order to take informed business decisions.
It helps in define business strategies and is also a performance indicator showing where the business is heading. This course on corporate valuation on Real Estate sector company -HDIL has been built with the purpose of enabling its participants to learn how to value a HDIL’s share (overvalued or undervalued) and a write a report on the analysis with supporting interpretations and results. At the end of this course the participants would be able to perform valuation on a company using methods such as the DCF and Relative valuation and write a professional report on the same.

Target Audience Equity Valuation – Real Estate Sector:

  • Finance graduates
  • B.Com, BMS, BBA, MBA (Finance)
  • Financial Analyst
  • Research Analyst
  • Sock analyst and investors

Course Highlights Equity Valuation – Real Estate Sector:

  • Excel skills

Having Excel proficiency is a pre-requisite for any business. It can be used to analyze costs, validating and maintain information, auditing etc. It helps in storing data, performing rapid calculations ad keep a track on all the aspects relating to business.
This section of the course helps you to learn the required excel skills by learning the basic and advanced tools and functions which can make the tasks quicker and presentable as well.

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

  • Corporate Valuation lessons

In order to gauge the true intrinsic value/worth of a company requires corporate valuation techniques for doing this it requires varied components and sophisticated analyses of the same.  In his module of the course we would learn the various valuation techniques in detail and apply the discounted cash flow (DCF) method and Relative valuation on HDIL Company and conduct its valuation.

  • Report Writing

The final step of valuation process includes communicating the value conclusion and giving the basis and assumptions of valuation undertaken. This is what would be taught in this last module where everything about report writing would be discussed in detail.

Back to top ▴

View Offline
View courses without internet connection with a Lifetime Membership
View courses without internet connection with a Lifetime Membership

View Offline - Internet-free viewing with your iOS or Android App

Watch offline with your iOS/Android app.

Start Your Free Trial Now

You can download courses from your iOS/Android App.

0 Shares
Share
Tweet
Share
Reader Interactions
Primary Sidebar
Merger Modeling - Comcast Corp and Time Warner Inc.

Curriculum

1. Basic Excel

  • Getting Started Ribbons Quick Access Toolbar
  • Getting Started Surfing Excel HELP Function
  •  XYZ Company Basic Excel Case Study
  • Excel Case Study
  • Data Entry in Excel
  • Populating the Case Study in Excel
  •  Populating case study in excel without solution
  •  Populating case study in excel with solution
  • Calculations Addition Subtract Multiply Division
  •  Calculations without solution
  •  Calculations with solution
  • Formulas SUM MAX MIN AVERAGE
  •  Formulas without solution
  •  Formulas with solution
  • Formatting Number Formats
  •  Formatting Number Formats without solution
  •  Formatting Number Formats with solution
  • Formatting Table Formats
  •  Formatting Table Formats without solution
  •  Formatting Table Formats with solution
  • Updating a Calculation
  •  Updating a calculation without solution
  •  Updating a calculation with solution
  • Percentages and Absolute References
  •  Percentage asbsolute refernceswithout solution
  •  Percentage asbsolute refernceswith solution
  • Conditional Formatting
  •  Conditional formatting without solution
  •  Conditional formatting with solution
  • IF Function
  •  If function without solution
  •  If function with solution
  • COUNTIF Function
  •  Count if without solution
  •  Count if with solution
  • SUMIF Function
  •  Sum if without solution
  •  Sum if with solution
  • Creating Charts and Graphs
  •  Creating Charts and Graphs without solution
  •  Creating Charts and Graphs with solution
  • Create Pie Charts
  •  Create Pie Charts without solution
  •  Create Pie Charts with solution
  • Sorts
  •  Sorts without solution
  •  Sorts with solution
  • Filter
  •  Filter without solution
  •  Filter with solution
  • Pivot Table
  •  Pivot table without solution
  •  Pivot table with solution
  • Freeze and Split
  •  Freeze and split without solution
  •  Freeze and split with solution
  • Presentation Table Formats
  •  Presentation 1 without solution
  •  Presentation 1 with solution
  • Presentation Indents and Formatting Charts
  •  Presentation Indents and Formatting Charts without solution
  •  Presentation Indents and Formatting Charts with solution
  • Printing the Worksheet
  • Printing Headers and Titles
  • Shortcuts Formatting and Navigation
  • Shortcuts Selection Data and Formula
  •  Excel Shortcuts
  • Common Errors

2. Advanced Excel

  • Office Button and Paste Function
  • Sparklines Custom Ribbons and Screenshots
  • Conditional Formatting and Equation Editor
  • Paste Special
  •  Paste Special Base File
  •  Logical functions IF AND OR
  • Logical functions IF AND OR
  •  Logical Function Quiz Without Solution
  •  Logical Function Quiz With Solution
  •  Arithmetic functions MAX MIN ABS etc
  • Arithmetic functions MAX MIN ABS etc
  •  Quiz Arithmetic Function Without Solution
  •  Quiz Arithmetic Function With Solution
  •  COUNT COUNTIF COUNTA COUNTBLANK
  • COUNT COUNTIF COUNTA COUNTBLANK
  • Cell Information ISERROR ISBLANK etc
  •  Cell Information Without Solution
  •  Cell Information With Solution
  •  CHOOSE Function
  • CHOOSE Function
  •  Choose Function Without Solution
  •  Choose Function With Solution
  •  VLOOKUP Function
  • VLOOKUP Function
  •  Vlookup Referencing Database File
  •  Vlookup Function Without Solution
  •  Vlookup Function With Solution
  •  HLOOKUP Function
  • HLOOKUP Function
  •  Hlookup Referencing Database File
  •  Hlookup Function Without Solution
  •  Hlookup Function With Solution
  •  MATCH INDEX
  • MATCH INDEX
  •  MATCH INDEX
  •  Database functions DSUM DAVERAGE DCOUNT
  • Database functions DSUM DAVERAGE DCOUNT
  •  Database functions Without Solution
  •  Database functions With Solution
  • OFFSET Function Part 1
  • OFFSET Function Part 2
  •  OFFSET Function Without Solution
  •  OFFSET Function With Solution
  • FORECAST Function
  •  FORECAST Function Without Solution
  •  FORECAST Function With Solution
  •  One Dimensional Data Tables
  • One Dimensional Data Tables
  •  One Dimensional Data Tables Without Solution
  •  One Dimensional Data Tables With Solution
  • Two dimensional Data Tables
  •  Two dimensional Data Tables Without Solution
  •  Two dimensional Data Tables With Solution
  • Solver
  •  Solver Without Solution
  •  Solver With Solution
  •  Goal Seek
  • Goal Seek
  •  Goal Seek Without Solution
  •  Goal Seek With Solution
  • Array Function Introduction
  •  Array Function Part 1 Without Solution
  •  Array Function Part 1 With Solution
  • Array Function Row and Columns
  •  Array Function Part 2 Without Solution
  •  Array Function Part 2 With Solution
  • Array Function TRANSPOSE
  •  Array Function Part 3 Without Solution
  •  Array Function Part 3 With Solution
  • Array Function FREQUENCY
  •  Array Function Part 4 Without Solution
  •  Array Function Part 4 With Solution
  • PROPER UPPER LOWER LEFT RIGHT MID
  •  Text and String Function Part 1 Without Solution
  •  Text and String Function Part 1 With Solution
  • FIND CLEAN REPT CONCATENATE
  •  Text and String Function Part 2 Without Solution
  •  Text and String Function Part 2 With Solution
  • Pivot Tables
  •  Pivot Tables Without Solution
  •  Pivot Tables With Solution
  • Pivot Table Filter Slicer
  •  Pivot Table Filter Slicer Without Solution
  •  Pivot Table Filter Slicer With Solution
  • Pivot Charts
  •  Pivot Charts Without Solution
  •  Pivot Charts With Solution
  • Naming a Cell and a Range
  •  Names Dynamic Ranges Part 1 Without Solution
  •  Names Dynamic Ranges Part 1 With Solution
  • Naming Dynamic Ranges
  •  Names Dynamic Ranges Part 2 Without Solution
  •  Names Dynamic Ranges Part 2 With Solution
  • Auditing Toolbar
  •  Auditing Toolbar Base File
  • Watch Window
  •  Watch Window Base File
  • Group Boxes and Options Button
  •  Group Boxes and Options Button Base File
  • Check Boxes
  •  Check Boxes Base File
  • List Boxes and Combo Boxes
  •  List Boxes and Combo Boxes Base File
  • Scroll Bar and Spinners
  •  Scroll Bar and Spinners Base File
  • Text to Columns
  •  Text to Columns Without Solution
  •  Text to Columns With Solution
  • Grouping Tabs
  •  Grouping Tabs Without Solution
  •  Grouping Tabs With Solution
  • SUBTOTAL Function
  •  SUBTOTAL Function Without Solution
  •  SUBTOTAL Function With Solution
  • Hyperlinks
  •  Hyperlinks Base File
  • Data Validation
  •  Data Validation Without Solution
  •  Data Validation With Solution
  • Random Numbers
  •  Random Numbers Without Solution
  •  Random Numbers With Solution
  • Custom View
  •  Custom View Without Solution
  •  Custom View With Solution
  • Protecting Worksheet and Workbook
  •  Protecting Worksheet and Workbook Without Solution
  •  Protecting Worksheet and Workbook With Solution
  • Excel 2010 Sparklines
  •  Excel 2010 Sparklines Without Solution
  •  Excel 2010 Sparklines With Solution
  •  Range Charts
  • Range Charts Type 1 Part a
  • Range Charts Type 1 Part b
  •  Range Charts Without Solution
  •  Range Charts With Solution
  •  Range Charts Area
  • Range Charts Area Type 2 Part a
  • Range Charts Area Type 2 Part b
  •  Range Charts Area Without Solution
  •  Range Charts Area With Solution
  •  Funding Graph
  • Funding Graph
  •  Funding Graph Without Solution
  •  Funding Graph With Solution
  •  Two Axis Graphs
  • Two Axis Graphs
  •  Two Axis Graphs Without Solution
  •  Two Axis Graphs With Solution
  •  Scenario Graphs
  • Scenario Graphs Part 1
  • Scenario Graphs Part 2
  •  Scenario Graphs Without Solution
  •  Scenario Graphs With Solution
  • Average Line
  •  Adding an average line without solution
  •  Adding an average line with solution
  • Bar to Pie chart
  •  Bar to Pie Chart without solution
  •  Bar to Pie Chart with solution
  • Combo Charts
  •  Combo Charts without solution
  •  Combo Charts with solution
  • Creating Histogram
  •  Creating Histogram without solution
  •  Creating Histogram with solution
  • Invert Negatives
  •  CBA Invert Negatives in Chart without solution
  •  CBA Invert Negatives in Chart with solution
  • Scrolling Chart part 1
  •  Scrolling Charts part 1 without solution
  •  Scrolling Charts part 1 with solution
  • Scrolling Chart part 2
  •  Scrolling Charts part 2 without solution
  •  Scrolling Charts part 2 with solution

3. Corporate Valuation

  •  Introduction to Valuation
  •  Dividend Discount Module
  • Dividend discount model DDM Example 1
  • Dividend discount model DDM Example 2
  • Dividend discount model DDM Example 3
  • Dividend discount model DDM Example 4
  • Dividend discount model DDM Example 4
  •  Dividend Discount Model without solutions
  •  Dividend Discount Model with solutions
  •  Dividend Discount Model
  • Introduction to DCF
  •  Introduction to DCF
  •  FCFF FCFE Example without solutions
  •  FCFF FCFE Example with solutions
  • Forecasting Income Statement EBITDA
  • Understanding the Working Capital
  • Completing the Working Capital Calculations
  • Linking the Free Cash Flow to Firm FCFF
  • Discounting the Explicit Period Cash Flows
  •  Detailed view on Calculating FCFF
  • Calculation of Terminal Values
  •  Terminal Value Perpetuity Growth and Exit Multiple Method
  •  Projecting FCFF Terminal Value without solution
  •  Projecting FCFF Terminal Value with solution
  • DCF Valuation Summary
  • DCF Sensitivity Analysis
  •  Understanding the Capital Structure
  • Options Treasury Stock Method
  • Options Explained Part 2
  • Calculation of inthemoney Convertibles
  • Calculation of inthemoney Stock Options
  • Calculation of Debt Equity Ratio
  •  Understanding the Capital Structure without solution
  •  Understanding the Capital Structure with solution
  • Cost of Debt Calculations
  •  Cost of Debt Calculations
  •  Cost of Equity
  • Cost of Equity Calculation
  •  Weighted Average Cost of Capital WACC
  •  WACC Calculations without Solution
  •  WACC Calculations with Solution
  •  Terminal Value
  • Enterprise Value Calculation Completing the Missing Links
  •  Enterprise Value Calculation
  •  Adjustments to Enterprise Value
  •  DCF
  •  DCF Synthesis without solution
  •  DCF Synthesis with solution
  •  WACC Calculations Internet Companies Case Study
  •  Discounted Cash Flow
  •  DCF Application Asian Paints without solution
  •  DCF Application Asian Paints with solution
  •  DCF Application Asian Paints
  •  DCF Application Google Inc without solution
  •  DCF Application Google Inc with solution
  •  DCF Application Google Inc
  •  Introduction to Relative Valuation
  • Introduction to Relative Valuation
  • Relative Valuations Enterprise Value and Equity Value
  • Relative Valuations Comparable Comp Sheet
  •  Relative Valuations Equity Value Method
  • Understanding PE Ratio
  • Forward and Trailing PE
  • Advantages and Limitations of PE
  • Understanding PBV Ratio
  • Why PBV is used in Banks
  • PBV and ROE Used for Energy Sector
  • Understanding PCF Ratio
  • Why PCF used in Oil Gas Gold Real Estate
  •  Relative Valuation Enterprise Value
  •  Benchmarking Analysis
  • Benchmarking Analysis part 1
  • Benchmarking Analysis part 2
  • Benchmarking Analysis part 3
  • Benchmarking Analysis part 4
  • Benchmarking Analysis part 5
  •  Relative Valuation
  •  Wockhardt Comparable Company Valuation
  • Wockhardt Equity Valuation Summary Comparable Company Valuation Part 1
  • Wockhardt Equity Valuation Summary Comparable Company Valuation Part 2
  •  Football Field Wockhardt Case Study
  • Football Field Wockhardt Case Study
  •  RHI Comparable Company Analysis
  •  RHI Comparable Company Analysis without solutions
  •  RHI Comparable Company Analysis with solutions
  •  Comparable Acquisition Analysis
  •  Introduction to Sum of Parts
  •  ITC Case Study
  •  ITC Cigarette Segment Comparable Comp without solution
  •  ITC Cigarette Segment Comparable Comp with solution
  •  ITC FMCG Segment Comparable Comp without solution
  •  ITC FMCG Segment Comparable Comp with solution
  •  ITC Hotel Segment Comparable Comp without solution
  •  ITC Hotel Segment Comparable Comp with solution
  •  Introduction to Residual Income Method
  •  Residual Income Method without solution
  •  Residual Income Method with solution
  •  Benchmarking Analysis
  • Comparables for Hospital Companies Part 1
  • Comparables for Hospital Companies Part 2
  • Comparables for Hospital Companies Part 3
  •  Comparable Company Analysis
  • Comparable Company Analysis Pharma part 1
  • Comparable Company Analysis Pharma part 2
  • Comparable Company Analysis Pharma part 3
  • Comparable Company Analysis Pharma part 4
  •  Cement Sector Comparable Companies Analysis Comps Analysis
  • Cement Sector Comparable Companies Analysis Comps Analysis
  • Valuing Property Companies Part 1
  • Valuing Property Companies Part 2
  • Valuing Property Companies Part 3
  • Valuing Property Companies Part 4
  •  Comp Sheet Global Benchmarking Model
  • Comps Sheet Global Benchmarking Model Part 1
  • Comps Sheet Global Benchmarking Model Part 2
  • Comps Sheet Global Benchmarking Model Part 3
  • Comps Sheet Global Benchmarking Model Part 4
  • Comps Sheet Global Benchmarking Model Part 5
  • Comps Sheet Global Benchmarking Model Part 6
  • Comps Sheet Global Benchmarking Model Part 7
  •  Oil and Gas Sector Comparable Company Analysis COMPS
  • Oil and Gas Sector Comparable Company Analysis COMPS
  •  Valuation Methodologies for PE Fund managers
  • Valuation Methodologies part 1
  • Valuation Methodologies part 2
  • Valuation Methodologies part 3
  • Valuation Methodologies part 4
  •  Discounted Cash Flows
  • Calculating Discounted Cash Flows part 1
  • Calculating Discounted Cash Flows part 2
  • Calculating Discounted Cash Flows part 3
  • Calculating Discounted Cash Flows part 4
  • Calculating Discounted Cash Flows part 5
  • Calculating Discounted Cash Flows part 6
  • Calculating Discounted Cash Flows part 7
  • Calculating Discounted Cash Flows part 8
  •  WACC analysis PE Companies
  • WACC analysis PE Companies part 1
  • WACC analysis PE Companies part 2
  •  Football Field
  • Football Field

4. Report Writing Technique

  •  Introduction
  • Introduction
  •  What is Equity Research Report
  • What is Equity Research Report Part 1
  • What is Equity Research Report Part 2
  •  Anatomy of Equity Research Report
  • Anatomy of Equity Research Report
  •  Comparing Equity Research Report
  • Comparing Equity Research Report
  •  Report Writing Case Studies
  • Report Writing Case Studies
  •  Useful Financial Websites
  • Useful Financial Websites
  •  Indian Media Sector Report
  • Indian Media Sector Report Part 1
  • Indian Media Sector Report Part 2
  • Indian Media Sector Report Part 3
  •  Peer Analysis without solutions
  •  Peer Analysis with solutions
  • Peer Analysis part 1
  • Peer Analysis part 2
  • Peer Analysis part 3
  • Peer Analysis part 4
  • Peer Analysis part 5
  • Peer Analysis part 6
  • Peer Analysis part 7
  •  Aurobindo Pharma Annual Report
  •  Biocon Ltd Annnual Report
  •  Cadila Annual Report
  •  Dishman Annnual Report
  •  Sun Pharma Annual Report
X

Loading the player...

Related Courses

LBO Modeling

LBO Modeling

3+ hours of Videos

14+ Lectures

Accounting Training - Online Accounting Courses

Accounting Training - Online Accounting Courses

17+ hours of Videos

93+ Lectures

Investment Management- Investment Management Courses

Investment Management- Investment Management Courses

6+ hours of Videos

32+ Lectures

Mergers and Acquisitions Courses (Project)

Mergers and Acquisitions Courses (Project)

93+ hours of Videos

505+ Lectures

Valuation Project # 3 - Idea

Valuation Project # 3 - Idea

35+ hours of Videos

189+ Lectures

M&A Project - Merger Modeling of DRL & CIPLA

M&A Project - Merger Modeling of DRL & CIPLA

32+ hours of Videos

176+ Lectures

Related Job Oriented Programs

Footer
About Us
  • Who is EDUCBA?
  • Sign Up
  •  
Free Courses
  • Free Finance Course Online
  • Free Online Course Accounting
  • Free Tutorials on QuickBooks
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course
  • Venture Capital Course
  • CFA Level 1 Course
  • CFA Level 2 Course
  • IFRS Course Training
  • Project Finance Course
  • Hedge Funds Course
Resources
  • Resources (A To Z)
  • Investment Banking Jobs Offer
  • Finance Formula
  • Valuation
  • Accounting Fundamentals
  • Corporate Finance Basics
  • Financial Modeling in excel
  • Credit Research Fundamentals
  • Asset Management Tutorial
  • Trading for dummies
Apps
  • iPhone & iPad
  • Android
Support
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions

© 2019 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

Let’s Get Started
Please provide your Email ID
Email ID is incorrect

Limited Period Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More

Limited Period Offer - Limited Period Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More