Sign in

Blog · Topic

Finance metrics and formulas

Margins, ratios and working-capital measures: the formula, a worked example from real rows, and where the number misleads.

Finance metrics and formulas · Finance and FP&A teams

Accounts receivable formula: reconcile the ending balance

The accounts receivable formula reconciles an opening customer balance to the closing ledger. Work through invoices, cash, credits, write-offs and adjustments, then bridge gross receivables to the net balance.

Oct 25, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow for loan application: what to prepare

Prepare historical cash flow evidence that ties to your financial statements and bank records. Work through operating cash, capital spending, and existing and proposed debt payments without counting interest twice.

Oct 25, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash management and receivables: turn invoices into cash

Connect invoice aging to actual receipts and expected collection dates. Use an invoice-level worksheet to reconcile balances, identify overdue amounts, and decide which collections need attention.

Oct 25, 20265 min read
Finance metrics and formulas · Manufacturing

Conversion Cost per Unit Calculator: Labor and Overhead

Calculate manufacturing conversion cost per equivalent unit from direct labor, factory overhead, and production records. Work through a spreadsheet example, reconcile the assigned costs, and compare production periods on the same basis.

Oct 25, 20266 min read
Finance metrics and formulas · Sales teams

Cost per lead by channel: compare spend and lead quality

Compare channel spending with consistently defined leads, qualified leads, and won customers. This guide gives the export layout, spreadsheet formulas, worked channel table, and reconciliation checks.

Oct 25, 20266 min read
Finance metrics and formulas

Customer lifetime value and customer equity: the difference

Customer lifetime value estimates the future contribution of one customer. Customer equity adds those estimates across a defined customer base, so portfolio size and customer mix matter alongside individual value.

Oct 25, 20265 min read
Finance metrics and formulas · Financial services

Data analysis in the financial industry

Connect financial-services revenue, customer activity and operating costs in a business-line review. See a worked contribution example, the checks behind it and the decisions each owner makes.

Oct 25, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Incremental profit formula: revenue less added costs

Incremental profit measures the change in profit caused by a decision. Work through a proposed order, separate relevant costs from allocations, and reconcile the result to the operating statement.

Oct 25, 20266 min read
Finance metrics and formulas · Banking

Investment deposit ratio for banks: formula and interpretation

The investment-to-deposit ratio compares a bank's investment securities with its deposits. Work through two reporting dates, reconcile the underlying balances, and separate investment changes from deposit outflows.

Oct 25, 20265 min read
Finance metrics and formulas · Legal services

Law firm profitability analysis by matter and practice

Compare collected fees with attributable labor and matter costs from practice-management exports. This guide calculates fee realization, matter contribution and practice totals while keeping shared overhead allocations visible.

Oct 25, 20266 min read
Finance metrics and formulas · Banking

Liquidity coverage ratio: bank liquidity inputs and formula

The liquidity coverage ratio compares a bank's eligible liquid-asset buffer with stressed net outflows. Reconcile bank-prepared aggregate inputs, calculate the ratio, and explain a change between reporting dates.

Oct 25, 20265 min read
Finance metrics and formulas · Manufacturing

Manufacturing operational ROI: measure improvement returns

Manufacturing operational ROI compares verified operating benefits with the cost of an improvement. Work from production and finance exports, normalize the baseline, and reconcile savings before calculating the return.

Oct 25, 20266 min read
Finance metrics and formulas · Education

Marketing ROI in higher education

Measure higher-education marketing return by inquiry cohort, enrollment census, and net tuition contribution. Use de-identified summaries and spreadsheet formulas to compare campaign costs with financially meaningful enrollment outcomes.

Oct 25, 20264 min read
Finance metrics and formulas · Manufacturing

Overall equipment efficiency: OEE formula and example

Calculate OEE from availability, performance and quality using a production export. Compare two machines, reconcile the lost minutes and check the combined result.

Oct 25, 20265 min read
Finance metrics and formulas · Manufacturing

Overall line efficiency: formula and production example

Measure good production against the approved line standard and planned production time. Work through two shifts, reconcile line losses and distinguish the result from labor line balancing.

Oct 25, 20266 min read
Finance metrics and formulas

Product profitability analysis in Excel

Build a SKU contribution table by joining sales to approved product costs and allocating a defined support pool. Work the Excel formulas and reconcile revenue, cost and allocated support to their source files.

Oct 25, 20264 min read
Finance metrics and formulas · Finance and FP&A teams

Stock-based compensation on the cash flow statement

Stock-based compensation expense is a noncash adjustment in the indirect operating cash flow reconciliation. Work through the add-back, employee tax withholding, option proceeds and share repurchases without mixing the schedules.

Oct 25, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

AI return on investment: measure costs and realized benefits

Calculate AI return on investment from documented benefits and the full cost of an initiative. Work through a manufacturing company's pilot, separate cash savings from released staff capacity, and reconcile the result to its source records.

Oct 24, 20266 min read
Finance metrics and formulas · Consumer goods

Alcoholic beverage industry average financial ratios

An alcoholic beverage ratio comparison needs a dated peer group and a stated averaging method. Work through illustrative US producer margins, inventory turns and debt ratios while keeping distributors outside the producer average.

Oct 24, 20266 min read
Finance metrics and formulas · Supply chain

Average inventory formula: balances and time weighting

Calculate average inventory from opening and closing balances or dated snapshots. Work through unequal intervals, spreadsheet formulas, and checks that keep SKU and site comparisons consistent.

Oct 24, 20265 min read
Finance metrics and formulas · Banking

Banks' capital adequacy ratio: definition and interpretation

A bank's capital adequacy ratio compares regulatory capital with risk-weighted assets. Work through supplied capital totals, explain a quarterly movement, and reconcile the result to an approved bank workbook.

Oct 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash Available for Debt Service: Formula and Uses

Cash available for debt service measures cash generated before scheduled debt payments under a stated definition. Build the numerator from cash-flow exports, reconcile interest and required deductions, and check the result against cash movements.

Oct 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cost variance: earned value formula and project example

Cost variance compares the budgeted value of completed project work with its actual cost. Calculate it by work package, reconcile the total, and distinguish its sign from an accounting budget variance.

Oct 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Debt ratio: formula and interpretation

The debt ratio compares interest-bearing debt with total assets under a stated debt definition. Work through a balance-sheet example, distinguish debt from total liabilities, and check the result before comparing periods or entities.

Oct 24, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Du Pont analysis: break ROE into its drivers

Du Pont analysis separates return on equity into profit margin, asset turnover and financial leverage. Work through two years of financial statements, prove the identity and reconcile the change in ROE.

Oct 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial leverage ratio: formulas and interpretation

The financial leverage ratio compares total assets with shareholders' equity. Work through two balance sheets, distinguish debt from total liabilities, and reconcile the change before judging financing risk.

Oct 24, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Fixed assets on the cash flow statement: reconcile the rows

Fixed-asset cash flows come from payments and disposal receipts, not simply the change in net book value. Reconcile additions, depreciation, disposals and unpaid capital invoices with a worked US company example.

Oct 24, 20265 min read
Finance metrics and formulas · Sales teams

Google leads cost: Google Ads cost per lead and sales

Calculate Google Ads spending per lead from campaign and CRM exports. Compare valid leads, qualified leads, and acquired customers without mixing their denominators.

Oct 24, 20266 min read
Finance metrics and formulas · Supply chain

Inventory write off analysis by cause and period

Inventory write off analysis explains posted stock losses by product, location, cause, and accounting period. Use the adjustment register and ledger to separate reversals, reserve use, and current expense before assigning corrective actions.

Oct 24, 20265 min read
Finance metrics and formulas · Manufacturing

Manufacturing working capital: inventory and cash needs

Calculate manufacturing trade working capital from raw materials, work in process, finished goods, receivables and payables. Compare plants with a worked table, spreadsheet formulas and reconciliation checks.

Oct 24, 20264 min read
Finance metrics and formulas · Sales teams

Newspaper advertising ROI: measure print campaign returns

Measure newspaper and magazine campaign returns using recorded responses, matched net revenue and complete print costs. The worked example includes spreadsheet formulas, a refund adjustment and the checks that keep attributed sales separate from incremental sales.

Oct 24, 20265 min read
Finance metrics and formulas · Sales teams

Omnichannel ROI: measure returns without double counting

Reconcile unique orders and channel costs before calculating omnichannel return. Use a worked spreadsheet example to allocate revenue and contribution without counting the same sale more than once.

Oct 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Return on tangible equity: formula and interpretation

Return on tangible equity compares net income with average equity after stated intangible deductions. Work through total and common equity versions, reconcile the denominator, and see why definitions must match before comparing reports.

Oct 24, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

SBA debt service coverage ratio: prepare the business inputs

Prepare a documented business cash-flow bridge and repayment schedule for an SBA lender's coverage review. Follow the spreadsheet steps, reconcile the inputs, and compare a change in accepted adjustments.

Oct 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

WACC analysis: interpret the cost of funding a business

WACC analysis combines supplied debt and equity costs using their capital weights. Work through a transparent business funding example, reconcile the weighted rate, and compare changes in approved assumptions.

Oct 24, 20265 min read
Finance metrics and formulas · Investment management

WAULT calculation in Excel from a lease schedule

Calculate rent-weighted unexpired lease terms from a commercial property lease schedule. Build the Excel formulas, separate contractual expiry from tenant break dates, and reconcile the average to rent and expiry concentrations.

Oct 24, 20265 min read
Finance metrics and formulas · Professional services

Working capital for service businesses: unbilled work and payroll

Working capital in a service company depends on billing, collection and payroll timing. Build a client-level view of receivables and recognized unbilled work, reconcile it to the ledger, and test the cash needed before the next collection.

Oct 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Working capital ratio by industry: compare the right peers

The working capital ratio is current assets divided by current liabilities. See why industry operating cycles and asset quality matter, rebuild three illustrative balance sheets, and choose a benchmark that matches your own reporting basis.

Oct 24, 20265 min read
Finance metrics and formulas

Average CAC for Ecommerce: Compare the Right Costs

Average CAC for ecommerce needs a consistent cost definition and comparable customer cohorts. Compare acquisition spend with gross profit after returns and observed repeat purchases, using a worked channel example.

Oct 23, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Balance sheet: assets, liabilities and equity

A balance sheet shows a company's assets, liabilities and equity at a reporting date. Learn its structure, follow a worked statement across two month-ends, and check that the balances and movements reconcile.

Oct 23, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Baumol cash management model: formula and limits

The Baumol framework balances fixed transfer costs against the opportunity cost of holding cash. Work the formula from a treasury schedule, check the cost equality, and test whether the assumptions fit your cash movements.

Oct 23, 20265 min read
Finance metrics and formulas

Event marketing ROI: measure matured opportunity cohorts

Calculate event marketing ROI from matched attendees, opportunities, realized revenue and campaign costs. Compare events at equal ages and keep open pipeline separate from the return already earned.

Oct 23, 20265 min read
Finance metrics and formulas · Consumer goods

Promotion ROI: measure profit after discounts and spend

Calculate promotion ROI from actual contribution, a stated baseline and the full promotional investment. A worked CPG example separates discounts already in net sales from additional promotional costs and reconciles the profit result.

Oct 23, 20265 min read
Finance metrics and formulas

Self storage financial model: occupancy, revenue and cash

Build a self-storage operating workbook from occupied units, rental rates and site costs. Compare actuals with plan and reconcile rental revenue, collections and closing cash.

Oct 23, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Accounts receivable collection rate: formula and checks

Measure cash collected against a defined pool of receivables for the month. This example sets the denominator, separates credits and write-offs from cash, and reconciles customer rates to the closing balance.

Oct 22, 20265 min read
Finance metrics and formulas · Banking

Bank financial statements: read income and balances

Bank financial statements connect interest income, funding costs, credit losses and cash movements. Work through a reconciled example and the spreadsheet checks that tie earnings to equity and closing cash.

Oct 22, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash to assets ratio: formula and interpretation

The cash to assets ratio shows the share of a company's asset base held in cash and cash equivalents. Calculate it across entities, reconcile the balance sheet totals, and distinguish cash composition from debt coverage.

Oct 22, 20266 min read
Finance metrics and formulas · Manufacturing

Fixed Asset Turnover Ratio: Formula and Interpretation

Fixed asset turnover measures revenue per dollar of average net property, plant and equipment. Work the ratio by plant, reconcile the asset rollforward, and separate operating productivity from depreciation effects.

Oct 22, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Inventory to net working capital ratio: formula and use

The inventory to net working capital ratio compares inventory with current assets less current liabilities. Calculate it from a balance-sheet export, reconcile the denominator, and handle small, zero, and negative working-capital balances.

Oct 22, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

NOPAT margin: formula and operating tax assumptions

NOPAT margin divides after-tax operating profit by revenue while excluding financing effects. Work through business-unit P&Ls, document operating tax assumptions, and reconcile NOPAT to net income.

Oct 22, 20265 min read
Finance metrics and formulas · Manufacturing

Overall operations effectiveness (OOE): formula and use

Calculate overall operations effectiveness using an explicit operating-time denominator. Reconcile scheduled exclusions, production losses and good output, then compare OOE with OEE on the same records.

Oct 22, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Profit vs profitability: dollars, margins and returns

Profit is an amount; profitability describes performance relative to sales or the resources used. Work the same annual financial rows both ways and see how profit dollars can rise while margins and investment returns fall.

Oct 22, 20266 min read
Finance metrics and formulas

Retail industry ratios: inventory, margins and cash

Use retail ratios to compare store margins, stock productivity and liquidity across matched seasonal periods. A worked store example reconciles revenue and inventory to operating profit, then explains why profit and cash differ.

Oct 22, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Working Capital to Total Assets Ratio: Formula and Example

Working capital to total assets measures the current-asset surplus relative to the entire asset base. Work through the balance-sheet rows, prove the calculation, and see why borrowing or debt reclassification can change the result.

Oct 22, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Accounting aging method for estimating bad debts

Apply company-approved loss rates to receivable aging buckets to calculate a required allowance. This worked example shows invoice-level aging, spreadsheet formulas and the adjustment from the recorded allowance balance.

Oct 21, 20265 min read
Finance metrics and formulas

AOV meaning in marketing: average order value and formula

AOV is net order revenue divided by eligible orders. Calculate it from an order export, compare channels on the same basis, and reconcile the result before deciding whether larger baskets improve profitability.

Oct 21, 20265 min read
Finance metrics and formulas

Content marketing ROI: formula, costs and attribution

Calculate content marketing ROI from attributed contribution and complete production and distribution costs. Work through an asset-level example, reconcile shared costs and handle long conversion windows without claiming causal lift.

Oct 21, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

EVA vs ROIC: economic profit and the cost of capital

EVA reports operating profit after a capital charge in dollars, while ROIC reports an operating return percentage. Calculate both for the same business units, reconcile the totals, and see why a lower percentage can still add economic profit.

Oct 21, 20266 min read
Finance metrics and formulas · Healthcare

Healthcare working capital: operating cash drivers

Healthcare working capital shows how current assets and liabilities support day-to-day operations. Compare receivable aging, supply inventory and supplier payables across provider units, then reconcile the movement to cash.

Oct 21, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Rollforward accounting: reconcile opening to closing balances

Rollforward accounting explains how posted movements take an account from its opening balance to its closing balance. Build the schedule from a ledger export, calculate it in a spreadsheet and investigate any difference against the closing trial balance.

Oct 21, 20265 min read
Finance metrics and formulas · Software

SaaS gross margin: define cost of revenue consistently

SaaS gross margin measures revenue left after delivery costs. Classify hosting, support and other delivery costs consistently, reconcile product margins, and separate real changes from accounting reclassifications.

Oct 21, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Ways to improve cash flow: prioritize operating actions

Find a practical way to improve cash flow by comparing overdue invoices, avoidable inventory purchases, payment dates and operating commitments. A worked weekly action table separates cash released from payments moved within the month.

Oct 21, 20266 min read
Finance metrics and formulas · Sales teams

Average cost per lead by industry: compare matched benchmarks

Use dated US industry benchmarks without confusing inquiries, qualified leads and customers. See how channel, cost scope, sales timing and weighting change a cost per lead comparison, with a worked example from supplied campaign data.

Oct 20, 20266 min read
Finance metrics and formulas · Software

Average cost per lead for SaaS: connect leads to customers

Calculate SaaS cost per lead from campaign and CRM exports, then follow the same leads into opportunities and customers. This worked example connects lead costs to acquisition cost and gross-profit payback.

Oct 20, 20265 min read
Finance metrics and formulas · Sales teams

B2B cost per lead: compare quality and conversion

B2B cost per lead becomes useful when contact counts connect to qualified accounts and opportunities. Build a cohort report from campaign and CRM exports, with spreadsheet formulas and checks for account duplication and sales-cycle timing.

Oct 20, 20265 min read
Finance metrics and formulas · Compliance

Business Compliance Cost Analysis

Measure compliance spending by obligation, department and reporting period. Build labor, vendor and remediation totals, state shared-cost allocations and reconcile the result to your expense records.

Oct 20, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash turnover ratio: formula and interpretation

Cash turnover compares revenue with the average cash balance supporting the period. Calculate it from matched financial exports, check the denominator, and separate sales growth from a shrinking liquidity buffer.

Oct 20, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Consolidated income statement: a worked example

A consolidated income statement combines entity results and removes transactions inside the group. Follow a complete parent-and-subsidiary example, check the eliminations, and see why changing an internal interest rate does not change group profit.

Oct 20, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial debt: what to include and how to calculate it

Financial debt sums the borrowing balances included by a stated reporting policy. This guide reconciles loans, notes, current maturities and finance lease liabilities to balance-sheet accounts, with checks for double counting and carrying-value differences.

Oct 20, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Net debt to EBITDA: formula and interpretation

Net debt to EBITDA subtracts eligible cash from defined borrowing before comparing it with trailing earnings. This guide works through the cash policy, debt and earnings rows, a repayment example and the checks that make leverage comparisons useful.

Oct 20, 20265 min read
Finance metrics and formulas · Banking

Tier 1 risk-based capital ratio: formula and interpretation

The Tier 1 risk-based capital ratio divides approved Tier 1 capital by reported risk-weighted assets. Follow a quarterly workbook example, separate numerator and denominator changes, and reconcile the result to its source schedules.

Oct 20, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Accounts receivable to working capital ratio: formula and checks

The accounts receivable to working capital ratio compares net trade receivables with current assets minus current liabilities. Work it from balance-sheet rows, check collections and liability changes separately, and handle zero or negative working capital.

Oct 19, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Aging of accounts receivable method: estimate credit losses

The aging of accounts receivable method applies documented loss rates to aged customer balances. Work through a required allowance, its reconciliation to the existing balance and a sensitivity using management-supplied assumptions.

Oct 19, 20265 min read
Finance metrics and formulas · Sales teams

Billboard advertising ROI: measure campaign outcomes

Calculate billboard and other out-of-home campaign returns from matched sales, contribution and complete campaign costs. A worked example separates tracked response from geographic comparisons and explains what neither can prove about incremental sales.

Oct 19, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow vs revenue: why sales and cash differ

Revenue measures earned sales, while cash flow measures receipts and payments. Reconcile the same month's sales, receivables, customer advances and bank movements with a worked US company example.

Oct 19, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash return on capital invested: formula and example

Cash return on capital invested compares cash earnings with the operating capital supporting them. Define the numerator and denominator, calculate returns for two business units, and reconcile the result to working capital movements.

Oct 19, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash to working capital ratio: formula and limits

The cash to working capital ratio divides cash by net working capital. Calculate it from balance-sheet exports, compare periods, and see why a shrinking or negative denominator changes its meaning.

Oct 19, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

DSO calculation with deferred revenue

See how advance billing and deferred revenue change a DSO denominator. Reconcile receivables, billings and recognized revenue with spreadsheet formulas and explicit assumptions.

Oct 19, 20265 min read
Finance metrics and formulas · Manufacturing

First-pass yield KPI: formula and production example

First-pass yield measures the share of units that pass a defined operation without rework. Learn which production rows belong in the denominator, calculate a weighted result across lots, and reconcile first-pass failures with final acceptance.

Oct 19, 20267 min read
Finance metrics and formulas · Finance and FP&A teams

Inventory carrying value: cost, reserves and reconciliation

Inventory carrying value is the inventory balance recognized after applicable valuation adjustments. Reconcile gross cost, reserves and net inventory by category, then explain differences between the valuation export and the ledger.

Oct 19, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Locational Break-Even Analysis: Compare Site Costs

Locational break-even analysis compares alternative sites at the same operating volume. Calculate site cost lines, pairwise crossover volumes and the least-cost operating ranges, with spreadsheet formulas and a three-site example.

Oct 19, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Operating income per employee: formula and use

Operating income per employee divides operating profit by average full-time equivalent staffing. Work through a business-unit example, reconcile the total, and see which staffing and cost choices change the comparison.

Oct 19, 20265 min read
Finance metrics and formulas

Tire business profit margin: sales and service costs

Measure tire-store profitability from tire sales, installation revenue, product cost and shop expenses. Use a worked store comparison to separate merchandise margin, direct profit and operating profit, with checks that tie back to the workbook.

Oct 19, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Average Debt to Capital Ratio by Industry: US Benchmarks

Compare dated US industry debt-to-capital references without mixing book and market values. Build a consistent peer workbook, calculate the company and group ratios, and explain the limits of the comparison.

