Financial Analysis & Modeling | Automobile Sector
Financial Analysis & Modeling | Automobile Sector
Updated 6/2023
Duration: 5h 17m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 3.79 GB
Genre: eLearning | Language: English
Updated 6/2023
Duration: 5h 17m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 3.79 GB
Genre: eLearning | Language: English
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 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.
Who this course is for:
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
More Info