Archived publication
This publication is no longer current or has been superseded.
A detailed financial model has been prepared by Cranleigh to assess the financial implications of the Initiative. This model has the ability to assess profitability and cash flows, and project investment returns and various other financial ratios against a wide range of variables.
The two rollout scenarios discussed above in Section 6 have been modelled. The associated spreadsheet files including profit and loss accounts, balance sheets, cash flows, investment returns and charts have been sent separately with this report.
Set out in the table below is a summary of the results of the modelling which compares base, optimistic and pessimistic scenarios during a ten-year period.
The key assumptions adopted in the financial model are as follows:
The key assumptions adopted in the financial model are as follows:
View Scenario A: limited coverage (large table)
View Scenario B: national basis (large table)
Based on the assumptions outlined above, this scenario shows strong growth in sales and profitability in the first two years levelling out once all bins are in place. Once established, strong positive cash flows are exhibited except in years where capital expenditure on replacement bins is required.
This generates a project Internal Rate of Return (IRR) of 32%. Given the risk of a new venture many investors would consider this inadequate to proceed with on a commercial basis.
An addition, sensitivity analysis shows that returns are highly sensitive to changes to the advertising revenue per bin and the advertising occupancy rate (the average time that bins have sold advertising on them). A 10% fall in advertising revenue or the occupancy rate reduces the project IRR to only 21% while a 10% drop in both together reduces the IRR to 10%.
As overheads will be similar to the national basis scenario, the full benefits of economies of scale will not be realised leading to greater sensitivity in returns.
A total investment of $2.5 million is required to establish the business.
With twice as many bins, revenues are twice as high once all bins are in place. However, due to greater economies of scale Net Cash Flow before Tax and Dividends is 140%, or $7.8 million higher over the 10-year forecast period compared to limited coverage scenario.
The resulting project IRR is 63%. While returns are not as highly sensitive to changes to the advertising revenue per bin and the advertising occupancy rate as in the limited coverage scenario, the variability is still significant. A 10% fall in advertising revenue or the occupancy rate reduces the project IRR to 48% while a 10% drop in both together reduces IRR to 32%.
It can be seen that the economies of scale of the larger project increases profitability and reduces the volatility in returns. The total investment required increases to $4.0 million.
Average revenue per bin and the advertising occupancy rate are the key variables for this project. The price and quantity of recycled materials has little financial impact. Provided the advertising demand is there, Scenario B, involving a roll out of the Initiative on a national basis, has much more attractive investment characteristics that the limited coverage scenario.