{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover Page","Source Data","Financial Modelling"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":140,"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":"Cover Page","index":0,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,1,7,14],[31,2,31,13],[12,2,12,13],[13,2,13,13],[14,2,14,13],[24,2,24,13],[25,2,25,13],[27,2,27,13],[28,2,28,13],[30,2,30,13],[8,2,8,14]]}
[]
[]
[null,"©Financial Model With DCF Model & IRR"]
[]
[]
[]
[]
[]
[null,null,"This is a discounted financial model which includes 3 Finanacial Statement Forecasting ,Sensitivity,Scenario Analysis,DCF Model &  Internal Rate of Return(IRR)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Strictly Confidential"]
[null,null,"Model Prepared and Compiled By:"]
[]
[null,null,"© CPA Abdulrahman Juma Bakari:(Founder of Brave Lions Brain Consultancy)"]
[]
[]
[]
[null,null,"Notes"]
[null,null,"This Model is prepared for Planing Purpose of the said Company…................................................................................. and focused on the company dynamics thus cannot "]
[null,null,"be used for other reasons !!!."]
[]
[null,null,"All contents is a Copyright matiral of :"]
[null,null,"CPA JUMA ABDULRAHMAN BAKARI  (Founder of Brave Lions Brain Consultancy)"]
[null,null,"Emaill :bravelionsbrainconsultancy@gmail.com / jumabakari753@gmail.com",null,null,null,null,null,"Phone:",{"$f":"\"+ 254 713883912\"","v":"+ 254 713883912"}]

