Rating 3.88 out of 5 (8 ratings in Udemy)
What you'll 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 …
Rating 3.88 out of 5 (8 ratings in Udemy)
What you'll 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
DescriptionThe 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.
