{"text_format":"2","workbook":"xlsx","n_sheets":12,"sheets":["Summary sheet ","Income Statement ","Cash Flow","Debtors and Creditors","Balance Sheet","Intangible Asset","Equity_Debt","Total Addressable Market","Customer Conversion Rate","Budgeted Sales per Customer","Manpower Expense","Marketing Expense"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Summary sheet ","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
["Funding Schedule"]
["Particulars",null,"Year 1","Year2 ","Year 3 ","Year 4","Year 5"]
[]
["Funding Ask:"]
["Application Development Cost",null,{"$f":"'Income Statement '!E45","v":1000000},{"$f":"'Income Statement '!F45","v":1400000},{"$f":"'Income Statement '!G45","v":1959999.9999999998},{"$f":"'Income Statement '!H45","v":2743999.9999999995},{"$f":"'Income Statement '!I45","v":3841599.9999999991}]
["Working Capital ",null,{"$f":"'Balance Sheet'!C33","v":6182761.7406200022},{"$f":"'Balance Sheet'!D33","v":63960671.705135159},{"$f":"'Balance Sheet'!E33","v":263414127.61857927},{"$f":"'Balance Sheet'!F33","v":678374543.22186029},{"$f":"'Balance Sheet'!G33","v":1475365945.1363585}]
["Marketing ",null,{"$f":"'Income Statement '!E48","v":1200000}]
["Manpower Cost",null,{"$f":"'Income Statement '!E47","v":5280000},{"$f":"'Manpower Expense'!H11","v":7488000},{"$f":"'Manpower Expense'!K11","v":10972800},{"$f":"'Manpower Expense'!N11","v":16606080},{"$f":"'Manpower Expense'!Q11","v":25934688}]
["Contingency Funds"]
["TOTAL FUNDS REQUIRED",null,{"$f":"SUM(C6:C10)","v":13662761.740620002},{"$f":"SUM(D6:D10)","v":72848671.705135167},276346927.61857927,697724623.22186029,1505142233.1363585]
["In Million Dollars ",null,null,null,"M&A ",null,"M&A"]
["Equity"]
["Opening Equity"]
["Owner's Equity Infusion"]
["Equity Raise",null,{"$f":"C11","v":13662761.740620002},{"$f":"D11","v":72848671.705135167},{"$f":"E11","v":276346927.61857927},{"$f":"F11","v":697724623.22186029},{"$f":"G11","v":1505142233.1363585}]
["Re-payment "]
["Closing Equity",null,{"$f":"SUM(C14:C17)","v":13662761.740620002},{"$f":"SUM(D14:D17)","v":72848671.705135167},276346927.61857927,697724623.22186029,1505142233.1363585]
[]
["Debt "]
["Opening Debt"]
["Debt Raised"]
["Interest",0.12]
["Principle Repayment"]
["Closing Debt "]
[]
["Working Capital"]
["Particulars",null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Credit Sales",0.5]
["Receivables Days",30]
["Inventory Days",45]
["Payables Days",30]
["Cash in Bank "]
["Total No of Days",365]
[]
["Change in Working Capital"]
[]
[]
["End of Sheet"]

{"sheet":"Income Statement ","index":1,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[5,4,5,8],[5,2,6,2],[5,1,6,1],[4,1,4,8],[32,1,32,8],[39,1,39,8],[17,1,17,8],[22,1,22,8],[28,1,28,8]]}
[]
[]
[]
[]
[null,"Total Addressable and Target Market"]
[null,"Revenue Streams","Industry Growth Rate",null,"Projected TAM"]
[null,null,null,"Existing facilities 2023","2025-26","2026-27","2027-28","2028-29","2029-30"]
[null,"Co-operative Housing Societies ",0.05,92000,{"$f":"D8*(1+$C8)","v":96600},{"$f":"E8*(1+$C8)","v":101430},{"$f":"F8*(1+$C8)","v":106501.5},{"$f":"G8*(1+$C8)","v":111826.57500000001},{"$f":"H8*(1+$C8)","v":117417.90375000001}]
[null,"Facility Management",0.02,347,{"$f":"D9*(1+$C9)","v":353.94},{"$f":"E9*(1+$C9)","v":361.0188},{"$f":"F9*(1+$C9)","v":368.23917599999999},{"$f":"G9*(1+$C9)","v":375.60395951999999},{"$f":"H9*(1+$C9)","v":383.11603871040001}]
[null,"Hotels",0.01,1547,{"$f":"D10*(1+$C10)","v":1562.47},{"$f":"E10*(1+$C10)","v":1578.0947000000001},{"$f":"F10*(1+$C10)","v":1593.8756470000001},{"$f":"G10*(1+$C10)","v":1609.8144034700001},{"$f":"H10*(1+$C10)","v":1625.9125475047001}]
[null,"Private Hospitals ",3.6799999999999999E-2,43486,{"$f":"D11*(1+$C11)","v":45086.284799999994},{"$f":"E11*(1+$C11)","v":46745.46008063999},{"$f":"F11*(1+$C11)","v":48465.693011607538},{"$f":"G11*(1+$C11)","v":50249.23051443469},{"$f":"H11*(1+$C11)","v":52098.402197365882}]
[null,"Private Schools ",0.04,34753,{"$f":"D12*(1+$C12)","v":36143.120000000003},{"$f":"E12*(1+$C12)","v":37588.844800000006},{"$f":"F12*(1+$C12)","v":39092.398592000005},{"$f":"G12*(1+$C12)","v":40656.094535680008},{"$f":"H12*(1+$C12)","v":42282.338317107213}]
[null,"Industrial Establishments ",0.05,246504,{"$f":"D13*(1+$C13)","v":258829.2},{"$f":"E13*(1+$C13)","v":271770.66000000003},{"$f":"F13*(1+$C13)","v":285359.19300000003},{"$f":"G13*(1+$C13)","v":299627.15265000006},{"$f":"H13*(1+$C13)","v":314608.51028250006}]
["A","Total Addressable Market",null,{"$f":"SUM(D8:D13)","v":418637},{"$f":"SUM(E8:E13)","v":438575.0148},{"$f":"SUM(F8:F13)","v":459474.07838064001},{"$f":"SUM(G8:G13)","v":481380.89942660759},{"$f":"SUM(H8:H13)","v":504344.47106310475},{"$f":"SUM(I8:I13)","v":528416.18313318829}]
["B","Target Market - 5% of TAM",null,null,{"$f":"E14*5%","v":21928.750740000003},{"$f":"F14*5%","v":22973.703919032003},{"$f":"G14*5%","v":24069.044971330382},{"$f":"H14*5%","v":25217.22355315524},{"$f":"I14*5%","v":26420.809156659416}]
[]
[]
[null,"New Customer Conversion Rate"]
[null,"Particular","Growth Rate",null,"Year 1 ","Year 2 ","Year 3","Year 4","Year 5 "]
[null,"Conversion Rate",0.35,null,6.4999999999999997E-3,1.4999999999999999E-2,0.02,0.03,0.04]
[null,"Total New customers added",null,null,{"$f":"E15*E20","v":142.53687981000002},{"$f":"F15*F20","v":344.60555878548001},{"$f":"G15*G20","v":481.38089942660764},{"$f":"H15*H20","v":756.51670659465719},{"$f":"I15*I20","v":1056.8323662663765}]
[]
[null,"Total Customers "]
[null,"Particular","Growth Rate","Initial Acquistion Rate ","Year 1 ","Year 2 ","Year 3","Year 4","Year 5 "]
[null,"New Customers",null,null,{"$f":"E21","v":142.53687981000002},344.60555878548001,481.38089942660764,756.51670659465719,1056.8323662663765]
[null,"Old Customers (Retention Rate - 53%)",null,null,null,{"$f":"E27*53%","v":75.544546299300009},{"$f":"F27*68%","v":285.70207145765045},{"$f":"G27*70%","v":536.95807961898061},{"$f":"H27*75%","v":970.10608966022835}]
["C","Total Customers ",null,null,{"$f":"E25","v":142.53687981000002},{"$f":"F25+F26","v":420.15010508478002},767.08297088425809,1293.4747862136378,2026.938455926605]
[]
[null,"Budgeted Sales per Customer"]
[null,"Particular","Growth Rate",null,"Year 1 ","Year 2 ","Year 3","Year 4","Year 5 "]
["D","AOV",0.2,null,600000,900000,1200000,1500000,1800000]
[]
[null,"Revenue"]
[null,"Particular","Formula",null,"Year 1 ","Year 2 ","Year 3","Year 4","Year 5 "]
["E","Revenue","Target Market*Conversion Rate* AOV",null,{"$f":"E27*E31","v":85522127.886000007},{"$f":"F27*F31","v":378135094.57630199},920499565.06110966,1940212179.3204567,3648489220.6678891]
[null,"Revenue in Dollar Millions",null,null,{"$f":"E35/85000000","v":1.0061426810117649},4.4486481714859059,10.829406647777761,22.826025639064198,42.923402596092814]
[null,"Growth Rate of Revenue",null,null,null,{"$f":"(F35-E35)/E35","v":3.4214883787778487},1.434314027616304,1.1077817447873002,0.88045887947458523]
[]
[]
[null,"Expenses"]
[null,"Particular","Rationaile","Growth Rate","Year 1 ","Year 2 ","Year 3","Year 4","Year 5 "]
[null,"Cost of Goods Sold","80% of Revenue",null,{"$f":"E35*80%","v":68417702.308800012},{"$f":"F35*79%","v":298726724.71527857},{"$f":"G35*75%","v":690374673.79583228},{"$f":"H35*75%","v":1455159134.4903426},{"$f":"I35*75%","v":2736366915.500917}]
[null,"Logistics / Shipping ","3% of Revenue",null,{"$f":"E35*3%","v":2565663.8365800004},11344052.83728906,27614986.951833289,58206365.379613698,109454676.62003668]
[null,"Rental Expenses",null,0.2,{"$f":"30000*12","v":360000},{"$f":"E44*(1+$D$44)","v":432000},518400,622080,746496]
[null,"Software Development",null,0.4,1000000,{"$f":"E45*(1+$D$45)","v":1400000},1959999.9999999998,2743999.9999999995,3841599.9999999991]
[null,"Laptop Rentals ",null,7.0000000000000007E-2,{"$f":"1800*12*10","v":216000},{"$f":"E46*(1+$D46)","v":231120},247298.40000000002,264609.28800000006,283131.93816000008]
[null,"Manpower Cost",null,"5 to 7%",{"$f":"'Manpower Expense'!E11","v":5280000},{"$f":"'Manpower Expense'!H11","v":7488000},{"$f":"'Manpower Expense'!G11","v":0},{"$f":"'Manpower Expense'!H11","v":7488000},{"$f":"'Manpower Expense'!I11","v":0}]
[null,"Marketing expenses",null,null,1200000,{"$f":"'Marketing Expense'!E7","v":420287.05921925401},{"$f":"'Marketing Expense'!H7","v":0},{"$f":"'Marketing Expense'!E7","v":420287.05921925401},{"$f":"'Marketing Expense'!F7","v":440346.81927765696}]
[null,"Other Utility & Supply Expenses ",null,0.05,300000,{"$f":"E49*(1+$D49)","v":315000},330750,347287.5,364651.875]
["F","Total Expenses",null,null,{"$f":"SUM(E42:E49)","v":79339366.145380005},320357184.61178684,721046109.1476655,1525251763.7171757,2851497818.7533913]
[]
["G","EBITDA / EBIT",null,null,{"$f":"E35-E50","v":6182761.7406200022},57777909.96451515,199453455.91344416,414960415.60328102,796991401.91449785]
[null,"Interest",null,null,{"$f":"Equity_Debt!D14","v":0},{"$f":"Equity_Debt!E14","v":0},{"$f":"Equity_Debt!F14","v":0},{"$f":"Equity_Debt!G14","v":0},{"$f":"Equity_Debt!H14","v":0}]
["H","PBT",null,null,{"$f":"E52-E53","v":6182761.7406200022},57777909.96451515,199453455.91344416,414960415.60328102,796991401.91449785]
[null,"Tax","Tax Rate",0.26,{"$f":"E54*26%","v":1607518.0525612007},15022256.59077394,51857898.537495486,107889708.05685307,207217764.49776945]
["I","PAT",null,null,{"$f":"E54-E55","v":4575243.688058801},42755653.37374121,147595557.37594867,307070707.54642797,589773637.41672838]

{"sheet":"Cash Flow","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Particulars","Year 1 ","Year 2 ","Year 3","Year 4","Year 5 "]
[null,"EBITA",{"$f":"'Income Statement '!E52","v":6182761.7406200022},{"$f":"'Income Statement '!F52","v":57777909.96451515},{"$f":"'Income Statement '!G52","v":199453455.91344416},{"$f":"'Income Statement '!H52","v":414960415.60328102},{"$f":"'Income Statement '!I52","v":796991401.91449785}]
["For CY","Debtors (Outstanding Receivables)",{"$f":"'Debtors and Creditors'!C7","v":3514607.9953150689},{"$f":"'Debtors and Creditors'!D7","v":15539798.407245288},{"$f":"'Debtors and Creditors'!E7","v":37828749.2490867},{"$f":"'Debtors and Creditors'!F7","v":79734747.095361233},{"$f":"'Debtors and Creditors'!G7","v":149937913.17813241}]
["For CY","Creditors (Payables)",{"$f":"'Debtors and Creditors'!C8","v":7497830.3900054805},{"$f":"'Debtors and Creditors'!D8","v":32737175.311263405},{"$f":"'Debtors and Creditors'!E8","v":75657498.498173401},{"$f":"'Debtors and Creditors'!F8","v":159469494.1907225},{"$f":"'Debtors and Creditors'!G8","v":299875826.35626489}]
["For PY","Debtors (Outstanding Receivables)",null,{"$f":"C5","v":3514607.9953150689},15539798.407245288,37828749.2490867,79734747.095361233]
["For PY","Creditors (Payables)",null,{"$f":"C6","v":7497830.3900054805},32737175.311263405,75657498.498173401,159469494.1907225]
[null,"A. Cash Flow from Operations",{"$f":"C4-C5+C6+C7-C8","v":10165984.135310413},70992064.473842859,220084828.25851271,456866413.44955552,867194567.99726915]
[null,"Cash Flow from Investing Activities"]
[null,"Product Developement Cost",0,0,0,0,0]
[null,"Tangible Assets",0,0,0,0,0]
[null,"Intangible Assets",0,0,0,0,0]
[null,"B.Net Cash Flow from  Investing Activities ",{"$f":"SUM(C11:C13)","v":0},0,0,0,0]
[null,"Cash Flow from Financing Activities"]
[null,"Equity Shares",{"$f":"Equity_Debt!D6+Equity_Debt!D7-Equity_Debt!D8","v":0},null,null,null,{"$f":"Equity_Debt!H6+Equity_Debt!H7-Equity_Debt!H8","v":0}]
[null,"Long term Borrowings",{"$f":"Equity_Debt!D13","v":0},{"$f":"Equity_Debt!E13","v":0},{"$f":"Equity_Debt!F13","v":0},{"$f":"Equity_Debt!G13","v":0},{"$f":"Equity_Debt!H13","v":0}]
[null,"Loan Repaid",{"$f":"Equity_Debt!D15","v":0},{"$f":"Equity_Debt!E15","v":0},{"$f":"Equity_Debt!F15","v":0},{"$f":"Equity_Debt!G15","v":0},{"$f":"Equity_Debt!H15","v":0}]
[null,"Interest Paid",{"$f":"Equity_Debt!D16","v":0},{"$f":"Equity_Debt!E16","v":0},{"$f":"Equity_Debt!F16","v":0},{"$f":"Equity_Debt!G16","v":0},{"$f":"Equity_Debt!H16","v":0}]
[null,"C. Cash Flow from Financing Activities",{"$f":"SUM(C16:C19)","v":0},0,0,0,0]
[null,"Cash Generated During the Year",{"$f":"C9+C14+C20","v":10165984.135310413},70992064.473842859,220084828.25851271,456866413.44955552,867194567.99726915]
[null,"Opening Balance Of Cash",0,{"$f":"C23","v":10165984.135310413},81158048.609153271,301242876.86766601,758109290.31722152]
[null,"Closing Balance",{"$f":"C21+C22","v":10165984.135310413},81158048.609153271,301242876.86766601,758109290.31722152,1625303858.3144908]

{"sheet":"Debtors and Creditors","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Inventory Days",0]
[null,"Receivable Days",15]
[null,"Payable Days",40]
[]
[null,"Particulars","Year 1 ","Year 2 ","Year 3","Year 4","Year 5 "]
[null,"Receivalble amount",{"$f":"$C$3*'Income Statement '!E35/365","v":3514607.9953150689},{"$f":"$C$3*'Income Statement '!F35/365","v":15539798.407245288},{"$f":"$C$3*'Income Statement '!G35/365","v":37828749.2490867},{"$f":"$C$3*'Income Statement '!H35/365","v":79734747.095361233},{"$f":"$C$3*'Income Statement '!I35/365","v":149937913.17813241}]
[null,"Payables Amount",{"$f":"'Income Statement '!E42*'Debtors and Creditors'!$C$4/365","v":7497830.3900054805},{"$f":"'Income Statement '!F42*'Debtors and Creditors'!$C$4/365","v":32737175.311263405},{"$f":"'Income Statement '!G42*'Debtors and Creditors'!$C$4/365","v":75657498.498173401},{"$f":"'Income Statement '!H42*'Debtors and Creditors'!$C$4/365","v":159469494.1907225},{"$f":"'Income Statement '!I42*'Debtors and Creditors'!$C$4/365","v":299875826.35626489}]

{"sheet":"Balance Sheet","index":4,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[17,1,17,6],[21,1,21,6],[3,1,3,6],[4,1,4,6],[8,1,8,6],[10,1,10,6],[16,1,16,6]]}
[]
[null,"Balance Sheet"]
[null,"Equity & Liabilities","Year 1 ","Year 2 ","Year 3","Year 4","Year 5 "]
[null,"Sources of Funds"]
[null,"Shareholder's Equity"]
[null,"Share Capital",{"$f":"Equity_Debt!D9","v":0},{"$f":"Equity_Debt!E9","v":0},{"$f":"Equity_Debt!F9","v":0},{"$f":"Equity_Debt!G9","v":0},{"$f":"Equity_Debt!H9","v":0}]
[null,"Reserves & Surplus",{"$f":"'Income Statement '!E56","v":4575243.688058801},{"$f":"'Income Statement '!F56","v":42755653.37374121},{"$f":"'Income Statement '!G56","v":147595557.37594867},{"$f":"'Income Statement '!H56","v":307070707.54642797},{"$f":"'Income Statement '!I56","v":589773637.41672838}]
["A","Total Shareholder's Equity",{"$f":"C6+C7","v":4575243.688058801},42755653.37374121,147595557.37594867,307070707.54642797,589773637.41672838]
[null,"Liabilities"]
["B","Long Term Borrowing",{"$f":"Equity_Debt!D17","v":0},{"$f":"Equity_Debt!E17","v":0},{"$f":"Equity_Debt!F17","v":0},{"$f":"Equity_Debt!G17","v":0},{"$f":"Equity_Debt!H17","v":0}]
[null,"Current liabilities:"]
[null,"Trade Paybles",{"$f":"'Debtors and Creditors'!C8","v":7497830.3900054805},{"$f":"'Debtors and Creditors'!D8","v":32737175.311263405},{"$f":"'Debtors and Creditors'!E8","v":75657498.498173401},{"$f":"'Debtors and Creditors'!F8","v":159469494.1907225},{"$f":"'Debtors and Creditors'!G8","v":299875826.35626489}]
[null,"Other Payables",0,0,0,0,0]
[null,"Short Term Provision",0,0,0,0,0]
["C","Total Current Liabilities",{"$f":"SUM(C12:C14)","v":7497830.3900054805},32737175.311263405,75657498.498173401,159469494.1907225,299875826.35626489]
[null,"Total Liabilities",{"$f":"C8+C10+C15","v":12073074.078064281},75492828.685004622,223253055.87412208,466540201.73715043,889649463.77299333]
[null,"Assets"]
[null,"Non-Current Assets"]
[null,"Tangible Assets",0,0,0,0,0]
[null,"Intangible Assets",{"$f":"'Intangible Asset'!C7","v":15000000},{"$f":"'Intangible Asset'!D7","v":15000000},{"$f":"'Intangible Asset'!E7","v":15000000},{"$f":"'Intangible Asset'!F7","v":15000000},{"$f":"'Intangible Asset'!G7","v":15000000}]
["D","Total Non-current assets",{"$f":"SUM(C19:C20)","v":15000000},15000000,15000000,15000000,15000000]
[null,"Current Assets"]
[null,"Inventory",0,0,0,0,0]
[null,"Receivables",{"$f":"'Debtors and Creditors'!C7","v":3514607.9953150689},{"$f":"'Debtors and Creditors'!D7","v":15539798.407245288},{"$f":"'Debtors and Creditors'!E7","v":37828749.2490867},{"$f":"'Debtors and Creditors'!F7","v":79734747.095361233},{"$f":"'Debtors and Creditors'!G7","v":149937913.17813241}]
[null,"Cash & Bank Balance",{"$f":"'Cash Flow'!C23","v":10165984.135310413},{"$f":"'Cash Flow'!D23","v":81158048.609153271},{"$f":"'Cash Flow'!E23","v":301242876.86766601},{"$f":"'Cash Flow'!F23","v":758109290.31722152},{"$f":"'Cash Flow'!G23","v":1625303858.3144908}]
[null,"Other Current Assets",0,0,0,0,0]
[null,"Total Current  Assets",{"$f":"SUM(C23:C26)","v":13680592.130625483},96697847.016398564,339071626.11675268,837844037.41258276,1775241771.4926233]
[null,"Total Assets",{"$f":"C21+C27","v":28680592.130625483},111697847.01639856,354071626.11675268,852844037.41258276,1790241771.4926233]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"C27+C21","v":28680592.130625483},111697847.01639856,354071626.11675268,852844037.41258276,1790241771.4926233]
[null,null,{"$f":"C16-C28","v":-16607518.052561201},-36205018.331393942,-130818570.2426306,-386303835.67543232,-900592307.71963]
[null,"End of Sheet"]
[]
[null,"Working Capital",{"$f":"C27-C15","v":6182761.7406200022},63960671.705135159,263414127.61857927,678374543.22186029,1475365945.1363585]

