Spreadsheet: 173442d1344550859-if-and-function-to-list-out-production-depending-on-which-month-the-business-starts-srilanka-dc-phase-1-3-model-draft-internet
Sheet: Assumptions - new

 | :--- Input cells
 | :--- [NAME] cell
Facility Related Assumptions
 |  |  | Phase I | Phase II | Phase III
 | DC Launch Year ( Financial Year - FY ) |  | 2015 | 2014 | 2015 |  | 2013
 | Start Month |  | April | April | April |  | 2014
 | Area of the server farm (sqft) phase 1 |  | 10000 | 10000 | 10000 |  | 2015 | April
 | Area occupied per rack (sqft) phase 1 |  |  |  |  |  | 2016 | May
 | Number of racks (#) phase 1 |  | 300 | 300 | 300 |  | 2017 | June
 | Number of seats |  | 30 | 30 | 30 |  | 2018 | Jul
 | % OF Racks that can be populated For Third Party |  | 0.95 | 0.95 | 0.95 |  | 2019 | Aug
 | Total No. of Racks that can be populated for Third party |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  | Oct
 | Service Mix in % Of Racks |  |  |  |  |  |  | Nov
 | % of racks to be sold in Colocation |  |  |  |  |  |  | Dec
 | Bandwidth to be sold in each [NAME] in Mbps |  | 1 | 1 | 1 |  |  | Jan
 | % of racks to be sold in Bandwidth |  |  |  |  |  |  | Feb
 | % of racks to be sold with Managed Services |  |  |  |  |  |  | Mar
Power Related Assumptions
 | Power charges per kw-hr (INR) |  | 7.5 | 7.5 | 7.5
 | Increase in unit power charges per year |  | 0.03 | 0.03 | 0.03
 | Power consumed per rack incl cooling (kw) |  | 3 | 3 | 3
 | Additional Power that will be sold per [NAME] in KVA |  | 0 | 0 | 0
 | Annual increase in power consumption (%) |  | 0.02 | 0.02 | 0.02
 | Diesel charges per kw-hr (INR) |  | 10 | 10 | 10
 | Hours per day when DG sets need to be used (hrs) |  | 4 | 4 | 4
 | Power factor |  | 0.8 | 0.8 | 0.8
 | Annual minimum power commitment (INR per KVA per year)
Bandwidth Related Assumptions
 | Cost of bandwidth per Mbps per year (INR)
 | Bandwidth sold per rack ([NAME]) |  | 1 | 1 | 1
 | Increase in bandwidth consumption per year (%) |  | 0.05 | 0.05 | 0.05
 | Decrease in bandwidth cost / price per year (%) |  | 0.15 | 0.15 | 0.15
 | Decrease in Bandwidth revenue /cost per Year
[NAME] related Assumptions
 | Annual increase in manpower cost (%) |  | 0.1 | 0.1 | 0.1
 | Administrative Expenses (Incl Communication and Office Expenses) per month |  | 500000 | 500000 | 500000
Sales and Marketing related Assumptions
 | Sales and marketing cost for first year |  | 5000000 | 5000000 | 5000000
 | Annual increase  in sales and marketing cost |  | 0.05 | 0.05 | 0.05
Financing Related Assumptions
 | Interest rate(%) |  | 0.1275 | 0.1275 | 0.1275
 | Preliminary expenses |  | 10000000 | 10000000 | 10000000
 | Tech refresh |  | 0.03 | 0.03 | 0.03
 | Depreciation for preliminary expenses (% each year) |  | 0.2 | 0.2 | 0.2
 | Legal and statutory charges per year |  | 2000000 | 2000000 | 2000000
 | AMC as a percent of capex |  | 0.04 | 0.04 | 0.04
 | Rent / Month / Sft in Rs. |  | 50 | 50 | 50
 | Increase in Rent year-on-year |  | 0.1 | 0.1 | 0.1
 | Receivables - credit period | Months | 3 | 3 | 3
 | Payables - credit period | Months | 1 | 1 | 1
Revenue Related Assumptions
 | Increase in revenue per year for space / services / racks |  | 0.03 | 0.03 | 0.03
 | Corporate tax rate |  | 0.3399 | 0.3399 | 0.3399