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 %) |
|---|---|---|---|---|
| Canada | 41,651,653 (2025) | 2,319,899,772,425.92 (2025) | 1.74 (2025) | 2.07 (2025) |
| Mexico | 131,946,900 (2025) | 1,832,641,364,775.52 (2025) | 0.56 (2025) | 3.81 (2025) |
| Chile | 19,859,921 (2025) | 357,371,159,574.86 (2025) | 2.46 (2025) | 4.21 (2025) |
Scope and decision object
The decision object is whether the project cash flows, as documented, are sufficient for the proposed capital structure and whether the return profile remains coherent under a consistent date and discount basis. The analysis applies to acquisitions, development finance, or operating expansions, but the workflow differs by project type because the evidentiary record differs.
The core distinction is between enterprise operating performance and capital structure mechanics. Cash available for debt service is a liquidity measure derived from the project’s documented operating cash flow after lender-defined adjustments. NOI is a property operating metric and is not, by itself, cash. EBITDA is an accounting proxy for operating earnings and may exclude items that are cash, noncash, recurring, or project specific. None of these measures can be substituted for one another without an explicit bridge.
The method also separates project cash flows from investor cash flows. Project cash flows are used for DSCR and for lender-level feasibility. Investor cash flows include equity contributions, fees, distributions, refinancing effects, and exit proceeds and are the appropriate basis for IRR and NPV when those metrics are intended to describe equity economics. Mixing those bases can create false comfort or false distress.
- Required records: rent rolls or customer contracts; actual cash receipts; operating expense ledgers; lease incentives or customer concessions; capital expenditure ledger; debt term sheet; amortization schedule; interest reset convention; covenant definitions; tax and fee assumptions; construction budget and draw schedule for developments; sale or exit assumptions if equity returns are analyzed.
- If the project has multiple entities or phases, each entity and phase must be mapped separately before aggregation. Intercompany items must be eliminated or identified as such.
Evidence set and documentary hierarchy
The highest-weight evidence is executed contractual documentation and bank or custodian records showing actual cash movement. Next in priority are schedules prepared from source documents, such as rent rolls, project budgets, lender schedules, and tenant ledgers. Lowest weight are management summaries that lack source support or that combine periods, currencies, or projects without reconciliation.
For an acquisition, reconcile the rent roll to the general ledger or cash receipts, then trace occupancy changes, abatements, and tenant improvement concessions to invoices or side letters. For a development, reconcile approvals, construction milestones, change orders, and committed capacity before treating announced pipeline as supply. For industrial or infrastructure projects, the production or commissioning state must be evidenced by signed tests, certified completion documents, or utility connection records, not by marketing descriptions.
For cross-border projects, use the functional operating currency as the base for operating cash flow. If an investor models returns in another currency, the translation layer must be explicit and dated. A final translated IRR is not a substitute for modeling currency exposure at each cash-flow date.
- Needed records for debt service testing: interest schedule, principal amortization, fees included in debt service, cash sweep terms, reserve requirements, and any cash trap triggers.
- Needed records for equity return testing: equity contribution dates and amounts, distribution waterfall, refinance proceeds, exit net of selling costs, and any preferred return or promote terms.
- Needed records for currency reconciliation: spot or contracted conversion dates tied to each cash-flow item, hedge documentation if any, and the accounting treatment of gains and losses.
Reproducible step-by-step method
Step one is define the analysis perimeter. Identify the project, legal entity, assets, phase, and time horizon. Confirm whether the task is acquisition, development, refinance, or mixed-use. Set the operating currency and the reporting currency separately if they differ.
Step two is build a source schedule. List every expected inflow and outflow by date, source, and document. Do not project a line item unless there is an evidentiary basis. Separate recurring operating items from nonrecurring or capital items. Separate committed items from merely expected items.
Step three is compute operating cash available for debt service. Start from project operating cash receipts, subtract cash operating expenses, adjust for lender-defined exclusions and add-backs only if they are documented and consistent with the debt documents, then subtract required replacement reserves or other cash traps if they are treated as unavailable for debt service under the loan terms.
Step four is compute debt service. Use the actual interest reset terms, amortization, capitalized interest rules, and mandatory fees. If principal is sculpted or partially deferred, reflect the actual schedule rather than a straight-line proxy. DSCR is then cash available for debt service divided by scheduled debt service for the same period and the same currency basis.
Step five is compute IRR and NPV on dated equity cash flows or project cash flows, but not a blend. Each cash flow must be placed on its actual date. The discount rate and compounding basis must match the timing convention used in the series. If the project is irregularly timed, the dated approach is mandatory.
Step six is compare the operating result with the financing result. A project can show a favorable IRR while still failing to generate enough operating cash to service debt in early periods. That is a liquidity failure, not a return failure. Conversely, a project can service debt but produce a weak equity return if the capital structure is inefficient or if exit value is limited.
Step seven is test alternative case paths. Build at least one downside case for delays, rent or price pressure, cost overruns, collection slippage, or lower output. Re-run the same cash flow logic without changing the methodological basis. The point is not to force a conclusion but to see whether the conclusion survives consistent stress.
- The exact reconciliation order is: source document to schedule, schedule to general ledger or bank record, ledger to model line item, model line item to ratio. Any unreconciled difference must be labeled and carried separately until explained.
- If lender definitions differ from accounting presentation, use lender definitions for covenant analysis and accounting definitions only for financial statement interpretation.
Verification and triangulation
No single schedule should be accepted if it can be independently checked. Rent or contract revenue should be triangulated against cash receipts and occupancy or delivery evidence. Operating expenses should be triangulated against invoices, bank disbursements, and budget variances. Capital costs should be triangulated against contractor payment applications, certified progress, and retained amounts.
For development projects, construction draw evidence should be reconciled to milestone completion, permits, and any lender inspection reports. If committed capacity is being used as demand evidence, the commitment must be signed, dated, and economically binding enough to distinguish it from marketing interest. For acquisition projects, historical occupancy and collection patterns should be compared with current contracts to identify whether the asset is stable, in transition, or distressed.
Triangulation should also check internal coherence. If NOI increases but bank receipts do not, the cause may be accrual timing, write-offs, or management presentation. If EBITDA improves but cash available for debt service falls, the difference may be working capital absorption, capitalized expenditures, or reserve requirements. If the project cash flow supports debt but the equity IRR is volatile, the issue may be leverage, timing, or terminal assumption sensitivity.
- A finding that would change the conclusion is any documented mismatch that alters cash reality rather than presentation: unrecorded abatements, delayed rent commencement, deferred capex, undisclosed fees, unapproved change orders, covenant-defined add-backs that are not actually allowed, or an unhedged currency exposure that changes the dated cash profile.
- A second conclusion-changing finding is any date error: using period-end discounting for irregular cash flows, assuming mid-period receipts without evidence, or treating a refinance or exit as available before the documented closing date.
Downside analysis and failure modes
The principal downside risk is liquidity shortfall. Even a high-return project can fail if early-period operating cash does not cover required debt service. In such a case, the financing plan may rely on equity cures, reserves, or refinancing that are not yet evidenced. This is why return metrics cannot repair a serviceability deficit.
A second failure mode is negative IRR. Negative IRR can occur when the investment basis is not recovered in nominal terms or when cash outflows dominate later inflows under the chosen date structure. Negative IRR is not merely a low-return case; it indicates that the dated series does not produce a positive solution at the observed cash-flow pattern, or that the project cannot recover capital on the modeled basis.
A third failure mode is multiple IRR. Multiple sign changes in the cash-flow series can create more than one mathematical IRR, or no economically meaningful IRR, especially when there are interim distributions followed by later capital calls, remediation costs, or refinance reversals. In such cases, IRR should not be treated as a stand-alone ranking tool. NPV at a specified discount rate, together with a clear rationale for that rate, is more stable. If IRR is reported at all, the sign pattern and the possibility of multiple solutions must be disclosed.
A fourth failure mode is basis mismatch. Using NOI for debt service, EBITDA for cash flow, or an undiscounted return series for a discounted metric can make a weak project appear stronger than it is. Another is currency mismatch: project cash flows in one currency and returns in another without explicit translation timing can overstate or understate both DSCR and IRR.
Investigation stop conditions
The investigation should stop only when the source record is sufficiently complete to support the stated question or when a missing record is so material that no reliable conclusion can be drawn. The threshold is analytical completeness, not convenience.
Stop and qualify the conclusion if any of the following remain unresolved: the debt service schedule is unavailable or inconsistent; the cash receipts record does not match the revenue schedule; major capex items are uncaptured; currency conversion timing is unclear; covenant definitions are missing; or the project phase and legal entity are not clearly identified.
Stop and decline to merge separate projects if their cash flows cannot be disentangled. Stop and treat the result as inconclusive if management summaries cannot be reconciled to bank, ledger, or contractual records. Stop and flag the need for local technical or legal review when the question turns on local approvals, property rights, tax treatment, or enforceability outside the analyst’s verified record. This is not a failure of method; it is a boundary of evidence.
- A conclusion should not be rendered if the material records are internally inconsistent and the inconsistency is outcome-determinative.
- A conclusion may be rendered as conditional only if the unresolved items are explicitly listed and the decision maker understands that the result is provisional.
Limitations and project specificity
This method is robust to structure but not to missing facts. It depends on document quality, date integrity, and consistent definitions. It does not replace valuation, engineering, tax, market, or legal review where those disciplines are necessary to verify the inputs.
There is no universal DSCR pass mark because acceptable coverage depends on the volatility of cash flow, the shape of amortization, the amount of reserve support, the timing of ramp-up, the lender’s covenants, and the project’s ability to withstand delay or shock. A ratio that is adequate for a stabilized asset may be inadequate for a ramping development, and vice versa.
Likewise, IRR and NPV are not interchangeable. IRR is sensitive to timing and can be misleading with nonconventional cash flows. NPV depends on the chosen discount rate and therefore on the risk and opportunity-cost framework. Any conclusion based on either metric is project-specific and should be stated with the exact cash-flow series, date basis, and assumptions used.
- The working paper should preserve the unresolved issues, not smooth them away.
- If the record changes, the conclusion must be revisited. This is true even when the direction of change appears small, because leverage and timing can magnify small revisions into material result changes.
Decision workpaper and conclusion template
The final workpaper should contain a one-page decision table that records the project entity, operating currency, cash flow source set, debt schedule source, equity cash flow source, discount basis, and any unresolved reconciliation items. It should state whether the project passes the liquidity test, whether the equity return test is mathematically coherent, and whether any reported IRR is unique or potentially multiple.
The conclusion should be conditional and evidence-led. If cash available for debt service covers scheduled debt service on the documented basis, the project is liquid enough for the modeled period, subject to the listed assumptions. If it does not, the project has a liquidity shortfall even if the equity IRR or NPV appears attractive. If the IRR is negative, state that the modeled series does not support a positive dated return under the chosen structure. If the cash-flow pattern can generate multiple IRRs, state that IRR is not reliable as a single summary statistic and rely on NPV and scenario analysis instead.
The decision record should end with the specific finding that would change the conclusion. Examples include a corrected rent roll, a revised draw schedule, a different amortization date, a lender-approved reserve release, a verified change in occupancy, or a documented currency hedge. Without such a finding, the current conclusion stands only for the current record set.
- Decision output should be one of three forms: supportable, supportable only with stated qualifications, or not supportable on the current record.
- The workpaper should identify who prepared it, what source files were reviewed, and which reconciliations remain open, but it should not claim final approval or certification.
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.
