Steps In Developing Senegal DCF Model - Done quite a while ago
AIM: To enter varying oil prices, field size and flow rates to come up with a per share value
- Lay out yearly cash flows approximating Cairn CMD pages 56 & 57
- Assumptions:
- 100,000 barrels / day production after 2 year ramp up
- Opex $10 / barrel
- Profit oil is sales (production X inserted price) minus opex
- Profit oil is reduced by Capex each year until Capex fully recovered
- Profit oil is taxed at 30% (PSC) and corporate tax is 25%
- Decommissioning $2.5 Billion
This is DCF modelling 101 literally. When comparing oil at $50 & $90 with Cairn CMD there are some minor differences, less so at $90.
- Apply growth rates to oil price and costs. Discount bottom line cash flows. Vary these rates until IRR = 28% and Barrel NPV = $10 at $70 US barrel. Then test these by varying the oil price to $50 and then $90 and comparing to Cairn CMD
- Consider how to vary flow rates, field size and adjust costs accordingly. Decided this is to complex and is virtually a major project which will require sophisticated spreadsheet programming
- Consider how to incorporate FAR’s financing of its share of production. Came up with a method of doing this and can combine it with increasing field size and making cost adjustments. This results in FAR’s field interest reducing as a proxy for finance.
- Consider how a deal might be structured.
- Review and consider reasonableness of assumptions. EG Oil having a compound growth rate of 9.00%. At $70 today a barrel price in ten years is $165. Costs only increasing by 2% compounding, low inflation economy. Discount factor 15%.
Note at $40 Senegal is worth zilch to FAR using this model. This is because the return is less than what they would have to borrow. The spreadsheet breakeven is $43.
I used Excel group function to get a one page fit, hence some years are not visible.
DYOR IMO etc
- Forums
- ASX - By Stock
- FAR
- Far spreadsheet 500mb table interim DEC 2015 update
Far spreadsheet 500mb table interim DEC 2015 update, page-42
-
- There are more pages in this discussion • 28 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Featured News
Add FAR (ASX) to my watchlist
(20min delay)
|
|||||
Last
46.5¢ |
Change
-0.005(1.06%) |
Mkt cap ! $42.97M |
Open | High | Low | Value | Volume |
47.0¢ | 47.0¢ | 45.5¢ | $31.34K | 67.88K |
Buyers (Bids)
No. | Vol. | Price($) |
---|---|---|
1 | 3338 | 46.0¢ |
Sellers (Offers)
Price($) | Vol. | No. |
---|---|---|
47.0¢ | 199900 | 2 |
View Market Depth
No. | Vol. | Price($) |
---|---|---|
3 | 90826 | 0.455 |
2 | 51822 | 0.450 |
1 | 50000 | 0.445 |
1 | 50000 | 0.440 |
1 | 50000 | 0.425 |
Price($) | Vol. | No. |
---|---|---|
0.500 | 10000 | 1 |
0.510 | 220895 | 4 |
0.515 | 103300 | 2 |
0.520 | 421965 | 4 |
0.525 | 100000 | 1 |
Last trade - 15.59pm 13/09/2024 (20 minute delay) ? |
Featured News
FAR (ASX) Chart |
The Watchlist
LPM
LITHIUM PLUS MINERALS LTD.
Simon Kidston, Non--Executive Director
Simon Kidston
Non--Executive Director
SPONSORED BY The Market Online