In Excel, one can multiple a matrix by itself (using the MMULT function), and hence raise a matrix to any power by repeated calculations. However, there is no function to calculate partial powers (e.g. square roots) of matrices. In this blog, we describe one useful way to do so.
Archives for October 2017
Recently I had the pleasure to visit Hanoi, Vietnam, to run a course on the economic evaluation of projects, taking into account the risks and uncertainties inherent in the projects. The course was built around a fully integrated hands-on exercise in which a project was evaluated using a realistic financial model which took into account the key uncertainties across the full life cycle.