Financial Modeling | Metal Sector : Barrick Gold Corp

Learn projections, financial modeling, forecasting and valuation techniques for Metal Sector

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