{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Ratios","Features of this template"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Create Chart \nfor the \nSelected Ratio"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Ratios","index":1,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Financial\\Per Share Ratio","Earning Per Share","Formula","In Terms of",2012,2013,2014,2015,2016]
["Financial\\Per Share Ratio","Diluted Earning Per share","PAT/Number of Shares Outs","Rupees",25,36,24,35,45]
["Financial\\Per Share Ratio","Dividend Per Share","Equity Dividend/Number of Shares","Rupees",25,36,24,35,45]
["Financial\\Per Share Ratio","Book Value Per share","Share Holders Equity/No of Shares Outstading","Rupees",15,18,14,22,24]
["Financial\\Per Share Ratio","Dividend Payout Ratio","DPS/EPS","Percentage",4.8500000000000001E-2,0.04,0.06,7.0000000000000007E-2,0.03]
["Financial\\Per Share Ratio","Dividend Retention Ratio","1-DPS","Percentage",45,0.5,0.58333333333333337,0.62857142857142856,0.53333333333333333]
["CashFlow Ratio","Cashflow Per Share","Total CashFlow/Shares Oustanding","Rupees",45,25,45,35,85]
["Profitability Ratio - On Sales","Gross Profit","Sales - Cost of Goods Sole","Rupees",50167,49869,55834,61242,71383]
["Profitability Ratio - On Sales","Net Profit","Sales-VariableCost -Fixed Cost","Rupees",32747,27470,31289,33545,44310]
["Profitability Ratio - On Sales","Gross Profit Margin Ratio","(Sales - Raw Material)/Sales","Percentage",2.2758040212836089E-2,2.5924299213998744E-2,2.2519200003987022E-2,2.6466048929914852E-2,4.0797481302812834E-2]
["Profitability Ratio - On Sales","Net Profit Margin Ratio","Net Profit/Net Sales*100","Percentage",0.15206544934283914,0.13841081108085829,0.14312116621423829,0.18610290631951282,0.30615719812316111]
["Profitability Ratio - On Investments","Return on Assets","Net Profit After Tax & Interest/Total Assets","Percentage",0.10190540278384015,8.5448949061468729E-2,7.9148050456657876E-2,9.6032527440469681E-2,0.1721536468832294]
["Profitability Ratio - On Investments","Return on Capital Employeed","Earning Before Interest and Tax/Capital Employeed","Percentage",6.8627081671021495E-2,6.3339696555717404E-2,5.5643299720568584E-2,5.1999862670374569E-2,5.3929600597972006E-2]
["Profitability Ratio - On Investments","Return on Equity","Profit After Tax/Sh Holders Equity","Percentage",0.12823787432986156,0.1245523633938395,0.1088286467980019,0.10339530230987086,0.11395573183443192]
["Expenses Ratio","Material Consummed","Material Consummed/Net Sales","Percentage",0.12296817186090606,0.11611565678903141,0.11014524703017671,0.10385591186487166,0.11307518136488677]
["Expenses Ratio","Manufacturing Expenses Ratio","Manufacturing Expenses/Sales","Percentage",0.84793455065716083,0.86158918891914171,0.85687883378576168,0.81389709368048713,0.69384280187683889]
["Expenses Ratio","Administrative Expenses Ratio","Admin Exp/Net Sales","Percentage",8.2781657694359564E-3,6.2670519044010914E-3,5.0882171246062081E-3,8.1804811046688308E-3,1.2116247351581332E-2]
["Financial Stability Ratio","Debt Equity Ratio","Total Debt/Total Equity","Times",3,2,4,3,2]
["Financial Stability Ratio","Current Ratio","Current Assets/Current Liabilities","Times",2,3,4,3,2]
["Financial Stability Ratio","Quick Ratio","(Current Assets-Inventory)/Current Liabilities","Times",1.4204718934687646,1.496131625219794,1.485156597892237,1.1227583806982948,0.78988091837317687]
["Financial Stability Ratio","Interest Coverage Ratio","EBIT/Interest","Times",0.87700841911153438,0.9594699824164783,0.95410914848349904,0.69878204384642151,0.56107116331077933]
["Financial Stability Ratio","Defensive Interval Ratio","COGS/Cash","Times",10.655043119610049,9.6574440052700918,9.6768558951965069,13.449514152936207,15.548084759576202]
["Financial Stability Ratio","Purchase Per Day","COGs/365","Times",7.0644224455780593,4.811867375567715,5.0290807883255608,4.8188049873158096,2.4793863413437958]
["Financial Stability Ratio","Cash Suffiency Days","Cash/Purchase","Times",766.40273972602745,850.48767123287666,915.84383561643835,733.79178082191777,443.21917808219177]
["Capital Structure Ratio","Gearing Ratio","Long Term Loans/Capital Employeed","Times",51.667351834044119,75.854127205020177,72.577875632323511,75.744920361119199,147.21384639159325]
["Performance\\Turnover Ratio","Asset Trunover Ratio","Sales/Total Assets","Times",4,5,6,5,4]
["Performance\\Turnover Ratio","Inventory Trunover Ratio","COGS/Total Inventory","Times",1.1297579217363611,1.0865639503849598,0.98741799295346855,0.75319806365228137,0.45862486107969352]
["Performance\\Turnover Ratio","Debtors Turnover Ratio","Sales/Debtors","Times",7.7801974690585451,7.2650424770062489,7.7863365321904405,7.327679133265848,5.7706713276735391]
["Performance\\Turnover Ratio","Fixed Assets Turnover Ratio","Sales/Fixed Assets","Times",17.90620929222753,30.328030303030303,36.5826144036009,70.602016734606309,66.711874105865519]
["Performance\\Turnover Ratio","Working Capital Turnover Ratio","Sales/Working Capital","Times",2.9829650258598863,3.3402896239709263,3.6437397842432167,3.0005197268242867,1.8845771465983399]
["Performance\\Turnover Ratio","Payable Turnover Ratio","Cost of GoodsSold/Current Liabilities","Times",3,2,4,3,4]
["Efficiency Ratio","Receivable Days","365/Receivable Turnover","Days",4.2282531477198866,3.8988696307460438,4.1349141556578104,3.1067625565479644,1.3203858930305825]
["Efficiency Ratio","Inventory Days","365/Inventory Turnover","Days",20.383990494204372,12.035071066370245,9.9774170313008668,5.1698239920261582,5.4712898549481475]
["Efficiency Ratio","Payable Days","365/Payable Turnover","Days",46.913976342064153,50.24058718929993,46.876987462718716,49.811133015225849,63.250873126255605]
["Efficiency Ratio","Operating Cycle","Receivable Days+Inventory Days","Days",86.324065104008412,93.61687734353859,88.272691103047407,117.48564409298297,276.43433781486635]
["Efficiency Ratio","Cash Conversion Cycle","Operating Cycle - Payable Days","Days",106.70805559821278,105.65194840990884,98.250108134348267,122.65546808500912,281.90562766981452]
["Efficiency Ratio","Cash Conversion Cycle","Operating Cycle - Payable Days","Days",20.383990494204369,12.03507106637025,9.9774170313008597,5.1698239920261528,5.4712898549481679]
[]
[]
["Note: All these ratios are prepared just for creating charts, Don't compare conceptually"]

{"sheet":"Features of this template","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,3,3,11]]}
[]
[]
[null,null,null,"Features of this template"]
[]
[]
[]
[]
[null,null,null,"Select any ratio in \"Column B\""]
[]
[null,null,null,"Click on COMMAND BUTTON,  chart will create by creating new Worksheet"]
[]
[null,null,null,"All these ratios mentioned for creating charts only, don’t compare conceptually"]
[]
[null,null,null,"Hope useful to every one"]