{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Basic P&L"],"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,"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":"Basic P&L","index":0,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[6,5,6,10],[0,0,0,2],[1,0,1,2],[5,5,5,10],[12,5,12,10],[10,5,10,10],[11,5,11,10],[7,5,7,10]]}
["BUSINESS NAME"]
["Forecast Profit and Loss Account - year ended DATE"]
[]
[]
[null,"£","£"]
["Sales"]
["Sales",null,90000]
["Other income",null,10000]
["Total Sales",null,{"$f":"SUM(C7+C8)","v":100000}]
[]
["Less Cost of sales"]
["Materials",30000]
["Direct wages & Employer's NI",25000]
["Other direct costs",15000]
[null,null,{"$f":"SUM(B12:B14)","v":70000}]
["Gross Profit",null,{"$f":"SUM(C7+C8-C15)","v":30000}]
[]
["Gross Profit margin",null,{"$f":"SUM(C16/C9)","v":0.3}]
[]
["Administrative expenses"]
["Salaries & Employer's NI",5000]
["Rent & rates",266]
["Light, heat & power",500]
["Repairs & Maintenance",44]
["Insurance",10]
["General office & administration",45]
["Motor expenses",1122]
["Travel/subsistence",456]
["Marketing & advertising ",77]
["Legal & professional fees",234]
["Finance charges",66]
["Telephone, postage etc",122]
["Other expenses",524]
[null,null,{"$f":"SUM(B21:B33)","v":8466}]
["Operating profit",null,{"$f":"C16-C34","v":21534}]
[]
["Non operating income/expense",null,100]
["Interest payable/receivable",null,-666]
[]
["Net profit/loss before tax",null,{"$f":"C35+C37+C38","v":20968}]
[]
["Net Profit Margin",null,{"$f":"SUM(C40/C9)","v":0.20968000000000001}]