{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Index","Instructions","Ratios Introduction","Income Statement","Balance Sheet","EPS","GP Margin","NP Margin","ROA","ROE","Current Ratio","Quick Ratio","ACP","ITO","Debt Ratio","Equity Ratio","TIE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":76,"comments":3,"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":"Index","index":0,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Ratio Analysis"]
[]
[]
[null,null," "]

{"sheet":"Instructions","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Instructions"]
[null,null,null,"Please Read This Page Carefully"]
[]
[]
[null,null,null,"Data Entry"]
[null,null,null,"The \"Income Statement\" and \"Balance Sheet\" are your two data entry worksheets."]
[null,null,null,"Navigation:"]
[null,null,null,"1. The \"Index Worksheet\" is your transportation page. All pages have a return button to it."]
[null,null,null,"Additional Instructions:"]
[null,null,null,"1. Look for the red corner triangles for additional instructions on the worksheets. For example:>>>>",null,null,null,null,null,null,null,"Point Here"]
[null,null,null,"Printing:"]
[null,null,null,"1. Be sure to \"Print Preview\" before printing a page. All pages are setup to print."]
[null,null,null,"2. You may print multiple pages by holding down the CONTROL-KEY and clicking on individual TABS or"]
[null,null,null,"    Right click on a tab and \"select all sheets\"."]

{"sheet":"Ratios Introduction","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Income Statement","index":3,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," ",null,"Forecasted",null,null,null,"Total"]
[null,null,null,null,null,null,null,null,"1ST QTR","2ND QTR","3RD QTR","4TH QTR",1999]
[null,null,null,null,null,"Sales"]
[null,null,null,null,null,null,"Sales",null,2000000,1500000,1300000,2010100,{"$f":"SUM(I16:L16)","v":6810100}]
[null,null,null,null,null,null,"Cost of sales",null,{"$f":"SUM(I45:I47)","v":945000},{"$f":"SUM(J45:J47)","v":865000},{"$f":"SUM(K45:K47)","v":833000},{"$f":"SUM(L45:L47)","v":946616},{"$f":"SUM(I17:L17)","v":3589616}]
[]
[null,null,null,null,null,null,null,"Gross profit  ",{"$f":"I16-I17","v":1055000},{"$f":"J16-J17","v":635000},{"$f":"K16-K17","v":467000},{"$f":"L16-L17","v":1063484},{"$f":"M16-M17","v":3220484}]
[]
[null,null,null,null,null,"Expenses"]
[null,null,null,null,null,null,"Operating expenses",null,424000,318000,275600,426141.2,{"$f":"SUM(I22:L22)","v":1443741.2}]
[null,null,null,null,null,null,"Interest",null,16250,16250,16250,16250,{"$f":"SUM(I23:L23)","v":65000}]
[null,null,null,null,null,null,"Depreciation",null,32500,33958,33958,33958,{"$f":"SUM(I24:L24)","v":134374}]
[null,null,null,null,null,null,"Amortization",null,1250,1250,1250,1250,{"$f":"SUM(I25:L25)","v":5000}]
[null,null,null,null,null,null,null,"Total expenses  ",{"$f":"SUM(I22:I25)","v":474000},{"$f":"SUM(J22:J25)","v":369458},{"$f":"SUM(K22:K25)","v":327058},{"$f":"SUM(L22:L25)","v":477599.2},{"$f":"SUM(M22:M25)","v":1648115.2}]
[]
[null,null,null,null,null,null,null,"Operating income  ",{"$f":"I19-I26","v":581000},{"$f":"J19-J26","v":265542},{"$f":"K19-K26","v":139942},{"$f":"L19-L26","v":585884.80000000005},{"$f":"M19-M26","v":1572368.8}]
[]
[null,null,null,null,null,"Other income and expenses"]
[null,null,null,null,null,null,"Gain (loss) on sale of assets",null,100000,10000,3000,405700,{"$f":"SUM(I31:L31)","v":518700}]
[null,null,null,null,null,null,"Other (net)",null,20000,50000,100000,200000,{"$f":"SUM(I32:L32)","v":370000}]
[null,null,null,null,null,null,null,"Subtotal  ",{"$f":"I31+I32","v":120000},{"$f":"J31+J32","v":60000},{"$f":"K31+K32","v":103000},{"$f":"L31+L32","v":605700},{"$f":"M31+M32","v":888700}]
[]
[]
[null,null,null,null,null,null,null,"Income before tax  ",{"$f":"I28+I33","v":701000},{"$f":"J28+J33","v":325542},{"$f":"K28+K33","v":242942},{"$f":"L28+L33","v":1191584.8},{"$f":"M28+M33","v":2461068.7999999998}]
[null,null,null,null,null,null,"Please enter  a tax percentage"]
[null,null,null,null,null,null,"Taxes @",0.3,{"$f":"0.3*I36","v":210300},{"$f":"0.3*J36","v":97662.599999999991},{"$f":"0.3*K36","v":72882.599999999991},{"$f":"0.3*L36","v":357475.44},{"$f":"SUM(H38:L38)","v":738320.94}]
[]
[null,null,null,null,null,null,null,"Net income  ",{"$f":"I36-I38","v":490700},{"$f":"J36-J38","v":227879.40000000002},{"$f":"K36-K38","v":170059.40000000002},{"$f":"L36-L38","v":834109.3600000001},{"$f":"SUM(I40:L40)","v":1722748.1600000001}]
[]
[null,null,null,null,null,"Detailed Supporting Information"]
[]
[null,null,null,null,null,"Cost of sales"]
[null,null,null,null,null,null,null,"Direct labor  ",320000,240000,208000,321616,{"$f":"SUM(I45:L45)","v":1089616}]
[null,null,null,null,null,null,null,"Materials  ",500000,500000,500000,500000,{"$f":"SUM(I46:L46)","v":2000000}]
[null,null,null,null,null,null,null,"Other costs  ",125000,125000,125000,125000,{"$f":"SUM(I47:L47)","v":500000}]