{"sheet":"Intangible Asset","index":5,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Software Application",null,"Year 1 ","Year 2 ","Year 3","Year 4","Year 5 "]
["Cost ",15000000]
["Rate of Depreciation",0]
["Opening Balance ",null,0,15000000,15000000,15000000,15000000]
["Addition",null,15000000,0,0,0,0]
["Depreciation",null,0,0,0,0,0]
["Closing Balance",null,15000000,15000000,15000000,15000000,15000000]

{"sheet":"Equity_Debt","index":6,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"2025-2026","2026-2027","2027-2028","2028-29","2029-30"]
[null,null,"Equity"]
[null,null,"Opening Equity"]
[null,null,"Owner's Equity Infusion"]
[null,null,"Equity Raise"]
[null,null,"Re-payment "]
[null,null,"Closing Equity"]
[]
[null,null,"Debt "]
[null,null,"Opening Debt"]
[null,null,"Debt Raised"]
[null,null,"Interest Due"]
[null,null,"Principle Repayment"]
[null,null,"Interest repaid"]
[null,null,"Closing Debt "]

{"sheet":"Total Addressable Market","index":7,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,2,0],[1,1,2,1],[1,3,1,7]]}
["Total Addressable and Target Market"]
["Revenue Streams","Industry Growth Rate",null,"Projected TAM"]
[null,null,"Existing facilities 2023","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Co-operative Housing Societies ",0.05,92000,{"$f":"C4*(1+$C4)","v":8464092000},778704928092000,7.1641632089392095E+19,6.5911017938561623E+24,6.0638795613656081E+29]
["Facility Management",0.02,347,{"$f":"C5*(1+$C5)","v":120756},42023088,14624034624,5089164049152,1771029089104896]
["Hotels",0.01,1547,{"$f":"C6*(1+$C6)","v":2394756},3707082288,5738563381824,8883296115063552,1.3751342386118377E+19]
["Private Hospitals ",3.6799999999999999E-2,43486,{"$f":"C7*(1+$C7)","v":1891075682},82237208183134,3.576249472259948E+18,1.5552036080016836E+23,6.7631139301169213E+27]
["Private Schools ",0.04,34753,{"$f":"C8*(1+$C8)","v":1207805762},41976081452548,1.4588367348018532E+18,5.0700411881303602E+22,1.7620421145228255E+27]
["Industrial Establishments ",0.05,246504,{"$f":"C9*(1+$C9)","v":60764468520},1.49787453125226E+16,3.6923356132633834E+21,9.1017919034749033E+26,2.2436372131660811E+32]
["Total Addressable Market",null,{"$f":"SUM(C4:C9)","v":418637},72329957476,1.5881667279355658E+16,3.7690123373130248E+21,9.1697651292291637E+26,2.2497863442880307E+32]
["Target Market - 5% of TAM",null,null,{"$f":"D10*5%","v":3616497873.8000002},794083363967783,1.8845061686565126E+20,4.5848825646145818E+25,1.1248931721440155E+31]

