What to Expect
The course is broken into 4 sessions:
Setting up the model and main cash flow drivers
Starting from a blank spreadsheet, delegates start by laying out the model structure and the main cashflows.
Timing, Tax and Capex
Once the balance sheet has been balanced, delegates work on the project timing and tax calculations (from VAT tax to capital allowances).
Debt and Equity
This session is focused on the funding structure using senior and subordinated debt as well as equity circularities.
Analysis and Setting the price
The course ends with debt analysis using debt cover ratios and learning how to set the bidding price by using macros.