{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Macro1","Required information for NPV","PRAs DETAIL FORMAT","Reference PVIF calculation","Incremental Type Details","Demo Screen"],"not_rendered":{"charts":0,"images":3,"macros":1,"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":"Macro1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Required information for NPV","index":1,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Necessary Details For NPV E-auction :","Below are the necessary details for the NPV E-Auction.\nBased on your provided details,\nwe will create and provide you with a screen for adding bids for (Resolution Applicant)","Site URL :  https://www.eauctions.co.in\nEmail ID : admin@eauctions.co.in"]
["Questions","Answers"]
["Auctioneer  Name & Auctioneer Email ID (Not CIRP Email)","?","Debtor Name & Email Id (CIRP)","?"]
["NPV Auction Title","?","Debtor Address","?"]
["E-auction start and end dates and times","?","EMD Date (optional)","?"]
["Reserve Price / Start Price / Base Price ","?","EMD Amount ( optional)","?"]
["Incremental Amount","?","Incremental Type ?","Minimal Increment / Fixed Increment"]
["Incremental  Type","Only Base Value / Both ( Base Value & NPV Value) / Bid as NPV with Increment ( Most Used)","First Bid Acceptance ?","Reserve Price  /  Reserve Price + Increment Price"]
["Upfront payment?"," Yes / No (Upfront payment days E.g  30, 45, 90 )"]
["Number Of Period","24 Months /  12 Quarters /  5 years\n","If you enter a value in B10 (e.g., 12 Months), the Excel will automatically create 12 rows in the PVIF table.\nThe same logic applies for Quarters and Years, where rows are generated based on the selected period"]
["Name Of Category Of Creditors","Examples: CIRP Cost, Financial Creditors, Operational Creditors, Government Dues"]
["Number of Minutes E-Auction extended","10 Minutes / 15 Minutes /  30 Minutes","Recommended : 15 minutes with unlimited extension of 15 minutes each"]
[]
["Resolution plan e-bidding plan please do provider information like","PVIF ( You can take Reference PVIF calculation sheet )","PVIF (%)"]
["Month 1"]
["Month 2"]
["Month 3"]
["Month 4"]
["Month 5"]
["Month 6"]
["Month 7"]
["Month 8"]
["Month 9"]
["Month 10"]
["Month 11"]
["Month 12"]
["Month 13"]
["Month 14"]
["Month 15"]
["Month 16"]
["Month 17"]
["Month 18"]
["Month 19"]
["Month 20"]
["Month 21"]
["Month 22"]
["Month 23"]
["Month 24"]

