All companies
Coterra logo
EnergyCTRA

Coterra (CTRA) Financial Forecast Calculator

Interactive 5-year forecast and DCF for Coterra. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from Coterra’s most recent SEC filings.

Revenue FY30
$14.14B
from $5.68B
FCF FY30
$6.16B
Margin 43.5%
Enterprise value
$80.41B
14.1× LTM revenue
Equity value
$78.91B
Net debt $1.50B
Revenue & free cash flow - history and 5-year forecast
Line (area)
Bars
Historicals from SEC EDGAR (grey). Forecast years (color) update live as you move the sliders.

Assumptions

Revenue growth (annual)
20.0%
-10.0%baseline 20.0%40.0%
Gross margin
45.0%
5.0%baseline 45.0%90.0%
Capex % of revenue
3.0%
0.0%baseline 3.0%30.0%
WACC (discount rate)
9.00%
4.0%baseline 9.0%18.0%
Terminal growth
2.50%
0.0%baseline 2.5%5.0%

Need this as an Excel model?

Keep iterating on the Coterra forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Frequently asked

What kind of company is Coterra Energy and what does it do?+

Coterra Energy is a premier, diversified independent oil and natural gas exploration and production (E&P) company based in Houston, Texas. It operates across three premier US basins, extracting hydrocarbons and selling them to market purchasers.

How does Coterra Energy generate its revenue?+

Coterra Energy generates revenue primarily from natural gas sales and oil sales. Natural gas revenue is driven by production volume and realized price per Mcf, while oil revenue is driven by production volume and realized price per Bbl.

What are Coterra Energy's typical capital expenditure requirements?+

Coterra Energy's capital expenditure typically ranges from 40% to 55% of revenue, measured as a reinvestment rate of discretionary cash flow. Approximately 75% of this capital is for maintenance to offset base decline, with the remaining 25% allocated to growth projects.

What are the key revenue growth assumptions for Coterra Energy's financial model?+

A financial model for Coterra Energy might incorporate a Revenue_Growth assumption of 0.2, reflecting overall growth expectations. Historically, oil sales have seen 5% to 8% CAGR, significantly boosted by acquisitions, while natural gas sales have been flat to low-single-digit decline.

What are important financial assumptions for a Coterra Energy valuation model?+

Key financial assumptions for a Coterra Energy valuation model include a Revenue_Growth of 0.2, COGS_Pct_Revenue at 0.55, and SGA_Pct_Revenue at 0.0579. The model also considers a Tax_Rate of 0.2183 and DA_Pct_Revenue of 0.2264.

Can I download a financial model for Coterra Energy to analyze its valuation?+

Yes, a downloadable Excel model is available for Coterra Energy (CTRA) that provides a standalone equity valuation and cash flow forecast. This model evaluates its intrinsic value and capital return capacity ahead of its pending merger with Devon Energy.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview