Kirjahaku

A simple walk-through of the common perils and pitfalls of financial modelling, this book examines the most common and necessary Excel functions, emphasizes the importance of a standardized and functional layout, explains accounting concepts simply, and reinforces four key concepts of best practice: consistency, robustness, flexibility, and transparency—CraFT. With more than fifty examples and an extended case study, this hands-on book helps users work with Excel more efficiently and effectively. This simple methodology has been adopted by many seasoned professionals who no longer must resort to balancing figures, circulars, and macros.

This book is aimed at those who wish to advance their knowledge and expertise in financial modelling by addressing common problems that occur day to day in the world of business/decision analyses, forecasting, and valuations. Building on the sister book, An Introduction to Financial Modelling, this book begins where the other ends considering typical issues and traps in cashflow forecasting, inventory modelling, depreciation calculations, debt sculpting, rolling budgets and charts, and valuation construction, to name just a few relevant topics.

RAISING ARRAYS FOR MODELLINGThis book tries hard to raze a laugh (yes, that’ s what was meant… ). Instead, 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!