Retail Business Plan Financial Projections Review

When preparing and reviewing financial projections for a retail business plan a useful technique is to analyse the financial statements of a similar business in the retail industry.

By reviewing a set of financial statements it is possible to check whether the assumptions used in the projection are appropriate, and whether the ratios generated are in line with actual results in the industry.

Key Characteristics of a Retail Business

Generally the financial projections of all businesses follow a similar format and are based on a set of key assumptions. These assumptions will vary depending on the type of business involved, and those for a retail business plan or online retail business plan will need to reflect the particular nature of that industry.

Although not a definitive list, some of the more important points to consider when reviewing the financial projections of a retail business are as follows.

Inventory

A retailer purchases finished products from a supplier (manufacturer, distributor, wholesaler) and sells them direct to consumers and therefore might need to hold significant amounts of inventory. The level of inventory held will obviously depend among other things on the type of retailer, the variety of products sold, and on supplier lead times. In a retail business plan the level of inventory is reflected by the inventory days assumption.

Sales

Sales in a retail business are usually made direct to consumers rather than to other businesses. As such sales tend to be made on cash terms rather than extended credit terms resulting in low accounts receivable days.

Purchases

Purchases are usually significant and on credit terms from suppliers often with long lead times, resulting in higher accounts payable days.

Gross Margin

Generally gross margins in a retail business plan tend be between 25% and 45% (after deducting occupancy costs), but there can be significant variations depending on the type of products sold.

Which Financial Statements to Use

Ideally the financial statements used will be of a similar size to that anticipated by the financial projections, however this is not always possible in which case publicly available information for larger retail businesses can be used as a starting point.

Example financial statements are available from a number of sources, including the investor pages of the company’s website or from sources such as Edgar in the US, or Companies House in the UK.

Example Retail Business Plan Review

In order to demonstrate how to estimate the key assumptions to be used in the financial projections of a startup retail business plan, the financial statements of GAP Inc. a leading global clothing retailer, are used in the calculations below.

A copy of the GAP Inc. 2015 financial statements can be downloaded here.

Assumptions Calculations

In the financial projections template the key assumptions used are as follows.

  • Gross margin %
  • Depreciation rate
  • Finance costs %
  • Income tax rate
  • Accounts receivable days
  • Inventory days
  • Accounts payable days
  • Other liability days

The majority of the information used below is obtained from the balance sheet (page 34), income statement (page 35), and cash flow statement (page 38) of the GAP Inc. financial statements, and for ease of use, these three main statements are available for download here.

In the calculations references to the financial statements are shown in brackets as follows.

  1. Balance sheet statement (B)
  2. Income statement (I)
  3. Cash flow statement (C)

Gross margin %

Gross margin % = Gross profit (I) / Net sales (I)
Gross margin % = 5,720 / 15,797
Gross margin % = 36.2%

It should be noted that in this example occupancy costs are deducted in arriving at gross margin.

Depreciation rate

To give an indication of the depreciation rate, it is useful to calculate the depreciation as a percentage of the net book value of long term assets.

Depreciation rate = Depreciation (C) / Property, Plant and Equipment (B)
Depreciation rate = (592-65) / 2,850 = 18.5%

Full details of the depreciation rates used can be found on page 40 of the financial statements.

Finance Costs %

Finance costs % = Interest expense (I) / Debts (B)
Finance costs % = 59 / (421 + 1,310) = 3.4%

Income tax rate

Income tax rate = Income tax (I) / Income before tax (I)
Income tax rate = 551 / 1,471 = 37.5% 

Accounts Receivable Days

Accounts receivable days = Accounts receivable (B)  x 365 / Revenue (I)
Accounts receivable days = 282 x 365 / 15,797
Accounts receivable days = 7 days
*Accounts receivable (282) is shown in the note on page 47 of the financial statements

Inventory Days

Inventory days = Inventory (B) x 365 / Cost of sales (I)
Inventory days = 1,873  x 365 / 10,077
Inventory days = 68 days

Accounts Payable Days

Accounts payable days = Accounts payable (B) x 365 / Cost of sales (I)
Accounts payable days = 1,112 x 365 / 10,077
Accounts payable days = 40 days

Other Liabilities Days

Other liabilities days = Other liabilities x 365 / (Operating expenses - Depreciation + Finance costs + Income tax)
Other liabilities days = 1,002 x 365 / 4,273
Other liabilities days = 86 days
*Other liabilities = 979 + 23 = 1,002 (B)
*Expenses = 4,196 - (592-65) + (59-6) + 551 = 4,273 (I and C)

The values from this retail business should now be compared with the assumptions used in the financial projections template and adjustments made as appropriate.

Ratios Calculations

In a similar manner the financial statements of GAP Inc. can be used to calculate ratios for comparison with those generated by the financial projections template.

The main ratios generated in the template are as follows.

  • Profitability (Net income / Revenue)
  • Efficiency (Revenue / Assets)
  • Leverage (Assets / Equity)
  • Return on assets (ROA)
  • Return on equity (ROE)
  • Liquidity (Current assets / Current liabilities)

Using information from the financial statements an estimate of each ratio can be calculated as follows.

Profitability

Profitability =  Net income (I) / Net sales (I)
Profitability =  920 / 15,797 = 5.8%

Efficiency

Efficiency = Net sales (I) / Assets (B)
Efficiency = 15,797 / 7,473 = 2.11

Leverage

Leverage = Assets (B) / Equity (B)
Leverage = 7,473 / 2,545 = 2.94

Return on assets (ROA)

Return on assets = Net income (I) / Assets (B)
Return on assets = 920 / 7,473 = 12.3%

Return on equity (ROE)

Return on equity = Net income (I) / Equity (B)
Return on equity = 920 / 2,545 = 36.1%

Liquidity

Liquidity = Current assets (B) / Current liabilities (B)
Liquidity = 3,985 / 2,535 = 1.57

The next step is to see how these ratios compare to those generated by the financial projections for your business.

Summary

In summary, using the financial statements of an appropriate business in the same industry assumptions and ratios can be calculated using primarily information from the balance sheet, income statement, and cash flow statement.

In the example above, the financial statements of GAP inc. 2015 were used to represent a retail business revealing the following assumption and ratio values.

Assumptions
Gross margin %36.2%
Depreciation rate18.5%
Finance costs %3.4%
Income tax rate37.5%
Accounts receivable days7 days
Inventory days68 days
Accounts payable days40 days
Other liability days86 days
Ratios
Profitability5.8%
Efficiency2.11
Leverage2.94
Return on assets12.3%
Return on equity36.1%
Liquidity1.57

Obviously the assumptions and ratios calculated from the financial statements of one business are not going to be the same as those of another business; even one in the same industry. Despite this, it is a worthwhile exercise to find a set of financial statements similar to your proposed retail business and, together with other information from trade statistics and benchmark reports, use these as the starting point for producing a set of financial projections for a startup retail business plan.

Last modified September 24th, 2019 by Michael Brown

About the Author

Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.

You May Also Like