Treasury & FX

Vertical and horizontal analysis: how to read a company's trend when exchange rates move

Vertical and horizontal analysis of a company whose books are in local currency but whose reports are in dollars is reliable only if each change is split into volume, price and exchange-rate effects.

Erika Sandoval
Erika Sandoval11 min read
Share
Treasury

A dollar-denominated income statement can show revenue up 10% and still hide a business that did not grow. When a Latin American subsidiary earns pesos and reports to its parent in US dollars, every line is translated at a rate that moves from one period to the next. Part of what looks like growth, or like margin gain, comes from the translation and not from selling more or charging more. Reading the trend without separating that effect leads to decisions on pricing, costs and hedging based on a contaminated figure.

At Soulbit Academy we close the financial-statement series of the CFO Kit with this article. The balance sheet with dollar assets and liabilities, the income statement in two currencies and financial ratios with dollar balances cover each statement and indicator. Here we cover something different: how to read vertical percentages, horizontal changes and the base year, and how to split a change into volume, price and exchange rate. Soulbit does not replace the accountant or the auditor.

Vertical and horizontal analysis: what each one measures and when to use it

Vertical analysis measures the structure of a financial statement in a single period, and horizontal analysis measures how each line changes between periods. The vertical answers how much each line weighs against a base; the horizontal answers how much it grew or fell. They work together, because a structure percentage without its trend does not say whether the problem is new.

Both rely on figures the accountant has already produced. IAS 1 requires comparative information for the prior period, and that comparison is the raw material of horizontal analysis. In Mexico, NIF B-15 addresses foreign-currency translation. In Colombia, Decree 2420 sets different frameworks by company group. Confirm the applicable framework with your accountant.

The table below compares the four readings you will use on a multi-currency series.

ReadingWhat it comparesFormulaWhen to use it
Vertical analysisEach line against a base from the same periodLine divided by revenue (or total assets) x 100To see the structure of costs, expenses and funding
Horizontal analysis against prior periodThe same line in two consecutive periods(Current minus prior) divided by priorTo measure the change of each year or quarter
Horizontal analysis against a base yearThe same line against a fixed period set at index 100Current divided by base x 100To see cumulative change across a long series
Price, volume and exchange-rate splitA line's change in reporting currency by causeVolume effect + price effect + exchange-rate effectWhen revenue or costs are in a currency other than the reporting one
Table 1. The four readings of a company's trend: vertical, horizontal against prior period, horizontal against base year, and the exchange-rate split.

Vertical analysis: how to read percentages of revenue or total assets

Vertical analysis divides each line by a single base from the same statement and expresses it as a percentage. On the income statement the base is revenue, so each line reads as a share of every dollar sold. On the balance sheet the base is total assets, and liabilities plus equity add up to the same 100%.

Two rules guide the reading. The first is to use one base per statement. The second is to compare percentages between periods and not only amounts, because a growing company changes the size of everything. A cost of services of 62% means that out of every 100 dollars of revenue, 38 remain to cover expenses, interest and taxes.

In a multi-currency company vertical analysis has a strength and a limit. The strength is that it neutralizes size. The limit appears when revenue and costs are denominated in different currencies: the exchange rate then moves numerator and denominator differently, and the percentage changes even if operations are identical.

Which vertical percentage should a CFO watch first?

A CFO should watch cost of sales and operating profit as a percentage of revenue first, because they summarize how much of each dollar sold reaches the result. If the cost share rises, the cause is price, mix or direct cost, and in a multi-currency company also the exchange rate. Liquidity and leverage ratios follow their own logic and are covered in the ratios article.

Horizontal analysis: absolute change, relative change and base year

Horizontal analysis computes, for each line, how much it changed between two periods and how large that change is against the starting figure. Absolute change is the current figure minus the base, in currency units. Relative change is that difference divided by the base, as a percentage. Read them together: a change of USD 50,000 weighs heavily on a line of 100,000 and little on one of 10,000,000.

