{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Input - Income","Input - Expenditure","General Assumptions"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":23,"defined_names":399,"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":"Summary","index":0,"n_rows":85,"n_cols":12,"rows_kept":85,"cut":false,"hidden":false,"merged":[[0,0,0,7],[14,9,15,9],[81,2,81,7],[52,2,52,7]]}
["Summary business case"]
[]
["All figures in £'000",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
[]
["Income"]
[]
["OFS Teaching Income",null,{"$f":"+'Input - Income'!C39+'Input - Income'!C72","v":0},{"$f":"+'Input - Income'!D39+'Input - Income'!D72","v":0},{"$f":"+'Input - Income'!E39+'Input - Income'!E72","v":0},{"$f":"+'Input - Income'!F39+'Input - Income'!F72","v":0},{"$f":"+'Input - Income'!G39+'Input - Income'!G72","v":0},{"$f":"+'Input - Income'!H39+'Input - Income'!H72","v":0}]
["Charity Support Funding",null,0,0,{"$f":"+SUM(B15:C15)/2*'General Assumptions'!B32","v":0},{"$f":"+SUM(C15:D15)/2*'General Assumptions'!C32","v":0},{"$f":"+SUM(D15:E15)/2*'General Assumptions'!C32","v":0},{"$f":"+SUM(E15:F15)/2*'General Assumptions'!D32","v":0},null,null,null,"Link"]
["RDP Funding",null,{"$f":"+'Input - Income'!C105","v":0},{"$f":"+'Input - Income'!D105","v":0},{"$f":"+'Input - Income'!E105","v":0},{"$f":"+'Input - Income'!F105","v":0},{"$f":"+'Input - Income'!G105","v":0},{"$f":"+'Input - Income'!H105","v":0},null,null,null,"Link"]
["UG Tuition fee income",null,{"$f":"+('Input - Income'!C11*'Input - Income'!C24)+'Input - Income'!C12*'Input - Income'!C36","v":0},{"$f":"+('Input - Income'!D11*'Input - Income'!D24)+'Input - Income'!D12*'Input - Income'!D36","v":0},{"$f":"+('Input - Income'!E11*'Input - Income'!E24)+'Input - Income'!E12*'Input - Income'!E36","v":0},{"$f":"+('Input - Income'!F11*'Input - Income'!F24)+'Input - Income'!F12*'Input - Income'!F36","v":0},{"$f":"+('Input - Income'!G11*'Input - Income'!G24)+'Input - Income'!G12*'Input - Income'!G36","v":0},{"$f":"+('Input - Income'!H11*'Input - Income'!H24)+'Input - Income'!H12*'Input - Income'!H36","v":0}]
["PGT Tuition fee income",null,{"$f":"+('Input - Income'!C58*'Input - Income'!C45)+('Input - Income'!C46*'Input - Income'!C70)","v":0},{"$f":"+('Input - Income'!D58*'Input - Income'!D45)+('Input - Income'!D46*'Input - Income'!D70)","v":0},{"$f":"+('Input - Income'!E58*'Input - Income'!E45)+('Input - Income'!E46*'Input - Income'!E70)","v":0},{"$f":"+('Input - Income'!F58*'Input - Income'!F45)+('Input - Income'!F46*'Input - Income'!F70)","v":0},{"$f":"+('Input - Income'!G58*'Input - Income'!G45)+('Input - Income'!G46*'Input - Income'!G70)","v":0},{"$f":"+('Input - Income'!H58*'Input - Income'!H45)+('Input - Income'!H46*'Input - Income'!H70)","v":0}]
["PGR Tuition fee income",null,{"$f":"+('Input - Income'!C78*'Input - Income'!C91)+('Input - Income'!C79*'Input - Income'!C103)","v":0},{"$f":"+('Input - Income'!D78*'Input - Income'!D91)+('Input - Income'!D79*'Input - Income'!D103)","v":0},{"$f":"+('Input - Income'!E78*'Input - Income'!E91)+('Input - Income'!E79*'Input - Income'!E103)","v":0},{"$f":"+('Input - Income'!F78*'Input - Income'!F91)+('Input - Income'!F79*'Input - Income'!F103)","v":0},{"$f":"+('Input - Income'!G78*'Input - Income'!G91)+('Input - Income'!G79*'Input - Income'!G103)","v":0},{"$f":"+('Input - Income'!H78*'Input - Income'!H91)+('Input - Income'!H79*'Input - Income'!H103)","v":0}]
["Waived fees",null,{"$f":"-'Input - Income'!C110","v":0},{"$f":"-'Input - Income'!D110","v":0},{"$f":"-'Input - Income'!E110","v":0},{"$f":"-'Input - Income'!F110","v":0},{"$f":"-'Input - Income'!G110","v":0},{"$f":"-'Input - Income'!H110","v":0}]
["International VAT education",null,{"$f":"'Input - Income'!C115","v":0},{"$f":"'Input - Income'!D115","v":0},{"$f":"'Input - Income'!E115","v":0},{"$f":"'Input - Income'!F115","v":0},{"$f":"'Input - Income'!G115","v":0},{"$f":"'Input - Income'!H115","v":0}]
["Research Income - Charity",null,{"$f":"+'Input - Income'!C120","v":0},{"$f":"+'Input - Income'!D120","v":0},{"$f":"+'Input - Income'!E120","v":0},{"$f":"+'Input - Income'!F120","v":0},{"$f":"+'Input - Income'!G120","v":0},{"$f":"+'Input - Income'!H120","v":0},null,null,null,"Link"]
["Research Income - Other",null,{"$f":"+'Input - Income'!C121","v":0},{"$f":"+'Input - Income'!D121","v":0},{"$f":"+'Input - Income'!E121","v":0},{"$f":"+'Input - Income'!F121","v":0},{"$f":"+'Input - Income'!G121","v":0},{"$f":"+'Input - Income'!H121","v":0},null,null,null,"Link"]
["Research Overheads",null,{"$f":"+'Input - Income'!C121*('Input - Income'!$C$119)","v":0},{"$f":"+'Input - Income'!D121*('Input - Income'!$C$119)","v":0},{"$f":"+'Input - Income'!E121*('Input - Income'!$C$119)","v":0},{"$f":"+'Input - Income'!F121*('Input - Income'!$C$119)","v":0},{"$f":"+'Input - Income'!G121*('Input - Income'!$C$119)","v":0},{"$f":"+'Input - Income'!H121*('Input - Income'!$C$119)","v":0},null,null,null,"Formula"]
["NHS Recharges",null,{"$f":"+'Input - Income'!C126","v":0},{"$f":"+'Input - Income'!D126","v":0},{"$f":"+'Input - Income'!E126","v":0},{"$f":"+'Input - Income'!F126","v":0},{"$f":"+'Input - Income'!G126","v":0},{"$f":"+'Input - Income'!H126","v":0}]
["CPD income",null,{"$f":"+'Input - Income'!C125","v":0},{"$f":"+'Input - Income'!D125","v":0},{"$f":"+'Input - Income'!E125","v":0},{"$f":"+'Input - Income'!F125","v":0},{"$f":"+'Input - Income'!G125","v":0},{"$f":"+'Input - Income'!H125","v":0},null,null,null,"Link"]
["Other income",null,{"$f":"+'Input - Income'!C127","v":0},{"$f":"+'Input - Income'!D127","v":0},{"$f":"+'Input - Income'!E127","v":0},{"$f":"+'Input - Income'!F127","v":0},{"$f":"+'Input - Income'!G127","v":0},{"$f":"+'Input - Income'!H127","v":0},null,null,null,"Link"]
[]
["Total Income",null,{"$f":"SUM(C6:C21)","v":0},{"$f":"SUM(D6:D21)","v":0},0,0,0,0]
[]
["Expenditure"]
[]
["Payroll"]
["QMUL Pay",null,{"$f":"+'Input - Expenditure'!C33","v":0},{"$f":"+'Input - Expenditure'!D33","v":0},{"$f":"+'Input - Expenditure'!E33","v":0},{"$f":"+'Input - Expenditure'!F33","v":0},{"$f":"+'Input - Expenditure'!G33","v":0},{"$f":"+'Input - Expenditure'!H33","v":0},null,null,null,"Link"]
["Research Pay",null,{"$f":"+('Input - Income'!C120+'Input - Income'!C121)*'General Assumptions'!B36","v":0},{"$f":"+('Input - Income'!D120+'Input - Income'!D121)*'General Assumptions'!C36","v":0},{"$f":"+('Input - Income'!E120+'Input - Income'!E121)*'General Assumptions'!D36","v":0},{"$f":"+('Input - Income'!F120+'Input - Income'!F121)*'General Assumptions'!E36","v":0},{"$f":"+('Input - Income'!G120+'Input - Income'!G121)*'General Assumptions'!F36","v":0},{"$f":"+('Input - Income'!H120+'Input - Income'!H121)*'General Assumptions'!G36","v":0},null,null,null,"Link"]
["NHS Recharges",null,{"$f":"+C18","v":0},0,0,0,0,0,null,null,null,"Link"]
["Total payroll",null,{"$f":"SUM(C27:C29)","v":0},0,0,0,0,0]
[]
["Non Pay"]
["QMUL Non Pay",null,{"$f":"+'Input - Expenditure'!C44","v":0},{"$f":"+'Input - Expenditure'!D44","v":0},{"$f":"+'Input - Expenditure'!E44","v":0},{"$f":"+'Input - Expenditure'!F44","v":0},{"$f":"+'Input - Expenditure'!G44","v":0},{"$f":"+'Input - Expenditure'!H44","v":0},null,null,null,"formula"]
["Bursaries",null,{"$f":"+('Input - Income'!C11*'Input - Income'!C24)*'General Assumptions'!B41","v":0},{"$f":"+('Input - Income'!D11*'Input - Income'!D24)*'General Assumptions'!C41","v":0},{"$f":"+('Input - Income'!E11*'Input - Income'!E24)*'General Assumptions'!D41","v":0},{"$f":"+('Input - Income'!F11*'Input - Income'!F24)*'General Assumptions'!E41","v":0},{"$f":"+('Input - Income'!G11*'Input - Income'!G24)*'General Assumptions'!E41","v":0},{"$f":"+('Input - Income'!H11*'Input - Income'!H24)*'General Assumptions'!F41","v":0}]
["Overseas Agents Fees",null,{"$f":"+((('Input - Income'!C12*'Input - Income'!C27)*'General Assumptions'!B13)+(('Input - Income'!C46*'Input - Income'!C61)*'General Assumptions'!B14))*'General Assumptions'!B15","v":0},{"$f":"+((('Input - Income'!D12*'Input - Income'!D27)*'General Assumptions'!C13)+(('Input - Income'!D46*'Input - Income'!D61)*'General Assumptions'!C14))*'General Assumptions'!C15","v":0},{"$f":"+((('Input - Income'!E12*'Input - Income'!E27)*'General Assumptions'!D13)+(('Input - Income'!E46*'Input - Income'!E61)*'General Assumptions'!D14))*'General Assumptions'!D15","v":0},{"$f":"+((('Input - Income'!F12*'Input - Income'!F27)*'General Assumptions'!E13)+(('Input - Income'!F46*'Input - Income'!F61)*'General Assumptions'!E14))*'General Assumptions'!E15","v":0},{"$f":"+((('Input - Income'!G12*'Input - Income'!G27)*'General Assumptions'!F13)+(('Input - Income'!G46*'Input - Income'!G61)*'General Assumptions'!F14))*'General Assumptions'!F15","v":0},{"$f":"+((('Input - Income'!H12*'Input - Income'!H27)*'General Assumptions'!G13)+(('Input - Income'!H46*'Input - Income'!H61)*'General Assumptions'!G14))*'General Assumptions'!G15","v":0}]
["Research non pay",null,{"$f":"+('Input - Income'!C120+'Input - Income'!C121)*'General Assumptions'!B37","v":0},{"$f":"+('Input - Income'!D120+'Input - Income'!D121)*'General Assumptions'!C37","v":0},{"$f":"+('Input - Income'!E120+'Input - Income'!E121)*'General Assumptions'!D37","v":0},{"$f":"+('Input - Income'!F120+'Input - Income'!F121)*'General Assumptions'!E37","v":0},{"$f":"+('Input - Income'!G120+'Input - Income'!G121)*'General Assumptions'!E37","v":0},{"$f":"+('Input - Income'!H120+'Input - Income'!H121)*'General Assumptions'!F37","v":0}]
["Total non pay",null,{"$f":"SUM(C32:C36)","v":0},0,0,0,0,0]
[]
["Total savings & strategic funding",null,{"$f":"-'Input - Expenditure'!C61","v":0},{"$f":"-'Input - Expenditure'!D61","v":0},{"$f":"-'Input - Expenditure'!E61","v":0},{"$f":"-'Input - Expenditure'!F61","v":0},{"$f":"-'Input - Expenditure'!G61","v":0},{"$f":"-'Input - Expenditure'!H61","v":0}]
[]
["Total expenditure",null,{"$f":"+C37+C30+C39","v":0},0,0,0,0,0]
[]
["TOTAL cash generation",null,{"$f":"+C22-C41","v":0},0,0,0,0,0]
[]
["Capital Expenditure",null,{"$f":"+'Input - Expenditure'!C52","v":0},{"$f":"+'Input - Expenditure'!D52","v":0},{"$f":"+'Input - Expenditure'!E52","v":0},{"$f":"+'Input - Expenditure'!F52","v":0},{"$f":"+'Input - Expenditure'!G52","v":0},{"$f":"+'Input - Expenditure'!H52","v":0}]
[]
["Cashflow ",null,{"$f":"+C43-C45","v":0},0,0,0,0,0]
[]
["Discount factor @ 4%",null,1,{"$f":"+C49*0.96","v":0.96},0.92159999999999997,0.88473599999999997,0.84934655999999997,0.81537269759999997]
[]
["Present value",null,{"$f":"+C47*C49","v":0},0,0,0,0,0]
[]
["Net Present Value",null,{"$f":"+SUM(C51:H51)","v":0}]
[]
["Cost of existing staff resources used - For information"]
[]
["All figures in £'000",null,"2020-21","2021-22","2022-23","2023-24","2024-25","2025-26"]
[]
["Cost of existing QMUL staff resources",null,{"$f":"-'Input - Expenditure'!C91","v":0},{"$f":"-'Input - Expenditure'!D91","v":0},{"$f":"-'Input - Expenditure'!E91","v":0},{"$f":"-'Input - Expenditure'!F91","v":0},{"$f":"-'Input - Expenditure'!G91","v":0},{"$f":"-'Input - Expenditure'!H91","v":0}]
[]
["QMUL potential loss of income - For information"]
[]
["All figures in £'000",null,"2020-21","2021-22","2022-23","2023-24","2024-25","2025-26"]
[]
["Studetnt FTE (1)"]
["Potential reduction in FTE - UG",null,{"$f":"-'Input - Income'!C148-'Input - Income'!C160","v":0},{"$f":"-'Input - Income'!D148-'Input - Income'!D160","v":0},{"$f":"-'Input - Income'!E148-'Input - Income'!E160","v":0},{"$f":"-'Input - Income'!F148-'Input - Income'!F160","v":0},{"$f":"-'Input - Income'!G148-'Input - Income'!G160","v":0},{"$f":"-'Input - Income'!H148-'Input - Income'!H160","v":0}]
["Potential reduction in FTE - PGT",null,{"$f":"-'Input - Income'!C181-'Input - Income'!C193","v":0},{"$f":"-'Input - Income'!D181-'Input - Income'!D193","v":0},{"$f":"-'Input - Income'!E181-'Input - Income'!E193","v":0},{"$f":"-'Input - Income'!F181-'Input - Income'!F193","v":0},{"$f":"-'Input - Income'!G181-'Input - Income'!G193","v":0},{"$f":"-'Input - Income'!H181-'Input - Income'!H193","v":0}]
["Potential reduction in FTE",null,{"$f":"SUM(C66:C67)","v":0},0,0,0,0,0]
[]
["Income (2)"]
["Potential reduction in income - UG",null,{"$f":"-('Input - Income'!C148*'Input - Income'!C11)-('Input - Income'!C160*'Input - Income'!C12)","v":0},{"$f":"-('Input - Income'!D148*'Input - Income'!D11)-('Input - Income'!D160*'Input - Income'!D12)","v":0},{"$f":"-('Input - Income'!E148*'Input - Income'!E11)-('Input - Income'!E160*'Input - Income'!E12)","v":0},{"$f":"-('Input - Income'!F148*'Input - Income'!F11)-('Input - Income'!F160*'Input - Income'!F12)","v":0},{"$f":"-('Input - Income'!G148*'Input - Income'!G11)-('Input - Income'!G160*'Input - Income'!G12)","v":0},{"$f":"-('Input - Income'!H148*'Input - Income'!H11)-('Input - Income'!H160*'Input - Income'!H12)","v":0}]
["Potential reduction in income - PGT",null,{"$f":"-('Input - Income'!C45*'Input - Income'!C181)-('Input - Income'!C46*'Input - Income'!C193)","v":0},{"$f":"-('Input - Income'!D45*'Input - Income'!D181)-('Input - Income'!D46*'Input - Income'!D193)","v":0},{"$f":"-('Input - Income'!E45*'Input - Income'!E181)-('Input - Income'!E46*'Input - Income'!E193)","v":0},{"$f":"-('Input - Income'!F45*'Input - Income'!F181)-('Input - Income'!F46*'Input - Income'!F193)","v":0},{"$f":"-('Input - Income'!G45*'Input - Income'!G181)-('Input - Income'!G46*'Input - Income'!G193)","v":0},{"$f":"-('Input - Income'!H45*'Input - Income'!H181)-('Input - Income'!H46*'Input - Income'!H193)","v":0}]
["Potential reduction in income - HEFCE Teaching",null,{"$f":"-'Input - Income'!C162-'Input - Income'!C195","v":0},{"$f":"-'Input - Income'!D162-'Input - Income'!D195","v":0},{"$f":"-'Input - Income'!E162-'Input - Income'!E195","v":0},{"$f":"-'Input - Income'!F162-'Input - Income'!F195","v":0},{"$f":"-'Input - Income'!G162-'Input - Income'!G195","v":0},{"$f":"-'Input - Income'!H162-'Input - Income'!H195","v":0}]
["Total Potential income reduction",null,{"$f":"SUM(C71:C73)","v":0},0,0,0,0,0]
[]
["QMUL potential loss of income",null,{"$f":"SUM(C71:C74)","v":0},0,0,0,0,0]
[]
["Discount factor @ 4%",null,1,{"$f":"+C78*0.96","v":0.96},{"$f":"+D78*0.96","v":0.92159999999999997},{"$f":"+E78*0.96","v":0.88473599999999997},{"$f":"+E78*0.96","v":0.88473599999999997},{"$f":"+F78*0.96","v":0.84934655999999997}]
[]
["Present value",null,{"$f":"+C76*C78","v":0},0,0,0,0,0]
[]
["Net Present Value",null,{"$f":"SUM(C80:H80)","v":0}]
[]
["(1) Potential FTE reduction of new applicants on existing programmes"]
["(2) Potential income reduction of new applicants on existing programmes"]

{"sheet":"Input - Income","index":1,"n_rows":198,"n_cols":17,"rows_kept":198,"cut":false,"hidden":false,"merged":[]}
["Income Inputs"]
[]
["Key"]
["Input"]
["Optional override"]
[]
["UG student numbers",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes",null,null,"A","B","C1.1","C1.2","C2","D"]
[]
["Programme length (Year)",null,3]
["HEFCE price group",null,"C2"]
["Home fee per student",null,9250,{"$f":"+C11","v":9250},{"$f":"+D11","v":9250},{"$f":"+E11","v":9250},{"$f":"+E11","v":9250},{"$f":"+F11","v":9250}]
["Overseas fee per student",null,28350,{"$f":"+C12*(1+'General Assumptions'!$B6)","v":29767.5},{"$f":"+D12*(1+'General Assumptions'!$B6)","v":31255.875},{"$f":"+E12*(1+'General Assumptions'!$B6)","v":32818.668750000004},{"$f":"+F12*(1+'General Assumptions'!$B6)","v":34459.602187500008},{"$f":"+G12*(1+'General Assumptions'!$B6)","v":36182.582296875007}]
[]
["Home student numbers"]
["Intake target"]
["Year 1",null,{"$f":"+IF(C9>=1,C15,0)","v":0},{"$f":"+IF(C9>=2,C15*'General Assumptions'!C7,0)","v":0},{"$f":"+IF(C9>=3,D16*'General Assumptions'!D8,0)","v":0},{"$f":"+IF(C9>=4,C15,0)","v":0},{"$f":"+IF(C9>=5,C15,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C9>=1,D15,0)","v":0},{"$f":"+IF(C9>=2,D15*'General Assumptions'!D7,0)","v":0},{"$f":"+IF(C9>=3,E17*'General Assumptions'!E8,0)","v":0},{"$f":"+IF(C9>=4,D15,0)","v":0},{"$f":"+IF(C9>=5,D15,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C9>=1,E15,0)","v":0},{"$f":"+IF(C9>=2,E15*'General Assumptions'!E7,0)","v":0},{"$f":"+IF(C9>=3,F18*'General Assumptions'!F8,0)","v":0},{"$f":"+IF(C9>=4,E15,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C9>=1,F15,0)","v":0},{"$f":"+IF(C9>=2,F15*'General Assumptions'!F7,0)","v":0},{"$f":"+IF(C9>=3,G19*'General Assumptions'!G8,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C9>=1,G15,0)","v":0},{"$f":"+IF(C9>=2,G15*'General Assumptions'!G7,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C9>=1,H15,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C16:C23)","v":0},{"$f":"SUM(D16:D23)","v":0},0,0,0,0]
[]
["Overseas student numbers"]
["Intake target"]
["Year 1",null,{"$f":"+IF(C9>=1,C27,0)","v":0},{"$f":"+IF(C9>=2,C27*'General Assumptions'!C7,0)","v":0},{"$f":"+IF(C9>=3,D28*'General Assumptions'!D8,0)","v":0},{"$f":"+IF(C9>=4,C27,0)","v":0},{"$f":"+IF(C9>=5,C27,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C9>=1,D27,0)","v":0},{"$f":"+IF(C9>=2,D27*'General Assumptions'!D7,0)","v":0},{"$f":"+IF(C9>=3,E29*'General Assumptions'!E8,0)","v":0},{"$f":"+IF(C9>=4,D27,0)","v":0},{"$f":"+IF(C9>=5,D27,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C9>=1,E27,0)","v":0},{"$f":"+IF(C9>=2,E27*'General Assumptions'!E7,0)","v":0},{"$f":"+IF(C9>=3,F30*'General Assumptions'!F8,0)","v":0},{"$f":"+IF(C9>=4,E27,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C9>=1,F27,0)","v":0},{"$f":"+IF(C9>=2,F27*'General Assumptions'!F7,0)","v":0},{"$f":"+IF(C9>=3,G31*'General Assumptions'!G8,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C9>=1,G27,0)","v":0},{"$f":"+IF(C9>=2,G27*'General Assumptions'!G7,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C9>=1,H27,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C28:C35)","v":0},0,0,0,0,0,null,null,null,null,null,"continuation rates"]
[]
["TOTAL UG student population",null,{"$f":"C24+C36","v":0},0,0,0,0,0]
["HEFCE T income",null,0,{"$f":"IF($C10=\"A\",C24*'General Assumptions'!B19,IF($C10=\"B\",'Input - Income'!C24*'General Assumptions'!B20,IF($C$10=\"C1.1\",C24*'General Assumptions'!B21,IF($C$10=\"C1.2\",C24*'General Assumptions'!B22,IF('Input - Income'!$C$10=\"C2\",'Input - Income'!C24*'General Assumptions'!B29,IF('Input - Income'!$C$10=\"D\",'Input - Income'!C24*'General Assumptions'!B30,0))))))","v":0},{"$f":"IF($C10=\"A\",D24*'General Assumptions'!C19,IF($C10=\"B\",'Input - Income'!D24*'General Assumptions'!C20,IF($C$10=\"C1.1\",D24*'General Assumptions'!C21,IF($C$10=\"C1.2\",D24*'General Assumptions'!C22,IF('Input - Income'!$C$10=\"C2\",'Input - Income'!D24*'General Assumptions'!C29,IF('Input - Income'!$C$10=\"D\",'Input - Income'!D24*'General Assumptions'!C30,0))))))","v":0},{"$f":"IF($C10=\"A\",E24*'General Assumptions'!D19,IF($C10=\"B\",'Input - Income'!E24*'General Assumptions'!D20,IF($C$10=\"C1.1\",E24*'General Assumptions'!D21,IF($C$10=\"C1.2\",E24*'General Assumptions'!D22,IF('Input - Income'!$C$10=\"C2\",'Input - Income'!E24*'General Assumptions'!D29,IF('Input - Income'!$C$10=\"D\",'Input - Income'!E24*'General Assumptions'!D30,0))))))","v":0},{"$f":"IF($C10=\"A\",F24*'General Assumptions'!E19,IF($C10=\"B\",'Input - Income'!F24*'General Assumptions'!E20,IF($C$10=\"C1.1\",F24*'General Assumptions'!E21,IF($C$10=\"C1.2\",F24*'General Assumptions'!E22,IF('Input - Income'!$C$10=\"C2\",'Input - Income'!F24*'General Assumptions'!E29,IF('Input - Income'!$C$10=\"D\",'Input - Income'!F24*'General Assumptions'!E30,0))))))","v":0},{"$f":"IF($C10=\"A\",G24*'General Assumptions'!F19,IF($C10=\"B\",'Input - Income'!G24*'General Assumptions'!F20,IF($C$10=\"C1.1\",G24*'General Assumptions'!F21,IF($C$10=\"C1.2\",G24*'General Assumptions'!F22,IF('Input - Income'!$C$10=\"C2\",'Input - Income'!G24*'General Assumptions'!F29,IF('Input - Income'!$C$10=\"D\",'Input - Income'!G24*'General Assumptions'!F30,0))))))","v":0}]
[]
["PGT student numbers",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
["Programme length (Year)"]
["HEFCE price group"]
["Home fee per student",null,null,{"$f":"+C45*(1+'General Assumptions'!B5)","v":0},{"$f":"+D45*(1+'General Assumptions'!C5)","v":0},{"$f":"+E45*(1+'General Assumptions'!D5)","v":0},{"$f":"+F45*(1+'General Assumptions'!E5)","v":0},{"$f":"+G45*(1+'General Assumptions'!F5)","v":0}]
["Overseas fee per student",null,null,{"$f":"+C46*(1+'General Assumptions'!B6)","v":0},{"$f":"+D46*(1+'General Assumptions'!C6)","v":0},{"$f":"+E46*(1+'General Assumptions'!D6)","v":0},{"$f":"+F46*(1+'General Assumptions'!E6)","v":0},{"$f":"+G46*(1+'General Assumptions'!F6)","v":0}]
[]
["Home student numbers"]
["Intake target",null,0,{"$f":"+C49","v":0},{"$f":"+D49","v":0},{"$f":"+E49","v":0},{"$f":"+E49","v":0},{"$f":"+F49","v":0}]
["Year 1",null,{"$f":"+IF(C43>=1,C49,0)","v":0},{"$f":"+IF(C43>=2,C49,0)","v":0},{"$f":"+IF(C43>=3,C49,0)","v":0},{"$f":"+IF(C43>=4,C49,0)","v":0},{"$f":"+IF(C43>=5,C49,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C43>=1,D49,0)","v":0},{"$f":"+IF(C43>=2,D49,0)","v":0},{"$f":"+IF(C43>=3,D49,0)","v":0},{"$f":"+IF(C43>=4,D49,0)","v":0},{"$f":"+IF(C43>=5,D49,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C43>=1,E49,0)","v":0},{"$f":"+IF(C43>=2,E49,0)","v":0},{"$f":"+IF(C43>=3,E49,0)","v":0},{"$f":"+IF(C43>=4,E49,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C43>=1,F49,0)","v":0},{"$f":"+IF(C43>=2,F49,0)","v":0},{"$f":"+IF(C43>=3,F49,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C43>=1,G49,0)","v":0},{"$f":"+IF(C43>=2,G49,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C43>=1,H49,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C50:C57)","v":0},0,0,0,0,0]
[]
["Overseas student numbers"]
["Intake target",null,0,{"$f":"+C61","v":0},{"$f":"+D61","v":0},{"$f":"+E61","v":0},{"$f":"+E61","v":0},{"$f":"+F61","v":0}]
["Year 1",null,{"$f":"+IF(C43>=1,C61,0)","v":0},{"$f":"+IF(C43>=2,C61,0)","v":0},{"$f":"+IF(C43>=3,C61,0)","v":0},{"$f":"+IF(C43>=4,C61,0)","v":0},{"$f":"+IF(C43>=5,C61,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C43>=1,D61,0)","v":0},{"$f":"+IF(C43>=2,D61,0)","v":0},{"$f":"+IF(C43>=3,D61,0)","v":0},{"$f":"+IF(C43>=4,D61,0)","v":0},{"$f":"+IF(C43>=5,D61,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C43>=1,E61,0)","v":0},{"$f":"+IF(C43>=2,E61,0)","v":0},{"$f":"+IF(C43>=3,E61,0)","v":0},{"$f":"+IF(C43>=4,E61,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C43>=1,F61,0)","v":0},{"$f":"+IF(C43>=2,F61,0)","v":0},{"$f":"+IF(C43>=3,F61,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C43>=1,G61,0)","v":0},{"$f":"+IF(C43>=2,G61,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C43>=1,H61,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C62:C69)","v":0},0,0,0,0,0,null,null,null,null,null,"continuation rates"]
[]
["HEFCE Teaching Income",null,0,{"$f":"IF($C44=\"A\",C58*'General Assumptions'!B25,IF($C44=\"B\",'Input - Income'!C58*'General Assumptions'!B26,IF($C$44=\"C1.1\",C58*'General Assumptions'!B27,IF('Input - Income'!$C$44=\"C1.2\",'Input - Income'!C58*'General Assumptions'!B28,IF('Input - Income'!$C$44=\"C2\",'Input - Income'!C58*'General Assumptions'!B29,IF('Input - Income'!$C$44=\"D\",'Input - Income'!C58*'General Assumptions'!B30,0))))))","v":0},{"$f":"IF($C44=\"A\",D58*'General Assumptions'!C25,IF($C44=\"B\",'Input - Income'!D58*'General Assumptions'!C26,IF($C$44=\"C1.1\",D58*'General Assumptions'!C27,IF('Input - Income'!$C$44=\"C1.2\",'Input - Income'!D58*'General Assumptions'!C28,IF('Input - Income'!$C$44=\"C2\",'Input - Income'!D58*'General Assumptions'!C29,IF('Input - Income'!$C$44=\"D\",'Input - Income'!D58*'General Assumptions'!C30,0))))))","v":0},{"$f":"IF($C44=\"A\",E58*'General Assumptions'!D25,IF($C44=\"B\",'Input - Income'!E58*'General Assumptions'!D26,IF($C$44=\"C1.1\",E58*'General Assumptions'!D27,IF('Input - Income'!$C$44=\"C1.2\",'Input - Income'!E58*'General Assumptions'!D28,IF('Input - Income'!$C$44=\"C2\",'Input - Income'!E58*'General Assumptions'!D29,IF('Input - Income'!$C$44=\"D\",'Input - Income'!E58*'General Assumptions'!D30,0))))))","v":0},{"$f":"IF($C44=\"A\",F58*'General Assumptions'!E25,IF($C44=\"B\",'Input - Income'!F58*'General Assumptions'!E26,IF($C$44=\"C1.1\",F58*'General Assumptions'!E27,IF('Input - Income'!$C$44=\"C1.2\",'Input - Income'!F58*'General Assumptions'!E28,IF('Input - Income'!$C$44=\"C2\",'Input - Income'!F58*'General Assumptions'!E29,IF('Input - Income'!$C$44=\"D\",'Input - Income'!F58*'General Assumptions'!E30,0))))))","v":0},{"$f":"IF($C44=\"A\",G58*'General Assumptions'!F25,IF($C44=\"B\",'Input - Income'!G58*'General Assumptions'!F26,IF($C$44=\"C1.1\",G58*'General Assumptions'!F27,IF('Input - Income'!$C$44=\"C1.2\",'Input - Income'!G58*'General Assumptions'!F28,IF('Input - Income'!$C$44=\"C2\",'Input - Income'!G58*'General Assumptions'!F29,IF('Input - Income'!$C$44=\"D\",'Input - Income'!G58*'General Assumptions'!F30,0))))))","v":0}]
[]
[]
["PGR student numbers (QMUL)",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
["Programme length (Year)"]
["Home fee per student",null,null,{"$f":"+C78*(1+'General Assumptions'!$B5)","v":0},{"$f":"+D78*(1+'General Assumptions'!$B5)","v":0},{"$f":"+E78*(1+'General Assumptions'!$B5)","v":0},{"$f":"+F78*(1+'General Assumptions'!$B5)","v":0},{"$f":"+G78*(1+'General Assumptions'!$B5)","v":0}]
["Overseas fee per student",null,null,{"$f":"+C79*(1+'General Assumptions'!$B6)","v":0},{"$f":"+D79*(1+'General Assumptions'!$B6)","v":0},{"$f":"+E79*(1+'General Assumptions'!$B6)","v":0},{"$f":"+F79*(1+'General Assumptions'!$B6)","v":0},{"$f":"+G79*(1+'General Assumptions'!$B6)","v":0}]
[]
["Home student numbers"]
["Intake target",null,0,{"$f":"+C82","v":0},{"$f":"+D82","v":0},{"$f":"+E82","v":0},{"$f":"+E82","v":0},{"$f":"+F82","v":0}]
["Year 1",null,{"$f":"+IF(C77>=1,C82,0)","v":0},{"$f":"+IF(C77>=2,C82,0)","v":0},{"$f":"+IF(C77>=3,C82,0)","v":0},{"$f":"+IF(C77>=4,C82,0)","v":0},{"$f":"+IF(C77>=5,C82,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C77>=1,D82,0)","v":0},{"$f":"+IF(C77>=2,D82,0)","v":0},{"$f":"+IF(C77>=3,D82,0)","v":0},{"$f":"+IF(C77>=4,D82,0)","v":0},{"$f":"+IF(C77>=5,D82,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C77>=1,E82,0)","v":0},{"$f":"+IF(C77>=2,E82,0)","v":0},{"$f":"+IF(C77>=3,E82,0)","v":0},{"$f":"+IF(C77>=4,E82,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C77>=1,F82,0)","v":0},{"$f":"+IF(C77>=2,F82,0)","v":0},{"$f":"+IF(C77>=3,F82,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C77>=1,G82,0)","v":0},{"$f":"+IF(C77>=2,G82,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C77>=1,H82,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C83:C90)","v":0},0,0,0,0,0]
[]
["Overseas student numbers"]
["Intake target",null,0,{"$f":"+C94","v":0},{"$f":"+D94","v":0},{"$f":"+E94","v":0},{"$f":"+E94","v":0},{"$f":"+F94","v":0}]
["Year 1",null,{"$f":"+IF(C77>=1,C94,0)","v":0},{"$f":"+IF(C77>=2,C94,0)","v":0},{"$f":"+IF(C77>=3,C94,0)","v":0},{"$f":"+IF(C77>=4,C94,0)","v":0},{"$f":"+IF(C77>=5,C94,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C77>=1,D94,0)","v":0},{"$f":"+IF(C77>=2,D94,0)","v":0},{"$f":"+IF(C77>=3,D94,0)","v":0},{"$f":"+IF(C77>=4,D94,0)","v":0},{"$f":"+IF(C77>=5,D94,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C77>=1,E94,0)","v":0},{"$f":"+IF(C77>=2,E94,0)","v":0},{"$f":"+IF(C77>=3,E94,0)","v":0},{"$f":"+IF(C77>=4,E94,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C77>=1,F94,0)","v":0},{"$f":"+IF(C77>=2,F94,0)","v":0},{"$f":"+IF(C77>=3,F94,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C77>=1,G94,0)","v":0},{"$f":"+IF(C77>=2,G94,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C77>=1,H94,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C95:C102)","v":0},0,0,0,0,0,null,null,null,null,null,"continuation rates"]
[]
["HEFCE RDP funding",null,0,{"$f":"+C91*'General Assumptions'!B31","v":0},{"$f":"+D91*'General Assumptions'!C31","v":0},{"$f":"+E91*'General Assumptions'!D31","v":0},{"$f":"+E91*'General Assumptions'!D31","v":0},{"$f":"+F91*'General Assumptions'!E31","v":0}]
[]
[]
["Waived fees",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
["Waived fees amount - £",null,{"$f":"(C61*0.1)*C46","v":0},{"$f":"+C110","v":0},{"$f":"+D110","v":0},{"$f":"+E110","v":0},{"$f":"+E110","v":0},{"$f":"+F110","v":0}]
[]
["VAT/Tax",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
[null,null,0]
["International VAT on education",null,{"$f":"((C12*C36)+(C46*C70)+(C79*C103))*$C$114","v":0},{"$f":"((D12*D36)+(D46*D70)+(D79*D103))*$C$114","v":0},0,0,0,0]
[]
["Research income",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
["Overhead recovery %"]
["Research Income - Charity",null,0,{"$f":"+C120","v":0},0,0,{"$f":"+E120","v":0},0]
["Research Income - Other",null,0,0,0,0,0,0]
[]
["Other Income",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
["CPD",null,0,{"$f":"+C125*(1+'General Assumptions'!C9)","v":0},{"$f":"+D125*(1+'General Assumptions'!D9)","v":0},{"$f":"+E125*(1+'General Assumptions'!E9)","v":0},{"$f":"+F125*(1+'General Assumptions'!F9)","v":0},{"$f":"+G125*(1+'General Assumptions'!G9)","v":0}]
["NHS Recharges",null,0,{"$f":"+C126*(1+'General Assumptions'!C10)","v":0},{"$f":"+D126*(1+'General Assumptions'!D10)","v":0},{"$f":"+E126*(1+'General Assumptions'!E10)","v":0},{"$f":"+F126*(1+'General Assumptions'!F10)","v":0},{"$f":"+G126*(1+'General Assumptions'!G10)","v":0}]
["Other Income",null,0,{"$f":"+C127*(1+'General Assumptions'!C9)","v":0},{"$f":"+D127*(1+'General Assumptions'!D9)","v":0},{"$f":"+E127*(1+'General Assumptions'!E9)","v":0},{"$f":"+F127*(1+'General Assumptions'!F9)","v":0},{"$f":"+G127*(1+'General Assumptions'!G9)","v":0}]
[]
["Potential loss of students from existing programmes - For information only *"]
[]
["UG student numbers",null,"2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","Notes"]
[]
["Programme length",null,{"$f":"+C9","v":3}]
["HEFCE price group",null,"B"]
["Home fee",null,{"$f":"+C11","v":9250},9250,9250,9250,9250,9250]
["Overseas fee",null,28350,29767.5,31255.875,32818.668750000004,34459.602187500008,36182.582296875007]
[]
["Home student numbers"]
["Intake target",null,0,{"$f":"+C139","v":0},{"$f":"+D139","v":0},{"$f":"+E139","v":0},{"$f":"+E139","v":0},{"$f":"+F139","v":0}]
["Year 1",null,{"$f":"+IF(C133>=1,C139,0)","v":0},{"$f":"+IF(C133>=2,C139,0)","v":0},{"$f":"+IF(C133>=3,C139,0)","v":0},{"$f":"+IF(C133>=4,C139,0)","v":0},{"$f":"+IF(C133>=5,C139,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C133>=1,D139,0)","v":0},{"$f":"+IF(C133>=2,D139,0)","v":0},{"$f":"+IF(C133>=3,D139,0)","v":0},{"$f":"+IF(C133>=4,D139,0)","v":0},{"$f":"+IF(C133>=5,D139,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C133>=1,E139,0)","v":0},{"$f":"+IF(C133>=2,E139,0)","v":0},{"$f":"+IF(C133>=3,E139,0)","v":0},{"$f":"+IF(C133>=4,E139,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C133>=1,F139,0)","v":0},{"$f":"+IF(C133>=2,F139,0)","v":0},{"$f":"+IF(C133>=3,F139,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C133>=1,G139,0)","v":0},{"$f":"+IF(C133>=2,G139,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C133>=1,H139,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C140:C147)","v":0},0,0,0,0,0]
[]
["Overseas student numbers"]
["Intake target",null,0,{"$f":"+C151","v":0},{"$f":"+D151","v":0},{"$f":"+E151","v":0},{"$f":"+E151","v":0},{"$f":"+F151","v":0}]
["Year 1",null,{"$f":"+IF(C133>=1,C151,0)","v":0},{"$f":"+IF(C133>=2,C151,0)","v":0},{"$f":"+IF(C133>=3,C151,0)","v":0},{"$f":"+IF(C133>=4,C151,0)","v":0},{"$f":"+IF(C133>=5,C151,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C133>=1,D151,0)","v":0},{"$f":"+IF(C133>=2,D151,0)","v":0},{"$f":"+IF(C133>=3,D151,0)","v":0},{"$f":"+IF(C133>=4,D151,0)","v":0},{"$f":"+IF(C133>=5,D151,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C133>=1,E151,0)","v":0},{"$f":"+IF(C133>=2,E151,0)","v":0},{"$f":"+IF(C133>=3,E151,0)","v":0},{"$f":"+IF(C133>=4,E151,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C133>=1,F151,0)","v":0},{"$f":"+IF(C133>=2,F151,0)","v":0},{"$f":"+IF(C133>=3,F151,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C133>=1,G151,0)","v":0},{"$f":"+IF(C133>=2,G151,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C133>=1,H151,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C152:C159)","v":0},0,0,0,0,0,null,null,null,null,null,"continuation rates"]
[]
["HEFCE RDP funding",null,0,{"$f":"+C148*'General Assumptions'!B83","v":0},{"$f":"+D148*'General Assumptions'!C83","v":0},{"$f":"+E148*'General Assumptions'!D83","v":0},{"$f":"+E148*'General Assumptions'!D83","v":0},{"$f":"+F148*'General Assumptions'!E83","v":0}]
[]
[]
[]
["Programme length",null,{"$f":"+C43","v":0}]
["HEFCE price group",null,{"$f":"+C44","v":0}]
["Home fee",null,{"$f":"+C45","v":0},{"$f":"+D45","v":0},0,0,0,0]
["Overseas fee",null,{"$f":"+C46","v":0},0,0,0,0,0]
[]
["Home student numbers"]
["Intake target",null,0,{"$f":"+C172","v":0},{"$f":"+D172","v":0},{"$f":"+E172","v":0},{"$f":"+E172","v":0},{"$f":"+F172","v":0}]
["Year 1",null,{"$f":"+IF(C166>=1,C172,0)","v":0},{"$f":"+IF(C166>=2,C172,0)","v":0},{"$f":"+IF(C166>=3,C172,0)","v":0},{"$f":"+IF(C166>=4,C172,0)","v":0},{"$f":"+IF(C166>=5,C172,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C166>=1,D172,0)","v":0},{"$f":"+IF(C166>=2,D172,0)","v":0},{"$f":"+IF(C166>=3,D172,0)","v":0},{"$f":"+IF(C166>=4,D172,0)","v":0},{"$f":"+IF(C166>=5,D172,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C166>=1,E172,0)","v":0},{"$f":"+IF(C166>=2,E172,0)","v":0},{"$f":"+IF(C166>=3,E172,0)","v":0},{"$f":"+IF(C166>=4,E172,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C166>=1,F172,0)","v":0},{"$f":"+IF(C166>=2,F172,0)","v":0},{"$f":"+IF(C166>=3,F172,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C166>=1,G172,0)","v":0},{"$f":"+IF(C166>=2,G172,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C166>=1,H172,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C173:C180)","v":0},0,0,0,0,0]
[]
["Overseas student numbers"]
["Intake target",null,0,{"$f":"+C184","v":0},{"$f":"+D184","v":0},{"$f":"+E184","v":0},{"$f":"+E184","v":0},{"$f":"+F184","v":0}]
["Year 1",null,{"$f":"+IF(C166>=1,C184,0)","v":0},{"$f":"+IF(C166>=2,C184,0)","v":0},{"$f":"+IF(C166>=3,C184,0)","v":0},{"$f":"+IF(C166>=4,C184,0)","v":0},{"$f":"+IF(C166>=5,C184,0)","v":0},0]
["Year 2",null,null,{"$f":"+IF(C166>=1,D184,0)","v":0},{"$f":"+IF(C166>=2,D184,0)","v":0},{"$f":"+IF(C166>=3,D184,0)","v":0},{"$f":"+IF(C166>=4,D184,0)","v":0},{"$f":"+IF(C166>=5,D184,0)","v":0}]
["Year 3",null,null,null,{"$f":"+IF(C166>=1,E184,0)","v":0},{"$f":"+IF(C166>=2,E184,0)","v":0},{"$f":"+IF(C166>=3,E184,0)","v":0},{"$f":"+IF(C166>=4,E184,0)","v":0}]
["Year 4",null,null,null,null,{"$f":"+IF(C166>=1,F184,0)","v":0},{"$f":"+IF(C166>=2,F184,0)","v":0},{"$f":"+IF(C166>=3,F184,0)","v":0}]
["Year 5",null,null,null,null,null,{"$f":"+IF(C166>=1,G184,0)","v":0},{"$f":"+IF(C166>=2,G184,0)","v":0}]
["Year 6",null,null,null,null,null,null,{"$f":"+IF(C166>=1,H184,0)","v":0}]
["Year 7"]
["Year 8"]
["Student population",null,{"$f":"SUM(C185:C192)","v":0},0,0,0,0,0,null,null,null,null,null,"continuation rates"]
[]
["HEFCE RDP funding",null,0,{"$f":"+C181*'General Assumptions'!B116","v":0},{"$f":"+D181*'General Assumptions'!C116","v":0},{"$f":"+E181*'General Assumptions'!D116","v":0},{"$f":"+E181*'General Assumptions'!D116","v":0},{"$f":"+F181*'General Assumptions'!E116","v":0}]
[]
[]
["* Include risk of cannibalisation of existing applicants to QM Programmes to this new programme i.e. Student would have enrolled at QMUL on an existing programme"]

{"sheet":"Input - Expenditure","index":2,"n_rows":93,"n_cols":31,"rows_kept":93,"cut":false,"hidden":false,"merged":[[2,11,3,11],[2,18,3,18],[2,26,3,26]]}
["Expenditure Inputs "]
[]
["Key",null,null,null,null,null,null,null,null,null,null,1.33,null,"Professional",null,null,null,null,1.33,null,"Lecturers",null,null,null,null,null,1.33,null,"Professors"]
["Input"]
["Optional override",null,null,null,null,null,null,null,null,null,null,"Point","Base salary 2019","Salary including on costs",null,null,null,null,"Point","Base salary 2019","Salary including on costs",null,null,null,null,null,"Point","Base salary 2019","Salary including on costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Spinal Point"]
["QMUL FTE and Pay",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes",null,null,53,77240,{"$f":"+M7*$L$3","v":102729.20000000001},null,null,null,null,null,null,null,null,null,null,null,null,"Off £159k",{"$f":"+AB8+3000","v":159000},{"$f":"+AB7*$L$3","v":211470}]
[null,null,null,null,null,null,null,null,null,null,null,52,75116,99904.28,null,null,null,null,null,null,null,null,null,null,null,null,"Off £156k",156000,{"$f":"+AB8*$L$3","v":207480}]
["QMUL FTE",null,null,null,null,null,null,null,null,null,null,51,73057,{"$f":"+M9*$L$3","v":97165.810000000012},null,null,null,null,null,null,null,null,null,null,null,null,"Off £153k",153000,{"$f":"+AB9*$L$3","v":203490}]
["Clinical Professor",null,0,{"$f":"+C10","v":0},0,0,0,0,null,null,null,50,71057,94505.810000000012,null,null,null,null,null,null,null,null,null,null,null,null,"Off £150k",150000,{"$f":"+AB10*$L$3","v":199500}]
["Clinical Reader/Senior Lecturer",null,0,0,0,0,0,0,null,null,null,49,69114,91921.62000000001,null,null,null,null,"Select Spinal Point",null,null,null,null,null,null,null,"Off £147k",147000,{"$f":"+AB11*$L$3","v":195510}]
["Clinical Lecturer",null,0,0,0,0,0,0,null,null,null,48,67228,89413.24,null,null,null,null,"Off £99k",99000,{"$f":"+T12*$L$3","v":131670},null,null,null,null,null,"Off £144k",144000,{"$f":"+AB12*$L$3","v":191520}]
["Non-clinical professor",null,0,{"$f":"+C13","v":0},0,0,0,0,null,null,null,47,65398,86979.340000000011,null,null,null,null,"Off £96k",96000,127680,null,null,null,null,null,"Off £141k",141000,187530]
["Reader / senior lecturer",null,0,{"$f":"+C14","v":0},{"$f":"+D14","v":0},{"$f":"+E14","v":0},{"$f":"+F14","v":0},{"$f":"+G14","v":0},null,null,null,46,63622,84617.260000000009,null,null,null,null,"Off £93k",93000,123690,null,null,null,null,null,"Off £138k",138000,183540]
["Lecturer",null,0,0,0,0,0,0,null,null,null,45,61896,82321.680000000008,null,null,null,null,"Off £90k",{"$f":"+T14-3000","v":90000},119700,null,null,null,null,null,"Off £135k",135000,179550]
["Academic & professional admin",null,0,0,0,0,0,0,null,null,null,44,60221,80093.930000000008,null,null,null,null,"Off £87k",{"$f":"+T15-3000","v":87000},115710,null,null,null,null,null,"Off £132k",132000,175560]
["Teaching assistants",null,0,0,0,0,0,0,null,null,null,43,58595,77931.350000000006,null,null,null,null,"Off £84k",84000,111720,null,null,null,null,null,"Off £129k",129000,171570]
["Other (include role in notes)",null,0,0,0,0,0,0,null,null,null,42,57015,75829.95,null,null,null,null,"Off £81k",81000,107730,null,null,null,null,null,"Off £126k",126000,167580]
[null,null,null,null,null,null,null,null,null,null,null,41,55483,73792.39,null,null,null,null,"Off £78k",78000,103740,null,null,null,null,null,"Off £123k",123000,163590]
["Total QMUL FTE",null,{"$f":"SUM(C9:C19)","v":0},0,0,0,0,0,null,null,null,40,53994,71812.02,null,null,null,null,"Off £75k",75000,99750,null,null,null,null,null,"Off £120k",120000,159600]
[null,null,null,null,null,null,null,null,null,null,null,39,52549,69890.17,null,null,null,null,"Off £72k",72000,95760,null,null,null,null,null,"Off £117k",117000,155610]
["QMUL Pay","Grade",null,null,null,null,null,null,null,null,null,38,51174,68061.42,"New QMUL Pay","Exist QMUL Pay",null,null,53,77240,102729.20000000001,"New QMUL Pay","Exist QMUL Pay",null,null,null,"Off £114k",114000,151620,"New QMUL Pay","Exist QMUL Pay"]
["Clinical Professor","Select Spinal Point",{"$f":"+C10*$AD23","v":0},{"$f":"+D10*$AD23*'General Assumptions'!C11","v":0},{"$f":"+E10*$AD23*'General Assumptions'!D11","v":0},{"$f":"+F10*$AD23*'General Assumptions'!E11","v":0},{"$f":"+G10*$AD23*'General Assumptions'!F11","v":0},{"$f":"+H10*$AD23*'General Assumptions'!G11","v":0},null,null,null,37,49785,66214.05,{"$f":"IF(ISNA(VLOOKUP(B23,$L$6:$N$61,3,FALSE)),0,VLOOKUP(B23,$L$6:$N$61,3,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(B81,$L$6:$N$61,3,FALSE)),0,VLOOKUP(B81,$L$6:$N$61,3,FALSE))","v":0},null,null,52,75116,99904.28,{"$f":"IF(ISNA(VLOOKUP(B23,$S$10:$U$69,3,FALSE)),0,VLOOKUP(B23,$S$10:$U$69,3,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(B81,$S$10:$U$69,3,FALSE)),0,VLOOKUP(B81,$S$10:$U$69,3,FALSE))","v":0},null,null,null,"Off £111k",111000,147630,{"$f":"IF(ISNA(VLOOKUP(B23,$AA$5:$AC$64,3,FALSE)),0,VLOOKUP(B23,$AA$5:$AC$64,3,FALSE))","v":0},{"$f":"IF(ISNA(VLOOKUP(B81,$AA$5:$AC$64,3,FALSE)),0,VLOOKUP(B81,$AA$5:$AC$64,3,FALSE))","v":0}]
["Clinical Reader/Senior Lecturer","Select Spinal Point",{"$f":"+C11*$V24","v":0},{"$f":"+D11*$V24*'General Assumptions'!C11","v":0},{"$f":"+E11*$V24*'General Assumptions'!D11","v":0},{"$f":"+F11*$V24*'General Assumptions'!E11","v":0},{"$f":"+G11*$V24*'General Assumptions'!F11","v":0},{"$f":"+H11*$V24*'General Assumptions'!G11","v":0},null,null,null,36,48463,64455.79,0,0,null,null,51,73057,{"$f":"+T24*$L$3","v":97165.810000000012},0,0,null,null,null,"Off £108k",108000,{"$f":"+AB24*$L$3","v":143640},0,0]
["Clinical Lecturer","Select Spinal Point",{"$f":"+C12*$V25","v":0},{"$f":"+D12*$V25*'General Assumptions'!C11","v":0},{"$f":"+E12*$V25*'General Assumptions'!D11","v":0},{"$f":"+F12*$V25*'General Assumptions'!E11","v":0},{"$f":"+G12*$V25*'General Assumptions'!F11","v":0},{"$f":"+H12*$V25*'General Assumptions'!G11","v":0},null,null,null,35,47178,62746.740000000005,0,0,null,null,50,71057,{"$f":"+T25*$L$3","v":94505.810000000012},0,0,null,null,null,"Off £105k",105000,{"$f":"+AB25*$L$3","v":139650},0,0]
["Non-clinical professor","Select Spinal Point",{"$f":"+C13*$AD26","v":0},{"$f":"+D13*$AD26*'General Assumptions'!C11","v":0},{"$f":"+E13*$AD26*'General Assumptions'!D11","v":0},{"$f":"+F13*$AD26*'General Assumptions'!E11","v":0},{"$f":"+G13*$AD26*'General Assumptions'!F11","v":0},{"$f":"+H13*$AD26*'General Assumptions'!G11","v":0},null,null,null,34,45932,61089.560000000005,0,0,null,null,49,69114,91921.62000000001,0,0,null,null,null,"Off £102k",{"$f":"+AB27+3000","v":102000},{"$f":"+AB26*$L$3","v":135660},0,0]
["Reader / senior lecturer","Select Spinal Point",{"$f":"+C14*$V27","v":0},{"$f":"+D14*$V27*'General Assumptions'!C11","v":0},{"$f":"+E14*$V27*'General Assumptions'!D11","v":0},{"$f":"+F14*$V27*'General Assumptions'!E11","v":0},{"$f":"+G14*$V27*'General Assumptions'!F11","v":0},{"$f":"+H14*$V27*'General Assumptions'!G11","v":0},null,null,null,33,44722,59480.26,0,0,null,null,48,67228,89413.24,0,0,null,null,null,"Off £99k",99000,{"$f":"+AB27*$L$3","v":131670},0,0]
["Lecturer","Select Spinal Point",{"$f":"+C15*$V28","v":0},{"$f":"+D15*$V28*'General Assumptions'!C11","v":0},{"$f":"+E15*$V28*'General Assumptions'!D11","v":0},{"$f":"+F15*$V28*'General Assumptions'!E11","v":0},{"$f":"+G15*$V28*'General Assumptions'!F11","v":0},{"$f":"+H15*$V28*'General Assumptions'!G11","v":0},null,null,null,32,43548,57918.840000000004,0,0,null,null,47,65398,86979.340000000011,0,0,null,null,null,"Off £96k",96000,127680,0,0]
["Academic & professional admin","Select Spinal Point",{"$f":"+C16*$O29","v":0},{"$f":"+D16*$O29*'General Assumptions'!C11","v":0},{"$f":"+E16*$O29*'General Assumptions'!D11","v":0},{"$f":"+F16*$O29*'General Assumptions'!E11","v":0},{"$f":"+G16*$O29*'General Assumptions'!F11","v":0},{"$f":"+H16*$O29*'General Assumptions'!G11","v":0},null,null,null,31,42405,56398.65,0,0,null,null,46,63622,84617.260000000009,0,0,null,null,null,"Off £93k",93000,123690,0,0]
["Teaching assistants","Select Spinal Point",{"$f":"+C17*$O30","v":0},{"$f":"+D17*$O30*'General Assumptions'!C11","v":0},{"$f":"+E17*$O30*'General Assumptions'!D11","v":0},{"$f":"+F17*$O30*'General Assumptions'!E11","v":0},{"$f":"+G17*$O30*'General Assumptions'!F11","v":0},{"$f":"+H17*$O30*'General Assumptions'!G11","v":0},null,null,null,30,41300,54929,0,0,null,null,45,61896,82321.680000000008,0,0,null,null,null,"Off £90k",{"$f":"+AB29-3000","v":90000},119700,0,0]
["Other","Select Spinal Point",{"$f":"+C18*$O31","v":0},{"$f":"+D18*$O31*'General Assumptions'!C11","v":0},{"$f":"+E18*$O31*'General Assumptions'!D11","v":0},{"$f":"+F18*$O31*'General Assumptions'!E11","v":0},{"$f":"+G18*$O31*'General Assumptions'!F11","v":0},{"$f":"+H18*$O31*'General Assumptions'!G11","v":0},null,null,null,29,40223,53496.590000000004,0,0,null,null,44,60221,80093.930000000008,0,0,null,null,null,"Off £87k",{"$f":"+AB30-3000","v":87000},115710,0,0]
[null,null,null,null,null,null,null,null,null,null,null,28,39180,52109.4,null,null,null,null,43,58595,77931.350000000006,null,null,null,null,null,"Off £84k",84000,111720]
["Total QMUL Pay",null,{"$f":"SUM(C23:C32)","v":0},0,0,0,0,0,null,null,null,27,38165,50759.450000000004,null,null,null,null,42,57015,75829.95,null,null,null,null,null,"Off £81k",81000,107730]
[null,null,null,null,null,null,null,null,null,null,null,26,37182,49452.060000000005,null,null,null,null,41,55483,73792.39,null,null,null,null,null,"Off £78k",78000,103740]
["QMUL Non Pay Expenditure",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes",null,null,25,36572,48640.76,null,null,null,null,40,53994,71812.02,null,null,null,null,null,"Off £75k",75000,99750]
[null,null,null,null,null,null,null,null,null,null,null,24,35636,47395.880000000005,null,null,null,null,39,52549,69890.17,null,null,null,null,null,"Off £72k",72000,95760]
["Start-up costs",null,0,0,0,0,0,0,null,null,null,23,34728,{"$f":"+M37*$L$3","v":46188.240000000005},null,null,null,null,38,51174,68061.42,null,null,null,null,null,53,77240,102729.20000000001]
["Consumables PhD students",null,0,{"$f":"C38*(1+'General Assumptions'!C12)","v":0},{"$f":"D38*(1+'General Assumptions'!D12)","v":0},{"$f":"E38*(1+'General Assumptions'!E12)","v":0},{"$f":"F38*(1+'General Assumptions'!F12)","v":0},{"$f":"G38*(1+'General Assumptions'!G12)","v":0},null,null,null,22,33845,45013.850000000006,null,null,null,null,37,49785,66214.05,null,null,null,null,null,52,75116,99904.28]
["PGR QMUL Funded Stipends",null,{"$f":"+$B39*('Input - Income'!C103+'Input - Income'!C91)","v":0},{"$f":"+$B39*('Input - Income'!D103+'Input - Income'!D91)*(1+'General Assumptions'!$B$12)","v":0},{"$f":"+$B39*('Input - Income'!E103+'Input - Income'!E91)*((1+'General Assumptions'!$B$12)^2)","v":0},{"$f":"+$B39*('Input - Income'!F103+'Input - Income'!F91)*((1+'General Assumptions'!$B$12)^3)","v":0},{"$f":"+$B39*('Input - Income'!G103+'Input - Income'!G91)*((1+'General Assumptions'!$B$12)^4)","v":0},{"$f":"+$B39*('Input - Income'!H103+'Input - Income'!H91)*((1+'General Assumptions'!$B$12)^5)","v":0},null,null,null,21,32999,43888.670000000006,null,null,null,null,36,48463,64455.79,null,null,null,null,null,51,73057,{"$f":"+AB39*$L$3","v":97165.810000000012}]
["Equipment",null,0,0,0,0,0,0,null,null,null,20,32220,42852.600000000006,null,null,null,null,35,47178,62746.740000000005,null,null,null,null,null,50,71057,{"$f":"+AB40*$L$3","v":94505.810000000012}]
["Marketing"]
["Other QMUL non pay",null,null,null,null,null,null,null,null,null,null,19,31421,41789.93,null,null,null,null,null,null,null,null,null,null,null,null,49,69114,{"$f":"+AB42*$L$3","v":91921.62000000001}]
[null,null,null,null,null,null,null,null,null,null,null,18,30685,40811.050000000003,null,null,null,null,null,null,null,null,null,null,null,null,48,67228,{"$f":"+AB43*$L$3","v":89413.24}]
["Total QMUL Non Pay",null,{"$f":"SUM(C36:C43)","v":0},0,0,0,0,0,null,null,null,17,29982,39876.060000000005]
[null,null,null,null,null,null,null,null,null,null,null,16,29378,39072.740000000005]
["Capital Expenditure",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes",null,null,15,28773,38268.090000000004]
[null,null,null,null,null,null,null,null,null,null,null,14,28528,37942.240000000005]
["IT",null,0,0,0,0,0,0,null,null,null,13,27979,37212.07]
["Estates",null,0,0,0,0,0,0,null,null,null,12,27424,36473.920000000006]
["Equipment",null,0,0,0,0,0,0,null,null,null,11,26961,35858.130000000005]
[null,null,null,null,null,null,null,null,null,null,null,10,26494,35237.020000000004]
["Total Capital Expenditure",null,{"$f":"SUM(C47:C51)","v":0},0,0,0,0,0,null,null,null,9,26108,34723.64]
[null,null,null,null,null,null,null,null,null,null,null,8,25823,34344.590000000004]
["Savings & Strategic funding",null,"2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes",null,null,7,25533,33958.89]
[null,null,null,null,null,null,null,null,null,null,null,6,0,0]
["QMUL Pay",null,0,{"$f":"C56*(1+'General Assumptions'!C11)","v":0},{"$f":"D56*(1+'General Assumptions'!D12)","v":0},{"$f":"E56*(1+'General Assumptions'!E12)","v":0},{"$f":"F56*(1+'General Assumptions'!F12)","v":0},{"$f":"G56*(1+'General Assumptions'!G12)","v":0},null,null,null,5,0,0]
["QMUL Non Pay",null,0,{"$f":"C57*(1+'General Assumptions'!C12)","v":0},{"$f":"D57*(1+'General Assumptions'!D12)","v":0},{"$f":"E57*(1+'General Assumptions'!E12)","v":0},{"$f":"F57*(1+'General Assumptions'!F12)","v":0},{"$f":"G57*(1+'General Assumptions'!G12)","v":0},null,null,null,4,0,0]
["Faculty Strategic funding",null,0,0,0,0,0,0,null,null,null,"Select Spinal Point",0,0]
["QMUL Strategic funding",null,0,0,0,0,0,0,null,null,null,3,0,{"$f":"+M59*$L$3","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,2,0,{"$f":"+M60*$L$3","v":0}]
["Total Savings & Strategic funding",null,{"$f":"SUM(C55:C60)","v":0},0,0,0,0,0,null,null,null,1,0,{"$f":"+M61*$L$3","v":0}]
[]
["QMUL existing pay resources utilised - For information only *"]
[]
[null,null,"2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","Notes"]
[]
["QMUL FTE"]
["Clinical Professor",null,0,{"$f":"+C68","v":0},{"$f":"+D68","v":0},{"$f":"+E68","v":0},{"$f":"+E68","v":0},{"$f":"+F68","v":0}]
["Clinical Reader/Senior Lecturer",null,0,0,0,0,0,0]
["Clinical Lecturer",null,0,0,0,0,0,0]
["Non-clinical professor",null,0,0,0,0,0,0]
["Reader / senior lecturer",null,0,0,0,0,0,0]
["Lecturer",null,0,0,0,0,0,0]
["Academic & professional support (within institute)",null,0,0,0,0,0,0]
["Teaching assistants",null,0,0,0,0,0,0]
["Other",null,0,0,0,0,0,0]
[]
["Total existing QMUL FTE",null,{"$f":"SUM(C67:C77)","v":0},0,0,0,0,0]
[]
["QMUL Pay","Grade"]
["Clinical Professor","Select Grade",{"$f":"+C68*$AE23","v":0},{"$f":"+D68*$AE23*(1+'General Assumptions'!$B$10)","v":0},{"$f":"+E68*$AE23*(1+'General Assumptions'!$B$10)^2","v":0},{"$f":"+F68*$AE23*(1+'General Assumptions'!$B$10)^3","v":0},{"$f":"+G68*$AE23*(1+'General Assumptions'!$B$10)^4","v":0},{"$f":"+H68*$AE23*(1+'General Assumptions'!$B$10)^5","v":0}]
["Clinical Reader/Senior Lecturer","Select Grade",{"$f":"+C69*$W24","v":0},{"$f":"+D69*$W24*(1+'General Assumptions'!$B$10)","v":0},{"$f":"+E69*$W24*(1+'General Assumptions'!$B$10)^2","v":0},{"$f":"+F69*$W24*(1+'General Assumptions'!$B$10)^3","v":0},{"$f":"+G69*$W24*(1+'General Assumptions'!$B$10)^4","v":0},{"$f":"+H69*$W24*(1+'General Assumptions'!$B$10)^5","v":0}]
["Clinical Lecturer","Select Grade",{"$f":"+C70*$W25","v":0},{"$f":"+D70*$W25*(1+'General Assumptions'!$B$10)","v":0},{"$f":"+E70*$W25*(1+'General Assumptions'!$B$10)^2","v":0},{"$f":"+F70*$W25*(1+'General Assumptions'!$B$10)^3","v":0},{"$f":"+G70*$W25*(1+'General Assumptions'!$B$10)^4","v":0},{"$f":"+H70*$W25*(1+'General Assumptions'!$B$10)^5","v":0}]
["Non-clinical professor","Select Grade",{"$f":"+C71*$AE26","v":0},{"$f":"+D71*$AE26*(1+'General Assumptions'!$B$10)","v":0},{"$f":"+E71*$AE26*(1+'General Assumptions'!$B$10)^2","v":0},{"$f":"+F71*$AE26*(1+'General Assumptions'!$B$10)^3","v":0},{"$f":"+G71*$AE26*(1+'General Assumptions'!$B$10)^4","v":0},{"$f":"+H71*$AE26*(1+'General Assumptions'!$B$10)^5","v":0}]
["Reader / senior lecturer","Select Grade",{"$f":"+C72*$W27","v":0},{"$f":"+D72*$W27*(1+'General Assumptions'!$B$10)","v":0},{"$f":"+E72*$W27*(1+'General Assumptions'!$B$10)^2","v":0},{"$f":"+F72*$W27*(1+'General Assumptions'!$B$10)^3","v":0},{"$f":"+G72*$W27*(1+'General Assumptions'!$B$10)^4","v":0},{"$f":"+H72*$W27*(1+'General Assumptions'!$B$10)^5","v":0}]
["Lecturer","Select Grade",{"$f":"+C73*$W28","v":0},{"$f":"+D73*$W28*(1+'General Assumptions'!$B$10)","v":0},{"$f":"+E73*$W28*(1+'General Assumptions'!$B$10)^2","v":0},{"$f":"+F73*$W28*(1+'General Assumptions'!$B$10)^3","v":0},{"$f":"+G73*$W28*(1+'General Assumptions'!$B$10)^4","v":0},{"$f":"+H73*$W28*(1+'General Assumptions'!$B$10)^5","v":0}]
["Academic & professional support (within institute)","Select Grade",{"$f":"+C74*$P29","v":0},{"$f":"+D74*$P29*(1+'General Assumptions'!$B$10)","v":0},{"$f":"+E74*$P29*(1+'General Assumptions'!$B$10)^2","v":0},{"$f":"+F74*$P29*(1+'General Assumptions'!$B$10)^3","v":0},{"$f":"+G74*$P29*(1+'General Assumptions'!$B$10)^4","v":0},{"$f":"+H74*$P29*(1+'General Assumptions'!$B$10)^5","v":0}]
["Teaching assistants","Select Grade",{"$f":"+C75*$P30","v":0},{"$f":"+D75*$P30*(1+'General Assumptions'!$B$10)","v":0},{"$f":"+E75*$P30*(1+'General Assumptions'!$B$10)^2","v":0},{"$f":"+F75*$P30*(1+'General Assumptions'!$B$10)^3","v":0},{"$f":"+G75*$P30*(1+'General Assumptions'!$B$10)^4","v":0},{"$f":"+H75*$P30*(1+'General Assumptions'!$B$10)^5","v":0}]
["Other","Select Grade",{"$f":"+C76*$P31","v":0},{"$f":"+D76*$P31*(1+'General Assumptions'!$B$10)","v":0},{"$f":"+E76*$P31*(1+'General Assumptions'!$B$10)^2","v":0},{"$f":"+F76*$P31*(1+'General Assumptions'!$B$10)^3","v":0},{"$f":"+G76*$P31*(1+'General Assumptions'!$B$10)^4","v":0},{"$f":"+H76*$P31*(1+'General Assumptions'!$B$10)^5","v":0}]
[]
["Total existing QMUL Pay",null,{"$f":"SUM(C81:C90)","v":0},0,0,0,0,0]
[]
["* Include pay costs of existing resources being utilised to deliver new programme / research initiative etc."]

{"sheet":"General Assumptions","index":3,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["General Assumptions"]
[]
["Inflation","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
["Tuition fees - Home",0.02,0.02,0.02,0.02,0.02,0.02]
["Tuition fees - Overseas",0.05,0.05,0.05,0.05,0.05,0.03]
["Progression Y1 to Y2",{"$f":"1-12.3%","v":0.877},{"$f":"B7","v":0.877},{"$f":"C7","v":0.877},0.877,0.877,0.877]
["Progression Y2 to Y3",{"$f":"1-4.9%","v":0.95099999999999996},{"$f":"B8","v":0.95099999999999996},0.95099999999999996,0.95099999999999996,0.95099999999999996,0.95099999999999996]
["Other income",0.02,0.02,0.02,0.02,0.02,0.02]
["Pay *",3.5000000000000003E-2,3.5000000000000003E-2,2.5000000000000001E-2,2.5000000000000001E-2,0.02,0.02]
["Compound pay inflation",1,{"$f":"+B11*1+C10","v":1.0349999999999999},{"$f":"+C11*1+D10","v":1.0599999999999998},1.0849999999999997,1.1049999999999998,1.1249999999999998]
["Non pay",0.02,0.02,0.02,0.02,0.02,0.02]
["Overseas students recruited by agents - UG",0.5,0.5,0.5,0.5,0.5,0.5]
["Overseas students recruited by agents - PGT",0.5,0.5,0.5,0.5,0.5,0.5]
["Agents Commission",0.15,{"$f":"B15","v":0.15},{"$f":"C15","v":0.15},0.15,0.15,0.15]
[]
["Funding body rate assumptions","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
["OFS Price group A - UG rate",10000,{"$f":"+B19","v":10000},10000,10000,10000,10000]
["OFS Price group B - UG rate",1500,1500,1500,1500,1500,1500]
["OFS Price group C1.1 - UG rate",250,250,250,250,250,250]
["OFS Price group C1.2 - UG rate",120,120,120,120,120,120]
["OFS Price group C2 - UG rate",0,0,0,0,0,0]
["OFS Price group D - UG rate",0,0,0,0,0,0]
["OFS Price group A - PGT rate",10000,{"$f":"+B25","v":10000},10000,10000,10000,10000]
["OFS Price group B - PGT rate",1500,{"$f":"+B26","v":1500},1500,1500,1500,1500]
["OFS Price group C1.1 - PGT rate",250,250,250,250,250,250]
["OFS Price group C1.2 - PGT rate",120,120,120,120,120,120]
["OFS Price group C2 - PGT rate",0,0,0,0,0,0]
["OFS Price group D - PGT rate",0,0,0,0,0,0]
["RDP funding rate",4870,{"$f":"+B31","v":4870},4870,4870,4870,4870]
["QR on charitable income (Incl 12% LW)",0.19,0.19,0.19,0.19,0.19,0.19]
[]
["Research mix","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30","Notes"]
[]
["Pay",0.65,0.62,0.62,0.62,0.62,0.62]
["Non pay",0.35,0.38,0.38,0.38,0.38,0.38]
[]
["Bursaries ","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
[]
["Bursary % of total UG Home/EU income",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2]
[]
["* Payscales based on August 2023"]