What you'll learn
Build P&L statements from a raw data extraction
Forecasting Financial Statement
Build valuation models from scratch
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 Metal sector. We have taken the company Barrick Gold Corp 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 FM Overview
Lecture 2 Introduction to Financial Modelling on Metal Sector
Section 2: Gold Industry Presentation
Lecture 3 Example on Chinas Demand
Lecture 4 Project Capital Expenditure
Lecture 5 Projection on Barrick Gold Corporation
Section 3: Gross Realization
Lecture 6 Calculating the Gross Realization
Lecture 7 Calculating the Gross Realization Continues
Lecture 8 General Selling and Admin Expenses
Lecture 9 Total Operating Profit
Lecture 10 Analyzing the Balance Sheet
Lecture 11 Rate of Depreciation
Lecture 12 Cost of Overall Debt
Section 4: Current Assets
Lecture 13 Calculating the Current Assets
Lecture 14 Evaluating Trade Accounts Payable
Lecture 15 Calculating Net Current Assets
Lecture 16 Evaluating the Overall Assets
Lecture 17 Profit before Tax and Exceptional Items
Lecture 18 Optimizing Increase in Inventory
Lecture 19 Determining the Interest Paid
Lecture 20 Sale of Investments
Lecture 21 Effects of Exchange Rates
Lecture 22 Earnings per Share
Lecture 23 Valuing Debt to Equity
Lecture 24 Calculating the Valuation Ratios
Lecture 25 Dividend Payout and Dividend Yield
Lecture 26 Compounded Annual Growth Rate
Lecture 27 Calculating Target Rate for Particular Stock
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



Download link

rapidgator.net:


uploadgig.com:


nitroflare.com:


[b][/b]: