Financial Modeling | It Sector : Ibm

Learn projections, financial modeling, forecasting and valuation techniques for IT 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 IT sector. We have taken the company IBM 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 Financial Modeling Overview

Lecture 2 Learning Path

Lecture 3 What is Financial Modeling

Lecture 4 Why Assumptions are important

Lecture 5 Understanding of Financial Model

Lecture 6 What are Financial Models Used for

Lecture 7 Cash Flow Forecasting

Lecture 8 Who Uses Financial Models

Lecture 9 Different Types of Financial Models

Lecture 10 Balance Sheet Structure

Lecture 11 Best Practices to follow when Creating Financial Models

Section 2: Building Financial Model

Lecture 12 How do you Build your Model

Lecture 13 Cash Flow Statement

Lecture 14 How do you Build a Forecast in your Model

Lecture 15 Pictorial Representation

Lecture 16 Balance Sheet

Lecture 17 3 Statement Model

Lecture 18 Creating a Financial Calculator

Section 3: Building Financial Model Continue

Lecture 19 Add Inputs to the General Assumption Tab

Lecture 20 Add Inputs to the Balance Sheet

Lecture 21 Create Forward Assumption

Lecture 22 Calculate Projections for Income Statement

Lecture 23 Calculating the Opening Debt

Lecture 24 Populate Net Assets in the Balance Sheet

Lecture 25 Calculate Defered Tax Liability in Balance Sheet

Section 4: IBM Model

Lecture 26 Management Discussion

Lecture 27 IBM Financial Modelling

Lecture 28 Operating Expenses

Lecture 29 Accounts Payable

Lecture 30 Calculating the Year

Lecture 31 Depreciation and Amortization

Lecture 32 populating Numbers in the Income Statement

Lecture 33 Actual Income Statement

Lecture 34 Advance Model

Lecture 35 Pension Costs Coming in

Lecture 36 Amortization of Intangibles

Lecture 37 Finding Income Statement

Lecture 38 Income from Continuing Operation

Section 5: Discounted Cash Flow

Lecture 39 Discounted Cash Flow

Lecture 40 Calculating Ebit

Lecture 41 Long Term Debt

Lecture 42 Adjusted Equity Value

Business and finance practitioners who are eager to improve their Excel and Financial Modeling skills,Graduates/Post Graduates/CA/CFA,Financial Analysts/ Managers who want to expand on the current set of skills