{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["WACC","Income Statement","Balance Sheet","FCFF"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"WACC","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,"Rf",1.7299999999999999E-2]
[null,null,null,null,null,"Beta",0.66]
[null,null,null,null,null,"MRP",0.06]
[]
[null,null,null,null,null,"Adjusted Beta",{"$f":"2/3*G5+1/3","v":0.77333333333333332}]
[]
[null,null,null,null,null,"Rs",{"$f":"G4+G5*G6","v":5.6900000000000006E-2}]
[]
[null,null,null,null,null,"Cost of Debt",null,null,"Tax Rate",{"$f":"'Income Statement'!D32","v":0.24615904102650685}]
[]
[null,null,null,null,null,"Interest Expense",{"$f":"'Income Statement'!D18","v":626000}]
[null,null,null,null,null,"Average Net Debt",{"$f":"'Balance Sheet'!D47","v":32883500}]
[]
[null,null,null,null,null,"Rd",{"$f":"G14/G15","v":1.9036903006066874E-2},null,"rd(1-t)",{"$f":"G17*(1-J12)","v":1.4350797217978826E-2}]
[]
[null,null,null,null,null,"WACC",null,"Weights"]
[null,null,null,null,null,"Total Debt",30.35,{"$f":"G20/G22","v":0.12020754119138151}]
[null,null,null,null,null,"Total Equity (MV)",222.13,{"$f":"G21/G22","v":0.87979245880861856}]
[null,null,null,null,null,"Total",{"$f":"G21+G20","v":252.48}]
[]
[null,null,null,null,null,"WACC",{"$f":"H20*J17+G10*H21","v":5.1785264953919753E-2}]

{"sheet":"Income Statement","index":1,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Gross Profit Margin",{"$f":"D7/D5","v":0.49034465580303882},{"$f":"E7/E5","v":0.49062228294621785},0.50083628738329422]
[]
[null,null,"Period Ending","2015-06-30","2014-06-30","2013-06-30"]
[null,null,"Total Revenue",76279000,80510000,80116000]
[null,null,"Cost of Revenue",38876000,41010000,39991000]
[null,null,"Gross Profit",37403000,39500000,40125000]
[null,null,"Operating Expenses"]
[null,null,"Research Development","-  ","-  ","-  "]
[null,null,"Selling General and Administrative",25613000,24760000,26000000]
[null,null,"Non Recurring","-  ","-  ",308000]
[null,null,"Others","-  ","-  ","-  "]
[null,null,"Total Operating Expenses","-  ","-  ","-  "]
[null,null,"Operating Income or Loss",11790000,14740000,13817000]
[null,null,"Income from Continuing Operations"]
[null,null,"Total Other Income/Expenses Net",682000,307000,1029000]
[null,null,"Earnings Before Interest And Taxes",12472000,15047000,14846000]
[null,null,"Interest Expense",626000,710000,667000]
[null,null,"Income Before Tax",11846000,14337000,14179000]
[null,null,"Income Tax Expense",2916000,3019000,3226000]
[null,null,"Minority Interest",-108000,-142000,-90000]
[null,null,"Net Income From Continuing Ops",8930000,11318000,10953000]
[null,null,"Non-recurring Events"]
[null,null,"Discontinued Operations",-1786000,467000,449000]
[null,null,"Extraordinary Items","-  ","-  ","-  "]
[null,null,"Effect Of Accounting Changes","-  ","-  ","-  "]
[null,null,"Other Items","-  ","-  ","-  "]
[null,null,"Net Income",7036000,11643000,11312000]
[null,null,"Preferred Stock And Other Adjustments","-  ","-  ","-  "]
[null,null,"Net Income Applicable To Common Shares",7036000,11643000,11312000]
[]
[null,null,"Tax Rate",{"$f":"D20/D19","v":0.24615904102650685},{"$f":"E20/E19","v":0.21057403919927462},0.22751957119684041]
[]
[null,null,"ROE",{"$f":"D28/'Balance Sheet'!D42","v":0.11272208782582227},{"$f":"E28/'Balance Sheet'!E42","v":0.16821741266217818},{"$f":"F28/'Balance Sheet'!F42","v":0.16619652092148565}]

{"sheet":"Balance Sheet","index":2,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Period Ending","2015-06-30","2014-06-30","2013-06-30"]
[null,null,"Assets"]
[null,null,"Current Assets"]
[null,null,"Cash And Cash Equivalents",6845000,8558000,5947000]
[null,null,"Short Term Investments",4767000,2128000,"-  "]
[null,null,"Net Receivables",6217000,7478000,7456000]
[null,null,"Inventory",5454000,6759000,6909000]
[null,null,"Other Current Assets",6363000,6694000,3678000]
[null,null,"Total Current Assets",29646000,31617000,23990000]
[null,null,"Long Term Investments","-  ","-  ","-  "]
[null,null,"Property Plant and Equipment",20268000,22304000,21666000]
[null,null,"Goodwill",47316000,53704000,55188000]
[null,null,"Intangible Assets",26829000,30843000,31572000]
[null,null,"Accumulated Amortization","-  ","-  ","-  "]
[null,null,"Other Assets",5436000,5798000,6847000]
[null,null,"Deferred Long Term Asset Charges","-  ","-  ","-  "]
[null,null,"Total Assets",129495000,144266000,139263000]
[null,null,"Liabilities"]
[null,null,"Current Liabilities"]
[null,null,"Accounts Payable",16582000,17460000,17605000]
[null,null,"Short/Current Long Term Debt",12021000,15606000,12432000]
[null,null,"Other Current Liabilities",1187000,660000,"-  "]
[null,null,"Total Current Liabilities",29790000,33726000,30037000]
[null,null,"Long Term Debt",18329000,19811000,19111000]
[null,null,"Other Liabilities",8795000,10535000,10579000]
[null,null,"Deferred Long Term Liability Charges",9531000,10218000,10827000]
[null,null,"Minority Interest",631000,762000,645000]
[null,null,"Negative Goodwill","-  ","-  ","-  "]
[null,null,"Total Liabilities",67076000,75052000,71199000]
[null,null,"Stockholders' Equity"]
[null,null,"Misc Stocks Options Warrants","-  ","-  ","-  "]
[null,null,"Redeemable Preferred Stock","-  ","-  ","-  "]
[null,null,"Preferred Stock",1077000,1111000,1137000]
[null,null,"Common Stock",4009000,4009000,4009000]
[null,null,"Retained Earnings",84807000,84990000,80197000]
[null,null,"Treasury Stock",-77226000,-75805000,-71966000]
[null,null,"Capital Surplus",63852000,63911000,63538000]
[null,null,"Other Stockholder Equity",-14100000,-9002000,-8851000]
[null,null,"Total Stockholder Equity",62419000,69214000,68064000]
[null,null,"Net Tangible Assets",-11726000,-15333000,-18696000]
[]
[null,null,"Total Debt",{"$f":"D27+D24","v":30350000},{"$f":"E27+E24","v":35417000}]
[]
[null,null,"Average Debt",{"$f":"AVERAGE(D45:E45)","v":32883500}]

{"sheet":"FCFF","index":3,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Period Ending","2015-06-30","2014-06-30","2013-06-30"]
[null,null,"Net Income",7036000,11643000,11312000]
[null,null,"Operating Activities, Cash Flows Provided By or Used In"]
[null,null,"Depreciation",3134000,3141000,2982000]
[null,null,"Adjustments To Net Income",2970000,162000,-569000]
[null,null,"Changes In Accounts Receivables",349000,87000,-415000]
[null,null,"Changes In Liabilities",928000,1000,1253000]
[null,null,"Changes In Inventories",313000,8000,-225000]
[null,null,"Changes In Other Operating Activities",-230000,-1226000,445000]
[null,null,"Total Cash Flow From Operating Activities",14608000,13958000,14873000]
[null,null,"Investing Activities, Cash Flows Provided By or Used In"]
[null,null,"Capital Expenditures",-3736000,-3848000,-4008000]
[null,null,"Investments",-2607000,-805000,-1726000]
[null,null,"Other Cash flows from Investing Activities",3452000,546000,-561000]
[null,null,"Total Cash Flows From Investing Activities",-2891000,-4107000,-6295000]
[null,null,"Financing Activities, Cash Flows Provided By or Used In"]
[null,null,"Dividends Paid",-7287000,-6911000,-6519000]
[null,null,"Sale Purchase of Stock",-1778000,-3911000,-2537000]
[null,null,"Net Borrowings",-3954000,3543000,1985000]
[null,null,"Other Cash Flows from Financing Activities","-  ","-  ","-  "]
[null,null,"Total Cash Flows From Financing Activities",-13019000,-7279000,-7071000]
[null,null,"Effect Of Exchange Rate Changes",-411000,39000,4000]
[null,null,"Change In Cash and Cash Equivalents",-1713000,2611000,1511000]
[]
[null,null,"CFO",{"$f":"D12","v":14608000},{"$f":"E12","v":13958000},14873000]
[null,null,"+ Interest (1-T)",{"$f":"'Income Statement'!D18*(1-'Income Statement'!D32)","v":471904.44031740667},{"$f":"'Income Statement'!E18*(1-'Income Statement'!E32)","v":560492.43216851505},{"$f":"'Income Statement'!F18*(1-'Income Statement'!F32)","v":515244.44601170742}]
[null,null,"- Capital Exp",{"$f":"D14","v":-3736000},{"$f":"E14","v":-3848000},-4008000]
[null,null,"FCFF",{"$f":"SUM(D27:D29)","v":11343904.440317407},{"$f":"SUM(E27:E29)","v":10670492.432168515},11380244.446011707]
[]
[null,null,"G",1.7999999999999999E-2]
[null,null,"WACC",{"$f":"WACC!G24","v":5.1785264953919753E-2}]
[]
[null,null,"Firm's Value",{"$f":"D30*(1+D32)/(D33-D32)","v":341808617.92837036}]
[null,null,"Deduct Debt",{"$f":"-'Balance Sheet'!D45","v":-30350000}]
[null,null,"Deduce Pref. Stock",{"$f":"-'Balance Sheet'!D36","v":-1077000}]
[null,null,"Add Cash and Cash Equiv.",{"$f":"'Balance Sheet'!D7","v":6845000}]
[null,null,"minority Interest",{"$f":"-'Balance Sheet'!D30","v":-631000}]
[null,null,"Total Equity",{"$f":"1000*SUM(D35:D39)","v":316595617928.37036}]
[]
[null,null,"Shares Outstanding",{"$f":"2700000000","v":2700000000}]
[]
[null,null,"Equity",{"$f":"D40/D42","v":117.25763626976681}]
[]
[]
[null,null,{"$f":"D44","v":117.25763626976681},0.01,1.4999999999999999E-2,0.02,0.02,2.5000000000000001E-2,0.03]
[null,null,0.05,96.748365599264659,112.50378843303878,133.51101887807104,133.51101887807104,162.92114150111615,207.03632543568386]
[null,null,5.5E-2,84.960975182885448,97.273546360390426,113.1039950171826,113.1039950171826,134.21125989290545,163.76143071891747]
[null,null,0.06,75.531062849782089,85.427802526108366,97.798727121516265,97.798727121516265,113.70420160132639,134.91150090773988]
[null,null,6.5000000000000002E-2,67.815680031788432,75.951207458682717,85.894629869331311,85.894629869331311,98.323907882642047,114.30440818547015]
[null,null,7.0000000000000007E-2,61.386194350127042,68.197629676243551,76.371352067583373,76.371352067583373,86.361457212554242,98.849088643767857]
[null,null,7.4999999999999997E-2,55.945860311798185,61.736314857544237,68.579579320698699,68.579579320698699,76.791496676484016,86.828284555777202]
[null,null,0.08,51.282716850373447,56.269048472490972,62.08643536496146,62.08643536496146,68.961528965153818,77.211641285384658]