• Post category:StudyBullet-15
  • Reading time:6 mins read


Learn forcasting, valuation and financial modeling of India focused automobile sector

What you will learn

Build valuation models from scratch

Forecasting Financial Statement

Build P&L statements from a raw data extraction

Learn many important Finance functions in Microsoft Excel

Knowledge of all the essential Excel formulas required for Financial Analysis

Use MS Excel to create and automate the calculation of Financial ratios

Description

In this course, you will learn the financial modeling for automobile sector (India Focused). We have taken the company Maruti Suzuki for all forecasting and modeling purpose. A financial model is a versatile tool used across different areas of finance, such as Equity Research, Investment Banking, and Credit Research. We can create it for various scenarios, including:


Get Instant Notification of New Courses on our Telegram channel.


  • Company valuation (using DCF valuation and Relative valuation)
  • IPO evaluation
  • M&A analysis (using an M&A Model)
  • Project evaluation (also known as project finance modeling)
  • Budgeting
  • Startup planning
  • Strategic decision-making and expansion.

Financial models are usually built by finance professionals specializing in different areas of finance, like investment banking, equity research, credit research, risk analysis, and portfolio management. Investment bankers and financial analysts use financial models to evaluate potential investments and determine the best course of action. Equity research analysts use financial models to evaluate the financial performance of companies and their stocks. Credit research analysts use financial models to assess companies’ creditworthiness and ability to repay debt. Risk analysts use financial models to assess the risk associated with investments and financial decisions. Investors and portfolio managers use financial models to decide which investments to include. Other finance professionals, such as CFOs (Chief Financial Officers), accountants, and financial consultants, also create financial models to support decision-making and planning.

English
language

Content

Introduction

Introduction to Automobile Sector
Market Overview of Automobile Sector

Financial Modelling of Maruti Suzuki

Financial Modelling of Maruti Suzuki
Total Income and Sales Values of Maruti Suzuki
Another and Total Expenses of the Maruti Suzuki
Minority Interest
More on Minority Interest

Profit and Loss

Profit and Loss Associate Company
Profit and Loss Associate Company Continues

Balance Sheet

Creating Balance Sheet Maruti Model
Secured and Unsecured Loan Balance Sheet
Capital Employed Balance Sheet
Total Depreciation Balance Sheet
Percentage of Sales
Cash and Bank Example of Maruti Model
Current Liabilites Details

Cash Flow

Introduction to Cash Flow
Cash Profits in Cash Flow
Captial Expenditure in Cash Flow
Payout Ratio and Dividend in Cash Flow
Equity and Debt Raised in Cash Flow
Key Ratio in Cash Flow
Dupoint Analysis Key Ratio in Cash Flow
Dupoint Analysis Key Ratio in Cash Flow Continues
Valuation Key Ratio in Cash Flow
Return Key Ratio in Cash Flow
Projected Sales In Cash Flow
Formula Calculating Key Ratios
Formula Calculating Key Ratios Continues
Volume Growth in P and L
Total And Other Incomes in P and L
Current and Actual Deprication in P and L
Depriciation Rates in P and L
Minority Intrest and P and L of Comapnay
Capital and General Reserves in Balance Sheet
Calculate Capital Workin Progress in Balance Sheet
Current Assets Formula in Balance Sheet
More on Key Ratio
More on Key Ratio Continues
Turnover Key Ratio