The choice of base decides what you see. With the prior period as base you measure each year's change. With a fixed base year set at index 100 you measure cumulative change. Take assumed revenue of USD 800,000 in Year 0, USD 1,000,000 in Year 1 and USD 1,100,000 in Year 2. Against the prior period, Year 1 grows 25.0% and Year 2 grows 10.0%. Against Year 0 as base 100, the indices are 125.0 and 137.5.

The base year must be representative. A year with an extreme exchange rate, an atypical close or an accounting policy change contaminates every later index, and if the company restated figures or changed its functional currency the comparison needs homogeneous numbers.

Is a high horizontal change always good news?

A high horizontal change is not good news by itself, because it depends on what caused it. A 10% revenue increase can be volume, price or translation, and only the first two come from operations; the exchange-rate effect can reverse.

Worked example: vertical and horizontal analysis of a services company that reports in dollars

A Colombian services company illustrates how translation affects both analyses. Every figure below is an assumption, not market data and not a Soulbit price. The company invoices and pays in Colombian pesos, has the peso as functional currency and reports in US dollars to its foreign parent.

In Year 1 it bills 400 contracts at COP 10,000,000, which is COP 4,000 million, translated at 4,000 pesos per dollar: USD 1,000,000. In Year 2 it bills 440 contracts at COP 10,500,000, which is COP 4,620 million, translated at 4,200: USD 1,100,000. Costs are in pesos: cost of services COP 2,480 million in Year 1 and COP 2,800 million in Year 2; operating expenses COP 1,000 million and COP 1,050 million.

The summarized income statement, in dollars, reads as follows.

  • Year 1: revenue 1,000,000 (100%); cost of services 620,000 (62.0%); gross profit 380,000 (38.0%); operating expenses 250,000 (25.0%); operating profit 130,000 (13.0%).
  • Year 2: revenue 1,100,000 (100%); cost of services 666,667 (60.6%); gross profit 433,333 (39.4%); operating expenses 250,000 (22.7%); operating profit 183,333 (16.7%).

Horizontal analysis gives these relative changes in dollars: revenue +10.0%, cost of services +7.5%, gross profit +14.0%, operating expenses 0.0% and operating profit +41.0%. In pesos the same operating profit moves from COP 520 million to COP 770 million, a gain of 48.1%. The dollar report understates the operational gain because the weaker peso translates it into fewer dollars, while the operating expenses appear flat in dollars despite rising in pesos.

How to separate price, volume and exchange-rate effects in the horizontal change

Separating the three effects means splitting the total change in revenue, in reporting currency, into the part explained by units sold, by unit price in local currency and by the translation rate. The three effects add up exactly to the total change, so no residual is left unexplained.

The order of calculation matters, because the effects cross. One useful convention for this example is:

  1. The volume effect is the change in units, valued at base price and base exchange rate.
  2. The price effect is the change in local price, valued at current volume and base exchange rate.
  3. The exchange-rate effect is the change in rate, applied to the current local-currency amount.

With the example figures: volume is 40 extra contracts x COP 10,000,000 divided by 4,000, equal to USD 100,000. Price is 440 contracts x COP 500,000 increase divided by 4,000, equal to USD 55,000. Exchange rate is COP 4,620 million divided by 4,200, minus the same amount divided by 4,000, equal to minus USD 55,000.

EffectCalculation (assumptions)USDShare of Year 1 revenue
Volume40 contracts x COP 10,000,000 / 4,000+100,000+10.0%
Price440 contracts x COP 500,000 / 4,000+55,000+5.5%
Exchange rateCOP 4,620 million / 4,200 minus / 4,000-55,000-5.5%
Total change in revenue1,100,000 minus 1,000,000+100,000+10.0%
Table 2. Split of the horizontal change in dollar revenue into volume, price and exchange rate (all figures are assumptions).

The reading changes the decision. Reported revenue grew 10.0%, but operations contributed 15.5 points and translation subtracted 5.5. Price was not an anonymous gain: it was cancelled out by the peso. At the constant rate of 4,000, Year 2 revenue would have been USD 1,155,000. This is a management measure, not an audited figure, and if it is shared outside the company its calculation should be explained.

