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.
CFI is the official global provider of financial modeling and valuation analyst FMVA Designation. CFI's mission is to help anyone become a world-class financial analyst and has a wide range of resources to help you along the way. In order to become a great financial analyst, below are some additional questions and answers for you to explore further:
Below is a screenshot from one of CFI’s online analyst training and certification courses, offered 100% online.
To learn How to Build an Excel Model step-by-step, click on the image below.