Blog · Topic
Margins, ratios and working-capital measures: the formula, a worked example from real rows, and where the number misleads.
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 readPrepare 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 readConnect 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 readCalculate 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 readCompare 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 readCustomer 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 readConnect 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 readIncremental 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 readThe 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 readCompare 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 readThe 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 readManufacturing 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 readMeasure 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 readCalculate 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 readMeasure 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 readBuild 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 readStock-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 readCalculate 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 readAn 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 readCalculate 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 readA 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 readCash 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 readCost 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 readThe 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 readDu 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 readThe 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 readFixed-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 readCalculate 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 readInventory 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 readCalculate 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 readMeasure 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 readReconcile 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 readReturn 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 readPrepare 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 readWACC 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 readCalculate 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 readWorking 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 readThe 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 readAverage 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 readA 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 readThe 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 readCalculate 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 readCalculate 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 readBuild 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 readMeasure 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 readBank 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 readThe 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 readFixed 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 readThe 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 readNOPAT 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 readCalculate 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 readProfit 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 readUse 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 readWorking 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 readApply 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 readAOV 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 readCalculate 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 readEVA 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 readHealthcare 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 readRollforward 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 readSaaS 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 readFind 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 readUse 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 readCalculate 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 readB2B 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 readMeasure 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 readCash 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 readA 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 readFinancial 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 readNet 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 readThe 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 readThe 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 readThe 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 readCalculate 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 readRevenue 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 readCash 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 readThe 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 readSee 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 readFirst-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 readInventory 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 readLocational 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 readOperating 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 readMeasure 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 readCompare 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 readCost 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 readFintech 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 readNonfinancial 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 readAn 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 readProfit 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 readCalculate 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 readCash 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 readA 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 readWork 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 readCompare 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 readA 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 readEcommerce 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 readThe 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 readFinancial 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 readFlux 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 readMarketing 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 readThe 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 readSales 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 readSenior 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 readCompare 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 readReturn 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 readAccounts 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 readCompare 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 readCompare 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 readCompare 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 readSensitivity 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 readCost 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 readDividends 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 readDSCR 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 readReconcile 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 readAssess 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 readCalculate 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 readGross 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 readOperating 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 readPayment 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 readMeasure 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 readReturn 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 readROI 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 readCalculate 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 readThe 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 readBalance 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 readBuild 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 readCapital 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 readCash 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 readReconcile 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 readA 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 readFinance 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 readCompare 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 readCalculate 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 readCompare 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 readTrace 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 readProperty 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 readWorking 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 readA 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 readCalculate 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 readTranslate 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 readGross 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 readCompare 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 readNegative 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 readOperating 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 readTelecommunications 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 readReconcile 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 readCash 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 readCompare 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 readConnect 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 readThe 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 readMeasure 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 readThe 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 readAn 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 readAn 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 readAn 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 readThe 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 readCalculate 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 readThe 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 readCompare 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 readSeparate 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 readAn 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 readBad 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 readA 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 readDebt 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 readMeasure 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 readChoose 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 readR&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 readCalculate 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 readCompare 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 readA 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 readA 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 readCapital 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 readBuild 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 readCompare 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 readCalculate 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 readReconcile 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 readMeasure 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 readSales 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 readAverage 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 readCash-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 readReconcile 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 readIndustry 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 readCompare 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 readCalculate 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 readImprove 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 readIntangible-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 readLiquidity 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 readNet 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 readCalculate 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 readSaaS 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 readThe 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 readMove 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 readCash 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 readThe 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 readEssential 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 readOperating 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 readFind 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 readSoftware 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 readCalculate 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 readCash 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 readEducation 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 readUnderstand 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 readCompare 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 readTrack signed return commission, its original policy link and the timing of cancellation adjustments. Avoid overstating income.
Oct 6, 20263 min readBreakeven 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 readA 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 readCash 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 readCost 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 readHotel 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 readCalculate 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 readBank 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 readDebt 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 readMeasure 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 readCalculate 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 readA 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 readSeparate placed premium from agency commission and fee income. A worked example shows why premium growth can hide falling revenue.
Oct 4, 20263 min readAllocate shared producer credit with explicit shares. Reconcile credited income to agency income and keep payout rules separate.
Oct 4, 20262 min readRenewable 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 readWorking 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 readCalculate 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 readBalance 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 readAn 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 readClassify 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 readIncremental 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 readMarket 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 readOutlier 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 readCalculate 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 readWIP 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 readCompany 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 readCustomer 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 readIndustrial 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 readReconcile 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 readBuild 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 readROE 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 readCompare commission by billing method without mixing premium collections and agency income. Show timing and source differences.
Oct 2, 20262 min readCompare 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 readCompare 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 readCompare 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 readA 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 readBridge prior agency income to current income using new clients, losses, retained-account movements, fees and adjustments.
Oct 1, 20263 min readCash 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 readCredit 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 readAn 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 readAnalyze weighted commission yield by line and carrier. Distinguish changes in the business mix from changes in commission terms.
Oct 1, 20262 min readReturn 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 readReturn 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 readSaaS 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 readCalculate 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 readA 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 readAdjusted 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 readExplain differences between booked commission and cash received. Reconcile opening balances, new items, adjustments and receipts.
Sep 30, 20262 min readCash 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 readCalculate 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 readCost 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 readThe 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 readCompare 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 readMatch carrier commission statement lines to booked amounts. Keep timing, returns and unexplained differences in separate buckets.
Sep 30, 20263 min readWorking 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 readCalculate 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 readNet 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 readRecurring 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 readCompare 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 readSeparate recurring, one-off and pass-through amounts in agency fee reports. Compare fees with service demand using a worked example.
Sep 28, 20263 min readDefine agency income per FTE with matching periods and staff scope. Explain mix, outsourcing and one-off income before benchmarking.
Sep 28, 20262 min readEstimate client servicing contribution with recorded time and approved cost rates. Keep unallocated effort and omitted costs visible.
Sep 28, 20263 min readHealthcare 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 readLuxury 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 readOperating 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 readCompare 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 readAverage 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 readThe 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 readCalculate 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 readOrdering 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 readVariance 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 readWorking 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 readThe 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 readAcquisition 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 readCash 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 readCombined 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 readProject 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 readEstimate 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 readFinancial 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 readLandscaping 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 readCompare 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 readThe 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 readShareholders 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 readUnit 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 readCompare 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 readFCFF 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 readPrice 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 readA 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 readConnect 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 readThe 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 readReturn 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 readRevenue 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 readTotal 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 readCapital 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 readA 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 readOperating 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 readOperating 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 readA 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 readAverage 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 readThe 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 readThe 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 readMarkup 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 readNet 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 readNet 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 readReturn 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 readThe 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 readGross 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 readCustomer 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 readThe 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 readThe 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 readA 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 readThe 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 readCalculate 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 readCompare 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 readMeasure 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 readEmail 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 readFinancial 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 readFixed 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 readProfitability 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 readWorking 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 readCalculate 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 readSeparate 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 readDPO 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 readDSO 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 readEBITDA 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 readOperating 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 readCompare 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 readThe 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 readCompare 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 readReconcile 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 readInventory 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 readCost 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 readCustomer 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 readCustomer 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 readLabor 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 readThe 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 readBalance 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 readThe 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 readThe 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 readRetail 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 readROCE 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 readA 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 readCompare 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 readThe 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 readBreak-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 readBurn 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 readThe 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 readAn 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 readPrivate-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 readProfit 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 readWorking 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 readAccrual 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 readActivity-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 readAuto 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 readCompare 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 readWeighted 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 readCash 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 readCash 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 readDays 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 readFCF 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 readCompare 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 readChoose 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 readFull 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 readGross 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 readRevenue 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 readUnderstand 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 readUnit 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 readCash 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 readA 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 readCost 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 readEcommerce 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 readA 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 readCalculate 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 readLead 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 readCash 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 readWeighted 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 readConvert 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 readCalculate 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 readMeasure 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 readBuild 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 readWorking 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 readMeasure 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 readCompare 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 readSeparate 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 readFoodservice 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 readHR 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 readRead 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 readCash 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 readCompare 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 readThe 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 readCompare 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 readLead 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 readUnlevered 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 readBuild 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 readMeasure 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 readContribution 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 readCalculate 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 readSeparate 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 readCompare 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 readFinancial 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 readFactoring 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 readCompare 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 readThe 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 readAdjusted 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 readAdvertising 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 readCalculate 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 readCustomer 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 readLead 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 readConnect 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 readBuild 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 readDental 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 readCalculate 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 readRestaurant 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 readAdjusted 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 readThe 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 readCost 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 readLT 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 readReturn 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 readSame-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 readShort-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 readAverage 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 readFinance 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 readHealthcare 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 readMaterial 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 readClick 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 readCalculate 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 readA 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 readCalculate 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 readCalculate 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 readCalculate 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 readA 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 readReal 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 readTurnover 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 readCalculate 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 readAverage 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 readCarrying 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 readCopy 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 readRaw-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 readAdjusted 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 readBank 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 readDiscontinued 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 readCompare 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 readBank 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 readReturn 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 readThe 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 readCurrent 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 readThe 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 readAmazon 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 readCost 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 readFinancial 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 readCompare 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 readThe 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 readConvert 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 readThe 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 readCompare 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 readSales 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 readTarget 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 readThe 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 readPurchases 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 readApparel 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 readCalculate 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 readAnnualized 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 readCash 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 readManufacturing 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 readWhiskey 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 readCalculate 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 readCompare 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 readNonprofit 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 readA 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 readAccounting 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 readMeasure 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 readHospital 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 readLiquidity 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 readA 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 readA 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 readCalculate 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 readAnalyze 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 readDCF 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 readCompare 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 readA 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 readBuild 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 readThe 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 readFactoring 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 readFunds 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 readCalculate 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 readA 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 readCalculate 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 readCompare 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 readBuild 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 readMeasure 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 readProfit 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 readTelecom 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 readWorking 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 readThe 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 readFinancial 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 readAn 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 readCompare 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 readDeferred 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 readCalculate 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 readFree 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 readBuild 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 readAsset 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 readFinancial 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 readA 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 readOverhead 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 readCalculate 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 readProject 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 readCompare 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 readBuild 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 readAsset 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 readBuild 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 readCompare 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 readCalculate 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 readA 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 readAn 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 readThe 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 readProfitability 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 readQualitative 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 readCompare 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 readA 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 readThe 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 readHistorical 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 readChoose 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 readNet 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 readIndustry 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 readPretax 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 readRetail 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 readThe 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 readInvested 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 readRate 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 readUse 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 readFinancial 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 readLabor 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 readCash 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 readScrap 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 readCost 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 readDefine 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 readCompare 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 readA 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 readUCA 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 readShipping 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 readFarm 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 readA 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 readCalculate 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 readCompare 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 readCalculate 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 readWorking 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 readUse 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 readMeasure 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 readCalculate 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 readIncremental 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 readOperating 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 readProfitability 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 readAn 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 readEBITDA 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 readBridge 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 readLife 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 readRestricted 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 readSeparate 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 readDiscretionary 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 readThe 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 readReturn 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 readSeparate 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 readBank 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 readIndustry 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 readService 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 readMining 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 readBank 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 readConnect 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 readCustomer 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 readManufacturing 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 readThe 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 readReconcile 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 readCash 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 readBreak-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 readCost 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 readA 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 readOperating 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 readCash 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 readDistribution 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 readCalculate 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 readOperating 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 readFinancial 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 readCompare 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 readInterest 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 readIRR 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 readA 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 readFinance 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 readConvert 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 readCompare 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 readCompare 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 readCalculate 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 readMeasure 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 readMaximum 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 readTarget 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 readCalculate 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 readAn 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 readAverage 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 readDebt 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 readCompare 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 readAverage 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 readFinancial 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 readTelecom 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 readCalculate 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 readCompare 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 readInventory 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 readUse 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 readDecide 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 readMarketing 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 readAnnual 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 readAnalyze 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 readEstimate 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 readDebt 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 readReturn 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 readCompare 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 readIndustry 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 readReconcile 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 readLife 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 readConvert 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 readHospitality 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 readLiquidity 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 readCalculate 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 readRead 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 readQualified 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 readReturn 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 readRisk-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 readCalculate 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 readDealership 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 readIRR 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 readInterpret 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 readCompare 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 readCalculate 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 readCash 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 readMeasure 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 readHeadcount 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 readCalculate 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 readIncremental 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 readReturn 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 readFintech 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 readCompare 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 readFree 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 readCalculate 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 readCompare 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 readIdentify 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 readThe 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 readCapital 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 readDebt 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 readLevered 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 readCompare 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 readROCE 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 readCompare 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 readBank 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 readCompare 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 readFinancial 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 readSales 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 readAn 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 readRent 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 readCompare 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 readCredit 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 readProperty 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