Business Arithmetic, Ratios and Indices

Introduction

Business analytics depends on the ability to translate operational information into comparable numerical measures. Sales figures, costs, prices, wages, taxes, exchange rates and inflation are often expressed in different forms. Business arithmetic provides the tools for converting, comparing and interpreting these values.

A percentage expresses a quantity relative to 100. A ratio compares quantities measured in compatible units. A rate relates a change or amount to a base over a specified period. An index number expresses the relative movement of a variable or group of variables compared with a selected base period. These ideas are mathematically elementary, but errors in their use can produce serious commercial consequences.

This chapter develops the principles needed to calculate and interpret percentages, proportions, mark-ups, margins, discounts, commissions, taxation, inflation, exchange rates and index numbers. It also considers benchmarking, data quality, ethical reporting and the use of spreadsheets and analytical software.

Learning objectives

By the end of this chapter, you should be able to:

1. Convert among fractions, decimals and percentages and apply percentage change correctly.
2. Solve direct and inverse proportion problems and distinguish rates from ratios.
3. Calculate mark-up, gross margin, discounts, commissions and taxes.
4. Apply simple and compound growth models, including inflation adjustments.
5. Convert currencies using clearly stated exchange-rate conventions.
6. Construct, interpret and evaluate simple price and quantity indices.
7. Use ratios and indices to benchmark business performance.
8. Identify common numerical, interpretive, governance and ethical errors.

1. Percentages and percentage change

A percentage is a proportion expressed per hundred. If a quantity x is part of a total T, then its percentage share is:

Here, x and T must be measured in the same units and T must not be zero. The result is a percentage, not a monetary amount.

A decimal percentage p% is converted to a decimal multiplier by dividing by 100. Thus, 7.5% = 0.075. To increase an amount A by p%, use the multiplier 1 + p/100:

To decrease A by p%, use:

These formulas assume that the percentage is applied once to the original amount. A percentage change from an initial value V₀ to a final value V₁ is:

The denominator is the initial value. A positive result indicates an increase and a negative result indicates a decrease.

Worked example 1: percentage change

A retailer’s monthly online orders increase from 2,400 to 2,760. The change is 360 orders. Therefore:

Percentage change = (360 ÷ 2,400) × 100% = 15%

Orders increased by 15%. If orders later fall from 2,760 to 2,400, the percentage decrease is 360 ÷ 2,760 × 100% ≈ 13.04%, not 15%. Percentage increases and decreases are not automatically reversible because their bases differ.

Successive percentage changes

Successive changes are applied multiplicatively, not by simply adding percentages. If a price rises by a% and then falls by b%, the final amount is:

For example, a 20% increase followed by a 20% decrease gives a multiplier of 1.20 × 0.80 = 0.96. The final amount is 96% of the original, representing a 4% decrease.

2. Proportion, ratios and rates

A ratio compares two quantities. The ratio a:b means a ÷ b, provided the quantities are compatible. Ratios can be simplified by dividing both terms by their greatest common divisor. A ratio is dimensionless only when both quantities have the same units or when units cancel.

If total quantity T is divided in the ratio a:b, the total number of parts is a + b. The first share is:

For a ratio a:b:c, the corresponding share is T × a ÷ (a + b + c), and similarly for the other components.

A rate compares quantities with different units, such as dollars per employee, units per hour or kilometres per litre. Rates should always be reported with their units. A ratio of 12:4 may be simplified to 3:1; a rate of 12 units per 4 hours is 3 units per hour.

Direct proportion means that two variables change by the same multiplicative factor. If y is directly proportional to x:

where k is a constant of proportionality. Inverse proportion means that one variable changes in the opposite direction:

These relationships should not be assumed without a plausible business rationale. For example, total variable cost may be directly proportional to units when unit cost is constant, while average cost is not necessarily constant because of fixed costs and scale effects.

Worked example 2: allocation by ratio

A marketing budget of $84,000 is allocated among digital, events and research in the ratio 5:2:1. The total number of parts is 8. The allocations are:

• Digital: $84,000 × 5/8 = $52,500
• Events: $84,000 × 2/8 = $21,000
• Research: $84,000 × 1/8 = $10,500

The allocations sum to $84,000, providing an arithmetic check.

3. Cost, selling price, mark-up and margin

Let C denote cost price and S denote selling price. Mark-up is calculated relative to cost:

Gross margin is calculated relative to selling price:

Both measures use gross profit, S − C, but different denominators. Consequently, a 25% mark-up is not a 25% margin.

If mark-up m is expressed as a decimal, then:

If desired margin g is expressed as a decimal, then:

