45+ Lessons
0 students enrolled
Instructor
0 (0)
Importance of Financial Analysis
Installation of Microsoft Excel 2021
Excel tools for Financial Analysis
Data Entry and Formatting
Excel Navigation and Basic Functions
Excel References
Basic Formulas and Functions
Data Validation and Error Handling
Understanding the Time Value of Money
Present and Future Value Calculations
Excel Functions for TVM (NPV, IRR)
Using Data Tables for Sensitivity
Requirement of a Financial Model
Drafting Assumption for Financial Model
Creating Financial Model Templates
Balance Sheet Analysis
Balance Sheet Analysis 2
Income Statement Analysis
Cash Flow Statement Analysis
Ratio Analysis
Sales and Revenue Forecasting
Expense Forecasting
Scenario Analysis and Goal seeking
Creating Budgets and Projections 01
Creating Budgets and Projections 02
Creating Budgets and Projections 03
Introduction to Valuation
Discounted Cash Flow (DCF) Valuation
Comparable Company Analysis (CCA)
Excel Models for Valuations
Capital Budgeting and Investment Appraisal
Payback Period, NPV and IRR for Investment Decisions
Risk Analysis and Monte Carlo Simulation
Real Options in Investment Analysis
Creating Financial Charts and Graphs
Data Tables and PivotTables for Analysis
Dashboard Design for Financial Reporting
Introduction to Profit & Loss (P & L) Statement
Overview of the P & L and its significance in Financial analysis
Components of P & L statement
Reading and Analysis P & L statements in Excel
Introduction to Loan Repayment
Types of loans – Amortizing vs Interest only
Building an amortization table using Excel
Demonstrations, Calculations and others
50 Students
29 Courses
51 Reviews
Username or Email Address
Password
Remember Me
Sign In
Enrolled: 0 Students
Duration: Not specified
Chapters: 45+ Lessons
Level: All Level
Maximum Students: 0