Introduction To Financial Modelling: How to Excel at Being a Lazy (That Means Efficient!) Modeller

by Liam Bastick

Overview

If you've had little formal training in financial forecasting with Excel or have ever burnt the midnight oil trying to get a balance sheet to balance, this book is for you. A simple walk-through of the common perils and pitfalls of financial modelling, this book offers a solid foundation. Taking little for granted, Liam Bastick 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 that creates a simple financial model from scratch to highlight the key concepts, this is a hands-on book to help 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.

Product Details

ISBN-13:	9781615471522
Publisher:	Holy Macro! Books
Publication date:	04/01/2020
Sold by:	INDEPENDENT PUB GROUP - EPUB - EBKS
Format:	eBook
Pages:	324
File size:	17 MB
Note:	This product may take a few minutes to download.

About the Author

Founder of consulting firm SumProduct, Liam Bastick has more than twenty-five years' experience in corporate finance, accounting, financial analysis, and forecasting.

Table of Contents

Introduction Key Excel Functions Key Excel Functionalities Best Practice Methodology Layout Tips Time Series Analysis Error Checks Model Template Example Financial Statement Theory Control Accounts Example Model Build Self-Review Ratio Analysis