The margin formula requires g < 1. These calculations assume that C represents the relevant cost base and that no additional selling expenses, taxes or discounts are included unless explicitly stated.

Worked example 3: mark-up and margin

A product costs $80 and sells for $100. Gross profit is $20.

Mark-up = $20 ÷ $80 × 100% = 25%

Gross margin = $20 ÷ $100 × 100% = 20%

If the business requires a 30% gross margin, the price must be:

S = $80 ÷ (1 − 0.30) = $114.2857

The practical price might be $114.29, subject to pricing policy and rounding.

4. Discounts and net prices

A trade discount is usually calculated from a list price. If list price is L and discount rate is d, the net price N is:

where d is expressed as a decimal. A sequence of discounts is multiplicative:

Thus, discounts of 10% and 5% are equivalent to a single discount of 14.5%, since 1 − (0.90 × 0.95) = 0.145. They are not equivalent to 15%.

A cash discount for early payment should be distinguished from a trade discount. The former depends on payment timing and may affect effective financing cost; the latter normally reduces the quoted selling price.

5. Commission, tax and compound growth

Commission is compensation based on a stated base. If commission rate is c and commissionable sales are R:

The base must be defined. Commission may be calculated on gross sales, net sales after returns, or gross profit. These alternatives are not interchangeable.

If a tax rate t applies to a taxable amount B:

If tax is added to a pre-tax price P, the tax-inclusive price is:

If a price Q already includes tax and the tax rate is t, the pre-tax price is:

This distinction is important: tax included in a price is not found by multiplying the tax-inclusive amount by t.

For a fixed annual growth rate r over n periods, the compound-growth model is:

V₀ is the initial value, Vₙ is the value after n periods, r is the growth rate per period expressed as a decimal, and n is the number of periods. The model assumes the same rate applies each period and that growth compounds at the end of each period.

Worked example 4: tax and commission

A salesperson generates $48,000 of eligible net sales and receives 4% commission:

Commission = 0.04 × $48,000 = $1,920

A service priced at $1,250 before a 12% tax has a tax-inclusive price of:

$1,250 × 1.12 = $1,400

The tax is $150, which is 12% of the pre-tax price, not 12% of $1,400.

6. Inflation and real values

Inflation is a sustained increase in the general price level. If a price rises at inflation rate i for n periods, its inflation-adjusted nominal value is:

To express a nominal monetary amount in base-period purchasing power, divide by the cumulative price multiplier:

If nominal growth is g and inflation is i, the exact real growth rate is:

The approximation g − i can be useful for small rates, but the exact formula is preferable for reporting and decision-making.

Worked example 5: real growth

A firm’s revenue increases by 8% while inflation is 5%. Exact real growth is:

(1.08 ÷ 1.05) − 1 = 0.028571... ≈ 2.86%

The approximate result, 8% − 5% = 3%, is close but not exact. Analysts should state whether a reported growth rate is nominal or real.

7. Exchange rates

An exchange rate expresses the value of one currency in another. The quotation convention must be stated. Suppose 1 euro = $1.10. For an amount E euros, the dollar value is:

Conversely, dollars converted to euros are divided by 1.10:

Transaction fees, bid–ask spreads and commissions may reduce the amount received. If a conversion fee f is charged as a proportion of the converted amount, the net received amount is multiplied by 1 − f. Foreign-exchange calculations should specify the date, quotation direction, fee treatment and whether the rate is an indicative or executable rate.

Worked example 6: currency conversion

An importer must pay €18,000 when the rate is €1 = $1.08. The dollar cost before fees is:

€18,000 × $1.08/€ = $19,440

If the bank charges a 0.5% conversion fee on the dollar amount, the fee is $97.20 and the total cost is $19,537.20. Ignoring the quotation convention or fee can materially distort a cost forecast.

8. Index numbers

An index number measures relative change compared with a base. The base-period index is conventionally 100. A simple price index for one item is:

P₀ is the base-period price and Pₜ is the current-period price. An index of 125 means the price is 125% of its base-period value, or 25% higher.

For several items, a simple aggregate price index is:

This treats each listed price in the same unweighted manner and may be misleading when quantities or economic importance differ.

A weighted average of price relatives is:

Iᵢ is the individual price relative expressed as an index, and wᵢ is its weight. Weights should represent a defensible basis such as expenditure share, revenue share or quantity importance. The weights must be stated and should normally be non-negative.

Two widely used quantity-weighted indices are the Laspeyres and Paasche price indices:

P₀ and Pₜ are base and current prices; Q₀ and Qₜ are base and current quantities. The Laspeyres index uses base-period quantities, while the Paasche index uses current-period quantities. The choice affects interpretation: a fixed base basket may overstate the cost of maintaining consumption when buyers substitute toward cheaper goods.

