Financial Modelling for Project Finance Supplementary Files:
CHAPTER 2.4 SUMIF to 2.6 SUMPRODUCT
CHAPTER 2.7 VLOOKUP
CHAPTER 2.8 LOOKUP
CHAPTER 2.10 XLOOKUP and XMATCH
CHAPTER 2.15 MAX MIN LARGE SMALL
CHAPTER 3.7 DATA TABLES
CHAPTER 3.8 GOAL SEEK and SOLVER
CHAPTER 12.7 REVENUE (Working Capital Adjustments)
CHAPTER 12.11 DEBT
CHAPTER 13 RATIOS
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