Financial Modeling | Automobile Sector : Maruti Suzuki
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
HOMEPAGE
https://www.udemy.com/course/financial-modeling-automobile-sector-maruti-suzuki/
DOWNLOAD
https://rapidgator.net/file/6254958cd84ce724e0092e7703436e69/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part1.rar.html
https://rapidgator.net/file/d13a7b312770f2034b3ec96dc140c498/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part2.rar.html
https://rapidgator.net/file/cd71356132b54f43ae8413d49aa5ca74/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part3.rar.html
https://rapidgator.net/file/b6dbfbd25267f3d47717375418a19676/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part4.rar.html
https://uploadgig.com/file/download/55715d5D28aae7D8/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part1.rar
https://uploadgig.com/file/download/D91A5aC5C4ebaeab/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part2.rar
https://uploadgig.com/file/download/ed92a70f27504b9f/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part3.rar
https://uploadgig.com/file/download/AD2Cf3cb9a50281e/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part4.rar
https://rapidgator.net/file/d13a7b312770f2034b3ec96dc140c498/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part2.rar.html
https://rapidgator.net/file/cd71356132b54f43ae8413d49aa5ca74/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part3.rar.html
https://rapidgator.net/file/b6dbfbd25267f3d47717375418a19676/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part4.rar.html
https://uploadgig.com/file/download/55715d5D28aae7D8/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part1.rar
https://uploadgig.com/file/download/D91A5aC5C4ebaeab/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part2.rar
https://uploadgig.com/file/download/ed92a70f27504b9f/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part3.rar
https://uploadgig.com/file/download/AD2Cf3cb9a50281e/Financial_Modeling_Automobile_Sector_Maruti_Suzuki.part4.rar