And Then There Were Five…

SumProduct is proud to announce two new books in the Financial Modelling series.  Just like buses, you wait and wait, and then two turn up at once!

To add to Introduction to Financial Modelling, Continuing Financial Modelling and Financial Modelling in Power BI, please welcome two new upstarts to the series:

1.     Financial Modelling for Project Finance (Liam Bastick with Oscar Hagan):

If you have a beginner's grasp in accounting, finance and Excel, you might be tempted to explore the quantitative, decision-centric world of Project Finance, ring-fencing funding for profitable projects.

This book seeks to demystify the area and show how the basic principles of financial modelling, first heralded in Introduction to Financial Modelling, may be applied and modified here.  

The book explains "Project Finance" and how it differs from "project finance" at the outset. It then provides various Excel pointers on Excel's key functions and features, before crafting together the salient points of "Best Practice" modelling.

This book is practical: it provides numerous examples including a full case study showing how to model Project Finance, separating the concepts (and modelling) of construction and operations, including delivering a Cash Flow Waterfall, Sources and Uses of Funds, various valuation techniques, plus demonstrating how to create scenario, sensitivity and ratio analyses

2.     Financial Modelling using Dynamic Arrays (Liam Bastick):

Through numerous examples and case studies, it details the impact of the ecosystem introduced by dynamic arrays in Excel, injecting life into the jaded, stale world of financial modelling. From comparing the old methodologies to the new frontiers, this book considers how dynamic arrays have reshaped Excel and made it Turing complete, with its liberal use of LET, LAMBDA, eta lambdas et al.

LET invites complexity but reduces memory requirements, LAMBDA allows you to build anything, and dynamic arrays make it easy to quite literally extend your ideas and your way of thinking.  See for yourself.

Through a dynamic array of Best Practice tips, tricks, functions and features, Financial Modelling using Dynamic Arrays shows you how to revamp and reinvent your financial models with Excel 365.  Recreate your development kit in this brave new world.  Erase the old and embrace the arrays!

For regular and ad hoc readers, each book is a standalone tome and does not require you to read earlier vignettes.  There is a little repetition to set the scene, but we thought this was the better alternative than put it all in one 3,000-page book! 

Watch out for Number Six, hopefully out later this year: it won’t be a “Prisoner” for long as we introduce AI into the foray!

You can find these books both physically and electronically from all good bookshops, including Amazon.  If it’s not available at your bookshop, well…

As always, we'll be detailing these updates in our February newsletter.  Please remember we have virtual / online training in Excel which you can find out more about here.  If you are not already a subscriber, why not sign up at the bottom of any SumProduct web page?