---
id: po.wb.de.afe-time-depth
title: AFE and Time-Depth
summary: "How many days and dollars a well takes to drill by hole section, its AFE with contingency, the actuals against plan and its NPV at that cost."
category: Drilling
requires:
  - excel-365
tags:
  - drilling
  - well-cost
  - schedule
  - time
  - economics
  - NPV
---

## Description

How long will this well take to drill, what should the AFE be, and what is the well worth at that cost? You enter each hole section's ROP, round trips, trip rate, flat time, spread rate, tangibles and fixed intangibles, and a contingency. You read off the time-depth curve, the AFE build-up and its total, the variance of the actual days and cost against the plan, and the NPV, IRR and payout of a synthetic well carrying the AFE as its drilling and completion cost. Field units: feet, hours, days and US dollars; no add-in needed.

**How to use it:** Replace the section assumptions on the Time-Depth sheet with the planned ROP, round trips, trip rate, flat time, spread rate, tangibles and fixed intangibles, and the contingency with the one the programme carries. Type the actual days and cost of each section on the Actuals sheet as the well is drilled; the cells start at the plan's own values, so the variances start at zero. The Economics sheet takes the TOTAL AFE as the well's drilling and completion cost, so editing the plan moves the NPV. Read the plan, the variances and the economics on the Summary, and read every check there before the numbers are used.

**Method:** The plan is the drilling family's shared reference well: a vertical well with its surface shoe at 4,000 ft, its intermediate shoe at 10,000 ft and total depth at 13,000 ft, drilled in three sections (surface 0 to 4,000 ft, intermediate 4,000 to 10,000 ft and production 10,000 to 13,000 ft), each starting where the last finished. Each section's time is t = (drilled length / ROP + trips x 2 x base depth / trip rate + flat time) / 24 days, and its cost is the days at the spread rate plus its fixed cost, the section's tangibles plus its fixed intangibles, so the cost is the section's sub-total before contingency. Each section carries the previous section's cumulative days and cost, and the last section's cumulative days are the plan's total days. The build-up splits the same money out again into tangibles, spread cost (the section's days at the spread rate) and fixed intangibles; the contingency is an editable fraction of that sub-total, and the AFE is the sub-total plus the contingency.

The actual days and cost of each section are typed numbers, never formulas, so what you enter stays what you entered when the plan changes. The day variance is the actual less the plan, the cost variance the same on the dollars, and a check warns when the total day variance is above zero.

The economics is the shared synthetic well: online in month 3, its life capped at 360 months, an initial rate of 800 STB/d on an Arps hyperbolic (b = 1, 65 %/yr effective secant decline) switching to an 8 %/yr exponential tail, 1,500 scf/STB of gas, oil at $70/STB less $1.50 and gas at $3/MMBtu less $1.00, a 25 % royalty, Texas severance and ad valorem, $8,000 a month of fixed LOE and $4/STB of variable LOE, discounted at 10 % a year. The only input the drilling plan touches is the drilling and completion cost, the TOTAL AFE in $MM. The cash flow is monthly: the mid-month rate on the type curve, the oil it makes, the margin after royalty, taxes and variable costs, the phased capital and the net cash, with the plugging in the month after the last production. NPV, IRR and payout follow from the monthly net cash. The same model is the one-well NPV and IRR blueprint, and every number in the economics matches it on the same inputs.

**Example:** The surface section takes 4,000 ft at 50 ft/hr, 80 hours of drilling, plus one round trip to 4,000 ft at 1,000 ft/hr (8 hours) and 24 hours of flat time: 112 hours, 4.67 days, and $510,000 at a $45,000/day spread rate plus $300,000 of tangibles and fixed intangibles. The intermediate section takes 6,000 ft at 40 ft/hr (150 hours), two round trips to 10,000 ft (40 hours) and 48 hours of flat time: 238 hours, 9.92 days, $996,250. The production section takes 3,000 ft at 30 ft/hr (100 hours), two round trips to 13,000 ft (52 hours) and 48 hours of flat time: 200 hours, 8.33 days, $1,075,000. The plan is 22.92 days, or 550 hours: $1,000,000 of tangibles, $1,581,250 of intangibles (the $1,031,250 of spread and time plus $550,000 of fixed intangibles) and $258,125 of contingency at 10 % of the $2,581,250 sub-total, for a TOTAL AFE of $2,839,375. At $2.839375 MM of drilling and completion cost the synthetic well's NPV is $13.89 MM at the 10 % discount rate, its IRR 1413.5 % a year (the monthly cash flows annualised) and its payout in month 6; the discounted capital is $2.79 MM, the PV/I 4.97, the oil EUR 611.9 MSTB and the undiscounted net cash $21.67 MM. Every rate, day rate, tangible, intangible and the contingency is an illustrative, editable planning assumption, not a quotation, a rig rate or a vendor price.

## Validity

The rates, the day rate, the tangibles, the intangibles and the contingency are illustrative, editable planning assumptions. They are not quotations, rig rates or vendor prices, and no field is meant.

The plan is a deterministic P50: there is no non-productive time in it unless it is entered as flat time, and the round trips are taken as full round trips from the section's base, the conservative depth for the section. The workbook does not compute a probabilistic AFE (P10/P50/P90).

