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.
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.
| Reading | What it compares | Formula | When to use it |
|---|---|---|---|
| Vertical analysis | Each line against a base from the same period | Line divided by revenue (or total assets) x 100 | To see the structure of costs, expenses and funding |
| Horizontal analysis against prior period | The same line in two consecutive periods | (Current minus prior) divided by prior | To measure the change of each year or quarter |
| Horizontal analysis against a base year | The same line against a fixed period set at index 100 | Current divided by base x 100 | To see cumulative change across a long series |
| Price, volume and exchange-rate split | A line's change in reporting currency by cause | Volume effect + price effect + exchange-rate effect | When revenue or costs are in a currency other than the reporting one |
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:
- The volume effect is the change in units, valued at base price and base exchange rate.
- The price effect is the change in local price, valued at current volume and base exchange rate.
- 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.
| Effect | Calculation (assumptions) | USD | Share of Year 1 revenue |
|---|---|---|---|
| Volume | 40 contracts x COP 10,000,000 / 4,000 | +100,000 | +10.0% |
| Price | 440 contracts x COP 500,000 / 4,000 | +55,000 | +5.5% |
| Exchange rate | COP 4,620 million / 4,200 minus / 4,000 | -55,000 | -5.5% |
| Total change in revenue | 1,100,000 minus 1,000,000 | +100,000 | +10.0% |
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