{"sheet":"Balance Sheet","index":4,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," ",null,"Actual","Forecast"]
[null,null,null,null,null,null,null,null,2002,"1ST QTR","2ND QTR","3RD QTR","4TH QTR"]
[null,null,null,null,null,"ASSETS"]
[null,null,null,null,null,"Current Assets"]
[null,null,null,null,null,null,"Cash and cash equivalents",null,451000,90360,229233,469196,-945586]
[null,null,null,null,null,null,"Accounts receivable",null,350000,657534,493151,427397,660855]
[null,null,null,null,null,null,"Inventory",null,400000,630411,590959,575178,1186002]
[null,null,null,null,null,null,"Other current assets",null,10000,60000,45090,76320,50000]
[null,null,null,null,null,null,null,"Total Current Assets  ",{"$f":"SUM(I18:I21)","v":1211000},{"$f":"SUM(J18:J21)","v":1438305},{"$f":"SUM(K18:K21)","v":1358433},{"$f":"SUM(L18:L21)","v":1548091},{"$f":"SUM(M18:M21)","v":951271}]
[]
[null,null,null,null,null,"Fixed Assets"]
[null,null,null,null,null,null,"Land",null,100000,112500,125000,137500,150000]
[null,null,null,null,null,null,"Buildings",null,1500000,1450000,1450000,1450000,1450000]
[null,null,null,null,null,null,"Equipment",null,800000,875000,875000,875000,875000]
[null,null,null,null,null,null,null,"Subtotal  ",{"$f":"SUM(I25:I27)","v":2400000},{"$f":"SUM(J25:J27)","v":2437500},{"$f":"SUM(K25:K27)","v":2450000},{"$f":"SUM(L25:L27)","v":2462500},{"$f":"SUM(M25:M27)","v":2475000}]
[null,null,null,null,null,null,"Less-accumulated depreciation",null,400000,432500,466458,500416,534374]
[null,null,null,null,null,null,null,"Total Fixed Assets  ",{"$f":"I28-I29","v":2000000},{"$f":"J28-J29","v":2005000},{"$f":"K28-K29","v":1983542},{"$f":"L28-L29","v":1962084},{"$f":"M28-M29","v":1940626}]
[]
[null,null,null,null,null,"Intangible Assets"]
[null,null,null,null,null,null,"Cost",null,50000,50000,50000,50000,50000]
[null,null,null,null,null,null,"Less-accumulated amortization",null,20000,21250,22500,23750,25000]
[null,null,null,null,null,null,null,"Total Intangible Assets  ",{"$f":"I33-I34","v":30000},{"$f":"J33-J34","v":28750},{"$f":"K33-K34","v":27500},{"$f":"L33-L34","v":26250},{"$f":"M33-M34","v":25000}]
[]
[null,null,null,null,null,"Other assets",null,null,25000,33000,120000,5000,23000]
[null,null,null,null,null,null,null,"Total Assets  ",{"$f":"I35+I30+I22+I37","v":3266000},{"$f":"J35+J30+J22+J37","v":3505055},{"$f":"K35+K30+K22+K37","v":3489475},{"$f":"L35+L30+L22+L37","v":3541425},{"$f":"M35+M30+M22+M37","v":2939897}]
[]
[null,null,null,null,null,null,null,null,"Actual","Forecast"]
[null,null,null,null,null,"LIABILITIES AND",null,null,1999,"1ST QTR","2ND QTR","3RD QTR","4TH QTR"]
[null,null,null,null,null,"STOCKHOLDERS' EQUITY"]
[null,null,null,null,null,"Current Liabilities"]
[null,null,null,null,null,null,"Accounts payable",null,600000,328767,328767,328767,328767]
[null,null,null,null,null,null,"Notes payable",null,100000,50000,50000,50000,50000]
[null,null,null,null,null,null,"Current portion of long-term debt",null,100000,100000,100000,100000,100000]
[null,null,null,null,null,null,"Income taxes",null,30000,183300,52663,14983,-188735]
[null,null,null,null,null,null,"Accrued expenses",null,90000,83288,62466,54137,83708]
[null,null,null,null,null,null,"Other current liabilities",null,16000,12000,12000,12000,12000]
[null,null,null,null,null,null,null,"Total Current Liabilities  ",{"$f":"SUM(I44:I49)","v":936000},{"$f":"SUM(J44:J49)","v":757355},{"$f":"SUM(K44:K49)","v":605896},{"$f":"SUM(L44:L49)","v":559887},{"$f":"SUM(M44:M49)","v":385740}]
[]
[null,null,null,null,null,"Non-Current Liabilities"]
[null,null,null,null,null,null,"Long-term debt",null,600000,500000,500000,500000,500000]
[null,null,null,null,null,null,"Deferred income",null,100000,90000,90000,90000,90000]
[null,null,null,null,null,null,"Deferred income taxes",null,30000,27000,27000,27000,27000]
[null,null,null,null,null,null,"Other long-term liabilities",null,50000,90000,40000,40000,40000]
[]
[null,null,null,null,null,null,null,"Total Liabilities  ",{"$f":"I50+SUM(I53:I56)","v":1716000},{"$f":"J50+SUM(J53:J56)","v":1464355},{"$f":"K50+SUM(K53:K56)","v":1262896},{"$f":"L50+SUM(L53:L56)","v":1216887},{"$f":"M50+SUM(M53:M56)","v":1042740}]
[]
[null,null,null,null,null,{"$f":"IF(#REF!=\"Y\",\"Stockholders' Equity\",\"Owners' Equity\")","v":{"$error":"#REF!"}},"Shares Outstanding",null,1000,1000,1000,1000,1000]
[null,null,null,null,null,null,"Capital stock issued",null,100000,100000,100000,100000,100000]
[null,null,null,null,null,null,"Additional paid in capital",null,50000,50000,50000,50000,50000]
[null,null,null,null,null,null,"Retained earnings",null,1400000,1890700,2076579,2174538,1747157]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I63)","v":1550000},{"$f":"SUM(J61:J63)","v":2040700},{"$f":"SUM(K61:K63)","v":2226579},{"$f":"SUM(L61:L63)","v":2324538},{"$f":"SUM(M61:M63)","v":1897157}]
[]
[null,null,null,null,null,null,null,"Total Liabilities and Equity  ",{"$f":"I64+I58","v":3266000},{"$f":"J64+J58","v":3505055},{"$f":"K64+K58","v":3489475},{"$f":"L64+L58","v":3541425},{"$f":"M64+M58","v":2939897}]

