When Adam West first contacted me to tell me he could build a financial model in Excel, using the new array formulas, in 30 minutes, I thought it would make a great challenge! Even though the build took closer to an hour, I thought it was a great example of how some new formulas can be incorporated into financial models. Learn more about financial modelling at