Spreadsheets for Finance and Accounting

  1. Three-Statement Financial Modeling
    1. Historical Data Setup
      1. Income Statement Input
        1. Balance Sheet Input
          1. Cash Flow Statement Input
            1. Data Consistency Checks
              1. Source Documentation
              2. Supporting Schedule Development
                1. Debt Schedule Construction
                  1. Interest Calculation Methods
                    1. Depreciation Schedule Building
                      1. Working Capital Analysis
                        1. Tax Schedule Development
                        2. Income Statement Forecasting
                          1. Revenue Projection Methods
                            1. Cost of Goods Sold Modeling
                              1. Operating Expense Forecasting
                                1. Interest Expense Calculation
                                  1. Tax Provision Modeling
                                    1. Earnings Per Share Calculation
                                    2. Balance Sheet Forecasting
                                      1. Current Asset Projections
                                        1. Fixed Asset Modeling
                                          1. Current Liability Forecasting
                                            1. Long-Term Debt Projections
                                              1. Equity Account Modeling
                                                1. Balance Sheet Balancing
                                                2. Cash Flow Statement Construction
                                                  1. Operating Cash Flow Derivation
                                                    1. Investing Activity Modeling
                                                      1. Financing Activity Projection
                                                        1. Cash Balance Reconciliation
                                                          1. Free Cash Flow Calculation
                                                          2. Statement Integration
                                                            1. Linking Mechanisms
                                                              1. Circular Reference Resolution
                                                                1. Error Check Implementation
                                                                  1. Model Testing Procedures

                                                                Previous

                                                                6. Financial Model Design Principles

                                                                Go to top

                                                                Next

                                                                8. Valuation Modeling Techniques