BUSINESS PLAN · WORKING DRAFT

Officina Aurora

Impresa con bilancio o situazione contabile · 2027–2029

Generated on 13/11/2026, 21:00:00

Forecasts calculated from the inputs provided.

This draft combines questionnaire answers and calculated results. Missing inputs still need to be defined. WACC and NPV calculations are pending.

Business country: Italy (IT) · Plan currency: EUR · Calculation rules: Italy · existing simplified model

Project overview

Industry
Equipment maintenance
Geographic market
Province of Milan, local market
Legal structure
S.r.l.
Plan purpose
Bank financing

The project

Officina Aurora is a fictional microbusiness that services equipment for workshops and small companies. This plan describes a service expansion and the addition of a spare parts line. All company details, amounts and contract terms are invented to illustrate a report generated with Lumivy Business Plan.

Customers and needs

Small workshops, craft businesses and service companies that need scheduled maintenance to reduce equipment downtime.

Competition and positioning

Local repair businesses and manufacturers’ service networks. The assumed positioning combines scheduled maintenance, quotes for each job and stock of commonly requested spare parts.

Sales channels

Direct relationships with business customers, referrals and quote requests through the company website.

Team and skills

One employee handles technical work. The owner handles scheduling, purchasing, customer relationships and review of the forecasts.

Goals, deadlines and risks

In the first three months, buy equipment, introduce the spare parts line and review inventory and receipts weekly. Within six months, compare jobs completed, margins and customer payment delays with the assumptions.

The starting point

Historical financial year: 2026. Revenue: €78,000. Opening cash: €15,000. Historical figures remain separate from forecasts.

Fictional financial statements. Existing receivables and payables are settled in the early months of the plan. The accrued severance liability is not paid during the forecast period.

Bank funding request

Bank / recipient
Bank to be identified
Funding requested
12000
Use of funds and funding needs
Purchase of equipment costing €6,000 before VAT and funding of working capital for the spare parts line.
Own funds and other funding: amounts, timing and status
Opening cash of €15,000 at the end of 2026 and an additional owner contribution of €12,000 in January 2027.
Repayment sources and affordability
36 monthly instalments, starting in February 2027. Maintenance jobs and parts sales are the projected sources of repayment.
Existing debts, credit facilities and financial commitments
The illustrative opening balances include no outstanding financial debt.
Available or proposed security
No guarantees are assumed; any lender requirements will be assessed separately.
Downside scenario and response to lower-than-expected receipts
If customers take longer to pay, revise collection terms in the cash forecast, reduce spare-parts inventory and defer avoidable purchases.
Documents available and still required by the bank
A real application requires financial statements, quotes, financing terms and any other information requested by the bank.

Completion and review status

Estimates and professional reviews are separate from missing data. This summary does not certify compliance or acceptance of the plan.

Inputs or sections to complete
0
Benchmark assumptions
0
Accounting, tax and methodology reviews
0

Financial overview

Forecast revenue: €95,640 in 2027 and €147,120 in 2029. First-year EBITDA is €25,386 and profit before tax is €20,827.

First-year closing cash: €46,571. Maximum additional funding need over the plan horizon: €0.

Revenue by product, service and stream

Stream / model202720282029
Maintenance and support
Service · Direct B2B sales · Project-based / contract · Quantity × price
€86,400€108,900€132,600
Spare parts and accessories
Physical product · Direct B2B sales · One-off sale · Quantity × price
€9,240€11,880€14,520
Total revenue€95,640€120,780€147,120

Your data and benchmark estimates

If you do not know an input, use a documented market benchmark. Applied values are estimates, not actual business data: the source, period and market are recorded in the plan. You can edit them. Existing inputs and explicit zeros take priority. Without a reliable comparison, leave the input undefined.

Values without a benchmark label are user inputs, not verified by Lumivy. The site does not perform real-time research.

No benchmarks applied; missing fields remain undefined.

Questionnaire inputs and checks

Confirmations are manual reviews. Counts include optional and explanatory fields, not all of which are required by current calculations.

SectionCompleted inputsReviewWarnings
Your business11 / 11Confirmed0
Bank funding request9 / 9Confirmed0
Initial assumptions42 / 116Confirmed0
Historical figures55 / 55Confirmed0
Historical operating expenses4 / 4Confirmed0
Opening-balance schedules156 / 160Confirmed0
Revenue streams166 / 168Confirmed0
Staffing43 / 43Confirmed0
Variable costs4 / 4Confirmed0
Operating expenses39 / 39Confirmed0
Capital expenditure76 / 76Confirmed0
Bank loans8 / 8Confirmed0
Equity and grants39 / 39Confirmed0
Financial investments0 / 0Confirmed0

No input-check warnings.

Annual income statement

Item202720282029
Revenue€95,640€120,780€147,120
Cost of sales€17,580€22,275€27,150
Variable costs€4,782€6,039€7,356
Operating expenses€15,600€16,320€17,040
Payroll and employer costs€30,654€30,654€30,654
Italian severance-pay provision€1,638€1,638€1,638
EBITDA€25,386€43,854€63,282
Depreciation and amortisation€4,000€4,000€4,000
Bad-debt provision€0€0€0
Operating profit (EBIT)€21,386€39,854€59,282
Finance costs€559€394€156
Profit before tax€20,827€39,460€59,126
Estimated annual tax€7,070€12,269€17,756
Estimated profit after tax€13,757€27,191€41,371