The actuals are typed by the user; the workbook does not read them from anywhere, and the sheet starts at the plan's own values.

The economics pairs this drilling plan with the shared synthetic well forecast. That forecast is a well-program workbook's illustrative base case reduced to one well, not a calibrated forecast of this well, and the NPV, IRR and payout it gives are the economics of that synthetic case at this plan's cost.

The monthly cash flow table carries 400 months. The shipped case needs 363 (online in month 3, a 360-month life), so a life cap beyond about 397 months would need a longer table; the results read the first N rows of it, so a longer life is truncated rather than refused.

## References

- Bourgoyne, A.T., Millheim, K.K., Chenevert, M.R. and Young, P.D. (1986). *Applied Drilling Engineering*. SPE Textbook Series Vol. 2, ch. 1: drilling cost per foot and the drilling-time curve.
- Mitchell, P.D. and Miska, T. (2011). *Fundamentals of Drilling Engineering*. SPE Textbook Series Vol. 12: well planning and AFE.
- Mian, M.A. (2011). *Project Economics and Decision Analysis*. Third edition. Gulf Professional Publishing: the NPV and the IRR.
- Arps, C.J. (1945). "Analysis of Decline Curve Types." *Transactions of the AIME* 194: 228-232.
- The Petroleum Office blueprint `po.bp.econ.npv.irr`, the one-well NPV and IRR whose numbers this workbook's economics matches on the same inputs.

## Inputs

| Input | Unit | Default | Name |
|---|---|---|---|
| ROP, connections included (surface, intermediate, production) | ft/hr | 50, 40, 30 | `ATD_SurfaceROP`, `ATD_IntermediateROP`, `ATD_ProductionROP` |
| Trips: round trips in the section | count | 1, 2, 2 | `ATD_SurfaceTrips`, `ATD_IntermediateTrips`, `ATD_ProductionTrips` |
| Trip rate, one way | ft/hr | 1000 each | `ATD_SurfaceTripRate`, `ATD_IntermediateTripRate`, `ATD_ProductionTripRate` |
| Flat time: casing, cementing, logging, BOP test | hr | 24, 48, 48 | `ATD_SurfaceFlatHours`, `ATD_IntermediateFlatHours`, `ATD_ProductionFlatHours` |
| Spread rate: rig and time-dependent services | $/day | 45000 each | `ATD_SurfaceDayRate`, `ATD_IntermediateDayRate`, `ATD_ProductionDayRate` |
| Tangibles | $ | 200000, 350000, 450000 | `ATD_SurfaceTangibles`, `ATD_IntermediateTangibles`, `ATD_ProductionTangibles` |
| Fixed intangibles | $ | 100000, 200000, 250000 | `ATD_SurfaceFixedIntangibles`, `ATD_IntermediateFixedIntangibles`, `ATD_ProductionFixedIntangibles` |
| Contingency on the sub-total | % | 10 | `ATD_Contingency` |
| Actual days per section, typed | days | the plan's days | `ATA_SurfaceDays`, `ATA_IntermediateDays`, `ATA_ProductionDays` |
| Actual cost per section, typed | $ | the plan's cost | `ATA_SurfaceCost`, `ATA_IntermediateCost`, `ATA_ProductionCost` |
| D&C from the AFE | $MM | 2.839375 | `AEC_DC` |

The economics' other inputs are the shared synthetic well's own: `AEC_Online`, `AEC_LifeCap`, `AEC_IP`, `AEC_b`, `AEC_Dei`, `AEC_Dterm`, `AEC_GOR`, `AEC_TC`, `AEC_Oil`, `AEC_OilDiff`, `AEC_Gas`, `AEC_GasDiff`, `AEC_Esc`, `AEC_WI`, `AEC_NRI`, `AEC_SevOil`, `AEC_SevGas`, `AEC_AdVal`, `AEC_LOE`, `AEC_LOEVar`, `AEC_Gath`, `AEC_PA`, `AEC_Phase4`, `AEC_Phase3`, `AEC_Phase2`, `AEC_Phase1`, `AEC_Disc`, `AEC_Hurdle` and `AEC_PayoutMax`.

## Sheets

- `Guide` — what the workbook answers and the order to work through its sheets.
- `Time-Depth` — the three hole sections' assumptions, each section's days and cost with the cumulative chain, the AFE build-up into tangibles, spread cost, fixed intangibles and contingency, the totals and the time-depth curve.
- `Actuals` — the actual days and cost typed for each section against the plan, with the day and cost variances.
- `Economics` — the shared synthetic well priced with the TOTAL AFE as its drilling and completion cost: the decline, limit and life, NPV, IRR, payout and PV/I, and the monthly cash flow.
- `Summary` — the plan, the economics and every check under one verdict.
- `Test Cases` — the worked example and other cases, with expected and computed results.

One chart: cumulative drilling days against depth.

## Functions used

Catalog LAMBDAs `PO.DE.AFE.TimeDepth`, `PO.ECON.NPV.Monthly`, `PO.ECON.IRR.Monthly` and `PO.ECON.Payout`. All travel with the workbook; no add-in function is called.
