UsefulLinks
Business and Management
Finance and Accounting
Accounting
Spreadsheets for Finance and Accounting
1. Spreadsheet Environment and Setup
2. Data Entry and Basic Formatting
3. Formula Fundamentals
4. Essential Financial Functions
5. Data Organization and Management
6. Financial Model Design Principles
7. Three-Statement Financial Modeling
8. Valuation Modeling Techniques
9. Budgeting and Forecasting Models
10. Advanced Analysis Tools
11. Data Analysis and Visualization
12. Professional Reporting
7.
Three-Statement Financial Modeling
7.1.
Historical Data Setup
7.1.1.
Income Statement Input
7.1.2.
Balance Sheet Input
7.1.3.
Cash Flow Statement Input
7.1.4.
Data Consistency Checks
7.1.5.
Source Documentation
7.2.
Supporting Schedule Development
7.2.1.
Debt Schedule Construction
7.2.2.
Interest Calculation Methods
7.2.3.
Depreciation Schedule Building
7.2.4.
Working Capital Analysis
7.2.5.
Tax Schedule Development
7.3.
Income Statement Forecasting
7.3.1.
Revenue Projection Methods
7.3.2.
Cost of Goods Sold Modeling
7.3.3.
Operating Expense Forecasting
7.3.4.
Interest Expense Calculation
7.3.5.
Tax Provision Modeling
7.3.6.
Earnings Per Share Calculation
7.4.
Balance Sheet Forecasting
7.4.1.
Current Asset Projections
7.4.2.
Fixed Asset Modeling
7.4.3.
Current Liability Forecasting
7.4.4.
Long-Term Debt Projections
7.4.5.
Equity Account Modeling
7.4.6.
Balance Sheet Balancing
7.5.
Cash Flow Statement Construction
7.5.1.
Operating Cash Flow Derivation
7.5.2.
Investing Activity Modeling
7.5.3.
Financing Activity Projection
7.5.4.
Cash Balance Reconciliation
7.5.5.
Free Cash Flow Calculation
7.6.
Statement Integration
7.6.1.
Linking Mechanisms
7.6.2.
Circular Reference Resolution
7.6.3.
Error Check Implementation
7.6.4.
Model Testing Procedures
Previous
6. Financial Model Design Principles
Go to top
Next
8. Valuation Modeling Techniques