{"sheet":"EPS","index":5,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Profitability Ratios"]
[null,"Earnings Per Share (EPS) Ratio",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Net income",null,{"$f":"'Income Statement'!_1ST_QTR Net_income","v":490700},{"$f":"'Income Statement'!_2ND_QTR Net_income","v":227879.40000000002},{"$f":"'Income Statement'!_3RD_QTR Net_income","v":170059.40000000002},{"$f":"'Income Statement'!_4TH_QTR Net_income","v":834109.3600000001}]
[null,"Shares of common stock outstanding",null,{"$f":"'Balance Sheet'!I60","v":1000},{"$f":"'Balance Sheet'!J60","v":1000},{"$f":"'Balance Sheet'!K60","v":1000},{"$f":"'Balance Sheet'!L60","v":1000}]
[null,"EPS",null,{"$f":"Net_income 'Income Statement'!_1ST_QTR/D5","v":490.7},{"$f":"Net_income 'Income Statement'!_2ND_QTR/E5","v":227.87940000000003},{"$f":"Net_income 'Income Statement'!_3RD_QTR/F5","v":170.05940000000001},{"$f":"Net_income 'Income Statement'!_4TH_QTR/G5","v":834.10936000000015}]

{"sheet":"GP Margin","index":6,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Profitability Ratios"]
[null,"Gross Profit Margin",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Sales",null,{"$f":"'Income Statement'!_1ST_QTR Sales","v":2000000},{"$f":"'Income Statement'!_2ND_QTR Sales","v":1500000},{"$f":"'Income Statement'!_3RD_QTR Sales","v":1300000},{"$f":"'Income Statement'!_4TH_QTR Sales","v":2010100}]
[null,"Cost of sales",null,{"$f":"'Income Statement'!_1ST_QTR COGS","v":945000},{"$f":"'Income Statement'!_2ND_QTR COGS","v":865000},{"$f":"'Income Statement'!_3RD_QTR COGS","v":833000},{"$f":"'Income Statement'!_4TH_QTR COGS","v":946616}]
[null,"Gross profit margin",null,{"$f":"(D4-D5)/D4","v":0.52749999999999997},{"$f":"(E4-E5)/E4","v":0.42333333333333334},{"$f":"(F4-F5)/F4","v":0.35923076923076924},{"$f":"(G4-G5)/G4","v":0.5290701955126611}]

{"sheet":"NP Margin","index":7,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Profitability Ratios"]
[null,"Net Profit Margin",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Net Income",null,{"$f":"'Income Statement'!_1ST_QTR Net_income","v":490700},{"$f":"'Income Statement'!_2ND_QTR Net_income","v":227879.40000000002},{"$f":"'Income Statement'!_3RD_QTR Net_income","v":170059.40000000002},{"$f":"'Income Statement'!_4TH_QTR Net_income","v":834109.3600000001}]
[null,"Sales",null,{"$f":"'Income Statement'!_1ST_QTR Sales","v":2000000},{"$f":"'Income Statement'!_2ND_QTR Sales","v":1500000},{"$f":"'Income Statement'!_3RD_QTR Sales","v":1300000},{"$f":"'Income Statement'!_4TH_QTR Sales","v":2010100}]
[null,"Net profit margin",null,{"$f":"D4/D5","v":0.24535000000000001},{"$f":"E4/E5","v":0.15191960000000002},{"$f":"F4/F5","v":0.13081492307692311},{"$f":"G4/G5","v":0.4149591363613751}]

{"sheet":"ROA","index":8,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Profitability Ratios"]
[null,"Return on Assets","Full Year"]
[null,"EBITDA",{"$f":"ANNUAL GrossProfit - ANNUAL OperatingExpense","v":1776742.8}]
[null,"Total assets",{"$f":"AVERAGE(OFFSET(Total_Assets,0,1,1,4))","v":3368963}]
[null,"Return on assets",{"$f":"C4/C5","v":0.52738566734036563}]

{"sheet":"ROE","index":9,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Profitability Ratios"]
[null,"Return on Equity",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Earnings after taxes",null,{"$f":"'Income Statement'!_1ST_QTR Net_income","v":490700},{"$f":"'Income Statement'!_2ND_QTR Net_income","v":227879.40000000002},{"$f":"'Income Statement'!_3RD_QTR Net_income","v":170059.40000000002},{"$f":"'Income Statement'!_4TH_QTR Net_income","v":834109.3600000001}]
[null,"Stockholder's equity",null,{"$f":"'Balance Sheet'!_1ST_QTR Equity","v":2040700},{"$f":"'Balance Sheet'!_2ND_QTR Equity","v":2226579},{"$f":"'Balance Sheet'!_3RD_QTR Equity","v":2324538},{"$f":"'Balance Sheet'!_4TH_QTR Equity","v":1897157}]
[null,"Return on equity",null,{"$f":"D4/D5","v":0.24045670603224384},{"$f":"E4/E5","v":0.10234507735858464},{"$f":"F4/F5","v":7.315836523214507E-2},{"$f":"G4/G5","v":0.43966280070653091}]

{"sheet":"Current Ratio","index":10,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Liquidity Ratios"]
[null,"Current ratio",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Current assets",null,{"$f":"'Balance Sheet'!_1ST_QTR CurrentAssets","v":1438305},{"$f":"'Balance Sheet'!_2ND_QTR CurrentAssets","v":1358433},{"$f":"'Balance Sheet'!_3RD_QTR CurrentAssets","v":1548091},{"$f":"'Balance Sheet'!_4TH_QTR CurrentAssets","v":951271}]
[null,"Current liabilities",null,{"$f":"'Balance Sheet'!_1ST_QTR CurrentLiabilities","v":757355},{"$f":"'Balance Sheet'!_2ND_QTR CurrentLiabilities","v":605896},{"$f":"'Balance Sheet'!_3RD_QTR CurrentLiabilities","v":559887},{"$f":"'Balance Sheet'!_4TH_QTR CurrentLiabilities","v":385740}]
[null,"Current ratio",null,{"$f":"D4/D5","v":1.8991160024031002},{"$f":"E4/E5","v":2.2420233835509724},{"$f":"F4/F5","v":2.7650061530273073},{"$f":"G4/G5","v":2.4660937418986881}]

{"sheet":"Quick Ratio","index":11,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Liquidity Ratios"]
[null,"Quick ratio",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Current assets",null,{"$f":"'Balance Sheet'!_1ST_QTR CurrentAssets","v":1438305},{"$f":"'Balance Sheet'!_2ND_QTR CurrentAssets","v":1358433},{"$f":"'Balance Sheet'!_3RD_QTR CurrentAssets","v":1548091},{"$f":"'Balance Sheet'!_4TH_QTR CurrentAssets","v":951271}]
[null,"Inventory",null,{"$f":"'Balance Sheet'!_1ST_QTR Inventory","v":630411},{"$f":"'Balance Sheet'!_2ND_QTR Inventory","v":590959},{"$f":"'Balance Sheet'!_3RD_QTR Inventory","v":575178},{"$f":"'Balance Sheet'!_4TH_QTR Inventory","v":1186002}]
[null,"Current liabilities",null,{"$f":"'Balance Sheet'!_1ST_QTR CurrentLiabilities","v":757355},{"$f":"'Balance Sheet'!_2ND_QTR CurrentLiabilities","v":605896},{"$f":"'Balance Sheet'!_3RD_QTR CurrentLiabilities","v":559887},{"$f":"'Balance Sheet'!_4TH_QTR CurrentLiabilities","v":385740}]
[null,"Quick ratio",null,{"$f":"(D4-D5)/D6","v":1.066730925391659},{"$f":"(E4-E5)/E6","v":1.2666761292367006},{"$f":"(F4-F5)/F6","v":1.7376952849414258},{"$f":"(G4-G5)/G6","v":-0.60852128376626746}]

{"sheet":"ACP","index":12,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Activity Ratios"]
[null,"Average Collection Period",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Accounts Receivable",null,{"$f":"'Balance Sheet'!_1ST_QTR AccountsReceivable","v":657534},{"$f":"'Balance Sheet'!_2ND_QTR AccountsReceivable","v":493151},{"$f":"'Balance Sheet'!_3RD_QTR AccountsReceivable","v":427397},{"$f":"'Balance Sheet'!_4TH_QTR AccountsReceivable","v":660855}]
[null,"Credit sales per day",null,{"$f":"'Income Statement'!_1ST_QTR Sales/90","v":22222.222222222223},{"$f":"'Income Statement'!_2ND_QTR Sales/90","v":16666.666666666668},{"$f":"'Income Statement'!_3RD_QTR Sales/90","v":14444.444444444445},{"$f":"'Income Statement'!_4TH_QTR Sales/90","v":22334.444444444445}]
[null,"Average Collection Period",null,{"$f":"D4/D5","v":29.589030000000001},{"$f":"E4/E5","v":29.589059999999996},{"$f":"F4/F5","v":29.589023076923077},{"$f":"G4/G5","v":29.589050296005173}]

{"sheet":"ITO","index":13,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Activity Ratios"]
[null,"Inventory Turnover Ratio",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Cost of Goods Sold",null,{"$f":"'Income Statement'!_1ST_QTR COGS","v":945000},{"$f":"'Income Statement'!_2ND_QTR COGS","v":865000},{"$f":"'Income Statement'!_3RD_QTR COGS","v":833000},{"$f":"'Income Statement'!_4TH_QTR COGS","v":946616}]
[null,"Average Inventory",null,{"$f":"'Balance Sheet'!_1ST_QTR Inventory","v":630411},{"$f":"'Balance Sheet'!_2ND_QTR Inventory","v":590959},{"$f":"'Balance Sheet'!_3RD_QTR Inventory","v":575178},{"$f":"'Balance Sheet'!_4TH_QTR Inventory","v":1186002}]
[null,"Inventory Turnover",null,{"$f":"D4/D5","v":1.4990220665565797},{"$f":"E4/E5","v":1.4637225255897617},{"$f":"F4/F5","v":1.4482473251758585},{"$f":"G4/G5","v":0.79815717005536246}]

{"sheet":"Debt Ratio","index":14,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Leverage Ratios"]
[null,"Debt ratio",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Total Liabilities",null,{"$f":"'Balance Sheet'!_1ST_QTR Total_Liabilities","v":1464355},{"$f":"'Balance Sheet'!_2ND_QTR Total_Liabilities","v":1262896},{"$f":"'Balance Sheet'!_3RD_QTR Total_Liabilities","v":1216887},{"$f":"'Balance Sheet'!_4TH_QTR Total_Liabilities","v":1042740}]
[null,"Total Assets",null,{"$f":"'Balance Sheet'!_1ST_QTR Total_Assets","v":3505055},{"$f":"'Balance Sheet'!_2ND_QTR Total_Assets","v":3489475},{"$f":"'Balance Sheet'!_3RD_QTR Total_Assets","v":3541425},{"$f":"'Balance Sheet'!_4TH_QTR Total_Assets","v":2939897}]
[null,"Debt ratio",null,{"$f":"D4/D5","v":0.41778374376436317},{"$f":"E4/E5","v":0.36191576096690764},{"$f":"F4/F5","v":0.34361507020479043},{"$f":"G4/G5","v":0.35468589545824225}]

{"sheet":"Equity Ratio","index":15,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Leverage Ratios"]
[null,"Equity ratio",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"Total Equity",null,{"$f":"'Balance Sheet'!_1ST_QTR Equity","v":2040700},{"$f":"'Balance Sheet'!_2ND_QTR Equity","v":2226579},{"$f":"'Balance Sheet'!_3RD_QTR Equity","v":2324538},{"$f":"'Balance Sheet'!_4TH_QTR Equity","v":1897157}]
[null,"Total Assets",null,{"$f":"'Balance Sheet'!_1ST_QTR Total_Assets","v":3505055},{"$f":"'Balance Sheet'!_2ND_QTR Total_Assets","v":3489475},{"$f":"'Balance Sheet'!_3RD_QTR Total_Assets","v":3541425},{"$f":"'Balance Sheet'!_4TH_QTR Total_Assets","v":2939897}]
[null,"Equity ratio",null,{"$f":"D4/D5","v":0.58221625623563678},{"$f":"E4/E5","v":0.63808423903309242},{"$f":"F4/F5","v":0.65638492979520957},{"$f":"G4/G5","v":0.64531410454175775}]

{"sheet":"TIE","index":16,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Leverage Ratios"]
[null,"Times Interest Earned Ratio",null,"Quarter 1","Quarter 2","Quarter 3","Quarter 4"]
[null,"EBIT",null,{"$f":"'Income Statement'!_1ST_QTR Net_income+'Income Statement'!_1ST_QTR Interest+'Income Statement'!_1ST_QTR Taxes","v":717250},{"$f":"'Income Statement'!_2ND_QTR Net_income+'Income Statement'!_2ND_QTR Interest+'Income Statement'!_2ND_QTR Taxes","v":341792},{"$f":"'Income Statement'!_3RD_QTR Net_income+'Income Statement'!_3RD_QTR Interest+'Income Statement'!_3RD_QTR Taxes","v":259192},{"$f":"'Income Statement'!_4TH_QTR Net_income+'Income Statement'!_4TH_QTR Interest+'Income Statement'!_4TH_QTR Taxes","v":1207834.8}]
[null,"Interest charges",null,{"$f":"'Income Statement'!_1ST_QTR Interest","v":16250},{"$f":"'Income Statement'!_2ND_QTR Interest","v":16250},{"$f":"'Income Statement'!_3RD_QTR Interest","v":16250},{"$f":"'Income Statement'!_4TH_QTR Interest","v":16250}]
[null,"Times interest earned",null,{"$f":"D4/D5","v":44.138461538461542},{"$f":"E4/E5","v":21.033353846153847},{"$f":"F4/F5","v":15.950276923076924},{"$f":"G4/G5","v":74.328295384615387}]