Annual cash flow forecast

Item202720282029
Opening cash€15,000€46,571€77,901
Sales receipts (including VAT)€107,933€144,826€176,839
Indirect taxes collected (manual profile)€0€0€0
Opening receivable collections€5,000€0€0
Purchasing and operating payments€44,986€54,070€62,485
Payroll and employer-cost payments€30,654€30,654€30,654
Payments of opening liabilities and provisions€3,000€0€0
VAT payments€10,396€16,402€20,658
Income tax payments entered€5,000€8,000€11,000
Operating cash flow€18,897€35,700€52,042
Capital expenditure payments (including VAT)€7,320€0€0
Net financial investments€0€0€0
New loan drawdowns€12,000€0€0
Principal repayments€3,447€3,976€4,215
Interest paid€559€394€156
Shareholder contributions€12,000€0€0
Grants and subsidies€0€0€0
Change in cash€31,571€31,330€47,672
Closing cash€46,571€77,901€125,573

Annual debt service coverage (indicative DSCR)

Item202720282029
Cash available for debt service€11,577€35,700€52,042
Modelled debt service€4,006€4,370€4,370
Indicative DSCR (times)2.89×8.17×11.91×

The ratio divides operating cash flow after tax and investment payments by projected principal and interest. It excludes opening cash, new borrowings, equity, grants and financial investment movements. Debt service excludes loan fees. Existing debt payments are included when principal and interest are stated. A dash means incomplete data or zero debt service. Your bank may use a different method.

New transaction balances and inventory

Item202720282029
Closing inventory (including opening inventory)€257€330€403
Gross receivables from new sales€8,747€11,273€13,920
Payables for new purchases and expenses€1,641€2,114€2,605
New assets net of depreciation€4,000€2,000€0
Outstanding principal of new loans€8,553€4,577€362
VAT balance (negative = credit)€917€1,251€1,603

Forecast balance sheet

Annual balances are December closing balances. The reconciliation compares assets with liabilities and equity. Any differences are shown. Negative cash is shown as an uncovered cash funding need.

ItemOpening202720282029
Cash and bank balances€15,000.00€46,571.27€77,901.07€125,572.77
Trade receivables€5,000.00€8,747.40€11,272.80€13,920.20
Other and social security receivables€0.00€0.00€0.00€0.00
Indirect tax receivables€0.00€0.00€0.00€0.00
Income tax receivables€0.00€0.00€0.00€0.00
Closing inventory€0.00€256.67€330.00€403.33
Advance payments for investments€0.00€0.00€0.00€0.00
Net tangible assets€6,000.00€8,000.00€4,000.00€0.00
Net intangible assets€0.00€0.00€0.00€0.00
Unclassified fixed assets€0.00€0.00€0.00€0.00
Total tangible and intangible assets€6,000.00€8,000.00€4,000.00€0.00
Non-current financial assets€0.00€0.00€0.00€0.00
Total assets€26,000.00€63,575.33€93,503.87€139,896.30
Uncovered cash funding need€0.00€0.00€0.00€0.00
Short-term bank debt (opening balance)€0.00€0.00€0.00€0.00
Trade payables€3,000.00€1,640.90€2,113.65€2,604.70
Fixed-asset supplier payables€0.00€0.00€0.00€0.00
Staff and payroll liabilities€0.00€0.00€0.00€0.00
Indirect tax liabilities€0.00€916.63€1,250.81€1,602.59
Income tax liabilities€0.00€2,070.00€6,338.65€13,094.27
Other current liabilities€0.00€0.00€0.00€0.00
Employee benefit provisions€4,000.00€5,638.00€7,276.00€8,914.00
Estimated credit risk allowance€0.00€0.00€0.00€0.00
Other provisions€0.00€0.00€0.00€0.00
Deferred revenue€0.00€0.00€0.00€0.00
Outstanding loans€0.00€8,553.25€4,577.13€362.44
Received grants pending classification€0.00€0.00€0.00€0.00
Total liabilities€7,000.00€18,818.78€21,556.23€26,578.00
Share capital and owner contributions€10,000.00€22,000.00€22,000.00€22,000.00
Reserves€1,000.00€1,000.00€1,000.00€1,000.00
Retained earnings and losses-€2,408.00€8,000.00€21,756.56€48,947.63
Profit / loss for the year€10,408.00€13,756.56€27,191.07€41,370.67
Total equity€19,000.00€44,756.56€71,947.63€113,318.30
Total liabilities and equity€26,000.00€63,575.33€93,503.87€139,896.30
Reconciliation difference€0.00€0.00€0.00€0.00

Scenario comparison

Scenarios apply the percentage change to monthly revenue and invoicing. Proportional costs and cash flow are recalculated. Fixed costs, investments, financing and the entered tax payment schedule are shared across scenarios.

ItemBase case (0%)Downside (-15%)Upside (+15%)
2027
Revenue€95,640€81,294€109,986
EBITDA€25,386€14,394€36,378
Closing cash€46,571€36,504€56,639
Minimum cash balance€15,000€15,000€15,000
Indicative DSCR (times)2.89×0.38×5.40×
2028
Revenue€120,780€102,663€138,897
EBITDA€43,854€29,984€57,724
Closing cash€77,901€54,230€101,572
Minimum cash balance€46,571€36,504€56,639
Indicative DSCR (times)8.17×5.06×11.28×
2029
Revenue€147,120€125,052€169,188
EBITDA€63,282€46,390€80,174
Closing cash€125,573€85,290€165,856
Minimum cash balance€77,901€54,230€101,572
Indicative DSCR (times)11.91×8.11×15.71×
Maximum additional funding need€0€0€0

