• Post category:StudyBullet-15
  • Reading time:5 mins read


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

What you will 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

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:


Get Instant Notification of New Courses on our Telegram channel.


  • 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.

English
language

Content

Introduction

FM Overview
Introduction to Financial Modelling on Metal Sector

Gold Industry Presentation

Example on Chinas Demand
Project Capital Expenditure
Projection on Barrick Gold Corporation

Gross Realization

Calculating the Gross Realization
Calculating the Gross Realization Continues
General Selling and Admin Expenses
Total Operating Profit
Analyzing the Balance Sheet
Rate of Depreciation
Cost of Overall Debt

Current Assets

Calculating the Current Assets
Evaluating Trade Accounts Payable
Calculating Net Current Assets
Evaluating the Overall Assets
Profit before Tax and Exceptional Items
Optimizing Increase in Inventory
Determining the Interest Paid
Sale of Investments
Effects of Exchange Rates
Earnings per Share
Valuing Debt to Equity
Calculating the Valuation Ratios
Dividend Payout and Dividend Yield
Compounded Annual Growth Rate
Calculating Target Rate for Particular Stock