Bike workshop
Repairs, sale of bicycles and maintenance contracts.
Three incomes, stock, equipment and recruitment.
Create my projectInformation to provide
How many repairs can you carry out?
What margin on the sale of bicycles?
When to hire a mechanic?
Example data and tax conventions must be verified before professional use.
Template version
0.2.0
Worked example
Fictitious data, to be replaced by your assumptions.
Cash balance
Calculation conventionsUnderstand the Bike workshop forecast
Fictional example from Jan 2027 to Dec 2027. The results below cover the first twelve months.
These figures are fictional: they describe neither a real business, market prices nor expected profitability. Replace them with your quotes, prices and schedule.
Reference assumptions
- Repairs: 100 units per month at €65 excluding VAT per unit.
- Sale of bicycles: 20 units per month at €600 excluding VAT per unit.
- Maintenance contracts: 30 units per month at €15 excluding VAT per unit.
- Direct cost of Repairs: €0 excluding VAT per unit and 25% of revenue excluding VAT.
- Direct cost of Sale of bicycles: €360 excluding VAT per unit and 0% of revenue excluding VAT.
- Rent: €1,400 excluding VAT per month.
- Communication: €600 excluding VAT per month.
- Other expenses: €250 excluding VAT per month.
- Insurance: €120 excluding VAT per month.
- Founders: 2 person(s), €2,200 gross per month per person, employer contributions 45%, starting in month 1.
- Mechanic: 1 person(s), €2,800 gross per month per person, employer contributions 45%, starting in month 4.
- Equipment: €18,000 excluding VAT. Equity contribution: €25,000. Loan: €30,000.
- Initial inventory purchase: €12,000 excluding VAT.
Source: assumptions from the Bike workshop template, version 0.2.0; calculation engine 0.3.0. The full calculation includes the template’s direct costs and tax conventions.
Effect of changing an assumption
Alternative: hire the mechanic in month 7 instead of month 4. All other assumptions, including sales, remain unchanged; check that the available work capacity allows this.
| Indicator | Reference | Alternative |
|---|---|---|
| Sales over 12 months | €227,400 | €227,400 |
| Net profit over 12 months | -€24,924 | -€12,744 |
| Cash at the end of Dec 2027 | €2,945 | €15,125 |
Cash difference at the end of the first year, alternative minus reference: €12,180.
Net profit measures profit or loss. Cash also depends on payment terms, VAT, capital expenditure, inventory and financing. A loan provides cash without generating revenue.
Read calculation conventionsExpenses to review for this template
This list depends on your premises, team and sales channels. Open each guide to identify the information needed and the calculation section.