Financial Modeling | Automobile Sector : Maruti Suzuki
Published 5/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.33 GB | Duration: 5h 13m

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

What you'll 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

Requirements
Microsoft Excel 2010, 2013, 2016, 2020, or Microsoft Excel 365

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:Company valuation (using DCF valuation and Relative valuation)IPO evaluationM&A analysis (using an M&A Model)Project evaluation (also known as project finance modeling)BudgetingStartup planningStrategic 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.

Overview
Section 1: Introduction

Lecture 1 Introduction to Automobile Sector

Lecture 2 Market Overview of Automobile Sector

Section 2: Financial Modelling of Maruti Suzuki

Lecture 3 Financial Modelling of Maruti Suzuki

Lecture 4 Total Income and Sales Values of Maruti Suzuki

Lecture 5 Another and Total Expenses of the Maruti Suzuki

Lecture 6 Minority Interest

Lecture 7 More on Minority Interest

Section 3: Profit and Loss

Lecture 8 Profit and Loss Associate Company

Lecture 9 Profit and Loss Associate Company Continues

Section 4: Balance Sheet

Lecture 10 Creating Balance Sheet Maruti Model

Lecture 11 Secured and Unsecured Loan Balance Sheet

Lecture 12 Capital Employed Balance Sheet

Lecture 13 Total Depreciation Balance Sheet

Lecture 14 Percentage of Sales

Lecture 15 Cash and Bank Example of Maruti Model

Lecture 16 Current Liabilites Details

Section 5: Cash Flow

Lecture 17 Introduction to Cash Flow

Lecture 18 Cash Profits in Cash Flow

Lecture 19 Captial Expenditure in Cash Flow

Lecture 20 Payout Ratio and Dividend in Cash Flow

Lecture 21 Equity and Debt Raised in Cash Flow

Lecture 22 Key Ratio in Cash Flow

Lecture 23 Dupoint Analysis Key Ratio in Cash Flow

Lecture 24 Dupoint Analysis Key Ratio in Cash Flow Continues

Lecture 25 Valuation Key Ratio in Cash Flow

Lecture 26 Return Key Ratio in Cash Flow

Lecture 27 Projected Sales In Cash Flow

Lecture 28 Formula Calculating Key Ratios

Lecture 29 Formula Calculating Key Ratios Continues

Lecture 30 Volume Growth in P and L

Lecture 31 Total And Other Incomes in P and L

Lecture 32 Current and Actual Deprication in P and L

Lecture 33 Depriciation Rates in P and L

Lecture 34 Minority Intrest and P and L of Comapnay

Lecture 35 Capital and General Reserves in Balance Sheet

Lecture 36 Calculate Capital Workin Progress in Balance Sheet

Lecture 37 Current Assets Formula in Balance Sheet

Lecture 38 More on Key Ratio

Lecture 39 More on Key Ratio Continues

Lecture 40 Turnover Key Ratio

Financial Analysts/ Managers who want to expand on the current set of skills,Graduates/Post Graduates/CA/CFA,Business and finance practitioners who are eager to improve their Excel and Financial Modeling skills

  https://www.udemy.com/course/financial-modeling-automobile-sector-maruti-suzuki/