{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["5 Year Projections"],"not_rendered":{"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"5 Year Projections","index":0,"n_rows":40,"n_cols":10,"rows_kept":40,"merged":[[2,3,3,9]]}
[]
[{"$nulls":3},"Five Year Projections"]
[{"$nulls":3},"This worksheet estimates the key financial figures for a company over five years.  The projections include abbreviated income and cash flow statements, and a balance sheet."]
[]
[]
[{"$nulls":3},"Years",null,2005,{"$f":"F6+1","v":2006},{"$f":"G6+1","v":2007},{"$f":"H6+1","v":2008},{"$f":"I6+1","v":2009}]
[{"$nulls":3},"Income Statement"]
[{"$nulls":3},"Net sales",null,{"v":43300,"d":"$43,300"},{"v":67900,"d":"$67,900"},{"v":77300,"d":"$77,300"},{"v":80200,"d":"$80,200"},{"v":88100,"d":"$88,100"}]
[{"$nulls":3},"Cost of goods sold",null,{"v":24100,"d":"$24,100"},{"v":24600,"d":"$24,600"},{"v":20800,"d":"$20,800"},{"v":21900,"d":"$21,900"},{"v":39500,"d":"$39,500"}]
[{"$nulls":3},"Net Operating Income",null,{"$f":"IF(OR(F8<>0,F9),F8-F9,\"\")","v":{"v":19200,"d":"$19,200"}},{"$f":"IF(OR(G8<>0,G9),G8-G9,\"\")","v":{"v":43300,"d":"$43,300"}},{"$f":"IF(OR(H8<>0,H9),H8-H9,\"\")","v":{"v":56500,"d":"$56,500"}},{"$f":"IF(OR(I8<>0,I9),I8-I9,\"\")","v":{"v":58300,"d":"$58,300"}},{"$f":"IF(OR(J8<>0,J9),J8-J9,\"\")","v":{"v":48600,"d":"$48,600"}}]
[{"$nulls":3},"Operating expenses",null,{"v":3500,"d":"$3,500"},{"v":3900,"d":"$3,900"},{"v":2100,"d":"$2,100"},{"v":3000,"d":"$3,000"},{"v":3600,"d":"$3,600"}]
[{"$nulls":4},"Net Income",{"$f":"IF(OR(F10<>0,F11),F10-F11,\"\")","v":{"v":15700,"d":"$15,700"}},{"$f":"IF(OR(G10<>0,G11),G10-G11,\"\")","v":{"v":39400,"d":"$39,400"}},{"$f":"IF(OR(H10<>0,H11),H10-H11,\"\")","v":{"v":54400,"d":"$54,400"}},{"$f":"IF(OR(I10<>0,I11),I10-I11,\"\")","v":{"v":55300,"d":"$55,300"}},{"$f":"IF(OR(J10<>0,J11),J10-J11,\"\")","v":{"v":45000,"d":"$45,000"}}]
[]
[]
[{"$nulls":3},"Cash Flow Statement"]
[{"$nulls":3},"Beginning balance",null,{"v":14500,"d":"$14,500"},{"$f":"IF(F19,F19,\"\")","v":{"v":13300,"d":"$13,300"}},{"$f":"IF(G19,G19,\"\")","v":{"v":15500,"d":"$15,500"}},{"$f":"IF(H19,H19,\"\")","v":{"v":18000,"d":"$18,000"}},{"$f":"IF(I19,I19,\"\")","v":{"v":20000,"d":"$20,000"}}]
[{"$nulls":3},"Cash inflow",null,{"v":7000,"d":"$7,000"},{"v":7600,"d":"$7,600"},{"v":9400,"d":"$9,400"},{"v":9900,"d":"$9,900"},{"v":7000,"d":"$7,000"}]
[{"$nulls":3},"Cash outflow",null,{"v":-8200,"d":"($8,200)"},{"v":-5400,"d":"($5,400)"},{"v":-6900,"d":"($6,900)"},{"v":-7900,"d":"($7,900)"},{"v":-8900,"d":"($8,900)"}]
[{"$nulls":4},"Ending Cash Balance",{"$f":"IF(SUM(F16:F18),SUM(F16:F18),\"\")","v":{"v":13300,"d":"$13,300"}},{"$f":"IF(SUM(G16:G18),SUM(G16:G18),\"\")","v":{"v":15500,"d":"$15,500"}},{"$f":"IF(SUM(H16:H18),SUM(H16:H18),\"\")","v":{"v":18000,"d":"$18,000"}},{"$f":"IF(SUM(I16:I18),SUM(I16:I18),\"\")","v":{"v":20000,"d":"$20,000"}},{"$f":"IF(SUM(J16:J18),SUM(J16:J18),\"\")","v":{"v":18100,"d":"$18,100"}}]
[]
[]
[{"$nulls":3},"Balance Sheet"]
[{"$nulls":3},"Cash",null,{"$f":"F19","v":{"v":13300,"d":"$13,300"}},{"$f":"G19","v":{"v":15500,"d":"$15,500"}},{"$f":"H19","v":{"v":18000,"d":"$18,000"}},{"$f":"I19","v":{"v":20000,"d":"$20,000"}},{"$f":"J19","v":{"v":18100,"d":"$18,100"}}]
[{"$nulls":3},"Accounts receivable",null,{"v":17600,"d":"$17,600"},{"v":13800,"d":"$13,800"},{"v":19800,"d":"$19,800"},{"v":19500,"d":"$19,500"},{"v":21800,"d":"$21,800"}]
[{"$nulls":3},"Inventory",null,{"v":6300,"d":"$6,300"},{"v":8200,"d":"$8,200"},{"v":9300,"d":"$9,300"},{"v":9400,"d":"$9,400"},{"v":11200,"d":"$11,200"}]
[{"$nulls":3},"Prepaid expenses",null,{"v":5700,"d":"$5,700"},{"v":6300,"d":"$6,300"},{"v":5800,"d":"$5,800"},{"v":3200,"d":"$3,200"},{"v":2700,"d":"$2,700"}]
[{"$nulls":4},"Total Current Assets",{"$f":"IF(SUM(F23:F26),SUM(F23:F26),\"\")","v":{"v":42900,"d":"$42,900"}},{"$f":"IF(SUM(G23:G26),SUM(G23:G26),\"\")","v":{"v":43800,"d":"$43,800"}},{"$f":"IF(SUM(H23:H26),SUM(H23:H26),\"\")","v":{"v":52900,"d":"$52,900"}},{"$f":"IF(SUM(I23:I26),SUM(I23:I26),\"\")","v":{"v":52100,"d":"$52,100"}},{"$f":"IF(SUM(J23:J26),SUM(J23:J26),\"\")","v":{"v":53800,"d":"$53,800"}}]
[{"$nulls":3},"Fixed assets",null,{"v":28000,"d":"$28,000"},{"v":30500,"d":"$30,500"},{"v":45000,"d":"$45,000"},{"v":43000,"d":"$43,000"},{"v":41000,"d":"$41,000"}]
[{"$nulls":4},"Total Assets",{"$f":"IF(SUM(F27:F28),SUM(F27:F28),\"\")","v":{"v":70900,"d":"$70,900"}},{"$f":"IF(SUM(G27:G28),SUM(G27:G28),\"\")","v":{"v":74300,"d":"$74,300"}},{"$f":"IF(SUM(H27:H28),SUM(H27:H28),\"\")","v":{"v":97900,"d":"$97,900"}},{"$f":"IF(SUM(I27:I28),SUM(I27:I28),\"\")","v":{"v":95100,"d":"$95,100"}},{"$f":"IF(SUM(J27:J28),SUM(J27:J28),\"\")","v":{"v":94800,"d":"$94,800"}}]
[]
[]
[{"$nulls":3},"Accounts payable",null,{"v":6400,"d":"$6,400"},{"v":6200,"d":"$6,200"},{"v":9800,"d":"$9,800"},{"v":7600,"d":"$7,600"},{"v":8200,"d":"$8,200"}]
[{"$nulls":3},"Short-term notes",null,{"v":5700,"d":"$5,700"},{"v":5500,"d":"$5,500"},{"v":4800,"d":"$4,800"},{"v":5400,"d":"$5,400"},{"v":7700,"d":"$7,700"}]
[{"$nulls":3},"Accrued & other liabilities",null,{"v":2300,"d":"$2,300"},{"v":2300,"d":"$2,300"},{"v":3000,"d":"$3,000"},{"v":2900,"d":"$2,900"},{"v":2700,"d":"$2,700"}]
[{"$nulls":4},"Total Current Liabilities",{"$f":"IF(SUM(F32:F34),SUM(F32:F34),\"\")","v":{"v":14400,"d":"$14,400"}},{"$f":"IF(SUM(G32:G34),SUM(G32:G34),\"\")","v":{"v":14000,"d":"$14,000"}},{"$f":"IF(SUM(H32:H34),SUM(H32:H34),\"\")","v":{"v":17600,"d":"$17,600"}},{"$f":"IF(SUM(I32:I34),SUM(I32:I34),\"\")","v":{"v":15900,"d":"$15,900"}},{"$f":"IF(SUM(J32:J34),SUM(J32:J34),\"\")","v":{"v":18600,"d":"$18,600"}}]
[{"$nulls":3},"Long-term debt",null,{"v":22100,"d":"$22,100"},{"v":23700,"d":"$23,700"},{"v":22600,"d":"$22,600"},{"v":21800,"d":"$21,800"},{"v":22400,"d":"$22,400"}]
[{"$nulls":3},"Other long-term liabilities",null,{"v":1400,"d":"$1,400"},{"v":1800,"d":"$1,800"},{"v":1400,"d":"$1,400"},{"v":1000,"d":"$1,000"},{"v":1700,"d":"$1,700"}]
[{"$nulls":4},"Total Long-term Liabilities",{"$f":"IF(SUM(F36:F37),SUM(F36:F37),\"\")","v":{"v":23500,"d":"$23,500"}},{"$f":"IF(SUM(G36:G37),SUM(G36:G37),\"\")","v":{"v":25500,"d":"$25,500"}},{"$f":"IF(SUM(H36:H37),SUM(H36:H37),\"\")","v":{"v":24000,"d":"$24,000"}},{"$f":"IF(SUM(I36:I37),SUM(I36:I37),\"\")","v":{"v":22800,"d":"$22,800"}},{"$f":"IF(SUM(J36:J37),SUM(J36:J37),\"\")","v":{"v":24100,"d":"$24,100"}}]
[{"$nulls":3},"Shareholders' equity",null,{"$f":"IF(OR(OR(F40<>0,F38),F35),F40-F38-F35,\"\")","v":{"v":33000,"d":"$33,000"}},{"$f":"IF(OR(OR(G40<>0,G38),G35),G40-G38-G35,\"\")","v":{"v":34800,"d":"$34,800"}},{"$f":"IF(OR(OR(H40<>0,H38),H35),H40-H38-H35,\"\")","v":{"v":56300,"d":"$56,300"}},{"$f":"IF(OR(OR(I40<>0,I38),I35),I40-I38-I35,\"\")","v":{"v":56400,"d":"$56,400"}},{"$f":"IF(OR(OR(J40<>0,J38),J35),J40-J38-J35,\"\")","v":{"v":52100,"d":"$52,100"}}]
[{"$nulls":3},"Total Liabilities and Equity",null,{"$f":"F29","v":{"v":70900,"d":"$70,900"}},{"$f":"G29","v":{"v":74300,"d":"$74,300"}},{"$f":"H29","v":{"v":97900,"d":"$97,900"}},{"$f":"I29","v":{"v":95100,"d":"$95,100"}},{"$f":"J29","v":{"v":94800,"d":"$94,800"}}]