{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","User Inputs","Output (Do not change)","Model Working (Do not change)","Input Data (Do not change) -->","Housing Shortage by State","CLSSStateWiseJun2020-MoHUA","GSDP by State","GDP and GSDP by State","GDP_GSDP Relationship","Current SD+RC Rate by State","SD as Pct of GSDP"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"GDP_GSDP Relationship","index":9,"reason":"not_a_worksheet"}],"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":"Instructions","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["How to use the Utility?"]
[]
["Objective","The Utility provides an easy way to quickly determine whether States would be better off or worse off by waiving stamp duty for low value housing."]
[null,"While States would lose stamp duty revenues, they will make it up through non-stamp duty revenues on housing created by the Central scheme, PMAY. "]
[]
["Steps in using the Utility"]
[1,"Change necessary inputs listed in the tab <User Inputs>. "]
[null,"Start with the State that you want the analysis for."]
[null,"The housing shortage in that State and SD revenue as % of GSDP of the State are auto-populated based on publicly available data."]
[null,"All other inputs can be changed by sliding the slidebar on the right of the input.  The key inputs here are: Percentage of housing that will be created solely by PMAY "]
[null,"and percentage of housing created under the other 3 verticals that would generate non-SD revenue for the State."]
[]
[2,"Outputs are displayed in the tabs <Output (Do not change)> and <Model Working (Do not change)>."]
[null,"The net gain/loss to the State of fully waiving the SD for low value housing is displayed both in aggregate (from now till 2021-22) as well as in present value terms."]
[null,"It is also displayed in the tab <User Inputs> at the top to provide a quick summary of whether it makes sense for the State to waive SD or not."]
[null,"Summary for the alternative proposal, i.e., giving SD rebates to all and not just to those who transact in low value housing, is also provided.  "]
[null,"The maximum rebate rate is computed based on uniform reduction in rates across all value categories. "]
[null,"The tab <Model Working (Do not change)> presents a detailed step-by-step computation of the impact of the revenue neutral proposal."]
[]
[3,"All tabs after <Input Data (Do not change)> hold data used in the computation of the impact of the proposal.  "]
[null,"They are obtained from various sources which have been displayed at the end of each tab."]
[null,"Unless the user is absolutely sure about their data, it is best that they don't change the data that is already in these tabs.  "]

{"sheet":"User Inputs","index":1,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,1,8,4]]}
[]
[]
[null,null,null,"Karnataka"]
[]
[]
[null,null,"Net revenue gain/loss to the State from waiving stamp duty fully for low value housing (Rs. Cr.)",{"$f":"'Output (Do not change)'!B11","v":640.44594172432517}]
[]
[]
[null,"Inputs (User to enter)",null,null,null,null,null,null,0]
[]
[null,"A","Housing Shortage to be covered by 2021-22 in the State (auto-populated)",{"$f":"VLOOKUP($D$3,'Housing Shortage by State'!$A$2:$B$27,2,0)","v":510000}]
[null,"B","Percentage of housing shortage to be met by HFA",{"$f":"$N$12/1000","v":0.96},null,null,null,null,null,null,null,null,null,960]
[null,"C","Percentage of houses that will be created under CLSS (solely because of PMAY)",{"$f":"$N$13/1000","v":0.13500000000000001},null,null,null,null,null,null,null,null,null,135]
[null,"D","Percentage of houses created under PMAY verticals other than CLSS that would generate non-SD revenue",{"$f":"$N$14/1000","v":0.5},null,null,null,null,null,null,null,null,null,500]
[]
[]
[null,"E","Current SD+RC (including on mortgage where applicable) rate in the State",{"$f":"IF(($O$17=0),$N$17,$O$17/1000)","v":7.5999999999999998E-2},null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(D3,'Current SD+RC Rate by State'!$A$2:$B$34,2,0)","v":7.5999999999999998E-2},0]
[null,"F","SD Revenue for State as pct of GSDP (auto populated)",{"$f":"VLOOKUP(D3,'SD as Pct of GSDP'!$A$2:$B$32,2,0)","v":1.0523532304568069E-2}]
[null,"G","Percent of SD+RC revenue derived from low value housing",{"$f":"$N$19/1000","v":0.06},null,null,null,null,null,null,null,null,null,60]
[null,"H","Non-SD revenue generated from new housing stock by the State",{"$f":"$N$20/1000","v":0.11899999999999999},null,null,null,null,null,null,null,null,null,119]
[]
[]
[null,"I","Average value of a house being built",{"$f":"$N$23*1000","v":1500000},null,null,null,null,null,null,null,null,null,1500]

{"sheet":"Output (Do not change)","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
["Outputs (Automatically Created)"]
[]
["Main Proposal: Waive all stamp duty for low value housing"]
[null,"2017-18","2018-19","2019-20","2020-21","2021-22"]
["Incremental Revenue from Housing Stock Created by PMAY (Rs. Cr.)",{"$f":"'Model Working (Do not change)'!D67","v":991.91736000000003},{"$f":"'Model Working (Do not change)'!E67","v":991.91736000000003},{"$f":"'Model Working (Do not change)'!F67","v":991.91736000000003},{"$f":"'Model Working (Do not change)'!G67","v":991.91736000000003},{"$f":"'Model Working (Do not change)'!H67","v":991.91736000000003},{"$f":"SUM(B6:F6)","v":4959.5868}]
["Loss of SD Revenues from Waiving SD for Low Value Housing (Rs. Cr.)",{"$f":"'Model Working (Do not change)'!D65+'Model Working (Do not change)'!D66","v":-744.45783015898576},{"$f":"'Model Working (Do not change)'!E65+'Model Working (Do not change)'!E66","v":-790.65000722910258},{"$f":"'Model Working (Do not change)'!F65+'Model Working (Do not change)'!F66","v":-841.35965587019564},{"$f":"'Model Working (Do not change)'!G65+'Model Working (Do not change)'!G66","v":-896.97982657528757},{"$f":"'Model Working (Do not change)'!H65+'Model Working (Do not change)'!H66","v":-956.78123388932852},{"$f":"SUM(B7:F7)","v":-4230.2285537229}]
["Net gain/loss for the State (Rs. Cr.)",{"$f":"SUM(B6:B7)","v":247.45952984101427},{"$f":"SUM(C6:C7)","v":201.26735277089745},{"$f":"SUM(D6:D7)","v":150.55770412980439},{"$f":"SUM(E6:E7)","v":94.937533424712456},{"$f":"SUM(F6:F7)","v":35.136126110671512},729.35824627710008]
[null,null,null,null,null,null,{"$f":"B11","v":640.44594172432517}]
["Total gain/loss until 2021-22 (Rs. Cr.)",{"$f":"SUM(B8:F8)","v":729.35824627710008}]
["Present value (@6% Discount Rate) of the Total gain",{"$f":"'Model Working (Do not change)'!D72","v":640.44594172432517}]
[]
[]
["Alternative Proposal: Provide SD rebate for all housing transactions"]
[null,"2017-18","2018-19","2019-20","2020-21","2021-22"]
["Average SD Rate Rebate (%)",{"$f":"'Model Working (Do not change)'!D86","v":9.8730846756323307E-2},{"$f":"'Model Working (Do not change)'!E86","v":9.1703664130601326E-2},{"$f":"'Model Working (Do not change)'!F86","v":8.5057612129457089E-2},{"$f":"'Model Working (Do not change)'!G86","v":7.8794172962460385E-2},{"$f":"'Model Working (Do not change)'!H86","v":7.301345644076386E-2}]

{"sheet":"Model Working (Do not change)","index":3,"n_rows":86,"n_cols":11,"rows_kept":86,"cut":false,"hidden":false,"merged":[[85,1,85,2],[70,1,70,2],[71,1,71,2],[79,1,79,2],[77,1,77,7],[78,1,78,2],[81,1,81,2],[82,1,82,2],[64,1,64,2],[65,1,65,2],[83,1,83,2],[63,1,63,2],[32,2,32,6],[46,5,46,6],[66,1,66,2],[67,1,67,2],[62,1,62,7],[37,9,37,10],[53,1,53,7],[54,1,54,2],[55,1,55,2],[56,1,56,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"GSDP and SD Projections (In Rs. '000 Crore)"]
[null,null,"2017-18","2018-19","2019-20","2020-21","2021-22"]
[null,"GDP",{"$f":"VLOOKUP(C$34,'GDP and GSDP by State'!$A$10:$C$15,2,0)","v":13012},{"$f":"VLOOKUP(D$34,'GDP and GSDP by State'!$A$10:$C$15,2,0)","v":13962},{"$f":"VLOOKUP(E$34,'GDP and GSDP by State'!$A$10:$C$15,2,0)","v":15005},{"$f":"VLOOKUP(F$34,'GDP and GSDP by State'!$A$10:$C$15,2,0)","v":16149},{"$f":"VLOOKUP(G$34,'GDP and GSDP by State'!$A$10:$C$15,2,0)","v":17379}]
[null,"GSDP",{"$f":"C35*0.077-61.557","v":940.36699999999996},{"$f":"VLOOKUP(D$34,'GDP and GSDP by State'!$A$10:$C$15,3,0)","v":1013.5239586669196},{"$f":"VLOOKUP(E$34,'GDP and GSDP by State'!$A$10:$C$15,3,0)","v":1093.8354725412123},{"$f":"VLOOKUP(F$34,'GDP and GSDP by State'!$A$10:$C$15,3,0)","v":1181.9240361770621},{"$f":"VLOOKUP(G$34,'GDP and GSDP by State'!$A$10:$C$15,3,0)","v":1276.6346421841381}]
[null,"SD Revenues \n(all transactions)",{"$f":"C36*'User Inputs'!$D$18","v":9.8959825026497619},{"$f":"D36*'User Inputs'!$D$18","v":10.665852120485042},{"$f":"E36*'User Inputs'!$D$18","v":11.511012931169926},{"$f":"F36*'User Inputs'!$D$18","v":12.438015776254792},{"$f":"G36*'User Inputs'!$D$18","v":13.434705898155475}]
[null,"SD Revenues \n(low value transactions)",{"$f":"C37*'User Inputs'!$D$19","v":0.59375895015898572},{"$f":"D37*'User Inputs'!$D$19","v":0.63995112722910252},{"$f":"E37*'User Inputs'!$D$19","v":0.69066077587019559},{"$f":"F37*'User Inputs'!$D$19","v":0.74628094657528754},{"$f":"G37*'User Inputs'!$D$19","v":0.80608235388932847},null,null,"Potential loss of revenues if Stamp Duty is waived for low value transactions"]
[]
[]
[]
[]
[]
[null,"Item","Total Housing Stock to be created by 2021-22","Annual Housing Stock to be created"]
[null,"Housing Shortage to be covered by 2021-22",{"$f":"'User Inputs'!D11","v":510000},{"$f":"C45/5","v":102000}]
[null,"Percentage of housing shortage to be met by HFA",{"$f":"C45*'User Inputs'!D12","v":489600},{"$f":"C46/5","v":97920},null,null,null,{"$f":"53000/C46","v":0.10825163398692811},null,52922,{"$f":"J46/4","v":13230.5}]
[null,"Percentage of houses that will be created under CLSS (5% of all housing created by PMAY)",{"$f":"C46*'User Inputs'!$D$13","v":66096},{"$f":"C47/5","v":13219.2},null,"Our focus is on these houses as they would generate additional revenue to the State",null,{"$f":"J46+K46","v":66152.5},{"$f":"H47/C46","v":0.13511540032679739}]
[null,"Percentage of houses that will be created under other schemes of PMAY (95 percent of all housing created by PMAY)",{"$f":"C46*(1-'User Inputs'!$D$13)","v":423504},{"$f":"C48/5","v":84700.800000000003}]
[null,"Percentage of houses that will be created solely because of PMAY (100% of CLSS + 50% of all other verticals)",{"$f":"C47*100%+C48*50%","v":277848},{"$f":"D47*100%+D48*50%","v":55569.600000000006}]
[]
[]
[]
[]
[null,{"$f":"\"Incremental revenues generated by housing stock created under PMAY in Crores \n(Average value per house = Rs. \"&'User Inputs'!$D$23&\")\"","v":"Incremental revenues generated by housing stock created under PMAY in Crores \n(Average value per house = Rs. 1500000)"}]
[null,null,null,"Total Value of Housing Stock to be created by 2021-22","Total Value of Housing Stock to be created each year","Incremental SD Revenue/year \n(Rs. Cr.)","Incremental Non-SD Revenue/year\n(Rs. Cr.)","Total Incremental Revenue/year\n(Rs. Cr.)"]
[null,"Incremental revenues to the State from housing stock created under CLSS (solely due to PMAY)",null,{"$f":"'User Inputs'!$D$23*C47/10000000","v":9914.4},{"$f":"'User Inputs'!$D$23*D47/10000000","v":1982.88},{"$f":"E56*'User Inputs'!$D$17","v":150.69888},{"$f":"E56*'User Inputs'!$D$20","v":235.96271999999999},{"$f":"F56+G56","v":386.66160000000002}]
[null,"Incremental revenues to the State from housing stock created under other 3 verticals (solely due to PMAY)",null,{"$f":"'User Inputs'!$D$23*C48/10000000","v":63525.599999999999},{"$f":"'User Inputs'!$D$23*D48/10000000","v":12705.12},null,{"$f":"E57*'User Inputs'!$D$20*'User Inputs'!$D$14","v":755.95464000000004},{"$f":"F57+G57","v":755.95464000000004}]
[]
[]
[]
[]
[]
[null,"Revenue Gain/Loss from Stamp Duty Waiver to All Low Value Housing (Rs. Crores)"]
[null,null,null,"2017-18","2018-19","2019-20","2020-21","2021-22"]
[null,"Loss of SD Revenues from Existing Low Value Transactions",null,{"$f":"-C38*1000","v":-593.75895015898573},{"$f":"-D38*1000","v":-639.95112722910255},{"$f":"-E38*1000","v":-690.66077587019561},{"$f":"-F38*1000","v":-746.28094657528754},{"$f":"-G38*1000","v":-806.08235388932849}]
[null,"Loss of SD Revenues from Incremental Housing Stock Created under PMAY",null,{"$f":"-$F$56","v":-150.69888},{"$f":"-$F$56","v":-150.69888},{"$f":"-$F$56","v":-150.69888},{"$f":"-$F$56","v":-150.69888},{"$f":"-$F$56","v":-150.69888}]
[null,"Gain in Non-SD Revenues from Incremental Housing Stock Created under PMAY ",null,{"$f":"$G$56+$G$57","v":991.91736000000003},{"$f":"$G$56+$G$57","v":991.91736000000003},{"$f":"$G$56+$G$57","v":991.91736000000003},{"$f":"$G$56+$G$57","v":991.91736000000003},{"$f":"$G$56+$G$57","v":991.91736000000003}]
[null,"Net Gain/Loss in Revenues to the State",null,{"$f":"SUM(D65:D67)","v":247.45952984101427},{"$f":"SUM(E65:E67)","v":201.26735277089745},150.55770412980439,94.937533424712456,35.136126110671512]
[]
[null,null,null,"(in Rs. Crores)"]
[null,"Total Net Gain/Loss to the State",null,{"$f":"SUM(D68:H68)","v":729.35824627710008}]
[null,"Present Value (@6% Discount Rate) of the Total Net Gain/Loss to the State",null,{"$f":"NPV(0.06,D68:H68)","v":640.44594172432517}]
[]
[]
[]
[]
[]
[null,"Uniform Reduction in Stamp Duty Rate Across All Value Categories"]
[null,null,null,"2017-18","2018-19","2019-20","2020-21","2021-22"]
[null,"Gain in Non-SD Revenues from Incremental Housing Stock Created under PMAY (Rs. Cr.)",null,{"$f":"D67","v":991.91736000000003},{"$f":"E67","v":991.91736000000003},991.91736000000003,991.91736000000003,991.91736000000003]
[]
[null,"Baseline SD Revenues from all existing transactions (Rs. Cr.)",null,{"$f":"C37*1000","v":9895.982502649762},{"$f":"D37*1000","v":10665.852120485042},{"$f":"E37*1000","v":11511.012931169926},{"$f":"F37*1000","v":12438.015776254791},{"$f":"G37*1000","v":13434.705898155475}]
[null,"Incremental SD Revenues from Housing Stock Created by PMAY (Rs. Cr.)",null,{"$f":"$F$56","v":150.69888},{"$f":"$F$56","v":150.69888},150.69888,150.69888,150.69888]
[null,"Total SD Revenues for the State from Housing (Rs. Cr.)",null,{"$f":"SUM(D82:D83)","v":10046.681382649762},{"$f":"SUM(E82:E83)","v":10816.551000485042},11661.711811169926,12588.714656254791,13585.404778155475]
[]
[null,"Average SD Rate Rebate (%)",null,{"$f":"D80/D84","v":9.8730846756323307E-2},{"$f":"E80/E84","v":9.1703664130601326E-2},8.5057612129457089E-2,7.8794172962460385E-2,7.301345644076386E-2]

{"sheet":"Input Data (Do not change) -->","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"All the spreadsheets beyond this tab have key input data."]
[]
[null,"They should not be altered unless users are sure about the accuracy of the data"]

{"sheet":"Housing Shortage by State","index":5,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,0,29,9]]}
["States","Housing Shortage"]
["Andhra Pradesh",635000]
["Arunachal Pradesh",15000]
["Assam",140000]
["Bihar",595000]
["Chattisgarh",175000]
["Delhi",245000]
["Jammu & Kashmir",65000]
["Jharkhand",315000]
["Maharashtra",970000]
["Karnataka",510000]
["Gujarat",495000]
["Haryana",210000]
["Himachal Pradesh",20000]
["Manipur",40000]
["Meghalaya",15000]
["Nagaland",105000]
["Odisha",205000]
["Puducherry",35000]
["Punjab",195000]
["Rajasthan",575000]
["Sikkim",5000]
["Tamil Nadu",625000]
["Tripura",15000]
["Uttar Pradesh",1535000]
["Uttarakhand",80000]
["West Bengal",665000]
[]
[]
["Source: Numbers from the Report of the Technical Group on Urban Housing Shortage (MHUPA, Government of India (2012)), are adjusted proportionately to reflect new Government estimates."]

{"sheet":"CLSSStateWiseJun2020-MoHUA","index":6,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[20,19,20,20],[7,19,7,20],[0,1,0,3],[0,5,0,7],[0,9,0,11],[0,12,0,14],[0,15,0,17]]}
[null,"LIG",null,null,null,"MIG",null,null,null,"Total",null,null,"Ticket Size (INR)",null,null,"Est Cost of House (@85% LTV) (INR Lakh)"]
["State (A)","Loan Amount (Cr) (B)","Central Subsidy (Cr) (C )","No. of Beneficiaries (D)","% of Tot Beneficiaries","Loan Amount (Cr) ( E )","Central Subsidy (Cr) (F)","No. of Beneficiaries (G)","% of Tot Beneficiaries","Loan Amount (Cr) (H)","Central Subsidy (Cr) (I)","No. of Beneficiaries (J)","LIG (K=B/D)","MIG (L=E/G)","Overall (Lakh) (M=H/J)","LIG (N=K/0.85)","MIG (O=L/0.85)","Overall (P=M/0.85)"]
["Andhra Pradesh",1672.67,292.88,12588,{"$f":"D3/L3","v":0.45183058147882271},3076.09,315.01,15272,{"$f":"H3/L3","v":0.54816941852117729},4748.76,607.89,27860,{"$f":"(B3/D3)*10000000","v":1328781.3790911981},{"$f":"(F3/H3)*10000000","v":2014202.4620220012},{"$f":"(J3/L3)*10000000","v":1704508.2555635322},{"$f":"M3/0.85","v":1563272.2106955273},{"$f":"N3/0.85","v":2369649.9553200016},{"$f":"O3/0.85","v":2005303.8300747438}]
["Bihar",536.34,120.96,5373,0.54217961654894042,758.81,90.83,4537,0.45782038345105952,1295.1500000000001,211.8,9910,998213.28866555006,1672492.8366762176,1306912.209889001,1174368.5749006472,1967638.6313837855,1537543.7763400013]
["Chattisgarh",818.25,202.4,10467,0.74413479311815722,577.20000000000005,70.48,3599,0.25586520688184272,1395.45,272.89,14066,781742.61966179428,1603778.8274520701,992073.08403241867,919697.19960211089,1886798.6205318472,1167144.804744022]
["Goa",76.31,11.88,484,0.41402908468776733,176.41,15.03,685,0.58597091531223267,252.73,26.91,1169,1576652.8925619835,2575328.4671532842,2161933.2763045337,1854885.7559552749,3029798.1966509228,2543450.9132994516]
["Gujarat",24968.66,5551.91,229501,0.85760462170272078,7724.57,816.56,38106,0.14239537829727922,32693.23,6368.48,267607,1087954.3008527195,2027126.9616333384,1221688.147171038,1279946.2362973171,2384855.2489803983,1437280.1731423975]
["Haryana",1059.19,232.28,10255,0.47441709844559588,2273.52,227.33,11361,0.52558290155440412,3332.71,459.61,21616,1032852.2671867382,2001161.8695537364,1541779.2376017764,1215120.314337339,2354308.0818279251,1813857.9265903251,null,"Computations for Karnataka"]
["Himachal Pradesh",50.11,10.85,506,0.57434733257661752,64.03,7.72,375,0.42565266742338254,114.14,18.579999999999998,881,990316.2055335968,1707466.6666666665,1295573.2122587969,1165077.888863055,2008784.3137254901,1524203.7791279964,null,"Total Sanctioned (A, from MoHuA Data) - Jum - 2020",{"$f":"L11","v":52922}]
["Jharkhand",434.39,85.62,3867,0.45839260312944524,797.74,86.6,4569,0.54160739687055481,1232.1199999999999,172.22,8436,1123325.5753814327,1745983.8038958197,1460550.0237079184,1321559.5004487443,2054098.5928186115,1718294.1455387275,null,"Avg CLSS/Yr over past 4 Yrs (B=A/4)",13230.5]
["Kamataka",1930.92,375.43,16900,0.31933789350364689,9477.09,767.11,36022,0.68066210649635317,11408.01,1142.54,52922,1142556.2130177515,2630917.2172561213,2155627.1493896679,1344183.780020884,3095196.7261836724,2536031.9404584328,null,"Avg CLSS Monthly (C=B/12)",1102.5416666666667]
["Kerala",875.69,258.62,12439,0.79411389172625124,611.86,65.989999999999995,3225,0.20588610827374873,1487.54,324.61,15664,703987.4587989389,1897240.3100775196,949655.26046986715,828220.53976345749,2232047.4236206114,1117241.4829057262,null,"MIG % (D, from MoHUA Data)",0.68066210649635317]
["Madhya Pradesh",4395.51,1137.42,50835,0.80221878550688042,1970.14,247.76,12533,0.19778121449311956,6365.65,1385.17,63368,864662.14222484513,1571962.0202664966,1004552.7711147582,1017249.5790880531,1849367.0826664667,1181826.7895467745,null,"LIG % (E, from MoHUA Data)",0.31933789350364689]
["Maharashtra",25060.17,4448.26,183056,0.69417488614084788,21563.3,1765.76,80647,0.30582511385915218,46623.46,6214.03,263703,1368989.2710427409,2673788.2376281819,1768029.1843475425,1610575.6129914599,3145633.2207390377,2080034.3345265207,null,"MIG Projected Over remaining Plan Period (Jul '20 - Mar '21) F = C*D*9 months",6754.1250000000018]
["Odisha",216.56,49.47,2548,0.44205412907702984,590.97,61.63,3216,0.55794587092297021,807.52,111.11,5764,849921.50706436427,1837593.2835820897,1400971.547536433,999907.65536984033,2161874.4512730469,1648201.8206310978,null,"LIG Projected Over remaining Plan Period (Jul '20 - Mar '22) G = C*E*21 months",7393.75]
["Punjab",1192.19,262.88,11467,0.61406233265502841,1329.14,151.22999999999999,7207,0.38593766734497159,2521.33,414.11,18674,1039670.3584198134,1844234.7717496878,1350182.0713291208,1223141.5981409571,2169687.9667643388,1588449.4956813187,null,"Projection (Total) H = F+G",{"$f":"U15+U14","v":14147.875000000002}]
["Rajasthan",3461.06,839.23,40015,0.72276208366447514,2650.06,306.64999999999998,15349,0.27723791633552491,6111.12,1145.8800000000001,55364,864940.64725727844,1726535.9306795232,1103807.5283577777,1017577.2320673864,2031218.7419759096,1298597.0921856209,null,"Sanctioned + Projected I = A+H",67069.875]
["Tamil Nadu",2893.72,577.83000000000004,26452,0.52093426286974676,5367.86,495.73,24326,0.47906573713025324,8261.58,1073.56,50778,1093951.3080296386,2206634.8762640795,1626999.8818385913,1287001.5388583983,2596041.030898917,1914117.5080454017,null,"Total Demand J",510000]
["Telangana",1743.3,300.66000000000003,12454,0.31250627321088026,6445.91,586.91,27398,0.6874937267891198,8189.21,887.57,39852,1399791.2317327766,2352693.6272720634,2054905.650908361,1646813.2138032666,2767874.8556141923,2417536.0598921892,null,"96% of Total Demand K=J*96%",{"$f":"U18*96%","v":489600}]
["Uttar Pradesh",4188.8100000000004,873.37,38123,0.49869188708369305,7677.11,777.32,38323,0.50130811291630695,11865.92,1650.68,76446,1098761.9022637254,2003264.358218302,1552196.3215864792,1292661.0614867357,2356781.5979038849,1826113.3195135051,null,"% of Total L = I/K",{"$f":"U17/U19","v":0.13698912377450981}]
["Uttarakhand",569.09,135.09,6141,0.65385434412265753,536.54999999999995,64.89,3251,0.34614565587734242,1105.6400000000001,199.97,9392,926705.74824947084,1650415.2568440477,1177214.6507666099,1090242.0567640834,1941665.0080518208,1384958.4126666,null,"We round off 14,148 to 14,200 and 13.7% to 13.5% for our computation purpose"]
["West Bengal",2372.29,465.5,19527,0.57462774409981754,2895.63,299.26,14455,0.42537225590018246,5267.91,764.77,33982,1214876.8371997746,2003203.0439294362,1550205.9914072156,1429266.8672938524,2356709.4634463955,1823771.7545967242]
["Sub-Total",78515.22,16232.55,692998,0.66797949595837502,76563.97,7219.83,344456,0.33202050404162498,155079.19,23452.38,1037454,1132979.0273565003,2222750.36579418,1494805.4564346948,1332916.5027723534,2615000.4303460941,1758594.6546290528]
["Arunachal Pradesh",0.5,0.11,6,0.15789473684210525,5.52,0.68,32,0.84210526315789469,6.02,0.79,38,833333.33333333326,1724999.9999999998,1584210.5263157894,980392.15686274506,2029411.7647058822,1863777.0897832818]
["Assam",69.989999999999995,15.73,760,0.45673076923076922,154.54,17.53,904,0.54326923076923073,224.53,33.26,1664,920921.05263157887,1709513.2743362831,1349338.9423076923,1083436.53250774,2011192.0874544508,1587457.5791855203]
["Manipur",8.69,2.69,160,0.90909090909090906,1.94,0.33,16,9.0909090909090912E-2,10.62,3.03,176,543125,1212500,603409.09090909082,638970.5882352941,1426470.5882352942,709893.04812834214]
["Meghalaya",7.73,2.21,122,0.82432432432432434,3.74,0.46,26,0.17567567567567569,11.47,2.67,148,633606.55737704923,1438461.5384615385,775000,745419.47926711675,1692307.6923076925,911764.70588235301]
["Mizoram",59.08,16.29,915,0.8988212180746562,10.31,1.65,103,0.10117878192534381,69.39,17.95,1018,645683.0601092896,1000970.8737864079,681630.6483300589,759627.12954034074,1177612.7926898915,801918.40980006929]
["Nagaland",1.0900000000000001,0.28999999999999998,16,0.59259259259259256,0.81,0.17,11,0.40740740740740738,1.9,0.46,27,681250,736363.63636363635,703703.70370370359,801470.5882352941,866310.16042780748,827886.71023965126]
["Sikkim",2.58,0.66,30,0.78947368421052633,1.25,0.15,8,0.21052631578947367,3.83,0.82,38,860000.00000000012,1562500,1007894.7368421053,1011764.7058823531,1838235.2941176472,1185758.5139318886]
["Tripura",50.6,12.79,604,0.58697764820213805,62.93,8.2200000000000006,425,0.41302235179786201,113.53,21.01,1029,837748.34437086096,1480705.8823529412,1103304.178814383,985586.28749513056,1742006.920415225,1298004.9162522154]
["Sub-Total (NE)",200.25,50.78,2613,0.63146447559207342,241.05,29.2,1525,0.36853552440792653,441.3,79.98,4138,766360.50516647531,1580655.7377049183,1066457.2257129049,901600.59431350033,1859594.9855351979,1254655.559662241]
["A&N Island",0.17,0.05,3,1,null,null,null,0,0.17,0.05,3,566666.66666666674,null,566666.66666666674,666666.66666666674,0,666666.66666666674]
["Chandigarh",31.4,5.03,214,0.33229813664596275,111.75,9.42,430,0.66770186335403725,143.15,14.45,644,1467289.719626168,{"$f":"(F34/H34)*10000000","v":2598837.2093023253},2222826.086956522,1726223.1995601978,3057455.5403556768,2615089.5140664964]
["DNH and DD",273.54000000000002,68.16,2894,0.8973643410852713,52.63,6.61,331,0.10263565891472869,326.16000000000003,74.77,3225,945196.95922598487,{"$f":"(F35/H35)*10000000","v":1590030.2114803628},1011348.8372093025,1111996.4226188057,1870623.7782121915,1189822.1614227088]
["NCR",1394.23,236.63,9821,0.48977658088968684,2440.48,217.1,10231,0.51022341911031321,3834.71,453.73,20052,1419641.5843600449,{"$f":"(F36/H36)*10000000","v":2385377.773433682},1912382.8047077598,1670166.5698353469,2806326.7922749203,2249862.1231855997]
["J&K",78.73,26.76,1304,0.84401294498381874,30.44,4.2699999999999996,241,0.15598705501618124,109.17,31.03,1545,603757.66871165647,{"$f":"(F37/H37)*10000000","v":1263070.5394190871},706601.94174757286,710303.13966077229,1485965.3404930437,831296.40205596806]
["Ladakh",1.52,0.44,47,0.77049180327868849,0.36,0.06,14,0.22950819672131148,1.88,0.49,61,323404.25531914894,{"$f":"(F38/H38)*10000000","v":257142.85714285713},308196.72131147538,380475.59449311643,302521.00840336131,362584.37801350048]
["Lakshadweep"]
["Puducherry",35.42,7.61,364,{"$f":"D40/L40","v":0.50837988826815639},66.16,6.76,352,{"$f":"H40/L40","v":0.49162011173184356},101.57,14.37,716,{"$f":"(B40/D40)*10000000","v":973076.92307692312},{"$f":"(F40/H40)*10000000","v":1879545.4545454546},{"$f":"(J40/L40)*10000000","v":1418575.4189944132},{"$f":"M40/0.85","v":1144796.3800904979},2211229.9465240641,1668912.2576404861]
["Sub-total (UT)",1815,344.68,14647,{"$f":"D41/L41","v":0.55806599100815357},2701.81,244.21,11599,{"$f":"H41/L41","v":0.44193400899184637},4516.8100000000004,588.89,26246,{"$f":"(B41/D41)*10000000","v":1239161.6030586469},{"$f":"(F41/H41)*10000000","v":2329347.3575308216},{"$f":"(J41/L41)*10000000","v":1720951.7640783358},1457837.1800689965,2740408.6559186135,2024649.134209807]
["Grand Total",80530.47,16628.009999999998,710258,{"$f":"D42/L42","v":0.66513647201167214},79506.83,7493.24,357580,{"$f":"H42/L42","v":0.3348635279883278},160037.29999999999,24121.25,1067838,{"$f":"(B42/D42)*10000000","v":1133819.9640130769},{"$f":"(F42/H42)*10000000","v":2223469.713071201},{"$f":"(J42/L42)*10000000","v":1498703.9232542762},1333905.8400153846,2615846.7212602366,1763181.0861815014]

{"sheet":"GSDP by State","index":7,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
["","GSDP in ('000 Crore)"]
["States/UTs","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17"]
["Andaman and Nicobar Islands",3.9786691451756999,4.1567132675423295,4.4886146971276295,4.7418563442681698,5.1331895713422195,5.5659000000000001]
["Andhra Pradesh",379.40158000000002,380.62901073573204,407.11474244340502,441.74118064678402,490.13409046283999,547.02144999999996]
["Arunachal Pradesh",11.06269,11.29917,12.338340000000001,14.40296,16.662479999999999,17.303439999999998]
["Assam",143.17491000000001,147.34237999999999,154.52539999999999,165.212302693998,178.929643475652,200.79]
["Bihar",247.14396140589901,256.85096124460398,269.64984200906201,279.482436905751,300.56608566881704,331.57178581573504]
["Chandigarh",18.768551190815,20.285538492785001,22.105082664481603,22.955592573756501,24.537182898780699,26.679025133567002]
["Chattisgarh",158.07382999999999,165.93650401207501,182.228983,196.02301,209.011715409267,223.93199876517301]
["Delhi",343.79750130944103,366.62836628485798,392.90838262600897,428.89923767771302,474.05771567366696,514.87079415551796]
["Goa",42.366656485520899,35.850220477843301,31.568462293091699,40.116491457800997,44.717279589001897,51.847000000000001]
["Gujarat",615.60606993131603,682.65021222667394,734.28386634302797,811.42764400889689,894.66723292396398,984.59751534184795]
["Haryana",297.538520682399,320.56951971336701,346.79932406603297,366.63586724684603,399.64593712654204,434.60792723301904]
["Himachal Pradesh",72.719845104592494,77.384274364323602,82.846691769353598,89.068035357312212,97.206660307392795,103.913944143207]
["Jammu & Kashmir",78.255548082352192,80.7749350399706,85.087226401314012,84.823605259895103,97.289270602313508,102.206]
["Jharkhand",150.91758999999999,163.25027,165.81626,186.53439,197.53559999999999,212.72058000000001]
["Karnataka",606.009810541825,643.29221294551303,704.84868632139205,751.907703222328,813.49740921068405,874.39479123197009]
["Kerala",364.04788938524098,387.69345827096998,402.78133080111502,419.95555337255405,447.69236522703403,480.87790758241601]
["Madhya Pradesh",315.56159000000002,351.68261999999999,365.13394,384.10514999999998,407.97001,465.13553000000002]
["Maharashtra",1275.9478802477299,1352.4707092315302,1451.2075850210401,1530.2110046699602,1659.7760498369501,1815.498]
["Manipur",12.9146058,12.984962599999999,14.116201100000001,15.09994,15.8563922,16.989000000000001]
["Meghalaya",19.917743723558999,20.3535653706763,20.725706245119699,20.158330823435598,21.756485688882698,23.089416353583299]
["Mizoram",7.2586899999999996,7.7779699999999998,9.0384149973588102,11.2610488620855,12.487734001903899,13.789]
["Nagaland",12.1767418686849,12.867896286694801,13.7925852599653,14.3987691358546,14.851109727587099,15.510999999999999]
["Odisha",230.98707362078702,243.36347587464002,265.89151717671098,270.66993618938403,292.79239965478098,323.21772722869599]
["Puducherry",16.818010000000001,17.31043,19.170249999999999,18.206652471395902,20.03237,21.989609999999999]
["Punjab",266.628291277865,280.82285152698802,299.44972885300001,312.02520656638802,328.97315177524598,348.48663372592705]
["Rajasthan",434.83663802119298,454.56433990221598,486.23018310181698,521.70036456490004,558.144328061235,599.029442746874]
["Sikkim",11.165096836958,11.4212053594224,12.114047955056201,13.070970912659401,14.0868415388813,15.095243049353]
["Tamil Nadu",751.485760422,792.16378820595298,852.21333950054998,893.89568758005692,948.67384583831097,1019.0780034220501]
["Telangana",359.43410999999998,369.26235000000003,388.69391000000002,415.21014000000002,452.06328999999999,497.95744000000002]
["Tripura",19.208410000000001,20.872969999999999,22.819109999999998,24.814240000000002,27.8203,29.146000000000001]
["Uttar Pradesh",724.05038999999999,758.20497,802.06969000000004,834.43236000000002,901.64490999999998,966.61857739999994]
["Uttarakhand",115.32758698443,123.710060996788,134.18235369323,141.27764371565999,151.90072606331699,162.45071800564301]
["West Bengal",520.48500000000001,542.19100000000003,558.49699999999996,574.36400000000003,609.54499999999996,657.88300000000004]
[]
[]
["Source: RBI Handbook of Statistics on Indian States"]
["https://m.rbi.org.in/Scripts/AnnualPublications.aspx?head=Handbook+of+Statistics+on+Indian+States"]
[]
["For WB and some other states in 2016-17, it is CMIE's States of India Database"]
["For Tripura, in 2016-17, it is Tripura's economic statistics document"]

{"sheet":"GDP and GSDP by State","index":8,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Linear Relationship Between GDP and GSDP for \"&'User Inputs'!$D$3","v":"Linear Relationship Between GDP and GSDP for Karnataka"}]
["State",{"$f":"'User Inputs'!D3","v":"Karnataka"}]
[]
["Year","GDP","GSDP"]
["2011-12",8736.3289999999997,{"$f":"VLOOKUP($B$2,'GSDP by State'!$A$2:$G$35,MATCH('GDP and GSDP by State'!A5,'GSDP by State'!$A$2:$G$2,0),0)","v":606.009810541825}]
["2012-13",9213.0169999999998,{"$f":"VLOOKUP($B$2,'GSDP by State'!$A$2:$G$35,MATCH('GDP and GSDP by State'!A6,'GSDP by State'!$A$2:$G$2,0),0)","v":643.29221294551303}]
["2013-14",9801.3700000000008,{"$f":"VLOOKUP($B$2,'GSDP by State'!$A$2:$G$35,MATCH('GDP and GSDP by State'!A7,'GSDP by State'!$A$2:$G$2,0),0)","v":704.84868632139205}]
["2014-15",10527.674000000001,{"$f":"VLOOKUP($B$2,'GSDP by State'!$A$2:$G$35,MATCH('GDP and GSDP by State'!A8,'GSDP by State'!$A$2:$G$2,0),0)","v":751.907703222328}]
["2015-16",11386.145,{"$f":"VLOOKUP($B$2,'GSDP by State'!$A$2:$G$35,MATCH('GDP and GSDP by State'!A9,'GSDP by State'!$A$2:$G$2,0),0)","v":813.49740921068405},null,"coefficients:"]
["2016-17",12196.005999999999,{"$f":"VLOOKUP($B$2,'GSDP by State'!$A$2:$G$35,MATCH('GDP and GSDP by State'!A10,'GSDP by State'!$A$2:$G$2,0),0)","v":874.39479123197009},null,"slope",{"$f":"SLOPE(Table1[GSDP],Table1[GDP])","v":7.7000492688679686E-2}]
["2017-18",13012,{"$f":"B11*$F$10+$F$11","v":940.37349061267378},null,"intercept",{"$f":"INTERCEPT(Table1[GSDP],Table1[GDP])","v":-61.556920252426266}]
["2018-19",13962,{"$f":"B12*$F$10+$F$11","v":1013.5239586669196}]
["2019-20",15005,{"$f":"B13*$F$10+$F$11","v":1093.8354725412123}]
["2020-21",16149,{"$f":"B14*$F$10+$F$11","v":1181.9240361770621}]
["2021-22",17379,{"$f":"B15*$F$10+$F$11","v":1276.6346421841381}]

{"sheet":"Current SD+RC Rate by State","index":10,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Current Stamp Duty + Registration Charge Rates for Property Transactions"]
["States","SD rates"]
["Andhra Pradesh",5.5E-2]
["Arunachal Pradesh",0.06]
["Assam",8.2500000000000004E-2]
["Bihar",0.06]
["Chandigarh",7.0000000000000007E-2]
["Chattisgarh",8.5000000000000006E-2]
["Delhi",0.04]
["Goa",0.08]
["Gujarat",4.5499999999999999E-2]
["Himachal Pradesh",0.08]
["Haryana",0.06]
["Jharkhand",7.0000000000000007E-2]
["Jammu & Kashmir",0.05]
["Karnataka",7.5999999999999998E-2,null,"<- also 1% SD on mortgage added"]
["Kerala",8.5000000000000006E-2]
["Manipur",7.0000000000000007E-2]
["Meghalaya",9.9000000000000005E-2]
["Maharashtra",0.05]
["Mizoram",0.06]
["Madhya Pradesh",0.09]
["Nagaland",7.0000000000000007E-2]
["Odisha",0.09]
["Punjab",7.0000000000000007E-2]
["Puducherry",0.08]
["Rajasthan",0.05]
["Sikkim",7.0000000000000007E-2]
["Tamil Nadu",0.08]
["Telengana",5.5E-2]
["Tripura",0.05]
["Uttarakhand",0.04]
["Uttar Pradesh",0.06]
["West Bengal",6.905457618617622E-2]

{"sheet":"SD as Pct of GSDP","index":11,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Stamp Duty Revenues as % of State GSDP"]
["State","SD as % of GSDP"]
["Andhra Pradesh",1.2695846000341541E-2]
["Arunachal Pradesh",1.849395927218607E-4]
["Assam",1.3554598608347427E-3]
["Bihar",5.869270314310779E-3]
["Chattisgarh",5.7973311529734102E-3]
["Delhi",7.5447302726319469E-3]
["Goa",5.8278095154390246E-3]
["Gujarat",5.9874326449177824E-3]
["Himachal Pradesh",2.5798613032132858E-3]
["Haryana",9.6246149319938017E-3]
["Jharkhand",2.5684953449561288E-3]
["Jammu & Kashmir",1.9798133002758419E-3]
["Karnataka",1.0523532304568069E-2]
["Kerala",9.4319911071461676E-3]
["Manipur",4.4540251418659127E-4]
["Meghalaya",6.7214864509986167E-4]
["Maharashtra",1.1695996823949215E-2]
["Mizoram",6.8529579937237007E-5]
["Madhya Pradesh",8.7639075504428038E-3]
["Nagaland",1.173800879677573E-4]
["Odisha",2.5379666794558813E-3]
["Punjab",1.1243448565887184E-2]
["Puducherry",3.6958699188792557E-3]
["Rajasthan",6.6839513951650028E-3]
["Sikkim",9.9452952645143178E-4]
["Tamil Nadu",9.3804080113556905E-3]
["Tripura",1.3917394220909483E-3]
["Uttarakhand",7.6728049709537368E-3]
["Uttar Pradesh",1.0730253083267572E-2]
["West Bengal",5.0555380921091884E-3]
[]
["Source: SD data and State GSDP data from RBI's Handbook of Statistics on Indian States and CMIE's States of India Database"]