Glossary

Monte Carlo Simulation

Monte Carlo simulation is a quantitative technique that builds a distribution of possible outcomes by running a large number of trials, each drawing its inputs from specified probability distributions, rather than relying on a single point estimate or a small set of discrete scenarios. In financial modelling and investment analysis, it is applied wherever a decision depends on several uncertain inputs whose combined effect is difficult to characterize through sensitivity or scenario analysis alone, most prominently in capital budgeting and DCF valuation, where the DCF-specific application of the technique is treated as its own dedicated guide.

NOPAT (Net Operating Profit After Tax)

NOPAT (Net Operating Profit After Tax) is a company's operating earnings (EBIT) adjusted to reflect the taxes that would be paid if the company had no debt, isolating operating performance from the effects of financing structure. NOPAT is calculated as EBIT multiplied by (1 minus the tax rate), and it deliberately excludes interest expense, which is a financing item rather than an operating one. NOPAT is the starting point for building unlevered free cash flow (FCFF): non-cash charges are added back and capital expenditure and working capital movements are deducted from NOPAT to arrive at FCFF, which is then discounted at WACC to derive enterprise value.

NPV (Net Present Value)

Net Present Value (NPV) is the sum of a series of future cash flows, each discounted back to the present at a chosen discount rate, minus any initial investment. It is one of the two most commonly used discounted cash flow metrics in financial modelling, alongside IRR, and one of the more frequently misapplied Excel functions, due to a timing convention that is easy to get wrong.

Named Range

A named range is a label assigned to a specific cell or range of cells in Microsoft Excel (or another spreadsheet application) using the Name Manager. Once named, the label can be used in formulas instead of the cell's coordinate reference (such as B12 or Sheet1!B12), making formulas more readable and reducing the likelihood of reference errors. Named ranges can refer to a single cell, a range of cells, a constant value, or a formula. They are defined at either the workbook level (accessible from any sheet) or the sheet level (accessible only from a specific sheet).

Naming Conventions

Naming conventions, in the context of financial modelling, are the agreed rules a team applies to naming worksheets, workbook files, and version identifiers, so that anyone reading the model can tell what a sheet or file is without opening it. This is a broader practice than a named range, which is a specific Excel feature that labels an individual cell or range of cells inside a formula. Naming conventions and named ranges are complementary but address different objects — the file and sheet level for one, the individual cell reference for the other.

Natural Language Processing

Natural language processing, or NLP, is the category of artificial intelligence technique that extracts structure and meaning from unstructured text, contract terms, earnings call transcripts, footnote disclosures, converting language into data a downstream process can use. In finance, NLP typically feeds structured data into machine learning or a financial model, functioning as an input stage rather than a decision-making or generative stage on its own.

Net Absorption (Data Centre)

Net absorption measures the net change in contracted data centre capacity over a given period, gross new bookings less capacity lost to tenant churn or downsizing. It is the standard metric used to assess genuine underlying demand growth in a market or portfolio, since a positive net absorption figure can still mask a high-churn, high-bookings-turnover portfolio if only the net figure is reported without its gross components.

Net Asset Value (NAV)

Net Asset Value (NAV) is the fair value of a company's assets minus its liabilities — the specific numerical output produced by an asset-based valuation. NAV is most commonly used as the primary valuation basis for real estate companies and REITs, where it is built up asset-by-asset from independently appraised or capitalized property values, and for investment funds, where it is built from the fair (typically market) value of the fund's underlying holdings. NAV per share, calculated by dividing total NAV by diluted shares outstanding, is a standard benchmark against which a real estate company's or fund's trading price is compared.

Net Debt

Net debt is a company's total interest-bearing debt minus its cash and cash equivalents, and in some definitions its short-term investments. It represents the debt burden actually carried by the business after netting off readily available liquid resources that could, in principle, be applied against that debt. Net debt is the single largest and most consequential deduction in the standard bridge from enterprise value, the output of an FCFF-based DCF, to equity value, the value attributable to shareholders, and it must be measured as of the same valuation date as the DCF itself.

Net Interest Income

Net interest income (NII) is the difference between total interest income earned on assets and total interest expense paid on liabilities, and it is the primary revenue line for most banks. Unlike a standard corporate revenue line, NII is not a standalone assumption but a derived output of the balance sheet forecast — a function of asset and liability volumes and the yields and costs applied to them.

Net Interest Margin

