{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Intro","Capital costs","Monthly costs","Revenue calculator","Summary"],"not_rendered":{"images":5,"external_links":1,"defined_names":6,"comments":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Intro","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"flags":["formulas_cached_only"]}
[]
[null,null,"Start-up costs calculator"]
[]
[]
[]
[]
[null,null,"Please note that this is a guide only and should neither replace competent advice, nor be taken, or relied upon, as financial or professional advice.  Seek professional advice before making any decision that could affect your business. "]

{"sheet":"Capital costs","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"merged":[[24,2,24,8]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Estimating your start-up costs"]
[null,null,"Equipment & assets",{"$nulls":3},"Life span (years)"]
[null,null,"Extra equipment e.g., vehicles, cleaning equipment",null,0,null,1]
[null,null,"Extra office equipment, e.g., computer, photocopier",null,0,null,1]
[null,null,"Fitting out, e.g., fittings, interior and exterior design",null,0,null,1]
[null,null,"Other 'one off' costs"]
[null,null,"Initial stock, e.g., merchandise, components",null,0]
[null,null,"Initial lease payments (new equipment etc)",null,0]
[null,null,"Licence fees",null,0]
[null,null,"Stationery e.g, letterhead, pens, pencils, paper",null,0]
[null,null,"Initial promotion costs, e.g, web design, signs, brochures",null,0]
[null,null,"Public relations fees",null,0]
[null,null,"Adviser fees, e.g., consultant charges, accountant fees",null,0]
[null,null,"Training costs. e.g., TAFE course fees",null,0]
[null,null,"Additional insurance",null,0]
[null,null,"Other",null,0]
[null,null,"Purchase cost of existing venture (include legal fees etc)",null,0]
[null,null,"Franchise and other fees to be paid",null,0]
[]
[null,null,"Total Capital costs",null,0]
[]
[]
[null,null,"Please note that this is a guide only and should neither replace competent advice, nor be taken, or relied upon, as financial or professional advice.  Seek professional advice before making any decision that could affect your business. "]

{"sheet":"Monthly costs","index":2,"n_rows":51,"n_cols":5,"rows_kept":51,"merged":[[3,2,3,5],[5,2,5,5],[30,2,30,5]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,"Your additional monthly business running costs"]
[null,null,"Equipment and assets (from Capital costs calculation)."]
[null,null,"These items have a limited life and will need to be replaced eventually.  We have calculated the monthly cost of these items from your entry in the previous Capital costs form.  If you wish to ignore this factor indicate below:"]
[null,null,"Ignore replacement costs (select)",null,"Ignore?"]
[]
[null,null,"Equipment and assets replacement cost",null,0]
[]
[null,null,"Additional wages (do you need extra staff?) ",null,0]
[null,null,"Packaging ",null,0]
[null,null,"Advertising  ",null,0]
[null,null,"Freight    ",null,0]
[null,null,"Telephone - incl additional mobile phones etc ",null,0]
[null,null,"Electricity  ",null,0]
[null,null,"Insurance  ",null,0]
[null,null,"Postage, printing, stationery ",null,0]
[null,null,"Rent, rates",null,0]
[null,null,"Hire purchase payments ",null,0]
[null,null,"Additional lease payments ",null,0]
[null,null,"Loan repayments ",null,0]
[null,null,"Repairs and maintenance ",null,0]
[null,null,"Payments to subcontractors    ",null,0]
[null,null,"Other   ",null,0]
[]
[null,null,"Total Monthly costs",null,0]
[]
[]
[]
[null,null,"Please note that this is a guide only and should neither replace competent advice, nor be taken, or relied upon, as financial or professional advice.  Seek professional advice before making any decision that could affect your business. "]
{"$rows_empty":17}
[{"$nulls":3},"Ignore?"]
[{"$nulls":3},"yes"]
[{"$nulls":3},"no"]

{"sheet":"Revenue calculator","index":3,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[2,2,2,6],[27,2,27,5],[29,2,29,6]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Potential Revenue Calculator (Yearly)"]
[]
[null,null,"Revenue","Example",null,"Your data"]
[]
[null,null,"Maximum number of possible customers (day)",80,null,0]
[]
[null,null,"Number of days open (per year)",300,null,0]
[]
[null,null,"Total potential customers / year ",24000,null,0]
[]
[null,null,"Percentage of customers who make a purchase",{"v":0.4,"d":"40%"},null,{"v":0,"d":"0%"}]
[]
[null,null,"Actual number of customers (per year)",9600,null,0]
[]
[null,null,"Average sale per customer",{"v":25,"d":"$25"},null,0]
[]
[null,null,"Average cost per customer",{"v":5,"d":"$5"},null,0]
[]
[null,null,"Total potential annual revenue ",{"v":192000,"d":"$192,000"},null,0]
[]
[null,null,"Less additional overheads (from Monthly costs)",{"v":12000,"d":"$12,000"},null,0]
[]
[null,null,"Revenue Potential",{"v":180000,"d":"$180,000"},null,0]
[]
[]
[null,null,"Note: This calculation includes an allowance for OVERHEADS."]
[]
[null,null,"Please note that this is a guide only and should neither replace competent advice, nor be taken, or relied upon, as financial or professional advice.  Seek professional advice before making any decision that could affect your business. "]

{"sheet":"Summary","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[6,2,6,3],[8,2,8,3],[16,2,16,4]],"flags":["formulas_cached_only"]}
[]
[]
[null,null,"Prepared by:","Date:"]
[null,null,"{Enter your name or business name here}","2010-11-23"]
[null,null,"Summary"]
[null,null,"Concept"]
[]
[null,null,"Description"]
[null,null,"{Enter a description for your concept here}"]
[null,null,"Capital costs. To set up you need:",0]
[null,null,"Monthly costs. Your idea will incur Monthly costs of:",0]
[null,null,"Potential revenue.  Additional revenue (after deducting annual expenses) for this idea is:",0]
[]
[]
[]
[]
[null,null,"Please note that this is a guide only and should neither replace competent advice, nor be taken, or relied upon, as financial or professional advice.  Seek professional advice before making any decision that could affect your business. "]