Financial Modelling for Project Finance Supplementary Files:

CHAPTER 2.4 SUMIF to 2.6 SUMPRODUCT

• SP Multiple Criteria Examples.xls

CHAPTER 2.7 VLOOKUP

• SP VLOOKUP Example.xlsm

CHAPTER 2.8 LOOKUP

• SP LOOKUP Example.xlsm

CHAPTER 2.10 XLOOKUP and XMATCH

• SP XLOOKUP and XMATCH Functions.xlsx

CHAPTER 2.15 MAX MIN LARGE SMALL

• SP MAX MIN LARGE and SMALL.xlsx

CHAPTER 3.7 DATA TABLES

• SP Data Table Examples.xls

CHAPTER 3.8 GOAL SEEK and SOLVER

• SP Goal Seeking Solver.xls

CHAPTER 12.7 REVENUE (Working Capital Adjustments)

• SP Working Capital Adjustments.xls

CHAPTER 12.11 DEBT

• Interest-Revenue-Example.xls

CHAPTER 13 RATIOS

• SP US GAAP Ratios Example.xls

MODEL BUILD FILES

• Model 00 - Starter File.xlsm
• Model 01 - Construction and Operations Period Timings Added.xlsm
• Model 02 - Operations Sheet Started.xlsm
• Model 03 - Financial Statements Added.xlsm
• Model 04 - Financial Statements Linked.xlsm
• Model 05 - Construction Costs Completed.xlsm
• Model 06 - Revenue Completed.xlsm
• Model 07 - COGS Completed.xlsm
• Model 08 - Opex Completed.xlsm
• Model 09 - Capex Completed.xlsm
• Model 10 - Debt Completed.xlsm
• Model 11 - Tax Completed.xlsm
• Model 12 - MRA Completed.xlsm
• Model 13 - Equity Completed.xlsm
• Model 14 - Balance Sheet Completed.xlsm
• Model 15 - Indirect Cash Flow Statement Completed.xlsm
• Model 16 - Ratios Completed.xlsm
• Model 17 - Sources and Uses Completed.xlsm
• Model 18 - Valuations Completed.xlsm
• Model 19 - Scenarios Completed.xlsm