Net interest margin (NIM) expresses net interest income as a percentage of average earning assets, making it comparable across periods and between institutions of different sizes in a way that a raw net interest income figure is not. It is the single most-watched profitability metric for a bank, and its period-over-period movement is typically decomposed into volume, rate, and mix effects through a net interest margin bridge.

Net Interest Spread

Net interest spread compares the average yield a bank earns on its interest-earning assets to the average cost it pays on its interest-bearing liabilities. It is closely related to, but distinct from, net interest margin: spread is a simple comparison of two average rates, while margin weights net interest income against average earning assets and therefore also reflects how much of the balance sheet is funded by non-interest-bearing sources.

Net Operating Income

Net operating income (NOI) is a real estate asset's total revenue less operating expenses, calculated before debt service, capital expenditure, and depreciation. It is the anchor figure for valuing an income-producing asset, whether through direct capitalization (NOI divided by a market capitalization rate) or as the cash flow line discounted in a real estate DCF. NOI should be built from a lease-level rent roll and an itemized operating expense schedule, and normalized for one-off items before being used in a stabilised valuation.

Net Patient Service Revenue (NPSR)

Net patient service revenue (NPSR) is the revenue a healthcare provider recognises after deducting contractual allowances (the difference between gross charges and the negotiated or regulated payer rate), charity care, and other revenue deductions from gross billed charges. NPSR, not gross charges, is the economically meaningful top-line revenue figure for a healthcare financial model, since gross charges are typically a list-price figure that bears little relationship to what any payer actually pays.

Net Working Capital Peg

The net working capital peg is a target level of net working capital, established during financial due diligence and written into the purchase agreement, against which the target's actual net working capital balance at closing is measured. Any shortfall below the peg reduces the purchase price, and any excess above it increases the purchase price, dollar for dollar — making the peg's calculation methodology one of the most commercially significant, and most frequently disputed, mechanics in a transaction.

Netback Price

Netback price is the realized price a producer actually receives for hydrocarbons after deducting transport, processing and royalty costs from the gross sale price, a more accurate measure of an asset's actual realized economics than a gross benchmark price. It is used throughout upstream and LNG modelling to translate a market reference price into the specific, asset-level realized value a financial model should actually project.

Non-Controlling Interest

Non-controlling interest (also called minority interest) is the portion of a partially-owned subsidiary's net income and equity attributable to shareholders other than the parent company. Where a parent consolidates a subsidiary it does not own 100% of, the subsidiary's full financial statements are still combined into the group result, and non-controlling interest is the mechanism that then allocates the correct share of that combined income and equity to the minority shareholders who actually own the remaining stake.

Non-Performing Loan Ratio

The non-performing loan (NPL) ratio measures non-performing loans — those in significant default or unlikely to be repaid in full without recourse to collateral — as a percentage of a bank's total loan book. It is the core asset-quality indicator, and should be read alongside the provision coverage ratio, since a rising NPL ratio without a corresponding increase in provisioning coverage signals building, unrecognized credit risk.

PLCR (Project Life Coverage Ratio)

The project life coverage ratio (PLCR) is the ratio of the net present value of projected cash available for debt service over the full remaining life of the project, including any tail period beyond the loan's final maturity, to the outstanding debt balance. It is calculated identically to LLCR except for the cash flow horizon used: LLCR discounts cash flows only to loan maturity, while PLCR discounts cash flows to the end of the project's useful economic life or concession term, whichever is relevant. The difference between LLCR and PLCR for a given project is a direct, quantified measure of the project's tail, the cushion of cash-generating life remaining after scheduled debt is fully repaid.

PPP Model

A PPP model (Public-Private Partnership model) is a financial model purpose-built to analyse the economics of a project structured as a public-private partnership. A PPP is a long-term contractual arrangement between a government authority and a private entity in which the private party designs, builds, finances, and/or operates a public asset or service in exchange for a defined payment stream over a concession period. The PPP model reflects the specific structural features that distinguish PPP transactions from standard commercial financing: - A defined concession period (typically 20 to 35 years or more) - A payment mechanism that is availability-based, demand-based, or a combination - Performance deduction regimes that reduce payment when the facility fails to meet defined standards - Lifecycle obligations requiring the private party to maintain the asset to a defined condition throughout the concession - Termination provisions specifying the compensation payable on early contract termination - A handback obligation returning the asset to the government at concession end