Monthly income statement 2027

ItemJanFebMarAprMayJunJulAugSepOctNovDec
Revenue€7,170€7,170€7,170€8,770€8,770€8,770€8,770€8,770€8,770€7,170€7,170€7,170
Cost of sales€1,345€1,345€1,345€1,585€1,585€1,585€1,585€1,585€1,585€1,345€1,345€1,345
Variable costs€359€359€359€439€439€439€439€439€439€359€359€359
Operating expenses€1,300€1,300€1,300€1,300€1,300€1,300€1,300€1,300€1,300€1,300€1,300€1,300
Payroll and employer costs€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555
Italian severance-pay provision€137€137€137€137€137€137€137€137€137€137€137€137
EBITDA€1,476€1,476€1,476€2,756€2,756€2,756€2,756€2,756€2,756€1,476€1,476€1,476
Depreciation and amortisation€333€333€333€333€333€333€333€333€333€333€333€333
Bad-debt provision€0€0€0€0€0€0€0€0€0€0€0€0
Operating profit (EBIT)€1,142€1,142€1,142€2,422€2,422€2,422€2,422€2,422€2,422€1,142€1,142€1,142
Finance costs€0€58€57€55€54€52€51€49€48€46€45€43
Profit before tax€1,142€1,084€1,085€2,367€2,368€2,370€2,371€2,373€2,374€1,096€1,097€1,099

Monthly cash flow 2027

ItemJanFebMarAprMayJunJulAugSepOctNovDec
Opening cash€15,000€32,299€31,346€33,251€34,597€37,322€37,546€40,270€42,994€45,719€48,541€47,485
Sales receipts (including VAT)€0€8,747€8,747€8,747€10,699€10,699€10,699€10,699€10,699€10,699€8,747€8,747
Indirect taxes collected (manual profile)€0€0€0€0€0€0€0€0€0€0€0€0
Opening receivable collections€5,000€0€0€0€0€0€0€0€0€0€0€0
Purchasing and operating payments€2,023€3,977€3,664€3,762€4,055€4,055€4,055€4,055€4,055€3,957€3,664€3,664
Payroll and employer-cost payments€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€4,716
Payments of opening liabilities and provisions€0€3,000€0€0€0€0€0€0€0€0€0€0
VAT payments€0€0€457€917€1,198€1,198€1,198€1,198€1,198€1,198€917€917
Income tax payments entered€0€0€0€0€0€2,500€0€0€0€0€2,500€0
Operating cash flow€619-€588€2,268€1,711€3,088€588€3,088€3,088€3,088€3,186-€692-€550
Capital expenditure payments (including VAT)€7,320€0€0€0€0€0€0€0€0€0€0€0
Net financial investments€0€0€0€0€0€0€0€0€0€0€0€0
New loan drawdowns€12,000€0€0€0€0€0€0€0€0€0€0€0
Principal repayments€0€306€307€309€310€312€313€315€316€318€319€321
Interest paid€0€58€57€55€54€52€51€49€48€46€45€43
Shareholder contributions€12,000€0€0€0€0€0€0€0€0€0€0€0
Grants and subsidies€0€0€0€0€0€0€0€0€0€0€0€0
Change in cash€17,299-€952€1,904€1,347€2,724€224€2,724€2,724€2,724€2,822-€1,056-€914
Closing cash€32,299€31,346€33,251€34,597€37,322€37,546€40,270€42,994€45,719€48,541€47,485€46,571

Monthly balance sheet 2027

