{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Budget","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,0,1,7],[2,0,2,7],[3,0,3,7],[5,2,5,3],[7,1,7,6],[12,1,12,6],[16,1,16,6],[22,1,22,6],[27,1,27,6],[31,1,31,6],[49,1,49,6],[59,0,59,7]]}
[]
["NAVI  –  THE NEW ENTREPRENEUR'S NAVIGATOR",{"$nulls":7},"💡 Explanation & example"]
["Budget Template – free tool for early-stage entrepreneurs"]
["South Karelia Entrepreneurs  |  Yrittäjyyden äitiyspakkaus project 2025–2026  |  Free tool for entrepreneurs"]
[]
[null,"Company name",{"$nulls":6},"Enter your company name here."]
[null,"Account group / Line item","Previous financial year €","Budget for financial year €",null,"Change €","Change %",null,"💡 What does this mean?"]
[null,"SALES REVENUE",{"$nulls":6},"💡 SALES REVENUE — Your income"]
[null,"   General sales total",100000,102000,null,{"$f":"D9-C9","v":2000},{"$f":"IFERROR(F9/C9,\"\")","v":0.02},null,"▸ General sales total\nAll regular sales — WITHOUT VAT.\nE.g: salon receives €4,000/month from customers, online shop €2,500.\n⚠️ Do not include VAT — net sales only."]
[null,"   Other revenue total",2000,2000,null,{"$f":"D10-C10","v":0},{"$f":"IFERROR(F10/C10,\"\")","v":0},null,"▸ Other revenue\nIrregular or other income.\nE.g: sold old equipment €200, received a project fee €500.\nLeave blank if none."]
[null,"TOTAL REVENUE",{"$f":"SUM(C9:C10)","v":102000},{"$f":"SUM(D9:D10)","v":104000},null,{"$f":"D11-C11","v":2000},{"$f":"IFERROR(F11/C11,\"\")","v":0.0196078431372549},null,"✅ All your income combined. Calculated automatically.\nThis is the figure against which all costs are compared."]
[]
[null,"OTHER OPERATING INCOME",{"$nulls":6},"💡 OTHER OPERATING INCOME"]
[null,"   Change in inventories",10000,-5000,null,{"$f":"D14-C14","v":-15000},{"$f":"IFERROR(F14/C14,\"\")","v":-1.5},null,"▸ Change in inventories\nIf you hold stock: enter the change in inventory value.\nIf stock grew by €10,000 enter +10,000. If it fell, use a negative.\n✏️ If you have NO inventory, enter 0."]
[null,"   Other operating income total",5000,6000,null,{"$f":"D15-C15","v":1000},{"$f":"IFERROR(F15/C15,\"\")","v":0.2},null,"▸ Other operating income\nGrants, compensation, rental income, or other occasional income.\nE.g: received €2,000 development grant or rented equipment for €500.\nLeave 0 if none."]
[]
[null,"MATERIALS AND SERVICES",{"$nulls":6},"💡 MATERIALS AND SERVICES — Production costs"]
[null,"   Purchases during the financial year",-30000,-31000,null,{"$f":"D18-C18","v":-1000},{"$f":"IFERROR(F18/C18,\"\")","v":0.0333333333333333},null,"▸ Purchases\nAll goods and materials purchased for the business.\nEnter as a negative number (costs are negative).\nE.g: shop buys stock −€15,000, café buys ingredients −€5,000."]
[null,"   Change in inventories",5000,5000,null,{"$f":"D19-C19","v":0},{"$f":"IFERROR(F19/C19,\"\")","v":0},null,"▸ Change in inventories (materials)\nChange in the value of material stock. Enter 0 if no inventory."]
[null,"   External services total",-10000,-10000,null,{"$f":"D20-C20","v":0},{"$f":"IFERROR(F20/C20,\"\")","v":-0},null,"▸ External services\nOutsourced work or services directly related to production.\nE.g: subcontractor, freelance graphic designer."]
[null,"Materials and services total",{"$f":"SUM(C18:C20)","v":-35000},{"$f":"SUM(D18:D20)","v":-36000},null,{"$f":"D21-C21","v":-1000},{"$f":"IFERROR(F21/C21,\"\")","v":0.0285714285714286},null,"✅ Calculated automatically."]
[]
[null,"PERSONNEL COSTS",{"$nulls":6},"💡 PERSONNEL COSTS — Wages and related costs"]
[null,"   Wages and salaries total",-20000,-21000,null,{"$f":"D24-C24","v":-1000},{"$f":"IFERROR(F24/C24,\"\")","v":0.05},null,"▸ Wages and salaries\nAll wages paid, including to yourself if you draw a salary.\nE.g: own salary −€2,000/month = −€24,000/year + part-timer −€800/month.\nEnter as a negative number."]
[null,"   Employer social contributions",-5000,-5000,null,{"$f":"D25-C25","v":0},{"$f":"IFERROR(F25/C25,\"\")","v":-0},null,"▸ Employer social contributions\nEmployer contributions on top of wages: pension, health insurance etc.\nUsually approx. 20–25% of gross wages."]
[null,"Personnel costs total",{"$f":"SUM(C24:C25)","v":-25000},{"$f":"SUM(D24:D25)","v":-26000},null,{"$f":"D26-C26","v":-1000},{"$f":"IFERROR(F26/C26,\"\")","v":0.04},null,"✅ Calculated automatically."]
[]
[null,"DEPRECIATION",{"$nulls":6},"💡 DEPRECIATION — Equipment losing value over time"]
[null,"   Planned depreciation total",-3000,-3000,null,{"$f":"D29-C29","v":0},{"$f":"IFERROR(F29/C29,\"\")","v":-0},null,"▸ Depreciation\nThe annual reduction in value of machines, equipment and fixtures.\nE.g: bought a €6,000 machine → depreciated over 3 years → −€2,000/year.\n✏️ If you have NO major equipment, enter 0."]
[null,"Depreciation total",{"$f":"SUM(C29)","v":-3000},{"$f":"SUM(D29)","v":-3000},null,{"$f":"D30-C30","v":0},{"$f":"IFERROR(F30/C30,\"\")","v":-0},null,"✅ Calculated automatically."]
[]
[null,"OTHER OPERATING COSTS",{"$nulls":6},"💡 OTHER OPERATING COSTS — All other business costs"]
[null,"   Voluntary personnel benefits",-4000,-4000,null,{"$f":"D33-C33","v":0},{"$f":"IFERROR(F33/C33,\"\")","v":-0},null,"▸ Voluntary personnel benefits\nOptional staff benefits: e.g. lunch benefit, sports benefit, phone benefit.\nLeave 0 if none."]
[null,"   Premises costs",-3000,-3000,null,{"$f":"D34-C34","v":0},{"$f":"IFERROR(F34/C34,\"\")","v":-0},null,"▸ Premises costs\nOffice, shop or warehouse rent + electricity + cleaning.\nE.g: office rent €400 + electricity €80 = −€480/month"]
[null,"   Vehicle costs",-500,-500,null,{"$f":"D35-C35","v":0},{"$f":"IFERROR(F35/C35,\"\")","v":-0},null,"▸ Vehicle costs\nCompany vehicle fuel, servicing, insurance.\nLeave 0 if you work from home or travel to customers without a company car."]
[null,"   IT equipment and software",-1000,-1000,null,{"$f":"D36-C36","v":0},{"$f":"IFERROR(F36/C36,\"\")","v":-0},null,"▸ IT equipment and software\nComputer, printer, cloud services, subscription software.\nE.g: Adobe €60/month, Shopify €30/month."]
[null,"   Other machinery and equipment",-1000,-1000,null,{"$f":"D37-C37","v":0},{"$f":"IFERROR(F37/C37,\"\")","v":-0},null,"▸ Other machinery and equipment\nMaintenance and leasing of other equipment.\nE.g: coffee machine lease, salon chair leasing."]
[null,"   Travel costs",-826,-900,null,{"$f":"D38-C38","v":-74},{"$f":"IFERROR(F38/C38,\"\")","v":0.089588377723971},null,"▸ Travel costs\nWork travel: mileage allowance, trains, flights, hotels.\nFinnish Tax Authority publishes the annual tax-free mileage rate."]
[null,"   Entertainment costs",-500,-500,null,{"$f":"D39-C39","v":0},{"$f":"IFERROR(F39/C39,\"\")","v":-0},null,"▸ Entertainment costs\nClient meeting expenses. Tax rules are strict.\nE.g: coffee for a client, small gift. Keep accurate records."]
[null,"   Sales and marketing costs",-500,-500,null,{"$f":"D40-C40","v":0},{"$f":"IFERROR(F40/C40,\"\")","v":-0},null,"▸ Sales and marketing costs\nAdvertising, social media ads, flyers, trade fairs, website.\nE.g: Facebook ads €100/month, domain €20/year."]
[null,"   Research and development",-100,-500,null,{"$f":"D41-C41","v":-400},{"$f":"IFERROR(F41/C41,\"\")","v":4},null,"▸ Research and development\nDevelopment of new products or services.\nE.g: training, prototypes, testing."]
[null,"   Administrative services",-1000,-1000,null,{"$f":"D42-C42","v":0},{"$f":"IFERROR(F42/C42,\"\")","v":-0},null,"▸ Administrative services\nAccountant, lawyer, consultant.\nE.g: accounting firm €150/month = −€1,800/year."]
[null,"   Other administrative costs",-2000,-2000,null,{"$f":"D43-C43","v":0},{"$f":"IFERROR(F43/C43,\"\")","v":-0},null,"▸ Other administrative costs\nOffice supplies, postage, bank charges, insurance.\nE.g: entrepreneur insurance €600/year, bank €10/month."]
[null,"   Other operating costs",-1000,-1000,null,{"$f":"D44-C44","v":0},{"$f":"IFERROR(F44/C44,\"\")","v":-0},null,"▸ Other operating costs\nAny other costs that do not fit the categories above."]
[null,"Other operating costs total",{"$f":"SUM(C33:C44)","v":-15426},{"$f":"SUM(D33:D44)","v":-15900},null,{"$f":"D45-C45","v":-474},{"$f":"IFERROR(F45/C45,\"\")","v":0.0307273434461299},null,"✅ Calculated automatically."]
[]
[null,"OPERATING PROFIT (LOSS)",{"$f":"SUM(C11,C14,C15,C21,C26,C30,C45)","v":38574},{"$f":"SUM(D11,D14,D15,D21,D26,D30,D45)","v":24100},null,{"$f":"D47-C47","v":-14474},{"$f":"IFERROR(F47/C47,\"\")","v":-0.375226836729403},null,"All income MINUS all costs.\n✅ Positive = profitable. Negative = loss.\nNote: this is before personal income tax."]
[null,"EBITDA (OPERATING PROFIT BEFORE DEPRECIATION)",{"$f":"C47-C30","v":41574},{"$f":"D47-D30","v":27100},null,{"$f":"D48-C48","v":-14474},{"$f":"IFERROR(F48/C48,\"\")","v":-0.34815028623659},null,"Operating profit before depreciation.\nShows operational efficiency before the impact of investments.\nA healthy EBITDA is a positive number."]
[]
[null,"% OF REVENUE",{"$nulls":6},"💡 % OF REVENUE — Cost structure as percentages"]
[null,"Line item","Previous financial year","Budget for financial year",{"$nulls":4},"These figures show what percentage of your revenue each cost group consumes."]
[null,"Other operating income total",{"$f":"IFERROR(C15/C11,\"\")","v":0.0490196078431373},{"$f":"IFERROR(D15/D11,\"\")","v":0.0576923076923077},{"$nulls":4},"E.g. 5% = other income is 5% of your revenue."]
[null,"Materials and services total",{"$f":"-IFERROR(C21/C11,\"\")","v":0.343137254901961},{"$f":"-IFERROR(D21/D11,\"\")","v":0.346153846153846},{"$nulls":4},"E.g. −30% = materials consume 30% of your revenue."]
[null,"Personnel costs total",{"$f":"-IFERROR(C26/C11,\"\")","v":0.245098039215686},{"$f":"-IFERROR(D26/D11,\"\")","v":0.25},{"$nulls":4},"E.g. −40% = personnel costs are 40% of your revenue."]
[null,"Depreciation total",{"$f":"-IFERROR(C30/C11,\"\")","v":0.0294117647058824},{"$f":"-IFERROR(D30/D11,\"\")","v":0.0288461538461538},{"$nulls":4},"E.g. −5% = depreciation is 5% of your revenue."]
[null,"Other operating costs total",{"$f":"-IFERROR(C45/C11,\"\")","v":0.151235294117647},{"$f":"-IFERROR(D45/D11,\"\")","v":0.152884615384615},{"$nulls":4},"E.g. −15% = other costs are 15% of your revenue."]
[null,"OPERATING PROFIT (LOSS)",{"$f":"IFERROR(C47/C11,\"\")","v":0.378176470588235},{"$f":"IFERROR(D47/D11,\"\")","v":0.231730769230769},{"$nulls":4},"✅ Target: operating profit positive (above 0%)."]
[null,"EBITDA",{"$f":"IFERROR(C48/C11,\"\")","v":0.407588235294118},{"$f":"IFERROR(D48/D11,\"\")","v":0.260576923076923},{"$nulls":4},"✅ A healthy EBITDA is typically 10–30% depending on sector."]
[]
["© South Karelia Entrepreneurs  |  Yrittäjyyden äitiyspakkaus project 2025–2026  |  Free tool – feel free to use and adapt"]

