Understanding Financial Analysis and Forecasting Techniques

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 deteation using Excel Table and Charts

The basic requirements for this Course are Basic Knowledge of Microsoft Excel and Basic knowledge of Accounting and Finance (Financial Statements)

The course is developed with the Microsoft Excel, Version 2016.

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



DOWNLOAD
uploadgig


rapidgator


nitroflare