Worked example 7: a weighted index

Consider two products:

The Laspeyres numerator is (12 × 100) + (22 × 50) = $2,300. The denominator is (10 × 100) + (20 × 50) = $2,000.

Laspeyres index = $2,300 ÷ $2,000 × 100 = 115

The cost of the base basket has increased by 15%.

9. Ratios and indices for business benchmarking

Business ratios convert raw totals into interpretable indicators. Examples include:

Ratios require consistent definitions. For example, inventory turnover based on cost of sales should not be compared with a ratio based on revenue without adjustment. Average inventory may be calculated as (opening inventory + closing inventory) ÷ 2 when no better time series is available.

Benchmarking can be internal, historical, competitive or against an industry standard. A benchmark is useful only when the populations, periods, accounting policies, currencies, inflation treatment and operational definitions are comparable. A higher ratio is not always better: very high inventory turnover may indicate efficiency, but it may also indicate stock shortages.

10. Integrated case: pricing and performance review

Background

The following is an illustrative case. Meridian Office Supplies sells a printer cartridge. Its unit cost is $36, list price is $60, and business customers receive a 10% trade discount. Sales staff receive 5% commission on net sales. The applicable sales tax is 8%. Management wants to determine the effective margin and assess a proposed price change.

Problem

The company must calculate the customer’s pre-tax price, gross profit, mark-up, margin and commission. It is also considering a 6% list-price increase while expecting a 4% annual inflation rate.

Analysis

Current net selling price:

$60 × (1 − 0.10) = $54

Gross profit per unit:

$54 − $36 = $18

Mark-up on cost:

$18 ÷ $36 × 100% = 50%

Gross margin on net selling price:

$18 ÷ $54 × 100% = 33.33%

Commission per unit:

0.05 × $54 = $2.70

The customer pays sales tax of 8% on the net pre-tax price:

$54 × 1.08 = $58.32

The tax is collected from the customer and should not be treated as revenue if accounting policy records sales net of tax.

After the proposed 6% list-price increase, the list price becomes:

$60 × 1.06 = $63.60

The discounted net price becomes:

$63.60 × 0.90 = $57.24

Assuming unit cost remains $36, gross profit becomes $21.24 and margin becomes:

$21.24 ÷ $57.24 × 100% ≈ 37.11%

However, if cost rises with 4% inflation, estimated cost is $36 × 1.04 = $37.44. The inflation-adjusted gross profit is then $19.80 and margin is approximately 34.59%.

Outcome and learning points

The price increase improves nominal margin under both assumptions, but the improvement is much smaller when cost inflation is included. Management should also test demand response: a higher price may reduce volume. The case demonstrates why analysts must distinguish list price from transaction price, gross margin from mark-up, tax from revenue, and nominal changes from inflation-adjusted changes.

11. Common errors, limitations and governance

Several mistakes recur in business arithmetic:

• using the wrong denominator for a percentage;
• adding successive percentage changes instead of multiplying their factors;
• confusing mark-up with margin;
• applying tax to a tax-inclusive amount;
• reversing an exchange rate incorrectly;
• reporting an index without identifying its base period;
• comparing ratios with inconsistent definitions;
• rounding intermediate values too early;
• ignoring fees, returns, rebates or quantity changes;
• treating correlation in a benchmark as proof of causation.

Good practice includes retaining full precision during calculations, rounding only at the reporting stage, documenting assumptions, checking units, reconciling totals and performing sensitivity analysis. A spreadsheet formula should be auditable, with labelled inputs and protected calculation cells. Automated systems and AI tools can help detect anomalies and generate scenarios, but they do not remove the need to verify source data, definitions and formula logic.

Ethically, analysts should not select a favourable denominator, base period or benchmark merely to create an attractive performance narrative. Index construction and ratio reporting can influence pay, pricing, investment and public policy. Material assumptions, revisions and data limitations should therefore be disclosed. Privacy and access controls are also required when ratios are calculated from employee, customer or supplier data.

Chapter Summary

Business arithmetic supplies the basic quantitative language of commerce. Percentages measure relative shares and changes; ratios compare quantities; rates relate amounts to units; and proportions allocate totals. Mark-up is based on cost, whereas margin is based on selling price. Discounts, commissions and taxes must be applied to their correct bases, and successive changes must be compounded multiplicatively.

Compound-growth formulas support analysis of revenue, prices, inflation and other time-dependent values. Real growth separates nominal change from changes in purchasing power. Exchange-rate calculations require an explicit quotation convention and consideration of fees. Index numbers compare current values with a base period, while weighted indices provide more meaningful measures when items differ in economic importance. Ratios and indices support benchmarking, but comparisons are valid only when definitions, periods and data conditions are consistent.