ItemJanFebMarAprMayJunJulAugSepOctNovDec
Cash and bank balances€32,298.63€31,346.43€33,250.56€34,597.26€37,321.56€37,545.86€40,270.17€42,994.47€45,718.77€48,540.67€47,484.97€46,571.27
Trade receivables€8,747.40€8,747.40€8,747.40€10,699.40€10,699.40€10,699.40€10,699.40€10,699.40€10,699.40€8,747.40€8,747.40€8,747.40
Other and social security receivables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Indirect tax receivables€459.84€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Income tax receivables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Closing inventory€256.67€256.67€256.67€256.67€256.67€256.67€256.67€256.67€256.67€256.67€256.67€256.67
Advance payments for investments€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Net tangible assets€11,666.67€11,333.33€11,000.00€10,666.67€10,333.33€10,000.00€9,666.67€9,333.33€9,000.00€8,666.67€8,333.33€8,000.00
Net intangible assets€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Unclassified fixed assets€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Total tangible and intangible assets€11,666.67€11,333.33€11,000.00€10,666.67€10,333.33€10,000.00€9,666.67€9,333.33€9,000.00€8,666.67€8,333.33€8,000.00
Non-current financial assets€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Total assets€53,429.20€51,683.83€53,254.63€56,220.00€58,610.96€58,501.93€60,892.90€63,283.87€65,674.83€66,211.40€64,822.37€63,575.33
Uncovered cash funding need€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Short-term bank debt (opening balance)€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Trade payables€4,954.03€1,640.90€1,640.90€1,933.70€1,933.70€1,933.70€1,933.70€1,933.70€1,933.70€1,640.90€1,640.90€1,640.90
Fixed-asset supplier payables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Staff and payroll liabilities€196.50€393.00€589.50€786.00€982.50€1,179.00€1,375.50€1,572.00€1,768.50€1,965.00€2,161.50€0.00
Indirect tax liabilities€0.00€456.79€916.63€1,198.23€1,198.23€1,198.23€1,198.23€1,198.23€1,198.23€916.63€916.63€916.63
Income tax liabilities€423.61€830.93€1,238.66€2,003.93€2,769.62€1,035.73€1,802.26€2,569.22€3,336.61€3,747.31€1,658.43€2,070.00
Other current liabilities€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Employee benefit provisions€4,136.50€4,273.00€4,409.50€4,546.00€4,682.50€4,819.00€4,955.50€5,092.00€5,228.50€5,365.00€5,501.50€5,638.00
Estimated credit risk allowance€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Other provisions€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Deferred revenue€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Outstanding loans€12,000.00€11,694.21€11,386.93€11,078.16€10,767.88€10,456.10€10,142.79€9,827.96€9,511.60€9,193.70€8,874.25€8,553.25
Received grants pending classification€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Total liabilities€21,710.65€19,288.83€20,182.13€21,546.02€22,334.44€20,621.76€21,407.99€22,193.12€22,977.14€22,828.54€20,753.22€18,818.78
Share capital and owner contributions€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00
Reserves€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00
Retained earnings and losses€8,000.00€8,000.00€8,000.00€8,000.00€8,000.00€8,000.00€8,000.00€8,000.00€8,000.00€8,000.00€8,000.00€8,000.00
Profit / loss for the year€718.55€1,394.99€2,072.50€3,673.98€5,276.53€6,880.17€8,484.91€10,090.75€11,697.69€12,382.86€13,069.15€13,756.56
Total equity€31,718.55€32,394.99€33,072.50€34,673.98€36,276.53€37,880.17€39,484.91€41,090.75€42,697.69€43,382.86€44,069.15€44,756.56
Total liabilities and equity€53,429.20€51,683.83€53,254.63€56,220.00€58,610.96€58,501.93€60,892.90€63,283.87€65,674.83€66,211.40€64,822.37€63,575.33
Reconciliation difference€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00

Monthly income statement 2028

ItemJanFebMarAprMayJunJulAugSepOctNovDec
Revenue€9,240€9,240€9,240€10,890€10,890€10,890€10,890€10,890€10,890€9,240€9,240€9,240
Cost of sales€1,733€1,733€1,733€1,980€1,980€1,980€1,980€1,980€1,980€1,733€1,733€1,733
Variable costs€462€462€462€545€545€545€545€545€545€462€462€462
Operating expenses€1,360€1,360€1,360€1,360€1,360€1,360€1,360€1,360€1,360€1,360€1,360€1,360
Payroll and employer costs€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555
Italian severance-pay provision€137€137€137€137€137€137€137€137€137€137€137€137
EBITDA€2,995€2,995€2,995€4,315€4,315€4,315€4,315€4,315€4,315€2,995€2,995€2,995
Depreciation and amortisation€333€333€333€333€333€333€333€333€333€333€333€333
Bad-debt provision€0€0€0€0€0€0€0€0€0€0€0€0
Operating profit (EBIT)€2,661€2,661€2,661€3,981€3,981€3,981€3,981€3,981€3,981€2,661€2,661€2,661
Finance costs€42€40€38€37€35€34€32€30€29€27€26€24
Profit before tax€2,620€2,621€2,623€3,944€3,946€3,947€3,949€3,951€3,952€2,634€2,636€2,637

Monthly cash flow 2028

ItemJanFebMarAprMayJunJulAugSepOctNovDec
Opening cash€46,571€47,816€50,706€53,669€56,532€60,815€61,099€65,382€69,665€73,949€78,332€77,296
Sales receipts (including VAT)€8,747€11,273€11,273€11,273€13,286€13,286€13,286€13,286€13,286€13,286€11,273€11,273
Indirect taxes collected (manual profile)€0€0€0€0€0€0€0€0€0€0€0€0
Opening receivable collections€0€0€0€0€0€0€0€0€0€0€0€0
Purchasing and operating payments€3,864€4,426€4,336€4,437€4,739€4,739€4,739€4,739€4,739€4,638€4,336€4,336
Payroll and employer-cost payments€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€4,716
Payments of opening liabilities and provisions€0€0€0€0€0€0€0€0€0€0€0€0
VAT payments€917€1,235€1,251€1,251€1,541€1,541€1,541€1,541€1,541€1,541€1,251€1,251
Income tax payments entered€0€0€0€0€0€4,000€0€0€0€0€4,000€0
Operating cash flow€1,609€3,254€3,327€3,227€4,647€647€4,647€4,647€4,647€4,748-€673€969
Capital expenditure payments (including VAT)€0€0€0€0€0€0€0€0€0€0€0€0
Net financial investments€0€0€0€0€0€0€0€0€0€0€0€0
New loan drawdowns€0€0€0€0€0€0€0€0€0€0€0€0
Principal repayments€323€324€326€327€329€330€332€334€335€337€339€340
Interest paid€42€40€38€37€35€34€32€30€29€27€26€24
Shareholder contributions€0€0€0€0€0€0€0€0€0€0€0€0
Grants and subsidies€0€0€0€0€0€0€0€0€0€0€0€0
Change in cash€1,245€2,890€2,963€2,863€4,283€283€4,283€4,283€4,283€4,384-€1,037€605
Closing cash€47,816€50,706€53,669€56,532€60,815€61,099€65,382€69,665€73,949€78,332€77,296€77,901