Oct 18, 20266 min read
Finance metrics and formulas · Supply chain

Cost per order: fulfillment cost formula and example

Cost per order divides defined fulfillment spending by the orders it served. Work through a warehouse and channel example, reconcile the totals, and separate fulfillment expense from customer acquisition.

Oct 18, 20264 min read
Finance metrics and formulas · Financial services

Fintech unit economics: revenue and cost per transaction

Fintech unit economics measures what each transaction contributes after processing, losses and servicing. Follow a worked US payments example, reconcile the totals, and see how product and customer cohorts change the result.

Oct 18, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Non financial ratios: operational measures with examples

Nonfinancial ratios measure conversion, capacity use and service delivery from business records. Work through a US service company's branch results, calculate the combined rates and change one input to see the effect.

Oct 18, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Opening balance sheet: balances and reconciliation

An opening balance sheet carries assets, liabilities and equity into a new reporting period. Reconcile prior closing exports to opening balances, separate approved changes and investigate differences that a balanced statement can hide.

Oct 18, 20264 min read
Finance metrics and formulas · Finance and FP&A teams

Profit per employee: formula and meaningful comparisons

Profit per employee divides a defined profit measure by average staffing. Work through gross and net profit per FTE, reconcile the company total and separate staffing changes from margin changes.

Oct 18, 20266 min read
Finance metrics and formulas · Sales teams

TV advertising ROI: measure contribution and cost

Calculate television advertising return from matched campaign revenue, contribution and complete production and placement costs. A worked market comparison shows the spreadsheet formulas, reconciliation checks and effect of a longer observation window without treating attribution as causal lift.

Oct 18, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash contribution margin: meaning and calculation

Cash contribution margin measures sales left after an explicitly defined set of variable cash costs. Compare two products, reconcile the result to ordinary contribution and separate cost behavior from the timing of receipts and payments.

Oct 17, 20265 min read
Finance metrics and formulas · Procurement

Cost avoidance vs cost savings: what to report to the CFO

A finance and procurement guide to historical and counterfactual savings baselines, with a checked price-reduction example, an avoided supplier increase and the evidence needed before reporting a benefit to the CFO.

Oct 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cost control examples: from variance to action

Work through a distributor's budget overrun, separate extra activity from higher unit costs, and test an operating response. The example reconciles every variance to the ledger and shows why released capacity is different from cash savings.

Oct 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cross-sectional analysis of financial statements

Compare companies over the same reporting period using consistent financial statement definitions. This guide builds a peer worksheet, calculates comparable ratios and shows how to check the results before interpreting a gap.

Oct 17, 20265 min read
Finance metrics and formulas

Earned value management: CPI, SPI and estimate at completion

A program-budget guide to planned value, earned value and actual cost, with checked CPI, SPI, EAC, ETC and VAC formulas, a worked work-package table and the assumptions a finance lead must approve.

Oct 17, 20266 min read
Finance metrics and formulas

Ecommerce gross margin: costs, returns and product mix

Ecommerce gross margin starts with net sales after discounts and returns, then deducts matched cost of sales. Work through an order and return reconciliation, check recovered inventory cost, and separate product economics from changes in sales mix.

Oct 17, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Equity-to-Total-Assets Ratio: Formula and Example

The equity-to-total-assets ratio measures book equity as a share of total assets. Calculate it from a balance sheet, reconcile the result, and compare entities with consistent ownership and consolidation boundaries.

Oct 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Financial analytics: connect profit, cash and business decisions

Financial analytics connects financial and operational evidence to a business decision. See how it extends beyond FP&A and KPI reporting, with a worked revenue, margin and receivables example and a practical starting point using the exports a finance desk already holds.

Oct 17, 20267 min read
Finance metrics and formulas · Finance and FP&A teams

Flux analysis: explain balance sheet and P&L movements

Flux analysis compares account balances or period activity, flags movements for review and explains them with evidence. A worked balance sheet and P&L table shows thresholds, zero-balance exceptions and an accounts-receivable roll-forward that closes exactly.

Oct 17, 20267 min read
Finance metrics and formulas

Marketing ROI vs ROAS: formulas and the margin test

Marketing ROI asks whether the contribution associated with a campaign covers its marketing cost. ROAS compares attributed revenue with ad spend. A worked USD example shows why the same ROAS can produce a positive return or only break even, and what a finance partner must check before changing the budget.

Oct 17, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

P&L balance sheet comparison: how the statements connect

The P&L reports profit over a period, while the balance sheet reports balances at a date. Work the same distributor transactions through both statements and reconcile profit, retained earnings and cash.

Oct 17, 20266 min read
Finance metrics and formulas · Sales teams

Sales cycle length: calculate and diagnose deal timing

Sales cycle length measures elapsed days from a defined starting event to close. Calculate the mean and median, reconcile stage time and keep open-deal aging separate from completed durations.

Oct 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Senior leverage ratio: formula and covenant checks

Senior leverage ratio compares agreement-defined senior debt with agreement-defined earnings. Work through the debt classification, EBITDA bridge, and arithmetic checks before comparing the result with a covenant limit.

Oct 17, 20265 min read
Finance metrics and formulas · Legal services

Law firm financial analysis by practice and matter

Compare practice contribution with billing realization and the value tied up in matters. Work from time, billing, cost and receivables exports, then reconcile the practice review to the firm's records.

Oct 16, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Return on incremental invested capital: formula and example

Return on incremental invested capital compares added after-tax operating profit with additional capital committed. Work a period-matched example, reconcile the capital increase, and separate the result from average ROIC.

Oct 16, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Accounts receivable aging: buckets, report and example

Accounts receivable aging groups unpaid invoice balances by how far they are past due. Build a report from an invoice export, reconcile its buckets to the ledger and identify the customers behind overdue balances.

Oct 15, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Aerospace and defense debt-to-equity ratio

Compare aerospace and defense leverage using a dated peer workbook with consistent debt and equity definitions. A fictional US supplier example shows lease treatment, aggregation and the effect of a share repurchase.

Oct 15, 20265 min read
Finance metrics and formulas

Amazon profitability analysis: reconcile sales and costs

Compare Amazon SKU contribution using sales, settlement, fee, advertising, and product-cost exports. Work through the spreadsheet formulas, reconcile contribution to the settlement, and separate product economics from company operating profit.

Oct 15, 20266 min read
Finance metrics and formulas · Sales teams

Average cost per lead for B2C: compare benchmarks and purchases

Compare B2C lead costs using dated US benchmarks and consistent consumer lead definitions. A worked campaign example connects media spending to valid leads, qualified consumers and purchases without assuming a universal average.

Oct 15, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cost benefit analysis: sensitivity analysis and thresholds

Sensitivity analysis shows which assumptions can reverse a cost-benefit decision. Use discounted cost and benefit streams to test rates, realization and timing, then calculate the switching values.

Oct 15, 20265 min read
Finance metrics and formulas · Healthcare

Cost per lead for dentists: measure campaign efficiency

Cost per lead for dentists connects campaign spending with qualified inquiries. Compare dental marketing sources using consistent lead definitions, then check booking and attendance before deciding where to spend.

Oct 15, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Dividends payable on the cash flow statement: the indirect method

Dividends payable reconciles declared dividends to cash dividends paid. Work through the liability rollforward, retained earnings check and financing cash flow without treating a declaration as a payment.

Oct 15, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

DSCR: debt service coverage ratio formula and example

DSCR compares cash available for debt service with required principal and interest payments. Work through a business example, distinguish cash-flow and EBITDA conventions, and reconcile the result to the repayment schedule.

Oct 15, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Ending accounts payable formula: reconcile the balance

Reconcile supplier opening balances, credit purchases, payments and adjustments to ending accounts payable. A worked supplier table shows the movement calculation and the checks against the closing ledger.

Oct 15, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial statement risk assessment for business teams

Assess operating financial resilience by comparing liquidity, leverage and cash conversion across reporting periods. Follow a worked statement review with spreadsheet formulas, cash reconciliation and clear owners for the questions it raises.

Oct 15, 20266 min read
Finance metrics and formulas · Hospitality

Food truck break even analysis: sales per trading day

Calculate the orders a food truck needs to cover an event and its share of monthly operating costs. Work through food, packaging, venue fees and limited selling days with a complete example.

Oct 15, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Gross margin vs EBITDA margin: what each leaves out

Gross margin and EBITDA margin measure profit at different cost boundaries. Compare both from the same business-unit P&L, trace depreciation correctly, and reconcile the difference before deciding which unit performs better.

Oct 15, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Operating capital: what to include and how to measure it

Operating capital combines operating working capital with net long-term assets used in the business. Build a consistent account map, compare business units and reconcile their balances to the company total.

Oct 15, 20266 min read
Finance metrics and formulas · Financial services

Payment business performance metrics that explain results

Payment performance depends on transaction counts, settled value, retained revenue and the cost of processing and supporting merchants. Work through a segment comparison and see why greater payment volume can raise contribution while lowering revenue yield.

Oct 15, 20266 min read
Finance metrics and formulas

Profit margin on blinds: measure each completed job

Measure profit margin on blinds from completed orders, supplier costs and installation records. Separate product gross profit from job contribution, including freight, commission and rework.

Oct 15, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Return on invested capital: formula and interpretation

Return on invested capital compares after-tax operating profit with average invested capital. Calculate NOPAT, reconcile the capital base, and interpret a worked business-unit return against its operating drivers and capital hurdle.

Oct 15, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

ROI and ROIC: investment return versus operating capital

ROI and ROIC answer different business questions because their profit definitions, capital bases, and time periods can differ. Compare both on one equipment investment, then connect the project result to a business unit's operating return.

Oct 15, 20266 min read
Finance metrics and formulas · Consumer goods

T-shirt business profit margin: costs and calculation

Calculate T-shirt margins from net sales, shirt and printing costs, fulfillment and selling expenses. Work through a product-and-channel example, reconcile it to operating profit, and see which costs belong at each level.

Oct 15, 20265 min read
Finance metrics and formulas · Banking

Wholesale funding ratio: formula and interpretation

The wholesale funding ratio shows reliance on a stated set of wholesale funding sources. Work the ratio from classified bank balances, reconcile the denominator and compare funding changes without implying a universal regulatory formula.

Oct 15, 20266 min read
Finance metrics and formulas · Banking

Balance sheet ratios for banks: read funding and asset mix

Balance sheet ratios for banks connect lending, deposit funding, borrowings, available assets and accounting equity. Use a reconciled bank example to compare two quarters, explain the combined movement and assign the follow-up questions.

Oct 14, 20266 min read
Finance metrics and formulas

Break-even template in Google Sheets

Build a Google Sheets break-even layout from product prices, variable costs and monthly fixed costs. Reproduce the formulas, test whole-unit rounding and check the sales threshold against total cost.

Oct 14, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Capital utilization: measure how assets support sales

Capital utilization examines how the capital committed to operations supports activity. Define the capital base, separate assets in use from idle and pre-use balances, and compare business units without confusing book value with physical capacity.

Oct 14, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow vs fund flow: cash and working capital

Cash flow measures cash movement, while traditional fund flow measures changes in working capital. Reconcile both from the same balance sheets and supporting schedules.

Oct 14, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

EBITDA to FCF: reconcile profit to cash

Reconcile EBITDA to free cash flow through cash interest, taxes, working capital and capital spending. Follow a two-quarter example, worksheet formulas and a check against operating cash flow.

Oct 14, 20266 min read
Finance metrics and formulas · Consumer goods

Examples of high margin products: compare real contribution

A product with a high gross margin can still contribute little after fulfillment and selling costs. Compare three illustrative products, change one cost input, and reconcile the result to the business total.

Oct 14, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Finance costs in the income statement: interest and checks

Finance costs usually appear as interest expense in a US income statement. Build a facility-level schedule, separate capitalized interest and reconcile the expense to reported profit.

Oct 14, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

International working capital: currency and payment timing

Compare receivables, inventory and payables across currencies using supplied exchange rates. Separate operating changes from currency effects and test cross-border collection and transit assumptions.

Oct 14, 20265 min read
Finance metrics and formulas · Banking

Liquid Assets to Total Assets: A Bank Liquidity Ratio

Calculate a bank's defined liquid assets as a share of total assets using consistent quarterly balances. This worked example shows the classifications, reconciliation, and difference from the liquidity coverage ratio.

Oct 14, 20266 min read
Finance metrics and formulas · Banking

Microfinance ratio analysis for US business lenders

Compare portfolio quality, operating sustainability and short-term cash coverage at a US mission-based business lender. Work from loan, expense and cash exports with explicit definitions and checks that reconcile branch results.

Oct 14, 20266 min read
Finance metrics and formulas

Retail P&L analysis: sales, markdowns and store costs

Trace retail profit changes from list-price sales through markdowns, returns and store expenses. Build a comparable-store worksheet, separate category mix from margin changes, and reconcile the result to the ledger.

Oct 14, 20265 min read
Finance metrics and formulas

Sales velocity in real estate: units sold over time

Property sales velocity measures net unit sales over a defined period. Use developer exports to reconcile contracts, cancellations and available inventory, then compare project pace and months of supply.

Oct 14, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Working capital employed: working capital vs. capital employed

Working capital measures the net current-asset position, while capital employed includes noncurrent assets. Compare both from one balance-sheet export, reconcile the totals, and separate operating capital from cash and borrowing.

Oct 14, 20265 min read
Finance metrics and formulas · Banking

Bank leverage ratio: formula and interpretation

A bank leverage ratio compares Tier 1 capital with a defined asset or exposure base. See the US Tier 1 leverage calculation, a supplied-input example, and the distinction from supplementary and risk-based capital ratios.

Oct 13, 20266 min read
Finance metrics and formulas · Manufacturing

Cost per equivalent unit: formula and worked example

Calculate process costs for completed output and partly finished production using the weighted-average method. Separate materials from conversion work, assign costs, and reconcile the production schedule to its cost pool.

Oct 13, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Foreign currency cash flow statement example

Translate foreign-currency receipts and payments into USD, then calculate the separate exchange-rate effect on cash. This example reconciles a US company's foreign subsidiary and changes one closing rate to show what moves.

Oct 13, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Gross leverage ratio: debt before cash offsets

Gross leverage ratio compares debt before cash offsets with a stated earnings measure. Rebuild the calculation from a debt schedule and income statement, reconcile the inputs, and distinguish gross from net leverage.

Oct 13, 20265 min read
Finance metrics and formulas · Banking

Loan portfolio analysis in banks: balances and past dues

Compare loan balances, past-due amounts, maturities and product concentration on one reporting date. Use a worked portfolio summary, exact spreadsheet formulas and reconciliation checks.

Oct 13, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Negative cash flow from operating activities: causes

Negative operating cash flow means operations used more cash than they generated. Separate recurring losses from receivables, inventory and payment timing, then reconcile the result to cash receipts and payments.

Oct 13, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Operating ratio analysis: formula and interpretation

Operating ratio analysis compares total operating costs with net sales. Work through the ledger rows, business-unit calculations and reconciliations that explain a change between periods.

Oct 13, 20266 min read
Finance metrics and formulas · Telecommunications

Telecommunications industry financial ratios for business reviews

Telecommunications financial ratios connect operating margins, network capital spending and cash generation. Work through a matched quarterly example and the checks needed for a consistent business review.

Oct 13, 20266 min read
Finance metrics and formulas

Capital statement formula: beginning to ending equity

Reconcile beginning owner capital, contributions, net income, and distributions to ending equity. Follow a book-capital example for a US LLC, identify the export rows, and prove the result against the balance sheet.

Oct 12, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow from investing: components and interpretation

Cash flow from investing records cash spent on and received from long-lived assets and investments. Learn which receipts and payments belong here, how securities change the analysis, and how to reconcile the total.

Oct 12, 20266 min read
Finance metrics and formulas · Construction

Construction project profitability analysis

Compare construction contract revenue with incurred costs and supplied remaining-cost estimates. Separate booked profit from forecast final margin, with worked project tables and spreadsheet checks.

Oct 12, 20265 min read
Finance metrics and formulas · Consumer goods

Consumer packaged goods financial analysis

Connect brand net sales, trade spending, margins and working capital in one operating review. Follow a worked CPG example from sales and accrual exports to a checked contribution and cash bridge.

Oct 12, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Debt to EBITDA ratio: formula and interpretation

The debt EBITDA ratio compares gross interest-bearing debt with earnings before interest, taxes, depreciation and amortization. Reconcile both inputs, work through a US company example, and separate borrowing changes from earnings changes.

Oct 12, 20266 min read
Finance metrics and formulas

Direct marketing ROI: match responses to contribution

Measure direct marketing ROI from matched response and purchase records. Calculate contribution after refunds and order costs, include the full campaign cost, and reconcile the result to finance exports.

Oct 12, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Fixed asset ratio: formula and funding interpretation

The fixed asset ratio compares fixed assets with a stated capital base. Work through net PP&E, long-term funding, competing denominator conventions, and the balance-sheet check that explains the result.

Oct 12, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Industry ratios: compare financial performance with peers

An industry ratio is useful only when the peers and accounting definitions fit the business. Use a fictional US distributor workbook to compare profitability, liquidity and leverage without turning unlike companies into a misleading benchmark.

Oct 12, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Insurance Company Liquidity Ratio: Claims Cash Coverage

An insurance company liquidity ratio compares available assets with a specified set of obligations. Build a claims cash view from finance exports, reconcile the assets and payments, and test whether cash arrives before it is needed.

Oct 12, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Interest expense ratio: formula and cost boundaries

An interest expense ratio compares financing cost with a stated base. Calculate interest as a share of revenue from P&L exports, reconcile the included accounts, and separate it from interest coverage.

Oct 12, 20265 min read
Finance metrics and formulas · Financial services

Investment income ratio: an insurer earnings measure

The investment income ratio compares an insurer's net investment income with earned premiums under a stated convention. Follow a worked quarterly example, reconcile the numerator and denominator, and distinguish this earnings measure from portfolio yield.

Oct 12, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Long-term debt-to-assets ratio: formula, scope and a worked example

Calculate long-term debt as a share of total assets from a balance-sheet export and maturity schedule. See how current maturities, leases and reclassification affect the result without changing total borrowing.

Oct 12, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Net debt to equity ratio: formula and interpretation

The net debt to equity ratio subtracts eligible cash from defined debt before dividing by book equity. Follow a worked balance-sheet example, reconcile gross and net leverage, and separate cash movements from borrowing changes.

Oct 12, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Return on equity by industry: compare peers fairly

Compare return on equity across dated US industry peers using consistent earnings and average common equity. Worked examples show how weighting and leverage can change the apparent ranking.

Oct 12, 20265 min read
Finance metrics and formulas · Investment management

Asset management cost analysis by fund and client

Separate an asset management firm's direct expenses from shared service and reporting costs. Build a fund and client-segment cost view from expense and activity workbooks, then reconcile the allocations to the firm's operating total.

Oct 11, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Average current ratio by industry: compare matched peers

An average current ratio needs a dated peer group, consistent classifications and a stated averaging method. Work through fictional US wholesale and retail examples, then explain the cash, receivables and inventory behind the ratios.

Oct 11, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Bad debt analysis by customer, aging and write-off

Bad debt analysis connects open invoices with the balances eventually written off. Work through an invoice reconciliation, an overdue aging and a comparison of customer cohorts without confusing those diagnostics with an allowance estimate.

Oct 11, 20265 min read
Finance metrics and formulas · Accounting

Cash basis balance sheet: what it shows and omits

A cash basis balance sheet reports balances under a stated cash accounting policy. Compare a worked cash-basis report with its accrual adjustments, prove the equity balance, and identify the missing information before making decisions.

Oct 11, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Debt to equity by industry: compare suitable peers

Debt to equity by industry is useful only when peers share a clear debt definition, equity basis and reporting date. Build a comparable peer workbook, calculate a median and pooled ratio, and explain changes caused by the equity denominator.

Oct 11, 20265 min read
Finance metrics and formulas · Sales teams

Facebook advertising ROI: measure profit after campaign costs

Measure Facebook advertising ROI using reconciled sales, direct costs, and the full campaign investment. Work the calculation in Excel and check that every cost appears once.

Oct 11, 20265 min read
Finance metrics and formulas · Pharmaceuticals

Pharmaceutical industry financial ratios for operating reviews

Choose pharmaceutical ratios for product margin, research spending and working capital. A worked US company example connects gross-to-net deductions, operating costs and inventory days without inventing an industry target.

Oct 11, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

R&D on the cash flow statement: expense, payments and assets

R&D expense does not equal the cash paid for research and development. Reconcile noncash costs, project accruals and separately approved capital spending to understand the operating and investing outflows.

Oct 11, 20266 min read
Finance metrics and formulas

Real estate cost per lead: compare channels

Calculate a brokerage's cost per inquiry and qualified lead from campaign and CRM exports. Follow each channel through closed deals and contribution before changing the budget.

Oct 11, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

ROIC vs WACC: measure the return above capital cost

Compare ROIC with a finance-approved WACC on the same annual, after-tax basis. Work two business units from operating profit and capital schedules through percentage-point spreads and dollar capital charges.

Oct 11, 20266 min read
Finance metrics and formulas · Wealth managers

Wealth management business model: fees and profitability

A wealth management business earns advisory and planning fees while paying for the people and services that support each household. Work through a fee-to-contribution example, then see how additional service hours change segment profitability.

