Dated evidence for the markets discussed
World Bank WDI source update and observation years are retained below. Checked 2026-11-22. The method that follows does not infer project demand from these national observations or report unperformed fieldwork.
| Country | Population | GDP (current USD) | Real GDP growth (annual %) | CPI inflation (annual %) |
|---|---|---|---|---|
| Brazil | 212,812,405 (2025) | 2,279,920,092,492.13 (2025) | 2.29 (2025) | 5.02 (2025) |
| Colombia | 53,425,635 (2025) | 457,410,034,202.52 (2025) | 2.64 (2025) | 5.14 (2025) |
| Argentina | 45,851,378 (2025) | 683,097,891,618.6 (2025) | 4.37 (2025) | 219.88 (2024) |
Scope and analytical boundary
This paper addresses project finance and acquisition sensitivity analysis where revenues, capital expenditure, working capital and debt are jointly affected by inflation, interest rates, operating performance and collection timing.
The analysis is project-specific. It should be built from the actual legal entity, the actual operating perimeter and the actual commercial catchment, not from a national average or a generic sector template.
The method is designed for transactions in Brazil, Colombia and Argentina, but the structure is transferable if the underlying records are comparable and the local accounting, tax and currency conventions are stated explicitly.
The analytical boundary should be fixed before modeling begins. Decide whether the workpaper covers construction period funding, stabilized operations, refinancing, acquisition accounting, or a combination, and do not mix them without a reconciliation bridge.
Evidence base and required records
The minimum evidence set should include management accounts, audited financial statements where available, general ledger extracts, bank statements, debt agreements, amortization schedules, capex budgets, procurement contracts, and the current project schedule.
Revenue testing requires customer contracts, tariff schedules, service-line or product-line reports, occupancy or throughput reports, billing registers, credit notes, collections ledgers, receivables aging, and evidence of actual cash receipts.
Construction testing requires vendor quotes, signed purchase orders, contractor progress certificates, change-order logs, equipment delivery records, contingency approvals, and the baseline schedule with milestone dates.
For debt and liquidity, obtain draw notices, facility covenants, interest reset clauses, hedging documents, fee schedules, reserve account terms, and all correspondence that changes repayment timing or pricing mechanics.
For Brazil, Colombia and Argentina, also collect local currency presentation packs and any parallel reporting in another currency or inflation basis. The workpaper should preserve the reporting date, the currency of record and the translation approach used in each source file.
Reproducible step-by-step method
First, define the unit of analysis and reconcile the opening balances. Tie reported cash, receivables, payables, debt and fixed assets to the latest closed period and explain every adjustment to arrive at the model opening point.
Second, split the forecast into separate modules: operating revenue, operating costs, capital expenditure, working capital, debt service and tax. Each module should have its own assumption sheet and source note.
Third, model construction delay separately from construction cost inflation. Delay changes the timing of capex, drawdowns, interest during construction and the start of revenue; cost inflation changes the amount of capex. Do not combine them into a single percentage unless the records justify that simplification.
Fourth, separate floating-rate resets from discount rates. A borrowing-rate increase affects cash interest and debt service; a higher discount rate affects valuation. The two can move together, but they are not interchangeable and should be stressed independently as well as jointly.
Fifth, separate occupancy or utilization from collections. Revenue can be booked when earned, but liquidity depends on when cash arrives. Build two linked schedules: one for earnings and one for receipts.
Sixth, recompute draw balances, capitalized interest where applicable, post-completion interest expense, working capital balances, debt service coverage and cash headroom under each scenario.
Seventh, keep every scenario internally coherent. If construction is delayed, revenue start dates, operating ramp-up, receivables formation and debt amortization must all shift consistently.
Eighth, if the project has imported equipment, export-linked revenue or foreign-currency debt, maintain a separate exchange-rate module and reconcile the currency basis of every item to avoid mixing nominal and real terms.
Verification and triangulation
Every key assumption should be triangulated against at least two independent records. For example, revenue should reconcile from contract terms to invoices to cash receipts; capex should reconcile from budget to purchase orders to bank disbursements; debt should reconcile from facility terms to bank statements to the amortization schedule.
If records conflict, rank them by transaction proximity and auditability. Cash receipts outrank management commentary for collections, signed contracts outrank pipeline summaries for committed revenue, and bank statements outrank internal schedules for debt balances.
Use a reconciliation table that lists source document, date, amount, currency, responsible counterparty, model line item and unresolved variance. If a variance remains unexplained, carry it as a separate sensitivity rather than forcing it into base case assumptions.
Where local reporting is in one currency and the investment case in another, reconcile the translation method, the date of conversion and any inflation adjustment. If the period basis is inconsistent, the margin, leverage and return calculations should be treated as not yet comparable.
For Brazil, verify state and municipality level demand evidence, not only national aggregates, because catchment behavior can vary materially by location and service type. For Colombia, reconcile payer mix, service line and receivable aging rather than relying on utilization alone. For Argentina, reconcile currency basis, pricing indexation and accounting methodology before comparing reported results across periods.
Downside analysis and reverse stress testing
The downside analysis should move in linked sets, not one independent slider at a time. A severe case may combine slower ramp-up, weaker collections, higher working capital absorption, delayed capex completion and higher interest resets, but only if those changes are causally consistent.
Reverse stress testing asks what has to happen for liquidity to fail or covenants to break. Start from the required minimum cash balance or covenant floor, then work backward to the revenue shortfall, cost overrun, delay or collections deterioration that would produce it.
Test at least three downside channels. One is operating underperformance, where volume, utilization or occupancy is below plan. Another is cost pressure, where capex or opex is above plan. The third is financing stress, where borrowing costs rise or refinancing is delayed.
When debt service is tight, a project can show accounting profit and still fail on cash timing. Therefore the workpaper should identify the first month or quarter in which cash, not earnings, becomes binding.
If the project includes staged construction, analyze each stage separately. A problem in one stage can postpone the next stage, increase interest during construction and alter the later revenue base. Do not assume a single aggregate completion date if the contract and vendor records show multiple milestones.
Investigation stop conditions
The investigation should stop when the model answers the decision question at the required confidence level for the available evidence, or when additional work would not materially change the conclusion.
Stop if source records consistently reconcile and the remaining uncertainty is not decision critical. For example, if the difference between two plausible assumptions does not change debt service feasibility, liquidity survival or the sign of the key project conclusion, further refinement may not be proportionate.
Continue if any of the following remain unresolved: opening debt balance, cash position, revenue recognition basis, collections lag, project completion date, capex commitment, related-party pricing, or the presence of off-balance-sheet obligations that affect cash.
Stop also if the project is so under-documented that the core forecast cannot be tied to primary records. In that case the workpaper should remain conditional and explicitly state which missing record would most likely change the conclusion.
The single most important stop rule is whether a missing or contradictory record can alter the direction of the recommendation. If yes, the analysis remains incomplete. If no, document why the residual variance is immaterial to the decision.
Limitations and decision sensitivity
This method does not convert uncertainty into probability unless there is an evidence-based distribution. A scenario is a conditional case, not a forecast probability, unless the analyst can support that probability from observed data or a documented inference method.
The analysis is limited by the quality of source records. Management projections, especially in early-stage or distressed situations, are not substitutes for bank statements, signed contracts or actual collections.
Local inflation, tax and currency treatment must be specified consistently. A nominal forecast should not be compared to a real discount rate, and a local-currency operating plan should not be mixed with a foreign-currency debt schedule without a translation bridge.
The workpaper cannot resolve legal, tax, environmental or regulated professional questions by itself. Those issues can change cash flows and timing, but they require qualified local review and separate documentation.
A materially different conclusion would arise if the project’s revenue basis, completion date, debt reset mechanics or collections profile were found to differ from the records used in the model.
Decision workpaper and conclusion logic
The decision page should summarize the base case, the key sensitivities, the worst coherent downside case, the reverse stress trigger and the specific record gaps that remain.
A useful decision workpaper shows three questions. First, does the project remain liquid through construction and ramp-up? Second, does it meet debt service after applying coherent downside assumptions? Third, do the source records support the claimed revenue, cost and timing profile?
If the answer to the first or second question depends on assumptions that are not tied to records, the decision should remain conditional. The conclusion should state which evidence would move the result from conditional to supportable, or from supportable to not supportable.
The final output should list the records reviewed, the unresolved items, the model modules affected and the exact finding that would change the conclusion. That is the central workpaper discipline: no conclusion without a traceable path from source documents to cash flow and debt capacity.
For Brazil, Colombia and Argentina alike, the conclusion must be project-specific, dated and currency-specific. It should not generalize beyond the actual entity, site, payer mix, route, contract set or balance sheet being analyzed.
Scope, provenance and professional limitations
Wert-Berater Financial provides independent analytical decision support. We do not provide or arrange financing, broker securities, solicit investments or guarantee returns. Every engagement is subject to scope, data availability, geographic coverage, professional qualifications, applicable local law, regulatory restrictions, sanctions, counterparty and payment-risk review. Market coverage does not imply a local office, licence, professional designation or partnership. Local legal, tax, engineering and regulated professional conclusions require appropriately qualified advisers.
