Financial Modelling and Forecast Techniques using Excel Tool

Financial Modelling and Forecast Techniques using Excel Tool, available at $49.99, has an average rating of 3.5, with 65 lectures, 11 quizzes, based on 11 reviews, and has 63 subscribers.

You will learn about Introduction to Excel Functions for Financial Analysis and Modelling Understanding Financial Modelling worst and best practices Understanding types of Financial Models used in Corporate Finance and Investment banking Financial Analysis using Microsoft Excel Building Financial Statements from raw data Understanding Cost of Capital Calculation Understand Business and Financial Forecasting Capital Budgeting Techniques using Linear and Integer Programming Tools Project Evaluation Techniques using NPV, IRR, Profitability index, Pay Back Period, MIRR and XIRR methods Understanding Financial Ratio Analysis Calculating Return on Equity using the Du Pont Analysis method Introducing the 3- Financial Statements use in Modelling and Forecasting to Non-Accountants Forecasting Income Statement, Balance Sheet, Cash Flow Statement using Forecast assumptions, drivers and schedules (Depreciation and Debt – Interest Schedules) Break Even Analysis and Profit determination using Excel Table and Charts This course is ideal for individuals who are Accountants, Data Analyst, Financial Analyst, Corporate Finance manager, Investment Bankers and anyone who is interested in building financial statement and forecasting them. It is particularly useful for Accountants, Data Analyst, Financial Analyst, Corporate Finance manager, Investment Bankers and anyone who is interested in building financial statement and forecasting them.

Enroll now: Financial Modelling and Forecast Techniques using Excel Tool

Summary

Title: Financial Modelling and Forecast Techniques using Excel Tool

Price: $49.99

Average Rating: 3.5

Number of Lectures: 65

Number of Quizzes: 11

Number of Published Lectures: 65

Number of Published Quizzes: 11

Number of Curriculum Items: 76

Number of Published Curriculum Objects: 76

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Introduction to Excel Functions for Financial Analysis and Modelling

Understanding Financial Modelling worst and best practices

Understanding types of Financial Models used in Corporate Finance and Investment banking

Financial Analysis using Microsoft Excel

Building Financial Statements from raw data

Understanding Cost of Capital Calculation

Understand Business and Financial Forecasting

Capital Budgeting Techniques using Linear and Integer Programming Tools

Project Evaluation Techniques using NPV, IRR, Profitability index, Pay Back Period, MIRR and XIRR methods

Understanding Financial Ratio Analysis

Calculating Return on Equity using the Du Pont Analysis method

Introducing the 3- Financial Statements use in Modelling and Forecasting to Non-Accountants

Forecasting Income Statement, Balance Sheet, Cash Flow Statement using Forecast assumptions, drivers and schedules (Depreciation and Debt – Interest Schedules)

Break Even Analysis and Profit determination using Excel Table and Charts

Who Should Attend

Accountants, Data Analyst, Financial Analyst, Corporate Finance manager, Investment Bankers and anyone who is interested in building financial statement and forecasting them.

Target Audiences

Accountants, Data Analyst, Financial Analyst, Corporate Finance manager, Investment Bankers and anyone who is interested in building financial statement and forecasting them.

The Financial Modelling and Forecasting Techniques is designed to help accountants and finance people to understand how they can use the Microsoft Excel application to analyze and forecast financial statements, understand how to calculate cost of capital, make business decisions, use financial functions, evaluate projects or business, understanding capital budgeting techniques, compute financial ratios, apply ratios to financial statement and derive accurate answers from their analysis that would aid their business decision making process.  The course is developed with the Microsoft Excel, Version 2016.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction – Welcome

Lecture 2: Introduction to Excel Function for Financial Modelling

Lecture 3: Introduction to Financial Modelling

Lecture 4: Understanding Financial Modelling Types

Chapter 2: BREAKEVEN ANALYSIS

Lecture 1: Understanding Breakeven Analysis and purpose – Presentation

Lecture 2: Breakeven Analysis – Practical (exercise file included)

Chapter 3: SENSITIVITY ANALYSIS (USING EXCEL WHAT-IF-ANALYSIS TOOLS)

Lecture 1: Understanding Sensitivity Analysis – Presentation

Lecture 2: Sensitivity Test using Goal Seek

Lecture 3: Sensitivity Test using Data Input Table

Lecture 4: Sensitivity Analysis using Solver Tools

Lecture 5: Performing Scenarios Analysis using Scenario Manager