{"sheet":"Source Data","index":1,"n_rows":300,"n_cols":40,"rows_kept":300,"cut":false,"hidden":true,"merged":[[1,1,1,4],[58,1,58,4],[114,1,114,4],[169,1,169,4],[225,1,225,4],[5,17,5,20],[5,22,5,25],[5,27,5,30],[5,32,5,35],[5,37,5,39]]}
[]
[null,"Year 1"]
[null,null,null,null,null,null,"Annual"]
["NURSERY",null,"Play Group","Nursery 1","Nursery 2","Nursery 3","Totals"]
["Number Of Students",null,5,5,5,5,{"$f":"SUM(C5:F5)","v":20}]
["Tution Fee","Per Term",76200,98200,99100,115250,null,null,null,null,null,null,null,null,null,null,null,"Year 1F",null,null,null,null,"Year 2F",null,null,null,null,"Year 3F",null,null,null,null,"Year 4F",null,null,null,null,"Year 5F"]
[null,"Annually",{"$f":"C5*C6*3","v":1143000},{"$f":"D5*D6*3","v":1473000},1486500,1728750,{"$f":"SUM(C7:F7)","v":5831250},null,null,null,null,null,null,null,null,null,"Nursery","Junior","Senior","Consolidated",null,"Nursery","Junior","Senior","Consolidated",null,"Nursery","Junior","Senior","Consolidated",null,"Nursery","Junior","Senior","Consolidated",null,"Nursery","Junior","Senior","Consolidated"]
["Registration Fee",null,50000,50000,50000,50000,null,null,null,null,null,null,null,null,null,null,{"$f":"G7","v":5831250},{"$f":"I25","v":17746500},{"$f":"J43","v":40254000},{"$f":"SUM(Q8:S8)","v":63831750},null,{"$f":"G64","v":12245640},{"$f":"I82","v":37267650},{"$f":"J100","v":84533400},{"$f":"SUM(V8:X8)","v":134046690},null,{"$f":"G120","v":19286910},{"$f":"I138","v":58696560},{"$f":"J156","v":133140105},{"$f":"SUM(AA8:AC8)","v":211123575},null,{"$f":"G175","v":27001620},{"$f":"I193","v":82175220},{"$f":"J211","v":186396180},{"$f":"SUM(AF8:AH8)","v":295573020},null,{"$f":"G231","v":35439603.999749996},{"$f":"I249","v":107854907.7525},{"$f":"J267","v":244644941.25},{"$f":"SUM(AK8:AM8)","v":387939453.00224996}]
[null,"All Students",{"$f":"C8*C5","v":250000},{"$f":"D8*D5","v":250000},250000,250000,{"$f":"SUM(C9:F9)","v":1000000},null,null,null,null,null,null,null,null,null,{"$f":"G9","v":1000000},{"$f":"I27","v":1500000},{"$f":"J45","v":1750000},{"$f":"SUM(Q9:S9)","v":4250000},null,{"$f":"G66","v":2000000},{"$f":"I84","v":3000000},{"$f":"J102","v":3500000},{"$f":"SUM(V9:X9)","v":8500000},null,{"$f":"G122","v":3000000},{"$f":"I140","v":4500000},{"$f":"J158","v":5250000},{"$f":"SUM(AA9:AC9)","v":12750000},null,{"$f":"G177","v":4000000},{"$f":"I195","v":6000000},{"$f":"J213","v":7000000},{"$f":"SUM(AF9:AH9)","v":17000000},null,{"$f":"G233","v":5000000},{"$f":"I251","v":7500000},{"$f":"J269","v":8750000},{"$f":"SUM(AK9:AM9)","v":21250000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,null,null,null,null,null,null,null,null,null,null,{"$f":"G11","v":1400000},{"$f":"I29","v":2100000},{"$f":"J47","v":2450000},5950000,null,{"$f":"G68","v":2800000},{"$f":"I86","v":4200000},{"$f":"J104","v":4900000},11900000,null,{"$f":"G124","v":4200000},{"$f":"I142","v":6300000},{"$f":"J160","v":7350000},17850000,null,{"$f":"G179","v":5600000},{"$f":"I197","v":8400000},{"$f":"J215","v":9800000},{"$f":"SUM(AF10:AH10)","v":23800000},null,{"$f":"G235","v":7000000},{"$f":"I253","v":10500000},{"$f":"J271","v":12250000},29750000]
[null,"All Students",{"$f":"C10*C5","v":350000},{"$f":"D10*D5","v":350000},350000,350000,{"$f":"SUM(C11:F11)","v":1400000},null,null,null,null,null,null,null,null,null,{"$f":"G13","v":3000000},{"$f":"I31","v":4500000},{"$f":"J49","v":5250000},12750000,null,{"$f":"G70","v":6000000},{"$f":"I88","v":9000000},{"$f":"J106","v":10500000},25500000,null,{"$f":"G126","v":9000000},{"$f":"I144","v":13500000},{"$f":"J162","v":15750000},38250000,null,{"$f":"G181","v":12000000},{"$f":"I199","v":18000000},{"$f":"J217","v":21000000},51000000,null,{"$f":"G237","v":15000000},{"$f":"I255","v":22500000},{"$f":"J273","v":26250000},63750000]
["Capital Levy",null,150000,150000,150000,150000,null,null,null,null,null,null,null,null,null,null,{"$f":"G15","v":2520000},{"$f":"I33","v":4185000},{"$f":"J51","v":5355000},12060000,null,{"$f":"G72","v":6525000},{"$f":"I90","v":8370000},{"$f":"J108","v":10710000},25605000,null,{"$f":"G128","v":7560000},{"$f":"I146","v":12555000},{"$f":"J164","v":16065000},36180000,null,{"$f":"G183","v":10080000},{"$f":"I201","v":16740000},{"$f":"J219","v":21420000},48240000,null,{"$f":"G239","v":12600000},{"$f":"I257","v":20925000},{"$f":"J275","v":26775000},60300000]
[null,null,{"$f":"C12*C5","v":750000},{"$f":"D12*D5","v":750000},750000,750000,{"$f":"SUM(C13:F13)","v":3000000},null,null,null,null,null,null,null,null,null,{"$f":"G17","v":1938000},{"$f":"I35","v":3343500},{"$f":"J53","v":4226250},9507750,null,{"$f":"G74","v":3876000},{"$f":"I92","v":6687000},{"$f":"J110","v":8452500},19015500,null,{"$f":"G130","v":5814000},{"$f":"I148","v":10030500},{"$f":"J166","v":12678750},28523250,null,{"$f":"G185","v":7752000},{"$f":"I203","v":13374000},{"$f":"J221","v":16905000},38031000,null,{"$f":"G241","v":9690000},{"$f":"I259","v":16717500},{"$f":"J277","v":21131250},47538750]
["Transport Fee","Per Term",42000,42000,42000,42000,null,null,null,null,null,null,null,null,null,null,{"$f":"G19","v":810000},{"$f":"I37","v":2052000},{"$f":"J55","v":3053250},5915250,null,{"$f":"G76","v":1620000},{"$f":"I94","v":4104000},{"$f":"J112","v":6106500},11830500,null,{"$f":"G132","v":2430000},{"$f":"I150","v":6156000},{"$f":"J168","v":9159750},17745750,null,{"$f":"G187","v":3240000},{"$f":"I205","v":8208000},{"$f":"J223","v":12213000},23661000,null,{"$f":"G243","v":4050000},{"$f":"I261","v":10260000},{"$f":"J279","v":15266250},29576250]
[null,"Annually",{"$f":"C14*C5*3","v":630000},{"$f":"D14*D5*3","v":630000},630000,630000,{"$f":"SUM(C15:F15)","v":2520000}]
["Lunch & Snacks Fee","Per Term",32300,32300,32300,32300]
[null,"Annually",{"$f":"C16*C5*3","v":484500},{"$f":"D16*D5*3","v":484500},484500,484500,{"$f":"SUM(C17:F17)","v":1938000}]
["Activity Fee","Per Term",13500,13500,13500,13500]
[null,"Annually",{"$f":"C18*C5*3","v":202500},{"$f":"D18*D5*3","v":202500},202500,202500,{"$f":"SUM(C19:F19)","v":810000}]
[]
[null,null,null,null,null,null,null,null,"Annual"]
["JUNIOR SCHOOL",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Totals"]
["Number Of Students",null,5,5,5,5,5,5,{"$f":"SUM(C23:H23)","v":30}]
["Tution Fee","Per Term",135000,168200,215300,215300,215300,234000]
[null,"Annually",{"$f":"C23*C24*3","v":2025000},{"$f":"D23*D24*3","v":2523000},3229500,3229500,3229500,3510000,{"$f":"SUM(C25:H25)","v":17746500}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C26*C23","v":250000},{"$f":"D26*D23","v":250000},250000,250000,250000,{"$f":"H26*H23","v":250000},{"$f":"SUM(C27:H27)","v":1500000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C28*C23","v":350000},{"$f":"D28*D23","v":350000},350000,350000,350000,350000,{"$f":"SUM(C29:H29)","v":2100000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C30*C23","v":750000},{"$f":"D30*D23","v":750000},750000,750000,750000,750000,{"$f":"SUM(C31:H31)","v":4500000}]
["Transport Fee","Per Term",46500,46500,46500,46500,46500,46500]
[null,"Annually",{"$f":"C32*C23*3","v":697500},{"$f":"D32*D23*3","v":697500},697500,697500,697500,697500,{"$f":"SUM(C33:H33)","v":4185000}]
["Lunch & Snacks Fee","Per Term",37150,37150,37150,37150,37150,37150]
[null,"Annually",{"$f":"C34*C23*3","v":557250},{"$f":"D34*D23*3","v":557250},557250,557250,557250,557250,{"$f":"SUM(C35:H35)","v":3343500}]
["Activity Fee","Per Term",21450,21450,21450,24150,24150,24150]
[null,"Annually",{"$f":"C36*C23*3","v":321750},{"$f":"D36*D23*3","v":321750},321750,362250,362250,362250,{"$f":"SUM(C37:H37)","v":2052000}]
[]
[null,null,null,null,null,null,null,null,null,"Annual"]
["SENIOR SCHOOL",null,"Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Totals"]
["Number Of Students",null,5,5,5,5,5,5,5,{"$f":"SUM(C41:I41)","v":35}]
["Tution Fee","Per Term",268100,318100,318100,318100,436600,512300,512300]
[null,"Annually",{"$f":"C41*C42*3","v":4021500},{"$f":"D41*D42*3","v":4771500},4771500,4771500,6549000,7684500,7684500,{"$f":"SUM(C43:I43)","v":40254000}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C44*C41","v":250000},{"$f":"D44*D41","v":250000},250000,250000,250000,250000,250000,{"$f":"SUM(C45:I45)","v":1750000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C46*C41","v":350000},{"$f":"D46*D41","v":350000},350000,350000,350000,350000,350000,{"$f":"SUM(C47:I47)","v":2450000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C48*C41","v":750000},{"$f":"D48*D41","v":750000},750000,750000,750000,750000,750000,{"$f":"SUM(C49:I49)","v":5250000}]
["Transport Fee","Per Term",51000,51000,51000,51000,51000,51000,51000]
[null,"Annually",{"$f":"C50*C41*3","v":765000},{"$f":"D50*D41*3","v":765000},765000,765000,765000,765000,765000,{"$f":"SUM(C51:I51)","v":5355000}]
["Lunch & Snacks Fee","Per Term",40250,40250,40250,40250,40250,40250,40250]
[null,"Annually",{"$f":"C52*C41*3","v":603750},{"$f":"D52*D41*3","v":603750},603750,603750,603750,603750,603750,{"$f":"SUM(C53:I53)","v":4226250}]
["Activity Fee","Per Term",27600,27600,27600,27600,31050,31050,31050]
[null,"Annually",{"$f":"C54*C41*3","v":414000},{"$f":"D54*D41*3","v":414000},414000,414000,465750,465750,465750,{"$f":"SUM(C55:I55)","v":3053250}]
[]
[]
[]
[null,"Year 2"]
[null,null,null,null,null,null,"Annual"]
["NURSERY",null,"Play Group","Nursery 1","Nursery 2","Nursery 3","Totals"]
["Number Of Students",null,10,10,10,10,{"$f":"SUM(C62:F62)","v":40}]
["Tution Fee","Per Term",80010,103110,104055,121013]
[null,"Annually",{"$f":"C62*C63*3","v":2400300},{"$f":"D62*D63*3","v":3093300},{"$f":"E62*E63*3","v":3121650},{"$f":"F62*F63*3","v":3630390},{"$f":"SUM(C64:F64)","v":12245640}]
["Registration Fee",null,50000,50000,50000,50000]
[null,"All Students",{"$f":"C65*C62","v":500000},{"$f":"D65*D62","v":500000},{"$f":"E65*E62","v":500000},{"$f":"F65*F62","v":500000},{"$f":"SUM(C66:F66)","v":2000000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000]
[null,"All Students",{"$f":"C67*C62","v":700000},{"$f":"D67*D62","v":700000},{"$f":"E67*E62","v":700000},{"$f":"F67*F62","v":700000},{"$f":"SUM(C68:F68)","v":2800000}]
["Capital Levy",null,150000,150000,150000,150000]
[null,null,{"$f":"C69*C62","v":1500000},{"$f":"D69*D62","v":1500000},{"$f":"E69*E62","v":1500000},{"$f":"F69*F62","v":1500000},{"$f":"SUM(C70:F70)","v":6000000}]
["Transport Fee","Per Term",54375,54375,54375,54375]
[null,"Annually",{"$f":"C71*C62*3","v":1631250},{"$f":"D71*D62*3","v":1631250},{"$f":"E71*E62*3","v":1631250},{"$f":"F71*F62*3","v":1631250},{"$f":"SUM(C72:F72)","v":6525000}]
["Lunch & Snacks Fee","Per Term",32300,32300,32300,32300]
[null,"Annually",{"$f":"C73*C62*3","v":969000},{"$f":"D73*D62*3","v":969000},{"$f":"E73*E62*3","v":969000},{"$f":"F73*F62*3","v":969000},{"$f":"SUM(C74:F74)","v":3876000}]
["Activity Fee","Per Term",13500,13500,13500,13500]
[null,"Annually",{"$f":"C75*C62*3","v":405000},{"$f":"D75*D62*3","v":405000},{"$f":"E75*E62*3","v":405000},{"$f":"F75*F62*3","v":405000},{"$f":"SUM(C76:F76)","v":1620000}]
[]
[null,null,null,null,null,null,null,null,"Annual"]
["JUNIOR SCHOOL",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Totals"]
["Number Of Students",null,10,10,10,10,10,10,{"$f":"SUM(C80:H80)","v":60}]
["Tution Fee","Per Term",141750,176610,226065,226065,226065,245700]
[null,"Annually",{"$f":"C80*C81*3","v":4252500},{"$f":"D80*D81*3","v":5298300},{"$f":"E80*E81*3","v":6781950},{"$f":"F80*F81*3","v":6781950},{"$f":"G80*G81*3","v":6781950},{"$f":"H80*H81*3","v":7371000},{"$f":"SUM(C82:H82)","v":37267650}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C83*C80","v":500000},{"$f":"D83*D80","v":500000},{"$f":"E83*E80","v":500000},{"$f":"F83*F80","v":500000},{"$f":"G83*G80","v":500000},{"$f":"H83*H80","v":500000},{"$f":"SUM(C84:H84)","v":3000000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C85*C80","v":700000},{"$f":"D85*D80","v":700000},{"$f":"E85*E80","v":700000},{"$f":"F85*F80","v":700000},{"$f":"G85*G80","v":700000},{"$f":"H85*H80","v":700000},{"$f":"SUM(C86:H86)","v":4200000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C87*C80","v":1500000},{"$f":"D87*D80","v":1500000},{"$f":"E87*E80","v":1500000},{"$f":"F87*F80","v":1500000},{"$f":"G87*G80","v":1500000},{"$f":"H87*H80","v":1500000},{"$f":"SUM(C88:H88)","v":9000000}]
["Transport Fee","Per Term",46500,46500,46500,46500,46500,46500]
[null,"Annually",{"$f":"C89*C80*3","v":1395000},{"$f":"D89*D80*3","v":1395000},{"$f":"E89*E80*3","v":1395000},{"$f":"F89*F80*3","v":1395000},{"$f":"G89*G80*3","v":1395000},{"$f":"H89*H80*3","v":1395000},{"$f":"SUM(C90:H90)","v":8370000}]
["Lunch & Snacks Fee","Per Term",37150,37150,37150,37150,37150,37150]
[null,"Annually",{"$f":"C91*C80*3","v":1114500},{"$f":"D91*D80*3","v":1114500},{"$f":"E91*E80*3","v":1114500},{"$f":"F91*F80*3","v":1114500},{"$f":"G91*G80*3","v":1114500},{"$f":"H91*H80*3","v":1114500},{"$f":"SUM(C92:H92)","v":6687000}]
["Activity Fee","Per Term",21450,21450,21450,24150,24150,24150]
[null,"Annually",{"$f":"C93*C80*3","v":643500},{"$f":"D93*D80*3","v":643500},{"$f":"E93*E80*3","v":643500},{"$f":"F93*F80*3","v":724500},{"$f":"G93*G80*3","v":724500},{"$f":"H93*H80*3","v":724500},{"$f":"SUM(C94:H94)","v":4104000}]
[]
[null,null,null,null,null,null,null,null,null,"Annual"]
["SENIOR SCHOOL",null,"Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Totals"]
["Number Of Students",null,10,10,10,10,10,10,10,{"$f":"SUM(C98:I98)","v":70}]
["Tution Fee","Per Term",281505,334005,334005,334005,458430,537915,537915]
[null,"Annually",{"$f":"C98*C99*3","v":8445150},{"$f":"D98*D99*3","v":10020150},{"$f":"E98*E99*3","v":10020150},{"$f":"F98*F99*3","v":10020150},{"$f":"G98*G99*3","v":13752900},{"$f":"H98*H99*3","v":16137450},{"$f":"I98*I99*3","v":16137450},{"$f":"SUM(C100:I100)","v":84533400}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C101*C98","v":500000},{"$f":"D101*D98","v":500000},{"$f":"E101*E98","v":500000},{"$f":"F101*F98","v":500000},{"$f":"G101*G98","v":500000},{"$f":"H101*H98","v":500000},{"$f":"I101*I98","v":500000},{"$f":"SUM(C102:I102)","v":3500000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C103*C98","v":700000},{"$f":"D103*D98","v":700000},{"$f":"E103*E98","v":700000},{"$f":"F103*F98","v":700000},{"$f":"G103*G98","v":700000},{"$f":"H103*H98","v":700000},{"$f":"I103*I98","v":700000},{"$f":"SUM(C104:I104)","v":4900000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C105*C98","v":1500000},{"$f":"D105*D98","v":1500000},{"$f":"E105*E98","v":1500000},{"$f":"F105*F98","v":1500000},{"$f":"G105*G98","v":1500000},{"$f":"H105*H98","v":1500000},{"$f":"I105*I98","v":1500000},{"$f":"SUM(C106:I106)","v":10500000}]
["Transport Fee","Per Term",51000,51000,51000,51000,51000,51000,51000]
[null,"Annually",{"$f":"C107*C98*3","v":1530000},{"$f":"D107*D98*3","v":1530000},{"$f":"E107*E98*3","v":1530000},{"$f":"F107*F98*3","v":1530000},{"$f":"G107*G98*3","v":1530000},{"$f":"H107*H98*3","v":1530000},{"$f":"I107*I98*3","v":1530000},{"$f":"SUM(C108:I108)","v":10710000}]
["Lunch & Snacks Fee","Per Term",40250,40250,40250,40250,40250,40250,40250]
[null,"Annually",{"$f":"C109*C98*3","v":1207500},{"$f":"D109*D98*3","v":1207500},{"$f":"E109*E98*3","v":1207500},{"$f":"F109*F98*3","v":1207500},{"$f":"G109*G98*3","v":1207500},{"$f":"H109*H98*3","v":1207500},{"$f":"I109*I98*3","v":1207500},{"$f":"SUM(C110:I110)","v":8452500}]
["Activity Fee","Per Term",27600,27600,27600,27600,31050,31050,31050]
[null,"Annually",{"$f":"C111*C98*3","v":828000},{"$f":"D111*D98*3","v":828000},{"$f":"E111*E98*3","v":828000},{"$f":"F111*F98*3","v":828000},{"$f":"G111*G98*3","v":931500},{"$f":"H111*H98*3","v":931500},{"$f":"I111*I98*3","v":931500},{"$f":"SUM(C112:I112)","v":6106500}]
[]
[]
[null,"Year 3"]
[null,null,null,null,null,null,"Annual"]
["NURSERY",null,"Play Group","Nursery 1","Nursery 2","Nursery 3","Totals"]
["Number Of Students",null,15,15,15,15,{"$f":"SUM(C118:F118)","v":60}]
["Tution Fee","Per Term",84011,108266,109258,127063]
[null,"Annually",{"$f":"C118*C119*3","v":3780495},{"$f":"D118*D119*3","v":4871970},{"$f":"E118*E119*3","v":4916610},{"$f":"F118*F119*3","v":5717835},{"$f":"SUM(C120:F120)","v":19286910}]
["Registration Fee",null,50000,50000,50000,50000]
[null,"All Students",{"$f":"C121*C118","v":750000},{"$f":"D121*D118","v":750000},{"$f":"E121*E118","v":750000},{"$f":"F121*F118","v":750000},{"$f":"SUM(C122:F122)","v":3000000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000]
[null,"All Students",{"$f":"C123*C118","v":1050000},{"$f":"D123*D118","v":1050000},{"$f":"E123*E118","v":1050000},{"$f":"F123*F118","v":1050000},{"$f":"SUM(C124:F124)","v":4200000}]
["Capital Levy",null,150000,150000,150000,150000]
[null,null,{"$f":"C125*C118","v":2250000},{"$f":"D125*D118","v":2250000},{"$f":"E125*E118","v":2250000},{"$f":"F125*F118","v":2250000},{"$f":"SUM(C126:F126)","v":9000000}]
["Transport Fee","Per Term",42000,42000,42000,42000]
[null,"Annually",{"$f":"C127*C118*3","v":1890000},{"$f":"D127*D118*3","v":1890000},{"$f":"E127*E118*3","v":1890000},{"$f":"F127*F118*3","v":1890000},{"$f":"SUM(C128:F128)","v":7560000}]
["Lunch & Snacks Fee","Per Term",32300,32300,32300,32300]
[null,"Annually",{"$f":"C129*C118*3","v":1453500},{"$f":"D129*D118*3","v":1453500},{"$f":"E129*E118*3","v":1453500},{"$f":"F129*F118*3","v":1453500},{"$f":"SUM(C130:F130)","v":5814000}]
["Activity Fee","Per Term",13500,13500,13500,13500]
[null,"Annually",{"$f":"C131*C118*3","v":607500},{"$f":"D131*D118*3","v":607500},{"$f":"E131*E118*3","v":607500},{"$f":"F131*F118*3","v":607500},{"$f":"SUM(C132:F132)","v":2430000}]
[]
[null,null,null,null,null,null,null,null,"Annual"]
["JUNIOR SCHOOL",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Totals"]
["Number Of Students",null,15,15,15,15,15,15,{"$f":"SUM(C136:H136)","v":90}]
["Tution Fee","Per Term",148838,185441,237368,237368,237368,257985]
[null,"Annually",{"$f":"C136*C137*3","v":6697710},{"$f":"D136*D137*3","v":8344845},{"$f":"E136*E137*3","v":10681560},{"$f":"F136*F137*3","v":10681560},{"$f":"G136*G137*3","v":10681560},{"$f":"H136*H137*3","v":11609325},{"$f":"SUM(C138:H138)","v":58696560}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C139*C136","v":750000},{"$f":"D139*D136","v":750000},{"$f":"E139*E136","v":750000},{"$f":"F139*F136","v":750000},{"$f":"G139*G136","v":750000},{"$f":"H139*H136","v":750000},{"$f":"SUM(C140:H140)","v":4500000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C141*C136","v":1050000},{"$f":"D141*D136","v":1050000},{"$f":"E141*E136","v":1050000},{"$f":"F141*F136","v":1050000},{"$f":"G141*G136","v":1050000},{"$f":"H141*H136","v":1050000},{"$f":"SUM(C142:H142)","v":6300000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C143*C136","v":2250000},{"$f":"D143*D136","v":2250000},{"$f":"E143*E136","v":2250000},{"$f":"F143*F136","v":2250000},{"$f":"G143*G136","v":2250000},{"$f":"H143*H136","v":2250000},{"$f":"SUM(C144:H144)","v":13500000}]
["Transport Fee","Per Term",46500,46500,46500,46500,46500,46500]
[null,"Annually",{"$f":"C145*C136*3","v":2092500},{"$f":"D145*D136*3","v":2092500},{"$f":"E145*E136*3","v":2092500},{"$f":"F145*F136*3","v":2092500},{"$f":"G145*G136*3","v":2092500},{"$f":"H145*H136*3","v":2092500},{"$f":"SUM(C146:H146)","v":12555000}]
["Lunch & Snacks Fee","Per Term",37150,37150,37150,37150,37150,37150]
[null,"Annually",{"$f":"C147*C136*3","v":1671750},{"$f":"D147*D136*3","v":1671750},{"$f":"E147*E136*3","v":1671750},{"$f":"F147*F136*3","v":1671750},{"$f":"G147*G136*3","v":1671750},{"$f":"H147*H136*3","v":1671750},{"$f":"SUM(C148:H148)","v":10030500}]
["Activity Fee","Per Term",21450,21450,21450,24150,24150,24150]
[null,"Annually",{"$f":"C149*C136*3","v":965250},{"$f":"D149*D136*3","v":965250},{"$f":"E149*E136*3","v":965250},{"$f":"F149*F136*3","v":1086750},{"$f":"G149*G136*3","v":1086750},{"$f":"H149*H136*3","v":1086750},{"$f":"SUM(C150:H150)","v":6156000}]
[]
[null,null,null,null,null,null,null,null,null,"Annual"]
["SENIOR SCHOOL",null,"Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Totals"]
["Number Of Students",null,15,15,15,15,15,15,15,{"$f":"SUM(C154:I154)","v":105}]
["Tution Fee","Per Term",295580,350705,350705,350705,481352,564811,564811]
[null,"Annually",{"$f":"C154*C155*3","v":13301100},{"$f":"D154*D155*3","v":15781725},{"$f":"E154*E155*3","v":15781725},{"$f":"F154*F155*3","v":15781725},{"$f":"G154*G155*3","v":21660840},{"$f":"H154*H155*3","v":25416495},{"$f":"I154*I155*3","v":25416495},{"$f":"SUM(C156:I156)","v":133140105}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C157*C154","v":750000},{"$f":"D157*D154","v":750000},{"$f":"E157*E154","v":750000},{"$f":"F157*F154","v":750000},{"$f":"G157*G154","v":750000},{"$f":"H157*H154","v":750000},{"$f":"I157*I154","v":750000},{"$f":"SUM(C158:I158)","v":5250000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C159*C154","v":1050000},{"$f":"D159*D154","v":1050000},{"$f":"E159*E154","v":1050000},{"$f":"F159*F154","v":1050000},{"$f":"G159*G154","v":1050000},{"$f":"H159*H154","v":1050000},{"$f":"I159*I154","v":1050000},{"$f":"SUM(C160:I160)","v":7350000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C161*C154","v":2250000},{"$f":"D161*D154","v":2250000},{"$f":"E161*E154","v":2250000},{"$f":"F161*F154","v":2250000},{"$f":"G161*G154","v":2250000},{"$f":"H161*H154","v":2250000},{"$f":"I161*I154","v":2250000},{"$f":"SUM(C162:I162)","v":15750000}]
["Transport Fee","Per Term",51000,51000,51000,51000,51000,51000,51000]
[null,"Annually",{"$f":"C163*C154*3","v":2295000},{"$f":"D163*D154*3","v":2295000},{"$f":"E163*E154*3","v":2295000},{"$f":"F163*F154*3","v":2295000},{"$f":"G163*G154*3","v":2295000},{"$f":"H163*H154*3","v":2295000},{"$f":"I163*I154*3","v":2295000},{"$f":"SUM(C164:I164)","v":16065000}]
["Lunch & Snacks Fee","Per Term",40250,40250,40250,40250,40250,40250,40250]
[null,"Annually",{"$f":"C165*C154*3","v":1811250},{"$f":"D165*D154*3","v":1811250},{"$f":"E165*E154*3","v":1811250},{"$f":"F165*F154*3","v":1811250},{"$f":"G165*G154*3","v":1811250},{"$f":"H165*H154*3","v":1811250},{"$f":"I165*I154*3","v":1811250},{"$f":"SUM(C166:I166)","v":12678750}]
["Activity Fee","Per Term",27600,27600,27600,27600,31050,31050,31050]
[null,"Annually",{"$f":"C167*C154*3","v":1242000},{"$f":"D167*D154*3","v":1242000},{"$f":"E167*E154*3","v":1242000},{"$f":"F167*F154*3","v":1242000},{"$f":"G167*G154*3","v":1397250},{"$f":"H167*H154*3","v":1397250},{"$f":"I167*I154*3","v":1397250},{"$f":"SUM(C168:I168)","v":9159750}]
[]
[null,"Year 4"]
[null,null,null,null,null,null,"Annual"]
["NURSERY",null,"Play Group","Nursery 1","Nursery 2","Nursery 3","Totals"]
["Number Of Students",null,20,20,20,20,{"$f":"SUM(C173:F173)","v":80}]
["Tution Fee","Per Term",88211,113679,114721,133416]
[null,"Annually",{"$f":"C173*C174*3","v":5292660},{"$f":"D173*D174*3","v":6820740},{"$f":"E173*E174*3","v":6883260},{"$f":"F173*F174*3","v":8004960},{"$f":"SUM(C175:F175)","v":27001620}]
["Registration Fee",null,50000,50000,50000,50000]
[null,"All Students",{"$f":"C176*C173","v":1000000},{"$f":"D176*D173","v":1000000},{"$f":"E176*E173","v":1000000},{"$f":"F176*F173","v":1000000},{"$f":"SUM(C177:F177)","v":4000000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000]
[null,"All Students",{"$f":"C178*C173","v":1400000},{"$f":"D178*D173","v":1400000},{"$f":"E178*E173","v":1400000},{"$f":"F178*F173","v":1400000},{"$f":"SUM(C179:F179)","v":5600000}]
["Capital Levy",null,150000,150000,150000,150000]
[null,null,{"$f":"C180*C173","v":3000000},{"$f":"D180*D173","v":3000000},{"$f":"E180*E173","v":3000000},{"$f":"F180*F173","v":3000000},{"$f":"SUM(C181:F181)","v":12000000}]
["Transport Fee","Per Term",42000,42000,42000,42000]
[null,"Annually",{"$f":"C182*C173*3","v":2520000},{"$f":"D182*D173*3","v":2520000},{"$f":"E182*E173*3","v":2520000},{"$f":"F182*F173*3","v":2520000},{"$f":"SUM(C183:F183)","v":10080000}]
["Lunch & Snacks Fee","Per Term",32300,32300,32300,32300]
[null,"Annually",{"$f":"C184*C173*3","v":1938000},{"$f":"D184*D173*3","v":1938000},{"$f":"E184*E173*3","v":1938000},{"$f":"F184*F173*3","v":1938000},{"$f":"SUM(C185:F185)","v":7752000}]
["Activity Fee","Per Term",13500,13500,13500,13500]
[null,"Annually",{"$f":"C186*C173*3","v":810000},{"$f":"D186*D173*3","v":810000},{"$f":"E186*E173*3","v":810000},{"$f":"F186*F173*3","v":810000},{"$f":"SUM(C187:F187)","v":3240000}]
[]
[null,null,null,null,null,null,null,null,"Annual"]
["JUNIOR SCHOOL",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Totals"]
["Number Of Students",null,20,20,20,20,20,20,{"$f":"SUM(C191:H191)","v":120}]
["Tution Fee","Per Term",156279,194713,249237,249237,249237,270884]
[null,"Annually",{"$f":"C191*C192*3","v":9376740},{"$f":"D191*D192*3","v":11682780},{"$f":"E191*E192*3","v":14954220},{"$f":"F191*F192*3","v":14954220},{"$f":"G191*G192*3","v":14954220},{"$f":"H191*H192*3","v":16253040},{"$f":"SUM(C193:H193)","v":82175220}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C194*C191","v":1000000},{"$f":"D194*D191","v":1000000},{"$f":"E194*E191","v":1000000},{"$f":"F194*F191","v":1000000},{"$f":"G194*G191","v":1000000},{"$f":"H194*H191","v":1000000},{"$f":"SUM(C195:H195)","v":6000000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C196*C191","v":1400000},{"$f":"D196*D191","v":1400000},{"$f":"E196*E191","v":1400000},{"$f":"F196*F191","v":1400000},{"$f":"G196*G191","v":1400000},{"$f":"H196*H191","v":1400000},{"$f":"SUM(C197:H197)","v":8400000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C198*C191","v":3000000},{"$f":"D198*D191","v":3000000},{"$f":"E198*E191","v":3000000},{"$f":"F198*F191","v":3000000},{"$f":"G198*G191","v":3000000},{"$f":"H198*H191","v":3000000},{"$f":"SUM(C199:H199)","v":18000000}]
["Transport Fee","Per Term",46500,46500,46500,46500,46500,46500]
[null,"Annually",{"$f":"C200*C191*3","v":2790000},{"$f":"D200*D191*3","v":2790000},{"$f":"E200*E191*3","v":2790000},{"$f":"F200*F191*3","v":2790000},{"$f":"G200*G191*3","v":2790000},{"$f":"H200*H191*3","v":2790000},{"$f":"SUM(C201:H201)","v":16740000}]
["Lunch & Snacks Fee","Per Term",37150,37150,37150,37150,37150,37150]
[null,"Annually",{"$f":"C202*C191*3","v":2229000},{"$f":"D202*D191*3","v":2229000},{"$f":"E202*E191*3","v":2229000},{"$f":"F202*F191*3","v":2229000},{"$f":"G202*G191*3","v":2229000},{"$f":"H202*H191*3","v":2229000},{"$f":"SUM(C203:H203)","v":13374000}]
["Activity Fee","Per Term",21450,21450,21450,24150,24150,24150]
[null,"Annually",{"$f":"C204*C191*3","v":1287000},{"$f":"D204*D191*3","v":1287000},{"$f":"E204*E191*3","v":1287000},{"$f":"F204*F191*3","v":1449000},{"$f":"G204*G191*3","v":1449000},{"$f":"H204*H191*3","v":1449000},{"$f":"SUM(C205:H205)","v":8208000}]
[]
[null,null,null,null,null,null,null,null,null,"Annual"]
["SENIOR SCHOOL",null,"Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Totals"]
["Number Of Students",null,20,20,20,20,20,20,20,{"$f":"SUM(C209:I209)","v":140}]
["Tution Fee","Per Term",310359,368241,368241,368241,505419,593051,593051]
[null,"Annually",{"$f":"C209*C210*3","v":18621540},{"$f":"D209*D210*3","v":22094460},{"$f":"E209*E210*3","v":22094460},{"$f":"F209*F210*3","v":22094460},{"$f":"G209*G210*3","v":30325140},{"$f":"H209*H210*3","v":35583060},{"$f":"I209*I210*3","v":35583060},{"$f":"SUM(C211:I211)","v":186396180}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C212*C209","v":1000000},{"$f":"D212*D209","v":1000000},{"$f":"E212*E209","v":1000000},{"$f":"F212*F209","v":1000000},{"$f":"G212*G209","v":1000000},{"$f":"H212*H209","v":1000000},{"$f":"I212*I209","v":1000000},{"$f":"SUM(C213:I213)","v":7000000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C214*C209","v":1400000},{"$f":"D214*D209","v":1400000},{"$f":"E214*E209","v":1400000},{"$f":"F214*F209","v":1400000},{"$f":"G214*G209","v":1400000},{"$f":"H214*H209","v":1400000},{"$f":"I214*I209","v":1400000},{"$f":"SUM(C215:I215)","v":9800000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C216*C209","v":3000000},{"$f":"D216*D209","v":3000000},{"$f":"E216*E209","v":3000000},{"$f":"F216*F209","v":3000000},{"$f":"G216*G209","v":3000000},{"$f":"H216*H209","v":3000000},{"$f":"I216*I209","v":3000000},{"$f":"SUM(C217:I217)","v":21000000}]
["Transport Fee","Per Term",51000,51000,51000,51000,51000,51000,51000]
[null,"Annually",{"$f":"C218*C209*3","v":3060000},{"$f":"D218*D209*3","v":3060000},{"$f":"E218*E209*3","v":3060000},{"$f":"F218*F209*3","v":3060000},{"$f":"G218*G209*3","v":3060000},{"$f":"H218*H209*3","v":3060000},{"$f":"I218*I209*3","v":3060000},{"$f":"SUM(C219:I219)","v":21420000}]
["Lunch & Snacks Fee","Per Term",40250,40250,40250,40250,40250,40250,40250]
[null,"Annually",{"$f":"C220*C209*3","v":2415000},{"$f":"D220*D209*3","v":2415000},{"$f":"E220*E209*3","v":2415000},{"$f":"F220*F209*3","v":2415000},{"$f":"G220*G209*3","v":2415000},{"$f":"H220*H209*3","v":2415000},{"$f":"I220*I209*3","v":2415000},{"$f":"SUM(C221:I221)","v":16905000}]
["Activity Fee","Per Term",27600,27600,27600,27600,31050,31050,31050]
[null,"Annually",{"$f":"C222*C209*3","v":1656000},{"$f":"D222*D209*3","v":1656000},{"$f":"E222*E209*3","v":1656000},{"$f":"F222*F209*3","v":1656000},{"$f":"G222*G209*3","v":1863000},{"$f":"H222*H209*3","v":1863000},{"$f":"I222*I209*3","v":1863000},{"$f":"SUM(C223:I223)","v":12213000}]
[]
[]
[null,"Year 5"]
[null,null,null,null,null,null,"Annual"]
["NURSERY",null,"Play Group","Nursery 1","Nursery 2","Nursery 3","Totals"]
["Number Of Students",null,25,25,25,25,{"$f":"SUM(C229:F229)","v":100}]
["Tution Fee","Per Term",92621.573329999999,119362.72,120456.667,140087.09299999999]
[null,"Annually",{"$f":"C229*C230*3","v":6946617.9997500004},{"$f":"D229*D230*3","v":8952204},{"$f":"E229*E230*3","v":9034250.0249999985},{"$f":"F229*F230*3","v":10506531.975},{"$f":"SUM(C231:F231)","v":35439603.999749996}]
["Registration Fee",null,50000,50000,50000,50000]
[null,"All Students",{"$f":"C232*C229","v":1250000},{"$f":"D232*D229","v":1250000},{"$f":"E232*E229","v":1250000},{"$f":"F232*F229","v":1250000},{"$f":"SUM(C233:F233)","v":5000000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000]
[null,"All Students",{"$f":"C234*C229","v":1750000},{"$f":"D234*D229","v":1750000},{"$f":"E234*E229","v":1750000},{"$f":"F234*F229","v":1750000},{"$f":"SUM(C235:F235)","v":7000000}]
["Capital Levy",null,150000,150000,150000,150000]
[null,null,{"$f":"C236*C229","v":3750000},{"$f":"D236*D229","v":3750000},{"$f":"E236*E229","v":3750000},{"$f":"F236*F229","v":3750000},{"$f":"SUM(C237:F237)","v":15000000}]
["Transport Fee","Per Term",42000,42000,42000,42000]
[null,"Annually",{"$f":"C238*C229*3","v":3150000},{"$f":"D238*D229*3","v":3150000},{"$f":"E238*E229*3","v":3150000},{"$f":"F238*F229*3","v":3150000},{"$f":"SUM(C239:F239)","v":12600000}]
["Lunch & Snacks Fee","Per Term",32300,32300,32300,32300]
[null,"Annually",{"$f":"C240*C229*3","v":2422500},{"$f":"D240*D229*3","v":2422500},{"$f":"E240*E229*3","v":2422500},{"$f":"F240*F229*3","v":2422500},{"$f":"SUM(C241:F241)","v":9690000}]
["Activity Fee","Per Term",13500,13500,13500,13500]
[null,"Annually",{"$f":"C242*C229*3","v":1012500},{"$f":"D242*D229*3","v":1012500},{"$f":"E242*E229*3","v":1012500},{"$f":"F242*F229*3","v":1012500},{"$f":"SUM(C243:F243)","v":4050000}]
[]
[null,null,null,null,null,null,null,null,"Annual"]
["JUNIOR SCHOOL",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Totals"]
["Number Of Students",null,25,25,25,25,25,25,{"$f":"SUM(C247:H247)","v":150}]
["Tution Fee","Per Term",164093.34669999999,204448.15,261698.49,261698.49,261698.49,284428.46999999997]
[null,"Annually",{"$f":"C247*C248*3","v":12307001.002499999},{"$f":"D247*D248*3","v":15333611.25},{"$f":"E247*E248*3","v":19627386.75},{"$f":"F247*F248*3","v":19627386.75},{"$f":"G247*G248*3","v":19627386.75},{"$f":"H247*H248*3","v":21332135.249999996},{"$f":"SUM(C249:H249)","v":107854907.7525}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C250*C247","v":1250000},{"$f":"D250*D247","v":1250000},{"$f":"E250*E247","v":1250000},{"$f":"F250*F247","v":1250000},{"$f":"G250*G247","v":1250000},{"$f":"H250*H247","v":1250000},{"$f":"SUM(C251:H251)","v":7500000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C252*C247","v":1750000},{"$f":"D252*D247","v":1750000},{"$f":"E252*E247","v":1750000},{"$f":"F252*F247","v":1750000},{"$f":"G252*G247","v":1750000},{"$f":"H252*H247","v":1750000},{"$f":"SUM(C253:H253)","v":10500000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C254*C247","v":3750000},{"$f":"D254*D247","v":3750000},{"$f":"E254*E247","v":3750000},{"$f":"F254*F247","v":3750000},{"$f":"G254*G247","v":3750000},{"$f":"H254*H247","v":3750000},{"$f":"SUM(C255:H255)","v":22500000}]
["Transport Fee","Per Term",46500,46500,46500,46500,46500,46500]
[null,"Annually",{"$f":"C256*C247*3","v":3487500},{"$f":"D256*D247*3","v":3487500},{"$f":"E256*E247*3","v":3487500},{"$f":"F256*F247*3","v":3487500},{"$f":"G256*G247*3","v":3487500},{"$f":"H256*H247*3","v":3487500},{"$f":"SUM(C257:H257)","v":20925000}]
["Lunch & Snacks Fee","Per Term",37150,37150,37150,37150,37150,37150]
[null,"Annually",{"$f":"C258*C247*3","v":2786250},{"$f":"D258*D247*3","v":2786250},{"$f":"E258*E247*3","v":2786250},{"$f":"F258*F247*3","v":2786250},{"$f":"G258*G247*3","v":2786250},{"$f":"H258*H247*3","v":2786250},{"$f":"SUM(C259:H259)","v":16717500}]
["Activity Fee","Per Term",21450,21450,21450,24150,24150,24150]
[null,"Annually",{"$f":"C260*C247*3","v":1608750},{"$f":"D260*D247*3","v":1608750},{"$f":"E260*E247*3","v":1608750},{"$f":"F260*F247*3","v":1811250},{"$f":"G260*G247*3","v":1811250},{"$f":"H260*H247*3","v":1811250},{"$f":"SUM(C261:H261)","v":10260000}]
[]
[null,null,null,null,null,null,null,null,null,"Annual"]
["SENIOR SCHOOL",null,"Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Totals"]
["Number Of Students",null,25,25,25,25,25,25,25,{"$f":"SUM(C265:I265)","v":175}]
["Tution Fee","Per Term",325877.23,386652.53,386652.53,386652.53,530690.03,622703.85,622703.85]
[null,"Annually",{"$f":"C265*C266*3","v":24440792.25},{"$f":"D265*D266*3","v":28998939.75},{"$f":"E265*E266*3","v":28998939.75},{"$f":"F265*F266*3","v":28998939.75},{"$f":"G265*G266*3","v":39801752.25},{"$f":"H265*H266*3","v":46702788.75},{"$f":"I265*I266*3","v":46702788.75},{"$f":"SUM(C267:I267)","v":244644941.25}]
["Registration Fee",null,50000,50000,50000,50000,50000,50000,50000]
[null,"All Students",{"$f":"C268*C265","v":1250000},{"$f":"D268*D265","v":1250000},{"$f":"E268*E265","v":1250000},{"$f":"F268*F265","v":1250000},{"$f":"G268*G265","v":1250000},{"$f":"H268*H265","v":1250000},{"$f":"I268*I265","v":1250000},{"$f":"SUM(C269:I269)","v":8750000}]
["Caution Fee-Refundable",null,70000,70000,70000,70000,70000,70000,70000]
[null,"All Students",{"$f":"C270*C265","v":1750000},{"$f":"D270*D265","v":1750000},{"$f":"E270*E265","v":1750000},{"$f":"F270*F265","v":1750000},{"$f":"G270*G265","v":1750000},{"$f":"H270*H265","v":1750000},{"$f":"I270*I265","v":1750000},{"$f":"SUM(C271:I271)","v":12250000}]
["Capital Levy",null,150000,150000,150000,150000,150000,150000,150000]
[null,null,{"$f":"C272*C265","v":3750000},{"$f":"D272*D265","v":3750000},{"$f":"E272*E265","v":3750000},{"$f":"F272*F265","v":3750000},{"$f":"G272*G265","v":3750000},{"$f":"H272*H265","v":3750000},{"$f":"I272*I265","v":3750000},{"$f":"SUM(C273:I273)","v":26250000}]
["Transport Fee","Per Term",51000,51000,51000,51000,51000,51000,51000]
[null,"Annually",{"$f":"C274*C265*3","v":3825000},{"$f":"D274*D265*3","v":3825000},{"$f":"E274*E265*3","v":3825000},{"$f":"F274*F265*3","v":3825000},{"$f":"G274*G265*3","v":3825000},{"$f":"H274*H265*3","v":3825000},{"$f":"I274*I265*3","v":3825000},{"$f":"SUM(C275:I275)","v":26775000}]
["Lunch & Snacks Fee","Per Term",40250,40250,40250,40250,40250,40250,40250]
[null,"Annually",{"$f":"C276*C265*3","v":3018750},{"$f":"D276*D265*3","v":3018750},{"$f":"E276*E265*3","v":3018750},{"$f":"F276*F265*3","v":3018750},{"$f":"G276*G265*3","v":3018750},{"$f":"H276*H265*3","v":3018750},{"$f":"I276*I265*3","v":3018750},{"$f":"SUM(C277:I277)","v":21131250}]
["Activity Fee","Per Term",27600,27600,27600,27600,31050,31050,31050]
[null,"Annually",{"$f":"C278*C265*3","v":2070000},{"$f":"D278*D265*3","v":2070000},{"$f":"E278*E265*3","v":2070000},{"$f":"F278*F265*3","v":2070000},{"$f":"G278*G265*3","v":2328750},{"$f":"H278*H265*3","v":2328750},{"$f":"I278*I265*3","v":2328750},{"$f":"SUM(C279:I279)","v":15266250}]
[]
[]
["Rate",0.17,null,"Period","Installment","Interest","Loan Repayment","Loan Amount"]
["Loan Amount",{"$f":"IFERROR(IF('Financial Modelling'!B4=2,(B290+B292),(B290+B291)),0)","v":312000000},null,0,null,null,null,{"$f":"B283","v":312000000}]
["nper",10,null,1,{"$f":"$B$285","v":66972858.163465135},{"$f":"H283*$B$282","v":53040000.000000007},{"$f":"E284-F284","v":13932858.163465127},{"$f":"H283-G284","v":298067141.83653486}]
["Installment",{"$f":"B283/B286","v":66972858.163465135},null,{"$f":"D284+1","v":2},{"$f":"$B$285","v":66972858.163465135},{"$f":"H284*$B$282","v":50671414.112210929},{"$f":"E285-F285","v":16301444.051254205},{"$f":"H284-G285","v":281765697.78528064}]
["PVIFA17%/10",{"$f":"(1-(1+B282)^-10)/B282","v":4.6586036277335028},null,{"$f":"D285+1","v":3},66972858.163465135,47900168.62349771,19072689.539967425,262693008.24531323]
[null,null,null,4,66972858.163465135,44657811.401703253,22315046.761761881,240377961.48355135]
["Bus Price",8000000,null,5,66972858.163465135,40864253.452203736,26108604.711261399,214269356.77228996]
[null,null,null,6,66972858.163465135,36425790.651289299,30547067.512175836,183722289.26011413]
["Land & Buildings",280000000,"Number of Buses",7,66972858.163465135,31232789.174219403,35740068.989245728,147982220.27086842]
["Senario 1 & 3(3 buses)",{"$f":"B288*C291","v":24000000},3,8,66972858.163465135,25156977.446047634,41815880.717417501,106166339.55345091]
["2(4 buses)",{"$f":"B288*C292","v":32000000},4,9,66972858.163465135,18048277.724086657,48924580.439378478,{"$f":"H291-G292","v":57241759.114072435}]
[null,null,null,10,66972858.163465135,9731099.0493923146,57241759.114072822,{"$f":"G293-H292","v":3.8743019104003906E-7}]
[null,null,null,"Totals",{"$f":"SUM(E284:E293)","v":669728581.6346513},{"$f":"SUM(F284:F293)","v":357728581.63465095},312000000.00000036]
["Year","Total Students ","Buses Needed"]
[1,85,{"$f":"B296/50","v":1.7}]
[2,170,{"$f":"B297/50","v":3.4}]
[3,255,{"$f":"B298/50","v":5.0999999999999996}]
[4,340,{"$f":"B299/50","v":6.8}]
[5,425,8.5]

{"sheet":"Financial Modelling","index":2,"n_rows":503,"n_cols":27,"rows_kept":503,"cut":false,"hidden":false,"merged":[[77,23,77,25],[413,9,413,10],[255,2,255,5],[255,7,255,10],[255,12,255,15],[255,17,255,20],[403,5,403,20],[402,2,402,6],[15,23,15,25],[6,2,6,7],[68,2,68,7],[255,22,255,25],[0,0,0,25],[201,13,201,15],[201,18,201,20],[201,23,201,25],[1,22,1,25],[1,2,1,5],[1,7,1,10],[1,12,1,15],[1,17,1,20],[139,13,139,15],[139,18,139,20],[139,23,139,25],[462,2,462,6],[15,13,15,15],[130,2,130,7],[15,18,15,20],[77,13,77,15],[77,18,77,20],[432,2,432,8],[430,2,430,8],[431,2,431,8]]}
["Finanacial Statement Forecasting Sensitivity  & Scenario Analysis"]
["Prepared By:",null,"Year 1F",null,null,null,null,"Year 2F",null,null,null,null,"Year 3F",null,null,null,null,"Year 4F",null,null,null,null,"Year 5F"]
["© CPA Abdulrahman Juma Bakari",null,"Nursery","Junior","Senior",{"$f":"IFERROR(IF(OR(F300=F319,F300-F319<=0),\"Balanced\",\"Error\"),\"\")","v":"Balanced"},null,"Nursery","Junior","Senior",{"$f":"IFERROR(IF(OR(K300=K319,K300-K319<=0),\"Balanced\",\"Error\"),\"\")","v":"Balanced"},null,"Nursery","Junior","Senior",{"$f":"IFERROR(IF(OR(P300=P319,P300-P319<=0),\"Balanced\",\"Error\"),\"\")","v":"Balanced"},null,"Nursery","Junior","Senior",{"$f":"IFERROR(IF(OR(U300=U319,U300-U319<=0),\"Balanced\",\"Error\"),\"\")","v":"Balanced"},null,"Nursery","Junior","Senior",{"$f":"IFERROR(IF(OR(Z300=Z319,Z300-Z319<=0),\"Balanced\",\"Error\"),\"\")","v":"Balanced"}]
["Scenario",2,null,null,null,null,1,null,null,null,{"$f":"IF(B4=1,\"5% @ 5std\",IF(B4=2,\"7.5% @ 10std\",IF(B4=3,\"2.5% @ 3std\",\"\")))","v":"7.5% @ 10std"},null,null,null,null,{"$f":"IF(B4=1,\"5% @ 5std\",IF(B4=2,\"7.5% @ 10std\",IF(B4=3,\"2.5% @ 3std\",\"\")))","v":"7.5% @ 10std"},null,null,null,null,{"$f":"IF(B4=1,\"5% @ 5std\",IF(B4=2,\"7.5% @ 10std\",IF(B4=3,\"2.5% @ 3std\",\"\")))","v":"7.5% @ 10std"},null,null,null,null,{"$f":"IF(B4=1,\"5% @ 5std\",IF(B4=2,\"7.5% @ 10std\",IF(B4=3,\"2.5% @ 3std\",\"\")))","v":"7.5% @ 10std"}]
[]
["Assumption"]
["Income Statement(Modarate Case)",null,"5% increase in Tution Fee @ a modarate Student Increase of 5 par year",null,null,null,null,null,0.05,{"$f":"I7+1","v":1.05}]
["Tution Fee",null,{"$f":"JUB","v":5831250},{"$f":"GABA","v":17746500},{"$f":"JHDF","v":40254000},{"$f":"SUM(C8:E8)","v":63831750},null,{"$f":"FG37J","v":12245640},{"$f":"RT","v":37267650},{"$f":"GDF","v":84533400},{"$f":"SUM(H8:J8)","v":134046690},null,{"$f":"WER456FDG","v":19286910},{"$f":"GHJJK","v":58696560},{"$f":"QW","v":133140105},{"$f":"SUM(M8:O8)","v":211123575},null,{"$f":"DFGDG","v":27001620},{"$f":"FH","v":82175220},{"$f":"DFGHF","v":186396180},{"$f":"SUM(R8:T8)","v":295573020},null,{"$f":"JUMA","v":35439603.999749996},{"$f":"OL","v":107854907.7525},{"$f":"HAH","v":244644941.25},{"$f":"SUM(W8:Y8)","v":387939453.00224996}]
["Registration Fee",null,{"$f":"OPPO","v":1000000},{"$f":"TUO","v":1500000},{"$f":"SDKJFH","v":1750000},{"$f":"SUM(C9:E9)","v":4250000},null,{"$f":"DFJH","v":2000000},{"$f":"FHFG","v":3000000},{"$f":"GHJ","v":3500000},{"$f":"SUM(H9:J9)","v":8500000},null,{"$f":"HJ","v":3000000},{"$f":"DF","v":4500000},{"$f":"CVN","v":5250000},{"$f":"SUM(M9:O9)","v":12750000},null,{"$f":"ERYRT","v":4000000},{"$f":"DFHTR","v":6000000},{"$f":"ER456GR","v":7000000},{"$f":"SUM(R9:T9)","v":17000000},null,{"$f":"ROB","v":5000000},{"$f":"COL","v":7500000},{"$f":"ROP","v":8750000},{"$f":"SUM(W9:Y9)","v":21250000}]
["Caution Fee-Refundable",null,{"$f":"TY","v":1400000},{"$f":"RUI","v":2100000},{"$f":"SDJK","v":2450000},5950000,null,{"$f":"DFJHK","v":2800000},{"$f":"TUY","v":4200000},{"$f":"TYUD","v":4900000},11900000,null,{"$f":"GFF","v":4200000},{"$f":"ZXC","v":6300000},{"$f":"QWEWER","v":7350000},17850000,null,{"$f":"SDSG","v":5600000},{"$f":"DFGFD","v":8400000},{"$f":"DFGFD5564GHGF","v":9800000},23800000,null,{"$f":"TOM","v":7000000},{"$f":"BOLT","v":10500000},{"$f":"SOP","v":12250000},29750000]
["Capital Levy",null,{"$f":"TOB","v":3000000},{"$f":"TUI","v":4500000},{"$f":"KSDJFJK","v":5250000},12750000,null,{"$f":"ERR","v":6000000},{"$f":"JKL","v":9000000},{"$f":"DFG","v":10500000},25500000,null,{"$f":"GJ","v":9000000},{"$f":"ZSE","v":13500000},{"$f":"QDDGF","v":15750000},38250000,null,{"$f":"ERTYTR","v":12000000},{"$f":"ZDFG","v":18000000},{"$f":"DFDF467DF","v":21000000},51000000,null,{"$f":"NOM","v":15000000},{"$f":"DOM","v":22500000},{"$f":"KOP","v":26250000},63750000]
["Transport Fee",null,{"$f":"Y","v":2520000},{"$f":"WERUIYIU","v":4185000},{"$f":"SDFJK","v":5355000},12060000,null,{"$f":"HGH45T","v":6525000},{"$f":"FGH","v":8370000},{"$f":"TRY","v":10710000},25605000,null,{"$f":"TRYTY","v":7560000},{"$f":"TRTYFG","v":12555000},{"$f":"RTIOP","v":16065000},36180000,null,{"$f":"FDGD","v":10080000},{"$f":"ERT","v":16740000},{"$f":"ERER34FGFG","v":21420000},48240000,null,{"$f":"JOB","v":12600000},{"$f":"WOB","v":20925000},{"$f":"COP","v":26775000},60300000]
["Lunch & Snacks Fee",null,{"$f":"EWQ","v":1938000},{"$f":"HSJKLHK","v":3343500},{"$f":"JKSDFK","v":4226250},9507750,null,{"$f":"GHU56D","v":3876000},{"$f":"VBHG","v":6687000},{"$f":"YU","v":8452500},19015500,null,{"$f":"WER","v":5814000},{"$f":"RDFG","v":10030500},{"$f":"BMRTE","v":12678750},28523250,null,{"$f":"CVBCVFG","v":7752000},{"$f":"DFF","v":13374000},{"$f":"DSFSD","v":16905000},38031000,null,{"$f":"FOB","v":9690000},{"$f":"TOP","v":16717500},{"$f":"BOMB","v":21131250},47538750]
["Activity Fee",null,{"$f":"GA","v":810000},{"$f":"SDLFKHKL","v":2052000},{"$f":"IERYUI","v":3053250},5915250,null,{"$f":"DFFG56X","v":1620000},{"$f":"DFGDF","v":4104000},{"$f":"SDF","v":6106500},11830500,null,{"$f":"FNG","v":2430000},{"$f":"YUIU","v":6156000},{"$f":"FDGFDG","v":9159750},17745750,null,{"$f":"SDFSG","v":3240000},{"$f":"CVBCVN","v":8208000},{"$f":"ER665RR","v":12213000},23661000,null,{"$f":"LOB","v":4050000},{"$f":"FOP","v":10260000},{"$f":"TOYP","v":15266250},29576250]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,0.1,null,null,null,null,0.1]
["Salaries & Benefits",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly"]
["Salaries - Local Teachers",null,null,150000,14,{"$f":"D18*E18*12","v":25200000},null,null,150000,20,{"$f":"I18*J18*12","v":36000000},null,null,{"$f":"$I18*(1+$N$202)","v":165000},22,{"$f":"N18*O18*12","v":43560000},null,null,165000,24,{"$f":"S18*T18*12","v":47520000},null,null,{"$f":"S18*($X$202+1)","v":181500.00000000003},24,{"$f":"X18*Y18*12","v":52272000.000000015}]
["Salaries -Expatriates Teachers",null,null,350000,4,{"$f":"D19*E19*12","v":16800000},null,null,350000,6,{"$f":"I19*J19*12","v":25200000},null,null,385000.00000000006,6,{"$f":"N19*O19*12","v":27720000.000000007},null,null,385000.00000000006,7,{"$f":"S19*T19*12","v":32340000.000000007},null,null,423500.00000000012,7,{"$f":"X19*Y19*12","v":35574000.000000015}]
["Salaries -Principal",null,null,500000,1,6000000,null,null,500000,1,6000000,null,null,550000,1,6600000,null,null,550000,1,6600000,null,null,605000,1,7260000]
["Salaries -Deputy Principal",null,null,400000,1,4800000,null,null,400000,1,4800000,null,null,440000.00000000006,1,5280000.0000000009,null,null,440000.00000000006,1,5280000.0000000009,null,null,484000.00000000012,1,5808000.0000000019]
["Section Head - Nursery",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,363000.00000000006,1,4356000.0000000009]
["Section Head - Primary",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,363000.00000000006,1,4356000.0000000009]
["Section Head - High",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,363000.00000000006,1,4356000.0000000009]
["Salary -Support Stuff",null,null,30000,10,3600000,null,null,30000,15,5400000,null,null,33000,20,7920000,null,null,33000,20,7920000,null,null,36300,20,8712000]
["           - Support Stuff",null,null,60000,5,3600000,null,null,60000,8,5760000,null,null,66000,8,6336000,null,null,66000,9,7128000,null,null,72600,9,7840800]
["Cleaning Services & Sanitation",null,null,50000,null,{"$f":"D27*12","v":600000},null,null,50000,null,{"$f":"I27*12","v":600000},null,null,50000,null,{"$f":"N27*12","v":600000},null,null,50000,null,{"$f":"S27*12","v":600000},null,null,50000,null,{"$f":"X27*12","v":600000}]
["Security Services",null,null,200000,null,{"$f":"D28*12","v":2400000},null,null,200000,null,{"$f":"I28*12","v":2400000},null,null,200000,null,{"$f":"N28*12","v":2400000},null,null,200000,null,{"$f":"S28*12","v":2400000},null,null,200000,null,{"$f":"X28*12","v":2400000}]
[null,null,null,null,null,{"$f":"SUM(F18:F28)","v":73800000},null,null,null,null,{"$f":"SUM(K18:K28)","v":96960000},null,null,null,null,{"$f":"SUM(P18:P28)","v":112296000},null,null,null,null,{"$f":"SUM(U18:U28)","v":121668000},null,null,null,null,{"$f":"SUM(Z18:Z28)","v":133534800.00000003}]
["Benefits - Health",null,null,{"$f":"SUM(D18:D28)*0.0145","v":38280},null,{"$f":"D30*12","v":459360},null,null,{"$f":"SUM($I$204:$I$214)*0.0145","v":40455},null,{"$f":"I30*12","v":485460},null,null,{"$f":"SUM(N18:N28)*0.0145","v":41745.5},null,{"$f":"N30*12","v":500946},null,null,{"$f":"SUM(S18:S28)*0.0145","v":41745.5},null,{"$f":"S30*12","v":500946},null,null,{"$f":"SUM(X18:X28)*0.0145","v":45557.55},null,{"$f":"X30*12","v":546690.60000000009}]
[{"$f":"\"-House\"","v":"-House"},null,null,{"$f":"SUM(D18:D28)*0.0105","v":27720},null,{"$f":"D31*12","v":332640},null,null,{"$f":"SUM($I$204:$I$214)*0.0105","v":29295},null,{"$f":"I31*12","v":351540},null,null,{"$f":"SUM(N18:N28)*0.0105","v":30229.500000000004},null,{"$f":"N31*12","v":362754.00000000006},null,null,{"$f":"SUM(S18:S28)*0.0105","v":30229.500000000004},null,{"$f":"S31*12","v":362754.00000000006},null,null,{"$f":"SUM(X18:X28)*0.0105","v":32989.950000000004},null,{"$f":"X31*12","v":395879.4}]
[{"$f":"\"-Transport\"","v":"-Transport"},null,null,{"$f":"SUM(D18:D28)*0.0175","v":46200.000000000007},null,{"$f":"D32*12","v":554400.00000000012},null,null,{"$f":"SUM($I$204:$I$214)*0.0175","v":48825.000000000007},null,{"$f":"I32*12","v":585900.00000000012},null,null,{"$f":"SUM(N18:N28)*0.0175","v":50382.500000000007},null,{"$f":"N32*12","v":604590.00000000012},null,null,{"$f":"SUM(S18:S28)*0.0175","v":50382.500000000007},null,{"$f":"S32*12","v":604590.00000000012},null,null,{"$f":"SUM(X18:X28)*0.0175","v":54983.250000000007},null,{"$f":"X32*12","v":659799.00000000012}]
["Accountant",null,null,80000,1,{"$f":"D33*12*E33","v":960000},null,null,80000,1,{"$f":"I33*12*J33","v":960000},null,null,165000,1,{"$f":"N33*12*O33","v":1980000},null,null,165000,1,{"$f":"S33*12*T33","v":1980000},null,null,181500,1,{"$f":"X33*12*Y33","v":2178000}]
["Bursar & Clerk",null,null,60000,1,{"$f":"D34*12*E34","v":720000},null,null,60000,1,{"$f":"I34*12*J34","v":720000},null,null,77000,1,{"$f":"N34*12*O34","v":924000},null,null,77000,1,{"$f":"S34*12*T34","v":924000},null,null,84700,1,{"$f":"X34*12*Y34","v":1016400}]
["Staff Development",null,null,30000,10,3600000,null,null,6000,10,720000,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F30:F35)+F29","v":80426400},null,null,null,null,{"$f":"SUM(K30:K35)+K29","v":100782900},null,null,null,null,{"$f":"SUM(P30:P35)+P29","v":116668290},null,null,null,null,{"$f":"SUM(U30:U35)+U29","v":126040290},null,null,null,null,{"$f":"SUM(Z30:Z35)+Z29","v":138331569.00000003}]
[]
["Utilities"]
["Laboratory consumables",null,null,null,null,2000000,null,null,null,null,2000000,null,null,null,null,2000000,null,null,null,null,2000000,null,null,null,null,2000000]
["Toiletries",null,null,60000,12,{"$f":"E40*D40","v":720000},null,null,75000,12,{"$f":"J40*I40","v":900000},null,null,93750,12,{"$f":"O40*N40","v":1125000},null,null,117188,12,{"$f":"T40*S40","v":1406256},null,null,146484,12,{"$f":"Y40*X40","v":1757808}]
["Subscription",null,null,null,null,1000000,null,null,null,null,1000000,null,null,null,null,1000000,null,null,null,null,1000000,null,null,null,null,1000000]
["Internet",null,null,60000,12,{"$f":"E42*D42","v":720000},null,null,100000,12,{"$f":"J42*I42","v":1200000},null,null,140625,12,{"$f":"O42*N42","v":1687500},null,null,156250,12,{"$f":"T42*S42","v":1875000},null,null,195313,12,{"$f":"Y42*X42","v":2343756}]
["Telephone & Postage",null,null,50000,12,600000,null,null,75000,12,900000,null,null,93750,12,1125000,null,null,117188,12,1406256,null,null,146484,12,1757808]
["Computer Exp",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Electricity & Water",null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000]
["Staff Food",null,null,80000,12,960000,null,null,87500,12,1050000,null,null,109375,12,1312500,null,null,136719,12,1640628,null,null,170898,12,2050776]
["Student Meals and Snack",null,null,250000,12,{"$f":"E47*D47","v":3000000},null,null,500000,12,{"$f":"J47*I47","v":6000000},null,null,510000,12,{"$f":"O47*N47","v":6120000},null,null,520000,12,{"$f":"T47*S47","v":6240000},null,null,540000,12,{"$f":"Y47*X47","v":6480000}]
["Miscellenous",null,null,62500,12,{"$f":"E48*D48","v":750000},null,null,125000,12,{"$f":"J48*I48","v":1500000},null,null,null,null,{"$f":"O48*N48","v":0},null,null,193313,12,{"$f":"T48*S48","v":2319756},null,null,202141,12,{"$f":"Y48*X48","v":2425692}]
[null,null,null,null,null,{"$f":"SUM(F39:F48)","v":11150000},null,null,null,null,{"$f":"SUM(K39:K48)","v":15950000},null,null,null,null,{"$f":"SUM(P39:P48)","v":15770000},null,null,null,null,{"$f":"SUM(U39:U48)","v":19287896},null,null,null,null,{"$f":"SUM(Z39:Z48)","v":21215840}]
[]
["Supplies & Legal Exp"]
["Legal Fee",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Supplies-Instructional",null,null,null,null,null,null,null,100000,12,{"$f":"J53*I53","v":1200000},null,null,80000,12,{"$f":"O53*N53","v":960000},null,null,80000,12,{"$f":"T53*S53","v":960000},null,null,70000,12,{"$f":"Y53*X53","v":840000}]
["Supplies-Administrative",null,null,null,null,null,null,null,100000,12,1200000,null,null,90000,12,1080000,null,null,90000,12,1080000,null,null,60000,12,720000]
["Supplies-General",null,null,null,null,null,null,null,100000,12,1200000,null,null,90000,12,1080000,null,null,90000,12,1080000,null,null,62000,12,744000]
["Printing & Advertising",null,null,100000,12,{"$f":"D56*E56","v":1200000},null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000]
["Licences & Service charge",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Consultancy fees",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Maintenance and Repair",null,null,null,null,null,null,null,200000,12,{"$f":"J59*I59","v":2400000},null,null,100000,12,{"$f":"O59*N59","v":1200000},null,null,120000,12,{"$f":"T59*S59","v":1440000},null,null,100000,12,{"$f":"Y59*X59","v":1200000}]
["Insurance",null,null,null,null,100000,null,null,null,null,100000,null,null,null,null,100000,null,null,null,null,100000,null,null,null,null,100000]
[null,null,null,null,null,{"$f":"SUM(F52:F60)","v":1900000},null,null,null,null,{"$f":"SUM(K52:K60)","v":7900000},null,null,null,null,{"$f":"SUM(P52:P60)","v":6220000},null,null,null,null,{"$f":"SUM(U52:U60)","v":6460000},null,null,null,null,{"$f":"SUM(Z52:Z60)","v":5404000}]
["Finance Cost"]
["Start Up Loan(Long Term)",null,null,null,null,{"$f":"'Source Data'!F284","v":53040000.000000007},null,null,null,null,{"$f":"'Source Data'!F285","v":50671414.112210929},null,null,null,null,{"$f":"'Source Data'!F286","v":47900168.62349771},null,null,null,null,{"$f":"'Source Data'!F287","v":44657811.401703253},null,null,null,null,{"$f":"'Source Data'!F288","v":40864253.452203736}]
["Short Term Loan"]
[null,null,null,null,null,{"$f":"SUM(F63:F64)","v":53040000.000000007},null,null,null,null,{"$f":"SUM(K63:K64)","v":50671414.112210929},null,null,null,null,{"$f":"SUM(P63:P64)","v":47900168.62349771},null,null,null,null,{"$f":"SUM(U63:U64)","v":44657811.401703253},null,null,null,null,{"$f":"SUM(Z63:Z64)","v":40864253.452203736}]
[]
["Caution Money Refund",null,null,70000,5,{"$f":"D67*E67","v":350000},null,null,70000,10,{"$f":"I67*J67","v":700000},null,null,70000,15,{"$f":"N67*O67","v":1050000},null,null,70000,20,{"$f":"S67*T67","v":1400000},null,null,70000,25,{"$f":"X67*Y67","v":1750000}]
[]
["Income Statement(Best Case)",null,"7.5% increase in Tution Fee @ a modarate Student Increase of 10 par year",null,null,null,null,null,7.4999999999999997E-2,{"$f":"I69+1","v":1.075}]
["Tution Fee",null,5831250,17746500,40254000,63831750,null,{"$f":"((C70/(3*5)*J69)*(15*3))","v":18805781.25},{"$f":"((D70/(3*5)*J69)*(15*3))","v":57232462.5},{"$f":"((E70/(3*5)*J69)*(15*3))","v":129819150},{"$f":"SUM(H70:J70)","v":205857393.75},null,{"$f":"((H70/(3*15)*J69)*(25*3))","v":33693691.40625},{"$f":"((I70/(3*15)*J69)*(25*3))","v":102541495.3125},{"$f":"((J70/(3*15)*J69)*(25*3))","v":232592643.75},{"$f":"SUM(M70:O70)","v":368827830.46875},null,{"$f":"((M70/(3*25)*J69)*(35*3))","v":50709005.56640625},{"$f":"((N70/(3*25)*J69)*(35*3))","v":154324950.4453125},{"$f":"((O70/(3*25)*J69)*(35*3))","v":350051928.84375},{"$f":"SUM(R70:T70)","v":555085884.85546875},null,{"$f":"((R70/(3*35)*J69)*(45*3))","v":70087089.836425781},{"$f":"((S70/(3*35)*J69)*(45*3))","v":213299127.93691406},{"$f":"((T70/(3*35)*J69)*(45*3))","v":483821773.08046871},{"$f":"SUM(W70:Y70)","v":767207990.85380864}]
["Registration Fee",null,1000000,1500000,1750000,4250000,null,{"$f":"((C71/20)*(15*4))","v":3000000},{"$f":"((D71/30)*(15*6))","v":4500000},{"$f":"((E71/35)*(15*7))","v":5250000},{"$f":"SUM(H71:J71)","v":12750000},null,{"$f":"((H71/(15*4))*(25*4))","v":5000000},{"$f":"((I71/(15*6))*(25*6))","v":7500000},{"$f":"((J71/(15*7))*(25*7))","v":8750000},{"$f":"SUM(M71:O71)","v":21250000},null,{"$f":"((M71/(25*4))*(35*4))","v":7000000},{"$f":"((N71/(25*6))*(35*6))","v":10500000},{"$f":"((O71/(25*7))*(35*7))","v":12250000},{"$f":"SUM(R71:T71)","v":29750000},null,{"$f":"((R71/(35*4))*(45*4))","v":9000000},{"$f":"((S71/(35*6))*(45*6))","v":13500000},{"$f":"((T71/(35*7))*(45*7))","v":15750000},{"$f":"SUM(W71:Y71)","v":38250000}]
["Caution Fee-Refundable",null,1400000,2100000,2450000,5950000,null,{"$f":"((C72/20)*(15*4))","v":4200000},{"$f":"((D72/30)*(15*6))","v":6300000},{"$f":"((E72/35)*(15*7))","v":7350000},17850000,null,{"$f":"((H72/(15*4))*(25*4))","v":7000000},{"$f":"((I72/(15*6))*(25*6))","v":10500000},{"$f":"((J72/(15*7))*(25*7))","v":12250000},29750000,null,{"$f":"((M72/(25*4))*(35*4))","v":9800000},{"$f":"((N72/(25*6))*(35*6))","v":14700000},{"$f":"((O72/(25*7))*(35*7))","v":17150000},{"$f":"SUM(R72:T72)","v":41650000},null,{"$f":"((R72/(35*4))*(45*4))","v":12600000},{"$f":"((S72/(35*6))*(45*6))","v":18900000},{"$f":"((T72/(35*7))*(45*7))","v":22050000},{"$f":"SUM(W72:Y72)","v":53550000}]
["Capital Levy",null,3000000,4500000,5250000,12750000,null,{"$f":"((C73/20)*(15*4))","v":9000000},{"$f":"((D73/30)*(15*6))","v":13500000},15750000,38250000,null,15000000,22500000,26250000,63750000,null,21000000,31500000,36750000,89250000,null,27000000,40500000,47250000,114750000]
["Transport Fee",null,2520000,4185000,5355000,12060000,null,{"$f":"((C74/(20*3))*(15*4*3))","v":7560000},{"$f":"((D74/(30*3))*(15*6*3))","v":12555000},{"$f":"((E74/(35*3))*(15*7*3))","v":16065000},36180000,null,{"$f":"((H74/(15*4*3))*(25*4*3))","v":12600000},{"$f":"((I74/(15*6*3))*(25*6*3))","v":20925000},{"$f":"((J74/(15*7*3))*(25*7*3))","v":26775000},60300000,null,17640000,{"$f":"((N74/(25*6))*(35*6))","v":29295000},{"$f":"((O74/(25*7))*(35*7))","v":37485000},84420000,null,{"$f":"((R74/(35*4))*(45*4))","v":22680000},{"$f":"((S74/(35*6))*(45*6))","v":37665000},{"$f":"((T74/(35*7))*(45*7))","v":48195000},108540000]
["Lunch & Snacks Fee",null,1938000,3343500,4226250,9507750,null,{"$f":"((C75/(20*3))*(15*4*3))","v":5814000},{"$f":"((D75/(30*3))*(15*6*3))","v":10030500},{"$f":"((E75/(35*3))*(15*7*3))","v":12678750},28523250,null,{"$f":"((H75/(15*4*3))*(25*4*3))","v":9690000},{"$f":"((I75/(15*6*3))*(25*6*3))","v":16717500},{"$f":"((J75/(15*7*3))*(25*7*3))","v":21131250},47538750,null,13566000,{"$f":"((N75/(25*6))*(35*6))","v":23404500},{"$f":"((O75/(25*7))*(35*7))","v":29583750},66554250,null,{"$f":"((R75/(35*4))*(45*4))","v":17442000},{"$f":"((S75/(35*6))*(45*6))","v":30091500},{"$f":"((T75/(35*7))*(45*7))","v":38036250},85569750]
["Activity Fee",null,810000,2052000,3053250,5915250,null,2430000,{"$f":"((D76/(30*3))*(15*6*3))","v":6156000},9159750,17745750,null,4050000,10260000,15266250,29576250,null,5670000,14364000,21372750,41406750,null,7290000,18468000,27479250,53237250]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,0.1,null,null,null,null,0.1]
["Salaries & Benefits",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly"]
["Salaries - Local Teachers",null,null,150000,14,{"$f":"D80*E80*12","v":25200000},null,null,150000,25,{"$f":"I80*J80*12","v":45000000},null,null,{"$f":"$I80*(1+$N$202)","v":165000},34,{"$f":"N80*O80*12","v":67320000},null,null,165000,43,{"$f":"S80*T80*12","v":85140000},null,null,{"$f":"S80*($X$202+1)","v":181500.00000000003},52,{"$f":"X80*Y80*12","v":113256000.00000003}]
["Salaries -Expatriates Teachers",null,null,350000,4,{"$f":"D81*E81*12","v":16800000},null,null,350000,10,{"$f":"I81*J81*12","v":42000000},null,null,385000.00000000006,16,{"$f":"N81*O81*12","v":73920000.000000015},null,null,385000.00000000006,22,{"$f":"S81*T81*12","v":101640000.00000003},null,null,423500.00000000012,28,{"$f":"X81*Y81*12","v":142296000.00000006}]
["Salaries -Principal",null,null,500000,1,6000000,null,null,500000,1,6000000,null,null,550000,1,6600000,null,null,550000,1,6600000,null,null,605000,1,7260000]
["Salaries -Deputy Principal",null,null,400000,1,4800000,null,null,400000,1,4800000,null,null,440000.00000000006,1,5280000.0000000009,null,null,440000.00000000006,1,5280000.0000000009,null,null,484000.00000000012,1,5808000.0000000019]
["Section Head - Nursery",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,363000.00000000006,1,4356000.0000000009]
["Section Head - Primary",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,363000.00000000006,1,4356000.0000000009]
["Section Head - High",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,363000.00000000006,1,4356000.0000000009]
["Salary -Support Stuff",null,null,30000,10,3600000,null,null,30000,18,6480000,null,null,33000,20,7920000,null,null,33000,22,8712000,null,null,36300,24,10454400]
["           - Support Stuff",null,null,60000,5,3600000,null,null,60000,8,5760000,null,null,66000,8,6336000,null,null,66000,11,8712000,null,null,72600,11,9583200]
["Cleaning Services",null,null,200000,null,{"$f":"D89*12","v":2400000},null,null,300000,null,{"$f":"I89*12","v":3600000},null,null,null,null,{"$f":"N89*12","v":0},null,null,null,null,{"$f":"S89*12","v":0},null,null,null,null,{"$f":"X89*12","v":0}]
["Security Services",null,null,100000,null,{"$f":"D90*12","v":1200000},null,null,100000,null,{"$f":"I90*12","v":1200000},null,null,100000,null,{"$f":"N90*12","v":1200000},null,null,100000,null,{"$f":"S90*12","v":1200000},null,null,100000,null,{"$f":"X90*12","v":1200000}]
[null,null,null,null,null,{"$f":"SUM(F80:F90)","v":74400000},null,null,null,null,{"$f":"SUM(K80:K90)","v":125640000},null,null,null,null,{"$f":"SUM(P80:P90)","v":180456000},null,null,null,null,{"$f":"SUM(U80:U90)","v":229164000.00000003},null,null,null,null,{"$f":"SUM(Z80:Z90)","v":302925600.00000012}]
["Benefits - Health",null,null,{"$f":"SUM(D80:D90)*0.0145","v":39005},null,{"$f":"D92*12","v":468060},null,null,{"$f":"SUM($I$204:$I$214)*0.0145","v":40455},null,{"$f":"I92*12","v":485460},null,null,{"$f":"SUM(N80:N90)*0.0145","v":39570.5},null,{"$f":"N92*12","v":474846},null,null,{"$f":"SUM(S80:S90)*0.0145","v":39570.5},null,{"$f":"S92*12","v":474846},null,null,{"$f":"SUM(X80:X90)*0.0145","v":43382.55},null,{"$f":"X92*12","v":520590.60000000003}]
[{"$f":"\"-House\"","v":"-House"},null,null,{"$f":"SUM(D80:D90)*0.0105","v":28245},null,{"$f":"D93*12","v":338940},null,null,{"$f":"SUM($I$204:$I$214)*0.0105","v":29295},null,{"$f":"I93*12","v":351540},null,null,{"$f":"SUM(N80:N90)*0.0105","v":28654.5},null,{"$f":"N93*12","v":343854},null,null,{"$f":"SUM(S80:S90)*0.0105","v":28654.5},null,{"$f":"S93*12","v":343854},null,null,{"$f":"SUM(X80:X90)*0.0105","v":31414.95},null,{"$f":"X93*12","v":376979.4}]
[{"$f":"\"-Transport\"","v":"-Transport"},null,null,{"$f":"SUM(D80:D90)*0.0175","v":47075.000000000007},null,{"$f":"D94*12","v":564900.00000000012},null,null,{"$f":"SUM($I$204:$I$214)*0.0175","v":48825.000000000007},null,{"$f":"I94*12","v":585900.00000000012},null,null,{"$f":"SUM(N80:N90)*0.0175","v":47757.500000000007},null,{"$f":"N94*12","v":573090.00000000012},null,null,{"$f":"SUM(S80:S90)*0.0175","v":47757.500000000007},null,{"$f":"S94*12","v":573090.00000000012},null,null,{"$f":"SUM(X80:X90)*0.0175","v":52358.250000000007},null,{"$f":"X94*12","v":628299.00000000012}]
["Accountant",null,null,80000,1,{"$f":"D95*12*E95","v":960000},null,null,80000,1,{"$f":"I95*12*J95","v":960000},null,null,165000,2,{"$f":"N95*12*O95","v":3960000},null,null,165000,3,{"$f":"S95*12*T95","v":5940000},null,null,181500,3,{"$f":"X95*12*Y95","v":6534000}]
["Bursar & Clerk",null,null,60000,1,{"$f":"D96*12*E96","v":720000},null,null,60000,1,{"$f":"I96*12*J96","v":720000},null,null,77000,1,{"$f":"N96*12*O96","v":924000},null,null,77000,2,{"$f":"S96*12*T96","v":1848000},null,null,84700,2,{"$f":"X96*12*Y96","v":2032800}]
["Staff Development",null,null,30000,10,3600000,null,null,6000,10,720000,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F92:F97)+F91","v":81051900},null,null,null,null,{"$f":"SUM(K92:K97)+K91","v":129462900},null,null,null,null,{"$f":"SUM(P92:P97)+P91","v":186731790},null,null,null,null,{"$f":"SUM(U92:U97)+U91","v":238343790.00000003},null,null,null,null,{"$f":"SUM(Z92:Z97)+Z91","v":313018269.00000012}]
[]
["Utilities"]
["Laboratory consumables",null,null,null,null,2000000,null,null,null,null,2000000,null,null,null,null,2000000,null,null,null,null,2000000,null,null,null,null,2000000]
["Toiletries",null,null,60000,12,{"$f":"E102*D102","v":720000},null,null,75000,12,{"$f":"J102*I102","v":900000},null,null,93750,12,{"$f":"O102*N102","v":1125000},null,null,117188,12,{"$f":"T102*S102","v":1406256},null,null,146484,12,{"$f":"Y102*X102","v":1757808}]
["Subscription",null,null,null,null,1000000,null,null,null,null,1000000,null,null,null,null,1000000,null,null,null,null,1000000,null,null,null,null,1000000]
["Internet",null,null,60000,12,{"$f":"E104*D104","v":720000},null,null,100000,12,{"$f":"J104*I104","v":1200000},null,null,140625,12,{"$f":"O104*N104","v":1687500},null,null,156250,12,{"$f":"T104*S104","v":1875000},null,null,195313,12,{"$f":"Y104*X104","v":2343756}]
["Telephone & Postage",null,null,50000,12,600000,null,null,75000,12,900000,null,null,93750,12,1125000,null,null,117188,12,1406256,null,null,146484,12,1757808]
["Computer Exp",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Electricity & Water",null,null,100000,12,{"$f":"E107*D107","v":1200000},null,null,100000,12,{"$f":"J107*I107","v":1200000},null,null,100000,12,{"$f":"O107*N107","v":1200000},null,null,100000,12,{"$f":"T107*S107","v":1200000},null,null,100000,12,{"$f":"Y107*X107","v":1200000}]
["Staff Food",null,null,80000,12,960000,null,null,87500,12,1050000,null,null,109375,12,1312500,null,null,136719,12,1640628,null,null,170898,12,2050776]
["Student Meals and Snack",null,null,250000,12,{"$f":"E109*D109","v":3000000},null,null,500000,12,{"$f":"J109*I109","v":6000000},null,null,510000,12,{"$f":"O109*N109","v":6120000},null,null,520000,12,{"$f":"T109*S109","v":6240000},null,null,540000,12,{"$f":"Y109*X109","v":6480000}]
["Miscellenous",null,null,62500,12,{"$f":"E110*D110","v":750000},null,null,125000,12,{"$f":"J110*I110","v":1500000},null,null,null,null,{"$f":"O110*N110","v":0},null,null,193313,12,{"$f":"T110*S110","v":2319756},null,null,202141,12,{"$f":"Y110*X110","v":2425692}]
[null,null,null,null,null,{"$f":"SUM(F101:F110)","v":11150000},null,null,null,null,{"$f":"SUM(K101:K110)","v":15950000},null,null,null,null,{"$f":"SUM(P101:P110)","v":15770000},null,null,null,null,{"$f":"SUM(U101:U110)","v":19287896},null,null,null,null,{"$f":"SUM(Z101:Z110)","v":21215840}]
[]
["Supplies &Legal Exp"]
["Legal Fee",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Supplies-Instructional",null,null,null,null,null,null,null,100000,12,{"$f":"J115*I115","v":1200000},null,null,80000,12,{"$f":"O115*N115","v":960000},null,null,80000,12,{"$f":"T115*S115","v":960000},null,null,70000,12,{"$f":"Y115*X115","v":840000}]
["Supplies-Administrative",null,null,null,null,null,null,null,100000,12,1200000,null,null,90000,12,1080000,null,null,90000,12,1080000,null,null,60000,12,720000]
["Supplies-General",null,null,null,null,null,null,null,100000,12,1200000,null,null,90000,12,1080000,null,null,90000,12,1080000,null,null,62000,12,744000]
["Printing & Advertising",null,null,100000,12,{"$f":"D118*E118","v":1200000},null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000]
["Licences & Service charge",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Consultancy fees",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Maintenance and Repair",null,null,null,null,null,null,null,200000,12,{"$f":"J121*I121","v":2400000},null,null,100000,12,{"$f":"O121*N121","v":1200000},null,null,120000,12,{"$f":"T121*S121","v":1440000},null,null,100000,12,{"$f":"Y121*X121","v":1200000}]
["Insurance",null,null,null,null,100000,null,null,null,null,100000,null,null,null,null,100000,null,null,null,null,100000,null,null,null,null,100000]
[null,null,null,null,null,{"$f":"SUM(F114:F122)","v":1900000},null,null,null,null,{"$f":"SUM(K114:K122)","v":7900000},null,null,null,null,{"$f":"SUM(P114:P122)","v":6220000},null,null,null,null,{"$f":"SUM(U114:U122)","v":6460000},null,null,null,null,{"$f":"SUM(Z114:Z122)","v":5404000}]
["Finance Cost"]
["Start Up Loan(Long Term)",null,null,null,null,{"$f":"F63","v":53040000.000000007},null,null,null,null,{"$f":"K63","v":50671414.112210929},null,null,null,null,47900168.62349771,null,null,null,null,44657811.401703253,null,null,null,null,40864253.452203736]
["Short Term Loan"]
[null,null,null,null,null,{"$f":"SUM(F125:F126)","v":53040000.000000007},null,null,null,null,{"$f":"SUM(K125:K126)","v":50671414.112210929},null,null,null,null,{"$f":"SUM(P125:P126)","v":47900168.62349771},null,null,null,null,{"$f":"SUM(U125:U126)","v":44657811.401703253},null,null,null,null,{"$f":"SUM(Z125:Z126)","v":40864253.452203736}]
[]
["Caution Money Refund",null,null,70000,5,{"$f":"D129*E129","v":350000},null,null,70000,15,{"$f":"I129*J129","v":1050000},null,null,70000,25,{"$f":"N129*O129","v":1750000},null,null,70000,35,{"$f":"S129*T129","v":2450000},null,null,70000,45,{"$f":"X129*Y129","v":3150000}]
[]
["Income Statement(Worst Case)",null,"2.5% increase in Tution Fee @ a modarate Student Increase of 3 par year",null,null,null,null,null,2.5000000000000001E-2,{"$f":"I131+1","v":1.0249999999999999}]
["Tution Fee",null,5831250,17746500,40254000,63831750,null,{"$f":"((C132/(3*5)*J131)*(8*3))","v":9563249.9999999981},{"$f":"((D132/(3*5)*J131)*(8*3))","v":29104260},{"$f":"((E132/(3*5)*J131)*(8*3))","v":66016559.999999985},{"$f":"SUM(H132:J132)","v":104684069.99999999},null,{"$f":"((H132/(3*8)*J131)*(11*3))","v":13478205.468749996},{"$f":"((I132/(3*8)*J131)*(11*3))","v":41018816.4375},{"$f":"((J132/(3*8)*J131)*(11*3))","v":93042089.24999997},{"$f":"SUM(M132:O132)","v":147539111.15624997},null,{"$f":"((M132/(3*11)*J131)*(14*3))","v":17582931.679687493},{"$f":"((N132/(3*11)*J131)*(14*3))","v":53510910.534374997},{"$f":"((O132/(3*11)*J131)*(14*3))","v":121377634.61249995},{"$f":"SUM(R132:T132)","v":192471476.82656243},null,{"$f":"((R132/(3*14)*J131)*(17*3))","v":21884470.322753895},{"$f":"((S132/(3*14)*J131)*(17*3))","v":66601972.575820304},{"$f":"((T132/(3*14)*J131)*(17*3))","v":151071805.93734369},{"$f":"SUM(W132:Y132)","v":239558248.83591789}]
["Registration Fee",null,1000000,1500000,1750000,4250000,null,{"$f":"((C133/20)*(8*4))","v":1600000},{"$f":"((D133/30)*(8*6))","v":2400000},{"$f":"((E133/35)*(8*7))","v":2800000},{"$f":"SUM(H133:J133)","v":6800000},null,{"$f":"((H133/(8*4))*(11*4))","v":2200000},{"$f":"((I133/(8*6))*(11*6))","v":3300000},{"$f":"((J133/(8*7))*(11*7))","v":3850000},{"$f":"SUM(M133:O133)","v":9350000},null,{"$f":"((M133/(11*4))*(14*4))","v":2800000},{"$f":"((N133/(11*6))*(14*6))","v":4200000},{"$f":"((O133/(11*7))*(14*7))","v":4900000},{"$f":"SUM(R133:T133)","v":11900000},null,{"$f":"((R133/(14*4))*(17*4))","v":3400000},{"$f":"((S133/(14*6))*(17*6))","v":5100000},{"$f":"((T133/(14*7))*(17*7))","v":5950000},{"$f":"SUM(W133:Y133)","v":14450000}]
["Caution Fee-Refundable",null,1400000,2100000,2450000,5950000,null,{"$f":"((C134/20)*(8*4))","v":2240000},{"$f":"((D134/30)*(8*6))","v":3360000},{"$f":"((E134/35)*(8*7))","v":3920000},9520000,null,{"$f":"((H134/(8*4))*(11*4))","v":3080000},{"$f":"((I134/(8*6))*(11*6))","v":4620000},{"$f":"((J134/(8*7))*(11*7))","v":5390000},13090000,null,{"$f":"((M134/(11*4))*(14*4))","v":3920000},{"$f":"((N134/(11*6))*(14*6))","v":5880000},{"$f":"((O134/(11*7))*(14*7))","v":6860000},16660000,null,{"$f":"((R134/(14*4))*(17*4))","v":4760000},{"$f":"((S134/(14*6))*(17*6))","v":7140000},{"$f":"((T134/(14*7))*(17*7))","v":8330000},20230000]
["Capital Levy",null,3000000,4500000,5250000,12750000,null,4800000,7200000,8400000,20400000,null,6600000,9900000,11550000,28050000,null,8400000,12600000,14700000,35700000,null,10200000,15300000,17850000,43350000]
["Transport Fee",null,2520000,4185000,5355000,12060000,null,{"$f":"((C136/(20*3))*(8*4*3))","v":4032000},{"$f":"((D136/(30*3))*(8*6*3))","v":6696000},{"$f":"((E136/(35*3))*(8*7*3))","v":8568000},19296000,null,{"$f":"((H136/(8*4*3))*(8*4*3))","v":4032000},{"$f":"((I136/(8*6*3))*(11*6*3))","v":9207000},{"$f":"((J136/(8*7*3))*(11*7*3))","v":11781000},25020000,null,{"$f":"((M136/(11*4))*(14*4))","v":5131636.3636363633},{"$f":"((N136/(11*6))*(14*6))","v":11718000},{"$f":"((O136/(11*7))*(14*7))","v":14994000},31843636.363636363,null,{"$f":"((R136/(14*4))*(17*4))","v":6231272.7272727266},{"$f":"((S136/(14*6))*(17*6))","v":14229000},{"$f":"((T136/(14*7))*(17*7))","v":18207000},38667272.727272727]
["Lunch & Snacks Fee",null,1938000,3343500,4226250,9507750,null,{"$f":"((C137/(20*3))*(8*4*3))","v":3100800},{"$f":"((D137/(30*3))*(8*6*3))","v":5349600},{"$f":"((E137/(35*3))*(8*7*3))","v":6762000},15212400,null,{"$f":"((H137/(8*4*3))*(8*4*3))","v":3100800},{"$f":"((I137/(8*6*3))*(11*6*3))","v":7355700},{"$f":"((J137/(8*7*3))*(11*7*3))","v":9297750},19754250,null,{"$f":"((M137/(11*4))*(14*4))","v":3946472.7272727275},{"$f":"((N137/(11*6))*(14*6))","v":9361800},{"$f":"((O137/(11*7))*(14*7))","v":11833500},25141772.727272727,null,{"$f":"((R137/(14*4))*(17*4))","v":4792145.4545454551},{"$f":"((S137/(14*6))*(17*6))","v":11367900},{"$f":"((T137/(14*7))*(17*7))","v":14369250},30529295.454545453]
["Activity Fee",null,810000,2052000,3053250,5915250,null,1296000,3283200,4885200,9464400,null,1296000,4514400,6717150,12527550,null,1649454.5454545454,5745600,8549100,15944154.545454545,null,2002909.0909090908,6976800,10381050,19360759.09090909]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,0.1,null,null,null,null,0.1]
["Salaries & Benefits",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly"]
["Salaries - Local Teachers",null,null,150000,14,{"$f":"D142*E142*12","v":25200000},null,null,150000,16,{"$f":"I142*J142*12","v":28800000},null,null,{"$f":"$I142*(1+$N$202)","v":165000},18,{"$f":"N142*O142*12","v":35640000},null,null,165000,20,{"$f":"S142*T142*12","v":39600000},null,null,{"$f":"S142*($X$202+1)","v":181500.00000000003},22,{"$f":"X142*Y142*12","v":47916000.000000007}]
["Salaries -Expatriates Teachers",null,null,350000,4,{"$f":"D143*E143*12","v":16800000},null,null,350000,6,{"$f":"I143*J143*12","v":25200000},null,null,385000.00000000006,6,{"$f":"N143*O143*12","v":27720000.000000007},null,null,385000.00000000006,7,{"$f":"S143*T143*12","v":32340000.000000007},null,null,423500.00000000012,7,{"$f":"X143*Y143*12","v":35574000.000000015}]
["Salaries -Principal",null,null,500000,1,6000000,null,null,500000,1,6000000,null,null,550000,1,6600000,null,null,550000,1,6600000,null,null,605000,1,7260000]
["Salaries -Deputy Principal",null,null,400000,1,4800000,null,null,400000,1,4800000,null,null,440000.00000000006,1,5280000.0000000009,null,null,440000.00000000006,1,5280000.0000000009,null,null,484000.00000000012,1,5808000.0000000019]
["Section Head - Nursery",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,363000.00000000006,1,4356000.0000000009]
["Section Head - Primary",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,363000.00000000006,1,4356000.0000000009]
["Section Head - High",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,363000.00000000006,1,4356000.0000000009]
["Salary -Support Stuff",null,null,30000,10,3600000,null,null,30000,15,5400000,null,null,33000,20,7920000,null,null,33000,20,7920000,null,null,36300,20,8712000]
["           - Support Stuff",null,null,60000,5,3600000,null,null,60000,8,5760000,null,null,66000,8,6336000,null,null,66000,9,7128000,null,null,72600,9,7840800]
["Cleaning Services",null,null,200000,null,{"$f":"D151*12","v":2400000},null,null,300000,null,{"$f":"I151*12","v":3600000},null,null,null,null,{"$f":"N151*12","v":0},null,null,null,null,{"$f":"S151*12","v":0},null,null,null,null,{"$f":"X151*12","v":0}]
["Security Services",null,null,100000,null,{"$f":"D152*12","v":1200000},null,null,100000,null,{"$f":"I152*12","v":1200000},null,null,100000,null,{"$f":"N152*12","v":1200000},null,null,100000,null,{"$f":"S152*12","v":1200000},null,null,100000,null,{"$f":"X152*12","v":1200000}]
[null,null,null,null,null,{"$f":"SUM(F142:F152)","v":74400000},null,null,null,null,{"$f":"SUM(K142:K152)","v":91560000},null,null,null,null,{"$f":"SUM(P142:P152)","v":102576000},null,null,null,null,{"$f":"SUM(U142:U152)","v":111948000},null,null,null,null,{"$f":"SUM(Z142:Z152)","v":127378800.00000003}]
["Benefits - Health",null,null,{"$f":"SUM(D142:D152)*0.0145","v":39005},null,{"$f":"D154*12","v":468060},null,null,{"$f":"SUM($I$204:$I$214)*0.0145","v":40455},null,{"$f":"I154*12","v":485460},null,null,{"$f":"SUM(N142:N152)*0.0145","v":39570.5},null,{"$f":"N154*12","v":474846},null,null,{"$f":"SUM(S142:S152)*0.0145","v":39570.5},null,{"$f":"S154*12","v":474846},null,null,{"$f":"SUM(X142:X152)*0.0145","v":43382.55},null,{"$f":"X154*12","v":520590.60000000003}]
[{"$f":"\"-House\"","v":"-House"},null,null,{"$f":"SUM(D142:D152)*0.0105","v":28245},null,{"$f":"D155*12","v":338940},null,null,{"$f":"SUM($I$204:$I$214)*0.0105","v":29295},null,{"$f":"I155*12","v":351540},null,null,{"$f":"SUM(N142:N152)*0.0105","v":28654.5},null,{"$f":"N155*12","v":343854},null,null,{"$f":"SUM(S142:S152)*0.0105","v":28654.5},null,{"$f":"S155*12","v":343854},null,null,{"$f":"SUM(X142:X152)*0.0105","v":31414.95},null,{"$f":"X155*12","v":376979.4}]
[{"$f":"\"-Transport\"","v":"-Transport"},null,null,{"$f":"SUM(D142:D152)*0.0175","v":47075.000000000007},null,{"$f":"D156*12","v":564900.00000000012},null,null,{"$f":"SUM($I$204:$I$214)*0.0175","v":48825.000000000007},null,{"$f":"I156*12","v":585900.00000000012},null,null,{"$f":"SUM(N142:N152)*0.0175","v":47757.500000000007},null,{"$f":"N156*12","v":573090.00000000012},null,null,{"$f":"SUM(S142:S152)*0.0175","v":47757.500000000007},null,{"$f":"S156*12","v":573090.00000000012},null,null,{"$f":"SUM(X142:X152)*0.0175","v":52358.250000000007},null,{"$f":"X156*12","v":628299.00000000012}]
["Accountant",null,null,80000,1,{"$f":"D157*12*E157","v":960000},null,null,80000,1,{"$f":"I157*12*J157","v":960000},null,null,165000,1,{"$f":"N157*12*O157","v":1980000},null,null,165000,1,{"$f":"S157*12*T157","v":1980000},null,null,181500,1,{"$f":"X157*12*Y157","v":2178000}]
["Bursar & Clerk",null,null,60000,1,{"$f":"D158*12*E158","v":720000},null,null,60000,1,{"$f":"I158*12*J158","v":720000},null,null,77000,1,{"$f":"N158*12*O158","v":924000},null,null,77000,1,{"$f":"S158*12*T158","v":924000},null,null,84700,1,{"$f":"X158*12*Y158","v":1016400}]
["Staff Development",null,null,30000,10,3600000,null,null,6000,10,720000,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,{"$f":"SUM(F154:F159)+F153","v":81051900},null,null,null,null,{"$f":"SUM(K154:K159)+K153","v":95382900},null,null,null,null,{"$f":"SUM(P154:P159)+P153","v":106871790},null,null,null,null,{"$f":"SUM(U154:U159)+U153","v":116243790},null,null,null,null,{"$f":"SUM(Z154:Z159)+Z153","v":132099069.00000003}]
[]
["Utilities"]
["Laboratory consumables",null,null,null,null,2000000,null,null,null,null,2000000,null,null,null,null,2000000,null,null,null,null,2000000,null,null,null,null,2000000]
["Toiletries",null,null,60000,12,{"$f":"E164*D164","v":720000},null,null,75000,12,{"$f":"J164*I164","v":900000},null,null,93750,12,{"$f":"O164*N164","v":1125000},null,null,117188,12,{"$f":"T164*S164","v":1406256},null,null,146484,12,{"$f":"Y164*X164","v":1757808}]
["Subscription",null,null,null,null,1000000,null,null,null,null,1000000,null,null,null,null,1000000,null,null,null,null,1000000,null,null,null,null,1000000]
["Internet",null,null,60000,12,{"$f":"E166*D166","v":720000},null,null,100000,12,{"$f":"J166*I166","v":1200000},null,null,140625,12,{"$f":"O166*N166","v":1687500},null,null,156250,12,{"$f":"T166*S166","v":1875000},null,null,195313,12,{"$f":"Y166*X166","v":2343756}]
["Telephone & Postage",null,null,50000,12,600000,null,null,75000,12,900000,null,null,93750,12,1125000,null,null,117188,12,1406256,null,null,146484,12,1757808]
["Computer Exp",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Electricity & Water",null,null,100000,12,{"$f":"E169*D169","v":1200000},null,null,100000,12,{"$f":"J169*I169","v":1200000},null,null,100000,12,{"$f":"O169*N169","v":1200000},null,null,100000,12,{"$f":"T169*S169","v":1200000},null,null,100000,12,{"$f":"Y169*X169","v":1200000}]
["Staff Food",null,null,80000,12,960000,null,null,87500,12,1050000,null,null,109375,12,1312500,null,null,136719,12,1640628,null,null,170898,12,2050776]
["Student Meals and Snack",null,null,250000,12,{"$f":"E171*D171","v":3000000},null,null,500000,12,{"$f":"J171*I171","v":6000000},null,null,510000,12,{"$f":"O171*N171","v":6120000},null,null,520000,12,{"$f":"T171*S171","v":6240000},null,null,540000,12,{"$f":"Y171*X171","v":6480000}]
["Miscellenous",null,null,62500,12,{"$f":"E172*D172","v":750000},null,null,125000,12,{"$f":"J172*I172","v":1500000},null,null,null,null,{"$f":"O172*N172","v":0},null,null,193313,12,{"$f":"T172*S172","v":2319756},null,null,202141,12,{"$f":"Y172*X172","v":2425692}]
[null,null,null,null,null,{"$f":"SUM(F163:F172)","v":11150000},null,null,null,null,{"$f":"SUM(K163:K172)","v":15950000},null,null,null,null,{"$f":"SUM(P163:P172)","v":15770000},null,null,null,null,{"$f":"SUM(U163:U172)","v":19287896},null,null,null,null,{"$f":"SUM(Z163:Z172)","v":21215840}]
[]
["Supplies &Legal Exp"]
["Legal Fee",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Supplies-Instructional",null,null,null,null,null,null,null,100000,12,{"$f":"J177*I177","v":1200000},null,null,80000,12,{"$f":"O177*N177","v":960000},null,null,80000,12,{"$f":"T177*S177","v":960000},null,null,70000,12,{"$f":"Y177*X177","v":840000}]
["Supplies-Administrative",null,null,null,null,null,null,null,100000,12,1200000,null,null,90000,12,1080000,null,null,90000,12,1080000,null,null,60000,12,720000]
["Supplies-General",null,null,null,null,null,null,null,100000,12,1200000,null,null,90000,12,1080000,null,null,90000,12,1080000,null,null,62000,12,744000]
["Printing & Advertising",null,null,100000,12,{"$f":"D180*E180","v":1200000},null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000]
["Licences & Service charge",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Consultancy fees",null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000,null,null,null,null,200000]
["Maintenance and Repair",null,null,null,null,null,null,null,200000,12,{"$f":"J183*I183","v":2400000},null,null,100000,12,{"$f":"O183*N183","v":1200000},null,null,120000,12,{"$f":"T183*S183","v":1440000},null,null,100000,12,{"$f":"Y183*X183","v":1200000}]
["Insurance",null,null,null,null,100000,null,null,null,null,100000,null,null,null,null,100000,null,null,null,null,100000,null,null,null,null,100000]
[null,null,null,null,null,{"$f":"SUM(F176:F184)","v":1900000},null,null,null,null,{"$f":"SUM(K176:K184)","v":7900000},null,null,null,null,{"$f":"SUM(P176:P184)","v":6220000},null,null,null,null,{"$f":"SUM(U176:U184)","v":6460000},null,null,null,null,{"$f":"SUM(Z176:Z184)","v":5404000}]
["Finance Cost"]
["Start Up Loan(Long Term)",null,null,null,null,{"$f":"F125","v":53040000.000000007},null,null,null,null,{"$f":"K125","v":50671414.112210929},null,null,null,null,47900168.62349771,null,null,null,null,44657811.401703253,null,null,null,null,40864253.452203736]
["Short Term Loan"]
[null,null,null,null,null,{"$f":"SUM(F187:F188)","v":53040000.000000007},null,null,null,null,{"$f":"SUM(K187:K188)","v":50671414.112210929},null,null,null,null,{"$f":"SUM(P187:P188)","v":47900168.62349771},null,null,null,null,{"$f":"SUM(U187:U188)","v":44657811.401703253},null,null,null,null,{"$f":"SUM(Z187:Z188)","v":40864253.452203736}]
[]
["Caution Money Refund",null,null,70000,5,{"$f":"D191*E191","v":350000},null,null,70000,8,{"$f":"I191*J191","v":560000},null,null,70000,11,{"$f":"N191*O191","v":770000},null,null,70000,14,{"$f":"S191*T191","v":980000},null,null,70000,17,{"$f":"X191*Y191","v":1190000}]
[]
["Income Statement(Live Case)"]
["Tution Fee",null,{"$f":"IFERROR(CHOOSE($B$4,C8,C70,C132),\"\")","v":5831250},17746500,40254000,63831750,null,{"$f":"IFERROR(CHOOSE($B$4,H8,H70,H132),\"\")","v":18805781.25},57232462.5,129819150,205857393.75,null,{"$f":"IFERROR(CHOOSE($B$4,M8,M70,M132),\"\")","v":33693691.40625},102541495.3125,232592643.75,368827830.46875,null,{"$f":"IFERROR(CHOOSE($B$4,R8,R70,R132),\"\")","v":50709005.56640625},154324950.4453125,350051928.84375,555085884.85546875,null,{"$f":"IFERROR(CHOOSE($B$4,W8,W70,W132),\"\")","v":70087089.836425781},213299127.93691406,483821773.08046871,767207990.85380864]
["Registration Fee",null,1000000,1500000,1750000,4250000,null,3000000,4500000,5250000,12750000,null,5000000,7500000,8750000,21250000,null,7000000,10500000,12250000,29750000,null,9000000,13500000,15750000,38250000]
["Caution Fee-Refundable",null,1400000,2100000,2450000,5950000,null,4200000,6300000,7350000,17850000,null,7000000,10500000,12250000,29750000,null,9800000,14700000,17150000,41650000,null,12600000,18900000,22050000,53550000]
["Capital Levy",null,3000000,4500000,5250000,12750000,null,9000000,13500000,15750000,38250000,null,15000000,22500000,26250000,63750000,null,21000000,31500000,36750000,89250000,null,27000000,40500000,47250000,114750000]
["Transport Fee",null,2520000,4185000,5355000,12060000,null,7560000,12555000,16065000,36180000,null,12600000,20925000,26775000,60300000,null,17640000,29295000,37485000,84420000,null,22680000,37665000,48195000,108540000]
["Lunch & Snacks Fee",null,1938000,3343500,4226250,9507750,null,5814000,10030500,12678750,28523250,null,9690000,16717500,21131250,47538750,null,13566000,23404500,29583750,66554250,null,17442000,30091500,38036250,85569750]
["Activity Fee",null,810000,2052000,3053250,5915250,null,2430000,6156000,9159750,17745750,null,4050000,10260000,15266250,29576250,null,5670000,14364000,21372750,41406750,null,7290000,18468000,27479250,53237250]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,0.1,null,null,null,null,0.1]
["Salaries & Benefits",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly",null,null,"Monthly ","Number ","Yearly"]
["Salaries - Local Teachers",null,null,{"$f":"IFERROR(CHOOSE($B$4,D18,D80,D142),\"\")","v":150000},{"$f":"IFERROR(CHOOSE($B$4,E18,E80,E142),\"\")","v":14},{"$f":"D204*E204*12","v":25200000},null,null,{"$f":"IFERROR(CHOOSE($B$4,I18,I80,I142),\"\")","v":150000},{"$f":"IFERROR(CHOOSE($B$4,J18,J80,J142),\"\")","v":25},{"$f":"I204*J204*12","v":45000000},null,null,{"$f":"IFERROR(CHOOSE($B$4,N18,N80,N142),\"\")","v":165000},{"$f":"IFERROR(CHOOSE($B$4,O18,O80,O142),\"\")","v":34},{"$f":"N204*O204*12","v":67320000},null,null,{"$f":"IFERROR(CHOOSE($B$4,S18,S80,S142),\"\")","v":165000},{"$f":"IFERROR(CHOOSE($B$4,T18,T80,T142),\"\")","v":43},{"$f":"S204*T204*12","v":85140000},null,null,{"$f":"IFERROR(CHOOSE($B$4,X18,X80,X142),\"\")","v":181500.00000000003},{"$f":"IFERROR(CHOOSE($B$4,Y18,Y80,Y142),\"\")","v":52},{"$f":"X204*Y204*12","v":113256000.00000003}]
["Salaries -Expatriates Teachers",null,null,{"$f":"IFERROR(CHOOSE($B$4,D19,D81,D143),\"\")","v":350000},4,{"$f":"D205*E205*12","v":16800000},null,null,{"$f":"IFERROR(CHOOSE($B$4,I19,I81,I143),\"\")","v":350000},10,{"$f":"I205*J205*12","v":42000000},null,null,{"$f":"IFERROR(CHOOSE($B$4,N19,N81,N143),\"\")","v":385000.00000000006},16,{"$f":"N205*O205*12","v":73920000.000000015},null,null,{"$f":"IFERROR(CHOOSE($B$4,S19,S81,S143),\"\")","v":385000.00000000006},22,{"$f":"S205*T205*12","v":101640000.00000003},null,null,{"$f":"IFERROR(CHOOSE($B$4,X19,X81,X143),\"\")","v":423500.00000000012},28,{"$f":"X205*Y205*12","v":142296000.00000006}]
["Salaries -Principal",null,null,500000,1,6000000,null,null,500000,1,6000000,null,null,550000,1,6600000,null,null,550000,1,6600000,null,null,{"$f":"IFERROR(CHOOSE($B$4,X20,X82,X144),\"\")","v":605000},1,7260000]
["Salaries -Deputy Principal",null,null,400000,1,4800000,null,null,400000,1,4800000,null,null,440000.00000000006,1,5280000.0000000009,null,null,440000.00000000006,1,5280000.0000000009,null,null,{"$f":"IFERROR(CHOOSE($B$4,X21,X83,X145),\"\")","v":484000.00000000012},1,5808000.0000000019]
["Section Head - Nursery",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,{"$f":"IFERROR(CHOOSE($B$4,X22,X84,X146),\"\")","v":363000.00000000006},1,4356000.0000000009]
["Section Head - Primary",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,{"$f":"IFERROR(CHOOSE($B$4,X23,X85,X147),\"\")","v":363000.00000000006},1,4356000.0000000009]
["Section Head - High",null,null,300000,1,3600000,null,null,300000,1,3600000,null,null,330000,1,3960000,null,null,330000,1,3960000,null,null,{"$f":"IFERROR(CHOOSE($B$4,X24,X86,X148),\"\")","v":363000.00000000006},1,4356000.0000000009]
["Salary -Support Stuff",null,null,30000,10,3600000,null,null,30000,18,6480000,null,null,33000,20,7920000,null,null,33000,22,8712000,null,null,{"$f":"IFERROR(CHOOSE($B$4,X25,X87,X149),\"\")","v":36300},24,10454400]
["           - Support Stuff",null,null,60000,5,3600000,null,null,60000,8,5760000,null,null,66000,8,6336000,null,null,66000,11,8712000,null,null,{"$f":"IFERROR(CHOOSE($B$4,X26,X88,X150),\"\")","v":72600},11,9583200]
["Cleaning Services",null,null,200000,0,{"$f":"D213*12","v":2400000},null,null,300000,0,{"$f":"I213*12","v":3600000},null,null,0,0,{"$f":"N213*12","v":0},null,null,0,0,{"$f":"S213*12","v":0},null,null,{"$f":"IFERROR(CHOOSE($B$4,X27,X89,X151),\"\")","v":0},0,{"$f":"X213*12","v":0}]
["Security Services",null,null,100000,0,{"$f":"D214*12","v":1200000},null,null,100000,0,{"$f":"I214*12","v":1200000},null,null,100000,0,{"$f":"N214*12","v":1200000},null,null,100000,0,{"$f":"S214*12","v":1200000},null,null,{"$f":"IFERROR(CHOOSE($B$4,X28,X90,X152),\"\")","v":100000},0,{"$f":"X214*12","v":1200000}]
[null,null,null,0,0,{"$f":"SUM(F204:F214)","v":74400000},null,null,0,0,{"$f":"SUM(K204:K214)","v":125640000},null,null,0,0,{"$f":"SUM(P204:P214)","v":180456000},null,null,0,0,{"$f":"SUM(U204:U214)","v":229164000.00000003},null,null,{"$f":"IFERROR(CHOOSE($B$4,X29,X91,X153),\"\")","v":0},0,{"$f":"SUM(Z204:Z214)","v":302925600.00000012}]
["Benefits - Health",null,null,39005,0,{"$f":"D216*12","v":468060},null,null,40455,0,{"$f":"I216*12","v":485460},null,null,39570.5,0,{"$f":"N216*12","v":474846},null,null,39570.5,0,{"$f":"S216*12","v":474846},null,null,{"$f":"IFERROR(CHOOSE($B$4,X30,X92,X154),\"\")","v":43382.55},0,{"$f":"X216*12","v":520590.60000000003}]
[{"$f":"\"-House\"","v":"-House"},null,null,28245,0,{"$f":"D217*12","v":338940},null,null,29295,0,{"$f":"I217*12","v":351540},null,null,28654.5,0,{"$f":"N217*12","v":343854},null,null,28654.5,0,{"$f":"S217*12","v":343854},null,null,{"$f":"IFERROR(CHOOSE($B$4,X31,X93,X155),\"\")","v":31414.95},0,{"$f":"X217*12","v":376979.4}]
[{"$f":"\"-Transport\"","v":"-Transport"},null,null,47075.000000000007,0,{"$f":"D218*12","v":564900.00000000012},null,null,48825.000000000007,0,{"$f":"I218*12","v":585900.00000000012},null,null,47757.500000000007,0,{"$f":"N218*12","v":573090.00000000012},null,null,47757.500000000007,0,{"$f":"S218*12","v":573090.00000000012},null,null,{"$f":"IFERROR(CHOOSE($B$4,X32,X94,X156),\"\")","v":52358.250000000007},0,{"$f":"X218*12","v":628299.00000000012}]
["Accountant",null,null,80000,1,{"$f":"D219*12*E219","v":960000},null,null,80000,1,{"$f":"I219*12*J219","v":960000},null,null,165000,2,{"$f":"N219*12*O219","v":3960000},null,null,165000,3,{"$f":"S219*12*T219","v":5940000},null,null,{"$f":"IFERROR(CHOOSE($B$4,X33,X95,X157),\"\")","v":181500},3,{"$f":"X219*12*Y219","v":6534000}]
["Bursar & Clerk",null,null,60000,1,{"$f":"D220*12*E220","v":720000},null,null,60000,1,{"$f":"I220*12*J220","v":720000},null,null,77000,1,{"$f":"N220*12*O220","v":924000},null,null,77000,2,{"$f":"S220*12*T220","v":1848000},null,null,{"$f":"IFERROR(CHOOSE($B$4,X34,X96,X158),\"\")","v":84700},2,{"$f":"X220*12*Y220","v":2032800}]
["Staff Development",null,null,30000,10,3600000,null,null,6000,10,720000,null,null,0,0,0,null,null,0,0,0,null,null,{"$f":"IFERROR(CHOOSE($B$4,X35,X97,X159),\"\")","v":0},0,0]
[null,null,null,null,null,{"$f":"SUM(F216:F221)+F215","v":81051900},null,null,null,null,{"$f":"SUM(K216:K221)+K215","v":129462900},null,null,null,null,{"$f":"SUM(P216:P221)+P215","v":186731790},null,null,null,null,{"$f":"SUM(U216:U221)+U215","v":238343790.00000003},null,null,null,null,{"$f":"SUM(Z216:Z221)+Z215","v":313018269.00000012}]
[]
["Utilities"]
["Laboratory consumables",null,null,{"$f":"IFERROR(CHOOSE($B$4,D39,D101,D163),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,E39,E101,E163),\"\")","v":0},2000000,null,null,0,0,2000000,null,null,0,0,2000000,null,null,0,0,2000000,null,null,0,0,2000000]
["Toiletries",null,null,{"$f":"IFERROR(CHOOSE($B$4,D40,D102,D164),\"\")","v":60000},{"$f":"IFERROR(CHOOSE($B$4,E40,E102,E164),\"\")","v":12},720000,null,null,75000,12,900000,null,null,93750,12,1125000,null,null,117188,12,1406256,null,null,146484,12,1757808]
["Subscription",null,null,0,{"$f":"IFERROR(CHOOSE($B$4,E41,E103,E165),\"\")","v":0},1000000,null,null,0,0,1000000,null,null,0,0,1000000,null,null,0,0,1000000,null,null,0,0,1000000]
["Internet",null,null,60000,{"$f":"IFERROR(CHOOSE($B$4,E42,E104,E166),\"\")","v":12},720000,null,null,100000,12,1200000,null,null,140625,12,1687500,null,null,156250,12,1875000,null,null,195313,12,2343756]
["Telephone & Postage",null,null,50000,{"$f":"IFERROR(CHOOSE($B$4,E43,E105,E167),\"\")","v":12},600000,null,null,75000,12,900000,null,null,93750,12,1125000,null,null,117188,12,1406256,null,null,146484,12,1757808]
["Computer Exp",null,null,0,{"$f":"IFERROR(CHOOSE($B$4,E44,E106,E168),\"\")","v":0},200000,null,null,0,0,200000,null,null,0,0,200000,null,null,0,0,200000,null,null,0,0,200000]
["Electricity & Water",null,null,100000,{"$f":"IFERROR(CHOOSE($B$4,E45,E107,E169),\"\")","v":12},1200000,null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000]
["Staff Food",null,null,80000,{"$f":"IFERROR(CHOOSE($B$4,E46,E108,E170),\"\")","v":12},960000,null,null,87500,12,1050000,null,null,109375,12,1312500,null,null,136719,12,1640628,null,null,170898,12,2050776]
["Student Meals and Snack",null,null,250000,{"$f":"IFERROR(CHOOSE($B$4,E47,E109,E171),\"\")","v":12},3000000,null,null,500000,12,6000000,null,null,510000,12,6120000,null,null,520000,12,6240000,null,null,540000,12,6480000]
["Miscellenous",null,null,62500,{"$f":"IFERROR(CHOOSE($B$4,E48,E110,E172),\"\")","v":12},750000,null,null,125000,12,1500000,null,null,0,0,0,null,null,193313,12,2319756,null,null,202141,12,2425692]
[null,null,null,null,null,{"$f":"SUM(F225:F234)","v":11150000},null,null,null,null,{"$f":"SUM(K225:K234)","v":15950000},null,null,null,null,{"$f":"SUM(P225:P234)","v":15770000},null,null,null,null,{"$f":"SUM(U225:U234)","v":19287896},null,null,null,null,{"$f":"SUM(Z225:Z234)","v":21215840}]
[]
["Supplies &Legal Exp"]
["Legal Fee",null,{"$f":"IFERROR(CHOOSE($B$4,C52,C114,C176),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,D52,D114,D176),\"\")","v":0},0,200000,null,null,0,0,200000,null,null,0,0,200000,null,null,0,0,200000,null,null,0,0,200000]
["Supplies-Instructional",null,{"$f":"IFERROR(CHOOSE($B$4,C53,C115,C177),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,D53,D115,D177),\"\")","v":0},0,0,null,null,100000,12,1200000,null,null,80000,12,960000,null,null,80000,12,960000,null,null,70000,12,840000]
["Supplies-Administrative",null,{"$f":"IFERROR(CHOOSE($B$4,C54,C116,C178),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,D54,D116,D178),\"\")","v":0},0,0,null,null,100000,12,1200000,null,null,90000,12,1080000,null,null,90000,12,1080000,null,null,60000,12,720000]
["Supplies-General",null,{"$f":"IFERROR(CHOOSE($B$4,C55,C117,C179),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,D55,D117,D179),\"\")","v":0},0,0,null,null,100000,12,1200000,null,null,90000,12,1080000,null,null,90000,12,1080000,null,null,62000,12,744000]
["Printing & Advertising",null,{"$f":"IFERROR(CHOOSE($B$4,C56,C118,C180),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,D56,D118,D180),\"\")","v":100000},12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000,null,null,100000,12,1200000]
["Licences & Service charge",null,{"$f":"IFERROR(CHOOSE($B$4,C57,C119,C181),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,D57,D119,D181),\"\")","v":0},0,200000,null,null,0,0,200000,null,null,0,0,200000,null,null,0,0,200000,null,null,0,0,200000]
["Consultancy fees",null,{"$f":"IFERROR(CHOOSE($B$4,C58,C120,C182),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,D58,D120,D182),\"\")","v":0},0,200000,null,null,0,0,200000,null,null,0,0,200000,null,null,0,0,200000,null,null,0,0,200000]
["Maintenance and Repair",null,{"$f":"IFERROR(CHOOSE($B$4,C59,C121,C183),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,D59,D121,D183),\"\")","v":0},0,0,null,null,200000,12,2400000,null,null,100000,12,1200000,null,null,120000,12,1440000,null,null,100000,12,1200000]
["Insurance",null,{"$f":"IFERROR(CHOOSE($B$4,C60,C122,C184),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,D60,D122,D184),\"\")","v":0},0,100000,null,null,0,0,100000,null,null,0,0,100000,null,null,0,0,100000,null,null,0,0,100000]
[null,null,null,null,null,{"$f":"SUM(F238:F246)","v":1900000},null,null,null,null,{"$f":"SUM(K238:K246)","v":7900000},null,null,null,null,{"$f":"SUM(P239:P246)","v":6020000},null,null,null,null,{"$f":"SUM(U239:U246)","v":6260000},null,null,null,null,{"$f":"SUM(Z238:Z246)","v":5404000}]
["Finance Cost"]
["Start Up Loan(Long Term)",null,null,null,null,{"$f":"IFERROR(CHOOSE($B$4,F63,F125,F187),\"\")","v":53040000.000000007},{"$f":"IFERROR(CHOOSE($B$4,G63,G125,G187),\"\")","v":0},0,0,0,50671414.112210929,0,0,0,0,47900168.62349771,0,0,0,0,44657811.401703253,0,0,0,0,40864253.452203736]
["Short Term Loan",null,null,null,null,{"$f":"IFERROR(CHOOSE($B$4,F64,F126,F188),\"\")","v":0},{"$f":"IFERROR(CHOOSE($B$4,G64,G126,G188),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F249:F250)","v":53040000.000000007},null,null,null,null,{"$f":"SUM(K249:K250)","v":50671414.112210929},null,null,null,null,{"$f":"SUM(P249:P250)","v":47900168.62349771},null,null,null,null,{"$f":"SUM(U249:U250)","v":44657811.401703253},null,null,null,null,{"$f":"SUM(Z249:Z250)","v":40864253.452203736}]
[]
["Caution Money Refund",null,null,70000,5,{"$f":"D253*E253","v":350000},null,null,70000,10,{"$f":"I253*J253","v":700000},null,null,70000,15,{"$f":"N253*O253","v":1050000},null,null,70000,20,{"$f":"S253*T253","v":1400000},null,null,70000,25,{"$f":"X253*Y253","v":1750000}]
[]
["Income Statement"]
["Tax Rate @ 30%",0.3,"Year 1",null,null,null,null,"Year 2",null,null,null,null,"Year 3",null,null,null,null,"Year 4",null,null,null,null,"Year 5"]
[null,null,"Nursery","Junior","Senior","Consldt Stmt",null,"Nursery","Junior","Senior","Consldt Stmt",null,"Nursery","Junior","Senior","Consldt Stmt",null,"Nursery","Junior","Senior","Consldt Stmt",null,"Nursery","Junior","Senior","Consldt Stmt"]
["Tution Fee",null,{"$f":"C194","v":5831250},{"$f":"D194","v":17746500},40254000,{"$f":"F194","v":63831750},null,18805781.25,57232462.5,129819150,{"$f":"K194","v":205857393.75},null,33693691.40625,102541495.3125,232592643.75,368827830.46875,null,50709005.56640625,154324950.4453125,350051928.84375,555085884.85546875,null,70087089.836425781,213299127.93691406,483821773.08046871,767207990.85380864]
["Registration Fee",null,{"$f":"C195","v":1000000},{"$f":"D195","v":1500000},1750000,{"$f":"F195","v":4250000},null,3000000,4500000,5250000,12750000,null,5000000,7500000,8750000,21250000,null,7000000,10500000,12250000,29750000,null,9000000,13500000,15750000,38250000]
["Caution Fee-Refundable",null,{"$f":"C196","v":1400000},2100000,2450000,5950000,null,4200000,6300000,7350000,17850000,null,7000000,10500000,12250000,29750000,null,9800000,14700000,17150000,41650000,null,12600000,18900000,22050000,53550000]
["Capital Levy",null,3000000,4500000,5250000,12750000,null,9000000,13500000,15750000,38250000,null,15000000,22500000,26250000,63750000,null,21000000,31500000,36750000,89250000,null,27000000,40500000,47250000,114750000]
["Transport Fee",null,2520000,4185000,5355000,12060000,null,7560000,12555000,16065000,36180000,null,12600000,20925000,26775000,60300000,null,17640000,29295000,37485000,84420000,null,22680000,37665000,48195000,108540000]
["Lunch & Snacks Fee",null,1938000,3343500,4226250,9507750,null,5814000,10030500,12678750,28523250,null,9690000,16717500,21131250,47538750,null,13566000,23404500,29583750,66554250,null,17442000,30091500,38036250,85569750]
["Activity Fee",null,810000,2052000,3053250,5915250,null,2430000,6156000,9159750,17745750,null,4050000,10260000,15266250,29576250,null,5670000,14364000,21372750,41406750,null,7290000,18468000,27479250,53237250]
["Total Incomes",null,{"$f":"SUM(C258:C264)","v":16499250},{"$f":"SUM(D258:D264)","v":35427000},62338500,114264750,null,{"$f":"SUM(H258:H264)","v":50809781.25},{"$f":"SUM(I258:I264)","v":110273962.5},196072650,357156393.75,null,87033691.40625,190943995.3125,343015143.75,620992830.46875,null,125385005.56640625,278088450.4453125,504643428.84375,908116884.85546875,null,166099089.83642578,372423627.93691409,682582273.08046865,{"$f":"SUM(Z258:Z264)","v":1221104990.8538086}]
[]
["Expenses"]
["Salaries & Benefits",null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(F222, \" \"))","v":81051900},null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(K222, \" \"))","v":129462900},null,null,null,null,186731790,null,null,null,null,238343790.00000003,null,null,null,null,313018269.00000012]
["Utilities",null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(F235,\"\"))","v":11150000},null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(K235,\"\"))","v":15950000},null,null,null,null,15770000,null,null,null,null,19287896,null,null,null,null,21215840]
["Supplies & Legal Exp",null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(F247,\"\"))","v":1900000},null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(K247,\"\"))","v":7900000},null,null,null,null,6020000,null,null,null,null,6260000,null,null,null,null,5404000]
["Depriciation",null,null,null,null,{"$f":"SUM(F380:F385)","v":38725000},null,null,null,null,{"$f":"SUM(K380:K385)","v":38725000},null,null,null,null,{"$f":"SUM(P380:P385)","v":38725000},null,null,null,null,{"$f":"SUM(U380:U385)","v":44725000},null,null,null,null,{"$f":"SUM(Z380:Z385)","v":28800000}]
["Caution Money Refund",null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(F253,\"\"))","v":350000},null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(K253,\"\"))","v":700000},null,null,null,null,1050000,null,null,null,null,1400000,null,null,null,null,1750000]
[null,null,null,null,null,{"$f":"SUM(F268:F272)","v":133176900},null,null,null,null,{"$f":"SUM(K268:K272)","v":192737900},null,null,null,null,{"$f":"SUM(P268:P272)","v":248296790},null,null,null,null,{"$f":"SUM(U268:U272)","v":310016686},null,null,null,null,{"$f":"SUM(Z268:Z272)","v":370188109.00000012}]
["EBIT",null,null,null,null,{"$f":"IFERROR(F265-F273,\"\")","v":-18912150},null,null,null,null,{"$f":"IFERROR(K265-K273,\"\")","v":164418493.75},null,null,null,null,372696040.46875,null,null,null,null,598100198.85546875,null,null,null,null,850916881.85380852]
[]
["Finance Cost",null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(F251,\"\"))","v":53040000.000000007},null,null,null,null,{"$f":"IF(OR($B$4=\"\",$B$4=0),\"\",IFERROR(K251,\"\"))","v":50671414.112210929},null,null,null,null,47900168.62349771,null,null,null,null,44657811.401703253,null,null,null,null,40864253.452203736]
["EBT",null,null,null,null,{"$f":"IFERROR(F274-F276,0)","v":-71952150},null,null,null,null,{"$f":"IFERROR(K274-K276,0)","v":113747079.63778907},null,null,null,null,{"$f":"IFERROR(P274-P276,0)","v":324795871.84525228},null,null,null,null,{"$f":"IFERROR(U274-U276,0)","v":553442387.45376551},null,null,null,null,{"$f":"IFERROR(Z274-Z276,0)","v":810052628.40160477}]
[]
["Tax @ 30%",null,null,null,null,{"$f":"IFERROR(_xlfn.IFNA(IF(F277<=0,0,F277*$B$256),0),0)","v":0},null,null,null,null,{"$f":"IFERROR(_xlfn.IFNA(IF(K277<=0,0,K277*$B$256),0),0)","v":34124123.891336717},null,null,null,null,{"$f":"IFERROR(_xlfn.IFNA(IF(P277<=0,0,P277*$B$256),0),0)","v":97438761.55357568},null,null,null,null,{"$f":"IFERROR(_xlfn.IFNA(IF(U277<=0,0,U277*$B$256),0),0)","v":166032716.23612964},null,null,null,null,{"$f":"IFERROR(_xlfn.IFNA(IF(Z277<=0,0,Z277*$B$256),0),0)","v":243015788.52048141}]
["EAT",null,null,null,null,{"$f":"IFERROR(_xlfn.IFNA(F277-F279,0),0)","v":-71952150},null,null,null,null,{"$f":"IFERROR(_xlfn.IFNA(K277-K279,0),0)","v":79622955.746452361},null,null,null,null,227357110.29167658,null,null,null,null,387409671.21763587,null,null,null,null,567036839.8811233]
[]
["Net Earning/Losses",null,null,null,null,{"$f":"IFERROR(_xlfn.IFNA(F280,0),0)","v":-71952150},null,null,null,null,{"$f":"IFERROR(_xlfn.IFNA(K280,0),0)","v":79622955.746452361},null,null,null,null,227357110.29167658,null,null,null,null,387409671.21763587,null,null,null,null,567036839.8811233]
[]
[]
["Balance Sheet"]
[]
["Non-Current Assets"]
["Software,Webhosting & Installation",null,null,null,null,{"$f":"IFERROR(IF((F359+F366-F373-F380)<=0,0,F359+F366-F373-F380),0)","v":525000},null,null,null,null,{"$f":"IFERROR(IF((F288+K366)-K380<0,0,(F288+K366)-K380),0)","v":350000},null,null,null,null,{"$f":"IFERROR(IF((K288+P366)-P380<=0,0,(K288+P366)-P380),0)","v":175000},null,null,null,null,{"$f":"IFERROR(IF((P288+U366)-U380<=0,0,(P288+U366)-U380),0)","v":0},null,null,null,null,{"$f":"IFERROR(IF((U288+Z366)-Z380<=0,0,(U288+Z366)-Z380),0)","v":0}]
["Laboratory equipment and machines",null,null,null,null,{"$f":"IFERROR(IF((F364+F371-F378-F385)<=0,0,F364+F371-F378-F385),0)","v":4500000},null,null,null,null,{"$f":"IFERROR(IF((F289+K371)-K385<=0,0,(F289+K371)-K385),0)","v":4000000},null,null,null,null,{"$f":"IFERROR(IF((K289+P371)-P385<=0,0,(K289+P371)-P385),0)","v":3500000},null,null,null,null,{"$f":"IFERROR(IF((P289+U371)-U385<=0,0,(P289+U371)-U385),0)","v":3000000},null,null,null,null,{"$f":"IFERROR(IF((U289+Z371)-Z385<=0,0,(U289+Z371)-Z385),0)","v":2500000}]
["Computers and accessories ",null,null,null,null,{"$f":"IFERROR(IF((F360+F367-F374-F381)<=0,0,F360+F367-F374-F381),0)","v":5250000},null,null,null,null,{"$f":"IFERROR(IF((F290+K374)-K381<=0,0,(F290+K374)-K381),0)","v":3500000},null,null,null,null,{"$f":"IFERROR(IF((K290+P374)-P381<=0,0,(K290+P374)-P381),0)","v":1750000},null,null,null,null,{"$f":"IFERROR(IF((P290+U374)-U381<=0,0,(P290+U374)-U381),0)","v":0},null,null,null,null,{"$f":"IFERROR(IF((U290+Z374)-Z381<=0,0,(U290+Z374)-Z381),0)","v":0}]
["School Buses",null,null,null,null,{"$f":"IFERROR(IF((F361+F368-F375-F382)<0,0,F361+F368-F375-F382),0)","v":24000000},null,null,null,null,{"$f":"IFERROR(IF((F291+K368)-K382<=0,0,(F291+K368)-K382),0)","v":16000000},null,null,null,null,{"$f":"IFERROR(IF((K291+P368)-P382<=0,0,(K291+P368)-P382),0)","v":8000000},null,null,null,null,{"$f":"IFERROR(IF((P291+U368)-U382<=0,0,(P291+U368)-U382),0)","v":18000000},null,null,null,null,{"$f":"IFERROR(IF((U291+Z368)-Z382<=0,0,(U291+Z368)-Z382),0)","v":18000000}]
["Land and Buildings ",null,null,null,null,{"$f":"IFERROR(IF((F362+F369-F376-F383)<=0,0,F362+F369-F376-F383),0)","v":252000000},null,null,null,null,{"$f":"IFERROR(IF((F292+K369)-K383<=0,0,(F292+K369)-K383),0)","v":224000000},null,null,null,null,{"$f":"IFERROR(IF((K292+P369)-P383<=0,0,(K292+P369)-P383),0)","v":196000000},null,null,null,null,{"$f":"IFERROR(IF((P292+U369)-U383<=0,0,(P292+U369)-U383),0)","v":168000000},null,null,null,null,{"$f":"IFERROR(IF((U292+Z369)-Z383<=0,0,(U292+Z369)-Z383),0)","v":140000000}]
["Furniture, Fixtures and Fittings",null,null,null,null,{"$f":"IFERROR(IF((F363+F370-F377-F384)<=0,0,F363+F370-F377-F384),0)","v":2700000},null,null,null,null,{"$f":"IFERROR(IF((F293+K370)-K384<=0,0,(F293+K370)-K384),0)","v":2400000},null,null,null,null,{"$f":"IFERROR(IF((K293+P370)-P384<=0,0,(K293+P370)-P384),0)","v":2100000},null,null,null,null,{"$f":"IFERROR(IF((P293+U370)-U384<=0,0,(P293+U370)-U384),0)","v":1800000},null,null,null,null,{"$f":"IFERROR(IF((U293+Z370)-Z384<=0,0,(U293+Z370)-Z384),0)","v":1500000}]
["Total Fixed Assets",null,null,null,null,{"$f":"SUM(F288:F293)","v":288975000},null,null,null,null,{"$f":"SUM(K288:K293)","v":250250000},null,null,null,null,{"$f":"SUM(P288:P293)","v":211525000},null,null,null,null,{"$f":"SUM(U288:U293)","v":190800000},null,null,null,null,{"$f":"SUM(Z288:Z293)","v":162000000}]
[]
["Current Assets"]
["Cash & Bank",null,null,null,null,{"$f":"IFERROR(IF(F346>=0,F346,\"\"),\"\")","v":1014401.8365348577},null,null,null,null,{"$f":"IFERROR(IF(K346>=0,K346,\"\"),\"\")","v":71760864.156733006},null,null,null,null,{"$f":"IFERROR(IF(P346>=0,P346,\"\"),\"\")","v":292350641.23656714},null,null,null,null,{"$f":"IFERROR(IF(U346>=0,U346,\"\"),\"\")","v":650161439.45376921},null,null,null,null,{"$f":"IFERROR(IF(Z346>=0,Z346,\"\"),\"\")","v":1188976452.8237972}]
["Acc Recivable",null,null,null,null,{"$f":"F390","v":4570590},null,null,null,null,{"$f":"K390","v":35715639.375},null,null,null,null,{"$f":"P390","v":62099283.046875},null,null,null,null,{"$f":"U390","v":90811688.485546887},null,null,null,null,{"$f":"Z390","v":122110499.08538087}]
["Total Current Asset",null,null,null,null,{"$f":"SUM(F297:F298)","v":5584991.8365348577},null,null,null,null,{"$f":"SUM(K297:K298)","v":107476503.53173301},null,null,null,null,354449924.28344214,null,null,null,null,740973127.93931603,null,null,null,null,1311086951.909178]
["Total Assets",null,null,null,null,{"$f":"F299+F294","v":294559991.83653486},null,null,null,null,{"$f":"K299+K294","v":357726503.53173304},null,null,null,null,565974924.28344214,null,null,null,null,931773127.93931603,null,null,null,null,1473086951.909178]
[]
["Capital & Liabiliteis"]
["Share Capital(10Ksh per share 10000)",null,null,null,null,100000,null,null,null,null,{"$f":"F306","v":-6852150},null,null,null,null,{"$f":"K306","v":72770805.746452361},null,null,null,null,{"$f":"P306","v":300127916.03812897},null,null,null,null,687537587.25576484]
["Capital Injection",null,null,null,null,{"$f":"F337","v":65000000}]
["Retained Earnings",null,null,null,null,{"$f":"F282","v":-71952150},0,0,0,0,79622955.746452361,0,0,0,0,227357110.29167658,0,0,0,0,387409671.21763587,0,0,0,0,567036839.8811233]
["Total Share Capital",null,null,null,null,{"$f":"SUM(F303:F305)","v":-6852150},null,null,null,null,{"$f":"SUM(K303:K305)","v":72770805.746452361},null,null,null,null,300127916.03812897,null,null,null,null,687537587.25576484,null,null,null,null,1254574427.136888]
[]
["Non-Current Liabiliteis"]
["Long Term Obligation 17%",null,null,null,null,{"$f":"'Source Data'!H285","v":281765697.78528064},null,null,null,null,{"$f":"'Source Data'!H286","v":262693008.24531323},null,null,null,null,{"$f":"'Source Data'!H287","v":240377961.48355135},null,null,null,null,{"$f":"'Source Data'!H288","v":214269356.77228996},null,null,null,null,{"$f":"'Source Data'!H289","v":183722289.26011413}]
[]
[]
["Total Non-Current Liabilities",null,null,null,null,{"$f":"SUM(F309:F311)","v":281765697.78528064},null,null,null,null,{"$f":"SUM(K309:K311)","v":262693008.24531323},null,null,null,null,240377961.48355135,null,null,null,null,214269356.77228996,null,null,null,null,183722289.26011413]
[]
["Current Liabilities"]
["Extra Short Finance(Eg.BOD)",null,null,null,null,{"$f":"IFERROR(IF(F346<0,F346*-1,\"\"),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(K346<0,K346*-1,\"\"),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(P346<0,P346*-1,\"\"),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(U346<0,U346*-1,\"\"),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(Z346<0,Z346*-1,\"\"),\"\")","v":""}]
["Short Term Obligation(17%)",null,null,null,null,{"$f":"'Source Data'!G285","v":16301444.051254205},null,null,null,null,{"$f":"'Source Data'!G286","v":19072689.539967425},null,null,null,null,{"$f":"'Source Data'!G287","v":22315046.761761881},null,null,null,null,{"$f":"'Source Data'!G288","v":26108604.711261399},null,null,null,null,{"$f":"'Source Data'!G289","v":30547067.512175836}]
["Acc Payable",null,null,null,null,{"$f":"F391","v":3345000},null,null,null,null,{"$f":"K391","v":3190000},null,null,null,null,{"$f":"P391","v":3154000},null,null,null,null,{"$f":"U391","v":3857579.2},null,null,null,null,{"$f":"Z391","v":4243168}]
["Total Current Liabilities",null,null,null,null,{"$f":"SUM(F315:F317)","v":19646444.051254205},null,null,null,null,{"$f":"SUM(K315:K317)","v":22262689.539967425},null,null,null,null,{"$f":"SUM(P315:P317)","v":25469046.761761881},null,null,null,null,{"$f":"SUM(U315:U317)","v":29966183.911261398},null,null,null,null,{"$f":"SUM(Z315:Z317)","v":34790235.512175836}]
["Total Capital & Liabilities",null,null,null,null,{"$f":"F318+F312+F306","v":294559991.83653486},null,null,null,null,{"$f":"K318+K312+K306","v":357726503.53173304},null,null,null,null,{"$f":"P318+P312+P306","v":565974924.28344226},null,null,null,null,{"$f":"U318+U312+U306","v":931773127.93931627},null,null,null,null,{"$f":"Z318+Z312+Z306","v":1473086951.909178}]
[null,null,null,null,null,{"$f":"F319-F300","v":0},null,null,null,null,{"$f":"K300-K319","v":0},null,null,null,null,{"$f":"P300-P319","v":0},null,null,null,null,{"$f":"U300-U319","v":0},null,null,null,null,{"$f":"Z300-Z319","v":0}]
[]
["Cash Flow Statement"]
["Operating Cash Flow"]
["Net Earnings:Plus",null,null,null,null,{"$f":"F282","v":-71952150},null,null,null,null,{"$f":"K282","v":79622955.746452361},null,null,null,null,{"$f":"P282","v":227357110.29167658},null,null,null,null,{"$f":"U282","v":387409671.21763587},null,null,null,null,{"$f":"Z282","v":567036839.8811233}]
["Depriciation & Armotization",null,null,null,null,{"$f":"F271","v":38725000},null,null,null,null,{"$f":"K271","v":38725000},null,null,null,null,{"$f":"P271","v":38725000},null,null,null,null,{"$f":"U271","v":44725000},null,null,null,null,{"$f":"Z271","v":28800000}]
["Finance Cost",null,null,null,null,{"$f":"F276","v":53040000.000000007},null,null,null,null,{"$f":"K276","v":50671414.112210929},null,null,null,null,{"$f":"P276","v":47900168.62349771},null,null,null,null,{"$f":"U276","v":44657811.401703253},null,null,null,null,{"$f":"Z276","v":40864253.452203736}]
["Change In Woring Capital",null,null,null,null,{"$f":"F354","v":-1225590},null,null,null,null,{"$f":"K354","v":-31300049.375},null,null,null,null,-26419643.671875,null,null,null,null,-28008826.238671888,null,null,null,null,-30913221.799833979]
["Cash From/Used In Operating Activities",null,null,null,null,{"$f":"SUM(F324:F327)","v":18587260.000000007},null,null,null,null,{"$f":"SUM(K324:K327)","v":137719320.48366329},null,null,null,null,{"$f":"SUM(P324:P327)","v":287562635.24329931},null,null,null,null,{"$f":"SUM(U324:U327)","v":448783656.38066721},null,null,null,null,{"$f":"SUM(Z324:Z327)","v":605787871.53349304},{"$f":"K319=K300","v":true}]
[]
["Investing Cash Flow"]
["Purchase of PPE",null,null,null,null,{"$f":"-(F366+F367+F370+F371+F369+F368)","v":-327700000},null,null,null,null,{"$f":"-(K366+K367+K370+K371+K369+K368)","v":0},null,null,null,null,{"$f":"-(P366+P367+P370+P371+P369+P368)","v":0},null,null,null,null,{"$f":"-(U366+U367+U370+U371+U369+U368)","v":-24000000},null,null,null,null,{"$f":"-(Z366+Z367+Z370+Z371+Z369+Z368)","v":0}]
["Sale of PPE",null,null,null,null,{"$f":"F387","v":0},null,null,null,null,{"$f":"K387","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["Cash From/Used In Investing Activities",null,null,null,null,{"$f":"SUM(F331:F332)","v":-327700000},null,null,null,null,{"$f":"SUM(K331:K332)","v":0},null,null,null,null,0,null,null,null,null,-24000000,null,null,null,null,0]
[]
["Financing Cash Flow"]
["Ordinary Share",null,null,null,null,{"$f":"F389","v":100000}]
["Capital Injection",null,null,null,null,65000000]
["Loan Recived",null,null,null,null,{"$f":"'Source Data'!B283","v":312000000}]
["Loan Repayment",null,null,null,null,{"$f":"-'Source Data'!E284","v":-66972858.163465135},null,null,null,null,{"$f":"-'Source Data'!E285","v":-66972858.163465135},null,null,null,null,{"$f":"-'Source Data'!E286","v":-66972858.163465135},null,null,null,null,{"$f":"-'Source Data'!E287","v":-66972858.163465135},null,null,null,null,{"$f":"-'Source Data'!E288","v":-66972858.163465135}]
[]
[]
["Cash From/Used In Financing Activities",null,null,null,null,{"$f":"SUM(F336:F341)","v":310127141.83653486},null,null,null,null,{"$f":"SUM(K336:K341)","v":-66972858.163465135},null,null,null,null,{"$f":"SUM(P336:P341)","v":-66972858.163465135},null,null,null,null,{"$f":"SUM(U336:U341)","v":-66972858.163465135},null,null,null,null,{"$f":"SUM(Z336:Z341)","v":-66972858.163465135}]
[]
["Net Increase (Decrease) in Cash",null,null,null,null,{"$f":"F328+F333+F342","v":1014401.8365348577},null,null,null,null,{"$f":"K328+K333+K342","v":70746462.320198148},null,null,null,null,{"$f":"P328+P333+P342","v":220589777.07983416},null,null,null,null,357810798.21720207,null,null,null,null,538815013.3700279]
["Opening Balance",null,null,null,null,null,null,null,null,null,{"$f":"F346","v":1014401.8365348577},null,null,null,null,{"$f":"K346","v":71760864.156733006},null,null,null,null,292350641.23656714,null,null,null,null,650161439.45376921]
["Closing Cash Balance",null,null,null,null,{"$f":"SUM(F344:F345)","v":1014401.8365348577},null,null,null,null,{"$f":"SUM(K344:K345)","v":71760864.156733006},null,null,null,null,{"$f":"SUM(P344:P345)","v":292350641.23656714},null,null,null,null,650161439.45376921,null,null,null,null,1188976452.8237972]
[]
[]
["Supporting Schedules"]
["Working Capital Schedule"]
["Acc Receivable",null,null,null,null,{"$f":"-F298","v":-4570590},null,null,null,null,{"$f":"(K298-F298)*-1","v":-31145049.375},null,null,null,null,{"$f":"(P298-K298)*-1","v":-26383643.671875},null,null,null,null,{"$f":"(U298-P298)*-1","v":-28712405.438671887},null,null,null,null,{"$f":"(Z298-U298)*-1","v":-31298810.59983398}]
["Inventory"]
["Acc Payables",null,null,null,null,{"$f":"F317","v":3345000},null,null,null,null,{"$f":"K317-F317","v":-155000},null,null,null,null,{"$f":"P317-K317","v":-36000},null,null,null,null,{"$f":"U317-P317","v":703579.20000000019},null,null,null,null,{"$f":"Z317-U317","v":385588.79999999981}]
["Net Working Capital(WAC)",null,null,null,null,{"$f":"SUM(F351:F353)","v":-1225590},null,null,null,null,{"$f":"SUM(K351:K353)","v":-31300049.375},null,null,null,null,{"$f":"SUM(P351:P353)","v":-26419643.671875},null,null,null,null,{"$f":"SUM(U351:U353)","v":-28008826.238671888},null,null,null,null,{"$f":"SUM(Z351:Z353)","v":-30913221.799833979}]
["Change in WAC"]
["Capital Allowance Rates",0.5,null,null,null,0.25,0.1]
["Depriciation Shcedule"]
["PPP Opening Balance"]
["Software,Webhosting & Installation",null,null,null,null,null,null,null,null,null,700000,null,null,null,null,700000,null,null,null,null,700000,null,null,null,null,700000]
["Computers and accessories ",null,null,null,null,null,null,null,null,null,7000000,null,null,null,null,7000000,null,null,null,null,7000000]
["School Buses",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(B4=2,'Source Data'!B292,'Source Data'!B291),0)","v":32000000},null,null,null,null,{"$f":"IFERROR(IF(B4=2,'Source Data'!B292,'Source Data'!B291),0)","v":32000000},null,null,null,null,{"$f":"IFERROR(IF(B4=2,'Source Data'!B292,'Source Data'!B291),0)","v":32000000}]
["Land and Buildings ",null,null,null,null,null,null,null,null,null,280000000,null,null,null,null,280000000,null,null,null,null,280000000,null,null,null,null,280000000]
["Furniture, Fixtures and Fittings",null,null,null,null,null,null,null,null,null,3000000,null,null,null,null,3000000,null,null,null,null,3000000,null,null,null,null,3000000]
["Laboratory equipment and machines",null,null,null,null,null,null,null,null,null,5000000,null,null,null,null,5000000,null,null,null,null,5000000,null,null,null,null,5000000]
["Plus Capex"]
["Software,Webhosting & Installation",null,null,null,null,700000]
["Computers and accessories ",null,null,null,null,7000000]
["School Buses",null,null,null,null,{"$f":"IFERROR(IF(B4=2,'Source Data'!B292,'Source Data'!B291),0)","v":32000000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Source Data'!B288*3","v":24000000}]
["Land and Buildings ",null,null,null,null,280000000]
["Furniture, Fixtures and Fittings",null,null,null,null,3000000]
["Laboratory equipment and machines",null,null,null,null,5000000]
["Disposal"]
["Software,Webhosting & Installation"]
["Computers and accessories "]
["School Buses"]
["Land and Buildings "]
["Furniture, Fixtures and Fittings"]
["Laboratory equipment and machines"]
["Less:Deprication"]
["Software,Webhosting & Installation",null,null,null,null,{"$f":"(SUM(F359,F366)-F373)*$F$356","v":175000},null,null,null,null,{"$f":"(SUM(K359,K366)-K373)*$F$356","v":175000},null,null,null,null,{"$f":"(SUM(P359,P366)-P373)*$F$356","v":175000},null,null,null,null,{"$f":"(SUM(U359,U366)-U373)*$F$356","v":175000}]
["Computers and accessories ",null,null,null,null,{"$f":"(SUM(F360,F367)-F374)*$F$356","v":1750000},null,null,null,null,{"$f":"(SUM(K360,K367)-K374)*$F$356","v":1750000},null,null,null,null,{"$f":"(SUM(P360,P367)-P374)*$F$356","v":1750000},null,null,null,null,{"$f":"(SUM(U360,U367)-U374)*$F$356","v":1750000},null,null,null,null,{"$f":"(SUM(Z360,Z367)-Z374)*$F$356","v":0}]
["School Buses",null,null,null,null,{"$f":"(SUM(F361,F368)-F375)*$F$356","v":8000000},null,null,null,null,{"$f":"(SUM(K361,K368)-K375)*$F$356","v":8000000},null,null,null,null,{"$f":"(SUM(P361,P368)-P375)*$F$356","v":8000000},null,null,null,null,{"$f":"(SUM(U361,U368)-U375)*$F$356","v":14000000},null,null,null,null,{"$f":"(SUM(Z361,Z368)-Z375)*$F$356","v":0}]
["Land and Buildings ",null,null,null,null,{"$f":"(SUM(F362,F369)-F376)*$G$356","v":28000000},null,null,null,null,{"$f":"(SUM(K362,K369)-K376)*$G$356","v":28000000},null,null,null,null,{"$f":"(SUM(P362,P369)-P376)*$G$356","v":28000000},null,null,null,null,{"$f":"(SUM(U362,U369)-U376)*$G$356","v":28000000},null,null,null,null,{"$f":"(SUM(Z362,Z369)-Z376)*$G$356","v":28000000}]
["Furniture, Fixtures and Fittings",null,null,null,null,{"$f":"(SUM(F363,F370)-F377)*$G$356","v":300000},null,null,null,null,{"$f":"(SUM(K363,K370)-K377)*$G$356","v":300000},null,null,null,null,{"$f":"(SUM(P363,P370)-P377)*$G$356","v":300000},null,null,null,null,{"$f":"(SUM(U363,U370)-U377)*$G$356","v":300000},null,null,null,null,{"$f":"(SUM(Z363,Z370)-Z377)*$G$356","v":300000}]
["Laboratory equipment and machines",null,null,null,null,{"$f":"(SUM(F364,F371)-F378)*$G$356","v":500000},null,null,null,null,{"$f":"(SUM(K364,K371)-K378)*$G$356","v":500000},null,null,null,null,{"$f":"(SUM(P364,P371)-P378)*$G$356","v":500000},null,null,null,null,{"$f":"(SUM(U364,U371)-U378)*$G$356","v":500000},null,null,null,null,{"$f":"(SUM(Z364,Z371)-Z378)*$G$356","v":500000}]
["PPE Closing",null,null,null,null,{"$f":"SUM(F359:F364)+SUM(F366:F371)-SUM(F373:F378)-SUM(F380:F385)","v":288975000},null,null,null,null,{"$f":"SUM(K359:K364)+SUM(K366:K371)-SUM(K373:K378)-SUM(K380:K385)","v":288975000},null,null,null,null,{"$f":"SUM(P359:P364)+SUM(P366:P371)-SUM(P373:P378)-SUM(P380:P385)","v":288975000},null,null,null,null,{"$f":"SUM(U359:U364)+SUM(U366:U371)-SUM(U373:U378)-SUM(U380:U385)","v":306975000},null,null,null,null,{"$f":"SUM(Z359:Z364)+SUM(Z366:Z371)-SUM(Z373:Z378)-SUM(Z380:Z385)","v":259900000}]
["PPE Proceeds"]
[]
["Share Capital ",null,null,null,null,100000]
["Acc Receivable (4% - 10% in Perpetuity)",null,null,null,null,{"$f":"F265*0.04","v":4570590},null,null,null,null,{"$f":"K265*0.1","v":35715639.375},null,null,null,null,{"$f":"P265*0.1","v":62099283.046875},null,null,null,null,{"$f":"U265*0.1","v":90811688.485546887},null,null,null,null,{"$f":"Z265*0.1","v":122110499.08538087}]
["Acc Payables (30% - 20% in Perpetuity)",null,null,null,null,{"$f":"F269*0.3","v":3345000},null,null,null,null,{"$f":"K269*0.2","v":3190000},null,null,null,null,{"$f":"P269*0.2","v":3154000},null,null,null,null,{"$f":"U269*0.2","v":3857579.2},null,null,null,null,{"$f":"Z269*0.2","v":4243168}]
[]
[]
["DCF Model"]
[]
["Assumptions"]
["Tax Rate",0.3]
["Disccount Rate",{"$f":"E409","v":0.11571996817820207}]
["Transaction Date",{"$f":"B415","v":"2023-12-31"}]
["Fiscal Year End",{"$f":"C415","v":"2024-12-31"}]
["Current Share Price",10]
["Shares Outstanding",15000000]
["Perpetueal Growth Rate",{"$f":"IFERROR(_xlfn.IFNA(IF(B4=1,0.05-0.015,IF(B4=2,0.075-0.015,0.025-0.005)),\"\"),\"\")","v":0.06},"Discouunted Cashflow Method(Free Cashflow to the firm Model)"]
[]
[]
[]
["WACC"]
["Source","Amount","Propotion","Cost","WACC"]
["Ordinary Shares(10 Ksh par share)",{"$f":"F303+F304","v":65100000},{"$f":"B409/$B$411","v":0.17263325377883851},0.1,{"$f":"IFERROR(SUMPRODUCT(C409:C410,D409:D410),\"\")","v":0.11571996817820207}]
["17% Long Term Loan",{"$f":"'Source Data'!B283","v":312000000},{"$f":"B410/$B$411","v":0.82736674622116146},0.11899999999999999]
[null,{"$f":"SUM(B409:B410)","v":377100000},{"$f":"SUM(C409:C410)","v":1},{"$f":"SUM(D409:D410)","v":0.219}]
[]
[]
["Discounted Cash Flow","Entry",2024,{"$f":"C414+1","v":2025},{"$f":"D414+1","v":2026},2027,2028,"Exit",null,"Terminal Value"]
["Date",{"$f":"DATE(YEAR(TODAY()),12,31)","v":"2023-12-31"},{"$f":"DATE(YEAR(B415)+1,12,31)","v":"2024-12-31"},{"$f":"DATE(YEAR(C415)+1,12,31)","v":"2025-12-31"},"2026-12-31","2027-12-31","2028-12-31","2029-12-31",null,"Perpetueal Growth",{"$f":"(G428*(1+B403))","v":224521111.51206675}]
["Time Period",null,1,2,3,4,5,null,null,"WACC -g",{"$f":"B398-B403","v":5.5719968178202073E-2}]
["Year Fraction",null,{"$f":"IFERROR(YEARFRAC(B415,C415),\"\")","v":1},{"$f":"IFERROR(YEARFRAC(C415,D415),\"\")","v":1},1,1,1,null,null,null,{"$f":"K415/K416","v":4029455128.0792103}]
[]
["EBIT",null,{"$f":"F282","v":-71952150},{"$f":"K282","v":79622955.746452361},{"$f":"P282","v":227357110.29167658},{"$f":"U282","v":387409671.21763587},{"$f":"Z282","v":567036839.8811233}]
["Interest",null,{"$f":"F276","v":53040000.000000007},{"$f":"K276","v":50671414.112210929},{"$f":"P276","v":47900168.62349771},{"$f":"U276","v":44657811.401703253},{"$f":"Z276","v":40864253.452203736},null,null,"Intrinsic Value"]
["EBT",null,{"$f":"IFERROR(IF(C419<=0,C419-C420,C419-C420),\"\")","v":-124992150},{"$f":"IFERROR(IF(D419<=0,D419-D420,D419-D420),\"\")","v":28951541.634241432},179456941.66817886,342751859.81593263,526172586.42891955,null,null,"Enterprice Value",{"$f":"B431","v":1811084769.5967145}]
["Less: tax @ 30%",null,{"$f":"IFERROR(IF(C421<=0,C421*-0.3,C421*-0.3),0)","v":37497645},{"$f":"IFERROR(IF(D421<=0,D421*-0.3,D421*-0.3),0)","v":-8685462.4902724288},{"$f":"IFERROR(IF(E421<=0,E421*-0.3,E421*-0.3),0)","v":-53837082.500453658},{"$f":"IFERROR(IF(F421<=0,F421*-0.3,F421*-0.3),0)","v":-102825557.94477978},{"$f":"IFERROR(IF(G421<=0,G421*-0.3,G421*-0.3),0)","v":-157851775.92867586},null," ","Cash",{"$f":"Z297","v":1188976452.8237972}]
["Plus:Depriciation",null,{"$f":"F271","v":38725000},{"$f":"K271","v":38725000},{"$f":"P271","v":38725000},{"$f":"U271","v":44725000},{"$f":"Z271","v":28800000},null,null,"Debt",{"$f":"-B410","v":-312000000}]
["Less Capex",null,{"$f":"-SUM(F366:F371)","v":-327700000},{"$f":"-SUM(K366:K371)","v":0},{"$f":"-SUM(P366:P371)","v":0},{"$f":"-SUM(U366:U371)","v":-24000000},{"$f":"-SUM(Z366:Z371)","v":0},null,null,null,{"$f":"SUM(K421:K423)","v":2688061222.4205117}]
["Less CPanges in NWC",null,{"$f":"F354","v":-1225590},{"$f":"K354","v":-31300049.375},{"$f":"P354","v":-26419643.671875},{"$f":"U354","v":-28008826.238671888},{"$f":"Z354","v":-30913221.799833979}]
["Unleverd FCF",null,{"$f":"SUM(C421:C425)","v":-377695095},{"$f":"SUM(D421:D425)","v":27691029.768968999},137925215.49585021,232642475.63248098,366207588.70040971]
["(Entry)Exit",{"$f":"(F309+F303)*-1","v":-281865697.78528064},null,null,null,null,null,{"$f":"K417","v":4029455128.0792103}]
["Net FCF",{"$f":"B427","v":-281865697.78528064},{"$f":"-IFERROR(PV($B$398,C416,1,C426),\"\")","v":-338521407.49682707},{"$f":"-IFERROR(PV($B$398,D416,1,D426),\"\")","v":22244811.408514466},99306588.89097099,150130246.08582726,211812369.35100636,{"$f":"SUM(H427)","v":4029455128.0792103}]
[]
["Analysis",0.14000000000000001]
["NPV",{"$f":"XNPV(B398,B428:H428,B415:H415)","v":1811084769.5967145}," If the NPV+ is positieve then the project is viable"]
["IRR",{"$f":"XIRR(B428:H428,B415:H415,B430)","v":0.46490136981010433},"If the IRR is equal to or more than WACC/Enteprise Cost of Capital then the Project is Vialble"]
["Share Price at year 5",{"$f":"K424/(B409/10)","v":412.91263017212162},"Based on intrinsic Value of the firm at the 5th Year"]
[]
["Charts And Graphs"]
[]
[null,null,{"$f":"C414","v":2024},{"$f":"D414","v":2025},{"$f":"E414","v":2026},{"$f":"F414","v":2027},{"$f":"G414","v":2028}]
[null,null,{"$f":"C428","v":-338521407.49682707},{"$f":"D428","v":22244811.408514466},{"$f":"E428","v":99306588.89097099},{"$f":"F428","v":150130246.08582726},{"$f":"G428","v":211812369.35100636}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sensitivity Analysis"]
[]
[]
["Share Price Sensitivity Analysis"]
[null,null,"Revenue Growth"]
[null,{"$f":"B433","v":412.91263017212162},0,{"$f":"C464+0.025","v":2.5000000000000001E-2},{"$f":"D464+0.025","v":0.05},{"$f":"E464+0.025","v":7.5000000000000011E-2},{"$f":"F464+0.025","v":0.1}]
[null,0,237.90144351955902,237.90144351955902,237.90144351955902,237.90144351955902,237.90144351955902]
[null,{"$f":"B465+0.02","v":0.02},271.86028525588847,271.86028525588847,271.86028525588847,271.86028525588847,271.86028525588847]
["Perpetuity Growth",{"$f":"B466+0.015","v":3.5000000000000003E-2},308.37277566366322,308.37277566366322,308.37277566366322,308.37277566366322,308.37277566366322]
[null,{"$f":"B467+0.02","v":5.5000000000000007E-2},385.11797222858877,385.11797222858877,385.11797222858877,385.11797222858877,385.11797222858877]
[null,7.5000000000000011E-2,537.25143651422275,537.25143651422275,537.25143651422275,537.25143651422275,537.25143651422275]
[]
[]
[]
[]
[]
[]
[]
["Ratio Analysis"]
[]
["Profitability Ratios"]
["Return on Capital Employed(R.O.CE)",null,null,null,null,{"$f":"IFERROR(F274/(F306+F312),\"\")","v":-6.8793081142626E-2},null,null,null,null,{"$f":"IFERROR(K274/(K306+K312),\"\")","v":0.4901228892426408},null,null,null,null,0.68953189219260747,null,null,null,null,0.66322421092031658,null,null,null,null,0.59161428386306369]
["Return on Investment(R.O.I)",null,null,null,null,{"$f":"IFERROR(IF(AND(F282<0,F306<0),(F282/F306)*-1,F282/F306),\"\")","v":-10.500667673649877},null,null,null,null,{"$f":"IFERROR(IF(AND(K282<0,K306<0),(K282/K306)*-1,K282/K306),\"\")","v":1.094160699881134},null,null,null,null,{"$f":"IFERROR(IF(AND(P282<0,P306<0),(P282/P306)*-1,P282/P306),\"\")","v":0.75753403179860346},null,null,null,null,{"$f":"IFERROR(IF(AND(U282<0,U306<0),(U282/U306)*-1,U282/U306),\"\")","v":0.56347416984712284},null,null,null,null,{"$f":"IFERROR(IF(AND(Z282<0,Z306<0),(Z282/Z306)*-1,Z282/Z306),\"\")","v":0.4519754488979818}]
["Profit Margine",null,null,null,null,{"$f":"IFERROR(IF(AND(F277<0,F265<0),(F277/F265)*-1,F277/F265),\"\")","v":-0.62969682251087933},null,null,null,null,{"$f":"IFERROR(IF(AND(K277<0,K265<0),(K277/K265)*-1,K277/K265),\"\")","v":0.31847975180701654},null,null,null,null,{"$f":"IFERROR(IF(AND(P277<0,P265<0),(P277/P265)*-1,P277/P265),\"\")","v":0.52302676602575826},null,null,null,null,{"$f":"IFERROR(IF(AND(U277<0,U265<0),(U277/U265)*-1,U277/U265),\"\")","v":0.60943959602936859},null,null,null,null,{"$f":"IFERROR(IF(AND(Z277<0,Z265<0),(Z277/Z265)*-1,Z277/Z265),\"\")","v":0.66337672392544067}]
["Taxation to Sales",null,null,null,null,{"$f":"IFERROR(IF(AND(F279<0,F265<0),(F279/F265)*-1,F279/F265),\"\")","v":0},null,null,null,null,{"$f":"IFERROR(IF(AND(K279<0,K265<0),(K279/K265)*-1,K279/K265),\"\")","v":9.5543925542104946E-2},null,null,null,null,{"$f":"IFERROR(IF(AND(P279<0,P265<0),(P279/P265)*-1,P279/P265),\"\")","v":0.15690802980772747},null,null,null,null,{"$f":"IFERROR(IF(AND(U279<0,U265<0),(U279/U265)*-1,U279/U265),\"\")","v":0.18283187880881058},null,null,null,null,{"$f":"IFERROR(IF(AND(Z279<0,Z265<0),(Z279/Z265)*-1,Z279/Z265),\"\")","v":0.19901301717763217}]
[]
["Liquidity Ratio"]
["Current Ratio",null,null,null,null,{"$f":"IFERROR(IF(AND(F299<0,F318<0),(F299/F318)*-1,F299/F318),\"\")","v":0.28427494675191967},null,null,null,null,{"$f":"IFERROR(IF(AND(K299<0,K318<0),(K299/K318)*-1,K299/K318),\"\")","v":4.8276513643503947},null,null,null,null,{"$f":"IFERROR(IF(AND(P299<0,P318<0),(P299/P318)*-1,P299/P318),\"\")","v":13.916890082262436},null,null,null,null,{"$f":"IFERROR(IF(AND(U299<0,U318<0),(U299/U318)*-1,U299/U318),\"\")","v":24.726976585792617},null,null,null,null,{"$f":"IFERROR(IF(AND(Z299<0,Z318<0),(Z299/Z318)*-1,Z299/Z318),\"\")","v":37.685486534011126}]
["Quick Ratio",null,null,null,null,{"$f":"IFERROR(IF(AND(F299<0,F318<0),(F299/F318)*-1,F299/F318),\"\")","v":0.28427494675191967},null,null,null,null,{"$f":"IFERROR(IF(AND(K299<0,K318<0),(K299/K318)*-1,K299/K318),\"\")","v":4.8276513643503947},null,null,null,null,{"$f":"IFERROR(IF(AND(P299<0,P318<0),(P299/P318)*-1,P299/P318),\"\")","v":13.916890082262436},null,null,null,null,{"$f":"IFERROR(IF(AND(U299<0,U318<0),(U299/U318)*-1,U299/U318),\"\")","v":24.726976585792617},null,null,null,null,{"$f":"IFERROR(IF(AND(Z299<0,Z318<0),(Z299/Z318)*-1,Z299/Z318),\"\")","v":37.685486534011126}]
[]
["Activity/Efficiency Ratio"]
["Days Of  the Year",365]
[]
["Debtor Collection Period",null,null,null,null,{"$f":"IFERROR(((F298*$B$490)/F265),\"\")","v":14.6},null,null,null,null,{"$f":"IFERROR(((K298*$B$490)/K265),\"\")","v":36.5},null,null,null,null,{"$f":"IFERROR(((P298*$B$490)/P265),\"\")","v":36.5},null,null,null,null,{"$f":"IFERROR(((U298*$B$490)/U265),\"\")","v":36.500000000000007},null,null,null,null,{"$f":"IFERROR(((Z298*$B$490)/Z265),\"\")","v":36.5}]
["Creditor Payment Period",null,null,null,null,{"$f":"IFERROR(((F317*$B$490)/F269),\"\")","v":109.5},null,null,null,null,{"$f":"IFERROR(((K317*$B$490)/K269),\"\")","v":73},null,null,null,null,{"$f":"IFERROR(((P317*$B$490)/P269),\"\")","v":73},null,null,null,null,{"$f":"IFERROR(((U317*$B$490)/U269),\"\")","v":73},null,null,null,null,{"$f":"IFERROR(((Z317*$B$490)/Z269),\"\")","v":73}]
[]
["Leverage Ratio"]
["Debt to Equity Ratio",null,null,null,null,{"$f":"IFERROR(F312/F306,\"\")","v":-41.120771989124677},null,null,null,null,{"$f":"IFERROR(K312/K306,\"\")","v":3.6098680721027985},null,null,null,null,{"$f":"IFERROR(P312/P306,\"\")","v":0.80091837059573345},null,null,null,null,{"$f":"IFERROR(U312/U306,\"\")","v":0.31164748043452278},null,null,null,null,{"$f":"IFERROR(Z312/Z306,\"\")","v":0.14644192108984219}]
["Debt to Capital Employed",null,null,null,null,{"$f":"IFERROR((F312/(F306+F309)),\"\")","v":1.0249247447250283},null,null,null,null,{"$f":"IFERROR((K312/(K306+K309)),\"\")","v":0.78307405236786987},null,null,null,null,{"$f":"IFERROR((P312/(P306+P309)),\"\")","v":0.44472774761623107},null,null,null,null,{"$f":"IFERROR((U312/(U306+U309)),\"\")","v":0.23760002979709161},null,null,null,null,{"$f":"IFERROR((Z312/(Z306+Z309)),\"\")","v":0.12773601383193497}]
["Equity Ratio",null,null,null,null,{"$f":"IFERROR((F309+F306)/F306,\"\")","v":-40.120771989124677},null,null,null,null,{"$f":"IFERROR((K309+K306)/K306,\"\")","v":4.6098680721027989},null,null,null,null,{"$f":"IFERROR((P309+P306)/P306,\"\")","v":1.8009183705957335},null,null,null,null,{"$f":"IFERROR((U309+U306)/U306,\"\")","v":1.3116474804345228},null,null,null,null,{"$f":"IFERROR((Z309+Z306)/Z306,\"\")","v":1.1464419210898422}]
["Interest Coverage",null,null,null,null,{"$f":"IFERROR(F274/F276,\"\")","v":-0.35656391402714926},null,null,null,null,{"$f":"IFERROR(K274/K276,\"\")","v":3.2447978141264859},null,null,null,null,{"$f":"IFERROR(P274/P276,\"\")","v":7.7806832664451573},null,null,null,null,{"$f":"IFERROR(U274/U276,\"\")","v":13.392958142876145},null,null,null,null,{"$f":"IFERROR(Z274/Z276,\"\")","v":20.823013024061989}]
[]
["Shareholders Ratio"]
["Earning Per share",null,null,null,null,{"$f":"IFERROR((F282/10000),\"\")","v":-7195.2150000000001},null,null,null,null,{"$f":"IFERROR((K282/10000),\"\")","v":7962.2955746452362},null,null,null,null,{"$f":"IFERROR((P282/10000),\"\")","v":22735.711029167658},null,null,null,null,{"$f":"IFERROR((U282/10000),\"\")","v":38740.967121763584},null,null,null,null,{"$f":"IFERROR((Z282/10000),\"\")","v":56703.683988112331}]
["Dividend Payout Ratio",null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]