Financial Modelling with Dynamic Arrays Supplementary Files:

CHAPTER 1.4 SUMIF to 1.6 SUMPRODUCT

• SP Multiple Criteria Examples.xls

CHAPTER 1.7 VLOOKUP

• SP VLOOKUP Example.xlsm

CHAPTER 1.8 LOOKUP

• SP LOOKUP Example.xlsm

CHAPTER 1.10 XLOOKUP and XMATCH

• SP XLOOKUP and XMATCH Functions.xlsx

CHAPTER 1.15 MAX MIN LARGE SMALL

• SP MAX MIN LARGE and SMALL.xlsx

CHAPTER 2.7 DATA TABLES

• SP Data Table Examples.xls

CHAPTER 2.8 GOAL SEEK and SOLVER

• SP Goal Seeking Solver.xls

CHAPTER 5 DYNAMIC ARRAYS

• SP Dynamic Arrays Examples.xlsx

CHAPTER 6 LET & LAMBDA

• SP LAMBDA Recursion Examples.xlsx

CHAPTER 16 REPEATABLE CALCULATIONS

• SP Repeatable Calculations with Dynamic Arrays.xlsx

CHAPTER 17.7 REVENUE (Working Capital Adjustments)

• SP Working Capital Adjustments.xls

CHAPTER 18 RATIOS

• SP US GAAP Ratios Example.xls

MODEL BUILD FILES

• SP Template Model.xlsm  
• Model 01 - Timing Completed.xlsm
• Model 02 - Sheets Added.xlsm
• Model 03 - Financial Statements Added.xlsm
• Model 04 - Financial Statements Totals Added.xlsm
• Model 05 - Statements Linked and Error Checks Added.xlsm
• Model 06 - Revenue Completed.xlsm
• Model 07 - COGS Completed.xlsm
• Model 08 - Inventory Completed.xlsm
• Model 09 - Operating Expenditure Completed.xlsm
• Model 10 - Capital Expenditure Completed.xlsm
• Model 11 - Debt Completed.xlsm
• Model 12 - Tax Completed.xlsm
• Model 13 - Equity Completed.xlsm
• Model 14 - Balance Sheet Completed.xlsm
• Model 15 - Opening Balance Sheet Added Back.xlsm
• Model 16 - Indirect Cash Flow Statement Completed.xlsm
• Model 17 - Model Completed.xlsm