Tutorials › VEE Accounting and Finance › Solving Backward From a Reported Ratio

VEE Accounting and Finance · Ratio Analysis Foundations · Tutorial 213 of 996

Solving Backward From a Reported Ratio

Rearrange ratio definitions to recover unknown amounts and check each result against the reported ratio.

Beginner 9 min read

What You'll Learn

  • Rearrange a ratio to solve for its numerator, denominator, or a related statement amount.
  • Convert a reported percentage or multiple into the form needed for calculation.
  • Keep units, reporting periods, and balance-sheet averages consistent.
  • Use a substitution check to test whether a recovered amount fits the original ratio.
  • Recognize common errors involving percentage conversion and ratio definitions.

Why Solve a Ratio Backward?

A financial ratio is usually calculated from statement amounts, but analysis often starts with a ratio that has already been reported. A reader may know a company’s current ratio and current liabilities but not current assets, or know a profit margin and sales but need to recover a profit amount. The task is to reverse the ratio’s definition without changing what the ratio measures.

The key is to write the precise relationship first. A ratio may be reported as a percentage, a multiple, or another scaled measure, and similar names can refer to different definitions. Use the definition specified in the question or reporting context; do not substitute a different version merely because it is familiar.

Definition: If a ratio is defined as \(R=N/D\), where \(N\) is its numerator and \(D\) is its denominator, then, provided the ratio is defined, \(N=RD\) and \(D=N/R\) when \(R\ne 0\). If an unknown statement amount is part of \(N\) or \(D\), first recover the relevant numerator or denominator, then use the statement relationship to isolate that amount.

These rearrangements are algebra, but a correct algebraic result is not automatically a correct financial answer. A reported 25% must be used as 0.25 in a ratio equation, while a reported 2.5 times is used as 2.5. Monetary amounts should be in the same currency and scale, and a flow measured over a period should be matched with the appropriate statement period or balance measure.

A Reliable Rearrangement Method

Before solving, write down the ratio definition, identify which quantity is unknown, and state the reported ratio in decimal or multiple form. Then isolate the unknown and keep its units visible. If the unknown is a component of a line item, use the relevant accounting identity only after recovering the line item itself.

1
State the definition.
Write the specified numerator divided by the specified denominator. Identify whether the reported figure is a percentage, multiple, or other scale.
2
Convert and align.
For a percentage, divide by 100 before using it as a decimal. Put monetary amounts in consistent units, and match the relevant reporting period and balance convention.
3
Rearrange and solve.
Multiply or divide as indicated by the definition. If the requested amount is a component, use the statement total and known components to isolate it.
4
Substitute back.
Put the recovered amount into the original ratio definition. Confirm that it reproduces the reported ratio and that the units and statement relationships make sense.

The algebra behind the method is direct. Starting from \(R=N/D\), multiply both sides by \(D\). This gives \(RD=N\), so the numerator is recovered by multiplying the ratio by the denominator. If instead \(N\) and \(R\) are known and \(R\ne0\), divide \(N=RD\) by \(R\) to obtain \(D=N/R\). Each operation preserves equality under the stated conditions, which is why the rearranged equations work.

$$ R=\frac{N}{D} \quad\Longrightarrow\quad N=RD \qquad\text{and}\qquad D=\frac{N}{R}\quad(R\ne 0). $$

For a reported percentage \(p\%\), the ratio used in these equations is \(R=p/100\). For example, 18% means \(R=0.18\), not 18. The substitution check is especially useful when the answer is an amount derived through more than one step: it can reveal a misplaced decimal, an arithmetic slip, or a mismatch between the ratio definition and the statement items.

Recovering Statement Amounts

The following examples use conventional definitions stated explicitly in each problem. All amounts are hypothetical. Unless specified otherwise, the reported ratios are treated as exact for the calculation; real published ratios may be rounded, in which case a recovered amount is an estimate rather than an exact figure.

Worked Example: Recovering Inventory From the Current Ratio

A hypothetical insurer reports a current ratio of 1.80. At the reporting date, current liabilities are $250,000, cash is $70,000, and receivables are $110,000. Under the definition current ratio = current assets / current liabilities, recover inventory. Assume current assets consist of cash, receivables, and inventory for this problem.

Method. First recover current assets from the ratio, then subtract the known components. This avoids treating the reported ratio as though it directly described inventory.

The ratio is 1.80 times, so it is used as 1.80. Let \(CA\) denote current assets and \(CL\) current liabilities:

$$ 1.80=\frac{CA}{250{,}000} \quad\Longrightarrow\quad CA=1.80(250{,}000)=450{,}000. $$

Current assets equal cash plus receivables plus inventory. Let inventory be \(I\):

$$ 450{,}000=70{,}000+110{,}000+I \quad\Longrightarrow\quad I=450{,}000-180{,}000=270{,}000. $$

Check. The reconstructed current assets are \(70{,}000+110{,}000+270{,}000=450{,}000\). Substitution gives \(450{,}000/250{,}000=1.80\), the reported current ratio. Inventory is $270,000.

Common mistake avoided. Subtracting cash and receivables directly from 1.80 mixes a dimensionless ratio with dollar amounts. Recover the dollar-valued total first; only then subtract dollar-valued components.

Worked Example: Recovering Cost of Goods Sold From Gross Margin

