{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Sheet1","index":0,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
["x","Income Statement for Go Nuts for Donuts from 1/1/2018-12/31/2018"]
[null,null,"FY2018",null,null,null,"Revenue Notes",null,null,"Account","Debit","Credit"]
[null,"Revenue",{"$f":"H6","v":150000},{"$f":"getformula(C4)","v":"<--  =H6"},null,null,"Units",100000,{"$f":"getformula(H4)","v":"<--  100000"},"Cash",150000]
[null,"COGS",{"$f":"H13","v":57000},{"$f":"getformula(C5)","v":"<--  =H13"},null,null,"Price",1.5,"<--  1.5","RE",null,150000]
[null,"SGA",{"$f":"H19","v":27000},{"$f":"getformula(C6)","v":"<--  =H19"},null,null,"Revenue",{"$f":"H4*H5","v":150000},"<--  =H4*H5","RE",57000]
[null,"EBIT",{"$f":"C4-C5-C6","v":66000},{"$f":"getformula(C7)","v":"<--  =C4-C5-C6"},null,null,null,null,null,"Inventory",null,31000]
[null,"Interest Expense, Net",{"$f":"H25","v":4800},{"$f":"getformula(C8)","v":"<--  =H25"},null,null,"COGS Notes",null,null,"Cash",null,25000]
[null,"Pre-tax Income",{"$f":"C7-C8","v":61200},{"$f":"getformula(C9)","v":"<--  =C7-C8"},null,null,"Inventory",30000,{"$f":"getformula(H9)","v":"<--  30000"},"PPE",null,1000]
[null,"Taxes",{"$f":"C9*H27","v":12852},"<--  =C9*H27",null,null,"Donut Making Team",25000,"<--  25000","RE",27000]
[null,"Net Income",{"$f":"C9-C10","v":48348},"<--  =C9-C10",null,null,"Write off Inventory",1000,"<--  1000","Accrued Expenses",null,5000]
[null,null,null,null,null,null,"Depreciation",1000,"<--  1000","Cash",null,22000]
[null,"Gross profit Margin",{"$f":"(C4-C5)/C4","v":0.62},"<--  =(C4-C5)/C4",null,null,"Total",{"$f":"SUM(H9:H12)","v":57000},"<--  =SUM(H9:H12)","RE",4800]
[null,"EPS",{"$f":"C11/H32","v":1.9339200000000001},"<--  =C11/H32",null,null,null,null,null,"Cash",null,4800]
[null,"EBITDA",{"$f":"C7+H12","v":67000},"<--  =C7+H12",null,null,"SGA Notes",null,null,"RE",12852]
[null,null,null,null,null,null,"Cashiers",25000,{"$f":"getformula(H16)","v":"<--  25000"},"Cash",null,12852]
["x","Balance Sheet for Go Nuts for Donuts",null,null,null,null,"Legal ",1500,"<--  1500","Cash",100000]
[null,null,"2018-01-01","2018-12-31",null,null,"Office supplies",500,"<--  500","Common Stock",null,100000]
[null,"Assets",null,null,{"$f":"D20-C20","v":155348},null,"Total",{"$f":"SUM(H16:H18)","v":27000},"<--  =SUM(H16:H18)","RE",15000]
[null,"Cash",38000,{"$f":"C20+M28","v":193348},{"$f":"getformula(D20)","v":"<--  =C20+M28"},null,null,null,null,"Cash",null,15000]
[null,"A/R",0,{"$f":"C21","v":0},{"$f":"getformula(D21)","v":"<--  =C21"},null,"Interest Notes",null,null,"Cash",10000]
[null,"Inventory",20000,{"$f":"C22+M30","v":9000},"<--  =C22+M30",null,"Interest Income",200,{"$f":"getformula(H22)","v":"<--  200"},"LTD",null,10000]
[null,"PP&E",67000,{"$f":"C23+M31","v":71000},"<--  =C23+M31",null,"New Loan interest",{"$f":"10000*0.1","v":1000},"<--  =10000*0.1","Inventory",20000]
[null,"Intangible",0,{"$f":"C24","v":0},"<--  =C24",null,"Interest pmts",4000,"<--  4000","Cash",null,20000]
[null,"Total Assets",{"$f":"SUM(C20:C24)","v":125000},{"$f":"SUM(D20:D24)","v":273348},"<--  =SUM(D20:D24)",null,"Total Expense",{"$f":"H24+H23-H22","v":4800},"<--  =H24+H23-H22","PPE",5000]
[null,null,null,null,null,null,null,null,null,"Cash",null,5000]
[null,"Liabilities",null,null,null,null,"Tax rate",0.21,null,null,{"$f":"getformula(K28)","v":"<--  =SUMIF($J$4:$J$26,$J28,K$4:K$26)"}]
[null,"Accrued Expenses",4000,{"$f":"C28-M32","v":9000},{"$f":"getformula(D28)","v":"<--  =C28-M32"},null,null,null,null,"Cash",{"$f":"SUMIF($J$4:$J$26,$J28,K$4:K$26)","v":260000},{"$f":"SUMIF($J$4:$J$26,$J28,L$4:L$26)","v":104652},{"$f":"K28-L28","v":155348},{"$f":"getformula(M28)","v":"<--  =K28-L28"}]
[null,"Long-term debt",40000,{"$f":"C29-M34","v":50000},"<--  =C29-M34",null,"Shares Notes",null,null,"RE",{"$f":"SUMIF($J$4:$J$26,$J29,K$4:K$26)","v":116652},150000,{"$f":"K29-L29","v":-33348},{"$f":"getformula(M29)","v":"<--  =K29-L29"}]
[null,"Total Liabilities",{"$f":"SUM(C28:C29)","v":44000},{"$f":"SUM(D28:D29)","v":59000},"<--  =SUM(D28:D29)",null,"Beg. Share count",20000,0.5,"Inventory",20000,31000,-11000,"<--  =K30-L30"]
[null,null,null,null,null,null,"Mid point Share Count",30000,0.5,"PPE",5000,1000,4000,"<--  =K31-L31"]
[null,"Equity",null,null,null,null,"EPS Share Count",{"$f":"H30*I30+H31*I31","v":25000},{"$f":"getformula(H32)","v":"<--  =H30*I30+H31*I31"},"Accrued Expenses",0,5000,-5000,"<--  =K32-L32"]
[null,"Common Stock",50000,{"$f":"C33-M33","v":150000},{"$f":"getformula(D33)","v":"<--  =C33-M33"},null,null,null,null,"Common Stock",0,100000,-100000,"<--  =K33-L33"]
[null,"Retained Earnings",{"$f":"C25-C30-C33","v":31000},{"$f":"C34-M29","v":64348},"<--  =C34-M29",null,"Dividend Notes",null,null,"LTD",0,10000,-10000,"<--  =K34-L34"]
[null,"Total Equity ",{"$f":"SUM(C33:C34)","v":81000},{"$f":"SUM(D33:D34)","v":214348},"<--  =SUM(D33:D34)",null,"Dividend/share",0.5]
[null,null,null,null,null,null,"Share Count",30000]
[null,"Balance Sheet Check",{"$f":"C25-C30-C35","v":0},{"$f":"D25-D30-D35","v":0},null,null,"Total Dividend",{"$f":"H36*H35","v":15000}]
[]
["x","Cash Flow Statement For Go Nuts for Donuts 1/1/2018-12/31/2018"]
[]
[null,"Cash at beginning",{"$f":"C20","v":38000},{"$f":"getformula(C41)","v":"<--  =C20"}]
[null,"Cash from operations"]
[null,"Net Income",{"$f":"C11","v":48348},{"$f":"getformula(C43)","v":"<--  =C11"}]
[null,"D&A",{"$f":"H12","v":1000},"<--  =H12"]
[null,"Changes in Working Capital"]
[null,"Inventory",{"$f":"-(D22-C22)","v":11000},{"$f":"getformula(C46)","v":"<--  =-(D22-C22)"}]
[null,"Accrued Expenses",{"$f":"D28-C28","v":5000},"<--  =D28-C28"]
[null,"Total",{"$f":"SUM(C43:C47)","v":65348},"<--  =SUM(C43:C47)"]
[]
[null,"Cash from investing"]
[null,"Capex",{"$f":"-5000","v":-5000},{"$f":"getformula(C51)","v":"<--  =-5000"}]
[null,"Asset sales",0,"<--  0"]
[null,"Asset write-offs",0,"<--  0"]
[null,"Total",{"$f":"SUM(C51:C53)","v":-5000},"<--  =SUM(C51:C53)"]
[]
[null,"Cash from financing"]
[null,"Debt Issuance",10000,{"$f":"getformula(C57)","v":"<--  10000"}]
[null,"Debt repayment",0,"<--  0"]
[null,"Stock issuance",100000,"<--  100000"]
[null,"Stock repurchase",0,"<--  0"]
[null,"Dividends paid",{"$f":"-H37","v":-15000},"<--  =-H37"]
[null,"Total",{"$f":"SUM(C57:C61)","v":95000},"<--  =SUM(C57:C61)"]
[]
[null,"Change in cash",{"$f":"C62+C54+C48","v":155348},{"$f":"getformula(C64)","v":"<--  =C62+C54+C48"}]
[null,"Cash at end",{"$f":"C64+C41","v":193348},"<--  =C64+C41"]
[null,"Check against BS",{"$f":"C65-D20","v":0},"<--  =C65-D20"]