Spreadsheets for Finance and Accounting

  1. Valuation Modeling Techniques
    1. Discounted Cash Flow Analysis
      1. Free Cash Flow Calculation
        1. Terminal Value Estimation
          1. Discount Rate Determination
            1. Present Value Calculations
              1. Enterprise Value Derivation
                1. Equity Value Calculation
                  1. Sensitivity Analysis
                  2. Comparable Company Analysis
                    1. Peer Group Selection
                      1. Multiple Calculations
                        1. Valuation Range Development
                          1. Premium and Discount Analysis
                          2. Precedent Transaction Analysis
                            1. Transaction Selection Criteria
                              1. Transaction Multiple Calculation
                                1. Control Premium Analysis
                                  1. Market Condition Adjustments

                                Previous

                                7. Three-Statement Financial Modeling

                                Go to top

                                Next

                                9. Budgeting and Forecasting Models