{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Consolidation Report","<Entity 1>","<Entity 2>","<Entity 3>"],"not_rendered":{"macros":1,"external_links":1,"defined_names":24},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Consolidation Report","index":0,"n_rows":111,"n_cols":15,"rows_kept":111,"flags":["formulas_cached_only"]}
[null,"<Company Name>"]
[null,"Consolidation Report for Manufacturing"]
[null,"<Year>"]
[]
[null,"Gray cells will be calculated for you. You do not need to enter anything in them."]
[]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December","Annual"]
[null,"Profit-and-Loss Statement"]
[null,"Income"]
[null,"Gross revenue",{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":15000000,"d":"$15,000,000"},{"v":180000000,"d":"$180,000,000"}]
[null,"Cost of goods sold",{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":3000000,"d":"3,000,000 "},{"v":36000000,"d":"36,000,000 "}]
[null,"Gross Margin",{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":12000000,"d":"$12,000,000"},{"v":144000000,"d":"$144,000,000"}]
[]
[null,"Operating Expenses"]
[null,"Sales and marketing",{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":1200000,"d":"$1,200,000"},{"v":14400000,"d":"$14,400,000"}]
[null,"Payroll and payroll taxes",{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":5400000,"d":"5,400,000 "},{"v":64800000,"d":"64,800,000 "}]
[null,"Depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Insurance",{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":3600000,"d":"3,600,000 "}]
[null,"Maintenance, repair, and overhaul",{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":600000,"d":"600,000 "},{"v":7200000,"d":"7,200,000 "}]
[null,"Utilities",{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":750000,"d":"750,000 "},{"v":9000000,"d":"9,000,000 "}]
[null,"Property taxes",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Administrative fees",{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":1800000,"d":"1,800,000 "}]
[null,"Other",{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":1800000,"d":"1,800,000 "}]
[null,"Total Operating Expenses",{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":8550000,"d":"$8,550,000"},{"v":102600000,"d":"$102,600,000"}]
[]
[null,"Operating Income (Loss)",{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":3450000,"d":"$3,450,000"},{"v":41400000,"d":"$41,400,000"}]
[]
[null,"Interest expenses",{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":300000,"d":"300,000 "},{"v":3600000,"d":"$3,600,000"}]
[]
[null,"Operating Income Before Taxes",{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":3150000,"d":"$3,150,000"},{"v":37800000,"d":"$37,800,000"}]
[]
[null,"Taxes",{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":450000,"d":"450,000 "},{"v":5400000,"d":"5,400,000 "}]
[]
[null,"Net Income",{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":32400000,"d":"$32,400,000"}]
[null,"Balance Sheet"]
[null,"Current Assets"]
[null,"Cash and short-term investments",{"v":2700000,"d":"$2,700,000"},{"v":5400000,"d":"$5,400,000"},{"v":8100000,"d":"$8,100,000"},{"v":10800000,"d":"$10,800,000"},{"v":13500000,"d":"$13,500,000"},{"v":16200000,"d":"$16,200,000"},{"v":18900000,"d":"$18,900,000"},{"v":21600000,"d":"$21,600,000"},{"v":24300000,"d":"$24,300,000"},{"v":27000000,"d":"$27,000,000"},{"v":29700000,"d":"$29,700,000"},{"v":32400000,"d":"$32,400,000"},{"v":32400000,"d":"$32,400,000"}]
[null,"Accounts receivable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total inventory",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Prepaid expenses",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Deferred income tax",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Current Assets",{"v":2700000,"d":"$2,700,000"},{"v":5400000,"d":"$5,400,000"},{"v":8100000,"d":"$8,100,000"},{"v":10800000,"d":"$10,800,000"},{"v":13500000,"d":"$13,500,000"},{"v":16200000,"d":"$16,200,000"},{"v":18900000,"d":"$18,900,000"},{"v":21600000,"d":"$21,600,000"},{"v":24300000,"d":"$24,300,000"},{"v":27000000,"d":"$27,000,000"},{"v":29700000,"d":"$29,700,000"},{"v":32400000,"d":"$32,400,000"},{"v":32400000,"d":"$32,400,000"}]
[]
[null,"Property and Equipment"]
[null,"Buildings",{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"}]
[null,"Land",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capital improvements",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Machinery and equipment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Less accumulated depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Net Property and Equipment",{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"}]
[]
[null,"Assets"]
[null,"Goodwill",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Deferred income tax",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Long-term investments",{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "}]
[null,"Deposits",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other long-term assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Assets",{"v":4350000,"d":"$4,350,000"},{"v":7050000,"d":"$7,050,000"},{"v":9750000,"d":"$9,750,000"},{"v":12450000,"d":"$12,450,000"},{"v":15150000,"d":"$15,150,000"},{"v":17850000,"d":"$17,850,000"},{"v":20550000,"d":"$20,550,000"},{"v":23250000,"d":"$23,250,000"},{"v":25950000,"d":"$25,950,000"},{"v":28650000,"d":"$28,650,000"},{"v":31350000,"d":"$31,350,000"},{"v":34050000,"d":"$34,050,000"},{"v":34050000,"d":"$34,050,000"}]
[]
[null,"Current Liabilities"]
[null,"Accounts payable",{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"}]
[null,"Accrued expenses",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Notes payable/short-term debt",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capital leases",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other current liabilities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Current Liabilities",{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"},{"v":150000,"d":"$150,000"}]
[]
[null,"Long-term debt",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[null,"Total Liabilities",{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "}]
[]
[null,"Equity"]
[null,"Common stock",{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"}]
[null,"Preferred stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Additional paid-in capital",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Retained earnings",{"v":2700000,"d":"2,700,000 "},{"v":5400000,"d":"5,400,000 "},{"v":8100000,"d":"8,100,000 "},{"v":10800000,"d":"10,800,000 "},{"v":13500000,"d":"13,500,000 "},{"v":16200000,"d":"16,200,000 "},{"v":18900000,"d":"18,900,000 "},{"v":21600000,"d":"21,600,000 "},{"v":24300000,"d":"24,300,000 "},{"v":27000000,"d":"27,000,000 "},{"v":29700000,"d":"29,700,000 "},{"v":32400000,"d":"32,400,000 "},{"v":32400000,"d":"32,400,000 "}]
[null,"Total Equity",{"v":4200000,"d":"$4,200,000"},{"v":6900000,"d":"$6,900,000"},{"v":9600000,"d":"$9,600,000"},{"v":12300000,"d":"$12,300,000"},{"v":15000000,"d":"$15,000,000"},{"v":17700000,"d":"$17,700,000"},{"v":20400000,"d":"$20,400,000"},{"v":23100000,"d":"$23,100,000"},{"v":25800000,"d":"$25,800,000"},{"v":28500000,"d":"$28,500,000"},{"v":31200000,"d":"$31,200,000"},{"v":33900000,"d":"$33,900,000"},{"v":33900000,"d":"$33,900,000"}]
[]
[null,"Total Liabilities and Equity",{"v":4350000,"d":"$4,350,000"},{"v":7050000,"d":"$7,050,000"},{"v":9750000,"d":"$9,750,000"},{"v":12450000,"d":"$12,450,000"},{"v":15150000,"d":"$15,150,000"},{"v":17850000,"d":"$17,850,000"},{"v":20550000,"d":"$20,550,000"},{"v":23250000,"d":"$23,250,000"},{"v":25950000,"d":"$25,950,000"},{"v":28650000,"d":"$28,650,000"},{"v":31350000,"d":"$31,350,000"},{"v":34050000,"d":"$34,050,000"},{"v":34050000,"d":"$34,050,000"}]
[null,"Statement of Cash Flow"]
[null,"Operating Activities"]
[null,"Net income",{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":32400000,"d":"$32,400,000"}]
[null,"Depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Accounts receivable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Inventories",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Accounts payable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Amortization",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other operating cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Operating Activities",{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":32400000,"d":"$32,400,000"}]
[]
[null,"Investing Activities"]
[null,"Capital expenditures",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Acquisition of business",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Sale of fixed assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other investing cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Investing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Financing Activities"]
[null,"Long-term debt/financing",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Principal payment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Preferred stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total cash dividends paid",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Common stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other financing cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Financing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Cumulative Cash Flow",{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":2700000,"d":"$2,700,000"},{"v":32400000,"d":"$32,400,000"}]
[]
[null,"Beginning Cash Balance",{"v":0,"d":"$0"},{"v":2700000,"d":"$2,700,000"},{"v":5400000,"d":"$5,400,000"},{"v":8100000,"d":"$8,100,000"},{"v":10800000,"d":"$10,800,000"},{"v":13500000,"d":"$13,500,000"},{"v":16200000,"d":"$16,200,000"},{"v":18900000,"d":"$18,900,000"},{"v":21600000,"d":"$21,600,000"},{"v":24300000,"d":"$24,300,000"},{"v":27000000,"d":"$27,000,000"},{"v":29700000,"d":"$29,700,000"}]
[null,"Ending Cash Balance",{"v":2700000,"d":"$2,700,000"},{"v":5400000,"d":"$5,400,000"},{"v":8100000,"d":"$8,100,000"},{"v":10800000,"d":"$10,800,000"},{"v":13500000,"d":"$13,500,000"},{"v":16200000,"d":"$16,200,000"},{"v":18900000,"d":"$18,900,000"},{"v":21600000,"d":"$21,600,000"},{"v":24300000,"d":"$24,300,000"},{"v":27000000,"d":"$27,000,000"},{"v":29700000,"d":"$29,700,000"},{"v":32400000,"d":"$32,400,000"}]

{"sheet":"<Entity 1>","index":1,"n_rows":111,"n_cols":15,"rows_kept":111,"flags":["formulas_cached_only"]}
[null,"<Company Name>"]
[null,"<Entity 1> Financial Statements"]
[null,"<Year>"]
[]
[null,"Gray cells will be calculated for you. You do not need to enter anything in them."]
[]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December","Annual"]
[null,"Profit-and-Loss Statement"]
[null,"Income"]
[null,"Gross revenue",{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":60000000,"d":"$60,000,000"}]
[null,"Cost of goods sold",{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":12000000,"d":"12,000,000 "}]
[null,"Gross Margin",{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":48000000,"d":"$48,000,000"}]
[]
[null,"Operating Expenses"]
[null,"Sales and marketing",{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":4800000,"d":"$4,800,000"}]
[null,"Payroll and payroll taxes",{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":21600000,"d":"21,600,000 "}]
[null,"Depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Insurance",{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":1200000,"d":"1,200,000 "}]
[null,"Maintenance, repair, and overhaul",{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":2400000,"d":"2,400,000 "}]
[null,"Utilities",{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":3000000,"d":"3,000,000 "}]
[null,"Property taxes",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Administrative fees",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":600000,"d":"600,000 "}]
[null,"Other",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":600000,"d":"600,000 "}]
[null,"Total Operating Expenses",{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":34200000,"d":"$34,200,000"}]
[]
[null,"Operating Income (Loss)",{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":13800000,"d":"$13,800,000"}]
[]
[null,"Interest expenses",{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":1200000,"d":"1,200,000 "}]
[]
[null,"Operating Income Before Taxes",{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":12600000,"d":"$12,600,000"}]
[]
[null,"Taxes",{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":1800000,"d":"1,800,000 "}]
[]
[null,"Net Income",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[null,"Balance Sheet"]
[null,"Current Assets"]
[null,"Cash and short-term investments",{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"},{"v":10800000,"d":"$10,800,000"},{"v":10800000,"d":"$10,800,000"}]
[null,"Accounts receivable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total inventory",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Prepaid expenses",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Deferred income tax",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Current Assets",{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"},{"v":10800000,"d":"$10,800,000"},{"v":10800000,"d":"$10,800,000"}]
[]
[null,"Property and Equipment"]
[null,"Buildings",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[null,"Land",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capital improvements",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Machinery and equipment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Less accumulated depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Net Property and Equipment",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[]
[null,"Assets"]
[null,"Goodwill",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Deferred income tax",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Long-term investments",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "}]
[null,"Deposits",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other long-term assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Assets",{"v":1450000,"d":"$1,450,000"},{"v":2350000,"d":"$2,350,000"},{"v":3250000,"d":"$3,250,000"},{"v":4150000,"d":"$4,150,000"},{"v":5050000,"d":"$5,050,000"},{"v":5950000,"d":"$5,950,000"},{"v":6850000,"d":"$6,850,000"},{"v":7750000,"d":"$7,750,000"},{"v":8650000,"d":"$8,650,000"},{"v":9550000,"d":"$9,550,000"},{"v":10450000,"d":"$10,450,000"},{"v":11350000,"d":"$11,350,000"},{"v":11350000,"d":"$11,350,000"}]
[]
[null,"Current Liabilities"]
[null,"Accounts payable",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[null,"Accrued expenses",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Notes payable/short-term debt",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capital leases",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other current liabilities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Current Liabilities",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[]
[null,"Long-term debt",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[null,"Total Liabilities",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[]
[null,"Equity"]
[null,"Common stock",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[null,"Preferred stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Additional paid-in capital",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Retained earnings",{"v":900000,"d":"900,000 "},{"v":1800000,"d":"1,800,000 "},{"v":2700000,"d":"2,700,000 "},{"v":3600000,"d":"3,600,000 "},{"v":4500000,"d":"4,500,000 "},{"v":5400000,"d":"5,400,000 "},{"v":6300000,"d":"6,300,000 "},{"v":7200000,"d":"7,200,000 "},{"v":8100000,"d":"8,100,000 "},{"v":9000000,"d":"9,000,000 "},{"v":9900000,"d":"9,900,000 "},{"v":10800000,"d":"10,800,000 "},{"v":10800000,"d":"10,800,000 "}]
[null,"Total Equity",{"v":1400000,"d":"$1,400,000"},{"v":2300000,"d":"$2,300,000"},{"v":3200000,"d":"$3,200,000"},{"v":4100000,"d":"$4,100,000"},{"v":5000000,"d":"$5,000,000"},{"v":5900000,"d":"$5,900,000"},{"v":6800000,"d":"$6,800,000"},{"v":7700000,"d":"$7,700,000"},{"v":8600000,"d":"$8,600,000"},{"v":9500000,"d":"$9,500,000"},{"v":10400000,"d":"$10,400,000"},{"v":11300000,"d":"$11,300,000"},{"v":11300000,"d":"$11,300,000"}]
[]
[null,"Total Liabilities and Equity",{"v":1450000,"d":"$1,450,000"},{"v":2350000,"d":"$2,350,000"},{"v":3250000,"d":"$3,250,000"},{"v":4150000,"d":"$4,150,000"},{"v":5050000,"d":"$5,050,000"},{"v":5950000,"d":"$5,950,000"},{"v":6850000,"d":"$6,850,000"},{"v":7750000,"d":"$7,750,000"},{"v":8650000,"d":"$8,650,000"},{"v":9550000,"d":"$9,550,000"},{"v":10450000,"d":"$10,450,000"},{"v":11350000,"d":"$11,350,000"},{"v":11350000,"d":"$11,350,000"}]
[null,"Statement of Cash Flow"]
[null,"Operating Activities"]
[null,"Net income",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[null,"Depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Accounts receivable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Inventories",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Accounts payable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Amortization",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other operating cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Operating Activities",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[]
[null,"Investing Activities"]
[null,"Capital expenditures",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Acquisition of business",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Sale of fixed assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other investing cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Investing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Financing Activities"]
[null,"Long-term debt/financing",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Principal payment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Preferred stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total cash dividends paid",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Common stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other financing cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Financing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Cumulative Cash Flow",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[]
[null,"Beginning Cash Balance",{"v":0,"d":"$0"},{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"}]
[null,"Ending Cash Balance",{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"},{"v":10800000,"d":"$10,800,000"}]

{"sheet":"<Entity 2>","index":2,"n_rows":111,"n_cols":15,"rows_kept":111,"flags":["formulas_cached_only"]}
[null,"<Company Name>"]
[null,"<Entity 2> Financial Statements"]
[null,"<Year>"]
[]
[null,"Gray cells will be calculated for you. You do not need to enter anything in them."]
[]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December","Annual"]
[null,"Profit-and-Loss Statement"]
[null,"Income"]
[null,"Gross revenue",{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":60000000,"d":"$60,000,000"}]
[null,"Cost of goods sold",{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":12000000,"d":"12,000,000 "}]
[null,"Gross Margin",{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":48000000,"d":"$48,000,000"}]
[]
[null,"Operating Expenses"]
[null,"Sales and marketing",{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":4800000,"d":"$4,800,000"}]
[null,"Payroll and payroll taxes",{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":21600000,"d":"21,600,000 "}]
[null,"Depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Insurance",{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":1200000,"d":"1,200,000 "}]
[null,"Maintenance, repair, and overhaul",{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":2400000,"d":"2,400,000 "}]
[null,"Utilities",{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":3000000,"d":"3,000,000 "}]
[null,"Property taxes",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Administrative fees",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":600000,"d":"600,000 "}]
[null,"Other",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":600000,"d":"600,000 "}]
[null,"Total Operating Expenses",{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":34200000,"d":"$34,200,000"}]
[]
[null,"Operating Income (Loss)",{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":13800000,"d":"$13,800,000"}]
[]
[null,"Interest expenses",{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":1200000,"d":"1,200,000 "}]
[]
[null,"Operating Income Before Taxes",{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":12600000,"d":"$12,600,000"}]
[]
[null,"Taxes",{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":1800000,"d":"1,800,000 "}]
[]
[null,"Net Income",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[null,"Balance Sheet"]
[null,"Current Assets"]
[null,"Cash and short-term investments",{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"},{"v":10800000,"d":"$10,800,000"},{"v":10800000,"d":"$10,800,000"}]
[null,"Accounts receivable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total inventory",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Prepaid expenses",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Deferred income tax",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Current Assets",{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"},{"v":10800000,"d":"$10,800,000"},{"v":10800000,"d":"$10,800,000"}]
[]
[null,"Property and Equipment"]
[null,"Buildings",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[null,"Land",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capital improvements",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Machinery and equipment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Less accumulated depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Net Property and Equipment",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[]
[null,"Assets"]
[null,"Goodwill",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Deferred income tax",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Long-term investments",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "}]
[null,"Deposits",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other long-term assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Assets",{"v":1450000,"d":"$1,450,000"},{"v":2350000,"d":"$2,350,000"},{"v":3250000,"d":"$3,250,000"},{"v":4150000,"d":"$4,150,000"},{"v":5050000,"d":"$5,050,000"},{"v":5950000,"d":"$5,950,000"},{"v":6850000,"d":"$6,850,000"},{"v":7750000,"d":"$7,750,000"},{"v":8650000,"d":"$8,650,000"},{"v":9550000,"d":"$9,550,000"},{"v":10450000,"d":"$10,450,000"},{"v":11350000,"d":"$11,350,000"},{"v":11350000,"d":"$11,350,000"}]
[]
[null,"Current Liabilities"]
[null,"Accounts payable",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[null,"Accrued expenses",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Notes payable/short-term debt",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capital leases",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other current liabilities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Current Liabilities",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[]
[null,"Long-term debt",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[null,"Total Liabilities",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[]
[null,"Equity"]
[null,"Common stock",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[null,"Preferred stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Additional paid-in capital",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Retained earnings",{"v":900000,"d":"900,000 "},{"v":1800000,"d":"1,800,000 "},{"v":2700000,"d":"2,700,000 "},{"v":3600000,"d":"3,600,000 "},{"v":4500000,"d":"4,500,000 "},{"v":5400000,"d":"5,400,000 "},{"v":6300000,"d":"6,300,000 "},{"v":7200000,"d":"7,200,000 "},{"v":8100000,"d":"8,100,000 "},{"v":9000000,"d":"9,000,000 "},{"v":9900000,"d":"9,900,000 "},{"v":10800000,"d":"10,800,000 "},{"v":10800000,"d":"10,800,000 "}]
[null,"Total Equity",{"v":1400000,"d":"$1,400,000"},{"v":2300000,"d":"$2,300,000"},{"v":3200000,"d":"$3,200,000"},{"v":4100000,"d":"$4,100,000"},{"v":5000000,"d":"$5,000,000"},{"v":5900000,"d":"$5,900,000"},{"v":6800000,"d":"$6,800,000"},{"v":7700000,"d":"$7,700,000"},{"v":8600000,"d":"$8,600,000"},{"v":9500000,"d":"$9,500,000"},{"v":10400000,"d":"$10,400,000"},{"v":11300000,"d":"$11,300,000"},{"v":11300000,"d":"$11,300,000"}]
[]
[null,"Total Liabilities and Equity",{"v":1450000,"d":"$1,450,000"},{"v":2350000,"d":"$2,350,000"},{"v":3250000,"d":"$3,250,000"},{"v":4150000,"d":"$4,150,000"},{"v":5050000,"d":"$5,050,000"},{"v":5950000,"d":"$5,950,000"},{"v":6850000,"d":"$6,850,000"},{"v":7750000,"d":"$7,750,000"},{"v":8650000,"d":"$8,650,000"},{"v":9550000,"d":"$9,550,000"},{"v":10450000,"d":"$10,450,000"},{"v":11350000,"d":"$11,350,000"},{"v":11350000,"d":"$11,350,000"}]
[null,"Statement of Cash Flow"]
[null,"Operating Activities"]
[null,"Net income",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[null,"Depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Accounts receivable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Inventories",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Accounts payable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Amortization",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other operating cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Operating Activities",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[]
[null,"Investing Activities"]
[null,"Capital expenditures",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Acquisition of business",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Sale of fixed assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other investing cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Investing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Financing Activities"]
[null,"Long-term debt/financing",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Principal payment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Preferred stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total cash dividends paid",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Common stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other financing cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Financing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Cumulative Cash Flow",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[]
[null,"Beginning Cash Balance",{"v":0,"d":"$0"},{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"}]
[null,"Ending Cash Balance",{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"},{"v":10800000,"d":"$10,800,000"}]

{"sheet":"<Entity 3>","index":3,"n_rows":111,"n_cols":15,"rows_kept":111,"flags":["formulas_cached_only"]}
[null,"<Company Name>"]
[null,"<Entity 3> Financial Statements"]
[null,"<Year>"]
[]
[null,"Gray cells will be calculated for you. You do not need to enter anything in them."]
[]
[null,null,"January","February","March","April","May","June","July","August","September","October","November","December","Annual"]
[null,"Profit-and-Loss Statement"]
[null,"Income"]
[null,"Gross revenue",{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":5000000,"d":"$5,000,000"},{"v":60000000,"d":"$60,000,000"}]
[null,"Cost of goods sold",{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":1000000,"d":"1,000,000 "},{"v":12000000,"d":"12,000,000 "}]
[null,"Gross Margin",{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":4000000,"d":"$4,000,000"},{"v":48000000,"d":"$48,000,000"}]
[]
[null,"Operating Expenses"]
[null,"Sales and marketing",{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":400000,"d":"$400,000"},{"v":4800000,"d":"$4,800,000"}]
[null,"Payroll and payroll taxes",{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":1800000,"d":"1,800,000 "},{"v":21600000,"d":"21,600,000 "}]
[null,"Depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Insurance",{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":1200000,"d":"1,200,000 "}]
[null,"Maintenance, repair, and overhaul",{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":2400000,"d":"2,400,000 "}]
[null,"Utilities",{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":250000,"d":"250,000 "},{"v":3000000,"d":"3,000,000 "}]
[null,"Property taxes",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Administrative fees",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":600000,"d":"600,000 "}]
[null,"Other",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":600000,"d":"600,000 "}]
[null,"Total Operating Expenses",{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":2850000,"d":"$2,850,000"},{"v":34200000,"d":"$34,200,000"}]
[]
[null,"Operating Income (Loss)",{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":1150000,"d":"$1,150,000"},{"v":13800000,"d":"$13,800,000"}]
[]
[null,"Interest expenses",{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":100000,"d":"100,000 "},{"v":1200000,"d":"1,200,000 "}]
[]
[null,"Operating Income Before Taxes",{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":1050000,"d":"$1,050,000"},{"v":12600000,"d":"$12,600,000"}]
[]
[null,"Taxes",{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":150000,"d":"150,000 "},{"v":1800000,"d":"1,800,000 "}]
[]
[null,"Net Income",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[null,"Balance Sheet"]
[null,"Current Assets"]
[null,"Cash and short-term investments",{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"},{"v":10800000,"d":"$10,800,000"},{"v":10800000,"d":"$10,800,000"}]
[null,"Accounts receivable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total inventory",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Prepaid expenses",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Deferred income tax",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Current Assets",{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"},{"v":10800000,"d":"$10,800,000"},{"v":10800000,"d":"$10,800,000"}]
[]
[null,"Property and Equipment"]
[null,"Buildings",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[null,"Land",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capital improvements",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Machinery and equipment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Less accumulated depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Net Property and Equipment",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[]
[null,"Assets"]
[null,"Goodwill",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Deferred income tax",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Long-term investments",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "}]
[null,"Deposits",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other long-term assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Assets",{"v":1450000,"d":"$1,450,000"},{"v":2350000,"d":"$2,350,000"},{"v":3250000,"d":"$3,250,000"},{"v":4150000,"d":"$4,150,000"},{"v":5050000,"d":"$5,050,000"},{"v":5950000,"d":"$5,950,000"},{"v":6850000,"d":"$6,850,000"},{"v":7750000,"d":"$7,750,000"},{"v":8650000,"d":"$8,650,000"},{"v":9550000,"d":"$9,550,000"},{"v":10450000,"d":"$10,450,000"},{"v":11350000,"d":"$11,350,000"},{"v":11350000,"d":"$11,350,000"}]
[]
[null,"Current Liabilities"]
[null,"Accounts payable",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[null,"Accrued expenses",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Notes payable/short-term debt",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Capital leases",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other current liabilities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Current Liabilities",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[]
[null,"Long-term debt",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[]
[null,"Total Liabilities",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[]
[null,"Equity"]
[null,"Common stock",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[null,"Preferred stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Additional paid-in capital",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Retained earnings",{"v":900000,"d":"900,000 "},{"v":1800000,"d":"1,800,000 "},{"v":2700000,"d":"2,700,000 "},{"v":3600000,"d":"3,600,000 "},{"v":4500000,"d":"4,500,000 "},{"v":5400000,"d":"5,400,000 "},{"v":6300000,"d":"6,300,000 "},{"v":7200000,"d":"7,200,000 "},{"v":8100000,"d":"8,100,000 "},{"v":9000000,"d":"9,000,000 "},{"v":9900000,"d":"9,900,000 "},{"v":10800000,"d":"10,800,000 "},{"v":10800000,"d":"10,800,000 "}]
[null,"Total Equity",{"v":1400000,"d":"$1,400,000"},{"v":2300000,"d":"$2,300,000"},{"v":3200000,"d":"$3,200,000"},{"v":4100000,"d":"$4,100,000"},{"v":5000000,"d":"$5,000,000"},{"v":5900000,"d":"$5,900,000"},{"v":6800000,"d":"$6,800,000"},{"v":7700000,"d":"$7,700,000"},{"v":8600000,"d":"$8,600,000"},{"v":9500000,"d":"$9,500,000"},{"v":10400000,"d":"$10,400,000"},{"v":11300000,"d":"$11,300,000"},{"v":11300000,"d":"$11,300,000"}]
[]
[null,"Total Liabilities and Equity",{"v":1450000,"d":"$1,450,000"},{"v":2350000,"d":"$2,350,000"},{"v":3250000,"d":"$3,250,000"},{"v":4150000,"d":"$4,150,000"},{"v":5050000,"d":"$5,050,000"},{"v":5950000,"d":"$5,950,000"},{"v":6850000,"d":"$6,850,000"},{"v":7750000,"d":"$7,750,000"},{"v":8650000,"d":"$8,650,000"},{"v":9550000,"d":"$9,550,000"},{"v":10450000,"d":"$10,450,000"},{"v":11350000,"d":"$11,350,000"},{"v":11350000,"d":"$11,350,000"}]
[null,"Statement of Cash Flow"]
[null,"Operating Activities"]
[null,"Net income",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[null,"Depreciation",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Accounts receivable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Inventories",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Accounts payable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Amortization",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other operating cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Operating Activities",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[]
[null,"Investing Activities"]
[null,"Capital expenditures",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Acquisition of business",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Sale of fixed assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other investing cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Investing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Financing Activities"]
[null,"Long-term debt/financing",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,"Principal payment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Preferred stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total cash dividends paid",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Common stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Other financing cash flow items",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total Financing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Cumulative Cash Flow",{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":900000,"d":"$900,000"},{"v":10800000,"d":"$10,800,000"}]
[]
[null,"Beginning Cash Balance",{"v":0,"d":"$0"},{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"}]
[null,"Ending Cash Balance",{"v":900000,"d":"$900,000"},{"v":1800000,"d":"$1,800,000"},{"v":2700000,"d":"$2,700,000"},{"v":3600000,"d":"$3,600,000"},{"v":4500000,"d":"$4,500,000"},{"v":5400000,"d":"$5,400,000"},{"v":6300000,"d":"$6,300,000"},{"v":7200000,"d":"$7,200,000"},{"v":8100000,"d":"$8,100,000"},{"v":9000000,"d":"$9,000,000"},{"v":9900000,"d":"$9,900,000"},{"v":10800000,"d":"$10,800,000"}]