Monthly balance sheet 2028

ItemJanFebMarAprMayJunJulAugSepOctNovDec
Cash and bank balances€47,816.10€50,706.06€53,669.36€56,532.01€60,815.32€61,098.62€65,381.92€69,665.22€73,948.52€78,332.47€77,295.77€77,901.07
Trade receivables€11,272.80€11,272.80€11,272.80€13,285.80€13,285.80€13,285.80€13,285.80€13,285.80€13,285.80€11,272.80€11,272.80€11,272.80
Other and social security receivables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Indirect tax receivables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Income tax receivables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Closing inventory€330.00€330.00€330.00€330.00€330.00€330.00€330.00€330.00€330.00€330.00€330.00€330.00
Advance payments for investments€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Net tangible assets€7,666.67€7,333.33€7,000.00€6,666.67€6,333.33€6,000.00€5,666.67€5,333.33€5,000.00€4,666.67€4,333.33€4,000.00
Net intangible assets€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Unclassified fixed assets€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Total tangible and intangible assets€7,666.67€7,333.33€7,000.00€6,666.67€6,333.33€6,000.00€5,666.67€5,333.33€5,000.00€4,666.67€4,333.33€4,000.00
Non-current financial assets€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Total assets€67,085.56€69,642.20€72,272.16€76,814.48€80,764.45€80,714.42€84,664.38€88,614.35€92,564.32€94,601.93€93,231.90€93,503.87
Uncovered cash funding need€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Short-term bank debt (opening balance)€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Trade payables€2,203.12€2,113.65€2,113.65€2,415.60€2,415.60€2,415.60€2,415.60€2,415.60€2,415.60€2,113.65€2,113.65€2,113.65
Fixed-asset supplier payables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Staff and payroll liabilities€196.50€393.00€589.50€786.00€982.50€1,179.00€1,375.50€1,572.00€1,768.50€1,965.00€2,161.50€0.00
Indirect tax liabilities€1,234.68€1,250.81€1,250.81€1,541.21€1,541.21€1,541.21€1,541.21€1,541.21€1,541.21€1,250.81€1,250.81€1,250.81
Income tax liabilities€2,905.80€3,742.03€4,578.71€5,784.11€6,989.95€4,196.24€5,402.98€6,610.17€7,817.82€8,657.64€5,497.91€6,338.65
Other current liabilities€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Employee benefit provisions€5,774.50€5,911.00€6,047.50€6,184.00€6,320.50€6,457.00€6,593.50€6,730.00€6,866.50€7,003.00€7,139.50€7,276.00
Estimated credit risk allowance€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Other provisions€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Deferred revenue€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Outstanding loans€8,230.68€7,906.55€7,580.83€7,253.53€6,924.64€6,594.15€6,262.04€5,928.32€5,592.98€5,256.01€4,917.39€4,577.13
Received grants pending classification€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Total liabilities€20,545.27€21,317.04€22,161.00€23,964.45€25,174.40€22,383.20€23,590.84€24,797.31€26,002.61€26,246.10€23,080.76€21,556.23
Share capital and owner contributions€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00
Reserves€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00
Retained earnings and losses€21,756.56€21,756.56€21,756.56€21,756.56€21,756.56€21,756.56€21,756.56€21,756.56€21,756.56€21,756.56€21,756.56€21,756.56
Profit / loss for the year€1,783.73€3,568.60€5,354.61€8,093.47€10,833.49€13,574.66€16,316.99€19,060.48€21,805.15€23,599.27€25,394.58€27,191.07
Total equity€46,540.29€48,325.16€50,111.16€52,850.03€55,590.05€58,331.22€61,073.55€63,817.04€66,561.71€68,355.83€70,151.14€71,947.63
Total liabilities and equity€67,085.56€69,642.20€72,272.16€76,814.48€80,764.45€80,714.42€84,664.38€88,614.35€92,564.32€94,601.93€93,231.90€93,503.87
Reconciliation difference€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00

Monthly income statement 2029

ItemJanFebMarAprMayJunJulAugSepOctNovDec
Revenue€11,410€11,410€11,410€13,110€13,110€13,110€13,110€13,110€13,110€11,410€11,410€11,410
Cost of sales€2,135€2,135€2,135€2,390€2,390€2,390€2,390€2,390€2,390€2,135€2,135€2,135
Variable costs€571€571€571€656€656€656€656€656€656€571€571€571
Operating expenses€1,420€1,420€1,420€1,420€1,420€1,420€1,420€1,420€1,420€1,420€1,420€1,420
Payroll and employer costs€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555€2,555
Italian severance-pay provision€137€137€137€137€137€137€137€137€137€137€137€137
EBITDA€4,594€4,594€4,594€5,954€5,954€5,954€5,954€5,954€5,954€4,594€4,594€4,594
Depreciation and amortisation€333€333€333€333€333€333€333€333€333€333€333€333
Bad-debt provision€0€0€0€0€0€0€0€0€0€0€0€0
Operating profit (EBIT)€4,260€4,260€4,260€5,620€5,620€5,620€5,620€5,620€5,620€4,260€4,260€4,260
Finance costs€22€21€19€17€16€14€12€10€9€7€5€4
Profit before tax€4,238€4,240€4,241€5,603€5,605€5,606€5,608€5,610€5,611€4,253€4,255€4,257

