Financial Modelling and Forecast Techniques using Excel Tool
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Understanding Financial Analysis and Forecasting TechniquesDescription
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.
Requirements
- Requirements
- The basic requirements for this Course are Basic Knowledge of Microsoft Excel and Basic knowledge of Accounting and Finance (Financial Statements)
Knowledge
- 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
- Modelling and Forecasting the Income Statement, Balance Sheet, and 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
Financial Modelling Workshop
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Build your own financial model using tried and tested best practice modelling techniques This is an introductory financial modelling workshop covering the modules listed below....
Build A Financial Forecasting Model for your next Startup
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Build a Dynamic Financial Model to forecast Business Performance and Cashflow required for Startup or existing business Welcome the course: Build A Financial Forecasting Model for your next Startup...
Financial Modelling and Forecast Techniques using Excel Tool
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Understanding Financial Analysis and Forecasting Techniques The course is developed with the Microsoft Excel, Version 2016. Introduction to Excel Functions for Financial Analysis and Modelling...
