Regression Analysis in Financial Modeling
Financial modeling regression analysis refers to the use of single or multivariable regression to help forecast the key assumptions that will drive a company’s performance in the future. Regression can be performed in Excel using the Data -> Data Analysis -> Regression Analysis. Note: in order to use the feature you must go to Excel Options, then Add-Ins, and select Data Analysis Tool Pack. Performing this type of analysis is covered in CFI’s budgeting and forecasting course.