Monthly cash flow 2029

ItemJanFebMarAprMayJunJulAugSepOctNovDec
Opening cash€77,901€80,659€85,148€89,710€94,169€100,091€100,513€106,436€112,358€118,280€124,306€123,368
Sales receipts (including VAT)€11,273€13,920€13,920€13,920€15,994€15,994€15,994€15,994€15,994€15,994€13,920€13,920
Indirect taxes collected (manual profile)€0€0€0€0€0€0€0€0€0€0€0€0
Opening receivable collections€0€0€0€0€0€0€0€0€0€0€0€0
Purchasing and operating payments€4,542€5,123€5,033€5,137€5,448€5,448€5,448€5,448€5,448€5,344€5,033€5,033
Payroll and employer-cost payments€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€2,358€4,716
Payments of opening liabilities and provisions€0€0€0€0€0€0€0€0€0€0€0€0
VAT payments€1,251€1,586€1,603€1,603€1,902€1,902€1,902€1,902€1,902€1,902€1,603€1,603
Income tax payments entered€0€0€0€0€0€5,500€0€0€0€0€5,500€0
Operating cash flow€3,122€4,853€4,927€4,823€6,287€787€6,287€6,287€6,287€6,390-€574€2,569
Capital expenditure payments (including VAT)€0€0€0€0€0€0€0€0€0€0€0€0
Net financial investments€0€0€0€0€0€0€0€0€0€0€0€0
New loan drawdowns€0€0€0€0€0€0€0€0€0€0€0€0
Principal repayments€342€344€345€347€349€350€352€354€355€357€359€361
Interest paid€22€21€19€17€16€14€12€10€9€7€5€4
Shareholder contributions€0€0€0€0€0€0€0€0€0€0€0€0
Grants and subsidies€0€0€0€0€0€0€0€0€0€0€0€0
Change in cash€2,758€4,489€4,562€4,459€5,922€422€5,922€5,922€5,922€6,026-€938€2,204
Closing cash€80,659€85,148€89,710€94,169€100,091€100,513€106,436€112,358€118,280€124,306€123,368€125,573

Monthly balance sheet 2029

ItemJanFebMarAprMayJunJulAugSepOctNovDec
Cash and bank balances€80,658.80€85,147.76€89,710.06€94,168.67€100,090.97€100,513.27€106,435.57€112,357.87€118,280.17€124,306.17€123,368.47€125,572.77
Trade receivables€13,920.20€13,920.20€13,920.20€15,994.20€15,994.20€15,994.20€15,994.20€15,994.20€15,994.20€13,920.20€13,920.20€13,920.20
Other and social security receivables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Indirect tax receivables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Income tax receivables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Closing inventory€403.33€403.33€403.33€403.33€403.33€403.33€403.33€403.33€403.33€403.33€403.33€403.33
Advance payments for investments€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Net tangible assets€3,666.67€3,333.33€3,000.00€2,666.67€2,333.33€2,000.00€1,666.67€1,333.33€1,000.00€666.67€333.33€0.00
Net intangible assets€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Unclassified fixed assets€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Total tangible and intangible assets€3,666.67€3,333.33€3,000.00€2,666.67€2,333.33€2,000.00€1,666.67€1,333.33€1,000.00€666.67€333.33€0.00
Non-current financial assets€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Total assets€98,649.00€102,804.63€107,033.60€113,232.87€118,821.83€118,910.80€124,499.77€130,088.73€135,677.70€139,296.37€138,025.33€139,896.30
Uncovered cash funding need€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Short-term bank debt (opening balance)€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Trade payables€2,694.17€2,604.70€2,604.70€2,915.80€2,915.80€2,915.80€2,915.80€2,915.80€2,915.80€2,604.70€2,604.70€2,604.70
Fixed-asset supplier payables€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Staff and payroll liabilities€196.50€393.00€589.50€786.00€982.50€1,179.00€1,375.50€1,572.00€1,768.50€1,965.00€2,161.50€0.00
Indirect tax liabilities€1,586.46€1,602.59€1,602.59€1,901.79€1,901.79€1,901.79€1,901.79€1,901.79€1,901.79€1,602.59€1,602.59€1,602.59
Income tax liabilities€7,625.97€8,913.75€10,202.00€11,870.16€13,538.79€9,707.90€11,377.48€13,047.53€14,718.07€16,009.65€11,801.72€13,094.27
Other current liabilities€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Employee benefit provisions€7,412.50€7,549.00€7,685.50€7,822.00€7,958.50€8,095.00€8,231.50€8,368.00€8,504.50€8,641.00€8,777.50€8,914.00
Estimated credit risk allowance€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Other provisions€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Deferred revenue€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Outstanding loans€4,235.21€3,891.62€3,546.36€3,199.43€2,850.80€2,500.48€2,148.45€1,794.71€1,439.24€1,082.05€723.12€362.44
Received grants pending classification€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00
Total liabilities€23,750.80€24,954.66€26,230.66€28,495.18€30,148.18€26,299.96€27,950.51€29,599.83€31,247.90€31,904.99€27,671.12€26,578.00
Share capital and owner contributions€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00€22,000.00
Reserves€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00€1,000.00
Retained earnings and losses€48,947.63€48,947.63€48,947.63€48,947.63€48,947.63€48,947.63€48,947.63€48,947.63€48,947.63€48,947.63€48,947.63€48,947.63
Profit / loss for the year€2,950.57€5,902.34€8,855.31€12,790.05€16,726.02€20,663.20€24,601.62€28,541.27€32,482.16€35,443.74€38,406.58€41,370.67
Total equity€74,898.20€77,849.97€80,802.94€84,737.69€88,673.65€92,610.84€96,549.25€100,488.90€104,429.80€107,391.38€110,354.21€113,318.30
Total liabilities and equity€98,649.00€102,804.63€107,033.60€113,232.87€118,821.83€118,910.80€124,499.77€130,088.73€135,677.70€139,296.37€138,025.33€139,896.30
Reconciliation difference€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00€0.00