Oct 11, 20266 min read
Finance metrics and formulas · Banking

Bank balance sheet: assets, funding and equity

A bank balance sheet shows the assets a bank holds and the deposits, borrowings and equity that fund them. Compare two periods with a worked operating-bank example, mix ratios and reconciliation checks.

Oct 10, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Capital structure ratios: compare debt and equity funding

Capital structure ratios show how debt, equity and other liabilities fund a business. Read debt-to-equity, debt-to-capital and equity-to-assets together, reconcile the balance sheet, and separate a funding-mix change from growth in absolute borrowing.

Oct 10, 20266 min read
Finance metrics and formulas · Manufacturing

Cost per unit Excel template

Build a cost per unit workbook with separate cost, output and overhead schedules. Use the example layout, formulas and reconciliation checks to compare products on a consistent basis.

Oct 10, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Debt-to-equity vs. debt-to-assets ratio: the same debt, different bases

Compare debt to equity and debt to assets using the same balance sheet. Work through the debt definition, both denominators, the reconciliation and the decisions each ratio supports.

Oct 10, 20266 min read
Finance metrics and formulas · Manufacturing

Garment business profit margin: production and order costs

Calculate garment manufacturing margins from order revenue, fabric consumption, labor and rework. Follow a worked production-order example, spreadsheet formulas and checks that separate factory gross profit from order contribution.

Oct 10, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Government grants on the cash flow statement

Reconcile government grant cash receipts with recognized income and deferred balances. See why a US business must establish its accounting policy before classifying the receipt.

Oct 10, 20265 min read
Finance metrics and formulas · Sales teams

ROI on radio advertising: measure response and contribution

Measure radio campaign return from station costs, tracked responses, and matched sales. Use a worked market comparison and spreadsheet formulas that separate attributed contribution from evidence of incremental impact.

Oct 10, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Sales commission in income statement: expense and payments

Sales commission expense can differ from the amount paid during the month. Follow a worked US example that reconciles the income statement, commission payable and deferred contract acquisition costs.

Oct 10, 20266 min read
Finance metrics and formulas · Manufacturing

Average manufacturing cost per unit: formula and example

Average manufacturing cost per unit divides consistently scoped production costs by the units they produced. Work through a plant comparison, separate the cost components and reconcile the result to production and finance records.

Oct 9, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash-Free, Debt-Free Working Capital at Closing

Cash-free, debt-free transaction terms separate operating working capital from cash, debt and other agreed closing items. Follow a worked acquisition adjustment, see who owns the classifications, and check that every balance enters the price calculation once.

Oct 9, 20266 min read
Finance metrics and formulas · Construction

Construction in progress on the cash flow statement

Reconcile an owner's construction-in-progress balance to cash capital spending. Separate additions, transfers to completed assets and capital payables, with a worked project reconciliation and cash-flow classification checks.

Oct 9, 20265 min read
Finance metrics and formulas · Sales teams

Cost per acquisition by industry: compare like with like

Industry CPA comparisons are useful only when acquisition definitions, cost scope and measurement windows match. Use a worked campaign example to build a defensible internal baseline before comparing an outside benchmark.

Oct 9, 20266 min read
Finance metrics and formulas · Banking

Credit ratio analysis for business borrowers

Compare a business borrower's liquidity, leverage and debt-service capacity across reporting periods. Build a consistent workbook, reconcile its inputs and explain why stable headline ratios can hide weaker repayment capacity.

Oct 9, 20266 min read
Finance metrics and formulas · Sales teams

Google Ads ROAS: calculate and reconcile revenue

Calculate Google Ads ROAS from campaign spending and attributed sales. Reconcile conversion values, refunds, attribution windows, and finance revenue before comparing campaigns.

Oct 9, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

How to improve free cash flow

Improve free cash flow by separating customer collections, inventory purchases, operating payments and capital spending. Use a worked quarterly bridge to distinguish lasting savings from cash brought forward or spending deferred.

Oct 9, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Intangible assets on the cash flow statement: reconcile them

Intangible-asset additions are not the same as cash paid. Reconcile purchased assets, capitalized software costs, business acquisition allocations and noncash amortization to their cash flow lines.

Oct 9, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Liquidity vs solvency: short-term and long-term capacity

Liquidity and solvency measure payment capacity over different horizons. Use one balance sheet, income schedule and dated payment list to distinguish a near-term cash shortfall from longer-term financial capacity.

Oct 9, 20267 min read
Finance metrics and formulas · Finance and FP&A teams

Net Asset Turnover Ratio: Formula and Interpretation

Net asset turnover compares revenue with the net operating assets supporting it. Define the denominator, classify balances consistently, and work an example with an independent funding reconciliation.

Oct 9, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Net liquidity position formula: scope and worked example

Calculate a net liquidity position from unrestricted liquid assets and obligations due within a stated horizon. Reconcile the result by entity and distinguish it from working capital and liquidity ratios.

Oct 9, 20265 min read
Finance metrics and formulas · Software

SaaS ARR: definition, calculation and recurring revenue bridge

SaaS ARR annualizes recurring subscription charges under a stated company policy. Calculate it from contract lines, reconcile customer movements and keep it separate from bookings and recognized revenue.

Oct 9, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Debt-to-Current-Assets Ratio: Formula and Debt Definition

The debt-to-current-assets ratio compares defined borrowings with current assets. Work through the export rows, distinguish it from the current ratio, and check how borrowing and asset changes affect the result.

Oct 8, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Enterprise value to equity value: the debt and cash bridge

Move from an approved enterprise value to common equity value using debt, eligible cash and agreed transaction adjustments. Reconcile a worked bridge to the balance sheet, debt schedule and closing workbook.

Oct 8, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash EBITDA margin: define and reconcile the measure

Cash EBITDA margin divides a company-defined cash EBITDA measure by revenue. Define the adjustments, rebuild a worked example from earnings and settlement rows, and reconcile the result separately to operating cash flow.

Oct 7, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Debt to Capital Ratio: Formula and Interpretation

The debt to capital ratio shows debt as a share of debt plus equity. Calculate it from a balance-sheet export, reconcile the inputs, and distinguish financing changes from changes in retained earnings.

Oct 7, 20265 min read
Finance metrics and formulas · Consumer goods

Essential oil profit margin: product costs and channels

Essential oil margins depend on the full bottle cost and the channel used to sell it. Work through a US brand's product and channel contribution, reconcile the totals, and identify who should act on the result.

Oct 7, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Operating cash flow vs free cash flow: compare the bridge

Operating cash flow measures cash generated by operations; free cash flow deducts capital spending. Compare both using the same statement rows and explain why stronger operations can coincide with lower cash after reinvestment.

Oct 7, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Public company financial statements: where to find them

Find US public-company statements in SEC filings and identify the right reporting periods. Build a consistent comparison from downloaded income statement, balance sheet and cash flow figures, then check the totals.

Oct 7, 20265 min read
Finance metrics and formulas · Software

Software industry financial ratios: margins, cash and costs

Software financial ratios connect delivery margins, operating spending and cash generation. Use a worked quarterly comparison to build a consistent finance scorecard from revenue, cost and cash exports.

Oct 7, 20266 min read
Finance metrics and formulas · Banking

Tangible common equity ratio: formula and limitations

Calculate the tangible common equity ratio from a bank's balance sheet and stated intangible adjustments. A two-period example reconciles tangible common equity to tangible assets and explains why the result differs from regulatory capital.

Oct 7, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash variance: reconcile expected and counted cash

Cash variance is the difference between counted and expected physical cash. Reconcile opening floats, cash receipts, refunds, and deposits by store and day, then investigate overages and shortages without letting them offset each other.

Oct 6, 20266 min read
Finance metrics and formulas · Education

Cost benefit analysis in education: program investments

Education providers can compare a program's incremental delivery costs with the institutional cash benefits it creates. Work from enrollment and staffing assumptions to a discounted result, then check what the decision leaves out.

Oct 6, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Gross vs net revenue recognition: principal or agent?

Understand the US ASC 606 principal-versus-agent presentation decision. Reconcile gross transaction billings, supplier amounts and recognized revenue using an approved classification schedule and a worked example.

Oct 6, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Managing credit risk on the balance sheet

Compare customer receivables, overdue balances and concentration from an aging export. Use spreadsheet formulas and a ledger reconciliation to build a review list finance can explain.

Oct 6, 20264 min read
Finance metrics and formulas · Insurance

Track return commission after cancellations and adjustments

Track signed return commission, its original policy link and the timing of cancellation adjustments. Avoid overstating income.

Oct 6, 20263 min read
Finance metrics and formulas · Finance and FP&A teams

Breakeven price: formula and worked example

Breakeven price is the selling price that covers all included costs at a stated sales volume. Work through a distributor's cost export, compare volume assumptions, and check the effect of percentage fees.

Oct 5, 20265 min read
Finance metrics and formulas · Financial services

Broker dealer business model: revenue and costs

A broker-dealer earns different kinds of revenue from brokerage, principal transactions and account services. Compare those recorded revenues with representative payouts, clearing charges and the cost of serving each client segment.

Oct 5, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash ROE: cash return on equity formula and interpretation

Cash ROE compares operating cash flow with average shareholder equity under a stated convention. Build the numerator from statement exports, reconcile the denominator, and distinguish cash generation from accounting returns and cash available to owners.

Oct 5, 20265 min read
Finance metrics and formulas · Sales teams

Cost per lead: formula and a worked example

Cost per lead divides campaign spending by consistently defined leads. Work through campaign costs, duplicate removal, spreadsheet formulas, and the reconciliation that proves the total.

Oct 5, 20265 min read
Finance metrics and formulas · Hospitality

Hotel Break-Even Analysis: Room Nights and Occupancy

Hotel break-even analysis turns room contribution and monthly costs into required occupied room nights. Work through the export columns, spreadsheet formulas and checks, including ancillary spending and seasonal capacity.

Oct 5, 20266 min read
Finance metrics and formulas · Distribution

Maintained margin formula: markdowns and realized profit

Calculate the merchandise margin retained after markdowns and allowances. Follow a category example from original ticket value to net sales, merchandise cost and the reconciliation back to initial margin.

Oct 5, 20265 min read
Finance metrics and formulas · Banking

Bank return on equity: formula and interpretation

Bank return on equity divides net income by average equity capital. Calculate the ratio from financial statements, reconcile it to return on assets and leverage, and compare periods and peers on a consistent basis.

Oct 4, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Debt to EBITDA: formula and interpretation

Debt to EBITDA compares a defined borrowing balance with trailing earnings before interest, taxes, depreciation and amortization. Work through a debt schedule, an earnings reconciliation and the adjustments that distinguish management leverage from a loan covenant.

Oct 4, 20265 min read
Finance metrics and formulas · Healthcare

Healthcare marketing ROI by service line

Measure healthcare marketing ROI from de-identified service-line collections, delivery costs and campaign spending. Work through the spreadsheet formulas, collection-window choices and checks that keep payer mix and delayed billing visible.

Oct 4, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

LT debt equity ratio: long-term debt formula and meaning

Calculate long-term debt relative to equity and compare it with total debt to equity. Work through current maturities, lease treatment, the balance-sheet reconciliation and changes caused by the equity base.

Oct 4, 20267 min read
Finance metrics and formulas · Finance and FP&A teams

Partnership balance sheet: partner capital and assets

A partnership balance sheet connects business assets and liabilities to each partner's capital. Follow a worked US business example, reconcile capital movements and see how an additional distribution changes cash and equity.

Oct 4, 20265 min read
Finance metrics and formulas · Insurance

Premium is not agency revenue: build two separate measures

Separate placed premium from agency commission and fee income. A worked example shows why premium growth can hide falling revenue.

Oct 4, 20263 min read
Finance metrics and formulas · Insurance

Reconcile split producer credit without duplicating agency income

Allocate shared producer credit with explicit shares. Reconcile credited income to agency income and keep payout rules separate.

Oct 4, 20262 min read
Finance metrics and formulas

Renewable energy industry financial ratios: project cash and debt

Renewable energy project ratios connect operating profit, cash generation and scheduled debt service. Work through an operating project's statements, reconcile the cash bridge and compare results using consistent definitions.

Oct 4, 20266 min read
Finance metrics and formulas · Banking

Working capital in banking: why the usual formula fails

Working capital in banking needs a different interpretation from trade working capital. Compare a bank's asset availability, funding balances, and cash timing with a reconciled example.

Oct 4, 20265 min read
Finance metrics and formulas · Sales teams

Amazon advertising ROI: include fees, returns, and margin

Calculate advertising return from seller revenue, refunds, marketplace fees, product costs, and campaign spend. Build a spreadsheet comparison that preserves the attribution basis and counts each fee once.

Oct 3, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Balance sheet management: assets, funding and risk

Balance sheet management connects asset growth with funding, cash availability, and repayment commitments. This guide works a company comparison and gives finance teams a review process using approved statements and supporting schedules.

Oct 3, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

EBITDA margin bridge: explain the change in points

An EBITDA margin bridge explains how revenue mix, direct costs and operating expenses change the company margin. Work two business units through an exact percentage-point reconciliation and reproduce the spreadsheet formulas.

Oct 3, 20265 min read
Finance metrics and formulas

How to calculate cash and cash equivalents

Classify cash and qualifying equivalents, then reconcile bank and investment records to the balance sheet. Follow a worked example with spreadsheet formulas, separate restricted cash, and prove the reported total.

Oct 3, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Incremental cash flow analysis for business decisions

Incremental cash flow analysis compares cash with and without a proposed business decision. Work through receipts, operating payments, taxes, capital spending and working capital without counting the same cash twice.

Oct 3, 20265 min read
Finance metrics and formulas

Market value of invested capital formula and calculation

Market value of invested capital combines the market values of equity and debt under a stated convention. This guide builds a financing schedule, reconciles book and market values, and compares a change in supplied valuation assumptions.

Oct 3, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Outlier analysis in financial data

Outlier analysis helps finance teams investigate unusual transactions and account movements. Work through an invoice screen, an account variance review and the reconciliation that keeps exceptions connected to the ledger.

Oct 3, 20266 min read
Finance metrics and formulas

SEO content ROI: costs, conversions and contribution

Calculate SEO content ROI using a publication cohort, a fixed outcome window and matched contribution. A worked example follows delayed sales, reconciles costs and explains why attributed organic revenue does not establish causal return.

Oct 3, 20265 min read
Finance metrics and formulas · Manufacturing

WIP variance: reconcile work in process and project costs

WIP variance compares recorded manufacturing work in process with a declared standard for the unfinished work. Reconcile cost movements, value the remaining production stage and explain differences by order.

Oct 3, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Company annual report analysis: a practical review

Company annual report analysis compares financial trends while checking that statement figures agree. Use this practical workflow to capture published numbers, calculate changes and margins, and build a review that distinguishes evidence from explanations.

Oct 2, 20265 min read
Finance metrics and formulas

Customer repeat rate: formula and examples

Customer repeat rate is the share of purchasing customers who buy again within a stated window. Calculate it from distinct customer orders, reconcile the denominator, and distinguish repeat buyers from returning customers and repeat orders.

Oct 2, 20265 min read
Finance metrics and formulas · Industrial distributors

Industrial distribution financial analysis

Industrial distribution financial analysis compares stocked-part margins, service costs and inventory investment. Build a branch review from sales, cost and stock exports with worked spreadsheet formulas and reconciliation checks.

Oct 2, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Interest payable on the cash flow statement: indirect method

Reconcile interest expense, accrued interest and cash payments under US reporting conventions. Work from a debt schedule and bank export, then check that the indirect cash-flow adjustment includes each movement once.

Oct 2, 20265 min read
Finance metrics and formulas · Hospitality

Restaurant break even analysis template: plan against actuals

Build a restaurant break-even worksheet from covers, average check, food costs and staffing assumptions. Compare the plan with actual results and prove the sales threshold with a contribution check.

Oct 2, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

ROE vs ROI: what each return actually measures

ROE and ROI compare earnings with different investment bases. Work the same business workbook both ways, reconcile the numerators, and see when company equity returns and project returns belong in separate comparisons.

Oct 2, 20266 min read
Finance metrics and formulas · Insurance

Separate direct-bill and agency-bill timing in agency reports

Compare commission by billing method without mixing premium collections and agency income. Show timing and source differences.

Oct 2, 20262 min read
Finance metrics and formulas · Sports

Sports Business Cost Analysis

Compare event delivery and venue operating costs with the approved budget. Use consistent shared-cost allocations, calculate cost per attendee and reconcile event totals to expense records.

Oct 2, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Working capital by industry: compare operating cash needs

Compare trade working capital as a share of sales across industries. See which balances to include, a worked comparison, and how operating cycles change the cash a business needs.

Oct 2, 20265 min read
Finance metrics and formulas · Sales teams

Automotive cost per lead: compare benchmarks and sales

Compare automotive cost per lead with dated US search advertising benchmarks. Work from campaign spending to valid inquiries, qualified buyers and recorded sales, with checks that keep the comparison consistent.

Oct 1, 20266 min read
Finance metrics and formulas · Banking

Bank debt-to-equity ratio: deposits and leverage

A bank debt-to-equity ratio depends on whether debt means all liabilities, borrowings alone or interest-bearing funding. Compare the definitions on the same bank balances, reconcile them to assets and equity, and explain the movement across quarters.

Oct 1, 20265 min read
Finance metrics and formulas · Insurance

Build an insurance agency commission-and-fee revenue bridge

Bridge prior agency income to current income using new clients, losses, retained-account movements, fees and adjustments.

Oct 1, 20263 min read
Finance metrics and formulas · Finance and FP&A teams

Cash on the balance sheet: read and reconcile it

Cash on the balance sheet is a balance at a reporting date, supported by bank reconciliations and cash schedules. This guide identifies the included accounts, works a reconciliation, and connects the ending balance to period movements.

Oct 1, 20266 min read
Finance metrics and formulas · Retail banking

Credit union liquidity ratio: inputs and interpretation

Credit union liquidity measures compare cash, short-term investments, loans and funding balances. Follow an NCUA-defined ratio through a worked balance-sheet example, then connect the result to cash availability and ownership of the follow-up.

Oct 1, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Economic balance sheet: compare with book values

An economic balance sheet places supplied valuations beside recorded balances. Compare the adjustments, reconcile the change in equity, and identify the assumptions that need an owner's approval.

Oct 1, 20265 min read
Finance metrics and formulas · Insurance

Explain commission-rate variance in an insurance agency book

Analyze weighted commission yield by line and carrier. Distinguish changes in the business mix from changes in commission terms.

Oct 1, 20262 min read
Finance metrics and formulas · Finance and FP&A teams

Return on net assets formula and a worked example

Return on net assets compares net income with net fixed assets plus a defined working-capital balance. Build the denominator from an approved asset schedule and balance sheet, then reconcile two business units to the company total.

Oct 1, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Return on net operating assets: formula and example

Return on net operating assets matches after-tax operating profit with the average assets supporting operations, net of operating liabilities. Follow a worked example with explicit financing exclusions, an approved tax basis and a reconciliation.

Oct 1, 20266 min read
Finance metrics and formulas · Software

SaaS bookings vs ARR: contract value and recurring run rate

SaaS bookings measure signed commitments, while ARR annualizes eligible recurring charges at a reporting date. Reconcile the same contract rows through term, services, start dates and renewals.

Oct 1, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Total revenue formula: calculation and worked example

Calculate total revenue from quantities, prices, discounts and returns. Follow a worked invoice example and reconcile the result to the revenue ledger.

Oct 1, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Working capital loan in the balance sheet: classification and cash

A working capital loan is a liability, with current and long-term portions determined from its terms and approved accounting treatment. Compare a short-term draw with a term loan using the same balance sheet and liquidity checks.

Oct 1, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Adjusted operating margin: formula and reconciliation

Adjusted operating margin divides operating profit after specified adjustments by revenue. Follow a business-unit example from the reported P&L through a signed adjustment register and a margin reconciliation.

Sep 30, 20265 min read
Finance metrics and formulas · Insurance

Booked versus received commission: explain the timing gap

Explain differences between booked commission and cash received. Reconcile opening balances, new items, adjustments and receipts.

Sep 30, 20262 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow to owners formula: cash paid and equity raised

Cash flow to owners reconciles dividends and share repurchases with new equity proceeds. Work the calculation from financing records and prove it against the change in company cash.

Sep 30, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

CFFA cash flow: cash flow from assets formula and example

Calculate cash flow from assets using the textbook bridge from operating cash generation through capital spending and working capital. Reconcile the result to financing flows and distinguish it from reported operating cash flow less capital expenditures.

Sep 30, 20266 min read
Finance metrics and formulas · Sales teams

Cost per qualified lead: formula and stage definitions

Cost per qualified lead depends on exactly which qualification stage you count. Calculate campaign spending per MQL and SQL, reconcile stage histories, and compare qualification rates with opportunity outcomes.

Sep 30, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Net debt to enterprise value ratio: formula and limits

The net debt to enterprise value ratio compares defined net debt with a finance-approved enterprise value. Follow a worked financing example, reconcile the value bridge, and separate repayment changes from valuation changes.

Sep 30, 20266 min read
Finance metrics and formulas · Professional services

Project margin analysis: revenue, costs and commitments

Compare project revenue with delivery costs and the work still to come. Build separate views of billed revenue, recognized revenue and forecast final margin, then reconcile them to your finance exports.

