How to Calculate a Model in Excel. Mathematical models are a way to attempt to predict the probable outcome of a complex situation. From climate, stock market and physics models, ...