Definitions:

• Operating Margin = Operating Profit / Sales
• Inventory Days = Inventory / (Cost of Sales / 365 or 366)
• Receivables Days = Receivables / (Sales / 365 or 366)
• Payables Days = Payables / (Cost of Sales / 365 or 366)

(24 correct figures at 0.5 marks each = 12 marks)

Comments:

• Sales & Profitability: Sales have been relatively flat for the first three years, with a forecasted 5% decline in 2020. Operating margins have declined steadily from 33% in 2017 to 25% in 2020. This indicates a drop in efficiency and profitability.
• Cash Flow & Liquidity: Cash balances have grown, showing strong liquidity. However, cash flow may be needed for future investments and lease renewal.
• Working Capital Management: Inventory days have been rising, indicating that stock is moving slower than before. Receivables days are stable but may indicate slow collection periods. Payables days are static, indicating no improvement in payment terms with suppliers.
• Gearing Covenant: The company breached the gearing covenant in 2017 but has since complied in the subsequent years. This may have required renegotiation with the bank.
• Key Risks & Future Considerations: The business faces risks regarding the expiring lease and the need for further investments, possibly impacting future profitability.

Appraisal Summary:

• The company has managed to maintain profitability, though sales are declining. Profit margins are shrinking, which may indicate competitive pressures. Inventory management is a concern as inventory days are increasing. Additionally, cash reserves will likely be called upon for investments or lease renewals.

(0.5 marks each for max 8 points = 4 marks)

Key Observations:

• The business is profitable but faces future financial risks due to declining sales and profitability.
• Inventory management is inefficient, and the company needs to address its slowing stock movement.
• The upcoming lease renewal presents a financial challenge that will require careful cash flow management.