Sep 30, 20265 min read
Finance metrics and formulas · Insurance

Reconcile carrier commission statements to the agency ledger

Match carrier commission statement lines to booked amounts. Keep timing, returns and unexplained differences in separate buckets.

Sep 30, 20263 min read
Finance metrics and formulas · Finance and FP&A teams

Working Capital Turnover Ratio by Industry

Working capital turnover depends on inventory, customer credit and supplier funding. Compare operating segments on a consistent basis and see why negative or very small denominators cannot support a useful industry ranking.

Sep 30, 20265 min read
Finance metrics and formulas

FCF growth rate formula: free cash flow growth and caveats

Calculate free cash flow growth from comparable operating cash flow and capital spending. Work through a quarterly example, a spreadsheet growth calculator, the driver reconciliation, and negative-base cases.

Sep 29, 20265 min read
Finance metrics and formulas · Banking

Net noninterest margin: formula and bank cost drivers

Net noninterest margin compares fee and other noninterest income with operating expenses against average assets. Work through the signed formula, reconcile the bank finance inputs, and separate operating improvement from balance-sheet growth.

Sep 29, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Recurring cash flow: separate ongoing and one-time items

Recurring cash flow separates normal operating receipts and payments from documented one-time items. Build a row-level bridge from reported cash movement and check it against the bank balance.

Sep 29, 20265 min read
Finance metrics and formulas · Sales teams

Advertising ROI by medium: compare on a consistent basis

Compare advertising media using contribution after complete campaign costs. This guide aligns attribution, revenue, margin, and observation windows, then works through a spreadsheet comparison and the checks behind its totals.

Sep 28, 20265 min read
Finance metrics and formulas · Insurance

Analyze agency fee income without confusing it with commission

Separate recurring, one-off and pass-through amounts in agency fee reports. Compare fees with service demand using a worked example.

Sep 28, 20263 min read
Finance metrics and formulas · Insurance

Compare agency income per FTE on a consistent basis

Define agency income per FTE with matching periods and staff scope. Explain mix, outsourcing and one-off income before benchmarking.

Sep 28, 20262 min read
Finance metrics and formulas · Insurance

Estimate client servicing contribution from agency time records

Estimate client servicing contribution with recorded time and approved cost rates. Keep unallocated effort and omitted costs visible.

Sep 28, 20263 min read
Finance metrics and formulas · Healthcare

Healthcare financial analysis for operating decisions

Healthcare financial analysis connects service-line contribution, labor costs and liquidity. Build a monthly review from deidentified finance exports, calculate margins in Excel and reconcile the movement in cash.

Sep 28, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Luxury goods industry financial ratios for operating reviews

Luxury goods financial ratios connect product-line margins, inventory efficiency and operating returns. This guide works through two product lines and shows why a strong gross margin can still leave capital tied up in stock.

Sep 28, 20267 min read
Finance metrics and formulas · Finance and FP&A teams

Operating cash flow vs investing cash flow

Operating cash flow measures cash generated or used by business operations, while investing cash flow tracks long-term asset and investment movements. Compare the same US company's transaction rows, distinguish working capital from capital spending, and check the classification against closing cash.

Sep 28, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Airline industry financial ratios: compare operating peers

Compare airline profitability, liquidity and leverage using consistent statements and operating statistics. Work through unit revenue, unit cost, load factor and lease definitions, then check what changes when operating costs rise.

Sep 27, 20265 min read
Finance metrics and formulas

Average orders per customer: formula and buying frequency

Average orders per customer divides distinct orders by eligible customers in a stated window. Use invoice exports to remove duplicate lines and returns, compare cohorts, and prove the total.

Sep 27, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Controllable margin: formula and example

The controllable margin formula deducts variable costs and manager-controllable fixed costs from segment revenue. See a department example, define who controls each expense, and reconcile the management measure to operating profit.

Sep 27, 20265 min read
Finance metrics and formulas

How to calculate unit selling price

Calculate realized unit selling price from net sales and comparable quantities in an invoice export. This guide works through cartons, individual units, returns and a price-only credit, then reconciles the result to net revenue.

Sep 27, 20266 min read
Finance metrics and formulas · Supply chain

Ordering cost and carrying cost: compare inventory tradeoffs

Ordering cost rises with order frequency, while carrying cost rises with average inventory. Compare annual order-size scenarios using the same demand, cost definitions, and service assumptions.

Sep 27, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Variance analysis: types, formulas and one worked example

Variance analysis compares actual results with the budget or standard and splits the gap into its causes. This page lists the main types, gives the formula for each pair, works a sales variance into volume and price and a material variance into price and usage, proves the parts sum to the total, and shows how budget variance analysis fits a monthly reporting package.

Sep 27, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Working capital: formula, worked example and the working capital cycle

Working capital is current assets minus current liabilities. This page works it from one quarter-end balance sheet with the current and quick ratios, separates trade working capital from cash and debt, turns it into days with DSO, DIO and DPO, and shows how change in working capital moves cash.

Sep 27, 20267 min read
Finance metrics and formulas · Finance and FP&A teams

Accounts payable turnover ratio: formula and meaning

The accounts payable turnover ratio compares net credit purchases with average trade payables. Work it from supplier invoices and payable balances, reconcile the result, and interpret changes alongside payment terms.

Sep 26, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Acquisition cost: purchase price and additional costs

Acquisition cost includes an asset's net purchase price and the approved costs of getting it ready for use. Work through a machine purchase, reconcile the invoices, and compare two purchasing options on the same basis.

Sep 26, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow analysis: how to read business cash movements

Cash flow analysis explains where business cash came from and where it went. Compare operating, investing and financing movements, reconcile profit with cash and trace changes back to receipts, payments and working capital.

Sep 26, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Combined financial and operating leverage: formulas

Combined leverage measures how fixed operating costs and interest amplify a change in sales. Calculate each leverage ratio from a cost workbook, then prove the combined result against a revenue scenario.

Sep 26, 20265 min read
Finance metrics and formulas · Construction

DSCR in project finance: period coverage and stress tests

Project DSCR compares cash available for debt service with scheduled repayments in matching periods. Build a quarterly cash bridge, distinguish minimum from aggregate coverage, and test receipt delays and higher operating costs.

Sep 26, 20267 min read
Finance metrics and formulas · Finance and FP&A teams

Estimating cash flows for project appraisal: a worked guide

Estimate project cash flows by comparing the business with and without the project. Build an incremental operating, capital, working-capital and terminal cash schedule, with spreadsheet formulas and a reconciliation.

Sep 26, 20265 min read
Finance metrics and formulas · Hospitality

Hotel financial ratios: margins, returns and liquidity

Financial ratios for hotels connect room demand and pricing with operating margin, asset returns and cash coverage. This guide defines each denominator, works through one US property and checks the results against its income statement and cash movement.

Sep 26, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Landscaping industry financial ratios for service businesses

Landscaping financial ratios connect crew margins, labor costs, receivables and equipment investment. This operating review works through two service lines and shows how to reconcile their results to the branch accounts.

Sep 26, 20266 min read
Finance metrics and formulas · Consumer goods

Price-pack architecture analysis: compare price and mix

Compare net selling price, physical volume and contribution across pack sizes and channels. Build a checked table from sales and cost exports, then test whether a pack shift improves the portfolio.

Sep 26, 20265 min read
Finance metrics and formulas · Software

Rule of 40 for SaaS: the formula, five companies worked and which margin to use

The Rule of 40 adds a software company's revenue growth rate to its profit margin and asks whether the sum reaches 40%. This page gives the formula and the Excel version, works five companies, shows how the choice between EBITDA and free cash flow margin can flip the result, and covers which growth figure to use and what the score cannot tell you.

Sep 26, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Shareholders equity on the balance sheet

Shareholders equity is the residual after liabilities are deducted from assets. See how contributed capital, retained earnings and treasury stock reconcile from opening to closing equity.

Sep 26, 20265 min read
Finance metrics and formulas · Software

Unit economics: the per-customer P&L, with LTV, CAC and payback worked for three segments

Unit economics is the profit and loss of one customer: what it pays, what it costs to serve, what it cost to win and how long it stays. This page builds the per-customer P&L for three segments of one software company, ties CAC, payback and LTV together, caps the lifetime so low churn cannot inflate it, and shows the same method for businesses without subscriptions.

Sep 26, 20268 min read
Finance metrics and formulas

Value chain analytics: find where margin is lost

Compare revenue with purchasing, production, delivery and service costs from your own files. Build a stage cost bridge, adjust the baseline for activity volumes and reconcile the result to the ledger.

Sep 26, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

FCFF: free cash flow to firm formula and example

FCFF measures operating cash generation after taxes and reinvestment, before financing payments. Rebuild it from operating profit, noncash charges, capital spending and working capital, then check it against an operating cash flow bridge.

Sep 25, 20266 min read
Finance metrics and formulas

Price volume mix analysis: the formulas, a worked bridge, and how to build it in Excel

Price volume mix analysis explains a revenue change as three effects that add up exactly to it. This page gives the three formulas and the order that leaves no residual, works a bridge on three product lines with every effect product by product, proves it sums to the change, and shows the Excel layout and waterfall chart.

Sep 25, 20267 min read
Finance metrics and formulas · Distribution

Profit and loss statement example, line by line: a sample P&L for a mid-sized distributor

A filled-in profit and loss statement for a US distributor with $47,000,000 of net revenue, this year against last, read line by line from gross sales to net income. It shows how each subtotal is built, the same P&L as percentages of revenue, and the bridge that explains why net income rose 52% on 7% more revenue.

Sep 25, 20267 min read
Finance metrics and formulas

Retail industry financial analysis

Connect retail sales mix, merchandise margin, store operating costs and inventory investment. Work through a store's category review, build the spreadsheet calculations and check the results against the ledger and inventory reports.

Sep 25, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Retail method of inventory valuation: worked example

The retail method estimates ending inventory at cost from retail records and a cost-to-retail ratio. Follow a department example, reconcile estimated inventory and cost of goods sold, and distinguish retail cost from lower-of-cost-or-market treatment.

Sep 25, 20266 min read
Finance metrics and formulas · Banking

Return on assets (ROA): formula, worked example and what a good ROA is

Return on assets is net income divided by average total assets. This page gives the formula and where its inputs sit in a 10-K, works ROA for five companies from a distributor to a bank, proves each figure with the DuPont split into net margin and asset turnover, explains why bank ROA sits near 1%, and compares ROA with ROE and ROIC.

Sep 25, 20267 min read
Finance metrics and formulas · Professional services

Revenue per employee: formula, a worked example by practice, and how to compare it

Revenue per employee is annual revenue divided by average full-time equivalent staff. This page gives the formula and which people to count, works it for a five-practice professional services firm, shows why the firm figure is not the average of the practices, and builds a dated comparison from 10-K filings.

Sep 25, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Total assets formula on the balance sheet

Total assets equal current assets plus noncurrent assets. Build the total from signed asset balances, account for valuation deductions, and reconcile it to liabilities plus equity for the same entity.

Sep 25, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Capital cash flow: formula and business example

Capital cash flow measures business cash available to debt and equity providers, including the interest tax shield. Reconcile it from operating assumptions and a financing schedule, then distinguish it from capital expenditures and actual distributions.

Sep 24, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Lessor cash flow statement: receipts and classification

A lessor cash flow statement reconciles actual lease receipts to cash records and the appropriate activity classification. This US example compares three lease types, separates overdue amounts from advance receipts, and explains the financial-institution exception.

Sep 24, 20265 min read
Finance metrics and formulas

Operating margin: formula, examples and how to read it across business units

Operating margin is operating profit divided by revenue: what is left of each sale after cost of goods sold and operating expenses, before interest and tax. This page gives the formula, separates it from EBIT and EBITDA, works it for three business units and a group, shows operating leverage, and explains why US GAAP and IFRS 18 define the line differently.

Sep 24, 20266 min read
Finance metrics and formulas

OPEX vs CAPEX: definitions, examples and how each hits the P&L and cash

Operating expenses are charged to profit in the period; capital expenditure buys long-lived assets that go on the balance sheet and are depreciated. This page compares the two in one table, gives examples, the test that decides, and works a buy-or-subscribe decision through EBITDA, operating profit and cash over five years.

Sep 24, 20266 min read
Finance metrics and formulas

Working capital gap formula: calculation and inputs

A working capital funding gap compares additional operating cash needs with funding that is actually available. Calculate the requirement from receivables, inventory and operating liabilities, then reconcile the shortfall to cash and undrawn credit.

Sep 24, 20266 min read
Finance metrics and formulas · Software

Average SaaS CAC: compare costs by customer segment

Average SaaS CAC measures acquisition spending per new customer, but contract size and sales motion change what the average means. Compare consistent segments, calculate gross-profit payback and select benchmarks that match your definitions.

Sep 23, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash generating power ratio: formula and limits

The cash generating power ratio compares operating cash flow with operating cash plus investing and financing inflows. Work through the export rows, denominator choices, reconciliation and reasons a higher percentage can mislead.

Sep 23, 20266 min read
Finance metrics and formulas · Software

LTV to CAC ratio: formula, what's good, and why 3:1 can mislead

The LTV to CAC ratio divides a customer's lifetime gross profit by the cost of winning them. This page gives the formula, works three segments with CAC payback in months, shows why a blended ratio hides the segment below 3:1, and caps the lifetime so a low churn rate cannot turn into a ten-year customer.

Sep 23, 20266 min read
Finance metrics and formulas

Markup vs margin: the difference, the formulas and a conversion table

Markup divides profit by cost; margin divides the same profit by the selling price. This page gives both formulas, works them on five products, converts between them in a table and in Excel, and shows the pricing mistake that turns a 40% margin target into 28.6%.

Sep 23, 20265 min read
Finance metrics and formulas · Banking

Net interest margin (NIM): formula, a worked bank example, and what moves it

Net interest margin is a bank's net interest income divided by its average earning assets. This page gives the formula and the inputs from the call report, works one bank through yields, funding costs, NIM and net interest spread, shows what a deposit rate rise does to it, proves the figure two ways, and sets it against FDIC industry data by bank size.

Sep 23, 20266 min read
Finance metrics and formulas

Net profit margin: formula, a worked year and what a good margin looks like

Net profit margin is net income divided by revenue, after every cost, interest and tax. This page gives the formula, works it on four quarters and a full year, proves why the year is not the average of the quarters, places it beside gross and operating margin on one P&L, and shows what counts as good by US industry.

Sep 23, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Return on tangible capital: formula and business comparison

Return on tangible capital compares operating earnings with the tangible assets supporting them. Define the denominator, calculate the ratio for two business units, and reconcile their combined return.

Sep 23, 20265 min read
Finance metrics and formulas · Banking

Cost income ratio: formula for bank efficiency

The cost income ratio compares bank operating expenses with operating revenue. Define the inclusions, calculate a worked example by business unit, and reconcile changes before interpreting efficiency.

Sep 22, 20265 min read
Finance metrics and formulas

Gross profit vs net profit: the difference, with one quarter's P&L worked through

Gross profit is revenue minus cost of goods sold; net profit is what is left after every cost, interest and tax. This page sets the two side by side, works one quarter's P&L from revenue to net income, and shows a second quarter where gross profit rises while net profit falls.

Sep 22, 20266 min read
Finance metrics and formulas · Software

How to calculate LTV (customer lifetime value): formulas and worked examples

Customer lifetime value is the gross profit a customer brings over the whole relationship. This page gives the standard LTV formula, where each input comes from, a worked example on three segments with LTV against CAC, a discounted version, a method for B2B businesses without subscriptions, and the check that proves the segment figures.

Sep 22, 20266 min read
Finance metrics and formulas · Distribution

Inventory turnover ratio: formula, worked example and days of inventory

The inventory turnover ratio is cost of goods sold divided by average inventory. This page gives the formula and the data it needs, works it for three categories of a food distributor with the Excel formulas, proves the total as a weighted average, converts turns to days of inventory, and shows why one company figure hides slow categories.

Sep 22, 20265 min read
Finance metrics and formulas · Banking

Loan-to-deposit ratio: formula, examples and what it shows

The loan-to-deposit ratio divides a bank's loans by its deposits. This page gives the formula as US regulators report it, compares five banks, shows why the aggregate is not the average of the ratios, follows one bank through four quarters of deposit outflows, and sets the ratio against FDIC data by bank size and the US liquidity rules.

Sep 22, 20266 min read
Finance metrics and formulas · Software

SaaS cash flow statement: billing, revenue and cash

A SaaS cash flow statement explains customer receipts, spending and the change in cash. Follow a worked example connecting annual advance billings, deferred revenue, receivables and operating cash, then test a slower renewal month.

Sep 22, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

The cash flow on total assets ratio: formula and example

The cash flow on total assets ratio divides operating cash flow by average total assets. Calculate cash productivity by business unit, reconcile the company total, and understand how asset timing and accounting values affect the comparison.

Sep 22, 20266 min read
Finance metrics and formulas · Pharmaceuticals

Cash conversion cycle: pharmaceutical industry analysis

Calculate the cash conversion cycle for a pharmaceutical business from inventory, receivables, and payables exports. Separate inventory stages, distributor balances, and supplier timing, then reconcile product-line results before comparing periods.

Sep 21, 20265 min read
Finance metrics and formulas · Retail banking

Credit union ratios: performance measures and formulas

Compare credit union earnings, capital, lending and asset quality with consistent formulas. Work through two years of financial inputs, check the balances and distinguish management indicators from regulatory capital calculations.

Sep 21, 20266 min read
Finance metrics and formulas

Customer Acquisition Cost in Retail

Measure retail customer acquisition cost across stores and online channels. Build a deduplicated new-shopper denominator, allocate spending consistently, and compare the result with observed customer contribution.

Sep 21, 20264 min read
Finance metrics and formulas

Email marketing ROI: costs, cohorts and contribution

Email marketing ROI depends on which customers and purchases qualify, how long outcomes are observed, and which costs are included. Work from delivery, order and finance exports to compare contribution after returns across email cohorts.

Sep 21, 20266 min read
Finance metrics and formulas

Financial KPIs: 25 that finance teams report, with the formula for each and one company worked through

Financial KPIs are the measures a company chooses to judge its financial performance. This page lists 25 of them in seven groups, with the formula and the question each answers, computes all 25 on one company's accounts, shows the identities that tie them together, and explains how to pick the eight that go on the dashboard.

Sep 21, 20269 min read
Finance metrics and formulas

Fixed vs variable costs: the difference, examples, and how to split a mixed cost

Fixed costs stay the same in total as volume changes; variable costs move with every unit. This page sets out the difference in one table, gives business examples of fixed, variable, semi-variable and step costs, and splits six months of a packing operation's costs with the high-low method, checked against Excel's SLOPE and INTERCEPT.

Sep 21, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Profitability ratios and liquidity ratios: formulas, two years worked through, and how to read them

Profitability ratios measure the profit a company makes from its sales and its capital; liquidity ratios measure whether it can pay what falls due within the year. This page gives the formula for each, works them all on two years of one distributor's accounts, reads the movement, and proves the returns with the DuPont identity.

Sep 21, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Working capital cost: formula and business example

Working capital cost estimates the financing burden of cash tied up in receivables and inventory after supplier credit. Calculate it from average operating balances and a supplied rate, reconcile the components and compare a change in inventory.

Sep 21, 20265 min read
Finance metrics and formulas

Cash conversion cycle in the automotive industry

Calculate the automotive cash conversion cycle separately for a manufacturer and a dealer. Work through inventory, receivables, trade payables, and a floorplan financing adjustment using consistent finance exports.

Sep 20, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cost of debt risk premium: what changes borrowing cost

Separate a supplied corporate borrowing rate into its reference rate and contractual spread. Work through a debt schedule, calculate weighted borrowing cost and compare the interest effect of clearly stated rate scenarios.

Sep 20, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Days payable outstanding (DPO): formula, worked example and what it shows

DPO is the average number of days a company takes to pay its suppliers. This page gives the formula with COGS or purchases, works it for four suppliers over one quarter against their terms, proves the company figure as a weighted average, prices paying early and late, and sets DPO beside DSO in the cash conversion cycle.

Sep 20, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Days sales outstanding (DSO): meaning, formula and a worked example

DSO is the average number of days customers take to pay. This page gives the formula and which receivables and sales go into it, works DSO for five customers over one quarter with the Excel formulas, proves the company figure as a revenue-weighted average, and covers DSO against terms, the countback method and what a good DSO is.

Sep 20, 20267 min read
Finance metrics and formulas

EBITDA margin: formula, worked example and what counts as good

EBITDA margin is earnings before interest, tax, depreciation and amortization divided by revenue. This page builds EBITDA from a P&L both ways, compares three companies whose ranking flips between operating margin and EBITDA margin, and covers the SEC non-GAAP rules and the lease trap that make EBITDA margins hard to compare.

Sep 20, 20267 min read
Finance metrics and formulas

EBITDA vs operating income: the difference, with one P&L worked both ways

Operating income is after depreciation and amortization; EBITDA adds them back. This page works one P&L both ways, reconciles the two EBITDA figures line by line, separates EBIT from operating income, and sets out the SEC rules that apply when a US company reports EBITDA.

Sep 20, 20265 min read
Finance metrics and formulas

Ecommerce working capital: stock, payouts and supplier terms

Compare the cash tied up in ecommerce stock, unsettled sales and payout reserves by channel. Reconcile inventory and settlement exports, then test supplier and payout timing.