{"sheet":"PRAs DETAIL FORMAT","index":2,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Sr. No","Company Name","Bidder / Contact Person Name","Email ID","Mobile No","PAN Card"]
[1]
[2]
[3]
[4]
[5]
[6]

{"sheet":"Reference PVIF calculation","index":3,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Day","PVIF (@10%)","PVIF (@12%)","PVIF (@15%)","PVIF (@20%)"]
[0,{"$f":"1/(1+0.1)^(0/360)","v":1},{"$f":"1/(1+0.12)^(0/360)","v":1},{"$f":"1/(1+0.15)^(0/360)","v":1},{"$f":"1/(1+0.2)^(0/360)","v":1}]
[30,{"$f":"1/(1+0.1)^(30/360)","v":0.99208894344699095},{"$f":"1/(1+0.12)^(30/360)","v":0.99060039794300325},{"$f":"ROUND(1/(1+0.15)^(+A3/360),4)","v":0.98839999999999995},{"$f":"ROUND(1/(1+0.2)^(+A3/360),4)","v":0.9849}]
[60,{"$f":"ROUND(1/(1+0.1)^(+A4/360),4)","v":0.98419999999999996},{"$f":"ROUND(1/(1+0.12)^(+A4/360),4)","v":0.98129999999999995},{"$f":"ROUND(1/(1+0.15)^(+A4/360),4)","v":0.97699999999999998},{"$f":"ROUND(1/(1+0.2)^(+A4/360),4)","v":0.97009999999999996}]
[90,{"$f":"ROUND(1/(1+0.1)^(+A5/360),4)","v":0.97650000000000003},{"$f":"1/(1+0.12)^(+A5/360)","v":0.972065420906982},0.9657,0.95540000000000003]
[120,0.96870000000000001,{"$f":"1/(1+0.12)^(+A6/360)","v":0.96292839277708941},0.95450000000000002,0.94099999999999995]
[150,0.96109999999999995,0.95387724907560134,0.94340000000000002,0.92679999999999996]
[180,0.95350000000000001,0.94491118252306794,0.9325,0.91290000000000004]
[210,0.94589999999999996,0.93602939342814506,0.92169999999999996,0.89910000000000001]
[240,0.93840000000000001,0.92723108961626854,0.91100000000000003,0.88549999999999995]
[270,0.93100000000000005,0.91851548635900027,0.90049999999999997,0.87219999999999998]
[300,0.92359999999999998,0.90988180630403681,0.8901,0.85899999999999999]
[330,0.9163,0.90132927940587759,0.87980000000000003,0.84609999999999996]
[360,0.90910000000000002,0.89285714285714279,0.86960000000000004,0.83330000000000004]
[390,0.90190000000000003,0.88446464102053857,0.85950000000000004,0.82079999999999997]
[420,0.89480000000000004,0.87615102536146106,0.84950000000000003,0.80840000000000001]
[450,0.88770000000000004,0.8679155543812338,0.8397,0.79620000000000002]
[480,0.88070000000000004,0.85975749355097253,0.83,0.78420000000000001]
[510,0.87370000000000003,0.85167611524607267,0.82040000000000002,0.77239999999999998]
[540,0.86680000000000001,0.84367069868131062,0.81089999999999995,0.76070000000000004]
[570,0.8599,0.835740529846558,0.80149999999999999,0.74929999999999997]
[600,0.85309999999999997,0.82788490144309679,0.79220000000000002,0.73799999999999999]
[630,0.84640000000000004,0.82010311282053572,0.78300000000000003,0.7268]
[660,0.8397,0.81239446991431852,0.77400000000000002,0.71589999999999998]
[690,0.83299999999999996,0.8047582851838192,0.76500000000000001,0.70509999999999995]
[720,0.82640000000000002,0.79719387755102034,0.75609999999999999,0.69440000000000002]
[750,0.81989999999999996,0.78970057233976654,0.74739999999999995,0.68400000000000005]
[780,0.81340000000000001,0.78227770121559026,0.73870000000000002,0.67369999999999997]
[810,0.80700000000000005,0.77492460212610159,0.73019999999999996,0.66349999999999998]
[840,0.80059999999999998,0.76764061924193971,0.72170000000000001,0.65349999999999997]
[870,0.79430000000000001,0.76042510289827903,0.71340000000000003,0.64359999999999995]
[900,0.78800000000000003,0.75327740953688449,0.70509999999999995,0.63390000000000002]
[930,0.78180000000000005,0.74619690164871233,0.69689999999999996,0.62439999999999996]
[960,0.77559999999999996,0.73918294771705073,0.68889999999999996,0.61499999999999999]
[990,0.76939999999999997,0.73223492216119268,0.68089999999999995,0.60570000000000002]
[1020,0.76329999999999998,0.72535220528064148,0.67300000000000004,0.59660000000000002]
[1050,0.75729999999999997,0.71853418319983853,0.66520000000000001,0.58760000000000001]
[1080,0.75129999999999997,0.71178024781341087,0.65749999999999997,0.57869999999999999]
[1110,0.74539999999999995,0.70508979673193428,0.64990000000000003,0.56999999999999995]
[1140,0.73950000000000005,0.69846223322820555,0.64239999999999997,0.56140000000000001]
[1170,0.73360000000000003,0.69189696618401919,0.63490000000000002,0.55289999999999995]
[1200,0.7278,0.68539341003744614,0.62760000000000005,0.54459999999999997]
[1230,0.72209999999999996,0.67895098473060622,0.62029999999999996,0.53639999999999999]
[1260,0.71640000000000004,0.67256911565793243,0.61309999999999998,0.52829999999999999]
[1320,0.70509999999999995,0.65998477474736661,0.59899999999999998,0.51249999999999996]
[1350,0.69950000000000001,0.65378118050106482,0.59209999999999996,0.50470000000000004]
[1380,0.69389999999999996,0.64763589757200124,0.58520000000000005,0.49709999999999999]
[1410,0.6885,0.64154837785699859,0.57850000000000001,0.48959999999999998]
[1440,0.68300000000000005,0.63551807840483121,0.57179999999999997,0.48230000000000001]
[1470,0.67759999999999998,0.62954446136779851,0.56510000000000005,0.47499999999999998]
[1500,0.67220000000000002,0.62362699395375476,0.55859999999999999,0.46779999999999999]
[1530,0.66690000000000005,0.61776514837858854,0.55210000000000004,0.46079999999999999]
[1560,0.66169999999999995,0.61195840181914829,0.54569999999999996,0.45379999999999998]
[1590,0.65639999999999998,0.60620623636661264,0.53939999999999999,0.44700000000000001]
[1620,0.6512,0.60050813898029676,0.53320000000000001,0.44019999999999998]
[1650,0.64610000000000001,0.59486360144189432,0.52700000000000002,0.43359999999999999]
[1680,0.64100000000000001,0.58927212031014864,0.52090000000000003,0.42709999999999998]
[1710,0.63590000000000002,0.5837331968759506,0.51490000000000002,0.42059999999999997]
[1740,0.63090000000000002,0.57824633711785822,0.50890000000000002,0.4143]
[1770,0.62590000000000001,0.57281105165803436,0.503,0.40799999999999997]
[1800,0.62090000000000001,0.56742685571859919,0.49719999999999998,0.40189999999999998]

{"sheet":"Incremental Type Details","index":4,"n_rows":61,"n_cols":1,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Incremental Type details informations "]
[]
["Options:"]
[]
["1) Only Base Value"]
[]
["2) Both (Base Value & NPV Value)"]
[]
["3) Bid as NPV With Increment"]
[]
[]
[]
["Description:"]
[]
["This setting defines how bid increments are applied during the NPV auction."]
[]
[]
[]
["1. Only Base Value"]
[]
["Example:"]
[]
["Reserve Price: 5,000"]
[]
["Incremental Value: 100"]
[]
["Process:"]
[]
["First actual bid: 5,100 → NPV generated: 5,002"]
[]
["Next bidder must place a base bid of 5,200 (5,100 + 100)"]
["→ NPV generated: 5,100.68"]
[]
["In this option, bidding continues by increasing only the base value, and each new NPV value must always be higher than the previous NPV."]
[]
[]
[]
["2. Both (Base Value & NPV Value)"]
[]
["Example:"]
[]
["First actual bid: 5,100 → NPV generated: 5,100"]
[]
["Next bidder places a bid of 5,250"]
["→ NPV generated: 5,202 (Minimum NPV: 5,200)"]
[]
["In this option, both base value and NPV value follow the incremental rule, and each new NPV must be higher than the last NPV by the defined increment."]
[]
[]
[]
["3. Bid as NPV With Increment (Recommended / Most Used)"]
[]
["Example:"]
[]
["First bid: 5,200 → NPV generated: 5,100.68"]
[]
["Next bidder must bid at least"]
["Last NPV (5,100.68) + Increment (100) = 5,200.68"]
["→ NPV generated: 5,200.68 (Minimum: 5,200.68)"]
[]
["In this option, bidding is done directly on NPV values, and each new bid must exceed the last NPV by the incremental value, making it the most transparent and widely used approach."]

{"sheet":"Demo Screen","index":5,"n_rows":47,"n_cols":17,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["URL : https://eauctions.co.in",null,"1) Auctioneer Login",null,null,null,null,null,null,null,null,null,null,null,null,null,"Site URL :  https://www.eauctions.co.in\nTechnical contact : 98700 99713 (Nitish)\nEmail ID : admin@eauctions.co.in"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"AucAuctioneerioneer "]
[]
[]
[null,null,"2) PRAs Login "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," 3) PRAs Demo Sheet"]