Tools › Finance and Business

Finance and Business

15 tools in 8 sections. Each tool page shows the method with the numbers substituted, its references and the published examples it reproduces.

Finance 2

DCF Valuation Enterprise and equity value of a business by discounted cash flow: the projected unlevered free cash flows are discounted at the weighted average cost of capital, built…
Investment Appraisal (NPV, IRR, Payback) Appraisal of a capital project from its cash-flow series: net present value with a nominal or real discount rate related by the Fisher equation, every internal rate of…

Depreciation (MACRS) Depreciation schedules of a business asset by every common method: straight line, 150 % and 200 % declining balance with the switch to straight line, sum-of-years…
Financial Ratios and Statement Analysis Ratio analysis of pasted income statement, balance sheet and cash-flow lines for up to five periods: liquidity (current, quick, cash), leverage (debt to equity and to…

Economic Damages Lost earnings and related losses for a personal-injury, wrongful-death or wrongful-termination report: a year-by-year schedule from the date of injury or termination of…
Lost Profits and Business Interruption Commercial damages and insured business-interruption losses from a pasted monthly revenue and cost history.

Loan Payoff Payment, total interest and the full amortization schedule of a fixed-rate loan (mortgage, car loan, student loan or a credit-card balance paid at a fixed amount), and…
Retirement Planner Retirement savings and withdrawal plan in one currency: a deterministic projection at the expected return (balance by year, the year the money runs out or the terminal…

Break-Even and Pricing Cost-volume-profit analysis for a single product (contribution margin and its ratio, break-even units and revenue, the volume for a target operating income or an…
Job Quote Builder Cost build-up and price for a manufacturing or service job quote: material lines with a scrap allowance, labour and machine operations with setup hours amortized over…
Pricing Waterfall Transaction-price analysis after Marn and Rosiello's pocket price waterfall: a list price and the pasted leakage elements (discounts, payment terms, rebates, co-op…

Cohort Retention and CLV Customer retention by acquisition cohort and the value of a customer, for subscription and repeat-purchase businesses: paste a retention table (cohort, size, active…
Customer Metrics (NPS) Net Promoter Score, CSAT and Customer Effort Score from pasted survey responses (one respondent per line with optional segment, period and driver ratings, or a tally of…

Loss Reserving Estimates unpaid claims from a pasted run-off triangle (cumulative or incremental; accident years down, development ages across) by the chain-ladder development method…

Capacity and Throughput Capacity analysis of a production line or service process: takt time from the demand and the net available time, the effective capacity of every step from its process…