Sep 20, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Equity ratio: formula, example and interpretation

The equity ratio shows the share of total assets financed by book equity. Calculate it from balance sheet rows, prove the funding identity and explain changes in owners' funding across periods or entities.

Sep 20, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial ratios for bank loans: assess repayment

Compare a business borrower's liquidity, leverage and debt-service coverage using consistent statements and a debt schedule. Work through two reporting periods, reconcile the inputs and distinguish management measures from the loan agreement's covenant definitions.

Sep 20, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Income tax paid on the cash flow statement: indirect method

Reconcile income tax expense, deferred tax and current tax payable to recorded cash taxes paid. Follow a worked payable rollforward with spreadsheet formulas and a payment-register check.

Sep 20, 20265 min read
Finance metrics and formulas · Distribution

Calculating inventory days (DIO): formula, Excel and a worked example

Inventory days, or days inventory outstanding (DIO), is average inventory divided by cost of goods sold, times the days in the period. This page gives the formula and the data it needs, works it for five categories at a distributor with the Excel formulas, proves the total as a COGS-weighted average, and places it in the cash conversion cycle.

Sep 19, 20266 min read
Finance metrics and formulas

Cost of goods sold (COGS): formula, what it includes and a worked example

Cost of goods sold is the direct cost of the goods a company sold in the period. This page gives the COGS formula, what US GAAP and the IRS put in and leave out, a worked year for a distributor with the Excel formulas, how FIFO, weighted average and LIFO change the figure, and what service companies call cost of revenue.

Sep 19, 20266 min read
Finance metrics and formulas · Software

Customer acquisition cost (CAC): formula, calculator and a worked example

Customer acquisition cost is the sales and marketing cost of winning a new customer. This page gives the formula and what belongs in the cost, a small spreadsheet calculator for CAC and payback, a worked example across four channels with the weighted-average check, and the difference between blended, paid and fully loaded CAC.

Sep 19, 20266 min read
Finance metrics and formulas

Customer lifetime cost: acquisition and cost to serve

Customer lifetime cost brings acquisition, onboarding, support and service costs together by account. Separate recorded costs from future assumptions, compare customers at consistent tenures and reconcile the total to source records.

Sep 19, 20266 min read
Finance metrics and formulas · Manufacturing

Labor efficiency variance: formula and example

Labor efficiency variance values extra or saved production hours at the standard labor rate. Learn the formula, build standard hours from actual output and reconcile a worked manufacturing example to total labor cost.

Sep 19, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Working investment to sales ratio: formula and example

The working investment to sales ratio measures operating funds tied up relative to revenue. Define the accounts, calculate a quarterly example, and reconcile the result to broader working capital.

Sep 19, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Balance sheet analysis: liquidity, debt and changes

Balance sheet analysis connects liquidity, borrowing, and movements in assets and equity. Follow a checked comparison from statement exports to a short list of questions for collections, inventory, and treasury owners.

Sep 18, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash conversion cycle: formula, a worked example over two quarters, and what it costs in cash

The cash conversion cycle counts the days between paying suppliers and collecting from customers. This page gives the formula and each leg, works it over two quarters for one company, values the change in cash, ties it to the balance sheet, explains negative cycles with figures from US 10-K filings, and lists the levers that shorten it.

Sep 18, 20266 min read
Finance metrics and formulas

Contribution margin ratio: formula, contribution per unit and the contribution margin income statement

The contribution margin ratio is revenue minus variable costs, divided by revenue. This page gives the three formulas (amount, per unit and ratio), which costs count as variable, a worked example on four products with the Excel formula, the contribution margin income statement beside the traditional layout, break-even and target-profit revenue from the ratio, and why product mix moves the blended ratio.

Sep 18, 20266 min read
Finance metrics and formulas · Consumer goods

Retail sales velocity formula: units per store per week

Retail unit velocity measures sales against the stores and weeks that generated them. Calculate it from sales and distribution exports, prove the total, and separate wider distribution from faster selling.

Sep 18, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

ROCE vs ROIC: compare capital returns on the same basis

ROCE usually measures pre-tax operating profit against capital employed, while ROIC measures after-tax operating profit against invested capital. Work both from the same business-unit schedules and separate the tax effect from differences in the capital base.

Sep 18, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Sole proprietorship balance sheet: owner equity

A sole proprietorship balance sheet separates business assets and liabilities from owner equity. Follow a worked example, reconcile contributions and draws, and see what changes when the owner withdraws more cash.

Sep 18, 20265 min read
Finance metrics and formulas · Sports

Sports Business Financial Analysis

Compare a sports organization's revenue, operating expenses and cash across seasons. Build a season-to-fiscal reconciliation, calculate operating margins and prove the cash movement from financial exports.

Sep 18, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Accounts receivable turnover ratio: formula, days sales in receivables and a worked example

The AR turnover ratio divides net credit sales by average receivables to show how many times receivables are collected in a period. This page gives the formula and the conversion to days sales in receivables, works one quarter for a company and its five customers with the Excel formulas, compares the average and closing balance methods, and measures days beyond terms customer by customer.

Sep 17, 20265 min read
Finance metrics and formulas

Break-even analysis: the formula, a worked example, and a break-even chart in Excel

Break-even analysis finds the sales at which revenue covers every cost and profit is zero. This page gives the formula in units and in revenue, works one product through break-even, target profit and margin of safety, builds the Excel table and chart, tests what moves the point, and extends it to several products.

Sep 17, 20266 min read
Finance metrics and formulas · Software

Burn rate: gross and net burn formulas, runway and a worked example

Burn rate is how fast a company uses cash. This page gives the gross and net burn formulas, works six months of a software company's bank data with the Excel formulas, turns net burn into runway on a stated average, proves the figures by walking opening cash to closing cash, and covers the burn multiple.

Sep 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow based accrual ratio: formula and interpretation

The cash flow based accrual ratio compares earnings with operating and investing cash flows. Work through the signed formula, document net operating assets, and reconcile the result before comparing periods.

Sep 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Investment in a subsidiary on the cash flow statement

An investment in a subsidiary changes presentation when the reporting entity changes. Compare the parent's cash payment with consolidated acquisition cash, acquired cash, internal funding and a complete bank reconciliation.

Sep 17, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Private company financial statements: access and analysis

Private-company statements describe profit, financial position and cash movements, but access usually comes through an authorized company relationship. Learn what to request, how to preserve confidentiality and how to compare prepared statements across matching periods.

Sep 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

ROI and profit margin: different denominators, different jobs

Profit margin measures profit against sales, while ROI measures income against investment. Compare both on the same business-unit rows, check the totals, and see why the higher-margin operation can earn the lower return.

Sep 17, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Working capital days: formula and interpretation

Working capital days divides average net working capital by daily revenue. Build the measure from monthly statements, reconcile changes across periods, and distinguish it from the cash conversion cycle and invoice payment timing.

Sep 17, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Accrual vs cash accounting: the difference in monthly reporting, with one month worked both ways

Accrual accounting records revenue when earned and costs when incurred; cash accounting records them when money moves. This page works one March both ways, reconciles the two profits through receivables, payables, accruals and prepaid expenses, and covers who may use the cash method for US tax and the month-end entries that close the gap.

Sep 16, 20266 min read
Finance metrics and formulas

Activity-based costing: a worked example against traditional allocation

Activity-based costing assigns overhead by the activities each product or customer uses, rather than by revenue or volume. This page sets out the four steps, builds activity rates for a distributor's four cost pools, charges four customers both ways, proves the charges reconcile, and covers when ABC changes the answer and when time-driven ABC is the simpler route.

Sep 16, 20267 min read
Finance metrics and formulas · Finance and FP&A teams

Auto dealership financial statement analysis: margins and cash

Auto dealership financial statement analysis connects department profit with vehicle inventory, floorplan borrowing and cash. Follow a worked monthly statement, spreadsheet formulas and the reconciliations that explain why profit can rise while cash falls.

Sep 16, 20265 min read
Finance metrics and formulas · Oil and gas

Key financial ratios for oil and gas industry operations

Compare oil and gas operating margins, cash generation and capital use with consistent denominators. A worked operating-unit example shows how to calculate the ratios, reconcile the totals and separate commodity exposure from operating decisions.

Sep 16, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Weighted average contribution margin: unit mix and break-even

Weighted average contribution margin combines product contribution per unit using unit sales mix. Work through the calculation, prove the total, and convert the result into composite-unit break-even.

Sep 16, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow lending: repayment capacity from business cash

Cash flow lending centers on the business cash available to repay debt. Compare monthly cash generation with a supplied payment schedule, reconcile the cash balance, and test a collection delay without confusing revenue with repayment cash.

Sep 15, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow leverage: debt relative to cash generation

Cash flow leverage compares a stated debt balance with operating cash generation. Calculate debt divided by trailing operating cash flow, reconcile both inputs, and distinguish a rising multiple from its inverse coverage ratio.

Sep 15, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Days sales in cash: formula and interpretation

Days sales in cash expresses a cash balance in units of average daily revenue. Calculate it from balance-sheet and sales exports, reconcile the inputs, and distinguish it from collection days and expense-based runway.

Sep 15, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

FCF Conversion: Formula and Earnings Reconciliation

FCF conversion compares free cash flow with a defined earnings measure. Reconcile operating cash flow and capital spending, work both net-income and EBITDA conventions, and identify which changes come from working capital or investment timing.

Sep 15, 20265 min read
Finance metrics and formulas · Construction

Financial ratios for construction companies

Compare contractor liquidity, leverage and margins from financial exports. A worked example shows why retainage, contract assets and billing timing change the interpretation.

Sep 15, 20265 min read
Finance metrics and formulas · Professional services

Financial ratios for service companies: margins and cash

Choose financial ratios that fit a service company with little inventory. Calculate margins, receivables days, asset turnover and liquidity from billing and ledger exports, then check what each result means.

Sep 15, 20265 min read
Finance metrics and formulas · Manufacturing

Full absorption cost per unit: formula and example

Full absorption cost per unit includes direct materials, direct labor and allocated variable and fixed production overhead. Follow a machine-hour allocation, reconcile inventory to production cost and keep unallocated idle-capacity cost separate.

Sep 15, 20266 min read
Finance metrics and formulas

Gross profit margin: formula, worked example and what moves it

Gross profit margin is revenue minus cost of goods sold, divided by revenue. This page gives the formula, what US GAAP and the IRS put into cost of goods sold, a worked example on three product lines with the Excel formulas, the weighted-average identity that proves the total, and the three things that move the margin: price, cost and mix.

Sep 15, 20266 min read
Finance metrics and formulas

Revenue vs profit: the difference, shown on one P&L

Revenue is what a company earns from sales before any costs; profit is what is left after them, at three levels: gross, operating and net. This page walks one company's income statement from top line to bottom line, then shows a year in which revenue grew 15% while net profit fell 22.5%, with a bridge that proves which lines caused it.

Sep 15, 20266 min read
Finance metrics and formulas · Investment banking

Investment bank business model: revenue and cost drivers

Understand how advisory and underwriting activity becomes fee revenue and business-line profit. A worked US example connects completed mandates, fee yield, compensation and support costs, then tests a delayed transaction.

Sep 14, 20265 min read
Finance metrics and formulas · Construction

Unit cost analysis in construction

Unit cost analysis compares construction costs with the completed quantities those costs produced. Work from job-cost and quantity exports to a checked cost per unit, then separate labor, material and equipment differences.

Sep 14, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash debt coverage: formula and interpretation

Cash debt coverage compares operating cash flow with average total liabilities. Follow the statement rows, a complete worked calculation and its reconciliation, then distinguish borrowing-only and debt-service variants.

Sep 13, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow statement vs profit and loss statement

A profit and loss statement measures earnings, while a cash flow statement explains cash movements. Work the same company's transactions both ways and reconcile the difference through depreciation, working capital, equipment purchases, and borrowing.

Sep 13, 20266 min read
Finance metrics and formulas

Cost revenue analysis: compare costs, sales and profit

Cost revenue analysis explains how sales and expenses change operating profit. Build a comparison from sales and expense exports, separate volume, price and cost effects, and reconcile the result to the income statement.

Sep 13, 20266 min read
Finance metrics and formulas

Ecommerce website conversion rate: formula and checks

Ecommerce website conversion rate compares qualifying orders with sessions in the same reporting scope. Work it by channel and device, reconcile the order count, and distinguish orders per session from the share of sessions that purchase.

Sep 13, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Foreign currency translation adjustment on the balance sheet

A foreign currency translation adjustment bridges a foreign entity's translated net assets to its translated equity. Follow a worked USD reconciliation using approved closing, average and historical rates, then separate the equity movement from operating results.

Sep 13, 20265 min read
Finance metrics and formulas · Financial services

Customer lifetime value in financial services

Calculate relationship value across financial products using contribution, retention and funding assumptions. Follow a worked example with spreadsheet formulas, credit-cost checks and a clear bridge to source exports.

Sep 12, 20266 min read
Finance metrics and formulas

Lead to MQL conversion rate: formula and qualification rules

Lead to MQL conversion rate measures leads reaching a written marketing qualification threshold. Build a dated creation cohort, calculate source rates, and check whether timing or changing qualification rules explain the result.

Sep 12, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Treasury stock purchases on the cash flow statement

Cash paid to repurchase a company's own shares is a financing outflow. Reconcile buyback settlements, share reissuances and noncash equity movements before using a treasury stock balance to explain cash.

Sep 12, 20265 min read
Finance metrics and formulas · Industrial distributors

Weighted average cost per unit: inventory formula and example

Weighted average cost per unit divides inventory cost available by the units available. Compare periodic and moving inventory averages on the same purchase and issue records, then reconcile ending inventory and cost of goods sold.

Sep 12, 20267 min read
Finance metrics and formulas · Software

Calculate annual churn from monthly churn: formula and cohort check

Convert a constant monthly churn rate into compounded annual churn. Follow a complete customer-cohort example, distinguish projected losses from observed losses, and check the result against monthly subscription exports.

Sep 11, 20265 min read
Finance metrics and formulas · Telecommunications

Customer Acquisition Cost in Telecom

Calculate telecom customer acquisition cost from activated accounts, acquisition spending, commissions, and device support. Compare consistent cohorts with retained accounts and observed service contribution.

Sep 11, 20264 min read
Finance metrics and formulas · Consumer goods

Ecommerce ROI analysis beyond ad spend

Measure an ecommerce initiative using incremental contribution after merchandise, fulfillment, refunds and channel costs. Build a baseline comparison, calculate the return in a spreadsheet and reconcile the result to your exports.

Sep 11, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Profitability analytics center of excellence: how it works

Build a profitability analytics center of excellence around agreed cost definitions and named margin-review owners. Reconcile customer and product contribution from revenue, cost and service-activity exports before acting on the results.

Sep 11, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Working capital requirement: estimate the operating cash gap

Working capital requirement estimates the operating balances a business needs to fund before customer cash arrives. Build a timing-based estimate from sales, inventory and purchases, then separate the total requirement from the additional funding caused by growth or slower collection.

Sep 11, 20265 min read
Finance metrics and formulas

Cost of customer churn: measure the lost contribution

Measure the cost of customer churn from billing, margin and acquisition records. Separate lost revenue, avoidable costs, replacement spending and exit costs, then check the result in a spreadsheet.

Sep 10, 20264 min read
Finance metrics and formulas · Logistics

Key financial ratios for the logistics industry

Compare logistics margins, liquidity and asset use with a worked business-unit example. See why purchased transportation, revenue presentation and fleet ownership change the comparison.

Sep 10, 20266 min read
Finance metrics and formulas · Professional services

Professional services cost analysis

Separate delivery labor, subcontractors and shared overhead to compare engagement costs. Follow a worked cost worksheet, reconcile it to the ledger and distinguish spending changes from utilization effects.

Sep 10, 20265 min read
Finance metrics and formulas · Foodservice distributors

Foodservice distribution financial analysis

Foodservice distribution financial analysis compares route contribution after customer credits, spoilage and delivery costs. Work from invoice, inventory and route exports to a reconciled operating review with spreadsheet formulas.

Sep 9, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

HR costs as a percentage of revenue: define and compare

HR costs as a percentage of revenue measures the HR function's spending against company sales. Define the cost boundary, calculate a worked example and distinguish a lower ratio from a lower cost.

Sep 9, 20266 min read
Finance metrics and formulas · Hospitality

Restaurant balance sheet: assets, debt and liquidity

Read a restaurant balance sheet through cash, inventory, equipment, leases and obligations. A fully worked example reconciles assets to liabilities and equity, then shows what a supplier payment changes.

Sep 9, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow margin: operating cash flow divided by revenue

Cash flow margin measures operating cash flow as a percentage of revenue. Work through the formula, a two-quarter example and the reconciliation that explains why cash conversion changed.

Sep 8, 20266 min read
Finance metrics and formulas · Consumer goods

Consumer goods industry average ratios: compare peers

Compare consumer-goods margins, inventory turns and liquidity using a dated, matched peer file. A fully worked example distinguishes a pooled operating ratio from an equal-company average and shows the checks behind both.

Sep 8, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Balance sheet accrual ratio: formula and interpretation

The balance sheet approach measures changes in net operating assets relative to their average balance. Work a complete example, define the operating scope, and check whether acquisitions or currency changes distort the result.

Sep 7, 20266 min read
Finance metrics and formulas · Hospitality

Hospitality cost analysis by property and department

Compare hotel labor, supplies and overhead with occupied room-nights on a consistent basis. Follow a property example, spreadsheet formulas and a cost bridge that separates activity from changes in spending.

Sep 7, 20265 min read
Finance metrics and formulas

Lead to opportunity conversion rate: formula and timing

Lead to opportunity conversion rate measures eligible leads that reach a defined opportunity stage. Calculate it from dated CRM exports, compare sources after equal follow-up, and reconcile every starting lead to an outcome.

Sep 7, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Unlevered free cash flow: formula and reconciliation

Unlevered free cash flow measures operating cash available before financing effects. Reconcile operating profit, operating taxes, noncash charges, working capital and capital spending, then check the result against operating cash flow.

Sep 7, 20265 min read
Finance metrics and formulas · Wealth managers

Wealth management cost analysis by team and client segment

Build a wealth management practice cost view from adviser time, support payroll and platform expense. Compare client segments, reconcile the practice total and distinguish released staff capacity from a reduction in cash expense.

Sep 7, 20265 min read
Finance metrics and formulas · Consumer goods

Candle business profit: unit costs and channel margins

Measure candle profit from saleable batch yield, production costs and channel expenses. Work from production and sales exports to contribution by channel, then reconcile the result to operating profit.

Sep 6, 20265 min read
Finance metrics and formulas · Healthcare

Contribution margin in healthcare: service-line analysis

Contribution margin in healthcare measures net service revenue less explicitly defined variable costs. Work through a service-line example, reconcile the result to operating income, and distinguish short-term contribution from full financial performance.

Sep 6, 20266 min read
Finance metrics and formulas · Sales teams

Facebook Ads ROAS: calculate and interpret the result

Calculate Facebook Ads ROAS from campaign spend and attributed order revenue. Match reporting windows, reconcile returns, and compare campaigns using a consistent revenue definition.

Sep 6, 20265 min read
Finance metrics and formulas · Oil and gas

Financial analysis of oil and gas companies

Separate production, realized prices, operating costs and capital spending in an oil and gas operating review. Work from sales and finance exports to a reconciled business-unit comparison.

Sep 6, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Comparing financial statements of two companies

Compare two companies after aligning their reporting periods, accounting definitions and units. Work through revenue, margins, operating cash flow and working capital, with spreadsheet formulas and checks.

Sep 5, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Financial efficiency ratios: formulas and interpretation

Financial efficiency ratios connect revenue and cost of goods sold with the assets supporting them. Compare asset, inventory and receivables turnover using reconciled business-unit exports and a worked company total.

Sep 5, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

How factoring affects cash flow

Factoring brings some customer receipts forward and reduces the cash ultimately retained by its fees. Compare advances, reserves and settlement dates with normal collections using an accounts receivable export.

Sep 5, 20266 min read
Finance metrics and formulas · Financial services

Life insurance ratio analysis: profitability, liquidity and capital

Compare a US life insurer's profitability, liquidity and capital using prepared finance workbooks. Keep statutory and GAAP measures separate, reproduce each calculation and check the reporting basis before interpreting a trend.

Sep 5, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Operating cash flow ratio: formula and interpretation

The operating cash flow ratio compares cash generated by operations with current liabilities. Work through the source rows, a complete reconciliation, and the checks that make comparisons across reporting periods useful.

Sep 5, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Adjusted gross margin: formula and reconciliation

Adjusted gross margin shows gross profit after specified cost adjustments, divided by revenue. Work through a product-level reconciliation and the checks that keep the adjusted figure tied to the reported P&L.

Sep 4, 20265 min read
Finance metrics and formulas · Sales teams

Advertising performance metrics: definitions and checks

Advertising metrics need consistent definitions before campaigns can be compared. Work through cost, click, purchase and revenue measures from one campaign table, with denominator checks and a clear distinction between revenue return and profit.

Sep 4, 20267 min read
Finance metrics and formulas · Hospitality

Break-Even Analysis for a Restaurant: Covers and Sales

Calculate restaurant break-even covers and sales from your sales, food cost and payroll exports. Follow a worked monthly example, exact spreadsheet formulas and checks for food waste, capacity and added labor shifts.