Sound professional practice combines correct formulas with unit checks, transparent assumptions, sensitivity analysis, appropriate rounding and ethical disclosure.

Key Terms

Percentage: A proportion expressed per hundred.

Percentage change: Change from an initial value expressed as a percentage of that initial value.

Ratio: A comparison of two quantities.

Rate: A quantity expressed relative to another quantity, usually with units.

Proportion: An equality between two ratios or a share of a total.

Mark-up: Gross profit expressed as a percentage of cost.

Gross margin: Gross profit expressed as a percentage of selling price or revenue.

Trade discount: A reduction from a listed or quoted price.

Commission: Compensation calculated as a percentage of a defined base.

Tax-inclusive price: A price that already contains the applicable tax.

Compound growth: Growth in which each period’s change is applied to the accumulated value.

Inflation: A sustained increase in the general price level.

Real value: A value adjusted for changes in purchasing power.

Exchange rate: The value of one currency expressed in another currency.

Index number: A relative measure of change compared with a base period.

Base period: The reference period assigned an index value, commonly 100.

Laspeyres index: A price index using base-period quantities as weights.

Paasche index: A price index using current-period quantities as weights.

Benchmark: A reference value used to evaluate performance.

Sensitivity analysis: Examination of how results change when assumptions change.

Review Questions

Short Answer Questions

1. Why is the denominator important when calculating a percentage change?
2. Distinguish between a mark-up and a gross margin.
3. What is the difference between a ratio and a rate?
4. Why are successive discounts multiplied rather than added?
5. What does an index value of 125 mean when the base period equals 100?

Long Answer Questions

1. Explain the uses and limitations of percentages, ratios and rates in business analysis. Include examples of inappropriate comparisons.
2. Derive the selling-price formula required to achieve a specified gross margin and explain its assumptions.
3. Compare nominal growth and real growth, using inflation to show why the distinction matters.
4. Explain the construction and interpretation of Laspeyres and Paasche price indices.
5. Discuss the governance and ethical responsibilities involved in selecting benchmarks and reporting business ratios.

Analytical / Application Questions

1. A product costs $72. It is listed at a price that allows a 40% mark-up, then sold after a 15% discount. Calculate the transaction price and the resulting margin on that transaction price.
2. A company’s revenue rises from $2.4 million to $2.7 million while prices rise by 6%. Calculate nominal revenue growth and estimate real revenue growth using the exact formula. Interpret the result.
3. An importer must pay £25,000 at an exchange rate of £1 = $1.26. A 0.75% fee is charged on the dollar conversion. Calculate the total dollar cost and identify two assumptions that should be verified before recording the forecast.

Multiple Choice Questions with Answers

Question 1

A product costs $80 and sells for $100. What is the gross margin?

A. 20%

B. 25%

C. 80%

D. 125%

Correct Answer: A. 20%

Question 2

A price of $500 is increased by 8%. What is the new price?

A. $508

B. $540

C. $550

D. $580

Correct Answer: B. $540

Question 3

A budget of $60,000 is divided in the ratio 2:3. What is the larger share?

A. $24,000

B. $30,000

C. $36,000

D. $40,000

Correct Answer: C. $36,000

Question 4

A list price of $200 receives successive discounts of 10% and 5%. What is the net price?

A. $170

B. $171

C. $175

D. $180

Correct Answer: B. $171

Question 5

A tax-inclusive price is $108 and the tax rate is 8%. What is the pre-tax price?

A. $99.36

B. $100

C. $100.08

D. $116.64

Correct Answer: B. $100

Question 6

If revenue grows by 10% and inflation is 4%, what is the exact real growth rate?

A. 4.00%

B. 5.77%

C. 6.00%

D. 14.00%

Correct Answer: B. 5.77%

Question 7

If 1 euro equals $1.20, how many dollars are needed for €2,500 before fees?

A. $2,083.33

B. $2,500

C. $3,000

D. $3,700

Correct Answer: C. $3,000

Question 8

An index rises from 100 to 115. What does this indicate?

A. A 15% decrease

B. A 15% increase from the base period

C. A 115% increase

D. No change in price

Correct Answer: B. A 15% increase from the base period

Question 9

Which denominator is used for a mark-up percentage?

A. Selling price

B. Revenue after tax

C. Cost price

D. Gross profit

Correct Answer: C. Cost price

Question 10

Which quantity weights a Laspeyres price index?

A. Current-period quantities

B. Base-period quantities

C. Average quantities only

D. No quantities

Correct Answer: B. Base-period quantities