{"sheet":"Instructions","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[14,0,14,2]]}
[]
["NAVI  –  BUDGET TEMPLATE INSTRUCTIONS"]
["South Karelia Entrepreneurs  |  Yrittäjyyden äitiyspakkaus project 2025–2026"]
[]
["HOW TO USE THE BUDGET TEMPLATE"]
[null,"Fill in the salmon-coloured cells","Enter your previous financial year figures (if known) and your budget for the coming financial year. Leave blank if a line does not apply to you."]
[null,"Change columns","The Change (€) and Change (%) columns are calculated automatically — they show how much the budget differs from the previous year."]
[null,"% of Revenue","The bottom section shows the main cost groups as a percentage of revenue. A useful way to monitor your cost structure."]
[null,"Revenue","Enter only VAT-exclusive sales (without VAT). Revenue = all sales income combined."]
[null,"Negative numbers","Enter costs as negative numbers (e.g. −5000). Income is entered as positive numbers."]
[null,"EBITDA","Operating profit before depreciation. Shows operational profitability before the impact of investments."]
[null,"Add or remove rows","You can add your own rows within cost groups. Remember to update the SUM formulas to include the new rows."]
[null,"Free to share","This file is free to use and adapt. The template may be modified to suit your own business."]
[]
["© South Karelia Entrepreneurs  |  Yrittäjyyden äitiyspakkaus project 2025–2026  |  Free tool – feel free to use and adapt"]