Sep 4, 20267 min read
Finance metrics and formulas

Customer profitability and lifetime value: what differs

Customer profitability measures contribution earned during a defined period, while lifetime value estimates future contribution. This comparison applies both measures to the same customer groups and shows why their rankings can differ.

Sep 4, 20265 min read
Finance metrics and formulas

Lead generation conversion rate: define the denominator

Lead generation conversion rate measures visits or clicks becoming valid leads. Work through a source-level example, remove spam and duplicates, and reconcile the result to the original exports.

Sep 4, 20265 min read
Finance metrics and formulas · Professional services

Professional services financial analysis: engagement to firm

Connect engagement revenue, utilization, realization and delivery costs to the firm's financial result. Use a worked practice review and spreadsheet formulas to reconcile profitability and identify the working capital questions behind it.

Sep 4, 20265 min read
Finance metrics and formulas

Commercial real estate cash flow: build an operating view

Build a property cash view from rent receipts, paid operating costs, capital spending and debt payments. Use spreadsheet formulas and a bank reconciliation to check the result by property.

Sep 3, 20265 min read
Finance metrics and formulas · Healthcare

Dental marketing ROI from inquiries to collected revenue

Dental marketing ROI compares campaign expense with contribution from acquired-patient cohorts. Follow inquiries through attended visits, separate collected revenue from treatment acceptance, and reconcile care costs and marketing costs before comparing returns.

Sep 3, 20265 min read
Finance metrics and formulas

Hardware store profit margin: sales, stock and shrink

Calculate hardware-store gross, operating and net margin from sales, inventory and expense exports. See how category mix and counted shrink reconcile to the store's profit.

Sep 3, 20265 min read
Finance metrics and formulas · Hospitality

Restaurant financial ratios: costs, margins and cash

Restaurant financial ratios connect food costs, beverage costs, labor and operating profit to the sales that support them. This guide works through two US restaurants, reconciles their results and explains how to compare locations without mixing denominators.

Sep 3, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Adjusted return on equity: reconcile profit and equity

Adjusted return on equity uses an approved definition of earnings and common equity. Follow an after-tax profit bridge, an average-equity reconciliation and the checks that keep the comparison consistent.

Sep 2, 20265 min read
Finance metrics and formulas · Banking

Asset utilization ratio for banks: formula and interpretation

The asset utilization ratio for banks compares income with average total assets. Work two quarters from income statement and balance sheet rows, define the income convention, and reconcile the result to return on assets.

Sep 2, 20265 min read
Finance metrics and formulas · Sales teams

Cost per acquisition: formula, examples and cost scope

Cost per acquisition divides campaign spending by an agreed conversion count. Work through campaign CPA, reconcile the denominator, and distinguish advertising costs from fully loaded customer acquisition cost.

Sep 2, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

LT debt (long-term debt): meaning and balance-sheet analysis

LT debt means long-term borrowing, with the noncurrent balance separated from upcoming principal payments. Learn how to read a debt schedule, reconcile it to the balance sheet and compare repayment exposure across entities.

Sep 2, 20264 min read
Finance metrics and formulas · Finance and FP&A teams

Return on employed capital: ROCE formula and interpretation

Return on employed capital compares operating earnings with the capital supporting a business. Calculate ROCE by unit, reconcile the balance-sheet denominator and distinguish the pretax measure from after-tax ROIC.

Sep 2, 20266 min read
Finance metrics and formulas

Same-store sales growth: formula and comparable cohorts

Same-store sales growth compares a fixed group of eligible stores across matched periods. Define the cohort, calculate the weighted growth rate and reconcile openings, closures and remodel exclusions to total company sales.

Sep 2, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Short-term investments on the cash flow statement

Short-term investment cash flows depend on cash-equivalent status and why the securities were acquired. Work from purchases, sale proceeds and maturities to a reconciliation that ties both investment balances and cash.

Sep 2, 20266 min read
Finance metrics and formulas · Software

Average revenue per user: ARPU formula and example

Average revenue per user divides a defined revenue amount by the matching user population. Work the formula by plan, reconcile the total and separate revenue changes from changes in user activity.

Sep 1, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Finance director data analysis: questions and checks

Finance directors need explanations for cash, margin and budget movements that lead to a decision. Work through a monthly review, the source files, the checks and the person responsible for each follow-up.

Sep 1, 20265 min read
Finance metrics and formulas · Healthcare

Healthcare cost analysis for finance teams

Healthcare cost analysis compares departmental labor, supplies and overhead with the service volume delivered. Use a flexible budget to separate the cost of higher activity from changes in rates, resource use and fixed expenses.

Sep 1, 20265 min read
Finance metrics and formulas · Manufacturing

Material mix variance: formula and a worked example

Material mix variance isolates the cost effect of changing an input blend. Work through the quantities, standard prices and reconciliation from mix to total material cost variance.

Sep 1, 20265 min read
Finance metrics and formulas

Click to lead conversion rate: formula and denominator

Click to lead conversion rate measures accepted leads against eligible campaign clicks. Use ad and lead exports to define the numerator, compare mature click cohorts, and reconcile the result before changing campaign spending.

Aug 31, 20265 min read
Finance metrics and formulas · Manufacturing

LED bulb business profit: costs and margin drivers

Calculate LED bulb product and channel profit from sales, assembly or sourcing costs, recorded returns and warranty expenses. Follow a worked contribution bridge, spreadsheet formulas and a warranty reconciliation for an operating US business.

Aug 31, 20265 min read
Finance metrics and formulas

Nonprofit current ratio: liquidity and restricted funds

A nonprofit current ratio compares current assets with current liabilities, but donor restrictions can limit what the organization can spend. Work the accounting ratio and a separate availability reconciliation from the same financial workbook.

Aug 31, 20266 min read
Finance metrics and formulas

Direct mail ROI: measure contribution after campaign costs

Calculate direct mail ROI from matched orders, product margins, postage and printing costs. Follow a campaign workbook from source exports to a checked result, and separate attributed sales from incremental sales.

Aug 30, 20265 min read
Finance metrics and formulas · Distribution

Furniture business profit: product and order contribution

Calculate furniture order profitability after merchandise, inbound freight, damage and customer delivery costs. Follow a worked distributor example from sales exports to contribution and an operating profit reconciliation.

Aug 30, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

How to calculate marginal cost per unit

Calculate marginal cost per unit by comparing total production costs at two output levels. Follow the spreadsheet formulas, a worked capacity-step example and the checks that separate marginal cost from average unit cost.

Aug 30, 20265 min read
Finance metrics and formulas

Real estate balance sheet: assets, debt and equity

A real estate balance sheet records a property company's assets, financing obligations and equity at a reporting date. Work through property cost, depreciation, mortgage balances and a two-period reconciliation for an operating company.

Aug 30, 20265 min read
Finance metrics and formulas

Real estate financial statement analysis

Real estate financial statement analysis connects property operating income with capital spending, debt and cash needs. Follow a corporate property portfolio from statement exports through a worked operating and cash reconciliation.

Aug 30, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Turnover in finance: revenue and activity ratios

Turnover can mean sales revenue or an activity ratio that compares a business flow with an average balance. Learn which meaning applies, how to label the measure, and how to compare periods without confusing dollars with times.

Aug 30, 20266 min read
Finance metrics and formulas · Distribution

Vegetable business profit margin: waste and costs

Calculate a vegetable distributor's margin after measured spoilage, inbound freight and handling. Use lot and sales records to reconcile quantities, costs and contribution before subtracting shared operating expenses.

Aug 30, 20265 min read
Finance metrics and formulas · Sales teams

Average B2B customer acquisition cost: compare fairly

Average B2B customer acquisition cost depends on deal size, sales-cycle timing, and the spending included. Compare acquisition cohorts from CRM and finance exports, then check the cost against contribution and payback.

Aug 29, 20266 min read
Finance metrics and formulas · Supply chain

Carrying cost: calculate the cost of holding inventory

Carrying cost measures the expense of keeping inventory available. Calculate capital, storage, service, and risk costs, then reconcile the total by product and warehouse.

Aug 29, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial ratio analysis Excel template

Copy a reusable workbook layout for comparing profitability and liquidity across periods. The template includes statement inputs, exact formulas, denominator checks, and a worked US distributor example.

Aug 29, 20265 min read
Finance metrics and formulas · Manufacturing

Raw material inventory turnover formula and example

Raw-material turnover compares material consumed with average raw-material inventory at cost. Follow a plant-level example, reconstruct consumption from inventory movements, and reconcile the result before comparing materials.

Aug 28, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Adjusted EBITDA margin: formula and reconciliation

Adjusted EBITDA margin is documented adjusted EBITDA divided by revenue. Work through the full bridge from net income, review add-backs and gains, and compare business units using consistent revenue and adjustment policies.

Aug 27, 20266 min read
Finance metrics and formulas · Banking

Bank ratios: what to track and compare

Bank ratios connect profitability, credit quality, funding and capital. Compare a consistent set across two periods, trace the movements to reported amounts and assign the questions to the right owners.

Aug 27, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Discontinued operations on the cash flow statement

Discontinued operations still produce operating, investing and financing cash movements. Reconcile a disposal schedule to company totals and understand the US GAAP disclosure alternatives before separating continuing-business performance.

Aug 27, 20266 min read
Finance metrics and formulas · Education

Education financial analysis by program

Compare education program revenue, delivery costs and enrollment against budget. Build a contribution table from operating exports and reconcile the variance to the institution's financial results.

Aug 27, 20265 min read
Finance metrics and formulas · Banking

Bank operating leverage: revenue growth versus expense growth

Bank operating leverage compares revenue growth with noninterest expense growth. Calculate the percentage-point spread from finance exports, reconcile the profit change and separate provisions and unusual items.

Aug 26, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Return on investment: formula and a business example

Return on investment compares a project's net gain with its investment cost. Work through a business example, define the cost convention, and check negative returns and different project durations.

Aug 26, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Free cash flow ratio: denominator choices

The free cash flow ratio can mean different things depending on its denominator. This page uses free cash flow divided by operating cash flow, works a two-period comparison and shows how to label and reconcile the measure.

Aug 25, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Current Asset Turnover Ratio: Formula and Meaning

Current asset turnover measures revenue per dollar of average current assets. Work the ratio from balance-sheet and sales exports, reconcile the company total, and compare entities without confusing asset efficiency with liquidity.

Aug 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Modified cash basis of accounting: adjustments and example

The modified cash basis of accounting starts with cash transactions and adds documented adjustments, such as depreciation and inventory. Follow a US distributor's cash-to-income bridge and the balance-sheet checks that prove it.

Aug 24, 20265 min read
Finance metrics and formulas

Amazon sales velocity: calculate units sold per day

Amazon sales velocity measures a SKU's unit sales over a defined number of days. Calculate it from exported order history, reconcile cancellations and returns, and compare periods without inferring competitor sales or ranking changes.

Aug 23, 20266 min read
Finance metrics and formulas

Cost per action in marketing: formula and checks

Cost per action measures eligible campaign spend for each defined marketing outcome. Work the formula from campaign and outcome exports, remove duplicates, and reconcile the result before comparing campaigns.

Aug 23, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial analysis for startups: cash, revenue and spending

Financial analysis for startups compares actual cash burn, revenue and committed spending with the operating plan. Use a worked monthly review to reconcile the figures and separate runway from funding assumptions.

Aug 23, 20265 min read
Finance metrics and formulas · Manufacturing

Manufacturing margin: costs, mix and plant capacity

Compare manufacturing margins by product family and plant using sales, materials, labor and overhead workbooks. Reconcile applied overhead with actual spending so capacity effects remain visible.

Aug 23, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Fixed charge coverage ratio: formula and example

The fixed charge coverage ratio compares a stated earnings measure with specified fixed obligations. Work through a lease-inclusive example, reconcile the inputs, and see why changing the definition changes the answer.

Aug 22, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Annual equivalent cash flow: formula and example

Convert a project's net present value into a comparable annual amount. Work through two equipment options with different lives, the spreadsheet formulas, and the assumptions needed for a fair replacement decision.

Aug 21, 20265 min read
Finance metrics and formulas

Cost of customer retention: formula and cost boundaries

The cost of customer retention divides a defined retention cost pool by retained accounts. Use a worked segment example, cost boundaries, spreadsheet formulas and reconciliation checks to compare your own programs.

Aug 21, 20266 min read
Finance metrics and formulas · Retail banking

Retail banking cost analysis by branch and channel

Compare branch and channel operating costs using documented activity drivers. Build a cost-per-transaction worksheet, reconcile allocated expenses and separate volume effects from spending changes.

Aug 21, 20265 min read
Finance metrics and formulas

Sales price per unit: formula and realized-price checks

Sales price per unit divides net sales by the matching net quantity sold. Work the calculation from invoices and returns, prove the weighted total and distinguish product price changes from a change in sales mix.

Aug 21, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Target return pricing: how to calculate price per unit

Target return pricing adds the required profit per expected unit to unit cost. Calculate the price from invested capital, annual costs, and sales volume, then test how lower volume changes the result.

Aug 21, 20266 min read
Finance metrics and formulas · Banking

Bank efficiency ratio: formula and cost drivers

The bank efficiency ratio compares noninterest expense with operating revenue. Work the calculation from income and expense lines, reconcile the totals, and explain a change by cost driver.

Aug 20, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Purchase of bonds on the cash flow statement

Purchases of another issuer's bonds usually create investing cash outflows. Reconcile treasury purchases, sales, maturities and cash-equivalent transfers to the ledger without confusing them with issuing your company's own debt.

Aug 19, 20265 min read
Finance metrics and formulas · Supply chain

Apparel industry inventory turnover ratio: seasons and markdowns

Apparel inventory turnover needs seasonal cohorts, returns, and markdown context. Work a category comparison, reconcile the cost and sales inputs, and see why a faster stock movement figure cannot establish better profitability.

Aug 18, 20266 min read
Finance metrics and formulas · Distribution

Electronic business profit margin: SKU and channel costs

Calculate electronics contribution by SKU and channel after landed cost, rebates, returns and warranty expenses. Use sales and cost exports to reconcile the result before changing prices or channel terms.

Aug 18, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

ROI per annum: annualized ROI for business projects

Annualized ROI converts a total project return into an equivalent compound yearly rate. Follow a business project from its cost and terminal receipt to the annual rate, distinguish it from a simple yearly average, and check when cash-flow timing requires a different method.

Aug 18, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash Conversion Rate: Formula and Earnings Quality

Cash conversion rate compares operating cash flow with a stated earnings denominator. Work through two quarters, reconcile the difference to working capital and noncash expenses, and separate timing changes from recurring cash generation.

Aug 17, 20265 min read
Finance metrics and formulas · Manufacturing

Manufacturing cost analysis by product and plant

Manufacturing cost analysis compares materials, labor, and overhead across products and plants. Use production and ledger exports to reconcile spending to completed output, then investigate the drivers behind a cost gap.

Aug 17, 20265 min read
Finance metrics and formulas · Consumer goods

Whiskey industry financial ratios: inventory, margins and cash

Whiskey financial ratios need to separate aging stock from goods ready to sell. Work through margins, inventory days and operating cash flow for a US distillery, with the checks that connect production investment to reported results.

Aug 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Ecommerce profit margin formula: reconcile sales and order costs

Calculate ecommerce profit margin from order, refund, fulfillment, and fee exports. Reconcile product gross profit, order contribution, marketplace payouts, and company net profit using the same sales base.

Aug 16, 20266 min read
Finance metrics and formulas · Insurance

Insurance Brokerage Cost Analysis

Compare brokerage payroll, placement and overhead expenses with commission and fee income. Build branch totals from ledger exports, show shared allocations and reconcile budget variances.

Aug 16, 20265 min read
Finance metrics and formulas

Nonprofit financial analysis: liquidity and sustainability

Nonprofit financial analysis separates operating performance, donor restrictions and usable liquidity. Work through statement exports, expense trends and an availability schedule with exact spreadsheet formulas.

Aug 16, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Project finance cash flow waterfall: priorities and example

A project finance cash flow waterfall allocates available cash in the order required by the financing documents. Work through operating payments, debt service, reserve funding and distribution tests, then reconcile the allocations to bank movements.

Aug 16, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Accounting profit vs economic profit: the difference

Accounting profit measures revenue less recorded expenses, while economic profit also considers approved opportunity costs. Compare the two using the same operating results and a separate schedule of management assumptions.

Aug 15, 20266 min read
Finance metrics and formulas · Financial services

Customer acquisition cost in financial services

Measure customer acquisition cost for lending, insurance and investment-product cohorts using acquisition spending and completed activation events. This worked method separates initial acquisition from continued activity and compares costs with equally mature contribution.

Aug 15, 20265 min read
Finance metrics and formulas · Healthcare

Hospital financial ratios: margin, liquidity and debt

Hospital financial ratios connect facility operating results, available cash and debt service. Compare two facilities using consistent definitions, worked figures and checks back to prepared finance schedules.

Aug 15, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Liquidity and cash flow: balances versus movement

Liquidity measures available resources against obligations, while cash flow measures receipts and payments over time. Compare both from the same business records and reconcile the change in cash.

Aug 15, 20266 min read
Finance metrics and formulas · Banking

Bank liquidity ratios: measures and interpretation

A bank liquidity ratio compares a defined pool of liquid assets with assets or funding. Work through two quarters of bank reports, separate available assets from pledged balances, and interpret the result alongside funding concentration and cash flow.

Aug 14, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Perpetual cash flow: present value and assumptions

A constant perpetual cash flow is an equal business cash payment expected to continue indefinitely. Calculate its present value, test the payment timing and compare supplied cash and discount-rate assumptions before a capital decision.

Aug 13, 20266 min read
Finance metrics and formulas · Manufacturing

Profit per unit: formula, costs and a worked example

Calculate gross, contribution and fully allocated profit per unit from SKU sales and cost records. Follow a worked allocation, reconcile the totals and see how lower volume changes unit profit.

Aug 13, 20266 min read
Finance metrics and formulas · Hospitality

Restaurant P&L analysis: find the drivers of profit

Analyze restaurant profit by location using net sales, food, labor and occupancy costs. Work from comparable exports to a checked profit bridge that separates sales mix from cost-rate changes.

Aug 13, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

DCF sensitivity analysis: reading the valuation range

DCF sensitivity analysis shows how selected discount-rate and terminal assumptions change a business valuation. Rebuild a small example, check the center cell, and compare outputs from an analyst-prepared workbook.

Aug 12, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Industry financial ratios by NAICS code: compare fairly

Compare company ratios with a supplied industry benchmark workbook using a defensible NAICS peer group. This guide covers matching, spreadsheet calculations, weighted ratios and the checks that make a performance gap meaningful.

Aug 12, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow statement for a partnership: worked US example

A partnership cash flow statement separates business operations from partner capital movements. This worked US example reconciles contributions, distributions, borrowing and closing cash to the capital schedule.

Aug 11, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow break even analysis template: a cash worksheet

Build a cash break-even worksheet from collected revenue and cash operating costs. The layout separates depreciation from payments and shows how collection delays change the volume needed to cover a month.

Aug 10, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow to net income ratio: formula and interpretation

The cash flow to net income ratio compares operating cash generation with accounting earnings. Use a worked reconciliation to understand noncash adjustments, working capital timing, and the limits of small or negative net income.

Aug 10, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Factoring receivables on the cash flow statement

Factoring presentation depends on whether the transfer is a sale or a borrowing. Reconcile trade receivables, factor settlements, fees and debt with a worked US example.

Aug 10, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Funds flow analysis: sources and uses of working capital

Funds flow analysis explains how a company's working capital changed between two balance sheets. Build a sources-and-uses schedule, reconcile it to current assets less current liabilities, and distinguish the result from cash flow.

Aug 10, 20265 min read
Finance metrics and formulas

Affiliate marketing ROI: commissions, costs, and margin

Calculate affiliate marketing ROI after refunds, commissions and delivery costs. Build a settlement-based spreadsheet, reconcile the totals and compare affiliates on contribution rather than gross sales.

Aug 9, 20265 min read
Finance metrics and formulas · Software

Cash Conversion Cycle for Software Companies

A software company's conventional cash cycle can miss the effect of advance subscription billing. Compare receivable and payable days with billings, collections and deferred revenue before judging the cash position.

Aug 9, 20265 min read
Finance metrics and formulas · Consumer goods

Direct-to-consumer LTV: repeat purchases and margin

Calculate customer contribution after refunds, product costs and fulfillment from an order export. Compare acquisition cohorts at the same age, with a worked example and spreadsheet formulas.

Aug 9, 20265 min read
Finance metrics and formulas · Construction

Cost-benefit analysis for a construction project

Compare a company construction project's incremental investment with its expected business benefits. Build the cash-flow rows, discount them consistently and test whether the approval case survives a weaker benefit assumption.

Aug 8, 20265 min read
Finance metrics and formulas · Banking

Global cash flow: combine borrower and entity cash flows

Build a commercial credit worksheet for related businesses using ownership shares and matched transfers. Work from supplied cash-generation and debt-service schedules to a combined coverage ratio, with checks against double counting.

Aug 8, 20265 min read
Finance metrics and formulas · Financial services

Merchant profitability analysis for payment portfolios

Measure payment-provider contribution by merchant using processing volume, transactions, fee revenue and attributable costs. Work through the spreadsheet formulas, portfolio reconciliation and the treatment of losses and shared service costs.