Methodology and limitations

  1. Simplified Italian profile: existing configuration, not full tax validation or bank approval. January–December financial years.
  2. Plan currency: EUR. No automatic conversion; all inputs must already use this currency.
  3. Income and expense amounts exclude VAT. Blank fields are not zero: totals include only available inputs.
  4. Trade collections and payments use 30-day months and split between the nearest two months for the entered delay. Purchase VAT uses the corresponding sales VAT rate.
  5. Inventory applies to physical products. Target inventory = monthly cost of sales × holding days / 30. Purchases cannot become negative when sales fall. Opening inventory is allocated by physical product cost of sales. Older drafts without a product type use holding days to identify streams with inventory.
  6. Payroll is accrued, with employer contributions on accrued salary. Additional 13th and 14th salaries are paid for the amount accrued in the selected month, with contributions. Italian severance pay is accrued without automatic payment.
  7. Straight-line monthly depreciation starts in the acquisition month and is capped at asset cost. Depreciation of existing assets follows the opening-balance schedules entered.
  8. New loans are drawn in the agreement month, with constant monthly repayments and interest starting the next month. Monthly rate: nominal annual rate / 12 or (1 + effective annual rate)^(1/12) − 1. Older drafts default to nominal rate. The grace period is interest-only. Existing loans belong in opening-balance schedules.
  9. VAT is settled the following month, carrying forward credits without automatic refunds. Cash flow includes only the income tax payments entered in initial assumptions and scheduled opening liabilities.
  10. Annual tax estimate: Italian IRES on positive profit before tax, plus IRAP on positive profit before tax plus payroll and severance accruals. This is a simplified planning convention, without deductions, loss carryforwards or automatic statutory deadlines.
  11. Grants are shown as separate cash inflows and excluded from income until their accounting treatment is defined. Financial investments use entered movements, without automatic returns or gains.
  12. Revenue streams are calculated separately then combined. Commission revenue equals transaction volume × rate. Monthly subscriptions use active customers net of churn × monthly fee. Prepaid annual contracts are invoiced on sale/renewal and earned over 12 months; VAT and collections follow invoicing. Prior-period contracts and refunds are not generated automatically.
  13. Benchmark estimates fill empty fields only when selected by the user, preserving own data and explicit zeros. Sources, period, market and assumptions are recorded in the report. The site does not conduct real-time market research.
  14. Balance sheet: the monthly result includes estimated income tax accrued since the start of the year when rates are available. Payments reduce tax payable or create a receivable. In January, the prior year’s result is transferred to retained earnings.
  15. Revenue billed in advance is deferred until earned. Received grants are shown separately pending classification. The model shows the estimated credit risk allowance under provisions.
  16. WACC e VAN non sono ancora calcolati.

Appendix: entered assumptions

Monthly input details are available in the separate Inputs CSV export.

Your business

Officina Aurora

Business or project name
Officina Aurora
Industry
Equipment maintenance
Location and target market
Province of Milan, local market
Legal structure
S.r.l.
What do you offer and what problem do you solve?
Officina Aurora is a fictional microbusiness that services equipment for workshops and small companies. This plan describes a service expansion and the addition of a spare parts line. All company details, amounts and contract terms are invented to illustrate a report generated with Lumivy Business Plan.
Who are your customers?
Small workshops, craft businesses and service companies that need scheduled maintenance to reduce equipment downtime.
Who are your competitors and what makes you different?
Local repair businesses and manufacturers’ service networks. The assumed positioning combines scheduled maintenance, quotes for each job and stock of commonly requested spare parts.
How will you reach customers?
Direct relationships with business customers, referrals and quote requests through the company website.
Who is on your team and what skills do you have?
One employee handles technical work. The owner handles scheduling, purchasing, customer relationships and review of the forecasts.
What is the business plan for?
Bank financing
Key goals, deadlines and risks
In the first three months, buy equipment, introduce the spare parts line and review inventory and receipts weekly. Within six months, compare jobs completed, margins and customer payment delays with the assumptions.

Bank funding request

Item 1

Bank / recipient
Bank to be identified
Funding requested
12000
Use of funds and funding needs
Purchase of equipment costing €6,000 before VAT and funding of working capital for the spare parts line.
Own funds and other funding: amounts, timing and status
Opening cash of €15,000 at the end of 2026 and an additional owner contribution of €12,000 in January 2027.
Repayment sources and affordability
36 monthly instalments, starting in February 2027. Maintenance jobs and parts sales are the projected sources of repayment.
Existing debts, credit facilities and financial commitments
The illustrative opening balances include no outstanding financial debt.
Available or proposed security
No guarantees are assumed; any lender requirements will be assessed separately.
Downside scenario and response to lower-than-expected receipts
If customers take longer to pay, revise collection terms in the cash forecast, reduce spare-parts inventory and defer avoidable purchases.
Documents available and still required by the bank
A real application requires financial statements, quotes, financing terms and any other information requested by the bank.

