Some things you get better at with practice; some you need to get right first time (like skydiving). Like an '80's movie, this is for Readers of the Lost Art: 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. Author Liam Bastick continues to write in his own inimitable style, explaining why you should model in a particular way, not just how. This is an essential book for every financial modelling practitioner and would-be Excel guru.
Author(s): Liam Bastick
Publisher: Holy Macro! Books
Year: 2020
Language: English
Pages: 352
City: Melbourne
_Hlk29216758
_Hlk29216925
_Hlk28597987
_Hlk28603126
_Hlk517716138
About the Author
Preface
Editor’s notes
Downloadable Resources
Chapter 0: Not an Introduction, But a Continuation
Chapter 1: Recap
Chapter 1.1: Best Practice Concept
Chapter 1.2: Time Series Analysis
CHAPTER 1.3: FINANCIAL STATEMENT THEORY
CHAPTER 1.4: CONTROL ACCOUNTS
Chapter 2: What-If? Analysis
Chapter 2.1: Conditional Formulae
CHAPTER 2.2: OFFSET
CHAPTER 2.3: SCENARIO ANALYSIS
CHAPTER 2.4: DATA TABLES
CHAPTER 2.5: INDEX and MATCH
CHAPTER 2.6: USING TORNADO CHARTS FOR SENSITIVITY ANALYSIS
CHAPTER 2.7: SIMULATIONS ANALYSIS
CHAPTER 2.8: VARIANCE ANALYSIS
CHAPTER 2.9: BREAKEVEN ANALYSIS
Chapter 3: Forecasting Considerations
CHAPTER 3.1: SEASONAL / CYCLICAL FORECASTING
CHAPTER 3.2: REVISING FORECASTS
CHAPTER 3.3: PRO-RATING FORECASTS OVER TIME
CHAPTER 3.4: CHANGING PERIODICITIES
Aggregating Time Periods
CHAPTER 3.5: MODELLING HISTORICAL, ACTUAL AND FORECAST DATA
CHAPTER 3.6: ROLLING BUDGETS AND CHARTS
CHAPTER 3.7: FORECASTING MAXIMUM CASH REQUIRED
Chapter 4: Modelling Inventory
Chapter 5: Capital Expenditure
Chapter 6: Debt
CHAPTER 6.1: DEBT SCULPTING
CHAPTER 6.2: CALCULATING INTEREST RATES CORRECTLY
CHAPTER 6.3: USEFUL REPAYMENT FUNCTIONS AND FORMULAE
Chapter 7: Valuation Considerations
CHAPTER 7.1: DERIVING THE CORRECT CASH FLOW FOR DCF
CHAPTER 7.2: CONSIDERING DISCOUNT FACTORS
CHAPTER 7.3: COMMON DCF MODELLING ERRORS
CHAPTER 7.4: USING THE DIVIDEND DISCOUNT MODEL
CHAPTER 7.5: IRRELEVANT IRR
CHAPTER 7.6: MODIFIED INTERNAL RATE OF RETURN (MIRR)
CHAPTER 7.7: SMOOTHING CAPITAL EXPENDITURE
CHAPTER 7.8: CALCULATING ECONOMIC LIVES
Chapter 8: Linking Models
Chapter 9: Life’s Too Short
CHAPTER 9.1: SECTION NUMBERING
CHAPTER 9.2: US vs. EUROPEAN DATES
CHAPTER 9.3: SHEET REFERENCING
CHAPTER 9.4: REDUCING FILE SIZE
CHAPTER 9.5: TAKING IT TO THE LIMIT
CHAPTER 9.6: ORDER OF OPERATIONS
CHAPTER 9.7: KEEPING STYLES UNDER CONTROL
CHAPTER 9.8: WEARING PROTECTION
Chapter 10: Look To The Future
CHAPTER 10.1: DYNAMIC ARRAYS
CHAPTER 10.2: XLOOKUP AND XMATCH
CHAPTER 10.3: LET IT BE
CHAPTER 10.4: NEW DATA TYPES
CHAPTER 10.5: STOCKHISTORY
RESOURCES
Index