Aug 8, 20265 min read
Finance metrics and formulas · Construction

Profit margin on replacement windows: price, labor and rework

Profit margin on replacement windows depends on the completed job's selling price and delivery costs. Work through materials, installation labor and callbacks, then compare crew results and reconcile gross profit before allocating shared overhead.

Aug 8, 20266 min read
Finance metrics and formulas · Telecommunications

Telecom financial analysis: subscribers, costs and cash

Telecom financial analysis connects subscriber revenue with operating costs and capital spending. Work through a segment-level example, reproduce it in Excel and reconcile operating profit to the cash balance.

Aug 8, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Types of working capital ratios and what each tells you

Working capital ratios answer different questions about payment capacity, asset use and cash timing. Compare the main measures using one monthly set of balances, with a worked example and reconciliation checks.

Aug 7, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash flow from operations to capital expenditures ratio

The cash flow from operations to capital expenditures ratio measures how much asset spending operating cash can cover. Work the ratio from statement rows, reconcile the result, and separate weaker cash generation from a larger investment program.

Aug 6, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial risk ratios: debt, coverage and liquidity

Financial risk ratios show how borrowing, earnings and short-term resources interact. Work through a company's debt, interest coverage and liquidity measures, then reconcile the figures to the supplied statements.

Aug 6, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Inventory write-down on the cash flow statement

An inventory write-down reduces profit without a cash payment when it is recorded. This page reconciles the expense, reserve usage and inventory movement so the operating cash-flow adjustment is counted once.

Aug 6, 20265 min read
Finance metrics and formulas · Healthcare

Medical device industry financial ratios: margin and cash

Compare medical-device margins, inventory efficiency and customer payment speed by product group. A worked US example shows the source rows, denominator choices and checks before a finance review.

Aug 5, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Deferred tax in the indirect cash flow statement

Deferred tax expense is a noncash adjustment in the indirect operating cash reconciliation. Work through tax expense, payable balances and cash payments, then check which deferred balance movements belong in the adjustment.

Aug 4, 20266 min read
Finance metrics and formulas · Professional services

Gross margin for a service business: labor and delivery costs

Calculate service gross margin from recognized revenue and a consistent delivery-cost definition. Work through labor, subcontractors, bench costs and allocations, then reconcile engagement margins to the company result.

Aug 4, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Net free cash flow: free cash flow vs net cash flow

Free cash flow measures operating cash remaining after defined capital spending, while net cash flow includes operating, investing, and financing movements. Reconcile both measures from the same company statement and see how borrowing changes cash without changing free cash flow.

Aug 4, 20265 min read
Finance metrics and formulas · Accounting

Accounting firm cost analysis by client and service

Build an accounting firm cost analysis from engagement time, approved labor rates and billing exports. Calculate direct labor, allocate overhead and reconcile client contribution to the practice totals.

Aug 3, 20266 min read
Finance metrics and formulas · Manufacturing

Asset utilization rate: measure productive capacity

Asset utilization rate compares productive equipment hours with a stated available-hours base. Work the calculation by asset, reconcile the time categories, and keep physical utilization separate from revenue-to-assets financial ratios.

Aug 2, 20266 min read
Finance metrics and formulas

Financial ratios for nonprofits: reserves, funding and costs

Financial ratios for nonprofits connect available cash, funding concentration and functional expenses. Work through two reporting years and see why a stronger surplus can accompany weaker cash coverage.

Aug 2, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Net working capital schedule: build a monthly rollforward

A net working capital schedule reconciles monthly operating assets and liabilities and shows the cash absorbed or released. Build it from balance-sheet and subledger exports, with exact spreadsheet formulas, component rollforwards and a cash reconciliation.

Aug 2, 20265 min read
Finance metrics and formulas · Manufacturing

Overhead variance: spending, efficiency and volume

Overhead variance compares actual manufacturing overhead with the overhead applied to actual output. Separate variable spending, variable efficiency, fixed spending and fixed production volume effects, then reconcile the parts.

Aug 2, 20266 min read
Finance metrics and formulas

Ecommerce LTV to CAC Ratio: Repeat Purchases and Margin

Calculate an ecommerce LTV to CAC ratio using observed customer cohorts and contribution after returns and variable costs. A worked example separates first-order value, repeat purchases and acquisition spending without using a subscription churn formula.

Aug 1, 20267 min read
Finance metrics and formulas

Equity IRR vs project IRR: financing changes the return

Project IRR measures a corporate project's cash flows before financing, while equity IRR measures the cash attributable to its owners. Compare the same project both ways, including debt draws, principal, interest and the explicitly assumed tax effects.

Aug 1, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Revenue vs gross receipts: reconcile the difference

Compare accounting revenue with gross receipts for a specified US reporting purpose. Work the same transactions through a revenue, cash and Form 1120 reconciliation.

Aug 1, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Accounts Payable Turnover Ratio Industry Average: A Guide

Build a documented payable turnover comparison from dated US peer reports. See a worked retail comparison, the limits of cost-of-sales proxies and the balance averaging choices that affect an industry benchmark.

Jul 31, 20265 min read
Finance metrics and formulas · Banking

Asset quality ratios for banks: what the measures show

Asset quality ratios for banks compare problem loans, recognized losses, and loan allowances. Work through quarterly balances and loss flows, then reconcile the ratios before interpreting the change.

Jul 31, 20266 min read
Finance metrics and formulas · Customer service

Call center cost-benefit analysis template

Build a call-center investment case from call volume, handling time, labor costs and technology spending. This reusable worksheet layout separates released capacity from cash savings and includes formulas, checks and a downside case.

Jul 31, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Fixed Asset Turnover Ratio by Industry: Peer Comparisons

Compare fixed asset turnover across industries without confusing asset age with operating performance. Work through dated US company disclosures and the adjustments that make a peer comparison useful.

Jul 31, 20265 min read
Finance metrics and formulas · Sales teams

LinkedIn Ads cost per lead: measure lead quality

Calculate LinkedIn Ads cost per lead from campaign and lead exports. Match the leads to qualified contacts, opportunities and won customers to see whether a lower CPL produces better sales outcomes.

Jul 31, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Nonprofit balance sheet: net assets and liquidity

A nonprofit statement of financial position reports assets, liabilities and net assets. Compare the donor-restriction classes, reconcile changes, and distinguish the accounting surplus from resources available for general spending.

Jul 31, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Prepaid expenses on the cash flow statement: indirect method

An increase in prepaid operating expenses reduces operating cash flow under the indirect method. Reconcile opening and closing balances to cash payments and expense recognition with a worked workbook example.

Jul 31, 20264 min read
Finance metrics and formulas · Finance and FP&A teams

Debt to equity ratio: formula, examples and interpretation

The debt to equity ratio compares a defined debt balance with book equity. Work it from two balance sheets, reconcile the inputs and separate changes in borrowing from changes in equity.

Jul 30, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Profitability Analysis: Find What Earns and What Costs

Profitability analysis identifies the products, customers and business units behind reported profit. Use a reconciled ledger example to separate gross profit, service costs and shared allocations, then assign actions to the underlying business drivers.

Jul 30, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Qualitative analysis of financial statements

Qualitative analysis connects financial results with business conditions, accounting choices and management explanations. Use a worked revenue, margin and cash review to separate supported explanations from questions that still need evidence.

Jul 30, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Return on invested capital by industry: compare peers

Compare industry ROIC only after aligning the earnings, tax and capital definitions. This worked example uses supplied hypothetical US peers to separate operating margin, capital intensity and goodwill effects.

Jul 30, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Solvency Ratio: Formulas and How to Read the Results

A solvency ratio relates a company's obligations to its funding or cash-generating capacity. Compare a cash-flow-based measure with an earnings proxy, reconcile the statements, and use complementary debt measures to explain the result.

Jul 30, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Long-term debt to net working capital ratio: formula and limits

The long-term debt to net working capital ratio compares noncurrent debt with current assets minus current liabilities. Calculate it from a balance sheet, reconcile the debt classification, and see why a small or negative denominator changes the interpretation.

Jul 29, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

PPP loans on the cash flow statement: cash and forgiveness

Historical PPP loan receipts and forgiveness affect different parts of a reporting workbook. Follow a debt-accounting example from the original bank receipt through principal repayment, noncash forgiveness and the cash reconciliation.

Jul 29, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Financial ratios for startups: burn, runway and margins

Choose startup measures that still make sense before profitability. Work through cash burn, runway, gross margin and working capital from monthly financial records, with checks that keep cash and earnings separate.

Jul 28, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Net working capital in capital budgeting

Net working capital ties up project cash before customers pay. Build the investment and recovery schedule, check its signs, and compare the funding effect of different assumptions.

Jul 28, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash Conversion Cycle by Industry: Compare Business Models

Industry cash-cycle comparisons depend on inventory, customer credit and supplier payment practices. Build a comparable peer set, work the components from matched-period balances and flows, and explain why a shorter cycle is not automatically a better operating target.

Jul 27, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Pretax margin: formula and financing effects

Pretax profit margin divides income before income tax by revenue. Calculate it from a P&L, reconcile changes across periods, and separate operating performance from interest and other nonoperating items.

Jul 27, 20265 min read
Finance metrics and formulas

Retail debt-to-asset ratio: compare industry averages

Retail debt-to-asset comparisons depend on the definition of debt, lease treatment and the retailers included. Build a dated peer comparison, calculate both company and aggregate figures, and reconcile the inputs to each balance sheet.

Jul 27, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

ROCE DuPont formula: margin and capital turnover

The ROCE DuPont formula separates operating return into EBIT margin and capital turnover. Build both components from financial-statement exports, reconcile the identity, and explain a return change without confusing sales growth with capital productivity.

Jul 27, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Invested capital: formula and operating balance sheet

Invested capital measures the funding tied up in business operations. Build it from operating balance-sheet rows, reconcile it to debt and equity, and compare periods using consistent classifications.

Jul 26, 20265 min read
Finance metrics and formulas · Banking

Rate volume mix analysis for net interest income

Rate volume mix analysis explains changes in bank interest income and funding expense using average balances and realized rates. Build a spreadsheet bridge that separates balance growth, portfolio mix and rate effects, then reconciles to net interest income.

Jul 26, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cost to serve analysis template

Use this cost to serve analysis template to organize cost pools, customer activity and contribution in a workbook. Copy the layouts, fill them from your exports and prove that allocated costs match the ledger.

Jul 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial gap analysis for business funding needs

Financial gap analysis compares dated cash needs with the cash and committed funding available to meet them. Work through a funding workbook, a minimum-cash check and a receipts downside case.

Jul 24, 20265 min read
Finance metrics and formulas · Manufacturing

Labor rate variance: formula and example

Labor rate variance isolates the cost effect of actual hourly pay differing from the approved standard. Work through department-level calculations, a weighted-rate check and a reconciliation to total direct labor cost.

Jul 24, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Cash coverage ratio: formula and interpretation

Cash coverage commonly adds depreciation and amortization back to EBIT before dividing by interest expense. Calculate that earnings-based measure, reconcile its addbacks, and distinguish it from actual cash-flow coverage.

Jul 23, 20266 min read
Finance metrics and formulas · Manufacturing

Scrap cost analysis by product and cause

Scrap cost analysis separates rejected quantities from material and conversion cost effects. Build a reconciled loss table by product, plant, and reason, then explain a change without counting the same loss twice.

Jul 23, 20265 min read
Finance metrics and formulas · Manufacturing

Cost flow analysis: tracing production costs

Cost flow analysis traces recorded costs through raw materials, work in process, finished goods, and cost of goods sold. Follow a manufacturing example from inventory exports to a complete reconciliation.

Jul 22, 20265 min read
Finance metrics and formulas

Working capital leverage formula: return sensitivity

Define working capital leverage as operating-return sensitivity under fixed profit and fixed noncurrent operating assets. Work the local coefficient and an exact scenario comparison, with a reconciliation of the capital released.

Jul 22, 20265 min read
Finance metrics and formulas · Consumer goods

Food and beverage industry financial ratios

Compare food and nonalcoholic beverage operations with ratios that keep manufacturing and distribution separate. Work through margin, inventory efficiency and liquidity using matched US business units and reconciled financial exports.

Jul 21, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Sample of a cash flow statement for a cooperative

A cooperative cash flow statement separates trading cash from member equity and patronage payments. Follow a US agricultural cooperative example with operating adjustments, debt, equity redemptions and a closing cash check.

Jul 21, 20266 min read
Finance metrics and formulas · Banking

UCA cash flow: format, calculation and interpretation

UCA cash flow converts borrower earnings and working-capital movements into a lending cash-flow schedule. Follow a worked calculation, spreadsheet formulas, debt-service conventions and a reconciliation to cash.

Jul 21, 20266 min read
Finance metrics and formulas · Logistics

Cost of shipping per pound: formula and checks

Shipping cost per pound divides stated freight charges by a stated weight basis. Work through shipment invoices, credits, actual and billable weights, and the checks needed for carrier and lane comparisons.

Jul 20, 20266 min read
Finance metrics and formulas

Farm financial ratios: liquidity, debt and profitability

Farm financial ratios connect seasonal working capital, operating returns and debt payments. Use a worked farm business example to compare consistent periods and prove the results against the financial statements.

Jul 20, 20267 min read
Finance metrics and formulas · Finance and FP&A teams

Consolidated cash flow statement: reconcile group cash

A consolidated cash flow statement reports the group's external cash movements after intercompany activity is eliminated. Follow a worked parent-and-subsidiary reconciliation, with workbook formulas and checks for category totals and ending cash.

Jul 19, 20265 min read
Finance metrics and formulas · Manufacturing

Cotton wicks business profit: yield, costs and contribution

Calculate cotton-wick batch costs and customer contribution from production and invoice exports. Follow the spreadsheet formulas from material yield through operating profit.

Jul 19, 20265 min read
Finance metrics and formulas

Marketing analytics pricing strategies and price analytics: compare margin

Compare realized selling prices, units and contribution by product and customer segment. A worked sales-export example shows how to turn observed differences into a pricing review without claiming to measure price elasticity.

Jul 19, 20265 min read
Finance metrics and formulas · Sales teams

PPC ROI: connect ad costs to contribution profit

Calculate paid-search ROI from campaign spending and matched financial outcomes. Reconcile clicks, orders, refunds, direct costs, and campaign fees before comparing returns.

Jul 19, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Working capital turnover: formula and interpretation

Working capital turnover compares sales with the average working capital supporting them. Calculate the ratio from monthly balances, reconcile net and operating definitions, and understand changes before comparing periods.

Jul 19, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Working ratio formula: operating costs versus revenue

Use the working ratio formula with an explicit operating-cost boundary. A worked services-company example separates depreciation, reconciles business units and shows why accrued expenses differ from cash paid.

Jul 19, 20266 min read
Finance metrics and formulas · Consumer goods

Chocolate business profit margin: costs and product mix

Measure chocolate product and channel margins after ingredients, production losses, packaging and selling costs. Use a worked US manufacturing example, exact spreadsheet formulas and checks that prevent spoilage from being counted twice.

Jul 18, 20265 min read
Finance metrics and formulas

Dropshipping profit margin: costs that determine the result

Calculate dropshipping contribution from order, supplier, fee, return, and campaign exports. Use exact spreadsheet formulas and a worked example to distinguish order contribution from company profit.

Jul 18, 20264 min read
Finance metrics and formulas · Finance and FP&A teams

Incremental margin: formula and profit growth

Incremental margin measures how much of a change in revenue becomes a change in profit. Work through the operating-profit formula, reconcile the cost bridge, and handle flat or falling sales before comparing business units.

Jul 18, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Operating lease cash flow statement: US GAAP treatment

Operating lease payments generally appear in operating activities under US GAAP. Reconcile a lessee's payment workbook to lease expense, liability movements and noncash recognition with a monthly example.

Jul 18, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Profitability and efficiency ratios: margins and turnover

Profitability ratios measure earnings, while efficiency ratios measure the assets used to support sales. This business-unit example connects operating margin and asset turnover to explain differences in operating return.

Jul 18, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Accounts receivable turnover industry average: compare peers

An industry receivables benchmark needs a dated peer group and consistent definitions. Compare two documented US companies, separate sales proxies from credit-sales turnover, and trace your own gap to customer balances.

Jul 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

EBITDA and working capital: why profit can use cash

EBITDA can rise while receivables and inventory absorb the cash earned by a business. This worked example connects EBITDA to operating working capital, reconciles the result to operating cash flow and identifies who owns each movement.

Jul 17, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

EBITDA to cash flow from operations: a reconciliation

Bridge EBITDA to operating cash flow using cash interest, cash taxes and operating balance movements. Build the monthly reconciliation from reporting exports, check the result against the cash flow statement and avoid counting the same adjustment twice.

Jul 17, 20265 min read
Finance metrics and formulas · Construction

Life cycle cost analysis in construction

Life cycle cost analysis compares building alternatives using their initial and future ownership costs. Build a consistent study period, discount recurring and replacement costs, account for residual value and check the difference between options.

Jul 17, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Restricted cash on the balance sheet

Restricted cash belongs in the cash reconciliation but may be unavailable for general spending. Compare approved classifications across periods, reconcile the balances, and separate reported cash from operating liquidity.

Jul 17, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial operating leverage: costs and debt compared

Separate operating leverage from financial leverage using the same business scenarios. Follow fixed costs, contribution, operating income and interest through a worked comparison, then check the profit sensitivities against the underlying dollars.

Jul 16, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Discretionary cash flow: definition and adjustments

Discretionary cash flow often means seller's discretionary earnings in business acquisition discussions. Build a documented earnings adjustment schedule, then reconcile it separately to actual cash.

Jul 14, 20266 min read
Finance metrics and formulas · Supply chain

Inventory-to-sales ratio: formula and interpretation

The inventory-to-sales ratio divides an inventory balance by net sales for a stated period. Work the ratio and its reciprocal by category, check the totals, and understand why valuation and seasonal timing change the interpretation.

Jul 14, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Return on working capital: formula and interpretation

Return on working capital compares operating earnings with average operating working capital. Calculate the balances from export rows, prove the result and handle near-zero or negative denominators before comparing units.

Jul 14, 20266 min read
Finance metrics and formulas · Distribution

Value added reseller margins: products and services

Separate product resale margins from implementation and support costs. Follow a customer bundle from sales and supplier files through delivery labor, contribution and allocated account profit.

Jul 14, 20265 min read
Finance metrics and formulas · Banking

Bank customer profitability across products and costs

Bank customer profitability combines product income, funding allocations, credit charges and servicing costs for the same relationship. This guide works from banking exports to a reconciled relationship contribution table.

Jul 13, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Industry averages for financial ratios: compare peers fairly

Industry ratio benchmarks are useful only when the companies and definitions are comparable. Build a dated peer workbook, calculate average, median and pooled ratios, and reconcile the comparison before acting on a gap.

Jul 13, 20265 min read
Finance metrics and formulas · Professional services

Cash Conversion Cycle for Service Companies

Service companies can compare customer collection with supplier payment timing without inventing inventory. Build the calculation from receivables, payables and matched costs, then keep unbilled work and payroll visible.

Jul 12, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial ratios for mining industry operating reviews

Mining financial ratios connect site operating margins, capital use and short-term liquidity. This guide works through two US mine sites, reconciles their results and separates operating changes from commodity-price effects.

Jul 12, 20266 min read
Finance metrics and formulas · Banking

Bank productivity ratios: output, staff and cost

Bank productivity ratios compare completed work or revenue with staffing and cost. Follow a branch example, reconcile the combined result, and see why labor productivity differs from the bank efficiency ratio.

Jul 11, 20266 min read
Finance metrics and formulas · Manufacturing

Semiconductor industry financial ratios for operating reviews

Connect semiconductor margins, inventory turns and production asset returns in one operating review. A worked US manufacturer example shows the effect of capital intensity and why better margins can coexist with lower inventory turns.

Jul 11, 20267 min read
Finance metrics and formulas

Customer Acquisition Cost by Industry: Compare Like for Like

Customer acquisition cost by industry is useful only when the cost scope, customer unit, geography, and period match. Learn how to assess benchmark definitions and compare consistent internal cohorts with acquisition cost and contribution payback.

Jul 10, 20266 min read
Finance metrics and formulas · Manufacturing

Manufacturing financial analysis: profit, costs and cash

Manufacturing financial analysis connects plant profit to output, production costs and inventory cash. Follow a worked monthly review with spreadsheet formulas and checks that separate better operations from cost absorption.

Jul 10, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Altman Z score formula for financial statement analysis

The Altman Z score combines liquidity, accumulated earnings, operating profit, equity value and asset turnover. Work through the original formula, check which companies it applies to, and reconcile the change between reporting periods.

Jul 9, 20266 min read
Finance metrics and formulas · Banking

Bank profitability analysis: income, costs and earnings

Reconcile bank earnings from interest income, funding costs, fees, operating expense and provision. Compare business lines and periods with a dollar bridge that ties to finance's reported results.

Jul 9, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Break even cash flow: formula and operating cash costs

Cash break-even is the sales level that covers cash operating costs before collection timing and other cash movements. Work through the cost split, the formula and a bridge from operating break-even to the bank balance.

Jul 9, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Break-even time: operating profit vs cash payback

Break-even time can mean the first month that covers operating costs or the month cumulative launch cash is recovered. Calculate both dates from monthly exports, reconcile profit to cash, and identify what remains unfunded.

