Spreadsheets for Finance and Accounting
Income Statement Input
Balance Sheet Input
Cash Flow Statement Input
Data Consistency Checks
Source Documentation
Debt Schedule Construction
Interest Calculation Methods
Depreciation Schedule Building
Working Capital Analysis
Tax Schedule Development
Revenue Projection Methods
Cost of Goods Sold Modeling
Operating Expense Forecasting
Interest Expense Calculation
Tax Provision Modeling
Earnings Per Share Calculation
Current Asset Projections
Fixed Asset Modeling
Current Liability Forecasting
Long-Term Debt Projections
Equity Account Modeling
Balance Sheet Balancing
Operating Cash Flow Derivation
Investing Activity Modeling
Financing Activity Projection
Cash Balance Reconciliation
Free Cash Flow Calculation
Linking Mechanisms
Circular Reference Resolution
Error Check Implementation
Model Testing Procedures
Previous
6. Financial Model Design Principles
Go to top
Next
8. Valuation Modeling Techniques