There are a few critical assumptions about ... which can help make certain investment decisions. A linear regression model can be created in Excel to make the process simpler.