{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Data Entry","Financial Analysis"],"not_rendered":{"defined_names":22,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Data Entry","index":0,"n_rows":109,"n_cols":8,"rows_kept":109,"merged":[[59,2,59,6],[60,3,60,7],[110,2,110,7]]}
[]
[]
[]
[null,null,"Data Entry For Financial Forecast Analysis"]
[]
[{"$nulls":7},"Four Year"]
[{"$nulls":3},2006,{"$f":"D7+1","v":2007},{"$f":"E7+1","v":2008},{"$f":"F7+1","v":2009},"Totals"]
[]
[null,null,"Sales"]
[null,null,"Sales",{"v":2010000,"d":"2,010,000 "},{"v":2060000,"d":"2,060,000 "},{"v":2121800,"d":"2,121,800 "},{"v":2391800,"d":"2,391,800 "},{"$f":"SUM(D10:G10)","v":{"v":8583600,"d":"8,583,600 "}}]
[null,null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(D11:G11)","v":{"v":0,"d":"0 "}}]
[null,null,"Total Sales",{"$f":"SUM(D10:D11)","v":{"v":2010000,"d":"2,010,000 "}},{"$f":"SUM(E10:E11)","v":{"v":2060000,"d":"2,060,000 "}},{"$f":"SUM(F10:F11)","v":{"v":2121800,"d":"2,121,800 "}},{"$f":"SUM(G10:G11)","v":{"v":2391800,"d":"2,391,800 "}},{"$f":"SUM(H10:H11)","v":{"v":8583600,"d":"8,583,600 "}}]
[]
[null,null,"Less Cost of Goods Sold"]
[null,null,"Materials",{"v":320000,"d":"320,000 "},{"v":329600,"d":"329,600 "},{"v":339488,"d":"339,488 "},{"v":389088,"d":"389,088 "},{"$f":"SUM(D15:G15)","v":{"v":1378176,"d":"1,378,176 "}}]
[null,null,"Labor",{"v":500000,"d":"500,000 "},{"v":515000,"d":"515,000 "},{"v":530450,"d":"530,450 "},{"v":545450,"d":"545,450 "},{"$f":"SUM(D16:G16)","v":{"v":2090900,"d":"2,090,900 "}}]
[null,null,"Overhead",{"v":125000,"d":"125,000 "},{"v":128750,"d":"128,750 "},{"v":132612.5,"d":"132,613 "},{"v":186362.5,"d":"186,363 "},{"$f":"SUM(D17:G17)","v":{"v":572725,"d":"572,725 "}}]
[null,null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(D18:G18)","v":{"v":0,"d":"0 "}}]
[null,null,"Total Cost of Goods Sold",{"$f":"SUM(D15:D18)","v":{"v":945000,"d":"945,000 "}},{"$f":"SUM(E15:E18)","v":{"v":973350,"d":"973,350 "}},{"$f":"SUM(F15:F18)","v":{"v":1002550.5,"d":"1,002,551 "}},{"$f":"SUM(G15:G18)","v":{"v":1120900.5,"d":"1,120,901 "}},{"$f":"SUM(H15:H18)","v":{"v":4041801,"d":"4,041,801 "}}]
[]
[null,null,"Gross Profit",{"$f":"D12-D19","v":{"v":1065000,"d":"1,065,000 "}},{"$f":"E12-E19","v":{"v":1086650,"d":"1,086,650 "}},{"$f":"F12-F19","v":{"v":1119249.5,"d":"1,119,250 "}},{"$f":"G12-G19","v":{"v":1270899.5,"d":"1,270,900 "}},{"$f":"H12-H19","v":{"v":4541799,"d":"4,541,799 "}}]
[]
[null,null,"Operating Expenses"]
[null,null,"Salaries and wages",{"v":190000,"d":"190,000 "},{"v":190000,"d":"190,000 "},{"v":190000,"d":"190,000 "},{"v":190000,"d":"190,000 "},{"$f":"SUM(D24:G24)","v":{"v":760000,"d":"760,000 "}}]
[null,null,"Employee benefits",{"v":50000,"d":"50,000 "},{"v":51500,"d":"51,500 "},{"v":53045,"d":"53,045 "},{"v":54545,"d":"54,545 "},{"v":209090,"d":"209,090 "}]
[null,null,"Payroll taxes",{"v":30000,"d":"30,000 "},{"v":30900,"d":"30,900 "},{"v":31827,"d":"31,827 "},{"v":32727,"d":"32,727 "},{"v":125454,"d":"125,454 "}]
[null,null,"Rent",{"v":5000,"d":"5,000 "},{"v":5150,"d":"5,150 "},{"v":5304.5,"d":"5,305 "},{"v":5454.5,"d":"5,455 "},{"v":20909,"d":"20,909 "}]
[null,null,"Utilities",{"v":3000,"d":"3,000 "},{"v":3090,"d":"3,090 "},{"v":3182.7,"d":"3,183 "},{"v":3272.7,"d":"3,273 "},{"v":12545.400000000001,"d":"12,545 "}]
[null,null,"Repairs and maintenance",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Insurance",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Travel",{"v":2133,"d":"2,133 "},{"v":2196.99,"d":"2,197 "},{"v":2262.8997,"d":"2,263 "},{"v":2262.8997,"d":"2,263 "},{"v":8855.7894,"d":"8,856 "}]
[null,null,"Telephone",{"v":11000,"d":"11,000 "},{"v":11330,"d":"11,330 "},{"v":11669.9,"d":"11,670 "},{"v":12669.9,"d":"12,670 "},{"v":46669.8,"d":"46,670 "}]
[null,null,"Postage",{"v":4000,"d":"4,000 "},{"v":4120,"d":"4,120 "},{"v":4243.6,"d":"4,244 "},{"v":4243.6,"d":"4,244 "},{"v":16607.2,"d":"16,607 "}]
[null,null,"Office supplies",{"v":6000,"d":"6,000 "},{"v":6180,"d":"6,180 "},{"v":6365.4,"d":"6,365 "},{"v":6365.4,"d":"6,365 "},{"v":24910.800000000003,"d":"24,911 "}]
[null,null,"Advertising",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Marketing/promotion",{"v":3000,"d":"3,000 "},{"v":3090,"d":"3,090 "},{"v":3182.7,"d":"3,183 "},{"v":3182.7,"d":"3,183 "},{"v":12455.400000000001,"d":"12,455 "}]
[null,null,"Professional fees",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Training and development",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Bank charges",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Depreciation",{"v":1000,"d":"1,000 "},{"v":1030,"d":"1,030 "},{"v":1060.9,"d":"1,061 "},{"v":1060.9,"d":"1,061 "},{"v":4151.8,"d":"4,152 "}]
[null,null,"Interest Expense",{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":24000,"d":"24,000 "}]
[null,null,"Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Operating Expenses",{"$f":"SUM(D24:D42)","v":{"v":317133,"d":"317,133 "}},{"$f":"SUM(E24:E42)","v":{"v":320766.99,"d":"320,767 "}},{"$f":"SUM(F24:F42)","v":{"v":324509.9997000002,"d":"324,510 "}},{"$f":"SUM(G24:G42)","v":{"v":328149.9997000002,"d":"328,150 "}},{"$f":"SUM(D43:G43)","v":{"v":1290559.9894000005,"d":"1,290,560 "}}]
[]
[null,null,"Operating Income",{"$f":"D21-D43","v":{"v":747867,"d":"747,867 "}},{"$f":"E21-E43","v":{"v":765883.01,"d":"765,883 "}},{"$f":"F21-F43","v":{"v":794739.5002999997,"d":"794,740 "}},{"$f":"G21-G43","v":{"v":942749.5002999997,"d":"942,750 "}},{"$f":"H21-H43","v":{"v":3251239.0105999997,"d":"3,251,239 "}}]
[]
[null,null,"Interest income (expense)",{"v":16250,"d":"16,250 "},{"v":16737.5,"d":"16,738 "},{"v":17239.625,"d":"17,240 "},{"v":18227.125,"d":"18,227 "},{"$f":"SUM(D47:G47)","v":{"v":68454.25,"d":"68,454 "}}]
[null,null,"Other income (expense)",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$f":"SUM(D48:G48)","v":{"v":0,"d":"0 "}}]
[null,null,"Total Nonoperating Income (Expense)",{"$f":"SUM(D47:D48)","v":{"v":16250,"d":"16,250 "}},{"$f":"SUM(E47:E48)","v":{"v":16737.5,"d":"16,738 "}},{"$f":"SUM(F47:F48)","v":{"v":17239.625,"d":"17,240 "}},{"$f":"SUM(G47:G48)","v":{"v":18227.125,"d":"18,227 "}},{"$f":"SUM(H47:H48)","v":{"v":68454.25,"d":"68,454 "}}]
[]
[null,null,"Income (Loss) Before Taxes",{"$f":"D45+D49","v":{"v":764117,"d":"764,117 "}},{"$f":"E45+E49","v":{"v":782620.51,"d":"782,621 "}},{"$f":"F45+F49","v":{"v":811979.1252999997,"d":"811,979 "}},{"$f":"G45+G49","v":{"v":960976.6252999997,"d":"960,977 "}},{"$f":"H45+H49","v":{"v":3319693.2605999997,"d":"3,319,693 "}}]
[]
[null,null,"Income Taxes",{"v":148563,"d":"148,563 "},{"v":149143.89,"d":"149,144 "},{"v":152922.20669999992,"d":"152,922 "},{"v":162629.0967,"d":"162,629 "},{"$f":"SUM(D53:G53)","v":{"v":613258.1934,"d":"613,258 "}}]
[]
[null,null,"Net Income (Loss)",{"$f":"D51-D53","v":{"v":615554,"d":"615,554 "}},{"$f":"E51-E53","v":{"v":633476.62,"d":"633,477 "}},{"$f":"F51-F53","v":{"v":659056.9185999997,"d":"659,057 "}},{"$f":"G51-G53","v":{"v":798347.5285999997,"d":"798,348 "}},{"$f":"H51-H53","v":{"v":2706435.0671999995,"d":"2,706,435 "}}]
[]
[null,null,"Cumulative Net Income (Loss)",{"$f":"D55","v":{"v":615554,"d":"615,554 "}},{"$f":"E55+D57","v":{"v":1249030.62,"d":"1,249,031 "}},{"$f":"F55+E57","v":{"v":1908087.5385999999,"d":"1,908,088 "}},{"$f":"G55+F57","v":{"v":2706435.0671999995,"d":"2,706,435 "}},{"$f":"H55+G57","v":{"v":5412870.134399999,"d":"5,412,870 "}}]
[]
[]
[null,null,"Balance Sheet - Years 1 to 4"]
[]
[]
[{"$nulls":3},"Opening","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"ASSETS"]
[]
[null,null,"Current Assets"]
[null,null,"Cash",{"v":507604.47331000003,"d":"507,604 "},{"v":451000,"d":"451,000 "},{"v":464530,"d":"464,530 "},{"v":478465.9,"d":"478,466 "},{"v":492819.87700000004,"d":"492,820 "}]
[null,null,"Notes Receivable",{"v":4300,"d":"4,300 "},{"v":1200,"d":"1,200 "},{"v":3200,"d":"3,200 "},{"v":3000,"d":"3,000 "},{"v":3400,"d":"3,400 "}]
[null,null,"Accounts receivable, net",{"v":393928.0835,"d":"393,928 "},{"v":350000,"d":"350,000 "},{"v":360500,"d":"360,500 "},{"v":371315,"d":"371,315 "},{"v":382454.45,"d":"382,454 "}]
[null,null,"Inventory",{"v":450203.524,"d":"450,204 "},{"v":400000,"d":"400,000 "},{"v":412000,"d":"412,000 "},{"v":424360,"d":"424,360 "},{"v":437090.8,"d":"437,091 "}]
[null,null,"Other",{"v":11255.0881,"d":"11,255 "},{"v":10000,"d":"10,000 "},{"v":10300,"d":"10,300 "},{"v":10609,"d":"10,609 "},{"v":10927.27,"d":"10,927 "}]
[null,null,"Total Current Assets",{"$f":"SUM(D68:D72)","v":{"v":1367291.16891,"d":"1,367,291 "}},{"$f":"SUM(E68:E72)","v":{"v":1212200,"d":"1,212,200 "}},{"$f":"SUM(F68:F72)","v":{"v":1250530,"d":"1,250,530 "}},{"$f":"SUM(G68:G72)","v":{"v":1287749.9,"d":"1,287,750 "}},{"$f":"SUM(H68:H72)","v":{"v":1326692.397,"d":"1,326,692 "}}]
[]
[null,null,"Long-Term Assets"]
[null,null,"Property, plant, and equipment",{"v":2701221.1440000003,"d":"2,701,221 "},{"v":2400000,"d":"2,400,000 "},{"v":2472000,"d":"2,472,000 "},{"v":2546160,"d":"2,546,160 "},{"v":2622544.8,"d":"2,622,545 "}]
[null,null,"Less accumulated depreciation",{"v":450203.524,"d":"450,204 "},{"v":400000,"d":"400,000 "},{"v":412000,"d":"412,000 "},{"v":424360,"d":"424,360 "},{"v":437090.8,"d":"437,091 "}]
[null,null,"Net property, plant, and equipment",{"$f":"+D76-D77","v":{"v":2251017.62,"d":"2,251,018 "}},{"$f":"+E76-E77","v":{"v":2000000,"d":"2,000,000 "}},{"$f":"+F76-F77","v":{"v":2060000,"d":"2,060,000 "}},{"$f":"+G76-G77","v":{"v":2121800,"d":"2,121,800 "}},{"$f":"+H76-H77","v":{"v":2185454,"d":"2,185,454 "}}]
[null,null,"Other long-term assets",{"v":58765.264299999995,"d":"58,765 "},{"v":55000,"d":"55,000 "},{"v":55900,"d":"55,900 "},{"v":56827,"d":"56,827 "},{"v":57781.81,"d":"57,782 "}]
[null,null,"Total Long-Term Assets",{"$f":"SUM(D78:D79)","v":{"v":2309782.8843,"d":"2,309,783 "}},{"$f":"SUM(E78:E79)","v":{"v":2055000,"d":"2,055,000 "}},{"$f":"SUM(F78:F79)","v":{"v":2115900,"d":"2,115,900 "}},{"$f":"SUM(G78:G79)","v":{"v":2178627,"d":"2,178,627 "}},{"$f":"SUM(H78:H79)","v":{"v":2243235.81,"d":"2,243,236 "}}]
[]
[null,null,"Total Assets",{"$f":"D73+D80","v":{"v":3677074.05321,"d":"3,677,074 "}},{"$f":"E73+E80","v":{"v":3267200,"d":"3,267,200 "}},{"$f":"F73+F80","v":{"v":3366430,"d":"3,366,430 "}},{"$f":"G73+G80","v":{"v":3466376.9,"d":"3,466,377 "}},{"$f":"H73+H80","v":{"v":3569928.2070000004,"d":"3,569,928 "}}]
[]
[null,null,"LIABILITIES AND SHAREHOLDERS' EQUITY"]
[]
[null,null,"Current Liabilities"]
[null,null,"Short-term debt",{"v":675305.286,"d":"675,305 "},{"v":600000,"d":"600,000 "},{"v":618000,"d":"618,000 "},{"v":636540,"d":"636,540 "},{"v":655636.2,"d":"655,636 "}]
[null,null,"Current maturities of long-term debt",{"v":112550.881,"d":"112,551 "},{"v":100000,"d":"100,000 "},{"v":103000,"d":"103,000 "},{"v":106090,"d":"106,090 "},{"v":109272.7,"d":"109,273 "}]
[null,null,"Accounts payable",{"v":112550.881,"d":"112,551 "},{"v":100000,"d":"100,000 "},{"v":103000,"d":"103,000 "},{"v":106090,"d":"106,090 "},{"v":109272.7,"d":"109,273 "}]
[null,null,"Income taxes payable",{"v":33765.264299999995,"d":"33,765 "},{"v":30000,"d":"30,000 "},{"v":30900,"d":"30,900 "},{"v":31827,"d":"31,827 "},{"v":32781.81,"d":"32,782 "}]
[null,null,"Accrued liabilities",{"v":101295.79289999999,"d":"101,296 "},{"v":90000,"d":"90,000 "},{"v":92700,"d":"92,700 "},{"v":95481,"d":"95,481 "},{"v":98345.43,"d":"98,345 "}]
[null,null,"Other",{"v":18008.14096,"d":"18,008 "},{"v":16000,"d":"16,000 "},{"v":16480,"d":"16,480 "},{"v":16974.4,"d":"16,974 "},{"v":17483.632,"d":"17,484 "}]
[null,null,"Total Current Liabilities",{"$f":"SUM(D87:D92)","v":{"v":1053476.24616,"d":"1,053,476 "}},{"$f":"SUM(E87:E92)","v":{"v":936000,"d":"936,000 "}},{"$f":"SUM(F87:F92)","v":{"v":964080,"d":"964,080 "}},{"$f":"SUM(G87:G92)","v":{"v":993002.4,"d":"993,002 "}},{"$f":"SUM(H87:H92)","v":{"v":1022792.4719999998,"d":"1,022,792 "}}]
[]
[null,null,"Long-Term Liabilities"]
[null,null,"Long-term debt less current maturities",{"v":692156.286,"d":"692,156 "},{"v":601200,"d":"601,200 "},{"v":624200,"d":"624,200 "},{"v":645630,"d":"645,630 "},{"v":668308.2,"d":"668,308 "}]
[null,null,"Deferred income taxes",{"v":112550.881,"d":"112,551 "},{"v":100000,"d":"100,000 "},{"v":103000,"d":"103,000 "},{"v":106090,"d":"106,090 "},{"v":109272.7,"d":"109,273 "}]
[null,null,"Other long-term liabilities",{"v":85903,"d":"85,903 "},{"v":79000,"d":"79,000 "},{"v":80650,"d":"80,650 "},{"v":82350,"d":"82,350 "},{"v":84101,"d":"84,101 "}]
[null,null,"Total Long-Term Liabilities",{"$f":"SUM(D96:D98)","v":{"v":890610.1669999999,"d":"890,610 "}},{"$f":"SUM(E96:E98)","v":{"v":780200,"d":"780,200 "}},{"$f":"SUM(F96:F98)","v":{"v":807850,"d":"807,850 "}},{"$f":"SUM(G96:G98)","v":{"v":834070,"d":"834,070 "}},{"$f":"SUM(H96:H98)","v":{"v":861681.8999999999,"d":"861,682 "}}]
[]
[null,null,"Total Liabilities",{"$f":"D93+D99","v":{"v":1944086.41316,"d":"1,944,086 "}},{"$f":"E93+E99","v":{"v":1716200,"d":"1,716,200 "}},{"$f":"F93+F99","v":{"v":1771930,"d":"1,771,930 "}},{"$f":"G93+G99","v":{"v":1827072.4,"d":"1,827,072 "}},{"$f":"H93+H99","v":{"v":1884474.3719999997,"d":"1,884,474 "}}]
[null,null,"Shareholders' Equity"]
[null,null,"Common stock",{"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 "}]
[null,null,"Additional paid-in capital",{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "},{"v":1000,"d":"1,000 "}]
[null,null,"Retained earnings",{"v":56275.4405,"d":"56,275 "},{"v":50000,"d":"50,000 "},{"v":51500,"d":"51,500 "},{"v":53045,"d":"53,045 "},{"v":54636.35,"d":"54,636 "}]
[null,null,"Other",{"v":1575712.334,"d":"1,575,712 "},{"v":1400000,"d":"1,400,000 "},{"v":1442000,"d":"1,442,000 "},{"v":1485260,"d":"1,485,260 "},{"v":1529817.8,"d":"1,529,818 "}]
[null,null,"Total Shareholders' Equity",{"$f":"SUM(D103:D106)","v":{"v":1732987.7745,"d":"1,732,988 "}},{"$f":"SUM(E103:E106)","v":{"v":1551000,"d":"1,551,000 "}},{"$f":"SUM(F103:F106)","v":{"v":1594500,"d":"1,594,500 "}},{"$f":"SUM(G103:G106)","v":{"v":1639305,"d":"1,639,305 "}},{"$f":"SUM(H103:H106)","v":{"v":1685454.1500000001,"d":"1,685,454 "}}]
[]
[null,null,"Total Liabilities and Shareholders' Equity",{"$f":"D93+D99+D107","v":{"v":3677074.1876600003,"d":"3,677,074 "}},{"$f":"E93+E99+E107","v":{"v":3267200,"d":"3,267,200 "}},{"$f":"F93+F99+F107","v":{"v":3366430,"d":"3,366,430 "}},{"$f":"G93+G99+G107","v":{"v":3466377.4,"d":"3,466,377 "}},{"$f":"H93+H99+H107","v":{"v":3569928.522,"d":"3,569,929 "}}]

{"sheet":"Financial Analysis","index":1,"n_rows":109,"n_cols":12,"rows_kept":109}
[]
[]
[]
[null,null,"Forecast Analysis - Income Statement"]
[]
[]
[{"$nulls":3},{"$f":"'Data Entry'!D7","v":2006},{"$f":"'Data Entry'!E7","v":2007},{"$f":"'Data Entry'!F7","v":2008},{"$f":"'Data Entry'!G7","v":2009},{"$f":"G7+1","v":2010},{"$f":"H7+1","v":2011},{"$f":"I7+1","v":2012},{"$f":"J7+1","v":2013},"Totals"]
[]
[null,null,"Sales"]
[null,null,{"$f":"'Data Entry'!C10","v":"Sales"},{"$f":"'Data Entry'!D10","v":{"v":2010000,"d":"2,010,000 "}},{"$f":"'Data Entry'!E10","v":{"v":2060000,"d":"2,060,000 "}},{"$f":"'Data Entry'!F10","v":{"v":2121800,"d":"2,121,800 "}},{"$f":"'Data Entry'!G10","v":{"v":2391800,"d":"2,391,800 "}},{"$f":"FORECAST(H7,D10:G10,$D$7:$G$7)","v":{"v":2447700,"d":"2,447,700 "}},{"$f":"FORECAST($I$7,D10:H10,$D$7:$H$7)","v":{"v":2568420,"d":"2,568,420 "}},{"$f":"FORECAST($J$7,D10:I10,$D$7:$I$7)","v":{"v":2689140,"d":"2,689,140 "}},{"$f":"FORECAST($K$7,D10:J10,$D$7:$J$7)","v":{"v":2809860,"d":"2,809,860 "}},{"$f":"SUM(D10:K10)","v":{"v":19098720,"d":"19,098,720 "}}]
[null,null,{"$f":"'Data Entry'!C11","v":"Other"},{"$f":"'Data Entry'!D11","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!E11","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!F11","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!G11","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($H$7,D11:G11,$D$7:$G$7)","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($I$7,D11:H11,$D$7:$H$7)","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($J$7,D11:I11,$D$7:$I$7)","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($K$7,D11:J11,$D$7:$J$7)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D11:K11)","v":{"v":0,"d":"0 "}}]
[null,null,"Total Sales",{"$f":"SUM(D10:D11)","v":{"v":2010000,"d":"2,010,000 "}},{"v":2060000,"d":"2,060,000 "},{"v":2121800,"d":"2,121,800 "},{"v":2391800,"d":"2,391,800 "},{"v":2447700,"d":"2,447,700 "},{"v":2568420,"d":"2,568,420 "},{"v":2689140,"d":"2,689,140 "},{"v":2809860,"d":"2,809,860 "},{"v":19098720,"d":"19,098,720 "}]
[]
[null,null,"Less Cost of Goods Sold"]
[null,null,{"$f":"'Data Entry'!C15","v":"Materials"},{"$f":"'Data Entry'!D15","v":{"v":320000,"d":"320,000 "}},{"$f":"'Data Entry'!E15","v":{"v":329600,"d":"329,600 "}},{"$f":"'Data Entry'!F15","v":{"v":339488,"d":"339,488 "}},{"$f":"'Data Entry'!G15","v":{"v":389088,"d":"389,088 "}},{"$f":"FORECAST($H$7,D15:G15,$D$7:$G$7)","v":{"v":398832,"d":"398,832 "}},{"$f":"FORECAST($I$7,D15:H15,$D$7:$H$7)","v":{"v":420547.200000003,"d":"420,547 "}},{"$f":"FORECAST($J$7,D15:I15,$D$7:$I$7)","v":{"v":442262.3999999985,"d":"442,262 "}},{"$f":"FORECAST($K$7,D15:J15,$D$7:$J$7)","v":{"v":463977.6000000015,"d":"463,978 "}},{"$f":"SUM(D15:K15)","v":{"v":3103795.200000003,"d":"3,103,795 "}}]
[null,null,{"$f":"'Data Entry'!C16","v":"Labor"},{"$f":"'Data Entry'!D16","v":{"v":500000,"d":"500,000 "}},{"$f":"'Data Entry'!E16","v":{"v":515000,"d":"515,000 "}},{"$f":"'Data Entry'!F16","v":{"v":530450,"d":"530,450 "}},{"$f":"'Data Entry'!G16","v":{"v":545450,"d":"545,450 "}},{"$f":"FORECAST($H$7,D16:G16,$D$7:$G$7)","v":{"v":560675,"d":"560,675 "}},{"$f":"FORECAST($I$7,D16:H16,$D$7:$H$7)","v":{"v":575855,"d":"575,855 "}},{"$f":"FORECAST($J$7,D16:I16,$D$7:$I$7)","v":{"v":591035,"d":"591,035 "}},{"$f":"FORECAST($K$7,D16:J16,$D$7:$J$7)","v":{"v":606215,"d":"606,215 "}},{"$f":"SUM(D16:K16)","v":{"v":4424680,"d":"4,424,680 "}}]
[null,null,{"$f":"'Data Entry'!C17","v":"Overhead"},{"$f":"'Data Entry'!D17","v":{"v":125000,"d":"125,000 "}},{"$f":"'Data Entry'!E17","v":{"v":128750,"d":"128,750 "}},{"$f":"'Data Entry'!F17","v":{"v":132612.5,"d":"132,613 "}},{"$f":"'Data Entry'!G17","v":{"v":186362.5,"d":"186,363 "}},{"$f":"FORECAST($H$7,D17:G17,$D$7:$G$7)","v":{"v":190168.75,"d":"190,169 "}},{"$f":"FORECAST($I$7,D17:H17,$D$7:$H$7)","v":{"v":208963.75,"d":"208,964 "}},{"$f":"FORECAST($J$7,D17:I17,$D$7:$I$7)","v":{"v":227758.75,"d":"227,759 "}},{"$f":"FORECAST($K$7,D17:J17,$D$7:$J$7)","v":{"v":246553.75,"d":"246,554 "}},{"$f":"SUM(D17:K17)","v":{"v":1446170,"d":"1,446,170 "}}]
[null,null,{"$f":"'Data Entry'!C18","v":"Other"},{"$f":"'Data Entry'!D18","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!E18","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!F18","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!G18","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($H$7,D18:G18,$D$7:$G$7)","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($I$7,D18:H18,$D$7:$H$7)","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($J$7,D18:I18,$D$7:$I$7)","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($K$7,D18:J18,$D$7:$J$7)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D18:K18)","v":{"v":0,"d":"0 "}}]
[null,null,"Total Cost of Goods Sold",{"$f":"SUM(D15:D18)","v":{"v":945000,"d":"945,000 "}},{"v":973350,"d":"973,350 "},{"v":1002550.5,"d":"1,002,551 "},{"v":1120900.5,"d":"1,120,901 "},{"v":1149675.75,"d":"1,149,676 "},{"v":1205365.950000003,"d":"1,205,366 "},{"v":1261056.1499999985,"d":"1,261,056 "},{"v":1316746.3500000015,"d":"1,316,746 "},{"v":8974645.200000003,"d":"8,974,645 "}]
[]
[null,null,"Gross Profit",{"$f":"D12-D19","v":{"v":1065000,"d":"1,065,000 "}},{"v":1086650,"d":"1,086,650 "},{"v":1119249.5,"d":"1,119,250 "},{"v":1270899.5,"d":"1,270,900 "},{"v":1298024.25,"d":"1,298,024 "},{"v":1363054.049999997,"d":"1,363,054 "},{"v":1428083.8500000015,"d":"1,428,084 "},{"v":1493113.6499999985,"d":"1,493,114 "},{"v":10124074.799999997,"d":"10,124,075 "}]
[]
[null,null,"Operating Expenses"]
[null,null,{"$f":"'Data Entry'!C24","v":"Salaries and wages"},{"$f":"'Data Entry'!D24","v":{"v":190000,"d":"190,000 "}},{"$f":"'Data Entry'!E24","v":{"v":190000,"d":"190,000 "}},{"$f":"'Data Entry'!F24","v":{"v":190000,"d":"190,000 "}},{"$f":"'Data Entry'!G24","v":{"v":190000,"d":"190,000 "}},{"$f":"FORECAST($H$7,D24:G24,$D$7:$G$7)","v":{"v":190000,"d":"190,000 "}},{"$f":"FORECAST($I$7,D24:H24,$D$7:$H$7)","v":{"v":190000,"d":"190,000 "}},{"$f":"FORECAST($J$7,D24:I24,$D$7:$I$7)","v":{"v":190000,"d":"190,000 "}},{"$f":"FORECAST($K$7,D24:J24,$D$7:$J$7)","v":{"v":190000,"d":"190,000 "}},{"$f":"SUM(D24:K24)","v":{"v":1520000,"d":"1,520,000 "}}]
[null,null,{"$f":"'Data Entry'!C25","v":"Employee benefits"},{"$f":"'Data Entry'!D25","v":{"v":50000,"d":"50,000 "}},{"$f":"'Data Entry'!E25","v":{"v":51500,"d":"51,500 "}},{"$f":"'Data Entry'!F25","v":{"v":53045,"d":"53,045 "}},{"$f":"'Data Entry'!G25","v":{"v":54545,"d":"54,545 "}},{"v":56067.5,"d":"56,068 "},{"v":57585.5,"d":"57,586 "},{"v":59103.5,"d":"59,104 "},{"v":60621.5,"d":"60,622 "},{"v":442468,"d":"442,468 "}]
[null,null,{"$f":"'Data Entry'!C26","v":"Payroll taxes"},{"$f":"'Data Entry'!D26","v":{"v":30000,"d":"30,000 "}},{"$f":"'Data Entry'!E26","v":{"v":30900,"d":"30,900 "}},{"$f":"'Data Entry'!F26","v":{"v":31827,"d":"31,827 "}},{"$f":"'Data Entry'!G26","v":{"v":32727,"d":"32,727 "}},{"v":33640.5,"d":"33,641 "},{"v":34551.299999999814,"d":"34,551 "},{"v":35462.09999999986,"d":"35,462 "},{"v":36372.899999999674,"d":"36,373 "},{"v":265480.79999999935,"d":"265,481 "}]
[null,null,{"$f":"'Data Entry'!C27","v":"Rent"},{"$f":"'Data Entry'!D27","v":{"v":5000,"d":"5,000 "}},{"$f":"'Data Entry'!E27","v":{"v":5150,"d":"5,150 "}},{"$f":"'Data Entry'!F27","v":{"v":5304.5,"d":"5,305 "}},{"$f":"'Data Entry'!G27","v":{"v":5454.5,"d":"5,455 "}},{"v":5606.75,"d":"5,607 "},{"v":5758.550000000047,"d":"5,759 "},{"v":5910.350000000035,"d":"5,910 "},{"v":6062.1500000000815,"d":"6,062 "},{"v":44246.80000000016,"d":"44,247 "}]
[null,null,{"$f":"'Data Entry'!C28","v":"Utilities"},{"$f":"'Data Entry'!D28","v":{"v":3000,"d":"3,000 "}},{"$f":"'Data Entry'!E28","v":{"v":3090,"d":"3,090 "}},{"$f":"'Data Entry'!F28","v":{"v":3182.7,"d":"3,183 "}},{"$f":"'Data Entry'!G28","v":{"v":3272.7,"d":"3,273 "}},{"v":3364.0499999999884,"d":"3,364 "},{"v":3455.1299999999756,"d":"3,455 "},{"v":3546.209999999992,"d":"3,546 "},{"v":3637.289999999979,"d":"3,637 "},{"v":26548.079999999936,"d":"26,548 "}]
[null,null,{"$f":"'Data Entry'!C29","v":"Repairs and maintenance"},{"$f":"'Data Entry'!D29","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!E29","v":{"v":1030,"d":"1,030 "}},{"$f":"'Data Entry'!F29","v":{"v":1060.9,"d":"1,061 "}},{"$f":"'Data Entry'!G29","v":{"v":1060.9,"d":"1,061 "}},{"v":1091.3499999999985,"d":"1,091 "},{"v":1112.7099999999919,"d":"1,113 "},{"v":1134.0699999999924,"d":"1,134 "},{"v":1155.429999999993,"d":"1,155 "},{"v":8645.359999999975,"d":"8,645 "}]
[null,null,{"$f":"'Data Entry'!C30","v":"Insurance"},{"$f":"'Data Entry'!D30","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!E30","v":{"v":1030,"d":"1,030 "}},{"$f":"'Data Entry'!F30","v":{"v":1060.9,"d":"1,061 "}},{"$f":"'Data Entry'!G30","v":{"v":1060.9,"d":"1,061 "}},{"v":1091.3499999999985,"d":"1,091 "},{"v":1112.7099999999919,"d":"1,113 "},{"v":1134.0699999999924,"d":"1,134 "},{"v":1155.429999999993,"d":"1,155 "},{"v":8645.359999999975,"d":"8,645 "}]
[null,null,{"$f":"'Data Entry'!C31","v":"Travel"},{"$f":"'Data Entry'!D31","v":{"v":2133,"d":"2,133 "}},{"$f":"'Data Entry'!E31","v":{"v":2196.99,"d":"2,197 "}},{"$f":"'Data Entry'!F31","v":{"v":2262.8997,"d":"2,263 "}},{"$f":"'Data Entry'!G31","v":{"v":2262.8997,"d":"2,263 "}},{"v":2327.849549999999,"d":"2,328 "},{"v":2373.4104300000035,"d":"2,373 "},{"v":2418.971310000008,"d":"2,419 "},{"v":2464.532189999998,"d":"2,465 "},{"v":18440.55288000001,"d":"18,441 "}]
[null,null,{"$f":"'Data Entry'!C32","v":"Telephone"},{"$f":"'Data Entry'!D32","v":{"v":11000,"d":"11,000 "}},{"$f":"'Data Entry'!E32","v":{"v":11330,"d":"11,330 "}},{"$f":"'Data Entry'!F32","v":{"v":11669.9,"d":"11,670 "}},{"$f":"'Data Entry'!G32","v":{"v":12669.9,"d":"12,670 "}},{"v":13004.84999999986,"d":"13,005 "},{"v":13539.810000000056,"d":"13,540 "},{"v":14074.770000000019,"d":"14,075 "},{"v":14609.729999999749,"d":"14,610 "},{"v":101898.95999999969,"d":"101,899 "}]
[null,null,{"$f":"'Data Entry'!C33","v":"Postage"},{"$f":"'Data Entry'!D33","v":{"v":4000,"d":"4,000 "}},{"$f":"'Data Entry'!E33","v":{"v":4120,"d":"4,120 "}},{"$f":"'Data Entry'!F33","v":{"v":4243.6,"d":"4,244 "}},{"$f":"'Data Entry'!G33","v":{"v":4243.6,"d":"4,244 "}},{"v":4365.399999999994,"d":"4,365 "},{"v":4450.839999999967,"d":"4,451 "},{"v":4536.27999999997,"d":"4,536 "},{"v":4621.719999999972,"d":"4,622 "},{"v":34581.4399999999,"d":"34,581 "}]
[null,null,{"$f":"'Data Entry'!C34","v":"Office supplies"},{"$f":"'Data Entry'!D34","v":{"v":6000,"d":"6,000 "}},{"$f":"'Data Entry'!E34","v":{"v":6180,"d":"6,180 "}},{"$f":"'Data Entry'!F34","v":{"v":6365.4,"d":"6,365 "}},{"$f":"'Data Entry'!G34","v":{"v":6365.4,"d":"6,365 "}},{"v":6548.100000000006,"d":"6,548 "},{"v":6676.260000000009,"d":"6,676 "},{"v":6804.420000000013,"d":"6,804 "},{"v":6932.579999999987,"d":"6,933 "},{"v":51872.16000000002,"d":"51,872 "}]
[null,null,{"$f":"'Data Entry'!C35","v":"Advertising"},{"$f":"'Data Entry'!D35","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!E35","v":{"v":1030,"d":"1,030 "}},{"$f":"'Data Entry'!F35","v":{"v":1060.9,"d":"1,061 "}},{"$f":"'Data Entry'!G35","v":{"v":1060.9,"d":"1,061 "}},{"v":1091.3499999999985,"d":"1,091 "},{"v":1112.7099999999919,"d":"1,113 "},{"v":1134.0699999999924,"d":"1,134 "},{"v":1155.429999999993,"d":"1,155 "},{"v":8645.359999999975,"d":"8,645 "}]
[null,null,{"$f":"'Data Entry'!C36","v":"Marketing/promotion"},{"$f":"'Data Entry'!D36","v":{"v":3000,"d":"3,000 "}},{"$f":"'Data Entry'!E36","v":{"v":3090,"d":"3,090 "}},{"$f":"'Data Entry'!F36","v":{"v":3182.7,"d":"3,183 "}},{"$f":"'Data Entry'!G36","v":{"v":3182.7,"d":"3,183 "}},{"v":3274.050000000003,"d":"3,274 "},{"v":3338.1300000000047,"d":"3,338 "},{"v":3402.2100000000064,"d":"3,402 "},{"v":3466.2899999999936,"d":"3,466 "},{"v":25936.08000000001,"d":"25,936 "}]
[null,null,{"$f":"'Data Entry'!C37","v":"Professional fees"},{"$f":"'Data Entry'!D37","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!E37","v":{"v":1030,"d":"1,030 "}},{"$f":"'Data Entry'!F37","v":{"v":1060.9,"d":"1,061 "}},{"$f":"'Data Entry'!G37","v":{"v":1060.9,"d":"1,061 "}},{"v":1091.3499999999985,"d":"1,091 "},{"v":1112.7099999999919,"d":"1,113 "},{"v":1134.0699999999924,"d":"1,134 "},{"v":1155.429999999993,"d":"1,155 "},{"v":8645.359999999975,"d":"8,645 "}]
[null,null,{"$f":"'Data Entry'!C38","v":"Training and development"},{"$f":"'Data Entry'!D38","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!E38","v":{"v":1030,"d":"1,030 "}},{"$f":"'Data Entry'!F38","v":{"v":1060.9,"d":"1,061 "}},{"$f":"'Data Entry'!G38","v":{"v":1060.9,"d":"1,061 "}},{"v":1091.3499999999985,"d":"1,091 "},{"v":1112.7099999999919,"d":"1,113 "},{"v":1134.0699999999924,"d":"1,134 "},{"v":1155.429999999993,"d":"1,155 "},{"v":8645.359999999975,"d":"8,645 "}]
[null,null,{"$f":"'Data Entry'!C39","v":"Bank charges"},{"$f":"'Data Entry'!D39","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!E39","v":{"v":1030,"d":"1,030 "}},{"$f":"'Data Entry'!F39","v":{"v":1060.9,"d":"1,061 "}},{"$f":"'Data Entry'!G39","v":{"v":1060.9,"d":"1,061 "}},{"v":1091.3499999999985,"d":"1,091 "},{"v":1112.7099999999919,"d":"1,113 "},{"v":1134.0699999999924,"d":"1,134 "},{"v":1155.429999999993,"d":"1,155 "},{"v":8645.359999999975,"d":"8,645 "}]
[null,null,{"$f":"'Data Entry'!C40","v":"Depreciation"},{"$f":"'Data Entry'!D40","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!E40","v":{"v":1030,"d":"1,030 "}},{"$f":"'Data Entry'!F40","v":{"v":1060.9,"d":"1,061 "}},{"$f":"'Data Entry'!G40","v":{"v":1060.9,"d":"1,061 "}},{"v":1091.3499999999985,"d":"1,091 "},{"v":1112.7099999999919,"d":"1,113 "},{"v":1134.0699999999924,"d":"1,134 "},{"v":1155.429999999993,"d":"1,155 "},{"v":8645.359999999975,"d":"8,645 "}]
[null,null,{"$f":"'Data Entry'!C41","v":"Interest Expense"},{"$f":"'Data Entry'!D41","v":{"v":6000,"d":"6,000 "}},{"$f":"'Data Entry'!E41","v":{"v":6000,"d":"6,000 "}},{"$f":"'Data Entry'!F41","v":{"v":6000,"d":"6,000 "}},{"$f":"'Data Entry'!G41","v":{"v":6000,"d":"6,000 "}},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":6000,"d":"6,000 "},{"v":48000,"d":"48,000 "}]
[null,null,{"$f":"'Data Entry'!C42","v":"Other"},{"$f":"'Data Entry'!D42","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!E42","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!F42","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!G42","v":{"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,null,"Total Operating Expenses",{"$f":"SUM(D24:D42)","v":{"v":317133,"d":"317,133 "}},{"v":320766.99,"d":"320,767 "},{"v":324509.9997000002,"d":"324,510 "},{"v":328149.9997000002,"d":"328,150 "},{"v":331838.49954999966,"d":"331,838 "},{"v":335517.9004299997,"d":"335,518 "},{"v":339197.30131,"d":"339,197 "},{"v":342876.7021899994,"d":"342,877 "},{"$f":"SUM(D43:G43)","v":{"v":1290559.9894000005,"d":"1,290,560 "}}]
[]
[null,null,"Operating Income",{"$f":"D21-D43","v":{"v":747867,"d":"747,867 "}},{"v":765883.01,"d":"765,883 "},{"v":794739.5002999997,"d":"794,740 "},{"v":942749.5002999997,"d":"942,750 "},{"v":966185.7504500004,"d":"966,186 "},{"v":1027536.1495699973,"d":"1,027,536 "},{"v":1088886.5486900015,"d":"1,088,887 "},{"v":1150236.947809999,"d":"1,150,237 "},{"v":8833514.810599996,"d":"8,833,515 "}]
[]
[null,null,{"$f":"'Data Entry'!C47","v":"Interest income (expense)"},{"$f":"'Data Entry'!D47","v":{"v":16250,"d":"16,250 "}},{"$f":"'Data Entry'!E47","v":{"v":16737.5,"d":"16,738 "}},{"$f":"'Data Entry'!F47","v":{"v":17239.625,"d":"17,240 "}},{"$f":"'Data Entry'!G47","v":{"v":18227.125,"d":"18,227 "}},{"$f":"FORECAST($H$7,D47:G47,$D$7:$G$7)","v":{"v":18721.9375,"d":"18,722 "}},{"$f":"FORECAST($I$7,D47:H47,$D$7:$H$7)","v":{"v":19365.287500000093,"d":"19,365 "}},{"$f":"FORECAST($J$7,D47:I47,$D$7:$I$7)","v":{"v":20008.637499999953,"d":"20,009 "}},{"$f":"FORECAST($K$7,D47:J47,$D$7:$J$7)","v":{"v":20651.987500000047,"d":"20,652 "}},{"$f":"SUM(D47:K47)","v":{"v":147202.1000000001,"d":"147,202 "}}]
[null,null,{"$f":"'Data Entry'!C48","v":"Other income (expense)"},{"$f":"'Data Entry'!D48","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!E48","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!F48","v":{"v":0,"d":"0 "}},{"$f":"'Data Entry'!G48","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($H$7,D48:G48,$D$7:$G$7)","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($I$7,D48:H48,$D$7:$H$7)","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($J$7,D48:I48,$D$7:$I$7)","v":{"v":0,"d":"0 "}},{"$f":"FORECAST($K$7,D48:J48,$D$7:$J$7)","v":{"v":0,"d":"0 "}},{"$f":"SUM(D48:K48)","v":{"v":0,"d":"0 "}}]
[null,null,"Total Nonoperating Income (Expense)",{"$f":"SUM(D47:D48)","v":{"v":16250,"d":"16,250 "}},{"v":16737.5,"d":"16,738 "},{"v":17239.625,"d":"17,240 "},{"v":18227.125,"d":"18,227 "},{"v":18721.9375,"d":"18,722 "},{"v":19365.287500000093,"d":"19,365 "},{"v":20008.637499999953,"d":"20,009 "},{"v":20651.987500000047,"d":"20,652 "},{"v":147202.1000000001,"d":"147,202 "}]
[]
[null,null,"Income (Loss) Before Taxes",{"$f":"D45+D49","v":{"v":764117,"d":"764,117 "}},{"v":782620.51,"d":"782,621 "},{"v":811979.1252999997,"d":"811,979 "},{"v":960976.6252999997,"d":"960,977 "},{"v":984907.6879500004,"d":"984,908 "},{"v":1046901.4370699974,"d":"1,046,901 "},{"v":1108895.1861900014,"d":"1,108,895 "},{"v":1170888.9353099992,"d":"1,170,889 "},{"v":8980716.910599995,"d":"8,980,717 "}]
[]
[null,null,{"$f":"'Data Entry'!C53","v":"Income Taxes"},{"$f":"'Data Entry'!D53","v":{"v":148563,"d":"148,563 "}},{"$f":"'Data Entry'!E53","v":{"v":149143.89,"d":"149,144 "}},{"$f":"'Data Entry'!F53","v":{"v":152922.20669999992,"d":"152,922 "}},{"$f":"'Data Entry'!G53","v":{"v":162629.0967,"d":"162,629 "}},{"$f":"FORECAST($H$7,D53:G53,$D$7:$G$7)","v":{"v":164808.7000500001,"d":"164,809 "}},{"$f":"FORECAST($I$7,D53:H53,$D$7:$H$7)","v":{"v":169406.36072999984,"d":"169,406 "}},{"$f":"FORECAST($J$7,D53:I53,$D$7:$I$7)","v":{"v":174004.02140999958,"d":"174,004 "}},{"$f":"FORECAST($K$7,D53:J53,$D$7:$J$7)","v":{"v":178601.68208999932,"d":"178,602 "}},{"$f":"SUM(D53:K53)","v":{"v":1300078.9576799988,"d":"1,300,079 "}}]
[]
[null,null,"Net Income (Loss)",{"$f":"D51-D53","v":{"v":615554,"d":"615,554 "}},{"v":633476.62,"d":"633,477 "},{"v":659056.9185999997,"d":"659,057 "},{"v":798347.5285999997,"d":"798,348 "},{"v":820098.9879000003,"d":"820,099 "},{"v":877495.0763399976,"d":"877,495 "},{"v":934891.1647800019,"d":"934,891 "},{"v":992287.2532199998,"d":"992,287 "},{"v":7680637.952919996,"d":"7,680,638 "}]
[]
[null,null,"Cumulative Net Income (Loss)",{"$f":"D55","v":{"v":615554,"d":"615,554 "}},{"$f":"E55+D57","v":{"v":1249030.62,"d":"1,249,031 "}},{"$f":"F55+E57","v":{"v":1908087.5385999999,"d":"1,908,088 "}},{"$f":"G55+F57","v":{"v":2706435.0671999995,"d":"2,706,435 "}},{"$f":"H55","v":{"v":820098.9879000003,"d":"820,099 "}},{"$f":"I55+H57","v":{"v":1697594.0642399979,"d":"1,697,594 "}},{"$f":"J55+I57","v":{"v":2632485.2290199995,"d":"2,632,485 "}},{"$f":"K55+J57","v":{"v":3624772.4822399993,"d":"3,624,772 "}},{"$f":"L55+G57","v":{"v":10387073.020119995,"d":"10,387,073 "}}]
[]
[]
[null,null,"Forecast Analysis - Balance Sheet"]
[]
[]
[{"$nulls":3},"Opening","Year 1","Year 2","Year 3","Opening","Year 1","Year 2","Year 3","Year 4"]
[]
[null,null,"ASSETS"]
[]
[null,null,"Current Assets"]
[null,null,{"$f":"'Data Entry'!C68","v":"Cash"},{"$f":"'Data Entry'!D68","v":{"v":507604.47331000003,"d":"507,604 "}},{"$f":"'Data Entry'!E68","v":{"v":451000,"d":"451,000 "}},{"$f":"'Data Entry'!F68","v":{"v":464530,"d":"464,530 "}},{"$f":"'Data Entry'!G68","v":{"v":478465.9,"d":"478,466 "}},{"$f":"FORECAST($H$7,D68:G68,$D$7:$G$7)","v":{"v":456928.6633449998,"d":"456,929 "}},{"$f":"FORECAST($I$7,D68:H68,$D$7:$H$7)","v":{"v":449540.09135199897,"d":"449,540 "}},{"$f":"FORECAST($J$7,D68:I68,$D$7:$I$7)","v":{"v":442151.51935899816,"d":"442,152 "}},{"$f":"FORECAST($K$7,D68:J68,$D$7:$J$7)","v":{"v":434762.94736599736,"d":"434,763 "}},{"v":492819.87700000004,"d":"492,820 "}]
[null,null,{"$f":"'Data Entry'!C69","v":"Notes Receivable"},{"$f":"'Data Entry'!D69","v":{"v":4300,"d":"4,300 "}},{"$f":"'Data Entry'!E69","v":{"v":1200,"d":"1,200 "}},{"$f":"'Data Entry'!F69","v":{"v":3200,"d":"3,200 "}},{"$f":"'Data Entry'!G69","v":{"v":3000,"d":"3,000 "}},{"$f":"FORECAST($H$7,D69:G69,$D$7:$G$7)","v":{"v":2450,"d":"2,450 "}},{"$f":"FORECAST($I$7,D69:H69,$D$7:$H$7)","v":{"v":2260,"d":"2,260 "}},{"$f":"FORECAST($J$7,D69:I69,$D$7:$I$7)","v":{"v":2070,"d":"2,070 "}},{"$f":"FORECAST($K$7,D69:J69,$D$7:$J$7)","v":{"v":1880,"d":"1,880 "}},{"v":3400,"d":"3,400 "}]
[null,null,{"$f":"'Data Entry'!C70","v":"Accounts receivable, net"},{"$f":"'Data Entry'!D70","v":{"v":393928.0835,"d":"393,928 "}},{"$f":"'Data Entry'!E70","v":{"v":350000,"d":"350,000 "}},{"$f":"'Data Entry'!F70","v":{"v":360500,"d":"360,500 "}},{"$f":"'Data Entry'!G70","v":{"v":371315,"d":"371,315 "}},{"$f":"FORECAST($H$7,D70:G70,$D$7:$G$7)","v":{"v":354600.9582500011,"d":"354,601 "}},{"$f":"FORECAST($I$7,D70:H70,$D$7:$H$7)","v":{"v":348867.03320000134,"d":"348,867 "}},{"$f":"FORECAST($J$7,D70:I70,$D$7:$I$7)","v":{"v":343133.1081500016,"d":"343,133 "}},{"$f":"FORECAST($K$7,D70:J70,$D$7:$J$7)","v":{"v":337399.1831000019,"d":"337,399 "}},{"v":382454.45,"d":"382,454 "}]
[null,null,{"$f":"'Data Entry'!C71","v":"Inventory"},{"$f":"'Data Entry'!D71","v":{"v":450203.524,"d":"450,204 "}},{"$f":"'Data Entry'!E71","v":{"v":400000,"d":"400,000 "}},{"$f":"'Data Entry'!F71","v":{"v":412000,"d":"412,000 "}},{"$f":"'Data Entry'!G71","v":{"v":424360,"d":"424,360 "}},{"$f":"FORECAST($H$7,D71:G71,$D$7:$G$7)","v":{"v":405258.23799999803,"d":"405,258 "}},{"$f":"FORECAST($I$7,D71:H71,$D$7:$H$7)","v":{"v":398705.18079999834,"d":"398,705 "}},{"$f":"FORECAST($J$7,D71:I71,$D$7:$I$7)","v":{"v":392152.12359999865,"d":"392,152 "}},{"$f":"FORECAST($K$7,D71:J71,$D$7:$J$7)","v":{"v":385599.06639999896,"d":"385,599 "}},{"v":437090.8,"d":"437,091 "}]
[null,null,{"$f":"'Data Entry'!C72","v":"Other"},{"$f":"'Data Entry'!D72","v":{"v":11255.0881,"d":"11,255 "}},{"$f":"'Data Entry'!E72","v":{"v":10000,"d":"10,000 "}},{"$f":"'Data Entry'!F72","v":{"v":10300,"d":"10,300 "}},{"$f":"'Data Entry'!G72","v":{"v":10609,"d":"10,609 "}},{"$f":"FORECAST($H$7,D72:G72,$D$7:$G$7)","v":{"v":10131.455950000032,"d":"10,131 "}},{"$f":"FORECAST($I$7,D72:H72,$D$7:$H$7)","v":{"v":9967.629520000017,"d":"9,968 "}},{"$f":"FORECAST($J$7,D72:I72,$D$7:$I$7)","v":{"v":9803.803090000001,"d":"9,804 "}},{"$f":"FORECAST($K$7,D72:J72,$D$7:$J$7)","v":{"v":9639.976659999986,"d":"9,640 "}},{"v":10927.27,"d":"10,927 "}]
[null,null,"Total Current Assets",{"$f":"SUM(D68:D72)","v":{"v":1367291.16891,"d":"1,367,291 "}},{"v":1212200,"d":"1,212,200 "},{"v":1250530,"d":"1,250,530 "},{"v":1287749.9,"d":"1,287,750 "},{"v":1229369.315544999,"d":"1,229,369 "},{"v":1209339.9348719986,"d":"1,209,340 "},{"v":1189310.5541989985,"d":"1,189,311 "},{"v":1169281.1735259981,"d":"1,169,281 "},{"v":1326692.397,"d":"1,326,692 "}]
[]
[null,null,"Long-Term Assets"]
[null,null,{"$f":"'Data Entry'!C76","v":"Property, plant, and equipment"},{"$f":"'Data Entry'!D76","v":{"v":2701221.1440000003,"d":"2,701,221 "}},{"$f":"'Data Entry'!E76","v":{"v":2400000,"d":"2,400,000 "}},{"$f":"'Data Entry'!F76","v":{"v":2472000,"d":"2,472,000 "}},{"$f":"'Data Entry'!G76","v":{"v":2546160,"d":"2,546,160 "}},{"$f":"FORECAST($H$7,D76:G76,$D$7:$G$7)","v":{"v":2431549.428000003,"d":"2,431,549 "}},{"$f":"FORECAST($I$7,D76:H76,$D$7:$H$7)","v":{"v":2392231.084800005,"d":"2,392,231 "}},{"$f":"FORECAST($J$7,D76:I76,$D$7:$I$7)","v":{"v":2352912.741600007,"d":"2,352,913 "}},{"$f":"FORECAST($K$7,D76:J76,$D$7:$J$7)","v":{"v":2313594.3984000087,"d":"2,313,594 "}},{"v":2622544.8,"d":"2,622,545 "}]
[null,null,{"$f":"'Data Entry'!C77","v":"Less accumulated depreciation"},{"$f":"'Data Entry'!D77","v":{"v":450203.524,"d":"450,204 "}},{"$f":"'Data Entry'!E77","v":{"v":400000,"d":"400,000 "}},{"$f":"'Data Entry'!F77","v":{"v":412000,"d":"412,000 "}},{"$f":"'Data Entry'!G77","v":{"v":424360,"d":"424,360 "}},{"$f":"FORECAST($H$7,D77:G77,$D$7:$G$7)","v":{"v":405258.23799999803,"d":"405,258 "}},{"$f":"FORECAST($I$7,D77:H77,$D$7:$H$7)","v":{"v":398705.18079999834,"d":"398,705 "}},{"$f":"FORECAST($J$7,D77:I77,$D$7:$I$7)","v":{"v":392152.12359999865,"d":"392,152 "}},{"$f":"FORECAST($K$7,D77:J77,$D$7:$J$7)","v":{"v":385599.06639999896,"d":"385,599 "}},{"v":437090.8,"d":"437,091 "}]
[null,null,{"$f":"'Data Entry'!C78","v":"Net property, plant, and equipment"},{"$f":"'Data Entry'!D78","v":{"v":2251017.62,"d":"2,251,018 "}},{"$f":"'Data Entry'!E78","v":{"v":2000000,"d":"2,000,000 "}},{"$f":"'Data Entry'!F78","v":{"v":2060000,"d":"2,060,000 "}},{"$f":"'Data Entry'!G78","v":{"v":2121800,"d":"2,121,800 "}},{"$f":"FORECAST($H$7,D78:G78,$D$7:$G$7)","v":{"v":2026291.1899999902,"d":"2,026,291 "}},{"$f":"FORECAST($I$7,D78:H78,$D$7:$H$7)","v":{"v":1993525.9039999917,"d":"1,993,526 "}},{"$f":"FORECAST($J$7,D78:I78,$D$7:$I$7)","v":{"v":1960760.6179999858,"d":"1,960,761 "}},{"$f":"FORECAST($K$7,D78:J78,$D$7:$J$7)","v":{"v":1927995.33199998,"d":"1,927,995 "}},{"$f":"+L76-L77","v":{"v":2185454,"d":"2,185,454 "}}]
[null,null,{"$f":"'Data Entry'!C79","v":"Other long-term assets"},{"$f":"'Data Entry'!D79","v":{"v":58765.264299999995,"d":"58,765 "}},{"$f":"'Data Entry'!E79","v":{"v":55000,"d":"55,000 "}},{"$f":"'Data Entry'!F79","v":{"v":55900,"d":"55,900 "}},{"$f":"'Data Entry'!G79","v":{"v":56827,"d":"56,827 "}},{"$f":"FORECAST($H$7,D79:G79,$D$7:$G$7)","v":{"v":55394.36784999992,"d":"55,394 "}},{"$f":"FORECAST($I$7,D79:H79,$D$7:$H$7)","v":{"v":54902.88855999999,"d":"54,903 "}},{"$f":"FORECAST($J$7,D79:I79,$D$7:$I$7)","v":{"v":54411.409269999946,"d":"54,411 "}},{"$f":"FORECAST($K$7,D79:J79,$D$7:$J$7)","v":{"v":53919.929980000015,"d":"53,920 "}},{"v":57781.81,"d":"57,782 "}]
[null,null,"Total Long-Term Assets",{"$f":"SUM(D78:D79)","v":{"v":2309782.8843,"d":"2,309,783 "}},{"v":2055000,"d":"2,055,000 "},{"v":2115900,"d":"2,115,900 "},{"v":2178627,"d":"2,178,627 "},{"v":2081685.5578499902,"d":"2,081,686 "},{"v":2048428.7925599916,"d":"2,048,429 "},{"v":2015172.0272699858,"d":"2,015,172 "},{"v":1981915.26197998,"d":"1,981,915 "},{"v":2243235.81,"d":"2,243,236 "}]
[]
[null,null,"Total Assets",{"$f":"D73+D80","v":{"v":3677074.05321,"d":"3,677,074 "}},{"v":3267200,"d":"3,267,200 "},{"v":3366430,"d":"3,366,430 "},{"v":3466376.9,"d":"3,466,377 "},{"v":3311054.8733949894,"d":"3,311,055 "},{"v":3257768.72743199,"d":"3,257,769 "},{"v":3204482.5814689845,"d":"3,204,483 "},{"v":3151196.435505978,"d":"3,151,196 "},{"v":3569928.2070000004,"d":"3,569,928 "}]
[]
[null,null,"LIABILITIES AND SHAREHOLDERS' EQUITY"]
[]
[null,null,"Current Liabilities"]
[null,null,{"$f":"'Data Entry'!C87","v":"Short-term debt"},{"$f":"'Data Entry'!D87","v":{"v":675305.286,"d":"675,305 "}},{"$f":"'Data Entry'!E87","v":{"v":600000,"d":"600,000 "}},{"$f":"'Data Entry'!F87","v":{"v":618000,"d":"618,000 "}},{"$f":"'Data Entry'!G87","v":{"v":636540,"d":"636,540 "}},{"$f":"FORECAST($H$7,D87:G87,$D$7:$G$7)","v":{"v":607887.3570000008,"d":"607,887 "}},{"$f":"FORECAST($I$7,D87:H87,$D$7:$H$7)","v":{"v":598057.7712000012,"d":"598,058 "}},{"$f":"FORECAST($J$7,D87:I87,$D$7:$I$7)","v":{"v":588228.1854000017,"d":"588,228 "}},{"$f":"FORECAST($K$7,D87:J87,$D$7:$J$7)","v":{"v":578398.5996000022,"d":"578,399 "}},{"v":655636.2,"d":"655,636 "}]
[null,null,{"$f":"'Data Entry'!C88","v":"Current maturities of long-term debt"},{"$f":"'Data Entry'!D88","v":{"v":112550.881,"d":"112,551 "}},{"$f":"'Data Entry'!E88","v":{"v":100000,"d":"100,000 "}},{"$f":"'Data Entry'!F88","v":{"v":103000,"d":"103,000 "}},{"$f":"'Data Entry'!G88","v":{"v":106090,"d":"106,090 "}},{"v":101314.55949999951,"d":"101,315 "},{"v":99676.29519999959,"d":"99,676 "},{"v":98038.03089999966,"d":"98,038 "},{"v":96399.76659999974,"d":"96,400 "},{"v":109272.7,"d":"109,273 "}]
[null,null,{"$f":"'Data Entry'!C89","v":"Accounts payable"},{"$f":"'Data Entry'!D89","v":{"v":112550.881,"d":"112,551 "}},{"$f":"'Data Entry'!E89","v":{"v":100000,"d":"100,000 "}},{"$f":"'Data Entry'!F89","v":{"v":103000,"d":"103,000 "}},{"$f":"'Data Entry'!G89","v":{"v":106090,"d":"106,090 "}},{"v":101314.55949999951,"d":"101,315 "},{"v":99676.29519999959,"d":"99,676 "},{"v":98038.03089999966,"d":"98,038 "},{"v":96399.76659999974,"d":"96,400 "},{"v":109272.7,"d":"109,273 "}]
[null,null,{"$f":"'Data Entry'!C90","v":"Income taxes payable"},{"$f":"'Data Entry'!D90","v":{"v":33765.264299999995,"d":"33,765 "}},{"$f":"'Data Entry'!E90","v":{"v":30000,"d":"30,000 "}},{"$f":"'Data Entry'!F90","v":{"v":30900,"d":"30,900 "}},{"$f":"'Data Entry'!G90","v":{"v":31827,"d":"31,827 "}},{"v":30394.367849999922,"d":"30,394 "},{"v":29902.888559999992,"d":"29,903 "},{"v":29411.409269999946,"d":"29,411 "},{"v":28919.929980000015,"d":"28,920 "},{"v":32781.81,"d":"32,782 "}]
[null,null,{"$f":"'Data Entry'!C91","v":"Accrued liabilities"},{"$f":"'Data Entry'!D91","v":{"v":101295.79289999999,"d":"101,296 "}},{"$f":"'Data Entry'!E91","v":{"v":90000,"d":"90,000 "}},{"$f":"'Data Entry'!F91","v":{"v":92700,"d":"92,700 "}},{"$f":"'Data Entry'!G91","v":{"v":95481,"d":"95,481 "}},{"v":91183.10355000012,"d":"91,183 "},{"v":89708.6656800001,"d":"89,709 "},{"v":88234.22781000007,"d":"88,234 "},{"v":86759.78994000051,"d":"86,760 "},{"v":98345.43,"d":"98,345 "}]
[null,null,{"$f":"'Data Entry'!C92","v":"Other"},{"$f":"'Data Entry'!D92","v":{"v":18008.14096,"d":"18,008 "}},{"$f":"'Data Entry'!E92","v":{"v":16000,"d":"16,000 "}},{"$f":"'Data Entry'!F92","v":{"v":16480,"d":"16,480 "}},{"$f":"'Data Entry'!G92","v":{"v":16974.4,"d":"16,974 "}},{"v":16210.329520000028,"d":"16,210 "},{"v":15948.207232000073,"d":"15,948 "},{"v":15686.084944000118,"d":"15,686 "},{"v":15423.962656000047,"d":"15,424 "},{"v":17483.632,"d":"17,484 "}]
[null,null,"Total Current Liabilities",{"$f":"SUM(D87:D92)","v":{"v":1053476.24616,"d":"1,053,476 "}},{"v":936000,"d":"936,000 "},{"v":964080,"d":"964,080 "},{"v":993002.4,"d":"993,002 "},{"v":948304.2769199999,"d":"948,304 "},{"v":932970.1230720006,"d":"932,970 "},{"v":917635.9692240012,"d":"917,636 "},{"v":902301.8153760022,"d":"902,302 "},{"v":1022792.4719999998,"d":"1,022,792 "}]
[]
[null,null,"Long-Term Liabilities"]
[null,null,{"$f":"'Data Entry'!C96","v":"Long-term debt less current maturities"},{"$f":"'Data Entry'!D96","v":{"v":692156.286,"d":"692,156 "}},{"$f":"'Data Entry'!E96","v":{"v":601200,"d":"601,200 "}},{"$f":"'Data Entry'!F96","v":{"v":624200,"d":"624,200 "}},{"$f":"'Data Entry'!G96","v":{"v":645630,"d":"645,630 "}},{"$f":"FORECAST($H$7,D96:G96,$D$7:$G$7)","v":{"v":611651.8570000008,"d":"611,652 "}},{"$f":"FORECAST($I$7,D96:H96,$D$7:$H$7)","v":{"v":599993.9712000042,"d":"599,994 "}},{"$f":"FORECAST($J$7,D96:I96,$D$7:$I$7)","v":{"v":588336.0854000039,"d":"588,336 "}},{"$f":"FORECAST($K$7,D96:J96,$D$7:$J$7)","v":{"v":576678.1996000037,"d":"576,678 "}},{"v":668308.2,"d":"668,308 "}]
[null,null,{"$f":"'Data Entry'!C97","v":"Deferred income taxes"},{"$f":"'Data Entry'!D97","v":{"v":112550.881,"d":"112,551 "}},{"$f":"'Data Entry'!E97","v":{"v":100000,"d":"100,000 "}},{"$f":"'Data Entry'!F97","v":{"v":103000,"d":"103,000 "}},{"$f":"'Data Entry'!G97","v":{"v":106090,"d":"106,090 "}},{"$f":"FORECAST($H$7,D97:G97,$D$7:$G$7)","v":{"v":101314.55949999951,"d":"101,315 "}},{"$f":"FORECAST($I$7,D97:H97,$D$7:$H$7)","v":{"v":99676.29519999959,"d":"99,676 "}},{"$f":"FORECAST($J$7,D97:I97,$D$7:$I$7)","v":{"v":98038.03089999966,"d":"98,038 "}},{"$f":"FORECAST($K$7,D97:J97,$D$7:$J$7)","v":{"v":96399.76659999974,"d":"96,400 "}},{"v":109272.7,"d":"109,273 "}]
[null,null,{"$f":"'Data Entry'!C98","v":"Other long-term liabilities"},{"$f":"'Data Entry'!D98","v":{"v":85903,"d":"85,903 "}},{"$f":"'Data Entry'!E98","v":{"v":79000,"d":"79,000 "}},{"$f":"'Data Entry'!F98","v":{"v":80650,"d":"80,650 "}},{"$f":"'Data Entry'!G98","v":{"v":82350,"d":"82,350 "}},{"$f":"FORECAST($H$7,D98:G98,$D$7:$G$7)","v":{"v":79723.5,"d":"79,724 "}},{"$f":"FORECAST($I$7,D98:H98,$D$7:$H$7)","v":{"v":78822.6000000001,"d":"78,823 "}},{"$f":"FORECAST($J$7,D98:I98,$D$7:$I$7)","v":{"v":77921.69999999995,"d":"77,922 "}},{"$f":"FORECAST($K$7,D98:J98,$D$7:$J$7)","v":{"v":77020.80000000005,"d":"77,021 "}},{"v":84101,"d":"84,101 "}]
[null,null,"Total Long-Term Liabilities",{"$f":"SUM(D96:D98)","v":{"v":890610.1669999999,"d":"890,610 "}},{"v":780200,"d":"780,200 "},{"v":807850,"d":"807,850 "},{"v":834070,"d":"834,070 "},{"v":792689.9165000003,"d":"792,690 "},{"v":778492.8664000039,"d":"778,493 "},{"v":764295.8163000036,"d":"764,296 "},{"v":750098.7662000034,"d":"750,099 "},{"v":861681.8999999999,"d":"861,682 "}]
[]
[null,null,"Total Liabilities",{"$f":"D93+D99","v":{"v":1944086.41316,"d":"1,944,086 "}},{"v":1716200,"d":"1,716,200 "},{"v":1771930,"d":"1,771,930 "},{"v":1827072.4,"d":"1,827,072 "},{"v":1740994.1934200001,"d":"1,740,994 "},{"v":1711462.9894720046,"d":"1,711,463 "},{"v":1681931.7855240046,"d":"1,681,932 "},{"v":1652400.5815760056,"d":"1,652,401 "},{"v":1884474.3719999997,"d":"1,884,474 "}]
[null,null,"Shareholders' Equity"]
[null,null,{"$f":"'Data Entry'!C103","v":"Common stock"},{"$f":"'Data Entry'!D103","v":{"v":100000,"d":"100,000 "}},{"$f":"'Data Entry'!E103","v":{"v":100000,"d":"100,000 "}},{"$f":"'Data Entry'!F103","v":{"v":100000,"d":"100,000 "}},{"$f":"'Data Entry'!G103","v":{"v":100000,"d":"100,000 "}},{"$f":"FORECAST($H$7,D103:G103,$D$7:$G$7)","v":{"v":100000,"d":"100,000 "}},{"$f":"FORECAST($I$7,D103:H103,$D$7:$H$7)","v":{"v":100000,"d":"100,000 "}},{"$f":"FORECAST($J$7,D103:I103,$D$7:$I$7)","v":{"v":100000,"d":"100,000 "}},{"$f":"FORECAST($K$7,D103:J103,$D$7:$J$7)","v":{"v":100000,"d":"100,000 "}},{"v":100000,"d":"100,000 "}]
[null,null,{"$f":"'Data Entry'!C104","v":"Additional paid-in capital"},{"$f":"'Data Entry'!D104","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!E104","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!F104","v":{"v":1000,"d":"1,000 "}},{"$f":"'Data Entry'!G104","v":{"v":1000,"d":"1,000 "}},{"$f":"FORECAST($H$7,D104:G104,$D$7:$G$7)","v":{"v":1000,"d":"1,000 "}},{"$f":"FORECAST($I$7,D104:H104,$D$7:$H$7)","v":{"v":1000,"d":"1,000 "}},{"$f":"FORECAST($J$7,D104:I104,$D$7:$I$7)","v":{"v":1000,"d":"1,000 "}},{"$f":"FORECAST($K$7,D104:J104,$D$7:$J$7)","v":{"v":1000,"d":"1,000 "}},{"v":1000,"d":"1,000 "}]
[null,null,{"$f":"'Data Entry'!C105","v":"Retained earnings"},{"$f":"'Data Entry'!D105","v":{"v":56275.4405,"d":"56,275 "}},{"$f":"'Data Entry'!E105","v":{"v":50000,"d":"50,000 "}},{"$f":"'Data Entry'!F105","v":{"v":51500,"d":"51,500 "}},{"$f":"'Data Entry'!G105","v":{"v":53045,"d":"53,045 "}},{"$f":"FORECAST($H$7,D105:G105,$D$7:$G$7)","v":{"v":50657.279749999754,"d":"50,657 "}},{"$f":"FORECAST($I$7,D105:H105,$D$7:$H$7)","v":{"v":49838.14759999979,"d":"49,838 "}},{"$f":"FORECAST($J$7,D105:I105,$D$7:$I$7)","v":{"v":49019.01544999983,"d":"49,019 "}},{"$f":"FORECAST($K$7,D105:J105,$D$7:$J$7)","v":{"v":48199.88329999987,"d":"48,200 "}},{"v":54636.35,"d":"54,636 "}]
[null,null,{"$f":"'Data Entry'!C106","v":"Other"},{"$f":"'Data Entry'!D106","v":{"v":1575712.334,"d":"1,575,712 "}},{"$f":"'Data Entry'!E106","v":{"v":1400000,"d":"1,400,000 "}},{"$f":"'Data Entry'!F106","v":{"v":1442000,"d":"1,442,000 "}},{"$f":"'Data Entry'!G106","v":{"v":1485260,"d":"1,485,260 "}},{"$f":"FORECAST($H$7,D106:G106,$D$7:$G$7)","v":{"v":1418403.8330000043,"d":"1,418,404 "}},{"$f":"FORECAST($I$7,D106:H106,$D$7:$H$7)","v":{"v":1395468.1328000054,"d":"1,395,468 "}},{"$f":"FORECAST($J$7,D106:I106,$D$7:$I$7)","v":{"v":1372532.4326000065,"d":"1,372,532 "}},{"$f":"FORECAST($K$7,D106:J106,$D$7:$J$7)","v":{"v":1349596.7324000075,"d":"1,349,597 "}},{"v":1529817.8,"d":"1,529,818 "}]
[null,null,"Total Shareholders' Equity",{"$f":"SUM(D103:D106)","v":{"v":1732987.7745,"d":"1,732,988 "}},{"v":1551000,"d":"1,551,000 "},{"v":1594500,"d":"1,594,500 "},{"v":1639305,"d":"1,639,305 "},{"v":1570061.112750004,"d":"1,570,061 "},{"v":1546306.2804000052,"d":"1,546,306 "},{"v":1522551.4480500063,"d":"1,522,551 "},{"v":1498796.6157000074,"d":"1,498,797 "},{"v":1685454.1500000001,"d":"1,685,454 "}]
[]
[null,null,"Total Liabilities and Shareholders' Equity",{"$f":"D93+D99+D107","v":{"v":3677074.1876600003,"d":"3,677,074 "}},{"v":3267200,"d":"3,267,200 "},{"v":3366430,"d":"3,366,430 "},{"v":3466377.4,"d":"3,466,377 "},{"v":3311055.3061700044,"d":"3,311,055 "},{"v":3257769.2698720098,"d":"3,257,769 "},{"v":3204483.233574011,"d":"3,204,483 "},{"v":3151197.197276013,"d":"3,151,197 "},{"v":3569928.522,"d":"3,569,929 "}]