ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
  • ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements
Originally published: 21/12/2020 09:06
Publication number: ELQ-49906-1
View all versions & Certificate
certified

ITC Valuation Excel Model: Complete DCF Valuation with Forecasted Financial Statements

Completely editable and formula-based Valuation Excel Model for ITC Shares

Description
The model contains a complete formula based Discounted Cashflow valuation for the company. The entire model is controlled by the Assumptions Sheet where the user can enter the desired values and the model will calculate the Intrinsic value for the shares. The financial statements are also forecasted for 5 years in the future, based on the values updated in the Assumptions sheet.

The Excel model covers all the major fundamental aspects of the company over 15 years period. The model is easy to edit and update for the future years as well when the company releases its new annual report. It also includes interactive charts used for visualization of both original last 10 years data and the forecasted 5 years values for the company's financials.

The Excel model includes formula based excel model and visualizations of the following as shown in the images attached:

1. Income Statement (Reported and Forecasted)
2. Balance Sheet (Reported and Forecasted)
3. Cashflow statements (Reported and Forecasted)

4. FCFF and FCFE based Valuation using Discounted Cash Flow Method

Analysis of the following factors

5. Growth Ratios
6. Profitability Ratios
7. Cash Flow Ratios
8. Liquidity and Solvency Ratios
9. Efficiency Ratios
10. Valuation Multiples (EV/EBIT, Market Cap/EBIT and EV/EBITDA)
11. ROE (Du Pont Analysis)
12. Common Size analysis
13. Enterprise Valuation
14. Financial Strength Analysis

About the company:

ITC was incorporated in 1910 as the Imperial Tobacco Company and was later renamed as ITC Limited in 2001 where it no longer stands as an acronym. ITC is one of the largest private sector companies in India and also a diversified conglomerate with businesses ranging from Fast Moving Consumer Goods, Hotels, Paperboards and Packaging, Agri-Business and Information Technology. The Company is acknowledged as one of India’s most valuable business corporations with a gross sales value of approximately $ 11+ billion last year.

Note: All the research done by us is only for educational purposes and should not be seen as Investment recommendations. We are Research analysts and not a SEBI registered Investment Advisor. My research completely reflects my personal opinions and not of my employers. Kindly do your own due diligence before Investing

This Best Practice includes
1 Microsoft Excel Model

Acquire nonprofit license for $5.00

Add to cart

Add to bookmarks

Discuss

Further information

The aim is to provide a thorough outlook into the company's financial position. This will help the students and Investors who are looking to do their own due diligence before investing in the Indian Stock Markets.

DCF Valuation, Intrinsic Price Calculation, Fundamental Analysis, Financial Statements Forecasting

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Aryann Paghdal(last updated: 29/12/2020 16:48)
    Very Detailed and Easy to Use
    Covers mostly all the aspects of company valuation and DCF methods. Also, the graphs and charts are very presentable. Saved me a lot of time and effort.

More Best Practices from Billion Dollar Valuation

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on ITC Valuation Excel Model: Complete DCF Valuation With Forecasted Financial Statements?

The user community and author are here to help. Go ahead!


5.0 / 5 (1 votes)

please wait...