{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Summary","Assumptions","Input Form","By Term Summary","General Input","UG Trad Input","UG Non-Trad Input","Grad Input","Certificate Input","Endow&Gift Input","Expense Input","DEFS","prt_T_UG","prt_NT_UG","prt_GRAD","prt_CERT_FR","prt_CERT_CH","prt_OthRev","prt_Expenses"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":549,"comments":2,"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":94,"n_cols":7,"rows_kept":94,"cut":false,"hidden":false,"merged":[[95,0,95,6]]}
["Creighton University"]
[{"$f":"IF(ISBLANK('General Input'!B5),\"\",'General Input'!B5)","v":""}]
[{"$f":"IF(ISBLANK('General Input'!B7),\"\",'General Input'!B7)","v":""}]
[{"$f":"IF(ISBLANK('General Input'!B6),\"\",'General Input'!B6)","v":""},"2014-2015","2015-2016","2016-2017","2017-2018","2018-2019"]
["Five Year Financial Projections","Year 1","Year 2","Year 3","Year 4","Year 5","5 Year Total"]
[{"$f":"CONCATENATE(\"Contact\",\":\",\" \",'General Input'!B8)","v":"Contact: "},"Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year","Fiscal Year"]
["Revenue"]
["  Tuition"]
["    Tuition",{"$f":"SUM('By Term Summary'!B9:H9)","v":0},{"$f":"SUM('By Term Summary'!I9:O9)","v":0},{"$f":"SUM('By Term Summary'!P9:V9)","v":0},{"$f":"SUM('By Term Summary'!W9:AC9)","v":0},{"$f":"SUM('By Term Summary'!AD9:AJ9)","v":0},{"$f":"SUM(B9:F9)","v":0}]
["    Tuition Discounts",{"$f":"SUM('By Term Summary'!B10:H10)","v":0},{"$f":"SUM('By Term Summary'!I10:O10)","v":0},{"$f":"SUM('By Term Summary'!P10:V10)","v":0},{"$f":"SUM('By Term Summary'!W10:AC10)","v":0},{"$f":"SUM('By Term Summary'!AD10:AJ10)","v":0},{"$f":"SUM(B10:F10)","v":0}]
["  Net Tuition",{"$f":"SUM(B9:B10)","v":0},0,0,0,0,0]
[]
["Endowment Income",{"$f":"SUM('By Term Summary'!B13:H13)","v":0},{"$f":"SUM('By Term Summary'!I13:O13)","v":0},{"$f":"SUM('By Term Summary'!P13:V13)","v":0},{"$f":"SUM('By Term Summary'!W13:AC13)","v":0},{"$f":"SUM('By Term Summary'!AD13:AJ13)","v":0},{"$f":"SUM(B13:F13)","v":0}]
["Gift Income",{"$f":"SUM('By Term Summary'!B14:H14)","v":0},{"$f":"SUM('By Term Summary'!I14:O14)","v":0},{"$f":"SUM('By Term Summary'!P14:V14)","v":0},{"$f":"SUM('By Term Summary'!W14:AC14)","v":0},{"$f":"SUM('By Term Summary'!AD14:AJ14)","v":0},{"$f":"SUM(B14:F14)","v":0}]
["Other Revenue",{"$f":"SUM('By Term Summary'!B15:H15)","v":0},{"$f":"SUM('By Term Summary'!I15:O15)","v":0},{"$f":"SUM('By Term Summary'!P15:V15)","v":0},{"$f":"SUM('By Term Summary'!W15:AC15)","v":0},{"$f":"SUM('By Term Summary'!AD15:AJ15)","v":0},{"$f":"SUM(B15:F15)","v":0}]
["Total Revenue",{"$f":"SUM(B11:B15)","v":0},0,0,0,0,0]
[]
["Expense"]
["Faculty Salaries ",{"$f":"SUM('By Term Summary'!B19:H19)","v":0},{"$f":"SUM('By Term Summary'!I19:O19)","v":0},{"$f":"SUM('By Term Summary'!P19:V19)","v":0},{"$f":"SUM('By Term Summary'!W19:AC19)","v":0},{"$f":"SUM('By Term Summary'!AD19:AJ19)","v":0},{"$f":"SUM(B19:F19)","v":0}]
["Adjunct faculty ",{"$f":"SUM('By Term Summary'!B20:H20)","v":0},{"$f":"SUM('By Term Summary'!I20:O20)","v":0},{"$f":"SUM('By Term Summary'!P20:V20)","v":0},{"$f":"SUM('By Term Summary'!W20:AC20)","v":0},{"$f":"SUM('By Term Summary'!AD20:AJ20)","v":0},{"$f":"SUM(B20:F20)","v":0}]
["Staff Salaries ",{"$f":"SUM('By Term Summary'!B21:H21)","v":0},{"$f":"SUM('By Term Summary'!I21:O21)","v":0},{"$f":"SUM('By Term Summary'!P21:V21)","v":0},{"$f":"SUM('By Term Summary'!W21:AC21)","v":0},{"$f":"SUM('By Term Summary'!AD21:AJ21)","v":0},0]
["Course development stipends",{"$f":"SUM('By Term Summary'!B22:H22)","v":0},{"$f":"SUM('By Term Summary'!I22:O22)","v":0},{"$f":"SUM('By Term Summary'!P22:V22)","v":0},{"$f":"SUM('By Term Summary'!W22:AC22)","v":0},{"$f":"SUM('By Term Summary'!AD22:AJ22)","v":0},0]
["Other Salaries",{"$f":"SUM('By Term Summary'!B23:H23)","v":0},{"$f":"SUM('By Term Summary'!I23:O23)","v":0},{"$f":"SUM('By Term Summary'!P23:V23)","v":0},{"$f":"SUM('By Term Summary'!W23:AC23)","v":0},{"$f":"SUM('By Term Summary'!AD23:AJ23)","v":0},0]
["Total Salaries",{"$f":"SUM(B19:B23)","v":0},0,0,0,0,0]
[]
["Benefits",{"$f":"SUM('By Term Summary'!B26:H26)","v":0},{"$f":"SUM('By Term Summary'!I26:O26)","v":0},{"$f":"SUM('By Term Summary'!P26:V26)","v":0},{"$f":"SUM('By Term Summary'!W26:AC26)","v":0},{"$f":"SUM('By Term Summary'!AD26:AJ26)","v":0},{"$f":"SUM(B26:F26)","v":0}]
[]
["Non Capital Expenses",{"$f":"SUM('By Term Summary'!B27:H27)","v":25000},{"$f":"SUM('By Term Summary'!I27:O27)","v":25000},{"$f":"SUM('By Term Summary'!P27:V27)","v":25000},{"$f":"SUM('By Term Summary'!W27:AC27)","v":25000},{"$f":"SUM('By Term Summary'!AD27:AJ27)","v":25000},{"$f":"SUM(B28:F28)","v":125000}]
["Capital Expenditures",{"$f":"SUM('By Term Summary'!B28:H28)","v":0},{"$f":"SUM('By Term Summary'!I28:O28)","v":0},{"$f":"SUM('By Term Summary'!P28:V28)","v":0},{"$f":"SUM('By Term Summary'!W28:AC28)","v":0},{"$f":"SUM('By Term Summary'!AD28:AJ28)","v":0},{"$f":"SUM(B29:F29)","v":0}]
["Other Initial Investment",{"$f":"SUM('By Term Summary'!B29:H29)","v":0},{"$f":"SUM('By Term Summary'!I29:O29)","v":0},{"$f":"SUM('By Term Summary'!P29:V29)","v":0},{"$f":"SUM('By Term Summary'!W29:AC29)","v":0},{"$f":"SUM('By Term Summary'!AD29:AJ29)","v":0},{"$f":"SUM(B30:F30)","v":0}]
["Total Expense",{"$f":"SUM(B24:B30)","v":25000},{"$f":"SUM(C24:C30)","v":25000},25000,25000,25000,125000]
[]
["Transfers",{"$f":"SUM('By Term Summary'!B32:H32)","v":0},{"$f":"SUM('By Term Summary'!I32:O32)","v":0},{"$f":"SUM('By Term Summary'!D32:J32)","v":0},{"$f":"SUM('By Term Summary'!W32:AC32)","v":0},{"$f":"SUM('By Term Summary'!AD32:AJ32)","v":0},{"$f":"SUM(B33:F33)","v":0}]
[]
["Contribution Margin",{"$f":"B16-B31-B33","v":-25000},-25000,-25000,-25000,-25000,-125000]
["Contribution Margin %",{"$f":"B35/B16","v":{"$error":"#DIV/0!"}},{"$f":"C35/C16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Administrative Overhead",{"$f":"SUM('By Term Summary'!B36:H36)","v":0},{"$f":"SUM('By Term Summary'!I36:O36)","v":0},{"$f":"SUM('By Term Summary'!P36:V36)","v":0},{"$f":"SUM('By Term Summary'!W36:AC36)","v":0},{"$f":"SUM('By Term Summary'!AD36:AJ36)","v":0},{"$f":"SUM(B38:F38)","v":0}]
["Total Overhead",{"$f":"SUM(B38:B38)","v":0},0,0,0,0,0]
[]
["Net Margin",{"$f":"B35-B39","v":-25000},-25000,-25000,-25000,-25000,-125000]
["Net Margin %",{"$f":"B41/B16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Cash Flow*",{"$f":"B35","v":-25000},-25000,-25000,-25000,-25000,-125000]
["Accumulated Cash Flow",null,{"$f":"B44+C44","v":-50000},{"$f":"C45+D44","v":-75000},{"$f":"D45+E44","v":-100000},{"$f":"E45+F44","v":-125000}]
["Payback",{"$f":"IF(F45<=0,\"After Year 5\",IF(E45<=0,(F45)/F44+4,IF(D45<=0,(E45)/E44+3,IF(C45<=0,(D45)/D44+2,IF(B44<=0,(C45)/C44+1,(B31/B16))))))","v":"After Year 5"}]
[]
[]
["Reallocated Faculty and Staff"]
["Expense"]
["Faculty Salaries to be reallocated",{"$f":"SUM('By Term Summary'!B48:H48)","v":0},{"$f":"SUM('By Term Summary'!I48:O48)","v":0},{"$f":"SUM('By Term Summary'!P48:V48)","v":0},{"$f":"SUM('By Term Summary'!W48:AC48)","v":0},{"$f":"SUM('By Term Summary'!AD48:AJ48)","v":0},{"$f":"SUM(B51:F51)","v":0}]
["Adjunct faculty to be reallocated",{"$f":"SUM('By Term Summary'!B49:H49)","v":0},{"$f":"SUM('By Term Summary'!I49:O49)","v":0},{"$f":"SUM('By Term Summary'!P49:V49)","v":0},{"$f":"SUM('By Term Summary'!W49:AC49)","v":0},{"$f":"SUM('By Term Summary'!AD49:AJ49)","v":0},{"$f":"SUM(B52:F52)","v":0}]
["Staff to be reallocated",{"$f":"SUM('By Term Summary'!B50:H50)","v":0},{"$f":"SUM('By Term Summary'!I50:O50)","v":0},{"$f":"SUM('By Term Summary'!P50:V50)","v":0},{"$f":"SUM('By Term Summary'!W50:AC50)","v":0},{"$f":"SUM('By Term Summary'!AD50:AJ50)","v":0},0]
["Total Reallocated Salaries",{"$f":"SUM(B51:B53)","v":0},{"$f":"SUM(C51:C53)","v":0},0,0,0,0]
[]
["Benefits",{"$f":"SUM('By Term Summary'!B53:H53)","v":0},{"$f":"SUM('By Term Summary'!I53:O53)","v":0},{"$f":"SUM('By Term Summary'!P53:V53)","v":0},{"$f":"SUM('By Term Summary'!W53:AC53)","v":0},{"$f":"SUM('By Term Summary'!AD53:AJ53)","v":0},{"$f":"SUM(B56:F56)","v":0}]
["Total Expense",{"$f":"SUM(B54:B56)","v":0},{"$f":"SUM(C54:C56)","v":0},0,0,0,0]
[]
[]
["Net Less Reallocated Faculty and Staff"]
["Expense"]
["Faculty Salaries ",{"$f":"B19-B51","v":0},{"$f":"C19-C51","v":0},0,0,0,0]
["Adjunct faculty ",{"$f":"B20-B52","v":0},0,0,0,0,0]
["Staff Salaries ",{"$f":"B21-B53","v":0},0,0,0,0,0]
["Course development stipends",{"$f":"B22","v":0},{"$f":"C22","v":0},0,0,0,0]
["Other Salaries",{"$f":"B23","v":0},{"$f":"C23","v":0},0,0,0,0]
["Total Salaries",{"$f":"SUM(B62:B66)","v":0},{"$f":"SUM(C62:C66)","v":0},0,0,0,0]
[]
["Benefits",{"$f":"B26-B56","v":0},{"$f":"C26-C56","v":0},0,0,0,0]
[]
["Non Capital Expenses",{"$f":"B28","v":25000},25000,25000,25000,25000,125000]
["Capital Expenditures",0,0,0,0,0,0]
["Total Expense",{"$f":"SUM(B67:B72)","v":25000},25000,25000,25000,25000,125000]
[]
["Transfers",{"$f":"B33","v":0},0,0,0,0,0]
[]
["Contribution Margin",{"$f":"B16-B73-B75","v":-25000},-25000,-25000,-25000,-25000,-125000]
["Contribution Margin %",{"$f":"B77/B16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Administrative Overhead",{"$f":"SUM('By Term Summary'!B77:H77)","v":0},{"$f":"SUM('By Term Summary'!I77:O77)","v":0},{"$f":"SUM('By Term Summary'!P77:V77)","v":0},{"$f":"SUM('By Term Summary'!W77:AC77)","v":0},{"$f":"SUM('By Term Summary'!AD77:AJ77)","v":0},{"$f":"SUM(B80:F80)","v":0}]
["Total Overhead",{"$f":"SUM(B80:B80)","v":0},0,0,0,0,0]
[]
["Net Margin",{"$f":"B77-B81","v":-25000},-25000,-25000,-25000,-25000,-125000]
["Net Margin %",{"$f":"B83/B16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Cash Flow*",{"$f":"B77","v":-25000},-25000,-25000,-25000,-25000,-125000]
["Accumulated Cash Flow",null,{"$f":"B86+C86","v":-50000},{"$f":"C87+D86","v":-75000},{"$f":"D87+E86","v":-100000},{"$f":"E87+F86","v":-125000}]
["Payback",{"$f":"IF(F87<=0,\"After Year 5\",IF(E87<=0,(F86-F87)/F87+4,IF(D87<=0,(E86-E87)/E87+3,IF(C87<=0,(D86-D87)/D87+2,IF(B86<=0,(C86-C87)/C87+1,(B73/B16))))))","v":"After Year 5"}]
[]
["FTE Student Enrollment",{"$f":"SUM('By Term Summary'!B85:H85)","v":0},{"$f":"SUM('By Term Summary'!I85:O85)","v":0},{"$f":"SUM('By Term Summary'!P85:V85)","v":0},{"$f":"SUM('By Term Summary'!W85:AC85)","v":0},{"$f":"SUM('By Term Summary'!AD85:AJ85)","v":0},{"$f":"SUM(B90:F90)","v":0}]
["FTE Faculty Increase",{"$f":"SUM('By Term Summary'!B86:H86)","v":0},{"$f":"SUM('By Term Summary'!I86:O86)","v":0},{"$f":"SUM('By Term Summary'!P86:V86)","v":0},{"$f":"SUM('By Term Summary'!W86:AC86)","v":0},{"$f":"SUM('By Term Summary'!AD86:AJ86)","v":0},{"$f":"SUM(B91:F91)","v":0}]
["FTE Staff Increase",{"$f":"SUM('By Term Summary'!B87:H87)","v":0},{"$f":"SUM('By Term Summary'!I87:O87)","v":0},{"$f":"SUM('By Term Summary'!P87:V87)","v":0},{"$f":"SUM('By Term Summary'!W87:AC87)","v":0},{"$f":"SUM('By Term Summary'!AD87:AJ87)","v":0},{"$f":"SUM(B92:F92)","v":0}]
[]
["*Overhead is excluded from the cash flow calculations"]

{"sheet":"Assumptions","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,8,0,11]]}
[{"$f":"Summary!A1","v":"Creighton University"},null,null,null,null,null,null,null,"Legend:"]
[{"$f":"Summary!A2","v":""},null,null,null,null,null,null,null,null,"Standard assumption, no changes"]
[{"$f":"Summary!A6","v":"Contact: "},"2014-2015","2015-2016","2016-2017","2017-2018","2018-2019",null,null,null,"Assumption input cell"]
["General assumptions:","Year 1","Year 2","Year 3","Year 4","Year 5",null,null,null,"Calculated cell"]
["Program Type:"]
["Annual growth rate for tuition and fees",null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["Traditional undergraduate tuition rate per semester",16898,{"$f":"ROUND(B7*(1+C$6),0)","v":17320},17753,18197,18652,"2013-2014 actual"]
["Non-traditional undergraduate tuition rate",412,{"$f":"ROUND(B8*(1+C$6),0)","v":422},433,444,455,"Default is based on BILS program"]
["Graduate tuition rate",780,{"$f":"ROUND(B9*(1+C$6),0)","v":800},820,841,862,"Default is current grad per hour rate"]
["Flat rate certificate programs rate per student",1500,1538,1576,1615,1655]
["Credit hour based certificate programs rate per credit hour",780,800,820,841,862]
["Traditional undergraduate tuition discount rate per semester",0.47499999999999998,{"$f":"B12","v":0.47499999999999998},0.47499999999999998,0.47499999999999998,0.47499999999999998,"Based on fall 2013 incoming freshmen class rate"]
["Non-traditional undergraduate tuition discount rate per semester",0,0,0,0,0]
["Graduate tuition discount",0,0,0,0,0]
["Benefits rate",0.28599999999999998,0.28599999999999998,0.28599999999999998,0.28599999999999998,0.28599999999999998]
["Departmental costs as % of revenue",0.1,0.1,0.1,0.1,0.1]
["Program specific annual marketing costs",25000,25000,25000,25000,25000]
["Administrative overhead, including facilities & marketing",0.25600000000000001,0.25600000000000001,0.25600000000000001,0.25600000000000001,0.25600000000000001]
["Direct instructional expenses per student (excluded for online programs) ",150,150,150,150,150]
["Office start up costs for new faculty and staff (computer & phone)",1500,{"$f":"B20","v":1500},{"$f":"C20","v":1500},1500,1500]
[]
["Traditional undergraduate FTE calculation, assumes all full time"]
["Non-traditional undergraduate FTE calculation, assumes 24 credit hours per FTE"]
["Graduate enrollment FTE calculation assumes 20 credit hours per FTE"]
[]
["Additional assumptions used in model:"]

{"sheet":"Input Form","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["New Program Financial Projection Template",null,null,null,null,null,null,null,"version 2"]
[]
[null,"You may receive the following Security Warnings when you open this file:"]
[null,null,"Macros have been disabled."]
[null,null,null,"Click on \"Enable Content\""]
[]
[null,null,"Do you want to make this file a Trusted Document?"]
[null,null,null,"It's okay to click on \"Yes\""]
[]
[null,"Click on the button below to begin entering data in the form"]

{"sheet":"By Term Summary","index":3,"n_rows":89,"n_cols":36,"rows_kept":89,"cut":false,"hidden":true,"merged":[[4,1,4,7],[4,8,4,14],[4,15,4,21],[4,22,4,28],[4,29,4,35]]}
["Creighton University"]
[{"$f":"'General Input'!B5","v":0}]
[{"$f":"'General Input'!B7","v":0}]
[{"$f":"'General Input'!B6","v":0}]
["5 year financial projections","Year 1",null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,"Year 3",null,null,null,null,null,null,"Year 4",null,null,null,null,null,null,"Year 5"]
[null,"Summer Term 2","Fall Term 1","Fall Term 2","Winter Term","Spring Term 1","Spring Term 2","Summer Term 1","Summer Term 2","Fall Term 1","Fall Term 2","Winter Term","Spring Term 1","Spring Term 2","Summer Term 1","Summer Term 2","Fall Term 1","Fall Term 2","Winter Term","Spring Term 1","Spring Term 2","Summer Term 1","Summer Term 2","Fall Term 1","Fall Term 2","Winter Term","Spring Term 1","Spring Term 2","Summer Term 1","Summer Term 2","Fall Term 1","Fall Term 2","Winter Term","Spring Term 1","Spring Term 2","Summer Term 1"]
["Revenue"]
["  Tuition"]
["    Tuition",{"$f":"'UG Trad Input'!C13+'UG Non-Trad Input'!C14+'Grad Input'!C13+'Certificate Input'!C7+'Certificate Input'!C14","v":0},{"$f":"'UG Trad Input'!D13+'UG Non-Trad Input'!D14+'Grad Input'!D13+'Certificate Input'!D7+'Certificate Input'!D14","v":0},{"$f":"'UG Trad Input'!E13+'UG Non-Trad Input'!E14+'Grad Input'!E13+'Certificate Input'!E7+'Certificate Input'!E14","v":0},{"$f":"'UG Trad Input'!F13+'UG Non-Trad Input'!F14+'Grad Input'!F13+'Certificate Input'!F7+'Certificate Input'!F14","v":0},{"$f":"'UG Trad Input'!G13+'UG Non-Trad Input'!G14+'Grad Input'!G13+'Certificate Input'!G7+'Certificate Input'!G14","v":0},{"$f":"'UG Trad Input'!H13+'UG Non-Trad Input'!H14+'Grad Input'!H13+'Certificate Input'!H7+'Certificate Input'!H14","v":0},{"$f":"'UG Trad Input'!I13+'UG Non-Trad Input'!I14+'Grad Input'!I13+'Certificate Input'!I7+'Certificate Input'!I14","v":0},{"$f":"'UG Trad Input'!J13+'UG Non-Trad Input'!J14+'Grad Input'!J13+'Certificate Input'!J7+'Certificate Input'!J14","v":0},{"$f":"'UG Trad Input'!K13+'UG Non-Trad Input'!K14+'Grad Input'!K13+'Certificate Input'!K7+'Certificate Input'!K14","v":0},{"$f":"'UG Trad Input'!L13+'UG Non-Trad Input'!L14+'Grad Input'!L13+'Certificate Input'!L7+'Certificate Input'!L14","v":0},{"$f":"'UG Trad Input'!M13+'UG Non-Trad Input'!M14+'Grad Input'!M13+'Certificate Input'!M7+'Certificate Input'!M14","v":0},{"$f":"'UG Trad Input'!N13+'UG Non-Trad Input'!N14+'Grad Input'!N13+'Certificate Input'!N7+'Certificate Input'!N14","v":0},{"$f":"'UG Trad Input'!O13+'UG Non-Trad Input'!O14+'Grad Input'!O13+'Certificate Input'!O7+'Certificate Input'!O14","v":0},{"$f":"'UG Trad Input'!P13+'UG Non-Trad Input'!P14+'Grad Input'!P13+'Certificate Input'!P7+'Certificate Input'!P14","v":0},{"$f":"'UG Trad Input'!Q13+'UG Non-Trad Input'!Q14+'Grad Input'!Q13+'Certificate Input'!Q7+'Certificate Input'!Q14","v":0},{"$f":"'UG Trad Input'!R13+'UG Non-Trad Input'!R14+'Grad Input'!R13+'Certificate Input'!R7+'Certificate Input'!R14","v":0},{"$f":"'UG Trad Input'!S13+'UG Non-Trad Input'!S14+'Grad Input'!S13+'Certificate Input'!S7+'Certificate Input'!S14","v":0},{"$f":"'UG Trad Input'!T13+'UG Non-Trad Input'!T14+'Grad Input'!T13+'Certificate Input'!T7+'Certificate Input'!T14","v":0},{"$f":"'UG Trad Input'!U13+'UG Non-Trad Input'!U14+'Grad Input'!U13+'Certificate Input'!U7+'Certificate Input'!U14","v":0},{"$f":"'UG Trad Input'!V13+'UG Non-Trad Input'!V14+'Grad Input'!V13+'Certificate Input'!V7+'Certificate Input'!V14","v":0},{"$f":"'UG Trad Input'!W13+'UG Non-Trad Input'!W14+'Grad Input'!W13+'Certificate Input'!W7+'Certificate Input'!W14","v":0},{"$f":"'UG Trad Input'!X13+'UG Non-Trad Input'!X14+'Grad Input'!X13+'Certificate Input'!X7+'Certificate Input'!X14","v":0},{"$f":"'UG Trad Input'!Y13+'UG Non-Trad Input'!Y14+'Grad Input'!Y13+'Certificate Input'!Y7+'Certificate Input'!Y14","v":0},{"$f":"'UG Trad Input'!Z13+'UG Non-Trad Input'!Z14+'Grad Input'!Z13+'Certificate Input'!Z7+'Certificate Input'!Z14","v":0},{"$f":"'UG Trad Input'!AA13+'UG Non-Trad Input'!AA14+'Grad Input'!AA13+'Certificate Input'!AA7+'Certificate Input'!AA14","v":0},{"$f":"'UG Trad Input'!AB13+'UG Non-Trad Input'!AB14+'Grad Input'!AB13+'Certificate Input'!AB7+'Certificate Input'!AB14","v":0},{"$f":"'UG Trad Input'!AC13+'UG Non-Trad Input'!AC14+'Grad Input'!AC13+'Certificate Input'!AC7+'Certificate Input'!AC14","v":0},{"$f":"'UG Trad Input'!AD13+'UG Non-Trad Input'!AD14+'Grad Input'!AD13+'Certificate Input'!AD7+'Certificate Input'!AD14","v":0},{"$f":"'UG Trad Input'!AE13+'UG Non-Trad Input'!AE14+'Grad Input'!AE13+'Certificate Input'!AE7+'Certificate Input'!AE14","v":0},{"$f":"'UG Trad Input'!AF13+'UG Non-Trad Input'!AF14+'Grad Input'!AF13+'Certificate Input'!AF7+'Certificate Input'!AF14","v":0},{"$f":"'UG Trad Input'!AG13+'UG Non-Trad Input'!AG14+'Grad Input'!AG13+'Certificate Input'!AG7+'Certificate Input'!AG14","v":0},{"$f":"'UG Trad Input'!AH13+'UG Non-Trad Input'!AH14+'Grad Input'!AH13+'Certificate Input'!AH7+'Certificate Input'!AH14","v":0},{"$f":"'UG Trad Input'!AI13+'UG Non-Trad Input'!AI14+'Grad Input'!AI13+'Certificate Input'!AI7+'Certificate Input'!AI14","v":0},{"$f":"'UG Trad Input'!AJ13+'UG Non-Trad Input'!AJ14+'Grad Input'!AJ13+'Certificate Input'!AJ7+'Certificate Input'!AJ14","v":0},{"$f":"'UG Trad Input'!AK13+'UG Non-Trad Input'!AK14+'Grad Input'!AK13+'Certificate Input'!AK7+'Certificate Input'!AK14","v":0}]
["    Tuition Discounts",{"$f":"'UG Trad Input'!C14+'UG Non-Trad Input'!C15+'Grad Input'!C14","v":0},{"$f":"'UG Trad Input'!D14+'UG Non-Trad Input'!D15+'Grad Input'!D14","v":0},{"$f":"'UG Trad Input'!E14+'UG Non-Trad Input'!E15+'Grad Input'!E14","v":0},{"$f":"'UG Trad Input'!F14+'UG Non-Trad Input'!F15+'Grad Input'!F14","v":0},{"$f":"'UG Trad Input'!G14+'UG Non-Trad Input'!G15+'Grad Input'!G14","v":0},{"$f":"'UG Trad Input'!H14+'UG Non-Trad Input'!H15+'Grad Input'!H14","v":0},{"$f":"'UG Trad Input'!I14+'UG Non-Trad Input'!I15+'Grad Input'!I14","v":0},{"$f":"'UG Trad Input'!J14+'UG Non-Trad Input'!J15+'Grad Input'!J14","v":0},{"$f":"'UG Trad Input'!K14+'UG Non-Trad Input'!K15+'Grad Input'!K14","v":0},{"$f":"'UG Trad Input'!L14+'UG Non-Trad Input'!L15+'Grad Input'!L14","v":0},{"$f":"'UG Trad Input'!M14+'UG Non-Trad Input'!M15+'Grad Input'!M14","v":0},{"$f":"'UG Trad Input'!N14+'UG Non-Trad Input'!N15+'Grad Input'!N14","v":0},{"$f":"'UG Trad Input'!O14+'UG Non-Trad Input'!O15+'Grad Input'!O14","v":0},{"$f":"'UG Trad Input'!P14+'UG Non-Trad Input'!P15+'Grad Input'!P14","v":0},{"$f":"'UG Trad Input'!Q14+'UG Non-Trad Input'!Q15+'Grad Input'!Q14","v":0},{"$f":"'UG Trad Input'!R14+'UG Non-Trad Input'!R15+'Grad Input'!R14","v":0},{"$f":"'UG Trad Input'!S14+'UG Non-Trad Input'!S15+'Grad Input'!S14","v":0},{"$f":"'UG Trad Input'!T14+'UG Non-Trad Input'!T15+'Grad Input'!T14","v":0},{"$f":"'UG Trad Input'!U14+'UG Non-Trad Input'!U15+'Grad Input'!U14","v":0},{"$f":"'UG Trad Input'!V14+'UG Non-Trad Input'!V15+'Grad Input'!V14","v":0},{"$f":"'UG Trad Input'!W14+'UG Non-Trad Input'!W15+'Grad Input'!W14","v":0},{"$f":"'UG Trad Input'!X14+'UG Non-Trad Input'!X15+'Grad Input'!X14","v":0},{"$f":"'UG Trad Input'!Y14+'UG Non-Trad Input'!Y15+'Grad Input'!Y14","v":0},{"$f":"'UG Trad Input'!Z14+'UG Non-Trad Input'!Z15+'Grad Input'!Z14","v":0},{"$f":"'UG Trad Input'!AA14+'UG Non-Trad Input'!AA15+'Grad Input'!AA14","v":0},{"$f":"'UG Trad Input'!AB14+'UG Non-Trad Input'!AB15+'Grad Input'!AB14","v":0},{"$f":"'UG Trad Input'!AC14+'UG Non-Trad Input'!AC15+'Grad Input'!AC14","v":0},{"$f":"'UG Trad Input'!AD14+'UG Non-Trad Input'!AD15+'Grad Input'!AD14","v":0},{"$f":"'UG Trad Input'!AE14+'UG Non-Trad Input'!AE15+'Grad Input'!AE14","v":0},{"$f":"'UG Trad Input'!AF14+'UG Non-Trad Input'!AF15+'Grad Input'!AF14","v":0},{"$f":"'UG Trad Input'!AG14+'UG Non-Trad Input'!AG15+'Grad Input'!AG14","v":0},{"$f":"'UG Trad Input'!AH14+'UG Non-Trad Input'!AH15+'Grad Input'!AH14","v":0},{"$f":"'UG Trad Input'!AI14+'UG Non-Trad Input'!AI15+'Grad Input'!AI14","v":0},{"$f":"'UG Trad Input'!AJ14+'UG Non-Trad Input'!AJ15+'Grad Input'!AJ14","v":0},{"$f":"'UG Trad Input'!AK14+'UG Non-Trad Input'!AK15+'Grad Input'!AK14","v":0}]
["  Net Tuition",{"$f":"SUM(B9:B10)","v":0},{"$f":"SUM(C9:C10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Endowment Income",{"$f":"'Endow&Gift Input'!C4","v":0},{"$f":"'Endow&Gift Input'!D4","v":0},{"$f":"'Endow&Gift Input'!E4","v":0},{"$f":"'Endow&Gift Input'!F4","v":0},{"$f":"'Endow&Gift Input'!G4","v":0},{"$f":"'Endow&Gift Input'!H4","v":0},{"$f":"'Endow&Gift Input'!I4","v":0},{"$f":"'Endow&Gift Input'!J4","v":0},{"$f":"'Endow&Gift Input'!K4","v":0},{"$f":"'Endow&Gift Input'!L4","v":0},{"$f":"'Endow&Gift Input'!M4","v":0},{"$f":"'Endow&Gift Input'!N4","v":0},{"$f":"'Endow&Gift Input'!O4","v":0},{"$f":"'Endow&Gift Input'!P4","v":0},{"$f":"'Endow&Gift Input'!Q4","v":0},{"$f":"'Endow&Gift Input'!R4","v":0},{"$f":"'Endow&Gift Input'!S4","v":0},{"$f":"'Endow&Gift Input'!T4","v":0},{"$f":"'Endow&Gift Input'!U4","v":0},{"$f":"'Endow&Gift Input'!V4","v":0},{"$f":"'Endow&Gift Input'!W4","v":0},{"$f":"'Endow&Gift Input'!X4","v":0},{"$f":"'Endow&Gift Input'!Y4","v":0},{"$f":"'Endow&Gift Input'!Z4","v":0},{"$f":"'Endow&Gift Input'!AA4","v":0},{"$f":"'Endow&Gift Input'!AB4","v":0},{"$f":"'Endow&Gift Input'!AC4","v":0},{"$f":"'Endow&Gift Input'!AD4","v":0},{"$f":"'Endow&Gift Input'!AE4","v":0},{"$f":"'Endow&Gift Input'!AF4","v":0},{"$f":"'Endow&Gift Input'!AG4","v":0},{"$f":"'Endow&Gift Input'!AH4","v":0},{"$f":"'Endow&Gift Input'!AI4","v":0},{"$f":"'Endow&Gift Input'!AJ4","v":0},{"$f":"'Endow&Gift Input'!AK4","v":0}]
["Gift Income",{"$f":"'Endow&Gift Input'!C5","v":0},{"$f":"'Endow&Gift Input'!D5","v":0},{"$f":"'Endow&Gift Input'!E5","v":0},{"$f":"'Endow&Gift Input'!F5","v":0},{"$f":"'Endow&Gift Input'!G5","v":0},{"$f":"'Endow&Gift Input'!H5","v":0},{"$f":"'Endow&Gift Input'!I5","v":0},{"$f":"'Endow&Gift Input'!J5","v":0},{"$f":"'Endow&Gift Input'!K5","v":0},{"$f":"'Endow&Gift Input'!L5","v":0},{"$f":"'Endow&Gift Input'!M5","v":0},{"$f":"'Endow&Gift Input'!N5","v":0},{"$f":"'Endow&Gift Input'!O5","v":0},{"$f":"'Endow&Gift Input'!P5","v":0},{"$f":"'Endow&Gift Input'!Q5","v":0},{"$f":"'Endow&Gift Input'!R5","v":0},{"$f":"'Endow&Gift Input'!S5","v":0},{"$f":"'Endow&Gift Input'!T5","v":0},{"$f":"'Endow&Gift Input'!U5","v":0},{"$f":"'Endow&Gift Input'!V5","v":0},{"$f":"'Endow&Gift Input'!W5","v":0},{"$f":"'Endow&Gift Input'!X5","v":0},{"$f":"'Endow&Gift Input'!Y5","v":0},{"$f":"'Endow&Gift Input'!Z5","v":0},{"$f":"'Endow&Gift Input'!AA5","v":0},{"$f":"'Endow&Gift Input'!AB5","v":0},{"$f":"'Endow&Gift Input'!AC5","v":0},{"$f":"'Endow&Gift Input'!AD5","v":0},{"$f":"'Endow&Gift Input'!AE5","v":0},{"$f":"'Endow&Gift Input'!AF5","v":0},{"$f":"'Endow&Gift Input'!AG5","v":0},{"$f":"'Endow&Gift Input'!AH5","v":0},{"$f":"'Endow&Gift Input'!AI5","v":0},{"$f":"'Endow&Gift Input'!AJ5","v":0},{"$f":"'Endow&Gift Input'!AK5","v":0}]
["Other Revenue",{"$f":"'Endow&Gift Input'!C6","v":0},{"$f":"'Endow&Gift Input'!D6","v":0},{"$f":"'Endow&Gift Input'!E6","v":0},{"$f":"'Endow&Gift Input'!F6","v":0},{"$f":"'Endow&Gift Input'!G6","v":0},{"$f":"'Endow&Gift Input'!H6","v":0},{"$f":"'Endow&Gift Input'!I6","v":0},{"$f":"'Endow&Gift Input'!J6","v":0},{"$f":"'Endow&Gift Input'!K6","v":0},{"$f":"'Endow&Gift Input'!L6","v":0},{"$f":"'Endow&Gift Input'!M6","v":0},{"$f":"'Endow&Gift Input'!N6","v":0},{"$f":"'Endow&Gift Input'!O6","v":0},{"$f":"'Endow&Gift Input'!P6","v":0},{"$f":"'Endow&Gift Input'!Q6","v":0},{"$f":"'Endow&Gift Input'!R6","v":0},{"$f":"'Endow&Gift Input'!S6","v":0},{"$f":"'Endow&Gift Input'!T6","v":0},{"$f":"'Endow&Gift Input'!U6","v":0},{"$f":"'Endow&Gift Input'!V6","v":0},{"$f":"'Endow&Gift Input'!W6","v":0},{"$f":"'Endow&Gift Input'!X6","v":0},{"$f":"'Endow&Gift Input'!Y6","v":0},{"$f":"'Endow&Gift Input'!Z6","v":0},{"$f":"'Endow&Gift Input'!AA6","v":0},{"$f":"'Endow&Gift Input'!AB6","v":0},{"$f":"'Endow&Gift Input'!AC6","v":0},{"$f":"'Endow&Gift Input'!AD6","v":0},{"$f":"'Endow&Gift Input'!AE6","v":0},{"$f":"'Endow&Gift Input'!AF6","v":0},{"$f":"'Endow&Gift Input'!AG6","v":0},{"$f":"'Endow&Gift Input'!AH6","v":0},{"$f":"'Endow&Gift Input'!AI6","v":0},{"$f":"'Endow&Gift Input'!AJ6","v":0},{"$f":"'Endow&Gift Input'!AK6","v":0}]
["Total Revenue",{"$f":"SUM(B11:B15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Expense"]
["Faculty Salaries ",{"$f":"'Expense Input'!C6","v":0},{"$f":"'Expense Input'!D6","v":0},{"$f":"'Expense Input'!E6","v":0},{"$f":"'Expense Input'!F6","v":0},{"$f":"'Expense Input'!G6","v":0},{"$f":"'Expense Input'!H6","v":0},{"$f":"'Expense Input'!I6","v":0},{"$f":"'Expense Input'!J6","v":0},{"$f":"'Expense Input'!K6","v":0},{"$f":"'Expense Input'!L6","v":0},{"$f":"'Expense Input'!M6","v":0},{"$f":"'Expense Input'!N6","v":0},{"$f":"'Expense Input'!O6","v":0},{"$f":"'Expense Input'!P6","v":0},{"$f":"'Expense Input'!Q6","v":0},{"$f":"'Expense Input'!R6","v":0},{"$f":"'Expense Input'!S6","v":0},{"$f":"'Expense Input'!T6","v":0},{"$f":"'Expense Input'!U6","v":0},{"$f":"'Expense Input'!V6","v":0},{"$f":"'Expense Input'!W6","v":0},{"$f":"'Expense Input'!X6","v":0},{"$f":"'Expense Input'!Y6","v":0},{"$f":"'Expense Input'!Z6","v":0},{"$f":"'Expense Input'!AA6","v":0},{"$f":"'Expense Input'!AB6","v":0},{"$f":"'Expense Input'!AC6","v":0},{"$f":"'Expense Input'!AD6","v":0},{"$f":"'Expense Input'!AE6","v":0},{"$f":"'Expense Input'!AF6","v":0},{"$f":"'Expense Input'!AG6","v":0},{"$f":"'Expense Input'!AH6","v":0},{"$f":"'Expense Input'!AI6","v":0},{"$f":"'Expense Input'!AJ6","v":0},{"$f":"'Expense Input'!AK6","v":0}]
["Adjunct faculty ",{"$f":"'Expense Input'!C7","v":0},{"$f":"'Expense Input'!D7","v":0},{"$f":"'Expense Input'!E7","v":0},{"$f":"'Expense Input'!F7","v":0},{"$f":"'Expense Input'!G7","v":0},{"$f":"'Expense Input'!H7","v":0},{"$f":"'Expense Input'!I7","v":0},{"$f":"'Expense Input'!J7","v":0},{"$f":"'Expense Input'!K7","v":0},{"$f":"'Expense Input'!L7","v":0},{"$f":"'Expense Input'!M7","v":0},{"$f":"'Expense Input'!N7","v":0},{"$f":"'Expense Input'!O7","v":0},{"$f":"'Expense Input'!P7","v":0},{"$f":"'Expense Input'!Q7","v":0},{"$f":"'Expense Input'!R7","v":0},{"$f":"'Expense Input'!S7","v":0},{"$f":"'Expense Input'!T7","v":0},{"$f":"'Expense Input'!U7","v":0},{"$f":"'Expense Input'!V7","v":0},{"$f":"'Expense Input'!W7","v":0},{"$f":"'Expense Input'!X7","v":0},{"$f":"'Expense Input'!Y7","v":0},{"$f":"'Expense Input'!Z7","v":0},{"$f":"'Expense Input'!AA7","v":0},{"$f":"'Expense Input'!AB7","v":0},{"$f":"'Expense Input'!AC7","v":0},{"$f":"'Expense Input'!AD7","v":0},{"$f":"'Expense Input'!AE7","v":0},{"$f":"'Expense Input'!AF7","v":0},{"$f":"'Expense Input'!AG7","v":0},{"$f":"'Expense Input'!AH7","v":0},{"$f":"'Expense Input'!AI7","v":0},{"$f":"'Expense Input'!AJ7","v":0},{"$f":"'Expense Input'!AK7","v":0}]
["Staff Salaries ",{"$f":"'Expense Input'!C8","v":0},{"$f":"'Expense Input'!D8","v":0},{"$f":"'Expense Input'!E8","v":0},{"$f":"'Expense Input'!F8","v":0},{"$f":"'Expense Input'!G8","v":0},{"$f":"'Expense Input'!H8","v":0},{"$f":"'Expense Input'!I8","v":0},{"$f":"'Expense Input'!J8","v":0},{"$f":"'Expense Input'!K8","v":0},{"$f":"'Expense Input'!L8","v":0},{"$f":"'Expense Input'!M8","v":0},{"$f":"'Expense Input'!N8","v":0},{"$f":"'Expense Input'!O8","v":0},{"$f":"'Expense Input'!P8","v":0},{"$f":"'Expense Input'!Q8","v":0},{"$f":"'Expense Input'!R8","v":0},{"$f":"'Expense Input'!S8","v":0},{"$f":"'Expense Input'!T8","v":0},{"$f":"'Expense Input'!U8","v":0},{"$f":"'Expense Input'!V8","v":0},{"$f":"'Expense Input'!W8","v":0},{"$f":"'Expense Input'!X8","v":0},{"$f":"'Expense Input'!Y8","v":0},{"$f":"'Expense Input'!Z8","v":0},{"$f":"'Expense Input'!AA8","v":0},{"$f":"'Expense Input'!AB8","v":0},{"$f":"'Expense Input'!AC8","v":0},{"$f":"'Expense Input'!AD8","v":0},{"$f":"'Expense Input'!AE8","v":0},{"$f":"'Expense Input'!AF8","v":0},{"$f":"'Expense Input'!AG8","v":0},{"$f":"'Expense Input'!AH8","v":0},{"$f":"'Expense Input'!AI8","v":0},{"$f":"'Expense Input'!AJ8","v":0},{"$f":"'Expense Input'!AK8","v":0}]
["Course development stipends",{"$f":"'Expense Input'!C9","v":0},{"$f":"'Expense Input'!D9","v":0},{"$f":"'Expense Input'!E9","v":0},{"$f":"'Expense Input'!F9","v":0},{"$f":"'Expense Input'!G9","v":0},{"$f":"'Expense Input'!H9","v":0},{"$f":"'Expense Input'!I9","v":0},{"$f":"'Expense Input'!J9","v":0},{"$f":"'Expense Input'!K9","v":0},{"$f":"'Expense Input'!L9","v":0},{"$f":"'Expense Input'!M9","v":0},{"$f":"'Expense Input'!N9","v":0},{"$f":"'Expense Input'!O9","v":0},{"$f":"'Expense Input'!P9","v":0},{"$f":"'Expense Input'!Q9","v":0},{"$f":"'Expense Input'!R9","v":0},{"$f":"'Expense Input'!S9","v":0},{"$f":"'Expense Input'!T9","v":0},{"$f":"'Expense Input'!U9","v":0},{"$f":"'Expense Input'!V9","v":0},{"$f":"'Expense Input'!W9","v":0},{"$f":"'Expense Input'!X9","v":0},{"$f":"'Expense Input'!Y9","v":0},{"$f":"'Expense Input'!Z9","v":0},{"$f":"'Expense Input'!AA9","v":0},{"$f":"'Expense Input'!AB9","v":0},{"$f":"'Expense Input'!AC9","v":0},{"$f":"'Expense Input'!AD9","v":0},{"$f":"'Expense Input'!AE9","v":0},{"$f":"'Expense Input'!AF9","v":0},{"$f":"'Expense Input'!AG9","v":0},{"$f":"'Expense Input'!AH9","v":0},{"$f":"'Expense Input'!AI9","v":0},{"$f":"'Expense Input'!AJ9","v":0},{"$f":"'Expense Input'!AK9","v":0}]
["Other Salaries",{"$f":"'Expense Input'!C10+'Expense Input'!C11","v":0},{"$f":"'Expense Input'!D10+'Expense Input'!D11","v":0},{"$f":"'Expense Input'!E10+'Expense Input'!E11","v":0},{"$f":"'Expense Input'!F10+'Expense Input'!F11","v":0},{"$f":"'Expense Input'!G10+'Expense Input'!G11","v":0},{"$f":"'Expense Input'!H10+'Expense Input'!H11","v":0},{"$f":"'Expense Input'!I10+'Expense Input'!I11","v":0},{"$f":"'Expense Input'!J10+'Expense Input'!J11","v":0},{"$f":"'Expense Input'!K10+'Expense Input'!K11","v":0},{"$f":"'Expense Input'!L10+'Expense Input'!L11","v":0},{"$f":"'Expense Input'!M10+'Expense Input'!M11","v":0},{"$f":"'Expense Input'!N10+'Expense Input'!N11","v":0},{"$f":"'Expense Input'!O10+'Expense Input'!O11","v":0},{"$f":"'Expense Input'!P10+'Expense Input'!P11","v":0},{"$f":"'Expense Input'!Q10+'Expense Input'!Q11","v":0},{"$f":"'Expense Input'!R10+'Expense Input'!R11","v":0},{"$f":"'Expense Input'!S10+'Expense Input'!S11","v":0},{"$f":"'Expense Input'!T10+'Expense Input'!T11","v":0},{"$f":"'Expense Input'!U10+'Expense Input'!U11","v":0},{"$f":"'Expense Input'!V10+'Expense Input'!V11","v":0},{"$f":"'Expense Input'!W10+'Expense Input'!W11","v":0},{"$f":"'Expense Input'!X10+'Expense Input'!X11","v":0},{"$f":"'Expense Input'!Y10+'Expense Input'!Y11","v":0},{"$f":"'Expense Input'!Z10+'Expense Input'!Z11","v":0},{"$f":"'Expense Input'!AA10+'Expense Input'!AA11","v":0},{"$f":"'Expense Input'!AB10+'Expense Input'!AB11","v":0},{"$f":"'Expense Input'!AC10+'Expense Input'!AC11","v":0},{"$f":"'Expense Input'!AD10+'Expense Input'!AD11","v":0},{"$f":"'Expense Input'!AE10+'Expense Input'!AE11","v":0},{"$f":"'Expense Input'!AF10+'Expense Input'!AF11","v":0},{"$f":"'Expense Input'!AG10+'Expense Input'!AG11","v":0},{"$f":"'Expense Input'!AH10+'Expense Input'!AH11","v":0},{"$f":"'Expense Input'!AI10+'Expense Input'!AI11","v":0},{"$f":"'Expense Input'!AJ10+'Expense Input'!AJ11","v":0},{"$f":"'Expense Input'!AK10+'Expense Input'!AK11","v":0}]
["Total Salaries",{"$f":"'Expense Input'!C13","v":0},{"$f":"'Expense Input'!D13","v":0},{"$f":"'Expense Input'!E13","v":0},{"$f":"'Expense Input'!F13","v":0},{"$f":"'Expense Input'!G13","v":0},{"$f":"'Expense Input'!H13","v":0},{"$f":"'Expense Input'!I13","v":0},{"$f":"'Expense Input'!J13","v":0},{"$f":"'Expense Input'!K13","v":0},{"$f":"'Expense Input'!L13","v":0},{"$f":"'Expense Input'!M13","v":0},{"$f":"'Expense Input'!N13","v":0},{"$f":"'Expense Input'!O13","v":0},{"$f":"'Expense Input'!P13","v":0},{"$f":"'Expense Input'!Q13","v":0},{"$f":"'Expense Input'!R13","v":0},{"$f":"'Expense Input'!S13","v":0},{"$f":"'Expense Input'!T13","v":0},{"$f":"'Expense Input'!U13","v":0},{"$f":"'Expense Input'!V13","v":0},{"$f":"'Expense Input'!W13","v":0},{"$f":"'Expense Input'!X13","v":0},{"$f":"'Expense Input'!Y13","v":0},{"$f":"'Expense Input'!Z13","v":0},{"$f":"'Expense Input'!AA13","v":0},{"$f":"'Expense Input'!AB13","v":0},{"$f":"'Expense Input'!AC13","v":0},{"$f":"'Expense Input'!AD13","v":0},{"$f":"'Expense Input'!AE13","v":0},{"$f":"'Expense Input'!AF13","v":0},{"$f":"'Expense Input'!AG13","v":0},{"$f":"'Expense Input'!AH13","v":0},{"$f":"'Expense Input'!AI13","v":0},{"$f":"'Expense Input'!AJ13","v":0},{"$f":"'Expense Input'!AK13","v":0}]
[]
["Benefits",{"$f":"'Expense Input'!C14","v":0},{"$f":"'Expense Input'!D14","v":0},{"$f":"'Expense Input'!E14","v":0},{"$f":"'Expense Input'!F14","v":0},{"$f":"'Expense Input'!G14","v":0},{"$f":"'Expense Input'!H14","v":0},{"$f":"'Expense Input'!I14","v":0},{"$f":"'Expense Input'!J14","v":0},{"$f":"'Expense Input'!K14","v":0},{"$f":"'Expense Input'!L14","v":0},{"$f":"'Expense Input'!M14","v":0},{"$f":"'Expense Input'!N14","v":0},{"$f":"'Expense Input'!O14","v":0},{"$f":"'Expense Input'!P14","v":0},{"$f":"'Expense Input'!Q14","v":0},{"$f":"'Expense Input'!R14","v":0},{"$f":"'Expense Input'!S14","v":0},{"$f":"'Expense Input'!T14","v":0},{"$f":"'Expense Input'!U14","v":0},{"$f":"'Expense Input'!V14","v":0},{"$f":"'Expense Input'!W14","v":0},{"$f":"'Expense Input'!X14","v":0},{"$f":"'Expense Input'!Y14","v":0},{"$f":"'Expense Input'!Z14","v":0},{"$f":"'Expense Input'!AA14","v":0},{"$f":"'Expense Input'!AB14","v":0},{"$f":"'Expense Input'!AC14","v":0},{"$f":"'Expense Input'!AD14","v":0},{"$f":"'Expense Input'!AE14","v":0},{"$f":"'Expense Input'!AF14","v":0},{"$f":"'Expense Input'!AG14","v":0},{"$f":"'Expense Input'!AH14","v":0},{"$f":"'Expense Input'!AI14","v":0},{"$f":"'Expense Input'!AJ14","v":0},{"$f":"'Expense Input'!AK14","v":0}]
["Non Capital Expenses",{"$f":"'Expense Input'!C32","v":25000},{"$f":"'Expense Input'!D32","v":0},{"$f":"'Expense Input'!E32","v":0},{"$f":"'Expense Input'!F32","v":0},{"$f":"'Expense Input'!G32","v":0},{"$f":"'Expense Input'!H32","v":0},{"$f":"'Expense Input'!I32","v":0},{"$f":"'Expense Input'!J32","v":25000},{"$f":"'Expense Input'!K32","v":0},{"$f":"'Expense Input'!L32","v":0},{"$f":"'Expense Input'!M32","v":0},{"$f":"'Expense Input'!N32","v":0},{"$f":"'Expense Input'!O32","v":0},{"$f":"'Expense Input'!P32","v":0},{"$f":"'Expense Input'!Q32","v":25000},{"$f":"'Expense Input'!R32","v":0},{"$f":"'Expense Input'!S32","v":0},{"$f":"'Expense Input'!T32","v":0},{"$f":"'Expense Input'!U32","v":0},{"$f":"'Expense Input'!V32","v":0},{"$f":"'Expense Input'!W32","v":0},{"$f":"'Expense Input'!X32","v":25000},{"$f":"'Expense Input'!Y32","v":0},{"$f":"'Expense Input'!Z32","v":0},{"$f":"'Expense Input'!AA32","v":0},{"$f":"'Expense Input'!AB32","v":0},{"$f":"'Expense Input'!AC32","v":0},{"$f":"'Expense Input'!AD32","v":0},{"$f":"'Expense Input'!AE32","v":25000},{"$f":"'Expense Input'!AF32","v":0},{"$f":"'Expense Input'!AG32","v":0},{"$f":"'Expense Input'!AH32","v":0},{"$f":"'Expense Input'!AI32","v":0},{"$f":"'Expense Input'!AJ32","v":0},{"$f":"'Expense Input'!AK32","v":0}]
["Capital Expenditures",{"$f":"'Expense Input'!C33","v":0},{"$f":"'Expense Input'!D33","v":0},{"$f":"'Expense Input'!E33","v":0},{"$f":"'Expense Input'!F33","v":0},{"$f":"'Expense Input'!G33","v":0},{"$f":"'Expense Input'!H33","v":0},{"$f":"'Expense Input'!I33","v":0},{"$f":"'Expense Input'!J33","v":0},{"$f":"'Expense Input'!K33","v":0},{"$f":"'Expense Input'!L33","v":0},{"$f":"'Expense Input'!M33","v":0},{"$f":"'Expense Input'!N33","v":0},{"$f":"'Expense Input'!O33","v":0},{"$f":"'Expense Input'!P33","v":0},{"$f":"'Expense Input'!Q33","v":0},{"$f":"'Expense Input'!R33","v":0},{"$f":"'Expense Input'!S33","v":0},{"$f":"'Expense Input'!T33","v":0},{"$f":"'Expense Input'!U33","v":0},{"$f":"'Expense Input'!V33","v":0},{"$f":"'Expense Input'!W33","v":0},{"$f":"'Expense Input'!X33","v":0},{"$f":"'Expense Input'!Y33","v":0},{"$f":"'Expense Input'!Z33","v":0},{"$f":"'Expense Input'!AA33","v":0},{"$f":"'Expense Input'!AB33","v":0},{"$f":"'Expense Input'!AC33","v":0},{"$f":"'Expense Input'!AD33","v":0},{"$f":"'Expense Input'!AE33","v":0},{"$f":"'Expense Input'!AF33","v":0},{"$f":"'Expense Input'!AG33","v":0},{"$f":"'Expense Input'!AH33","v":0},{"$f":"'Expense Input'!AI33","v":0},{"$f":"'Expense Input'!AJ33","v":0},{"$f":"'Expense Input'!AK33","v":0}]
["Other Initial Investment",{"$f":"initial_investment","v":0}]
["Total Expense",{"$f":"SUM(B20:B28)","v":25000},0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0]
[]
["Transfers",{"$f":"'Expense Input'!C37","v":0},{"$f":"'Expense Input'!D37","v":0},{"$f":"'Expense Input'!E37","v":0},{"$f":"'Expense Input'!F37","v":0},{"$f":"'Expense Input'!G37","v":0},{"$f":"'Expense Input'!H37","v":0},{"$f":"'Expense Input'!I37","v":0},{"$f":"'Expense Input'!J37","v":0},{"$f":"'Expense Input'!K37","v":0},{"$f":"'Expense Input'!L37","v":0},{"$f":"'Expense Input'!M37","v":0},{"$f":"'Expense Input'!N37","v":0},{"$f":"'Expense Input'!O37","v":0},{"$f":"'Expense Input'!P37","v":0},{"$f":"'Expense Input'!Q37","v":0},{"$f":"'Expense Input'!R37","v":0},{"$f":"'Expense Input'!S37","v":0},{"$f":"'Expense Input'!T37","v":0},{"$f":"'Expense Input'!U37","v":0},{"$f":"'Expense Input'!V37","v":0},{"$f":"'Expense Input'!W37","v":0},{"$f":"'Expense Input'!X37","v":0},{"$f":"'Expense Input'!Y37","v":0},{"$f":"'Expense Input'!Z37","v":0},{"$f":"'Expense Input'!AA37","v":0},{"$f":"'Expense Input'!AB37","v":0},{"$f":"'Expense Input'!AC37","v":0},{"$f":"'Expense Input'!AD37","v":0},{"$f":"'Expense Input'!AE37","v":0},{"$f":"'Expense Input'!AF37","v":0},{"$f":"'Expense Input'!AG37","v":0},{"$f":"'Expense Input'!AH37","v":0},{"$f":"'Expense Input'!AI37","v":0},{"$f":"'Expense Input'!AJ37","v":0},{"$f":"'Expense Input'!AK37","v":0}]
[]
["Contribution Margin",{"$f":"B16-B30-B32","v":-25000},0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0]
[]
["Administrative Overhead",{"$f":"'Expense Input'!C39","v":0},{"$f":"'Expense Input'!D39","v":0},{"$f":"'Expense Input'!E39","v":0},{"$f":"'Expense Input'!F39","v":0},{"$f":"'Expense Input'!G39","v":0},{"$f":"'Expense Input'!H39","v":0},{"$f":"'Expense Input'!I39","v":0},{"$f":"'Expense Input'!J39","v":0},{"$f":"'Expense Input'!K39","v":0},{"$f":"'Expense Input'!L39","v":0},{"$f":"'Expense Input'!M39","v":0},{"$f":"'Expense Input'!N39","v":0},{"$f":"'Expense Input'!O39","v":0},{"$f":"'Expense Input'!P39","v":0},{"$f":"'Expense Input'!Q39","v":0},{"$f":"'Expense Input'!R39","v":0},{"$f":"'Expense Input'!S39","v":0},{"$f":"'Expense Input'!T39","v":0},{"$f":"'Expense Input'!U39","v":0},{"$f":"'Expense Input'!V39","v":0},{"$f":"'Expense Input'!W39","v":0},{"$f":"'Expense Input'!X39","v":0},{"$f":"'Expense Input'!Y39","v":0},{"$f":"'Expense Input'!Z39","v":0},{"$f":"'Expense Input'!AA39","v":0},{"$f":"'Expense Input'!AB39","v":0},{"$f":"'Expense Input'!AC39","v":0},{"$f":"'Expense Input'!AD39","v":0},{"$f":"'Expense Input'!AE39","v":0},{"$f":"'Expense Input'!AF39","v":0},{"$f":"'Expense Input'!AG39","v":0},{"$f":"'Expense Input'!AH39","v":0},{"$f":"'Expense Input'!AI39","v":0},{"$f":"'Expense Input'!AJ39","v":0},{"$f":"'Expense Input'!AK39","v":0}]
["Total Overhead",{"$f":"SUM(B36:B36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Net Margin",{"$f":"B34-B37","v":-25000},0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0]
[]
["Cash Flow*"]
["Accumulated Cash Flow"]
["Payback"]
[]
[]
["Reallocated faculty and staff"]
["Expense"]
["Faculty Salaries to be reallocated",{"$f":"'Expense Input'!C48","v":0},{"$f":"'Expense Input'!D48","v":0},{"$f":"'Expense Input'!E48","v":0},{"$f":"'Expense Input'!F48","v":0},{"$f":"'Expense Input'!G48","v":0},{"$f":"'Expense Input'!H48","v":0},{"$f":"'Expense Input'!I48","v":0},{"$f":"'Expense Input'!J48","v":0},{"$f":"'Expense Input'!K48","v":0},{"$f":"'Expense Input'!L48","v":0},{"$f":"'Expense Input'!M48","v":0},{"$f":"'Expense Input'!N48","v":0},{"$f":"'Expense Input'!O48","v":0},{"$f":"'Expense Input'!P48","v":0},{"$f":"'Expense Input'!Q48","v":0},{"$f":"'Expense Input'!R48","v":0},{"$f":"'Expense Input'!S48","v":0},{"$f":"'Expense Input'!T48","v":0},{"$f":"'Expense Input'!U48","v":0},{"$f":"'Expense Input'!V48","v":0},{"$f":"'Expense Input'!W48","v":0},{"$f":"'Expense Input'!X48","v":0},{"$f":"'Expense Input'!Y48","v":0},{"$f":"'Expense Input'!Z48","v":0},{"$f":"'Expense Input'!AA48","v":0},{"$f":"'Expense Input'!AB48","v":0},{"$f":"'Expense Input'!AC48","v":0},{"$f":"'Expense Input'!AD48","v":0},{"$f":"'Expense Input'!AE48","v":0},{"$f":"'Expense Input'!AF48","v":0},{"$f":"'Expense Input'!AG48","v":0},{"$f":"'Expense Input'!AH48","v":0},{"$f":"'Expense Input'!AI48","v":0},{"$f":"'Expense Input'!AJ48","v":0},{"$f":"'Expense Input'!AK48","v":0}]
["Adjunct faculty to be reallocated",{"$f":"'Expense Input'!C49","v":0},{"$f":"'Expense Input'!D49","v":0},{"$f":"'Expense Input'!E49","v":0},{"$f":"'Expense Input'!F49","v":0},{"$f":"'Expense Input'!G49","v":0},{"$f":"'Expense Input'!H49","v":0},{"$f":"'Expense Input'!I49","v":0},{"$f":"'Expense Input'!J49","v":0},{"$f":"'Expense Input'!K49","v":0},{"$f":"'Expense Input'!L49","v":0},{"$f":"'Expense Input'!M49","v":0},{"$f":"'Expense Input'!N49","v":0},{"$f":"'Expense Input'!O49","v":0},{"$f":"'Expense Input'!P49","v":0},{"$f":"'Expense Input'!Q49","v":0},{"$f":"'Expense Input'!R49","v":0},{"$f":"'Expense Input'!S49","v":0},{"$f":"'Expense Input'!T49","v":0},{"$f":"'Expense Input'!U49","v":0},{"$f":"'Expense Input'!V49","v":0},{"$f":"'Expense Input'!W49","v":0},{"$f":"'Expense Input'!X49","v":0},{"$f":"'Expense Input'!Y49","v":0},{"$f":"'Expense Input'!Z49","v":0},{"$f":"'Expense Input'!AA49","v":0},{"$f":"'Expense Input'!AB49","v":0},{"$f":"'Expense Input'!AC49","v":0},{"$f":"'Expense Input'!AD49","v":0},{"$f":"'Expense Input'!AE49","v":0},{"$f":"'Expense Input'!AF49","v":0},{"$f":"'Expense Input'!AG49","v":0},{"$f":"'Expense Input'!AH49","v":0},{"$f":"'Expense Input'!AI49","v":0},{"$f":"'Expense Input'!AJ49","v":0},{"$f":"'Expense Input'!AK49","v":0}]
["Staff to be reallocated",{"$f":"'Expense Input'!C50","v":0},{"$f":"'Expense Input'!D50","v":0},{"$f":"'Expense Input'!E50","v":0},{"$f":"'Expense Input'!F50","v":0},{"$f":"'Expense Input'!G50","v":0},{"$f":"'Expense Input'!H50","v":0},{"$f":"'Expense Input'!I50","v":0},{"$f":"'Expense Input'!J50","v":0},{"$f":"'Expense Input'!K50","v":0},{"$f":"'Expense Input'!L50","v":0},{"$f":"'Expense Input'!M50","v":0},{"$f":"'Expense Input'!N50","v":0},{"$f":"'Expense Input'!O50","v":0},{"$f":"'Expense Input'!P50","v":0},{"$f":"'Expense Input'!Q50","v":0},{"$f":"'Expense Input'!R50","v":0},{"$f":"'Expense Input'!S50","v":0},{"$f":"'Expense Input'!T50","v":0},{"$f":"'Expense Input'!U50","v":0},{"$f":"'Expense Input'!V50","v":0},{"$f":"'Expense Input'!W50","v":0},{"$f":"'Expense Input'!X50","v":0},{"$f":"'Expense Input'!Y50","v":0},{"$f":"'Expense Input'!Z50","v":0},{"$f":"'Expense Input'!AA50","v":0},{"$f":"'Expense Input'!AB50","v":0},{"$f":"'Expense Input'!AC50","v":0},{"$f":"'Expense Input'!AD50","v":0},{"$f":"'Expense Input'!AE50","v":0},{"$f":"'Expense Input'!AF50","v":0},{"$f":"'Expense Input'!AG50","v":0},{"$f":"'Expense Input'!AH50","v":0},{"$f":"'Expense Input'!AI50","v":0},{"$f":"'Expense Input'!AJ50","v":0},{"$f":"'Expense Input'!AK50","v":0}]
["Total Reallocated Salaries",{"$f":"SUM(B48:B50)","v":0},{"$f":"SUM(C48:C50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Benefits",{"$f":"'Expense Input'!C53","v":0},{"$f":"'Expense Input'!D53","v":0},{"$f":"'Expense Input'!E53","v":0},{"$f":"'Expense Input'!F53","v":0},{"$f":"'Expense Input'!G53","v":0},{"$f":"'Expense Input'!H53","v":0},{"$f":"'Expense Input'!I53","v":0},{"$f":"'Expense Input'!J53","v":0},{"$f":"'Expense Input'!K53","v":0},{"$f":"'Expense Input'!L53","v":0},{"$f":"'Expense Input'!M53","v":0},{"$f":"'Expense Input'!N53","v":0},{"$f":"'Expense Input'!O53","v":0},{"$f":"'Expense Input'!P53","v":0},{"$f":"'Expense Input'!Q53","v":0},{"$f":"'Expense Input'!R53","v":0},{"$f":"'Expense Input'!S53","v":0},{"$f":"'Expense Input'!T53","v":0},{"$f":"'Expense Input'!U53","v":0},{"$f":"'Expense Input'!V53","v":0},{"$f":"'Expense Input'!W53","v":0},{"$f":"'Expense Input'!X53","v":0},{"$f":"'Expense Input'!Y53","v":0},{"$f":"'Expense Input'!Z53","v":0},{"$f":"'Expense Input'!AA53","v":0},{"$f":"'Expense Input'!AB53","v":0},{"$f":"'Expense Input'!AC53","v":0},{"$f":"'Expense Input'!AD53","v":0},{"$f":"'Expense Input'!AE53","v":0},{"$f":"'Expense Input'!AF53","v":0},{"$f":"'Expense Input'!AG53","v":0},{"$f":"'Expense Input'!AH53","v":0},{"$f":"'Expense Input'!AI53","v":0},{"$f":"'Expense Input'!AJ53","v":0},{"$f":"'Expense Input'!AK53","v":0}]
["Total Reallocated Expenses",{"$f":"B53","v":0},{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Net with reallocated faculty and staff"]
["Expense"]
["Faculty Salaries ",{"$f":"B19-B48","v":0},{"$f":"C19-C48","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Adjunct faculty ",{"$f":"B20-B49","v":0},{"$f":"C20-C49","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Staff Salaries ",{"$f":"B21-B50","v":0},{"$f":"C21-C50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Course development stipends",{"$f":"B22","v":0},{"$f":"C22","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Salaries",{"$f":"B23","v":0},{"$f":"C23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Salaries",{"$f":"B24+B53","v":0},{"$f":"C24+C53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Benefits",{"$f":"B26-B53","v":0},{"$f":"C26-C53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Non Capital Expenses",{"$f":"B27","v":25000},0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0]
["Capital Expenditures",{"$f":"B28","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Expense",{"$f":"SUM(B64:B69)","v":25000},{"$f":"SUM(C64:C69)","v":0},0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0]
[]
["Transfers",{"$f":"B32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Contribution Margin",{"$f":"B16-B70-B72","v":-25000},0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0]
[]
["Administrative Overhead",{"$f":"'Expense Input'!C39","v":0},{"$f":"'Expense Input'!D39","v":0},{"$f":"'Expense Input'!E39","v":0},{"$f":"'Expense Input'!F39","v":0},{"$f":"'Expense Input'!G39","v":0},{"$f":"'Expense Input'!H39","v":0},{"$f":"'Expense Input'!I39","v":0},{"$f":"'Expense Input'!J39","v":0},{"$f":"'Expense Input'!K39","v":0},{"$f":"'Expense Input'!L39","v":0},{"$f":"'Expense Input'!M39","v":0},{"$f":"'Expense Input'!N39","v":0},{"$f":"'Expense Input'!O39","v":0},{"$f":"'Expense Input'!P39","v":0},{"$f":"'Expense Input'!Q39","v":0},{"$f":"'Expense Input'!R39","v":0},{"$f":"'Expense Input'!S39","v":0},{"$f":"'Expense Input'!T39","v":0},{"$f":"'Expense Input'!U39","v":0},{"$f":"'Expense Input'!V39","v":0},{"$f":"'Expense Input'!W39","v":0},{"$f":"'Expense Input'!X39","v":0},{"$f":"'Expense Input'!Y39","v":0},{"$f":"'Expense Input'!Z39","v":0},{"$f":"'Expense Input'!AA39","v":0},{"$f":"'Expense Input'!AB39","v":0},{"$f":"'Expense Input'!AC39","v":0},{"$f":"'Expense Input'!AD39","v":0},{"$f":"'Expense Input'!AE39","v":0},{"$f":"'Expense Input'!AF39","v":0},{"$f":"'Expense Input'!AG39","v":0},{"$f":"'Expense Input'!AH39","v":0},{"$f":"'Expense Input'!AI39","v":0},{"$f":"'Expense Input'!AJ39","v":0},{"$f":"'Expense Input'!AK39","v":0}]
["Total Overhead",{"$f":"SUM(B76:B76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Net Margin",{"$f":"B74-B77","v":-25000},0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0,-25000,0,0,0,0,0,0]
[]
["Cash Flow*"]
["Accumulated Cash Flow"]
["Payback"]
[]
["FTE Student Enrollment",{"$f":"'UG Trad Input'!C3+'UG Non-Trad Input'!C9+'Grad Input'!C9","v":0},{"$f":"'UG Trad Input'!D3+'UG Non-Trad Input'!D9+'Grad Input'!D9","v":0},{"$f":"'UG Trad Input'!E3+'UG Non-Trad Input'!E9+'Grad Input'!E9","v":0},{"$f":"'UG Trad Input'!F3+'UG Non-Trad Input'!F9+'Grad Input'!F9","v":0},{"$f":"'UG Trad Input'!G3+'UG Non-Trad Input'!G9+'Grad Input'!G9","v":0},{"$f":"'UG Trad Input'!H3+'UG Non-Trad Input'!H9+'Grad Input'!H9","v":0},{"$f":"'UG Trad Input'!I3+'UG Non-Trad Input'!I9+'Grad Input'!I9","v":0},{"$f":"'UG Trad Input'!J3+'UG Non-Trad Input'!J9+'Grad Input'!J9","v":0},{"$f":"'UG Trad Input'!K3+'UG Non-Trad Input'!K9+'Grad Input'!K9","v":0},{"$f":"'UG Trad Input'!L3+'UG Non-Trad Input'!L9+'Grad Input'!L9","v":0},{"$f":"'UG Trad Input'!M3+'UG Non-Trad Input'!M9+'Grad Input'!M9","v":0},{"$f":"'UG Trad Input'!N3+'UG Non-Trad Input'!N9+'Grad Input'!N9","v":0},{"$f":"'UG Trad Input'!O3+'UG Non-Trad Input'!O9+'Grad Input'!O9","v":0},{"$f":"'UG Trad Input'!P3+'UG Non-Trad Input'!P9+'Grad Input'!P9","v":0},{"$f":"'UG Trad Input'!Q3+'UG Non-Trad Input'!Q9+'Grad Input'!Q9","v":0},{"$f":"'UG Trad Input'!R3+'UG Non-Trad Input'!R9+'Grad Input'!R9","v":0},{"$f":"'UG Trad Input'!S3+'UG Non-Trad Input'!S9+'Grad Input'!S9","v":0},{"$f":"'UG Trad Input'!T3+'UG Non-Trad Input'!T9+'Grad Input'!T9","v":0},{"$f":"'UG Trad Input'!U3+'UG Non-Trad Input'!U9+'Grad Input'!U9","v":0},{"$f":"'UG Trad Input'!V3+'UG Non-Trad Input'!V9+'Grad Input'!V9","v":0},{"$f":"'UG Trad Input'!W3+'UG Non-Trad Input'!W9+'Grad Input'!W9","v":0},{"$f":"'UG Trad Input'!X3+'UG Non-Trad Input'!X9+'Grad Input'!X9","v":0},{"$f":"'UG Trad Input'!Y3+'UG Non-Trad Input'!Y9+'Grad Input'!Y9","v":0},{"$f":"'UG Trad Input'!Z3+'UG Non-Trad Input'!Z9+'Grad Input'!Z9","v":0},{"$f":"'UG Trad Input'!AA3+'UG Non-Trad Input'!AA9+'Grad Input'!AA9","v":0},{"$f":"'UG Trad Input'!AB3+'UG Non-Trad Input'!AB9+'Grad Input'!AB9","v":0},{"$f":"'UG Trad Input'!AC3+'UG Non-Trad Input'!AC9+'Grad Input'!AC9","v":0},{"$f":"'UG Trad Input'!AD3+'UG Non-Trad Input'!AD9+'Grad Input'!AD9","v":0},{"$f":"'UG Trad Input'!AE3+'UG Non-Trad Input'!AE9+'Grad Input'!AE9","v":0},{"$f":"'UG Trad Input'!AF3+'UG Non-Trad Input'!AF9+'Grad Input'!AF9","v":0},{"$f":"'UG Trad Input'!AG3+'UG Non-Trad Input'!AG9+'Grad Input'!AG9","v":0},{"$f":"'UG Trad Input'!AH3+'UG Non-Trad Input'!AH9+'Grad Input'!AH9","v":0},{"$f":"'UG Trad Input'!AI3+'UG Non-Trad Input'!AI9+'Grad Input'!AI9","v":0},{"$f":"'UG Trad Input'!AJ3+'UG Non-Trad Input'!AJ9+'Grad Input'!AJ9","v":0},{"$f":"'UG Trad Input'!AK3+'UG Non-Trad Input'!AK9+'Grad Input'!AK9","v":0}]
["FTE Faculty Increase",{"$f":"'Expense Input'!C3","v":0},{"$f":"'Expense Input'!D3","v":0},{"$f":"'Expense Input'!E3","v":0},{"$f":"'Expense Input'!F3","v":0},{"$f":"'Expense Input'!G3","v":0},{"$f":"'Expense Input'!H3","v":0},{"$f":"'Expense Input'!I3","v":0},{"$f":"'Expense Input'!J3","v":0},{"$f":"'Expense Input'!K3","v":0},{"$f":"'Expense Input'!L3","v":0},{"$f":"'Expense Input'!M3","v":0},{"$f":"'Expense Input'!N3","v":0},{"$f":"'Expense Input'!O3","v":0},{"$f":"'Expense Input'!P3","v":0},{"$f":"'Expense Input'!Q3","v":0},{"$f":"'Expense Input'!R3","v":0},{"$f":"'Expense Input'!S3","v":0},{"$f":"'Expense Input'!T3","v":0},{"$f":"'Expense Input'!U3","v":0},{"$f":"'Expense Input'!V3","v":0},{"$f":"'Expense Input'!W3","v":0},{"$f":"'Expense Input'!X3","v":0},{"$f":"'Expense Input'!Y3","v":0},{"$f":"'Expense Input'!Z3","v":0},{"$f":"'Expense Input'!AA3","v":0},{"$f":"'Expense Input'!AB3","v":0},{"$f":"'Expense Input'!AC3","v":0},{"$f":"'Expense Input'!AD3","v":0},{"$f":"'Expense Input'!AE3","v":0},{"$f":"'Expense Input'!AF3","v":0},{"$f":"'Expense Input'!AG3","v":0},{"$f":"'Expense Input'!AH3","v":0},{"$f":"'Expense Input'!AI3","v":0},{"$f":"'Expense Input'!AJ3","v":0},{"$f":"'Expense Input'!AK3","v":0}]
["FTE Staff Increase",{"$f":"'Expense Input'!C4","v":0},{"$f":"'Expense Input'!D4","v":0},{"$f":"'Expense Input'!E4","v":0},{"$f":"'Expense Input'!F4","v":0},{"$f":"'Expense Input'!G4","v":0},{"$f":"'Expense Input'!H4","v":0},{"$f":"'Expense Input'!I4","v":0},{"$f":"'Expense Input'!J4","v":0},{"$f":"'Expense Input'!K4","v":0},{"$f":"'Expense Input'!L4","v":0},{"$f":"'Expense Input'!M4","v":0},{"$f":"'Expense Input'!N4","v":0},{"$f":"'Expense Input'!O4","v":0},{"$f":"'Expense Input'!P4","v":0},{"$f":"'Expense Input'!Q4","v":0},{"$f":"'Expense Input'!R4","v":0},{"$f":"'Expense Input'!S4","v":0},{"$f":"'Expense Input'!T4","v":0},{"$f":"'Expense Input'!U4","v":0},{"$f":"'Expense Input'!V4","v":0},{"$f":"'Expense Input'!W4","v":0},{"$f":"'Expense Input'!X4","v":0},{"$f":"'Expense Input'!Y4","v":0},{"$f":"'Expense Input'!Z4","v":0},{"$f":"'Expense Input'!AA4","v":0},{"$f":"'Expense Input'!AB4","v":0},{"$f":"'Expense Input'!AC4","v":0},{"$f":"'Expense Input'!AD4","v":0},{"$f":"'Expense Input'!AE4","v":0},{"$f":"'Expense Input'!AF4","v":0},{"$f":"'Expense Input'!AG4","v":0},{"$f":"'Expense Input'!AH4","v":0},{"$f":"'Expense Input'!AI4","v":0},{"$f":"'Expense Input'!AJ4","v":0},{"$f":"'Expense Input'!AK4","v":0}]
[]
["*Overhead is excluded from the cash flow calculations"]

{"sheet":"General Input","index":4,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":true,"merged":[[7,30,7,36],[0,1,0,4],[7,2,7,8],[7,9,7,15],[7,16,7,22],[7,23,7,29]]}
["Creighton University","Legend:"]
["New program financial proforma",null,"Standard assumption, no changes"]
["General Input page",null,"Assumption input cell"]
[null,null,"Calculated cell"]
["Name of Program:"]
["Online Program, if yes, type \"Online Program\""]
["Revenue Type (see list below):"]
["Contact Name"]
[]
["Go To:","Traditional Undergraduate Revenue Input"]
[null,"Non-Traditional Undergraduate Revenue Input"]
[null,"Graduate Program Revenue Input"]
[null,"Flat Rate Certificate Program Revenue Input"]
[null,"Credit Hours Based Certificate Program Revenue Input"]
[null,"Endowment, Gift & Other Income Input"]
[null,"Expense Assumptions Input"]

{"sheet":"UG Trad Input","index":5,"n_rows":20,"n_cols":37,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,30,0,36],[0,2,0,8],[0,9,0,15],[0,16,0,22],[0,23,0,29]]}
[null,null,"Year 1",null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,"Year 3",null,null,null,null,null,null,"Year 4",null,null,null,null,null,null,"Year 5"]
["Traditional Undergraduate Program Revenue Assumptions:","Notes","Summer Year 1 Term 2","Fall Year 1 Term 1","Fall Year 1 Term 2","Winter Year 1","Spring Year 1 Term 1","Spring Year 1 Term 2","Summer Year 1 Term 1","Summer Year 2 Term 2","Fall Year 2 Term 1","Fall Year 2 Term 2","Winter Year 2","Spring Year 2 Term 1","Spring Year 2 Term 2","Summer Year 2 Term 1","Summer Year 3 Term 2","Fall Year 3 Term 1","Fall Year 3 Term 2","Winter Year 3","Spring Year 3 Term 1","Spring Year 3 Term 2","Summer Year 3 Term 1","Summer Year 4 Term 2","Fall Year 4 Term 1","Fall Year 4 Term 2","Winter Year 4","Spring Year 4 Term 1","Spring Year 4 Term 2","Summer Year 4 Term 1","Summer Year 5 Term 2","Fall Year 5 Term 1","Fall Year 5 Term 2","Winter Year 5","Spring Year 5 Term 1","Spring Year 5 Term 2","Summer Year 5 Term 1"]
["FTE Enrollment",null,null,{"$f":"SUM(D4:D7)","v":0},null,null,{"$f":"SUM(G4:G7)","v":0},null,null,null,{"$f":"SUM(K4:K7)","v":0},null,null,{"$f":"SUM(N4:N7)","v":0},null,null,null,{"$f":"SUM(R4:R7)","v":0},null,null,{"$f":"SUM(U4:U7)","v":0},null,null,null,{"$f":"SUM(Y4:Y7)","v":0},null,null,{"$f":"SUM(AB4:AB7)","v":0},null,null,null,{"$f":"SUM(AF4:AF7)","v":0},null,null,{"$f":"SUM(AI4:AI7)","v":0}]
["Freshmen"]
["Sophomore"]
["Junior"]
["Senior"]
["Tuition per FTE per semester","2013-2014",null,{"$f":"Assumptions!$B$7","v":16898},null,null,{"$f":"Assumptions!$B$7","v":16898},null,null,null,{"$f":"Assumptions!$C$7","v":17320},null,null,{"$f":"Assumptions!$C$7","v":17320},null,null,null,{"$f":"Assumptions!$D$7","v":17753},null,null,{"$f":"Assumptions!$D$7","v":17753},null,null,null,{"$f":"Assumptions!$E$7","v":18197},null,null,{"$f":"Assumptions!$E$7","v":18197},null,null,null,{"$f":"Assumptions!$F$7","v":18652},null,null,{"$f":"Assumptions!$F$7","v":18652}]
["Fees per FTE per semester",null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"Assumptions!#REF!+Assumptions!#REF!","v":{"$error":"#REF!"}}]
["Tuition discount rate","based on fall 2013 incoming freshmen, assumes holding flat throughout program",null,{"$f":"Assumptions!$B$12","v":0.47499999999999998},null,null,{"$f":"Assumptions!$B$12","v":0.47499999999999998},null,null,null,{"$f":"Assumptions!$C$12","v":0.47499999999999998},null,null,{"$f":"Assumptions!$C$12","v":0.47499999999999998},null,null,null,{"$f":"Assumptions!$D$12","v":0.47499999999999998},null,null,{"$f":"Assumptions!$D$12","v":0.47499999999999998},null,null,null,{"$f":"Assumptions!$E$12","v":0.47499999999999998},null,null,{"$f":"Assumptions!$E$12","v":0.47499999999999998},null,null,null,{"$f":"Assumptions!$F$12","v":0.47499999999999998},null,null,{"$f":"Assumptions!$F$12","v":0.47499999999999998}]
["Annual tuition increase",null,null,null,null,null,null,null,null,{"$f":"Assumptions!$C$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$D$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$E$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$F$6","v":2.5000000000000001E-2}]
["Traditional undergraduate program assumptions assumes full-time, regular undergraduate tuition rate for fall & spring semesters, less tuition discount"]
["Tuition",null,null,{"$f":"D3*D8","v":0},null,null,{"$f":"G3*G8","v":0},null,null,null,{"$f":"K3*K8","v":0},null,null,0,null,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,null,0,null,null,0]
["Tuition Discount",null,null,{"$f":"ROUND(D13*-D10,0)","v":0},null,null,0,null,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,null,0,null,null,0]
["Total Net Tuition",null,null,{"$f":"D13+D14","v":0},null,null,0,null,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,null,0,null,null,0,null,null,null,0,null,null,0]
[]
[]
[null,null,null,null,null,null,{"$f":"+G13+D13","v":0},null,null,null,null,null,null,{"$f":"+N13+K13","v":0}]
[null,null,null,null,null,null,{"$f":"+G14+D14","v":0},null,null,null,null,null,null,{"$f":"+N14+K14","v":0}]
[null,null,null,null,null,null,{"$f":"+G15+D15","v":0},null,null,null,null,null,null,{"$f":"+N15+K15","v":0}]

{"sheet":"UG Non-Trad Input","index":6,"n_rows":16,"n_cols":37,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,30,0,36],[0,2,0,8],[0,9,0,15],[0,16,0,22],[0,23,0,29]]}
[null,null,"Year 1",null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,"Year 3",null,null,null,null,null,null,"Year 4",null,null,null,null,null,null,"Year 5"]
["Non-Traditional Undergraduate Program Revenue Assumptions:","Notes","Summer Year 1 Term 2","Fall Year 1 Term 1","Fall Year 1 Term 2","Winter Year 1","Spring Year 1 Term 1","Spring Year 1 Term 2","Summer Year 1 Term 1","Summer Year 2 Term 2","Fall Year 2 Term 1","Fall Year 2 Term 2","Winter Year 2","Spring Year 2 Term 1","Spring Year 2 Term 2","Summer Year 2 Term 1","Summer Year 3 Term 2","Fall Year 3 Term 1","Fall Year 3 Term 2","Winter Year 3","Spring Year 3 Term 1","Spring Year 3 Term 2","Summer Year 3 Term 1","Summer Year 4 Term 2","Fall Year 4 Term 1","Fall Year 4 Term 2","Winter Year 4","Spring Year 4 Term 1","Spring Year 4 Term 2","Summer Year 4 Term 1","Summer Year 5 Term 2","Fall Year 5 Term 1","Fall Year 5 Term 2","Winter Year 5","Spring Year 5 Term 1","Spring Year 5 Term 2","Summer Year 5 Term 1"]
["Enrollment",null,{"$f":"SUM(C4:C7)","v":0},{"$f":"SUM(D4:D7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Freshmen"]
["Sophomore"]
["Junior"]
["Senior"]
["Average number of credit hours per student"]
["FTE Enrollment","Assumes 24 hours per FTE",{"$f":"C3*C8/24","v":0},{"$f":"D3*D8/24","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tuition per credit hour",null,{"$f":"Assumptions!B8","v":412},{"$f":"C10","v":412},412,412,412,412,412,{"$f":"Assumptions!$C$8","v":422},{"$f":"J10","v":422},422,422,422,422,422,{"$f":"Assumptions!$D$8","v":433},{"$f":"Q10","v":433},433,433,433,433,433,{"$f":"Assumptions!$E$8","v":444},{"$f":"X10","v":444},444,444,444,444,444,{"$f":"Assumptions!$F$8","v":455},{"$f":"AE10","v":455},455,455,455,455,455]
["Tuition discount rate",null,{"$f":"Assumptions!$B$13","v":0},{"$f":"C11","v":0},0,0,0,0,0,{"$f":"Assumptions!$C$13","v":0},{"$f":"J11","v":0},0,0,0,0,0,{"$f":"Assumptions!$D$13","v":0},{"$f":"Q11","v":0},0,0,0,0,0,{"$f":"Assumptions!$E$13","v":0},{"$f":"X11","v":0},0,0,0,0,0,{"$f":"Assumptions!$F$13","v":0},{"$f":"AE11","v":0},0,0,0,0,0]
["Annual tuition increase",null,null,null,null,null,null,null,null,{"$f":"Assumptions!$C$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$D$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$E$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$F$6","v":2.5000000000000001E-2}]
[]
["Tuition",null,{"$f":"(C3*C8*C10)","v":0},{"$f":"(D3*D8*D10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tuition Discount",null,{"$f":"ROUND(C14*-C11,0)","v":0},{"$f":"ROUND(D14*-D11,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Net Tuition",null,{"$f":"C14+C15","v":0},{"$f":"D14+D15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Grad Input","index":7,"n_rows":15,"n_cols":37,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,30,0,36],[0,2,0,8],[0,9,0,15],[0,16,0,22],[0,23,0,29]]}
[null,null,"Year 1",null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,"Year 3",null,null,null,null,null,null,"Year 4",null,null,null,null,null,null,"Year 5"]
["Graduate Program Revenue Assumptions:","Notes","Summer Year 1 Term 2","Fall Year 1 Term 1","Fall Year 1 Term 2","Winter Year 1","Spring Year 1 Term 1","Spring Year 1 Term 2","Summer Year 1 Term 1","Summer Year 2 Term 2","Fall Year 2 Term 1","Fall Year 2 Term 2","Winter Year 2","Spring Year 2 Term 1","Spring Year 2 Term 2","Summer Year 2 Term 1","Summer Year 3 Term 2","Fall Year 3 Term 1","Fall Year 3 Term 2","Winter Year 3","Spring Year 3 Term 1","Spring Year 3 Term 2","Summer Year 3 Term 1","Summer Year 4 Term 2","Fall Year 4 Term 1","Fall Year 4 Term 2","Winter Year 4","Spring Year 4 Term 1","Spring Year 4 Term 2","Summer Year 4 Term 1","Summer Year 5 Term 2","Fall Year 5 Term 1","Fall Year 5 Term 2","Winter Year 5","Spring Year 5 Term 1","Spring Year 5 Term 2","Summer Year 5 Term 1"]
["Enrollment",null,{"$f":"SUM(C4:C5)","v":0},{"$f":"SUM(D4:D5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["1st Year Students"]
["2nd Year Students"]
["Average number of credit hours per student"]
["1st Year Students"]
["2nd Year Students"]
["FTE Enrollment","Assumes 20 hours per FTE",{"$f":"((C4*C7)+(C5*C8))/20","v":0},{"$f":"((D4*D7)+(D5*D8))/20","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tuition per credit hour",null,{"$f":"Assumptions!B9","v":780},{"$f":"C10","v":780},780,780,780,780,780,{"$f":"Assumptions!$C$9","v":800},{"$f":"J10","v":800},800,800,800,800,800,{"$f":"Assumptions!$D$9","v":820},{"$f":"Q10","v":820},820,820,820,820,820,{"$f":"Assumptions!$E$9","v":841},{"$f":"X10","v":841},841,841,841,841,841,{"$f":"Assumptions!$F$9","v":862},{"$f":"AE10","v":862},862,862,862,862,862]
["Tuition discount rate",null,{"$f":"Assumptions!$B$14","v":0},{"$f":"C11","v":0},0,0,0,0,0,{"$f":"Assumptions!$C$14","v":0},{"$f":"J11","v":0},0,0,0,0,0,{"$f":"Assumptions!$D$14","v":0},{"$f":"Q11","v":0},0,0,0,0,0,{"$f":"Assumptions!$E$14","v":0},{"$f":"X11","v":0},0,0,0,0,0,{"$f":"Assumptions!$F$14","v":0},{"$f":"AE11","v":0},0,0,0,0,0]
["Annual tuition increase",null,null,null,null,null,null,null,null,{"$f":"Assumptions!$C$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$D$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$E$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$F$6","v":2.5000000000000001E-2}]
["Tuition",null,{"$f":"(C4*C7*C10)+(C5*C8*C10)","v":0},{"$f":"(D4*D7*D10)+(D5*D8*D10)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Tuition Discount",null,{"$f":"ROUND(C13*-C11,0)","v":0},{"$f":"ROUND(D13*-D11,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Net Tuition",null,{"$f":"C13+C14","v":0},{"$f":"D13+D14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Certificate Input","index":8,"n_rows":14,"n_cols":37,"rows_kept":14,"cut":false,"hidden":true,"merged":[[0,30,0,36],[0,2,0,8],[0,9,0,15],[0,16,0,22],[0,23,0,29]]}
[null,null,"Year 1",null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,"Year 3",null,null,null,null,null,null,"Year 4",null,null,null,null,null,null,"Year 5"]
["Certificate/Symposium/Seminar/Workshop Program Revenue Assumptions","Notes","Summer Year 1 Term 2","Fall Year 1 Term 1","Fall Year 1 Term 2","Winter Year 1","Spring Year 1 Term 1","Spring Year 1 Term 2","Summer Year 1 Term 1","Summer Year 2 Term 2","Fall Year 2 Term 1","Fall Year 2 Term 2","Winter Year 2","Spring Year 2 Term 1","Spring Year 2 Term 2","Summer Year 2 Term 1","Summer Year 3 Term 2","Fall Year 3 Term 1","Fall Year 3 Term 2","Winter Year 3","Spring Year 3 Term 1","Spring Year 3 Term 2","Summer Year 3 Term 1","Summer Year 4 Term 2","Fall Year 4 Term 1","Fall Year 4 Term 2","Winter Year 4","Spring Year 4 Term 1","Spring Year 4 Term 2","Summer Year 4 Term 1","Summer Year 5 Term 2","Fall Year 5 Term 1","Fall Year 5 Term 2","Winter Year 5","Spring Year 5 Term 1","Spring Year 5 Term 2","Summer Year 5 Term 1"]
["Certificate/Symposium/Seminar/Workshop Program Revenue Assumptions - Flat Rate Program:"]
["Enrollment"]
["Tuition per student",null,{"$f":"Assumptions!B10","v":1500},{"$f":"C5","v":1500},1500,1500,1500,1500,1500,{"$f":"Assumptions!$C$10","v":1538},{"$f":"J5","v":1538},1538,1538,1538,1538,1538,{"$f":"Assumptions!$D$10","v":1576},{"$f":"Q5","v":1576},1576,1576,1576,1576,1576,{"$f":"Assumptions!$E$10","v":1615},{"$f":"X5","v":1615},1615,1615,1615,1615,1615,{"$f":"Assumptions!$F$10","v":1655},{"$f":"AE5","v":1655},1655,1655,1655,1655,1655]
["Annual tuition increase",null,null,null,null,null,null,null,null,{"$f":"Assumptions!$C$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$D$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$E$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$F$6","v":2.5000000000000001E-2}]
["Tuition",null,{"$f":"C4*C5","v":0},{"$f":"D4*D5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Certificate/Symposium/Seminar/Workshop Program Revenue Assumptions - Based On Credit Hours:"]
["Student Enrollment"]
["Average number of credit hours per student"]
["Tuition per credit hour",null,{"$f":"Assumptions!B11","v":780},{"$f":"C12","v":780},{"$f":"D12","v":780},{"$f":"E12","v":780},{"$f":"F12","v":780},{"$f":"G12","v":780},{"$f":"H12","v":780},{"$f":"Assumptions!$C$11","v":800},{"$f":"J12","v":800},{"$f":"K12","v":800},{"$f":"L12","v":800},{"$f":"M12","v":800},{"$f":"N12","v":800},{"$f":"O12","v":800},{"$f":"Assumptions!$D$11","v":820},{"$f":"Q12","v":820},{"$f":"R12","v":820},{"$f":"S12","v":820},{"$f":"T12","v":820},{"$f":"U12","v":820},{"$f":"V12","v":820},{"$f":"Assumptions!$E$11","v":841},{"$f":"X12","v":841},{"$f":"Y12","v":841},{"$f":"Z12","v":841},{"$f":"AA12","v":841},{"$f":"AB12","v":841},{"$f":"AC12","v":841},{"$f":"Assumptions!$F$11","v":862},{"$f":"AE12","v":862},{"$f":"AF12","v":862},{"$f":"AG12","v":862},{"$f":"AH12","v":862},{"$f":"AI12","v":862},{"$f":"AJ12","v":862}]
["Annual tuition increase",null,null,null,null,null,null,null,null,{"$f":"Assumptions!$C$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$D$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$E$6","v":2.5000000000000001E-2},null,null,null,null,null,null,{"$f":"Assumptions!$F$6","v":2.5000000000000001E-2}]
["Tuition",null,{"$f":"(C10*C11*C12)","v":0},{"$f":"(D10*D11*D12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Endow&Gift Input","index":9,"n_rows":6,"n_cols":37,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,30,0,36],[0,2,0,8],[0,9,0,15],[0,16,0,22],[0,23,0,29]]}
[null,null,"Year 1",null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,"Year 3",null,null,null,null,null,null,"Year 4",null,null,null,null,null,null,"Year 5"]
["Other Revenue Assumptions:","Notes","Summer Year 1 Term 2","Fall Year 1 Term 1","Fall Year 1 Term 2","Winter Year 1","Spring Year 1 Term 1","Spring Year 1 Term 2","Summer Year 1 Term 1","Summer Year 2 Term 2","Fall Year 2 Term 1","Fall Year 2 Term 2","Winter Year 2","Spring Year 2 Term 1","Spring Year 2 Term 2","Summer Year 2 Term 1","Summer Year 3 Term 2","Fall Year 3 Term 1","Fall Year 3 Term 2","Winter Year 3","Spring Year 3 Term 1","Spring Year 3 Term 2","Summer Year 3 Term 1","Summer Year 4 Term 2","Fall Year 4 Term 1","Fall Year 4 Term 2","Winter Year 4","Spring Year 4 Term 1","Spring Year 4 Term 2","Summer Year 4 Term 1","Summer Year 5 Term 2","Fall Year 5 Term 1","Fall Year 5 Term 2","Winter Year 5","Spring Year 5 Term 1","Spring Year 5 Term 2","Summer Year 5 Term 1"]
["Other Income:"]
["Endowment Income"]
["Gift Income"]
["Other Revenue"]

{"sheet":"Expense Input","index":10,"n_rows":53,"n_cols":37,"rows_kept":53,"cut":false,"hidden":true,"merged":[[0,30,0,36],[0,2,0,8],[0,9,0,15],[0,16,0,22],[0,23,0,29]]}
[null,null,"Year 1",null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,"Year 3",null,null,null,null,null,null,"Year 4",null,null,null,null,null,null,"Year 5"]
["Expense Assumptions:","Notes","Summer Year 1 Term 2","Fall Year 1 Term 1","Fall Year 1 Term 2","Winter Year 1","Spring Year 1 Term 1","Spring Year 1 Term 2","Summer Year 1 Term 1","Summer Year 2 Term 2","Fall Year 2 Term 1","Fall Year 2 Term 2","Winter Year 2","Spring Year 2 Term 1","Spring Year 2 Term 2","Summer Year 2 Term 1","Summer Year 3 Term 2","Fall Year 3 Term 1","Fall Year 3 Term 2","Winter Year 3","Spring Year 3 Term 1","Spring Year 3 Term 2","Summer Year 3 Term 1","Summer Year 4 Term 2","Fall Year 4 Term 1","Fall Year 4 Term 2","Winter Year 4","Spring Year 4 Term 1","Spring Year 4 Term 2","Summer Year 4 Term 1","Summer Year 5 Term 2","Fall Year 5 Term 1","Fall Year 5 Term 2","Winter Year 5","Spring Year 5 Term 1","Spring Year 5 Term 2","Summer Year 5 Term 1"]
["Incremental Faculty FTEs"]
["Incremental Staff FTEs"]
[]
["Faculty Salaries to be added"]
["Adjunct faculty to be added"]
["Staff Salaries to be added"]
["Course development stipends ($4000 per course)"]
["Teaching Assistant/Fellowship stipends"]
["Student Employment"]
["Benefits Rate",null,{"$f":"Assumptions!$B$15","v":0.28599999999999998},null,null,null,null,null,null,{"$f":"Assumptions!$C$15","v":0.28599999999999998},null,null,null,null,null,null,{"$f":"Assumptions!$D$15","v":0.28599999999999998},null,null,null,null,null,null,{"$f":"Assumptions!$E$15","v":0.28599999999999998},null,null,null,null,null,null,{"$f":"Assumptions!$F$15","v":0.28599999999999998}]
["Total Salaries",null,{"$f":"SUM(C6:C11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Benefits",null,{"$f":"SUM(C6:C11)*$C$12","v":0},{"$f":"SUM(D6:D11)*$C$12","v":0},0,0,0,0,0,{"$f":"SUM(J6:J11)*$J$12","v":0},{"$f":"SUM(K6:K11)*$J$12","v":0},0,0,0,0,0,{"$f":"SUM(Q6:Q11)*$Q$12","v":0},{"$f":"SUM(R6:R11)*$Q$12","v":0},0,0,0,0,0,{"$f":"SUM(X6:X11)*$X$12","v":0},{"$f":"SUM(Y6:Y11)*$X$12","v":0},0,0,0,0,0,{"$f":"SUM(AE6:AE11)*$AE$12","v":0},{"$f":"SUM(AF6:AF11)*$AE$12","v":0},0,0,0,0,0]
[]
["Non-Salary Expenses"]
["Direct Instructional Expenses",null,{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!C3+'UG Non-Trad Input'!C3+'Grad Input'!C3+'Certificate Input'!C4+'Certificate Input'!C10)*Assumptions!$B$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!D3+'UG Non-Trad Input'!D3+'Grad Input'!D3+'Certificate Input'!D4+'Certificate Input'!D10)*Assumptions!$B$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!E3+'UG Non-Trad Input'!E3+'Grad Input'!E3+'Certificate Input'!E4+'Certificate Input'!E10)*Assumptions!$B$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!F3+'UG Non-Trad Input'!F3+'Grad Input'!F3+'Certificate Input'!F4+'Certificate Input'!F10)*Assumptions!$B$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!G3+'UG Non-Trad Input'!G3+'Grad Input'!G3+'Certificate Input'!G4+'Certificate Input'!G10)*Assumptions!$B$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!H3+'UG Non-Trad Input'!H3+'Grad Input'!H3+'Certificate Input'!H4+'Certificate Input'!H10)*Assumptions!$B$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!I3+'UG Non-Trad Input'!I3+'Grad Input'!I3+'Certificate Input'!I4+'Certificate Input'!I10)*Assumptions!$B$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!J3+'UG Non-Trad Input'!J3+'Grad Input'!J3+'Certificate Input'!J4+'Certificate Input'!J10)*Assumptions!$C$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!K3+'UG Non-Trad Input'!K3+'Grad Input'!K3+'Certificate Input'!K4+'Certificate Input'!K10)*Assumptions!$C$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!L3+'UG Non-Trad Input'!L3+'Grad Input'!L3+'Certificate Input'!L4+'Certificate Input'!L10)*Assumptions!$C$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!M3+'UG Non-Trad Input'!M3+'Grad Input'!M3+'Certificate Input'!M4+'Certificate Input'!M10)*Assumptions!$C$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!N3+'UG Non-Trad Input'!N3+'Grad Input'!N3+'Certificate Input'!N4+'Certificate Input'!N10)*Assumptions!$C$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!O3+'UG Non-Trad Input'!O3+'Grad Input'!O3+'Certificate Input'!O4+'Certificate Input'!O10)*Assumptions!$C$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!P3+'UG Non-Trad Input'!P3+'Grad Input'!P3+'Certificate Input'!P4+'Certificate Input'!P10)*Assumptions!$C$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!Q3+'UG Non-Trad Input'!Q3+'Grad Input'!Q3+'Certificate Input'!Q4+'Certificate Input'!Q10)*Assumptions!$D$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!R3+'UG Non-Trad Input'!R3+'Grad Input'!R3+'Certificate Input'!R4+'Certificate Input'!R10)*Assumptions!$D$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!S3+'UG Non-Trad Input'!S3+'Grad Input'!S3+'Certificate Input'!S4+'Certificate Input'!S10)*Assumptions!$D$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!T3+'UG Non-Trad Input'!T3+'Grad Input'!T3+'Certificate Input'!T4+'Certificate Input'!T10)*Assumptions!$D$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!U3+'UG Non-Trad Input'!U3+'Grad Input'!U3+'Certificate Input'!U4+'Certificate Input'!U10)*Assumptions!$D$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!V3+'UG Non-Trad Input'!V3+'Grad Input'!V3+'Certificate Input'!V4+'Certificate Input'!V10)*Assumptions!$D$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!W3+'UG Non-Trad Input'!W3+'Grad Input'!W3+'Certificate Input'!W4+'Certificate Input'!W10)*Assumptions!$D$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!X3+'UG Non-Trad Input'!X3+'Grad Input'!X3+'Certificate Input'!X4+'Certificate Input'!X10)*Assumptions!$E$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!Y3+'UG Non-Trad Input'!Y3+'Grad Input'!Y3+'Certificate Input'!Y4+'Certificate Input'!Y10)*Assumptions!$E$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!Z3+'UG Non-Trad Input'!Z3+'Grad Input'!Z3+'Certificate Input'!Z4+'Certificate Input'!Z10)*Assumptions!$E$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AA3+'UG Non-Trad Input'!AA3+'Grad Input'!AA3+'Certificate Input'!AA4+'Certificate Input'!AA10)*Assumptions!$E$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AB3+'UG Non-Trad Input'!AB3+'Grad Input'!AB3+'Certificate Input'!AB4+'Certificate Input'!AB10)*Assumptions!$E$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AC3+'UG Non-Trad Input'!AC3+'Grad Input'!AC3+'Certificate Input'!AC4+'Certificate Input'!AC10)*Assumptions!$E$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AD3+'UG Non-Trad Input'!AD3+'Grad Input'!AD3+'Certificate Input'!AD4+'Certificate Input'!AD10)*Assumptions!$E$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AE3+'UG Non-Trad Input'!AE3+'Grad Input'!AE3+'Certificate Input'!AE4+'Certificate Input'!AE10)*Assumptions!$F$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AF3+'UG Non-Trad Input'!AF3+'Grad Input'!AF3+'Certificate Input'!AF4+'Certificate Input'!AF10)*Assumptions!$F$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AG3+'UG Non-Trad Input'!AG3+'Grad Input'!AG3+'Certificate Input'!AG4+'Certificate Input'!AG10)*Assumptions!$F$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AH3+'UG Non-Trad Input'!AH3+'Grad Input'!AH3+'Certificate Input'!AH4+'Certificate Input'!AH10)*Assumptions!$F$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AI3+'UG Non-Trad Input'!AI3+'Grad Input'!AI3+'Certificate Input'!AI4+'Certificate Input'!AI10)*Assumptions!$F$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AJ3+'UG Non-Trad Input'!AJ3+'Grad Input'!AJ3+'Certificate Input'!AJ4+'Certificate Input'!AJ10)*Assumptions!$F$19)","v":0},{"$f":"IF('General Input'!$B$6=\"Online Program\",0,('UG Trad Input'!AK3+'UG Non-Trad Input'!AK3+'Grad Input'!AK3+'Certificate Input'!AK4+'Certificate Input'!AK10)*Assumptions!$F$19)","v":0}]
["Equipment Costs"]
["Departmental Costs % of net revenue",null,{"$f":"Assumptions!$B$16","v":0.1},null,null,null,null,null,null,{"$f":"Assumptions!$C$16","v":0.1},null,null,null,null,null,null,{"$f":"Assumptions!$D$16","v":0.1},null,null,null,null,null,null,{"$f":"Assumptions!$E$16","v":0.1},null,null,null,null,null,null,{"$f":"Assumptions!$F$16","v":0.1}]
["Departmental Costs",null,{"$f":"'By Term Summary'!B$16*$C$19","v":0},{"$f":"'By Term Summary'!C$16*$C$19","v":0},{"$f":"'By Term Summary'!D$16*$C$19","v":0},{"$f":"'By Term Summary'!E$16*$C$19","v":0},{"$f":"'By Term Summary'!F$16*$C$19","v":0},{"$f":"'By Term Summary'!G$16*$C$19","v":0},{"$f":"'By Term Summary'!H$16*$C$19","v":0},{"$f":"'By Term Summary'!I$16*$J$19","v":0},{"$f":"'By Term Summary'!J$16*$J$19","v":0},{"$f":"'By Term Summary'!K$16*$J$19","v":0},{"$f":"'By Term Summary'!L$16*$J$19","v":0},{"$f":"'By Term Summary'!M$16*$J$19","v":0},{"$f":"'By Term Summary'!N$16*$J$19","v":0},{"$f":"'By Term Summary'!O$16*$J$19","v":0},{"$f":"'By Term Summary'!P$16*$Q$19","v":0},{"$f":"'By Term Summary'!Q$16*$Q$19","v":0},{"$f":"'By Term Summary'!R$16*$Q$19","v":0},{"$f":"'By Term Summary'!S$16*$Q$19","v":0},{"$f":"'By Term Summary'!T$16*$Q$19","v":0},{"$f":"'By Term Summary'!U$16*$Q$19","v":0},{"$f":"'By Term Summary'!V$16*$Q$19","v":0},{"$f":"'By Term Summary'!W$16*$X$19","v":0},{"$f":"'By Term Summary'!X$16*$X$19","v":0},{"$f":"'By Term Summary'!Y$16*$X$19","v":0},{"$f":"'By Term Summary'!Z$16*$X$19","v":0},{"$f":"'By Term Summary'!AA$16*$X$19","v":0},{"$f":"'By Term Summary'!AB$16*$X$19","v":0},{"$f":"'By Term Summary'!AC$16*$X$19","v":0},{"$f":"'By Term Summary'!AD$16*$AE$19","v":0},{"$f":"'By Term Summary'!AE$16*$AE$19","v":0},{"$f":"'By Term Summary'!AF$16*$AE$19","v":0},{"$f":"'By Term Summary'!AG$16*$AE$19","v":0},{"$f":"'By Term Summary'!AH$16*$AE$19","v":0},{"$f":"'By Term Summary'!AI$16*$AE$19","v":0},{"$f":"'By Term Summary'!AJ$16*$AE$19","v":0}]
["Marketing",null,{"$f":"Assumptions!$B$17","v":25000},null,null,null,null,null,null,{"$f":"Assumptions!$C$17","v":25000},null,null,null,null,null,null,{"$f":"Assumptions!$D$17","v":25000},null,null,null,null,null,null,{"$f":"Assumptions!$E$17","v":25000},null,null,null,null,null,null,{"$f":"Assumptions!$F$17","v":25000}]
["Office start up costs for new faculty and staff (computer & phone)",{"$f":"Assumptions!$B$20","v":1500},{"$f":"$B$22*(ROUNDUP((C3+C4),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
["Facilities - remodel"]
["Facilities - build out/new"]
["Other initial investment"]
[]
["Overhead, including facilities & marketing",null,{"$f":"'By Term Summary'!B$16*Assumptions!$B$18","v":0},{"$f":"'By Term Summary'!C$16*Assumptions!$B$18","v":0},{"$f":"'By Term Summary'!D$16*Assumptions!$B$18","v":0},{"$f":"'By Term Summary'!E$16*Assumptions!$B$18","v":0},{"$f":"'By Term Summary'!F$16*Assumptions!$B$18","v":0},{"$f":"'By Term Summary'!G$16*Assumptions!$B$18","v":0},{"$f":"'By Term Summary'!H$16*Assumptions!$B$18","v":0},{"$f":"'By Term Summary'!I$16*Assumptions!$C$18","v":0},{"$f":"'By Term Summary'!J$16*Assumptions!$C$18","v":0},{"$f":"'By Term Summary'!K$16*Assumptions!$C$18","v":0},{"$f":"'By Term Summary'!L$16*Assumptions!$C$18","v":0},{"$f":"'By Term Summary'!M$16*Assumptions!$C$18","v":0},{"$f":"'By Term Summary'!N$16*Assumptions!$C$18","v":0},{"$f":"'By Term Summary'!O$16*Assumptions!$C$18","v":0},{"$f":"'By Term Summary'!P$16*Assumptions!$D$18","v":0},{"$f":"'By Term Summary'!Q$16*Assumptions!$D$18","v":0},{"$f":"'By Term Summary'!R$16*Assumptions!$D$18","v":0},{"$f":"'By Term Summary'!S$16*Assumptions!$D$18","v":0},{"$f":"'By Term Summary'!T$16*Assumptions!$D$18","v":0},{"$f":"'By Term Summary'!U$16*Assumptions!$D$18","v":0},{"$f":"'By Term Summary'!V$16*Assumptions!$D$18","v":0},{"$f":"'By Term Summary'!W$16*Assumptions!$E$18","v":0},{"$f":"'By Term Summary'!X$16*Assumptions!$E$18","v":0},{"$f":"'By Term Summary'!Y$16*Assumptions!$E$18","v":0},{"$f":"'By Term Summary'!Z$16*Assumptions!$E$18","v":0},{"$f":"'By Term Summary'!AA$16*Assumptions!$E$18","v":0},{"$f":"'By Term Summary'!AB$16*Assumptions!$E$18","v":0},{"$f":"'By Term Summary'!AC$16*Assumptions!$E$18","v":0},{"$f":"'By Term Summary'!AD$16*Assumptions!$F$18","v":0},{"$f":"'By Term Summary'!AE$16*Assumptions!$F$18","v":0},{"$f":"'By Term Summary'!AF$16*Assumptions!$F$18","v":0},{"$f":"'By Term Summary'!AG$16*Assumptions!$F$18","v":0},{"$f":"'By Term Summary'!AH$16*Assumptions!$F$18","v":0},{"$f":"'By Term Summary'!AI$16*Assumptions!$F$18","v":0},{"$f":"'By Term Summary'!AJ$16*Assumptions!$F$18","v":0}]
[]
["Non-Salary Expenses",null,{"$f":"C16+C17+C20+C21+C22","v":25000},0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0]
["Capital Expenses",null,{"$f":"C18+C26+C27","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total Expenses",null,{"$f":"C13+C32+C33","v":25000},0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0,25000,0,0,0,0,0,0]
[]
["Transfers"]
[]
["Administrative Overhead",null,{"$f":"C30","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Overhead",null,{"$f":"SUM(C39:C39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Utilizing Reallocated Faculty and Staff:"]
[]
["Reallocated Faculty FTEs"]
["Reallocated Staff FTEs"]
[]
["Faculty Salaries to be reallocated"]
["Adjunct faculty to be reallocated"]
["Staff to be reallocated"]
["Benefits Rate",null,{"$f":"Assumptions!$B$15","v":0.28599999999999998},null,null,null,null,null,null,{"$f":"Assumptions!$C$15","v":0.28599999999999998},null,null,null,null,null,null,{"$f":"Assumptions!$D$15","v":0.28599999999999998},null,null,null,null,null,null,{"$f":"Assumptions!$E$15","v":0.28599999999999998},null,null,null,null,null,null,{"$f":"Assumptions!$F$15","v":0.28599999999999998}]
["Total Salaries",null,{"$f":"SUM(C48:C50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Benefits",null,{"$f":"SUM(C48:C50)*$C$51","v":0},{"$f":"SUM(D48:D50)*$C$51","v":0},0,0,0,0,0,{"$f":"SUM(J48:J50)*$J$51","v":0},{"$f":"SUM(K48:K50)*$J$51","v":0},0,0,0,0,0,{"$f":"SUM(Q48:Q50)*$Q$51","v":0},{"$f":"SUM(R48:R50)*$Q$51","v":0},0,0,0,0,0,{"$f":"SUM(X48:X50)*$X$51","v":0},{"$f":"SUM(Y48:Y50)*$X$51","v":0},0,0,0,0,0,{"$f":"SUM(AE48:AE50)*$AE$51","v":0},{"$f":"SUM(AF48:AF50)*$AE$51","v":0},0,0,0,0,0]

{"sheet":"DEFS","index":11,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
["Program Type"]
["Traditional Undergraduate Revenue"]
["Non-Traditional Undergraduate Revenue"]
["Graduate Program Revenue"]
["Certificate Program - Flat Rate"]
["Certificate Program - Credit Hour Based"]
["Other Revenue"]

{"sheet":"prt_T_UG","index":12,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["New Program Financial Input"]
[null,"Program Name:"]
[null,"Program Type:",null,"Traditional Undergraduate Revenue"]
[null,"Contact Name:"]
[]
[null,"Traditional Undergrad - Expected Full Time Enrollment",null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"Fall"]
[null,"   ","Freshmen",null,null,null,null,null,{"$f":"SUM(D9:H9)","v":0}]
[null,null,"Sophomore",null,null,null,null,null,{"$f":"SUM(D10:H10)","v":0}]
[null,null,"Junior",null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,null,"Senior",null,null,null,null,null,{"$f":"SUM(D12:H12)","v":0}]
[null,null,"Total",{"$f":"SUM(D9:D12)","v":0},{"$f":"SUM(E9:E12)","v":0},{"$f":"SUM(F9:F12)","v":0},{"$f":"SUM(G9:G12)","v":0},{"$f":"SUM(H9:H12)","v":0}]
[null,"Spring"]
[null,"   ","Freshmen",null,null,null,null,null,{"$f":"SUM(D15:H15)","v":0}]
[null,null,"Sophomore",null,null,null,null,null,{"$f":"SUM(D16:H16)","v":0}]
[null,null,"Junior",null,null,null,null,null,{"$f":"SUM(D17:H17)","v":0}]
[null,null,"Senior",null,null,null,null,null,{"$f":"SUM(D18:H18)","v":0}]
[null,null,null,{"$f":"SUM(D15:D18)","v":0},{"$f":"SUM(E15:E18)","v":0},{"$f":"SUM(F15:F18)","v":0},{"$f":"SUM(G15:G18)","v":0},{"$f":"SUM(H15:H18)","v":0}]

{"sheet":"prt_NT_UG","index":13,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
["New Program Financial Input"]
[null,"Program Name:"]
[null,"Program Type:",null,"Non-Traditional Undergraduate Revenue"]
[null,"Contact Name:"]
[]
[null,"Non-Traditional Undergrad"]
[null,"Freshman Expected Enrollment"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2",null,null,null,null,null,null,{"$f":"SUM(D10:H10)","v":0}]
[null,"  Fall Term 1",null,null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,"  Fall Term 2",null,null,null,null,null,null,{"$f":"SUM(D12:H12)","v":0}]
[null,"  Winter Term",null,null,null,null,null,null,{"$f":"SUM(D13:H13)","v":0}]
[null,"  Spring Term 1",null,null,null,null,null,null,0]
[null,"  Spring Term 2",null,null,null,null,null,null,0]
[null,"  Summer Term 1",null,null,null,null,null,null,{"$f":"SUM(D16:H16)","v":0}]
[null,null,"Total",{"$f":"SUM(D10:D16)","v":0},{"$f":"SUM(E10:E16)","v":0},{"$f":"SUM(F10:F16)","v":0},{"$f":"SUM(G10:G16)","v":0},{"$f":"SUM(H10:H16)","v":0}]
[]
[null,"Sophomore Expected Enrollment"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2",null,null,null,null,null,null,{"$f":"SUM(D21:H21)","v":0}]
[null,"  Fall Term 1",null,null,null,null,null,null,{"$f":"SUM(D22:H22)","v":0}]
[null,"  Fall Term 2",null,null,null,null,null,null,{"$f":"SUM(D23:H23)","v":0}]
[null,"  Winter Term",null,null,null,null,null,null,{"$f":"SUM(D24:H24)","v":0}]
[null,"  Spring Term 1",null,null,null,null,null,null,0]
[null,"  Spring Term 2",null,null,null,null,null,null,0]
[null,"  Summer Term 1",null,null,null,null,null,null,{"$f":"SUM(D27:H27)","v":0}]
[null,null,"Total",{"$f":"SUM(D21:D27)","v":0},{"$f":"SUM(E21:E27)","v":0},{"$f":"SUM(F21:F27)","v":0},{"$f":"SUM(G21:G27)","v":0},{"$f":"SUM(H21:H27)","v":0}]
[]
[null,"Junior Expected Enrollment"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2",null,null,null,null,null,null,{"$f":"SUM(D32:H32)","v":0}]
[null,"  Fall Term 1",null,null,null,null,null,null,{"$f":"SUM(D33:H33)","v":0}]
[null,"  Fall Term 2",null,null,null,null,null,null,{"$f":"SUM(D34:H34)","v":0}]
[null,"  Winter Term",null,null,null,null,null,null,{"$f":"SUM(D35:H35)","v":0}]
[null,"  Spring Term 1",null,null,null,null,null,null,0]
[null,"  Spring Term 2",null,null,null,null,null,null,0]
[null,"  Summer Term 1",null,null,null,null,null,null,{"$f":"SUM(D38:H38)","v":0}]
[null,null,"Total",{"$f":"SUM(D32:D38)","v":0},{"$f":"SUM(E32:E38)","v":0},{"$f":"SUM(F32:F38)","v":0},{"$f":"SUM(G32:G38)","v":0},{"$f":"SUM(H32:H38)","v":0}]
[]
[null,"Senior Expected Enrollment"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2",null,null,null,null,null,null,{"$f":"SUM(D43:H43)","v":0}]
[null,"  Fall Term 1",null,null,null,null,null,null,{"$f":"SUM(D44:H44)","v":0}]
[null,"  Fall Term 2",null,null,null,null,null,null,{"$f":"SUM(D45:H45)","v":0}]
[null,"  Winter Term",null,null,null,null,null,null,{"$f":"SUM(D46:H46)","v":0}]
[null,"  Spring Term 1",null,null,null,null,null,null,0]
[null,"  Spring Term 2",null,null,null,null,null,null,0]
[null,"  Summer Term 1",null,null,null,null,null,null,{"$f":"SUM(D49:H49)","v":0}]
[null,null,"Total",{"$f":"SUM(D43:D49)","v":0},{"$f":"SUM(E43:E49)","v":0},{"$f":"SUM(F43:F49)","v":0},{"$f":"SUM(G43:G49)","v":0},{"$f":"SUM(H43:H49)","v":0}]
[]
[null,"Average Credit Hours per Student"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2"]
[null,"  Fall Term 1"]
[null,"  Fall Term 2"]
[null,"  Winter Term"]
[null,"  Spring Term 1"]
[null,"  Spring Term 2"]
[null,"  Summer Term 1"]
[]
[null,"Tuition & Fees Income"]
[null,null,null,"Year 1"]
[null,"  Tuition per Credit Hour",null,400]
[null,"  Tuitino Discount Rate",null,0]
[null," ",null,0]
[null,"  "]
[null," "]
[null," "]

{"sheet":"prt_GRAD","index":14,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
["New Program Financial Input"]
[null,"Program Name:"]
[null,"Program Type:",null,"Graduate Program Revenue"]
[null,"Contact Name:"]
[]
[null,"Graduate "]
[null,"1st Year Students"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2",null,null,null,null,null,null,{"$f":"SUM(D10:H10)","v":0}]
[null,"  Fall Term 1",null,null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,"  Fall Term 2",null,null,null,null,null,null,{"$f":"SUM(D12:H12)","v":0}]
[null,"  Winter Term",null,null,null,null,null,null,{"$f":"SUM(D13:H13)","v":0}]
[null,"  Spring Term 1",null,null,null,null,null,null,0]
[null,"  Spring Term 2",null,null,null,null,null,null,0]
[null,"  Summer Term 1",null,null,null,null,null,null,{"$f":"SUM(D16:H16)","v":0}]
[null,null,"Total",{"$f":"SUM(D10:D16)","v":0},{"$f":"SUM(E10:E16)","v":0},{"$f":"SUM(F10:F16)","v":0},{"$f":"SUM(G10:G16)","v":0},{"$f":"SUM(H10:H16)","v":0}]
[]
[null,"2nd Year Students"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2",null,null,null,null,null,null,{"$f":"SUM(D21:H21)","v":0}]
[null,"  Fall Term 1",null,null,null,null,null,null,{"$f":"SUM(D22:H22)","v":0}]
[null,"  Fall Term 2",null,null,null,null,null,null,{"$f":"SUM(D23:H23)","v":0}]
[null,"  Winter Term",null,null,null,null,null,null,{"$f":"SUM(D24:H24)","v":0}]
[null,"  Spring Term 1",null,null,null,null,null,null,0]
[null,"  Spring Term 2",null,null,null,null,null,null,0]
[null,"  Summer Term 1",null,null,null,null,null,null,{"$f":"SUM(D27:H27)","v":0}]
[null,null,"Total",{"$f":"SUM(D21:D27)","v":0},{"$f":"SUM(E21:E27)","v":0},{"$f":"SUM(F21:F27)","v":0},{"$f":"SUM(G21:G27)","v":0},{"$f":"SUM(H21:H27)","v":0}]
[]
[]
[null,"Average Credit Hours per 1st Year Student"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2"]
[null,"  Fall Term 1"]
[null,"  Fall Term 2"]
[null,"  Winter Term"]
[null,"  Spring Term 1"]
[null,"  Spring Term 2"]
[null,"  Summer Term 1"]
[]
[null,"Average Credit Hours per 2nd Year Student"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2"]
[null,"  Fall Term 1"]
[null,"  Fall Term 2"]
[null,"  Winter Term"]
[null,"  Spring Term 1"]
[null,"  Spring Term 2"]
[null,"  Summer Term 1"]
[]
[null,"Tuition & Fees Income"]
[null,null,null,"Year 1"]
[null,"  Tuition per Credit Hour",null,756]
[null,"  Tuitino Discount Rate",null,0]
[null," ",null,0]
[null,"  "]
[null," "]
[null," "]

{"sheet":"prt_CERT_FR","index":15,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
["New Program Financial Input"]
[null,"Program Name:"]
[null,"Program Type:",null,"Certificate Program - Flat Rate"]
[null,"Contact Name:"]
[]
[null,"Certificate Program - Flat Rate"]
[null,"Expected Enrollment"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2",null,null,null,null,null,null,{"$f":"SUM(D10:H10)","v":0}]
[null,"  Fall Term 1",null,null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,"  Fall Term 2",null,null,null,null,null,null,{"$f":"SUM(D12:H12)","v":0}]
[null,"  Winter Term",null,null,null,null,null,null,{"$f":"SUM(D13:H13)","v":0}]
[null,"  Spring Term 1",null,null,null,null,null,null,0]
[null,"  Spring Term 2",null,null,null,null,null,null,0]
[null,"  Summer Term 1",null,null,null,null,null,null,{"$f":"SUM(D16:H16)","v":0}]
[null,null,"Total",{"$f":"SUM(D10:D16)","v":0},{"$f":"SUM(E10:E16)","v":0},{"$f":"SUM(F10:F16)","v":0},{"$f":"SUM(G10:G16)","v":0},{"$f":"SUM(H10:H16)","v":0}]
[]
[]
[null,"Certificate Revenue"]
[null,null,null,"Year 1"]
[null,"Revenue per Student"]
[null," "]
[null,"  "]
[null," "]
[null," "]

{"sheet":"prt_CERT_CH","index":16,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
["New Program Financial Input"]
[null,"Program Name:"]
[null,"Program Type:",null,"Certificate Program - Credit Hour Based"]
[null,"Contact Name:"]
[]
[null,"Certificate Program - Credit Hour Based"]
[null,"Expected Enrollment"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2",null,null,null,null,null,null,{"$f":"SUM(D10:H10)","v":0}]
[null,"  Fall Term 1",null,null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,"  Fall Term 2",null,null,null,null,null,null,{"$f":"SUM(D12:H12)","v":0}]
[null,"  Winter Term",null,null,null,null,null,null,{"$f":"SUM(D13:H13)","v":0}]
[null,"  Spring Term 1",null,null,null,null,null,null,0]
[null,"  Spring Term 2",null,null,null,null,null,null,0]
[null,"  Summer Term 1",null,null,null,null,null,null,{"$f":"SUM(D16:H16)","v":0}]
[null,null,"Total",{"$f":"SUM(D10:D16)","v":0},{"$f":"SUM(E10:E16)","v":0},{"$f":"SUM(F10:F16)","v":0},{"$f":"SUM(G10:G16)","v":0},{"$f":"SUM(H10:H16)","v":0}]
[]
[null,"Average Credit Hours per Student"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Summer Term 2"]
[null,"  Fall Term 1"]
[null,"  Fall Term 2"]
[null,"  Winter Term"]
[null,"  Spring Term 1"]
[null,"  Spring Term 2"]
[null,"  Summer Term 1"]
[]
[]
[null,"Certificate Revenue"]
[null,null,null,"Year 1"]
[null,"Revenue per Credit Hour"]
[null," "]
[null,"  "]
[null," "]
[null," "]

{"sheet":"prt_OthRev","index":17,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["New Program Financial Input"]
[null,"Program Name:"]
[null,"Program Type:",null,"Other Revenue"]
[null,"Contact Name:"]
[]
[null,"Other Revenue"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"  Endowment Income",null,null,null,null,null,null,{"$f":"SUM(D9:H9)","v":0}]
[null,"  Gift Income",null,null,null,null,null,null,{"$f":"SUM(D10:H10)","v":0}]
[null,"  Other Revenue ",null,null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,null,"Total",{"$f":"SUM(D9:D11)","v":0},{"$f":"SUM(E9:E11)","v":0},{"$f":"SUM(F9:F11)","v":0},{"$f":"SUM(G9:G11)","v":0},{"$f":"SUM(H9:H11)","v":0}]

{"sheet":"prt_Expenses","index":18,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Expenses"]
[null,"Program Name:"]
[null,"Program Type:"]
[null,"Contact Name:"]
[]
[null,"Program Expenses"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,"New Faculty FTEs",null,null,null,null,null,null,{"$f":"SUM(D9:H9)","v":0}]
[null,"New Staff FTEs",null,null,null,null,null,null,{"$f":"SUM(D10:H10)","v":0}]
[null,"Course Development Stipend",null,null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,"TA/Fellowship Stipend",null,null,null,null,null,null,{"$f":"SUM(D12:H12)","v":0}]
[null,"Student Employment",null,null,null,null,null,null,0]
[null,"Total New Faculty Salary",null,null,null,null,null,null,0]
[null,"Total Adjunct Faculty Salary",null,null,null,null,null,null,{"$f":"SUM(D15:H15)","v":0}]
[null,"Total New Staff Salary",null,null,null,null,null,null,{"$f":"SUM(D16:H16)","v":0}]
[]
[]
[null,"Other Expenses"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5",{"$f":"SUM(D20:H20)","v":0}]
[null,"Equipment Costs",null,null,null,null,null,null,0]
[null,"Facilities - Remodel",null,null,null,null,null,null,0]
[null,"Facilities - New Build",null,null,null,null,null,null,0]
[null,"Other non-salary expenses",null,null,null,null,null,null,0]