Vol. ICiélio Queiroz

Living spreadsheets

§ 06

Financial models I build in Excel — recreated here as editorial HTML. Illustrative data.

Case 01 · Corporate income statement

Income Statement — Nexus Corporação S.A.

Fiscal year 2024

Base case

Drag to simulate. Deductions and COGS follow revenue; operating expenses, depreciation and financial result are fixed — that combination is what produces operating leverage.

Gross margin

36.9%

EBITDA margin

18.9%

Net margin

9.3%

Revenue YoY

+15.6%

AccountAmount (R$)
Gross Sales RevenueR$95,840,000
(–) Deductions & Taxes(R$12,200,000)
Net RevenueR$83,640,000
(–) Cost of Goods Sold(R$48,320,000)
Gross ProfitR$35,320,000
(–) Operating Expenses(R$17,200,000)
EBITDAR$18,120,000
(–) Depreciation & Amortization(R$2,640,000)
EBITR$15,480,000
Financial Result(R$1,140,000)
(–) Income Taxes(R$5,430,980)
Net IncomeR$8,909,020

Source: model spreadsheet · illustrative data · vertical analysis calculated over gross revenue.

Case 02 · Household cash flow

Household Budget Tracker

January – June 2026

Income

R$98,445

Expenses

R$87,827

Net balance

R$10,618

% committed

89.2%

MonthIncomeExpensesBalanceCommittedStatus
JanuaryR$15,735R$13,967R$1,768
88.8%
positive
FebruaryR$16,120R$14,240R$1,880
88.3%
positive
MarchR$15,980R$15,320R$660
95.9%
watch
AprilR$16,540R$13,870R$2,670
83.9%
positive
MayR$17,200R$14,590R$2,610
84.8%
positive
JuneR$16,870R$15,840R$1,030
93.9%
watch
Period totalR$98,445R$87,827R$10,61889.2%positive

Source: “Household Budget 2026” spreadsheet · built in Excel · automated dashboard.