Working Capital & Funding Analysis
Analyse current working capital, projected requirements and the potential funding requirement.
Current Working Capital Position
Current working capital
€0
Stock + Debtors - Creditors
Turnover
€0
Current annual turnover
Working capital / sales
0.0%
Cash tied up relative to sales
Cash tied up
€0
Net operating working capital
| Balance |
Current |
% of turnover |
| Stock |
€0 |
0.0% |
| Debtors |
€0 |
0.0% |
| Creditors |
€0 |
0.0% |
| Net working capital |
€0 |
0.0% |
Projection Assumptions
Projected stock, debtor and creditor days initially mirror the current position.
Changing an opening balance-sheet assumption updates these projected days.
You can then manually change the projected days to model an efficiency scenario.
Projected Working Capital
Projected turnover
€0
0.0% growth
Projected working capital
€0
Required operating working capital
Incremental funding
€0
Projected WC less current WC
Indicative facility
€0
Including funding headroom
Current vs Projected
| Item |
Current |
Projected |
Change |
| Stock |
€0 |
€0 |
€0 |
| Debtors |
€0 |
€0 |
€0 |
| Creditors |
€0 |
€0 |
€0 |
| Working capital |
€0 |
€0 |
€0 |
Funding Requirement
Growth effect
€0
Funding required from turnover growth
Efficiency effect
€0
Impact of changing working-capital days
Total funding
€0
Net incremental requirement
Facility requirement
€0
Including headroom
Scenario Analysis
Base
Growth
0%
CCC
0 days
Stock
€0
Debtors
€0
Creditors
€0
Working capital
€0
Funding
€0
Growth
Growth
0%
CCC
0 days
Stock
€0
Debtors
€0
Creditors
€0
Working capital
€0
Funding
€0
Stress
Stock
€0
Debtors
€0
Creditors
€0
Working capital
€0
Funding
€0
Sensitivity
| Change |
Impact on working capital |
| +10% turnover growth |
€0 |
| +10 stock days |
€0 |
| +10 debtor days |
€0 |
| -10 creditor days |
€0 |
Working Capital Comparison
Methodology
Current Working Capital
Current Stock + Current Debtors - Current Creditors
Projected Turnover
Current Turnover x (1 + Growth)
Cost of Sales
Projected Turnover x (1 - Gross Margin)
Projected Stock
Cost of Sales x Stock Days / 365
Projected Debtors
Projected Turnover x Debtor Days / 365
Projected Creditors
Cost of Sales x Creditor Days / 365
Projected Working Capital
Projected Stock + Projected Debtors - Projected Creditors
Incremental Funding
Projected Working Capital - Current Working Capital
Indicative Facility
Incremental Funding x (1 + Funding Headroom)