MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Continuing Financial Modelling


November 2020

Continuing Financial Modelling

Working Those Optimal Figures for the Modelling Industry (Financial Modelling)

Dr. Liam Bastick’s sequel to Introduction to Financial Modelling.

Bill Jelen, MrExcel

category: Excel
covers: Excel 2013, Excel 2016, Excel 2019, Office 365

Product Details
  • Paperback: 402 pages
  • Publisher Holy Macro! Books
  • Print ISBN: 978-1-61547-068-6
  • eBook ISBN: 978-1-61547-152-2

IT’S JUST LIKE WAITING FOR A BUS.

You wait for one decent Financial Modelling book to come out and then two come along at once. This edition 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 volume begins where the other ends, considering typical issues and traps in cashflow forecasting, inventory modelling, depreciation calculations, debt sculpting, rolling budgets / charts, and valuation construction, to name just a few relevant topics.

This is not so much the sequel to Liam’s first sortie into the world of financial modelling, as the continuing reconnaissance mission. This book continues the theme of pragmatic – not theoretical – tips, tricks and ideas about how to build a financial model, with over 40 large scale and numerous smaller Excel examples.

Delivered in Liam’s inimitable style, be warned: the humour remains terrible. Find out why so many readers have said, “Oh, I wish I had kept the receipt”.

  • Chapter 0: Not an Introduction, But a Continuation
  • Chapter 1: Recap

    • 1.1: Best Practice Concept
    • 1.2: Time Series Analysis
    • 1.3: Financial Statement Theory
    • 1.4: Control Accounts
  • Chapter 2: What-If? Analysis

    • 2.1: Conditional Formulae
    • 2.2: Offset
    • 2.3: Scenario Analysis
    • 2.4: Data Tables
    • 2.5: Index and Match
    • 2.6: Using Tornado Charts for Sensitivity Analysis
    • 2.7: Simulations Analysis
    • 2.8: Variance Analysis
    • 2.9: Breakeven Analysis
  • Chapter 3: Forecasting Considerations

    • 3.1: Seasonal / Cyclical Forecasting
    • 3.2: Revising Forecasts
    • 3.3: Pro-Rating Forecasts Over Time
    • 3.4: Changing Periodicities
    • 3.5: Modelling Historical, Actual and Forecast Data
    • 3.6: Rolling Budgets and Charts
    • 3.7: Forecasting Maximum Cash Required
  • Chapter 4: Modelling Inventory
  • Chapter 5: Capital Expenditure
  • Chapter 6: Debt

    • 6.1: Debt Sculpting
    • 6.2: Calculating Interest Rates Correctly
    • 6.3: Useful Repayment Functions and Formulae
  • Chapter 7: Valuation Considerations

    • 7.1: Deriving the Correct Cash Flow For DCF
    • 7.2: Considering Discount Factors
    • 7.3: Common DCF Modelling Errors
    • 7.4: Using the Dividend Discount Model
    • 7.5: Irrelevant IRR
    • 7.6: Modified Internal Rate of Return (MIRR)
    • 7.7: Smoothing Capital Expenditure
    • 7.8: Calculating Economic Lives
  • Chapter 8: Linking Models
  • Chapter 9: Life’s Too Short

    • 9.1: Section Numbering
    • 9.2: US vs. European Dates
    • 9.3: Sheet Referencing
    • 9.4: Reducing File Size
    • 9.5: Taking It to the Limit
    • 9.6: Order of Operations
    • 9.7: Keeping Styles Under Control
    • 9.8: Wearing Protection
  • Chapter 10: Look To The Future

    • 10.1: Dynamic Arrays
    • 10.2: XLOOKUP and XMATCH
    • 10.3: Let It Be
    • 10.4: New Data Types
  • Resources

Where to Buy

MrExcel Bookstore

Print book from MrExcel.

Buy Now »

Other Editions

  • Introduction to Financial Modelling
    Introduction to Financial Modelling

    October 2019

    With over 50 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, focused on working with Excel more efficiently and effectively.