A hypothetical equipment distributor reports net sales of $1,250,000 and a gross profit margin of 32%. For this problem, gross profit margin = gross profit / net sales, and gross profit = net sales − cost of goods sold. Recover cost of goods sold.

Method. Convert the percentage to a decimal, calculate gross profit, and use the stated income-statement relationship to find cost of goods sold.

The ratio is \(32/100=0.32\). Let \(GP\) be gross profit:

$$ 0.32=\frac{GP}{1{,}250{,}000} \quad\Longrightarrow\quad GP=0.32(1{,}250{,}000)=400{,}000. $$

Now use gross profit = net sales − cost of goods sold. Let \(COGS\) denote cost of goods sold:

$$ 400{,}000=1{,}250{,}000-COGS \quad\Longrightarrow\quad COGS=1{,}250{,}000-400{,}000=850{,}000. $$

Check. Gross profit reconstructed from the result is \(1{,}250{,}000-850{,}000=400{,}000\). Its margin is \(400{,}000/1{,}250{,}000=0.32=32\%\). Cost of goods sold is $850,000.

Common mistake avoided. Using 32 instead of 0.32 would give \(GP=32(1{,}250{,}000)=40{,}000{,}000\), which is far larger than sales and fails the check. A percentage must be converted to a decimal before multiplying by the statement amount.

Worked Example: Recovering an Ending Balance From Asset Turnover

A hypothetical manufacturer has annual net sales of $3,600,000 and reports total asset turnover of 2.40 times, defined here as net sales / average total assets. Total assets were $1,300,000 at the beginning of the year. Recover total assets at year-end. Assume average total assets are the arithmetic mean of beginning and ending total assets.

Method. First rearrange the turnover definition to recover average total assets. Then use the stated average-balance relationship to solve for the ending balance.

Let \(AA\) denote average total assets. The reported ratio is a multiple, so it is used as 2.40:

$$ 2.40=\frac{3{,}600{,}000}{AA} \quad\Longrightarrow\quad AA=\frac{3{,}600{,}000}{2.40}=1{,}500{,}000. $$

Let \(E\) denote ending total assets. Under the assumption in the problem:

$$ 1{,}500{,}000=\frac{1{,}300{,}000+E}{2}. $$

Multiply both sides by 2 to get \(3{,}000{,}000=1{,}300{,}000+E\). Therefore \(E=3{,}000{,}000-1{,}300{,}000=1{,}700{,}000\).

Check. The average of the beginning and ending balances is \((1{,}300{,}000+1{,}700{,}000)/2=1{,}500{,}000\). Then \(3{,}600{,}000/1{,}500{,}000=2.40\) times. Ending total assets are $1,700,000.

Common mistake avoided. Dividing sales by the turnover ratio recovers average total assets, not the ending balance. The beginning balance and the stated averaging convention are needed for the final step.

What the Check Can and Cannot Establish

Substitution confirms that the calculated amount satisfies the ratio definition and the other relationships used in the calculation. It does not establish that the underlying reported ratio was calculated correctly, that the source statement data are accurate, or that a chosen ratio definition is appropriate for every company. Those questions depend on the definition and source information available.

A reported figure may also be rounded. If a company reports a ratio to two decimal places, the unrounded ratio could differ slightly from the displayed figure. Rearranging the displayed value then yields an amount consistent with that displayed value, but not necessarily the exact amount behind it. Follow the precision requested in the problem and avoid implying more accuracy than the inputs support.

When the ratio uses a percentage, keep the percentage conversion visible. When it uses a multiple, do not divide or multiply by 100. When a recovered numerator or denominator is a statement subtotal, check whether the question asks for the subtotal itself or a component within it. Finally, retain units through the calculation: a ratio is dimensionless, while a recovered statement amount is in dollars, thousands of dollars, or another stated unit.

Key takeaway: Begin with the exact ratio definition, convert its reported scale correctly, and solve one relationship at a time. Substituting the answer back into the original definition is the simplest way to catch many backward-solving errors.

Check Your Understanding

For each problem, write the ratio definition before solving. Treat each stated ratio as exact and check that your recovered amount fits the supplied statement relationships.

  1. A hypothetical retailer has a current ratio of 1.75 and current liabilities of $160,000. Current assets consist of cash of $55,000, receivables of $90,000, and inventory. Using current ratio = current assets / current liabilities, recover inventory. (Answer: $135,000)
  2. A hypothetical parts supplier reports net sales of $840,000 and a gross profit margin of 28%, defined as gross profit / net sales. Using gross profit = net sales − cost of goods sold, recover cost of goods sold. (Answer: $604,800)
  3. A hypothetical firm reports total debt of $1,560,000 and a debt-to-equity ratio of 0.65, defined as total debt / total equity. Recover total equity. (Answer: $2,400,000)
  4. A hypothetical service company has annual net credit sales of $4,800,000 and receivables turnover of 8.0 times, defined as net credit sales / average accounts receivable. Beginning accounts receivable is $520,000, and average accounts receivable is the arithmetic mean of beginning and ending balances. Recover ending accounts receivable. (Answer: $680,000)
  5. A hypothetical firm reports a current ratio of 2.10 and current liabilities of $400,000. Its current assets consist of cash of $190,000, receivables of $310,000, and inventory. Using current ratio = current assets / current liabilities, recover inventory and verify the ratio. (Answer: $340,000; current assets are $840,000 and $840,000 / $400,000 = 2.10)
Clinical Biostats