Chapter 4: BUSINESS AND FINANCIAL FORECASTING TECHNIQUES

Lecture 1: Understanding Forecasting Functions – Presentation

Lecture 2: Working with FORECAST Function

Lecture 3: Working with FORECAST.LINEAR Function

Lecture 4: Understanding GROWTH Function – Presentation

Lecture 5: Working with the GROWTH Function

Lecture 6: Understanding the TREND Function – Presentation

Lecture 7: Working with the TREND Function

Lecture 8: Understanding the Coefficient of Determination (R^2) – Presentation

Lecture 9: Calculating the Coefficient of Determination in a Regression Analysis

Chapter 5: UNDERSTANDING COST OF CAPITAL CALCULATIONS

Lecture 1: Understanding Cost of Capital and Calculations – Presentation

Lecture 2: Understanding the Cost of Equity Calculation – Presentation

Lecture 3: Cost of Equity Calculation – Practical session

Lecture 4: Capital Asset Pricing Model – Risk F-Rate, Beta, & Estimated Market Risk – Calc

Lecture 5: Understanding the Cost of Debt – Presentation

Lecture 6: Cost of Debt Calculation

Lecture 7: Understanding Weighted Average Cost of Capital (WACC) – Presentation

Lecture 8: Weighted Average Cost of Capital Calculation

Chapter 6: CAPITAL BUDGETING TECHNIQUES USING LINEAR & INTEGER PROGRAMMING METHOD

Lecture 1: Understanding Capital Budgeting Techniques using Linear Program – Presentation

Lecture 2: Solving Investment Problem – Linear programming Method

Lecture 3: Solving Multi-Period, multi-Investment Cash flow Problem

Lecture 4: Solving Capital Rationing Problem – Using Integer Programming

Lecture 5: Cost Minimization using Integer programming approach

Lecture 6: Solving Product mix and profit Maximization Problem

Chapter 7: PROJECT EVALUATION TECHNIQUES (NPV, IRR, PI, PBP)

Lecture 1: Project Evaluation Techniques – Presentation

Lecture 2: Calculating Time Value of Money – Future Value – Using Formulas

Lecture 3: Estimating Time Value of Money – Present Value – using Formulas

Lecture 4: Using the PV Function for Present Value Calculation

Lecture 5: Using the FV Function for Future Value Calculation

Lecture 6: Using Pay Back Period Method for Project Evaluation

Lecture 7: Evaluating Project using NPV, IRR Function

Lecture 8: Using XIRR Function Method for Internal Rate of Return estimation

Lecture 9: Calculating NPV for mutually Exclusive project

Lecture 10: Using MIRR Function Method for Internal Rate of Return

Lecture 11: Investment Criteria using PBP, IRR etc

Chapter 8: PERFORMING RATIO ANALYSIS USING MICROSOFT EXCEL

Lecture 1: Understanding Financial Ratios Analysis – Presentation

Lecture 2: Financial Ratios calculations in Excel

Lecture 3: Common Size Statements (Analysis) – Presentation

Lecture 4: Common Size Statements Analysis in Excel

Lecture 5: Understanding Du Pont Analysis – Presentation

Lecture 6: Du Pont Analysis – Return on Equity Calculations

Chapter 9: UNDERSTANDING FINANCIAL STATEMENTS – FOR NON-ACCOUNTANTS

Lecture 1: Financial Statements for Non-Accountants

Lecture 2: The Balance Sheet Statement

Lecture 3: The Income Statement

Lecture 4: The Cash Flow Statement

Lecture 5: The 3-Financial Statements Related

Lecture 6: Building Income Statement from Scratch

Lecture 7: Building Balance Sheet from Scratch

Chapter 10: THE THREE (3) STATEMENTS FINANCIAL MODELLING AND FORECASTING

Lecture 1: Building 3-Statement model and forecasting – Part 1

Lecture 2: Building 3-Statement model and forecasting – Part 2

Lecture 3: Building 3-Statement model and forecasting – Part 3

Lecture 4: Building 3-Statement model and forecasting – Part 4

Lecture 5: Building 3-Statement model and forecasting – Part 5

Lecture 6: Building 3-Statement model and forecasting – Part 6

Lecture 7: Building 3-Statement model and forecasting – Part 7

Instructors

Abraham Eninla
CEO at Lead Vision Concepts

Rating Distribution

1 stars: 0 votes

2 stars: 3 votes

3 stars: 3 votes

4 stars: 1 votes

5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!