Initial assumptions

Item 1

First forecast year
2027
Forecast horizon
3
Expected launch / business start
2024-01
Assumed Italian IRAP rate
3.9
Assumed Italian IRES rate
24
Bad-debt provision
0
Cost of debt capital (Ki)
To be defined
Cost of equity capital (Ke)
To be defined

Historical figures

Item 1

Source of opening balances
Provisional accounts / newly formed business
Date, source and limitations of the accounts
Opening balances as at 31 December 2026, compiled entirely from fictional data for this example.
Financial year of opening balances
2026
Historical revenue
78000
Purchasing costs
11700
Inventory movement
0
Variable costs
3900
Operating expenses
14400
Employee costs
30654
Italian severance-pay provision
1638
Depreciation of tangible assets
2000
Amortisation of intangible assets
0
Bad-debt provision
0
Grace-period interest
0
Loan interest
0
Italian IRES for the year
2500
Italian IRAP for the year
800
Cash and bank balances
15000
Trade receivables
5000
Social-security receivables
0
Tax and withholding receivables
0
VAT credit
0
Other receivables and unbilled revenue
0
Closing inventory
0
Buildings: historical cost
0
Accumulated building depreciation
0
Plant and machinery: historical cost
0
Accumulated plant depreciation
0
Equipment: historical cost
10000
Accumulated equipment depreciation
4000
Non-current financial assets
0
Formation and expansion costs
0
Accumulated amortisation of formation costs
0
Research and development
0
Accumulated R&D amortisation
0
Other intangible assets
0
Accumulated amortisation of other intangibles
0
Short-term bank debt
0
Trade payables
3000
Fixed-asset supplier payables
0
Wages payable
0
Social-security and employee accruals
0
VAT payable
0
Tax liabilities
0
Other current liabilities
0
Outstanding loans and borrowings
0
Italian severance-pay fund
4000
Other provisions
0
Other medium- and long-term borrowings
0
Share capital
10000
Statutory reserve
1000
Other reserves
0
Retained earnings / accumulated losses
-2408
Profit / loss for the year
10408
Historical expense breakdown and notes to the accounts
Fictional financial statements. Existing receivables and payables are settled in the early months of the plan. The accrued severance liability is not paid during the forecast period.

Historical operating expenses

Premises and utilities

Historical expense category
Premises and utilities
Amount in the previous financial year
9600

Software and professional services

Historical expense category
Software and professional services
Amount in the previous financial year
4800

Opening-balance schedules

Customer receivables from 2026

Opening-balance item
Customer receivables from 2026
Movement
Collection of receivable
Opening balance account
To be defined
Opening balance
5000

Supplier payables from 2026

Opening-balance item
Supplier payables from 2026
Movement
Payment of liability
Opening balance account
To be defined
Opening balance
3000

Existing equipment

Opening-balance item
Existing equipment
Movement
Depreciation / amortisation
Opening balance account
To be defined
Opening balance
6000

Accrued severance liability

Opening-balance item
Accrued severance liability
Movement
Use of provision
Opening balance account
To be defined
Opening balance
4000

Revenue streams

Maintenance and support

Product, service or revenue stream
Maintenance and support
What do you sell?
Service
How do you deliver your offer?
Direct service delivery
Revenue-stream sales channel
Direct B2B sales
Commercial model
Project-based / contract
Forecast method
Quantity × price
Commission rate (commission method only)
To be defined
Cost of sales / direct costs as a share of revenue
15
VAT rate
22
Inventory holding period
0
Customer collection period
30
Supplier payment period
30

Spare parts and accessories

Product, service or revenue stream
Spare parts and accessories
What do you sell?
Physical product
How do you deliver your offer?
Purchase and resale
Revenue-stream sales channel
Direct B2B sales
Commercial model
One-off sale
Forecast method
Quantity × price
Commission rate (commission method only)
To be defined
Cost of sales / direct costs as a share of revenue
50
VAT rate
22
Inventory holding period
20
Customer collection period
30
Supplier payment period
30

Staffing

Technician

Role / job title
Technician
Monthly gross salary per person
1800
Italian INPS contributions
30
Italian INAIL contributions
1
Italian severance-pay / fund provision
7
Salary payments per year
13
13th-salary payment month
Dec
14th-salary payment month
To be defined

Variable costs

Sales commissions and job promotion

Cost category
Sales commissions and job promotion
VAT rate
22
Share of revenue
5
Payment delay
0

Operating expenses

Premises, software and professional services

Cost category
Premises, software and professional services
VAT rate
22
Payment delay
0

Capital expenditure

Workstations and equipment

Investment description
Workstations and equipment
Category
Industrial and commercial equipment
VAT rate
22
Depreciation / amortisation years
3

Bank loans

Illustrative bank loan

Bank / loan
Illustrative bank loan
Loan amount
12000
Loan agreement month and year
2027-01
Grace period in months
0
First repayment
2027-02
Annual interest rate
6
Annual rate basis
Effective annual rate (Excel model)
Number of monthly repayments
36

Equity and grants

Additional owner contribution

Funding source
Additional owner contribution
Type
Equity / shareholder capital
Status
Confirmed

Financial investments

Nessuna voce inserita.