Jul 9, 20265 min read
Finance metrics and formulas · Procurement

Cost per purchase order: processing cost calculation

Cost per purchase order divides procurement processing spending by the purchase orders handled in the same period. Calculate it by business unit and processing route, reconcile the cost pools, and separate a process difference from a change in order mix.

Jul 9, 20266 min read
Finance metrics and formulas · Healthcare

Cost-benefit analysis in health care: facility investments

A healthcare facility cost-benefit analysis compares incremental investment costs with measurable operating cash benefits. Build a workbook from quotes, spending records and utilization assumptions, then test the result before approving the project.

Jul 9, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Operating expense margin: costs as a share of revenue

Operating expense margin measures expenses below gross profit as a share of revenue. Follow a worked cost-center example, reconcile it to the income statement and explain the change between periods.

Jul 9, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Deferred financing costs on the cash flow statement

Cash debt issuance fees and amortization affect different parts of the cash flow statement. Work through a debt schedule, reconcile the fee balance, and check the cash and noncash entries.

Jul 8, 20265 min read
Finance metrics and formulas · Distribution

Distribution financial analysis by branch and product

Distribution financial analysis joins branch profitability with inventory and receivables. Use the worked spreadsheet layout to compare margins, trace working-capital movements and reconcile the cash available after operating costs.

Jul 8, 20265 min read
Finance metrics and formulas

Ecommerce Customer Acquisition Cost: Formula and Inputs

Calculate ecommerce customer acquisition cost from distinct first-time buyers and fully loaded acquisition spending. Work through channel costs, buyer exclusions, refunds and the first-order gross profit check.

Jul 8, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Explain the determinants of working capital for firms

Operating scale, collection timing, inventory policy, supplier terms and seasonality determine how much cash a business ties up. Compare their separate effects in a worked US distributor example and reconcile the combined change.

Jul 8, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Financial analysis for small business: a monthly review

Financial analysis for small business connects profit, bank cash and customer payment timing. Follow a worked review using accounting exports, margin calculations and a cash reconciliation.

Jul 8, 20265 min read
Finance metrics and formulas · Manufacturing

Financial ratios for manufacturing companies

Compare manufacturing inventory, production assets, profit margins and liquidity from plant workbook exports. A worked example shows how the ratios fit together and how to check the company totals.

Jul 8, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Interest coverage ratio: formula and interpretation

Interest coverage compares earnings before interest and taxes with interest expense. Build the ratio from a P&L export, reconcile the numerator, and separate earnings changes from borrowing costs.

Jul 8, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

IRR financial model: project cash flows and checks

IRR in a financial model is the discount rate that brings project net present value to zero. Build a project cash-flow schedule, calculate IRR in Excel and check how a timing change affects the result.

Jul 8, 20264 min read
Finance metrics and formulas · Finance and FP&A teams

Net working capital peg: setting a deal target

A net working capital peg is the operating working capital target used to compare balances delivered at an acquisition closing. Build a monthly comparison from seller schedules, test the effect of seasonality and reconcile a proposed target to the same account definitions.

Jul 8, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Capital leases cash flow statement: finance lease treatment

Finance lease payments split between operating and financing cash flows under US GAAP. Reconcile the principal, interest, liability rollforward, and noncash additions from lease and ledger exports.

Jul 7, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

FCFF to FCFE: the cash flow reconciliation

Convert free cash flow to the firm into free cash flow to equity using after-tax interest and net borrowing. Follow one company's operating and financing rows through both calculations, then prove that the bridge reconciles.

Jul 7, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Financial statement analysis and the prediction of financial distress

Compare cash generation, liquidity and interest coverage to investigate operating deterioration. This guide works through historical statements, spreadsheet formulas and the checks that support each finding.

Jul 7, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

ROE vs cost of equity: accounting and required returns

Compare accounting ROE with the required equity return supplied by your finance team. A worked company example separates book equity, the hurdle rate and the dollar gap between them.

Jul 7, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

After-tax operating cash flow: formula and assumptions

Calculate project operating cash flow after cash taxes while keeping depreciation, financing and investment spending separate. Work a US project example, compare tax depreciation assumptions and reconcile the result before using it in an investment decision.

Jul 6, 20266 min read
Finance metrics and formulas

Earned media ROI: measure outcomes without ad-value proxies

Measure earned media ROI from program costs and matched business outcomes. A worked example allocates contribution across sales records, tests a different credit rule and distinguishes attributed return from incremental impact.

Jul 6, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Maximum annual debt service coverage ratio: meaning

Maximum annual debt service coverage compares defined annual income with the largest annual payment requirement in a debt schedule. Work through the income bridge, identify the peak year, and reconcile the result against first scheduled-year coverage.

Jul 6, 20265 min read
Finance metrics and formulas · Sales teams

Target ROAS: meaning and how to set a business target

Target ROAS is the revenue a business wants for each advertising dollar. Work from contribution margin to a defensible target, then check campaign results against the same revenue and cost definitions.

Jul 6, 20266 min read
Finance metrics and formulas · Sales teams

Facebook Ads cost per lead: calculation and interpretation

Calculate Facebook Ads cost per lead from campaign spending and matched lead records. Reconcile form submissions to usable contacts, then compare qualification and customer conversion before changing the budget.

Jul 5, 20264 min read
Finance metrics and formulas · Finance and FP&A teams

Activity ratios: formulas and operating interpretation

An activity ratio measures how efficiently a company uses assets, inventory or receivables to support sales. Compare the main turnover measures, rebuild a two-year example and learn which operating team should investigate each change.

Jul 4, 20266 min read
Finance metrics and formulas

Average marketing ROI: compare costs and time windows

Average marketing ROI is useful only when campaigns share the same profit definition, cost boundary and observation window. Work through a campaign comparison, prove the weighted return and separate attributed contribution from incremental profit.

Jul 4, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Debt service: formula and example

Debt service is scheduled principal plus cash interest for a stated period. Calculate it by loan and month, reconcile the principal to debt balances and see how a maturity payment changes the cash requirement.

Jul 4, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial statement analysis in mergers and acquisitions

Compare an acquisition target's historical revenue, margins, working capital and cash conversion. A worked US business example shows what the trends establish, which questions they raise and who should resolve them.

Jul 4, 20266 min read
Finance metrics and formulas · Sales teams

Average ROAS: compare benchmarks with your margins

Average ROAS is only comparable when revenue, spending and attribution definitions match. Calculate a weighted campaign average, test the contribution behind it and evaluate outside benchmarks without assuming a universal target.

Jul 3, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Financial analysis for business decisions

Financial analysis connects a company's revenue, costs, earnings and cash to the decisions managers need to make. Use a checked quarterly example to read the statements together, explain changes and assign the next investigation.

Jul 3, 20266 min read
Finance metrics and formulas

Telecom cost analysis for business spending

Telecom cost analysis compares business invoices with the services a company actually uses. Reconcile recurring charges, usage, fees, and credits, then compare locations and investigate inactive services with a worked spreadsheet example.

Jul 3, 20265 min read
Finance metrics and formulas · Consumer goods

Bread profit margin: cost each loaf and batch

Calculate bread profit margin from production yield, ingredient costs and actual sales. Work through a batch and compare counter sales with wholesale contribution.

Jul 1, 20264 min read
Finance metrics and formulas · Wealth managers

Financial advisor compensation models: compare firm costs

Compare salary, revenue payout and salary-plus-incentive structures from an advisory firm's budgeting perspective. Work the same client books through each structure, include employer costs and test the effect of lower revenue.

Jul 1, 20266 min read
Finance metrics and formulas · Supply chain

Inventory ratios: which measure answers which question

Inventory ratios connect stock balances with sales, cost of goods sold, and gross profit. Compare the measures on one category scorecard, reconcile the inputs, and choose the ratio that fits your decision.

Jun 30, 20266 min read
Finance metrics and formulas · Investment banking

Investment banking ratios: compare deal economics

Use investment banking ratios to compare transaction-company margins, leverage and valuation multiples. Work through a consistent deal workbook, reconcile enterprise value and earnings, and identify the assumptions that change the comparison.

Jun 30, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Low profit margin products: when volume makes them worthwhile

Decide whether to retain, reprice, or review low profit margin products using contribution dollars and avoidable costs. Work from invoice lines through cost to serve, capacity use, and a product-retention check.

Jun 30, 20266 min read
Finance metrics and formulas

Marketing automation ROI: costs, savings, and return

Marketing automation ROI compares supported benefits with the full cost of the program. Separate cash savings, released staff capacity, and incremental contribution before approving the investment.

Jun 30, 20265 min read
Finance metrics and formulas · Procurement

Annual order cost formula: orders times cost per order

Annual ordering cost is the number of orders placed during a year multiplied by the processing cost of each order. Work from purchase-order headers and an agreed cost rate, compare purchasing frequencies, and separate released capacity from cash savings.

Jun 28, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

How to analyze headcount costs

Analyze payroll costs by department using average staffing, recurring compensation, and hiring dates. Build a budget-to-actual bridge that reconciles to the ledger and separates recurring changes from one-time costs.

Jun 28, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Investment in accounts receivable: formula and example

Estimate the receivables supported by customer credit and the cash costs funded while invoices remain unpaid. A worked example separates face value from a cost-based planning estimate and tests a longer collection period.

Jun 28, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Debt adjusted cash flow: definition and reconciliation

Debt adjusted cash flow changes operating cash flow using an explicitly stated financing adjustment. Compare two US entities through a complete bridge, see how the measure differs from free cash flow, and identify the records needed to check it.

Jun 26, 20265 min read
Finance metrics and formulas · Manufacturing

Return on fixed assets: formula and interpretation

Return on fixed assets compares a stated profit measure with average net fixed assets. Work through a three-plant example, reconcile the asset schedule, and separate operating performance from the effect of depreciation.

Jun 26, 20266 min read
Finance metrics and formulas

Apparel profit margins: gross, contribution and net

Compare apparel margin layers after discounts, returns and channel costs. Follow an illustrative brand's direct and wholesale sales through gross profit, contribution and the company net result.

Jun 25, 20266 min read
Finance metrics and formulas

Average marketing ROI by industry: compare like returns

Industry marketing ROI figures only compare when revenue, margin, costs, and measurement periods match. Use a worked segment comparison to separate industry economics from campaign performance.

Jun 25, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Due diligence financial analysis: checks before a deal

Reconcile revenue, earnings adjustments and operating working capital to seller-provided records. Follow a worked example and spreadsheet checks that turn unexplained differences into specific questions for the deal team.

Jun 25, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

How to calculate life cycle cost per unit

Life cycle cost per unit spreads product development, production, support and retirement costs across expected lifetime output. Build the calculation from a cost-planning workbook and test the assumptions that change it.

Jun 25, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Cash payments for operating expenses: how to calculate

Convert accrued operating expenses into cash paid using prepayments, accruals and noncash charges. Follow a ledger-to-payment reconciliation with spreadsheet formulas and a worked example.

Jun 24, 20264 min read
Finance metrics and formulas · Hospitality

Hospitality financial analysis by property

Hospitality financial analysis connects room demand, departmental contribution and cash movements. Use property exports to calculate occupancy, ADR and RevPAR, reconcile operating results and identify the cash needs behind them.

Jun 24, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Liquidity and efficiency ratios: what each measures

Liquidity ratios assess short-term payment capacity. Efficiency ratios measure how productively assets support sales, and this worked comparison shows why the two can move in different directions.

Jun 24, 20265 min read
Finance metrics and formulas

Print on demand profit margin: actual order contribution

Calculate print-on-demand contribution from order and fulfillment exports. Include discounts, refunds, printing, shipping, marketplace fees and attributable advertising before comparing products.

Jun 24, 20265 min read
Finance metrics and formulas · Construction

Analyzing construction company financial statements

Read contractor income, contract balances and cash together. Follow a worked reconciliation from project exports to the company statements, including retainage and billing timing.

Jun 23, 20266 min read
Finance metrics and formulas

Qualified lead conversion rate: qualification to closed sale

Qualified lead conversion rate measures how many qualified prospects become customers. Calculate it by qualification cohort and source, with a CRM example, outcome reconciliation, and rules for open records.

Jun 22, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Return on research capital: formula and limitations

Return on research capital compares gross profit with prior-period research and development expense. Work the ratio from annual ledger rows, check the period pairing, and understand why it does not prove a research project's return.

Jun 22, 20265 min read
Finance metrics and formulas · Banking

Risk-adjusted return on equity: inputs and interpretation

Risk-adjusted return on equity compares an approved measure of risk-adjusted profit with allocated equity. Work through a bank business-unit comparison, reconcile the adjustments and see how capital allocation changes the answer.

Jun 22, 20266 min read
Finance metrics and formulas · Hospitality

Working capital for restaurant teams: payroll, stock and receipts

Calculate restaurant working capital and turn the balance into a dated cash review. Work through card settlements, perishable inventory, supplier payments and payroll using a checked weekly example.

Jun 21, 20266 min read
Finance metrics and formulas

Car dealership inventory turnover ratio: units, cost and aging

Dealership inventory turnover can measure vehicles sold or the cost of vehicles sold against average stock. This page separates those bases, works new and used vehicle examples, and checks the result against inventory movements and aging.

Jun 20, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

IRR vs ROIC: cash-flow returns vs operating returns

IRR measures the return in a project's dated cash flows, while ROIC measures operating profit against invested capital. Compare both measures on the same equipment investment, reconcile the inputs, and see why the percentages differ.

Jun 20, 20266 min read
Finance metrics and formulas · Construction

Current ratio in construction: WIP and cash timing

Interpret a contractor's current ratio alongside retainage, contract assets and payment timing. A worked example separates reported working capital from cash available for upcoming obligations.

Jun 19, 20265 min read
Finance metrics and formulas · Oil and gas

Oil and gas services cost analysis

Compare oilfield job costs by crew, service line and customer using operating and expense exports. Calculate crew, equipment, mobilization and subcontractor costs, allocate shared overhead and reconcile the result to the ledger.

Jun 19, 20266 min read
Finance metrics and formulas

Online clothing store profit margin: costs and returns

Calculate online clothing-store margin from orders, returns, fulfillment and expense exports. Reconcile product contribution to operating and net profit with exact spreadsheet formulas.

Jun 19, 20265 min read
Finance metrics and formulas

Cash flow to creditors formula: interest and net borrowing

Cash flow to creditors measures the net cash a business transfers to its lenders. Reconcile interest payments, borrowing proceeds and principal repayments, then check the result against a debt rollforward that separates noncash changes.

Jun 18, 20265 min read
Finance metrics and formulas · Hospitality

Customer Acquisition Cost for Restaurants

Measure restaurant customer acquisition cost using identified first-time diners rather than orders or covers. Work through channel spending, promotion costs, repeat purchases, and observed contribution from restaurant exports.

Jun 18, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Headcount variance: separate staffing, timing and pay

Headcount variance compares actual employees or full-time equivalents with an approved staffing plan. Use matching snapshots and period averages to distinguish vacancies, late hires and pay changes.

Jun 18, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

How to calculate cost per unit

Calculate cost per unit from a defined cost total and matching output. Work through the spreadsheet formulas, a product-level example, and the checks that prove the result.

Jun 18, 20264 min read
Finance metrics and formulas

Incremental return on ad spend: measurement and limits

Incremental return on ad spend compares additional revenue with additional advertising cost. Work through a treatment and control example, normalize unequal groups, and separate the arithmetic from the evidence needed to claim causal lift.

Jun 17, 20266 min read
Finance metrics and formulas · Banking

Return on risk-weighted assets: formula and interpretation

Return on risk-weighted assets compares an approved earnings measure with reported RWA. This guide states the numerator, averaging and annualization conventions, works a bank business-unit example, and checks that the group ratio reconciles.

Jun 17, 20266 min read
Finance metrics and formulas · Financial services

Average CAC for Fintech: Compare Like With Like

Fintech acquisition costs depend on product type, onboarding expense and what counts as an activated customer. Compare a fully worked acquisition cohort, reconcile the average and learn how to assess an outside benchmark.

Jun 16, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Debt vs equity financing: costs and cash commitments

Compare debt repayments with equity dilution using the same company funding requirement and operating cash assumptions. Follow a debt schedule, ownership calculation and downside cash check before choosing a financing route.

Jun 16, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Free cash flow to debt: formula and interpretation

Free cash flow to debt compares cash after capital spending with interest-bearing borrowings. Calculate the coverage percentage and its inverse debt-to-FCF multiple, reconcile the debt balance and understand what neither measure proves about repayment.

Jun 16, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Initial investment cash flow: calculate the outlay

Calculate initial investment cash flow from equipment, setup payments, initial working capital and after-tax disposal proceeds. A worked US project shows the sign convention, spreadsheet formulas and the effect of a larger inventory requirement.

Jun 16, 20266 min read
Finance metrics and formulas · Investment banking

Investment banking cost analysis by deal and team

Compare advisory fees with deal labor, direct expenses and allocated shared costs. Follow a worked example from fee, time and expense exports to contribution by engagement and advisory team.

Jun 16, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Non-cash investing and financing activities: examples

Identify investing and financing transactions that change assets, debt or equity without moving cash. Reconcile a transaction register to cash-flow totals and a separate noncash disclosure schedule.

Jun 16, 20265 min read
Finance metrics and formulas · Distribution

Return on inventory ratio: formula and interpretation

The return on inventory ratio compares gross profit with average inventory at cost. Work it by product category, prove the company total and distinguish gross margin return from turnover, markup and overall investment returns.

Jun 16, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Capital turnover: formula and interpretation

Capital turnover measures revenue against average capital employed. Work through the balance-sheet rows, the funding reconciliation and a business-unit comparison before interpreting a change.

Jun 15, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

DSCR vs interest coverage ratio: what each measures

Debt service coverage includes scheduled principal and interest, while interest coverage tests interest alone. Compare both on the same earnings and debt rows, with explicit numerator conventions and checks.

Jun 15, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Levered and unlevered free cash flow: what each measures

Levered and unlevered free cash flow answer different financing questions. Compare the same operating, tax, capital-spending and debt schedules under both definitions, with a worked US company example.

Jun 15, 20266 min read
Finance metrics and formulas · Oil and gas

Oil and gas services financial analysis: margins to cash

Compare oilfield service-line profitability, equipment utilization and receivables on one reporting basis. Work from job exports to a cash bridge that explains why profit has not reached the bank.

Jun 15, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

WACC ROCE comparison: match returns and capital costs

ROCE usually measures pre-tax operating returns, while WACC usually includes the debt tax shield. Compare them on a consistent tax and capital basis, using a worked business-unit example and checks for the finance review.

Jun 15, 20266 min read
Finance metrics and formulas · Manufacturing

Automotive industry financial ratios and matched benchmarks

Compare automotive margins, inventory turnover and capital use with peers that do the same work. A US supplier example shows the calculations, reconciliations and limits of a benchmark comparison.

Jun 14, 20266 min read
Finance metrics and formulas · Retail banking

Bank customer lifetime value: contribution by cohort

Bank customer lifetime value starts with contribution across a customer's banking relationship. This worked method combines product income, agreed funding allocations and costs, then separates historical cohort evidence from future retention assumptions.

Jun 14, 20265 min read
Finance metrics and formulas · Education

Education cost analysis by program and activity

Compare education program budgets, actual spending and cost per participant on consistent activity bases. Follow a worked example with spreadsheet formulas, volume adjustments and checks against the ledger and enrollment register.

Jun 14, 20265 min read
Finance metrics and formulas · Finance and FP&A teams

Financial break-even formula: find zero EPS

Financial break-even is the operating earnings needed to leave zero earnings for common shareholders after financing charges. Work through interest, preferred dividends and taxes, then compare financing scenarios with a check back to earnings per share.

Jun 14, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Sales in a balance sheet: where revenue actually appears

Sales appear on the income statement, while their effects enter cash, receivables and retained earnings on the balance sheet. Trace one US distributor's month through the entries, statement balances and reconciliation checks.

Jun 14, 20266 min read
Finance metrics and formulas · Finance and FP&A teams

Optimal leverage ratio: set a target your cash flow supports

An optimal leverage ratio depends on cash generation, downside conditions, and the company's own constraints. Use a worked spreadsheet example to compare a proposed debt balance with both earnings and cash-flow limits.

Jun 13, 20265 min read
Finance metrics and formulas

Rent coverage ratio: formula and operating headroom

Rent coverage compares a site's earnings before rent with its rent obligation under a stated convention. Calculate EBITDAR coverage for two US locations, check the combined result, and test a renewal increase.

Jun 13, 20266 min read
Finance metrics and formulas · Banking

Analyzing Business Financial Statements and Tax Returns

Compare business financial statements with tax-return schedules without confusing book income and taxable income. Follow a documented reconciliation, reproduce the spreadsheet formulas, and identify the questions a commercial credit reviewer should resolve.

Jun 12, 20265 min read
Finance metrics and formulas · Retail banking

Credit card customer lifetime value: costs and calculation

Credit card customer lifetime value depends on contribution after funding, rewards, credit losses and servicing. Work through a supplied cardholder cohort, discount its projected contribution, and check the costs and original-customer denominator.

Jun 12, 20266 min read
Finance metrics and formulas

Net operating income vs EBITDA: property and company profit

Property net operating income measures revenue after property operating costs. This guide reconciles the same property and corporate expense rows to company EBITDA, explains the overhead boundary, and shows how to check both figures.

Jun 12, 20266 min read