{"sheet":"Customer Conversion Rate","index":8,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,0,0,3]]}
["Conversion Rates"]
["Conversion Rates","Ratio","Growth Rate","2025-26"]
["Digital Media Marketing:",2,0.1,0.01]
["Word of Mouth Marketing:",3,0.3,0.02]
["Offline Marketing:",3,0.3,7.4999999999999997E-3]
[null,null,{"$f":"((C3*$B3)+(C4*$B4)+($B5*C5))/8","v":0.24999999999999997},1.2812500000000001E-2]

{"sheet":"Budgeted Sales per Customer","index":9,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Particulars","Budgeted Sales for 2025-26 per customer","TAM","Adjusting Sales to TAM"]
["Co-operative Housing Societies ",{"$f":"100000*12","v":1200000},{"$f":"'Income Statement '!E8","v":96600},{"$f":"B4/$C$10*C4","v":264310.54229767766}]
["Facility Management",{"$f":"(25000000*12)","v":300000000},{"$f":"'Income Statement '!E9","v":353.94},242106.81506428577]
["Hotels",{"$f":"1000000*12","v":12000000},{"$f":"'Income Statement '!E10","v":1562.47},42751.272569756977]
["Private Hospitals ",{"$f":"70000*12","v":840000},{"$f":"'Income Statement '!E11","v":45086.284799999994},86353.48105561985]
["Private Schools ",{"$f":"30000*12","v":360000},{"$f":"'Income Statement '!E12","v":36143.120000000003},29667.725613447325]
["Industrial Establishments ",{"$f":"100000*12","v":1200000},{"$f":"'Income Statement '!E13","v":258829.2},708191.36867985583]
[null,null,{"$f":"SUM(C4:C9)","v":438575.0148},1373381.2052806434]

{"sheet":"Manpower Expense","index":10,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,5,2,7],[2,8,2,10],[2,11,2,13],[2,14,2,16]]}
[]
[null,"Manpower Cost"]
[null,null,"2025-26",null,null,"2026-27",null,null,"2027-28",null,null,"2028-29",null,null,"2029-30"]
[null,"Designation","No. of Employees","Salary per employee","Total","No. of Employees","Salary per employee","Total","No. of Employees","Salary per employee","Total","No. of Employees","Salary per employee","Total","No. of Employees","Salary per employee","Total"]
[null,"Directors",2,70000,{"$f":"D5*C5","v":140000},{"$f":"C5*1","v":2},{"$f":"D5*1.1","v":77000},{"$f":"G5*F5","v":154000},{"$f":"F5*1","v":2},{"$f":"G5*1.1","v":84700},{"$f":"J5*I5","v":169400},{"$f":"I5*1","v":2},{"$f":"J5*1.1","v":93170.000000000015},{"$f":"M5*L5","v":186340.00000000003},{"$f":"L5*1","v":2},{"$f":"M5*1.1","v":102487.00000000003},{"$f":"P5*O5","v":204974.00000000006}]
[null,"Catalogue & Category Manager",1,40000,40000,5,{"$f":"E6*1.1","v":44000},{"$f":"E6*1.5","v":60000},7.5,{"$f":"H6*1.1","v":66000},{"$f":"H6*1.5","v":90000},11.25,{"$f":"K6*1.1","v":99000.000000000015},{"$f":"K6*1.5","v":135000},16.875,{"$f":"N6*1.1","v":148500},{"$f":"N6*1.5","v":202500}]
[null,"Technical Team",2,70000,140000,5,154000,{"$f":"E7*1.5","v":210000},5,231000.00000000003,{"$f":"H7*1.5","v":315000},5,346500,{"$f":"K7*1.5","v":472500},5,519750.00000000006,708750]
[null,"Sales and Operations ",2,40000,80000,4,88000,{"$f":"E8*1.5","v":120000},8,132000,{"$f":"H8*1.5","v":180000},12,198000.00000000003,{"$f":"K8*1.5","v":270000},18,297000,405000]
[null,"Delivery & Operations Staff",2,20000,40000,{"$f":"C9*2","v":4},44000,{"$f":"E9*2","v":80000},8,88000,{"$f":"H9*2","v":160000},16,176000,{"$f":"K9*2","v":320000},16,352000,{"$f":"N9*2","v":640000}]
[{"$nulls":4},{"$f":"SUM(E5:E9)","v":440000},null,null,{"$f":"SUM(H5:H9)","v":624000},null,null,{"$f":"SUM(K5:K9)","v":914400},null,null,{"$f":"SUM(N5:N9)","v":1383840},null,null,{"$f":"SUM(Q5:Q9)","v":2161224}]
[{"$nulls":4},{"$f":"(E10*12)","v":5280000},null,null,{"$f":"(H10*12)","v":7488000},null,null,{"$f":"(K10*12)","v":10972800},null,null,{"$f":"(N10*12)","v":16606080},null,null,{"$f":"(Q10*12)","v":25934688}]