Common mistakes when comparing periods with different exchange rates

There are three frequent mistakes. The first is comparing figures translated at different rates without saying so. The second is choosing an atypical base year. The third is presenting as operating merit a change that is translation.

To avoid them, document three decisions before each analysis. First, which rate translated each period: IAS 21 requires translating income and expenses at the rate on the transaction date and allows an average rate as an approximation when rates do not fluctuate significantly. Second, which currency is functional; the article on IAS 21 and NIF B-15 details it. Third, which reference rate is used for the constant-rate comparison, for example the budget rate, as in the article on the 2027 budget FX assumption.

Should every comparison use a constant exchange rate?

Not every comparison should use a constant rate: translation changes reported dollar figures but does not necessarily change local-currency cash flows. The constant-rate view evaluates operating performance and the reported view shows what happened to profit. Present both and the bridge between them.

What Soulbit delivers today and what remains the accountant's job

Soulbit V1 delivers company balances in stablecoins (USDC and USDT) and fiat (USD, EUR and GBP), conversion by eOTC quote on request, institutional custody, payment links, collection QR codes and recurring or batch payroll. The local bank rail exists only in Colombia; in Mexico and Brazil Soulbit offers no exit to local currency. The company must reconcile its balances and transactions against its own accounting records.

For evidence on each receipt or payment, see payment traceability for the accounting close. The exchange-rate analysis also requires the company’s accounting records and policy.

What Soulbit does not do: it does not prepare financial statements, compute vertical or horizontal analyses, split variances or define accounting policy. V1 has no accounting reports or analysis dashboards. Classification, base-year choice and presentation belong to the accountant and the CFO.

Frequently asked questions

What is vertical and horizontal analysis of financial statements?

Vertical analysis expresses each line of a financial statement as a percentage of a base from the same period, such as revenue or total assets. Horizontal analysis compares the same line across periods using absolute and relative change. The first describes structure and the second describes trend.

How do you calculate absolute and relative change in horizontal analysis?

Absolute change is the current-period figure minus the base-period figure. Relative change divides that difference by the base figure and expresses it as a percentage. If revenue moves from USD 1,000,000 to USD 1,100,000, the absolute change is USD 100,000 and the relative change is 10.0%.

What base is used for vertical analysis of the balance sheet and the income statement?

On the balance sheet the usual base is total assets, and liabilities and equity are expressed against that same total. On the income statement the usual base is revenue. Every line of one statement is measured against a single base so the percentages stay comparable.

How does a Latin American company reporting in dollars separate the exchange-rate effect?

A company with local-currency revenue translated into US dollars computes three effects: volume at base price and base rate, price on current volume at the base rate, and translation on the current local-currency amount. The three add up to the total change in dollars. It is a management measure, and the order of calculation should be documented.

What is a base year and how does it change horizontal analysis?

A base year is the period against which all others are compared, and it is assigned an index of 100. A fixed base year shows cumulative change, while comparing with the prior period shows the change of each year. An unrepresentative base year, for example one with an extreme exchange rate, distorts the whole series.

Want your company to add stablecoins to its operations?

Join the Soulbit waitlist and start paying payroll, collecting and managing treasury without SWIFT.

Join the waitlist

Related articles

Treasury

Break Even Point and Exchange Rates: How Currency Shifts the Threshold

The break even point is the sales level where profit is zero. This guide gives the formula in units and in sales, the margin of safety, and how exchange rates move it when costs are in one currency and revenue in another.

11 min read
Break Even Point and Exchange Rates: How Currency Shifts the Threshold
Treasury

Income Statement for Companies Operating in Two Currencies: How to Read It

When a LATAM subsidiary bills in dollars and pays costs in local currency, its income statement mixes operating performance with exchange effects. This guide reads it line by line and separates the two with a worked example.

11 min read
Income Statement for Companies Operating in Two Currencies: How to Read It