UsefulLinks
Business and Management
Finance and Accounting
Corporate Finance
Financial Modeling and Valuation
1. Introduction to Financial Modeling and Valuation
2. Foundational Concepts
3. Spreadsheet Skills for Financial Modeling
4. Building a Three-Statement Financial Model
5. Valuation Methodologies
6. Advanced Modeling and Analysis
7. Model Validation and Quality Control
8. Finalizing and Presenting the Analysis
3.
Spreadsheet Skills for Financial Modeling
3.1.
Best Practices in Excel
3.1.1.
Formatting Conventions
3.1.1.1.
Color Coding System
3.1.1.1.1.
Input Cells
3.1.1.1.2.
Calculation Cells
3.1.1.1.3.
Output Cells
3.1.1.2.
Font and Style Consistency
3.1.1.3.
Cell Borders and Shading
3.1.2.
Structuring Worksheets
3.1.2.1.
Separation of Inputs, Calculations, Outputs
3.1.2.2.
Logical Sheet Organization
3.1.2.3.
Navigation Structure
3.1.3.
Formula Best Practices
3.1.3.1.
Avoiding Hard-Coding in Calculations
3.1.3.2.
Centralizing Assumptions
3.1.3.3.
Formula Consistency
3.1.4.
Naming Conventions
3.1.4.1.
Named Ranges
3.1.4.2.
Cell Naming
3.1.4.3.
Sheet Naming
3.2.
Essential Functions and Formulas
3.2.1.
Basic Mathematical Operations
3.2.1.1.
Arithmetic Operators
3.2.1.2.
Order of Operations
3.2.2.
Logical Functions
3.2.2.1.
IF Statements
3.2.2.2.
Nested IF Statements
3.2.2.3.
AND Function
3.2.2.4.
OR Function
3.2.3.
Lookup Functions
3.2.3.1.
VLOOKUP
3.2.3.2.
HLOOKUP
3.2.3.3.
INDEX Function
3.2.3.4.
MATCH Function
3.2.3.5.
INDEX-MATCH Combinations
3.2.4.
Statistical Functions
3.2.4.1.
SUM and SUMIF
3.2.4.2.
COUNT and COUNTA
3.2.4.3.
AVERAGE Functions
3.2.5.
Advanced Analysis Tools
3.2.5.1.
Data Tables for Sensitivity Analysis
3.2.5.2.
Goal Seek
3.2.5.3.
Solver
3.2.5.4.
Scenario Manager
3.3.
Keyboard Shortcuts for Efficiency
3.3.1.
Navigation Shortcuts
3.3.2.
Formula Entry Shortcuts
3.3.3.
Formatting Shortcuts
3.3.4.
Selection and Editing Shortcuts
3.3.5.
Auditing Shortcuts
Previous
2. Foundational Concepts
Go to top
Next
4. Building a Three-Statement Financial Model