{"sheet":"Marketing Expense","index":11,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Digital Media Marketing Expense",{"$nulls":5},0.15,0.3]
["Particulars","2025-26","2026-27","2027-28","2028-29","2029-30"]
["Customers Onboarded",280.68800947200003,352.87609219633157,443.64063691156161,557.76463743810882,701.26323030078674]
["Conversion Rate",1.2800000000000001E-2,1.536E-2,1.8432E-2,2.21184E-2,2.6542079999999999E-2]
[null,{"$f":"B3/B4","v":21928.750740000003},22973.703919032003,24069.044971330382,25217.22355315524,26420.809156659416]
["CTR (Click Through Rate)",0.06,0.06,0.06,0.06,0.06]
["TOTAL",{"$f":"B5/B6","v":365479.17900000006},382895.06531720009,401150.74952217308,420287.05921925401,440346.81927765696]
[]
["Online marketing (Digital Marketing)",900000,{"$f":"(B9+(B9*G1))","v":1035000},1345500]
["Offline marketing (Offline deals with FM companies)",600000,{"$f":"(B10+(B10*0.2))","v":720000},{"$f":"(C10+(C10*0.3))","v":936000},{"$f":"(D10+(D10*0.5))","v":1404000}]
["Referral marketing ",{"$f":"(150582670.608*0.008)","v":1204661.3648640001},{"$f":"(150582670.608*0.1)","v":15058267.060800001},{"$f":"(150582670.608*0.008)","v":1204661.3648640001},1204661.3648640001,1204661.3648640001]
["Commision ",{"$f":"(100*32000*4)*0.05","v":640000}]
["Total marketing Spend",{"$f":"SUM(B9:B12)","v":3344661.3648640001}]