Financial Modelling & Valuations
4.8 /5- Offered byJobaaj Learnings
Financial Modelling & Valuations at Jobaaj Learnings Overview
Duration | 40 hours |
Total fee | ₹9,999 |
Mode of learning | Online |
Credential | Certificate |
Financial Modelling & Valuations at Jobaaj Learnings Highlights
- Certificate of completion
- Full lifetime access
- 40 articles
- 40 Hours 31 Mins on-demand video
Financial Modelling & Valuations at Jobaaj Learnings Course details
- This programme will help learner to create financial models, use such models for funding proposals, credit rating or business valuation and take decisions by analyzing such models
Financial Modelling & Valuations at Jobaaj Learnings Curriculum
LESSON 1
Introduction to Financial Modelling & Valuation
Learning Resources (Presentations & Worksheets)
Introduction to Financial Modelling & Valuation
Ms Excel : Basic To Advance
Excel Interface, Basic shortcuts, Navigation keys, Manipulating worksheets & Modifying rows/columns/cells
Entering data, Name Manager, Go To, Trace Precedents & Dependents, Quick Access Shortcuts
Fomatting Tools
Custom Cell Formats, Paste Special, Transpose, Hyperlink
Sorting & Filtering, Table & its Features, Importing data, Grouping & Hiding, Data Validation
Printing setup, Text-to-columns, Math Functions, SUMPRODUCT, Date functions
Text functions, Flash Fill, Consolidate
Conditional Formatting, IF Functions/AND/OR
CHOOSE, SUBTOTAL
Pivot Table
HLOOKUP, INDEX, MATCH, OFFSET
VLOOKUP, DGET
Goal Seek, Data Table, Scenario Manage
FORECAST, TREND, GROWTH, Wild Card Characters, Error Types, Error Checks
VBA & Macros, Solver
Interactive Charts
Corporate Finance
Time Value of Money Part - I
Time Value of Money Part - 2
Capital Budgeting Part- I
Capital Budgeting Part- II
Cost of Capital
Equity Valuation Part- I
Equity Valuation Part- II
Financial Statement Analysis
Financial Statements : Basics
Cash Flow Statement + Other Concepts
Depreciation Methods + Working Capital
Working Capital + DuPont Analysis
Ratio Analysis + Common Sizing
Construction of Financial Models
Financial Modelling Process
Project Finance Model Part - I
Project Finance Model Part - II
Project Finance Model Part - III
Project Finance Model Part - IV
DCF Model Part - I
DCF Model Part - II
DCF Model Part - III
Comparables Valuation Model – I
Comparables Valuation Model – II
Other courses offered by Jobaaj Learnings
Student Forum
Anything you would want to ask experts?