Home / Examples / Petrobras

Petrobras financial model

This Excel model of Petrobras has three statements (income statement, balance sheet and cash flow), five projected years from Jun-27E to Jun-31E, and a DCF valuation. Skale built it automatically from 4 published financial documents. For LTM Jun-26, revenue was $104.2 billion (up 16.9% vs 2025), net income to shareholders was $25.6 billion, and net debt was $19.4 billion. Projected revenue reaches $272.5 billion by Jun-31E, and the DCF enterprise value is $834.5 billion under the model's assumptions.

Built by Skale · updated November 10, 2026

Preview the Excel

The first rows of each sheet, as they open in Excel.

Petrobras financial model — Summary sheet in Excel
Summary sheet — Key lines of the three statements with growth, margins, net debt and the balance check.

Petrobras summary financials

USD millions · historical and projected years 2023–2031. From the model's Summary sheet; every projected figure is a formula in the Excel.

HistoricalProjected
USD millionsUnit20232024202520262027E2028E2029E2030E2031E
Income statement
Revenue102,409.091,416.089,195.0104,227.0123,408.8146,006.1176,307.2217,164.1272,529.5
Revenue growth(10.7%)(2.4%)16.9%18.4%18.3%20.8%23.2%25.5%
Gross profit53,974.045,972.042,459.052,892.062,626.274,093.689,470.5110,204.1138,300.3
Gross margin52.7%50.3%47.6%50.7%50.7%50.7%50.7%50.7%50.7%
EBITDA54,340.053,861.065,464.076,490.987,094.5100,892.4119,123.2143,496.0
EBITDA margin59.4%60.4%62.8%62.0%59.7%57.2%54.9%52.7%
EBIT47,342.039,253.035,323.044,744.052,978.662,679.575,687.693,227.2116,995.2
EBIT margin46.2%42.9%39.6%42.9%42.9%42.9%42.9%42.9%42.9%
Pre-tax income35,396.011,142.026,795.034,671.041,423.556,604.577,796.8107,199.5147,879.4
Income taxes10,401.03,537.07,075.09,047.010,809.014,770.320,300.227,972.538,587.4
Effective tax rate29.4%31.7%26.4%26.1%26.1%26.1%26.1%26.1%26.1%
Net income24,995.07,605.019,720.025,624.030,614.541,834.257,496.679,227.0109,292.0
Net income to shareholders24,884.07,528.019,634.025,553.030,529.641,718.357,337.379,007.5108,989.1
Net margin24.3%8.2%22.0%24.5%24.7%28.6%32.5%36.4%40.0%
Cash flow
Cash flow from operations45,803.047,738.052,938.664,833.580,799.3102,553.5132,305.4
Capex26,424.031,643.030,758.030,758.030,758.030,758.030,758.030,758.0
Unlevered free cash flow14,495.319,768.630,805.538,681.248,641.761,688.679,024.9
FCF margin16.3%19.0%25.0%26.5%27.6%28.4%29.0%
Balance sheet
Cash and cash equivalents3,271.06,471.06,483.050,380.9114,158.6205,022.4333,069.0512,213.5
Financial debt23,162.026,441.025,834.025,815.025,815.025,815.025,815.025,815.0
Lease liabilities37,149.043,352.044,972.044,972.044,972.044,972.044,972.044,972.0
Net debt (financial debt − cash)19,891.019,970.019,351.0(24,565.9)(88,343.6)(179,207.4)(307,254.0)(486,398.5)
Total equity59,350.075,891.093,083.0145,348.9216,769.4314,929.2450,187.8636,774.0
Balance check (assets − liabilities − equity)--------
Key ratios
EBITDA margin59.4%60.4%62.8%62.0%59.7%57.2%54.9%52.7%
ROIC (EBIT × (1 − t) ÷ average invested capital)23.1%20.4%22.3%24.3%27.3%31.6%37.3%45.0%
FCF margin16.3%19.0%25.0%26.5%27.6%28.4%29.0%
Net debt ÷ EBITDA0.37x0.37x0.30x(0.32x)(1.01x)(1.78x)(2.58x)(3.39x)
EBITDA ÷ interest9.12x12.49x15.22x17.79x20.26x23.47x27.71x33.38x
Minimum DSCR over the projection7.87x

How revenue is built

Skale reads the documents to decide how each revenue stream is projected, and explains why.

DieselVolume × price

Petrobras reports domestic diesel sales volumes for two full years and the interim period, so revenue is built as volume x average price.

GasolineVolume × price

Reported domestic gasoline volumes for at least two years support volume x price.

Liquefied petroleum gasVolume × price

Reported domestic LPG volumes for at least two years support volume x price.

Jet fuelVolume × price

Reported jet fuel volumes for at least two years support volume x price.

NaphthaVolume × price

Reported naphtha volumes for at least two years support volume x price.

Fuel oil (including bunker fuel)Volume × price

Reported fuel oil volumes for at least two years support volume x price.

Other oil productsVolume × price

Reported volumes for other oil products for at least two years support volume x price.

Natural gasVolume × price

Reported natural gas sales volumes for at least two years support volume x price.

Crude oilVolume × price

Reported domestic crude oil sales volumes for at least two years support volume x price.

Renewables and nitrogen productsVolume × price

A reported volume exists for two years, so volume x price is used.

ElectricityVolume × price

Reported electricity sales in average MW for at least two years support volume x price.

Exports - Crude oilVolume × price

Reported crude export volumes for at least two years support volume x price. The price follows Brent.

Exports - Fuel oil (including bunker fuel)Volume × price

Reported fuel oil export volumes for at least two years support volume x price.

Exports - Other oil products and other productsVolume × price

Reported other oil product export volumes for at least two years support volume x price.

Sales abroadVolume × price

Reported volumes for sales abroad (trading and foreign operations) for at least two years support volume x price.

Road-use diesel subsidy programGrowth rate

The subsidy started in March 2026 and has no two-year driver history, so the current build is kept.

Gasoline subsidy programGrowth rate

The subsidy started in 2026 and has no history, so the current build is kept.

Liquefied petroleum gas subsidy programGrowth rate

The subsidy started in 2026 and has no history, so the current build is kept.

BreakageGrowth rate

Breakage has no operational driver in the documents, so growth is the best supported build.

Services, agency and othersGrowth rate

Services and agency revenue has no operational driver in the documents, so growth is the best supported build.

Build this for your company

Upload your financial statements; Skale builds the model, and you review the assumptions.

Get started

New to financial models? What is a financial model?

Download for free

Create a free Skale account to download this file — with Google or your email. Every example is then in your Dashboard under Free models.