{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Budget Worksheet","Data","Loan Proration","Change Log"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":27,"comments":1,"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":"Budget Worksheet","index":0,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,8,44,10],[43,11,44,18],[45,8,53,13],[45,14,53,18],[32,11,33,18],[32,8,33,10],[34,8,35,10],[34,11,35,18],[36,8,37,10],[36,11,37,18],[38,8,39,10],[38,11,39,18],[40,11,42,18],[40,8,42,10],[27,13,29,15],[2,8,2,18],[25,8,25,18],[27,8,27,10],[28,8,28,10],[29,8,29,10],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[26,13,26,15],[26,16,29,18],[52,1,52,6],[53,1,53,5],[45,1,45,5],[31,8,31,18],[1,8,1,18],[26,8,26,10],[43,1,43,2],[43,3,43,4],[44,1,44,2],[44,3,44,4],[35,1,35,4],[36,1,36,4],[32,3,32,4],[33,1,33,2],[42,1,42,2],[42,3,42,4],[51,1,51,5],[50,1,50,4],[39,1,39,4],[34,1,34,5],[46,1,46,3],[48,1,48,3],[47,1,47,3],[38,1,38,4],[41,3,41,4],[41,1,41,2],[37,1,37,4],[40,1,40,2],[40,3,40,4],[1,1,1,6],[18,1,18,3],[29,1,29,6],[13,1,13,3],[13,4,13,5],[2,1,2,6],[6,1,6,6],[5,1,5,6],[9,1,9,2],[7,5,7,6],[8,1,8,2],[7,1,7,3],[10,1,10,2],[14,1,14,6],[16,2,16,3],[17,2,17,3],[19,1,19,6],[3,5,3,6],[4,5,4,6],[12,1,12,2],[15,1,15,3],[11,1,11,2],[3,2,3,3],[4,1,4,4],[20,1,20,5],[22,1,22,3],[23,1,23,3],[22,4,22,5],[23,4,23,5],[21,1,21,5],[24,1,24,5],[25,1,25,5],[33,3,33,4],[26,1,26,5],[27,1,27,5],[31,1,31,2],[31,3,31,4],[28,1,28,6],[32,1,32,2],[30,1,30,4]]}
[]
[null,"IRIS Undergraduate Budget Worksheet",null,null,null,null,null,null,"Semester Finances Summary"]
[null,"Step 1: Enter your name and semester information. ",null,null,null,null,null,null,"Step 6: Check out your summary and next steps"]
[null,"Name:",null,null,"Semester:"]
[null,{"$f":"IF(F4=Data!K57, \"Skip to next section:\", \"Credit Hours Completed in Fall 2026 (excluding grades of W, F, I):\")","v":"Credit Hours Completed in Fall 2026 (excluding grades of W, F, I):"}]
[null,"What are my costs?"]
[null,"Step 2: Enter your credit hours by type to calculate your tuition and fees"]
[null,null,null,null,"Residency:"]
[null,"Undergraduate Tuition Types",null,"Credit Hours","Tuition Per Credit","Fees Per Credit","Total"]
[null,"On Campus/Hybrid",null,null,{"$f":"_xlfn.IFS(D10=0,0,F8=\"\",\"Select residency\",Data!B3=\"Actual\",VLOOKUP(F8,Data!B7:C15,2,FALSE), Data!B3=\"Estimated\", VLOOKUP(F8,Data!B6:F15,5,FALSE))","v":0},{"$f":"_xlfn.IFS(D10=0,0,Data!B3=\"Estimated\", Data!F13, Data!B3=\"Actual\",Data!C13)","v":0},{"$f":"D10*(E10+F10)","v":0}]
[null,"Career & Technical Education (CTE)",null,null,{"$f":"_xlfn.IFS(D11=\"\",0,F8=\"\",\"Select residency\",AND(F8=\"In-State\", Data!B3=\"Estimated\"), VLOOKUP(B11,Data!B6:F15,5,FALSE),AND(F8=\"In-State\", Data!B3=\"Actual\"), VLOOKUP(B11,Data!B6:F15,2,FALSE), AND(F8<>\"In-State\",Data!B3=\"Estimated\"), VLOOKUP(F8,Data!B6:F15,5,FALSE),AND(F8<>\"In-State\", Data!B3=\"Actual\"), VLOOKUP(F8,Data!B6:F15,2,FALSE))","v":0},{"$f":"_xlfn.IFS(D11=0,0,Data!B3=\"Estimated\", Data!F13, Data!B3=\"Actual\",Data!C13)","v":0},{"$f":"D11*(E11+F11)","v":0}]
[null,"Online",null,null,{"$f":"_xlfn.IFS(D12=0,0,F8=\"\",\"Select residency\",AND(D12<>\"\", Data!B3=\"Actual\"),VLOOKUP(B12,Data!B7:C15,2,FALSE), Data!B3=\"Estimated\", VLOOKUP(B12,Data!B6:F15,5,FALSE))","v":0},null,{"$f":"D12*E12","v":0}]
[null,{"$f":"IF(F8=Data!B7, \"COF Eligible\", \"COF applies to in-state students only\")","v":"COF applies to in-state students only"},null,null,{"$f":"_xlfn.IFS(F8<>Data!B7, 0,'Budget Worksheet'!D13<>\"Yes\", 0, AND(D13=\"Yes\",Data!B3=\"Actual\"), Data!C12*-1, AND(D13=\"Yes\",Data!B3=\"Estimated\"),Data!D12*-1)","v":0},null,{"$f":"_xlfn.IFS(D13=\"\",0,D13=\"No\",0,D13=\"Yes\",IF(F8=\"In-State\",(D10+D11+D12)*E13,0))","v":0}]
[null,{"$f":"IF(F8=Data!B7, \"What is COF? Visit www.coloradomesa.edu/cof to learn more.\", \"\")","v":""},null,null,"Tuition & Fees Total",null,{"$f":"SUM(G10:G13)","v":0}]
[null,"Step 3: Enter your housing and meal plan information"]
[null,"Housing & Food",null,null,"Rate Per Semester","Activity Fee","Total"]
[null,"Dorm",null,null,{"$f":"_xlfn.IFS(C17=\"\",0,Data!B3=\"Estimated\", VLOOKUP(C17,Data!B21:H51,7,FALSE), Data!B3=\"Actual\", VLOOKUP(C17,Data!B21:H51,3,FALSE))","v":0},{"$f":"_xlfn.IFS(C17=\"\",0, C17=\"None\", 0, AND(C17<>\"\",Data!B3=\"Actual\"),Data!B56, AND(C17<>\"\",Data!B3=\"Estimated\"),Data!E56)","v":0},{"$f":"SUM(E17:F17)","v":0}]
[null,"Meal Plan*",null,null,{"$f":"_xlfn.IFS(C18=\"\",0,AND(C18<>\"\", Data!B3=\"Estimated\"), VLOOKUP(C18,Data!B62:H69,7,FALSE),AND(C18<>\"\", Data!B3=\"Actual\"), VLOOKUP(C18,Data!B62:H69,3,FALSE) )","v":0},null,{"$f":"E18","v":0}]
[null,"Learn more at www.coloradomesa.edu/residence-life",null,null,null,"Housing & Food Total",{"$f":"SUM(G17:G18)","v":0}]
[null,"Step 4: Enter your information for other college expenses"]
[null,"Description (e.g. books, transportation, rent, etc.)",null,null,null,null,"Total"]
[null,"Do you have a past balance from a previous semester?",null,null,null,null,0]
[null,"Is this your first semester at CMU?",null,null,null,null,{"$f":"_xlfn.IFS(E23=\"\", 0, AND(E23=\"Yes\",Data!B3=\"Actual\"),Data!C76, AND(E23=\"Yes\",Data!B3=\"Estimated\"),Data!F76, E23=\"No\",0)","v":0}]
[null,"*Are you planning to buy a parking pass?",null,null,null,null,{"$f":"_xlfn.IFS(E24=\"\", 0,AND(E24<>\"\", Data!B3=\"Estimated\"), VLOOKUP(E24,Data!B81:F87, 5,FALSE), AND(E24<>\"\", Data!B3=\"Actual\"), VLOOKUP(E24,Data!B81:F87, 2,FALSE))","v":0}]
[null,"Type name of additional expenses here",null,null,null,null,0]
[null,"Type name of additional expenses here",null,null,null,null,0,null,"Check out CMU's payment plan options in the ePay app in MAVzone!"]
[null,"Total Other Expenses",null,null,null,null,{"$f":"SUM(G22:G26)","v":0},null,"Payment Plan Type",null,null,"Payment Amounts",null,"Make an Optional Initial Payment",null,null,{"$error":"#VALUE!"}]
[null,"Estimated Semester Expenses (includes estimated increases for 2026-2027)",null,null,null,null,{"$f":"SUM(G14,G19,G27)","v":0},null,"Monthly",null,null,{"$f":"IF(Data!T50>0, _xlfn.IFS(Data!U50<Data!L49,ROUNDUP(Data!T50/Data!L50,2), Data!U50<Data!M49,ROUNDUP(Data!T50/Data!M50,2),Data!U50<Data!N49,ROUNDUP(Data!T50/Data!N50,2),Data!U50>=Data!N49, \"Past Deadline\"), \"N/A\")","v":"N/A"}]
[null,"How do I plan to pay?",null,null,null,null,null,null,"Semi-Monthly",null,null,{"$f":"IF(Data!T50>0,_xlfn.IFS(Data!U50<Data!L51,ROUNDUP(Data!T50/Data!L52,2), Data!U50<Data!M51,ROUNDUP(Data!T50/Data!M52,2),Data!U50<Data!N51,ROUNDUP(Data!T50/Data!N52,2), Data!U50<Data!O51, ROUNDUP(Data!T50/Data!O52,2),Data!U50<Data!P51,ROUNDUP(Data!T50/Data!P52,2), Data!U50>=Data!P51, \"Past Deadline\"), \"N/A\")","v":"N/A"}]
[null,"Step 5: Enter your financial aid information",null,null,null,null,null,null,"Weekly",null,null,{"$f":"IF(Data!T50>0,_xlfn.IFS(Data!U50<Data!L53,ROUNDUP(Data!T50/Data!L54,2), Data!U50<Data!M53,ROUNDUP(Data!T50/Data!M54,2),Data!U50<Data!N53,ROUNDUP(Data!T50/Data!N54,2), Data!U50<Data!O53, ROUNDUP(Data!T50/Data!O54,2),Data!U50< Data!P53, ROUNDUP(Data!T50/Data!P54,2), Data!U50<Data!Q53, ROUNDUP(Data!T50/Data!Q54,2), Data!U50<Data!R53,ROUNDUP(Data!T50/Data!R54,2), Data!U50<Data!S53,ROUNDUP(Data!T50/Data!S54,2), Data!U50<Data!T53,ROUNDUP(Data!T50/Data!T54,2), Data!U50>=Data!T53, \"Past Deadline\"), \"N/A\")","v":"N/A"}]
[null,"CMU Merit Scholarships & CMU Promise",null,null,null,"Yearly Amount","Per Semester"]
[null,"CMU Merit Scholarships",null,null,null,{"$f":"_xlfn.IFS(D32=\"\",0,AND(D32=Data!K7, F8=\"In-State\"), \"Adjusts to tuition\", AND(D32=Data!K7, F8<>\"In-State\"), \"Must be in-state student\", D32<>\"\", VLOOKUP(D32,Data!K6:L13,2,FALSE))","v":0},{"$f":"_xlfn.IFS(F32=\"\",0, AND(D32=Data!K7, F8=\"In-State\"),Data!L27, AND( D32=Data!K7, F8<>\"In-State\"), 0, F32<>\"\", 'Budget Worksheet'!F32/2)","v":0},null,"What are my next steps?"]
[null,"First Gen or Next Gen",null,null,null,{"$f":"_xlfn.IFS(D33=\"\",0,D33<>\"\",VLOOKUP(D33,Data!K17:L21,2,FALSE))","v":0},{"$f":"F33/2","v":0},null,"Getting a refund?",null,null,"Sign up for eRefunds (direct deposit) in the ePay app in MAVzone to get your refund faster."]
[null,"CMU Promise Eligible?",null,null,null,{"$f":"_xlfn.IFS(D34=\"\", 0, D34=\"No\", 0, AND(D34=\"Yes\", F8=\"In-State\"), \"Adjusts to tuition & aid\", AND(D34=\"Yes\", F8<>\"In-State\"), \"Must be in-state\")","v":0},{"$f":"_xlfn.IFS(D34=\"\", 0, D34=\"No\", 0, AND(D34=\"Yes\", F8<>\"In-State\"), 0, AND(D34=\"Yes\", F8=\"In-State\", Data!L26<Data!L27), Data!L27-Data!L26, AND(D34=\"Yes\", F8=\"In-State\", Data!L26>Data!L27), 0)","v":0}]
[null,{"$f":"_xlfn.IFS(SUM(D10:D12)<12,\"You must be registered for 12 credits to receive most scholarships!\", SUM(D10:D12)>=12, \"Learn more at www.coloradomesa.edu/financial-aid/scholarships\")","v":"You must be registered for 12 credits to receive most scholarships!"},null,null,null,null,{"$f":"SUM(G32:G34)","v":0},null,"Will you have a balance?",null,null,"Check out the ePay app in MAVzone to make payments and/or sign up for a payment plan."]
[null,"Grants",null,null,null,"Yearly Amount","Per Semester"]
[null,"Pell Grant",null,null,null,0,{"$f":"_xlfn.IFS(F37=0,0,AND(F37<>0,SUM(D10:D12)>=12),F37/2,AND(F37<>0,SUM(D10:D12)<12),(F37*((SUM(D10:D12))/12)/2))","v":0},null,"Set up Authorized Users in ePay",null,null,"Authorized Users will receive their own ePay account where they can view your ePay activity, access billing statements, and make payments to your account."]
[null,"Colorado State Grant (CSG) or Supplemental Educ. Opportunity Grant (SEOG)",null,null,null,0,{"$f":"IF(SUM(D10:D12)<12,0,IF(F38=0,0,F38/2))","v":0}]
[null,"Type name of additional grants here",null,null,null,0,{"$f":"IF(F39=0,0,F39/2)","v":0},null,"When are bills due?",null,null,"Bills are due September 15 for fall semesters and February 15 for spring semesters. "]
[null,{"$f":"_xlfn.IFS(SUM(D10:D12)<12,\"You must be registered for 12 credits to receive CSG, SEOG, and most grants!\", SUM(D10:D12)>=12, \"\")","v":"You must be registered for 12 credits to receive CSG, SEOG, and most grants!"},null,null,null,"Grants Total",{"$f":"SUM(G37:G39)","v":0}]
[null,"Other Scholarships & Contributions",null,"Fund Type",null,"Yearly Amount","Per Semester",null,"How will a balance affect registration?",null,null,"Currently enrolled students must have their balance paid below $1000 to register for the next semester. Students who are not currently enrolled must have their balance paid in full in order to register."]
[null,"Type name of other funding here",null,null,null,0,{"$f":"_xlfn.IFS(F42=0,0, AND(F42<>0, D42=\"\"), \"Select Fund Type\", AND(F42<>0, D42<>\"\"),F42/2)","v":0}]
[null,"Type name of other funding here",null,null,null,0,{"$f":"_xlfn.IFS(F43=0,0, AND(F43<>0, D43=\"\"), \"Select Fund Type\", AND(F43<>0, D43<>\"\"),F43/2)","v":0}]
[null,"Type name of other funding here",null,null,null,0,{"$f":"_xlfn.IFS(F44=0,0, AND(F44<>0, D44=\"\"), \"Select Fund Type\", AND(F44<>0, D44<>\"\"),F44/2)","v":0},null,"Still have questions? askIRIS!",null,null,"Stop by IRIS, call 970-248-1177, or email iris@coloradomesa.edu. Schedule a financial advising appointment with an IRIS Advisor at www.coloradomesa.edu/iris."]
[null,"Type name of other funding here",null,null,null,0,{"$f":"_xlfn.IFS(F45=0,0, AND(F45<>0, D45=\"\"), \"Select Fund Type\", AND(F45<>0, D45<>\"\"),F45/2)","v":0}]
[null,"Other/Family Contributions Total",null,null,null,null,{"$f":"SUM(G42:G45)","v":0},null,{"$error":"#VALUE!"}]
[null,"Federal Loans",null,null,"Offered for Year",{"$f":"IF(F4=Data!K58, \"Fall 2026 Amount Paid\", \"N/A\")","v":"N/A"},{"$f":"_xlfn.IFS(F4=\"\", \"Select Semester\", F4=Data!K57, \"Fall Amount\",F4=Data!K58, \"Spring Amount\")","v":"Select Semester"}]
[null,"Subsidized Loan",null,null,0,null,{"$f":"_xlfn.IFS(E48=0,0,SelectTerm=\"\",\"Select Term\",AND(SelectTerm=SpringTerm,'Budget Worksheet'!$F$5=\"\"),\"Enter Fall Credits\",SelectTerm=FallTerm,ROUND(_xlfn.IFS(E48=0,0,SUM($D$10:$D$12)<6,0,AND(E48<>0,SUM($D$10:$D$12)>=6),FallSub-(FallSub*Data!$L$43)),0.1), AND(E48<>0,SUM($D$10:$D$12)>=6,SelectTerm=SpringTerm, F48=\"\"),\"Enter Fall Paid\", AND(E48<>0,SUM($D$10:$D$12)>=6,SelectTerm=SpringTerm), ROUND(SpringAdjSub-(SpringAdjSub*Data!$L$43), 0.1))","v":0}]
[null,"Unsubsidized Loan",null,null,0,null,{"$f":"_xlfn.IFS(E49=0, 0, SelectTerm=\"\",\"Select Term\",AND(SelectTerm=SpringTerm,'Budget Worksheet'!$F$5=\"\"),\"Enter Fall Credits\",SelectTerm=FallTerm,ROUND(_xlfn.IFS(E49=0,0,SUM($D$10:$D$12)<6,0,AND(E49<>0,SUM($D$10:$D$12)>=6),FallUnsub-(FallUnsub*Data!$L$43)),0.1), AND(E49<>0,SUM($D$10:$D$12)>=6,SelectTerm=SpringTerm, F49=\"\"),\"Enter Fall Paid\", AND(E49<>0,SUM($D$10:$D$12)>=6,SelectTerm=SpringTerm), ROUND(SpringAdjUnsub-(SpringAdjUnsub*Data!$L$43), 0.1))","v":0}]
[null,"Parent PLUS Loan",null,null,0,null,{"$f":"_xlfn.IFS(E50=0,0,SUM($D$10:$D$12)<6, 0, AND(E50<>0, SUM($D$10:$D$12)>=6), (E50-(E50*(Data!L44/100)))/2)","v":0}]
[null,{"$f":"_xlfn.IFNA(_xlfn.IFS(SUM(D10:D12)<6, \"You must be registered for at least 6 credit hours to be eligible for federal loans!\",E50>0, \"Students who qualify for Legacy Eligibility may qualify for additional Parent Plus loan.\", SUM(D10:D12>=6), \"Learn how to view & accept loans at www.coloradomesa.edu/iris\"), \"\")","v":"You must be registered for at least 6 credit hours to be eligible for federal loans!"},null,null,null,"Loans Total",{"$f":"SUM(G48:G50)","v":0}]
[null,"Estimated Financial Aid",null,null,null,null,{"$f":"SUM(G35,G51,G40,G46)","v":0}]
[null,"How much will I owe after financial aid has paid?"]
[null,{"$f":"IF(G54<=0, \"Estimated refund\", \"Estimated amount I will still owe after financial aid has paid\")","v":"Estimated refund"},null,null,null,null,{"$f":"G28-G52","v":0}]

{"sheet":"Data","index":1,"n_rows":92,"n_cols":21,"rows_kept":92,"cut":false,"hidden":true,"merged":[[40,10,40,12],[46,10,46,20],[29,10,29,12],[1,1,1,2],[2,1,2,2],[18,1,19,1],[18,4,18,5],[18,2,18,3],[4,1,4,6],[4,10,4,12],[15,10,15,12],[23,10,23,12],[18,6,19,6],[18,8,19,8],[18,7,19,7],[17,1,17,8],[47,11,47,20],[53,1,53,5],[59,7,60,7],[58,1,58,8],[71,1,71,6],[60,10,60,19],[59,4,59,5],[59,6,60,6],[59,8,60,8],[59,2,59,3],[6,6,14,6],[21,8,50,8],[61,8,64,8],[59,1,60,1],[89,1,89,3],[78,1,78,6]]}
[]
[null,"Select Actual/Estimated"]
[null,"Estimated"]
[]
[null,"Tuition & Fees",null,null,null,null,null,null,null,null,"Merit Scholarships"]
[null,"Selection","2627 Rates","2526 Rates","Estimated % Increase","Estimated New Rates","Notes",null,null,null,"Scholarship Name","Amount","Notes"]
[null,"In-State",452.9,452.9,1,{"$f":"D7*E7","v":452.9},"Copied actual into estimated with no increase",null,null,null,"Distinguished Scholar","N/A","Reflects updated 2024-2025 scholarships"]
[null,"Out-of-State",931.7,931.7,1,{"$f":"D8*E8","v":931.7},null,null,null,null,"Trustee",7500,"Reflects updated 2024-2025 scholarships"]
[null,"Western Undergratuate Exchange (WUE)",533.6,533.6,1,533.6,null,null,null,null,"Presidential",5000,"Reflects updated 2024-2025 scholarships"]
[null,"Mountains and Plains (M&P)",533.6,533.6,1,533.6,null,null,null,null,"Academic Achievement",3000,"Reflects updated 2024-2025 scholarships"]
[null,"Online",483.7,483.7,1,483.7,null,null,null,null,"Two Rivers",2000,"Reflects updated 2024-2025 scholarships"]
[null,"COF",116,116,"N/A","N/A",null,null,null,null,"Phi Theta Kappa",1000,"Reflects updated 2024-2025 scholarships"]
[null,"Student Fees Per Credit Hour",45.8,45.8,1,45.8,null,null,null,null,"None",0,"N/A"]
[null,"Career & Technical Education (CTE)",298.7,298.7,1,298.7]
[null,"CTE-Health Sciences",384.6,384.6,1,384.6]
[null,null,null,null,null,null,null,null,null,null,"Other Scholarships"]
[null,null,null,null,null,null,null,null,null,null,"Scholarship Name","Amount","Notes"]
[null,"Residence Hall Rates",null,null,null,null,null,null,null,null,"First Gen",1000,"Did not change from 23-24 amounts"]
[null,"Dorm Selection","2627 Rates",null," 2526 Rates",null,"Estimated % Increase","Estimated New Rates","Notes",null,"Next Gen",1000,"Did not change from 23-24 amounts"]
[null,null,"Room Cost per Year","Room Cost per Semester","Room Cost per Year","Room Cost per Semester",null,null,null,null,"Both",{"$f":"SUM(L18:L19)","v":2000},"Did not change from 23-24 amounts"]
[null,"None",0,{"$f":"C21/2","v":0},0,{"$f":"E21/2","v":0},1,{"$f":"F21*G21","v":0},"N/A",null,"None",0,"N/A"]
[null,"Albers - Double",4720,{"$f":"C22/2","v":2360},4720,2360,1,{"$f":"F22*G22","v":2360},"Copied actual into estimated with no increase"]
[null,"Albers - Single",7030,3515,7030,3515,1,3515]
[null,"Aspen Apartments",10220,{"$f":"C24/2","v":5110},10220,5110,1,5110,null,null,"CMU Promise & Distinguished Scholarship Calculations"]
[null,"Bunting Hall - Double",8130,{"$f":"C25/2","v":4065},8130,4065,1,4065,null,null,"Sums","Amounts","Notes"]
[null,"Bunting Hall - Double Stacked",7480,{"$f":"C26/2","v":3740},7480,3740,1,3740,null,null,"Scholarship & Grants",{"$f":"SUM('Budget Worksheet'!G32:G33,'Budget Worksheet'!G40,SUMIF('Budget Worksheet'!D42:E45,\"Athletic Scholarship\",'Budget Worksheet'!G42:G45))","v":0},"Sums merit scholarships, all grants, and athletic scholarships"]
[null,"Bunting Hall - Single",10100,5050,10100,5050,1,5050,null,null,"Tuition - COF",{"$f":"(SUM('Budget Worksheet'!D10*'Budget Worksheet'!E10,'Budget Worksheet'!D12*'Budget Worksheet'!E12,'Budget Worksheet'!D11*'Budget Worksheet'!E11)-(SUM('Budget Worksheet'!D10:D12)*Data!D12))","v":0},"Amounts are from input on Budget Worksheet tab and adjust automatically"]
[null,"Centential Village Apartment",12880,{"$f":"C28/2","v":6440},12880,6440,1,6440]
[null,"Garfield Hall - Double",6420,3210,6420,3210,1,3210]
[null,"Grand Mesa Hall - Single",10310,5155,10310,5155,1,5155,null,null,"Other Scholarships & Contributions"]
[null,"Grand Mesa Hall - Super Single",10870,5435,10870,5435,1,5435,null,null,"Additional Funding Type","Count Against CMU Promise?","Notes"]
[null,"Grand Mesa Hall - Double",8340,4170,8340,4170,1,4170,null,null,"CMU Foundation Scholarship","No"]
[null,"Lucero Hall - Double",8340,4170,8340,4170,1,4170,null,null,"Athletic Scholarship","Yes"]
[null,"Lucero Hall - Single",10310,5155,10310,5155,1,5155,null,null,"Outside Scholarship","No"]
[null,"Lucero Hall Apartment - Double",8760,4380,8760,4380,1,4380,null,null,"529 Payment","No"]
[null,"Lucero Hall Apartment - Single",11120,5560,11120,5560,1,5560,null,null,"Personal/Family Contribution","No"]
[null,"Monument Hall - Double",7690,3845,7690,3845,1,3845,null,null,"Alternative Loan","No"]
[null,"Orchard Ave Apartments - Double",8760,4380,8760,4380,1,4380,null,null,"Other","No"]
[null,"Orchard Ave Apartments - Single",11120,5560,11120,5560,1,5560]
[null,"Pinon Hall - Double",6420,3210,6420,3210,1,3210]
[null,"Pinon Hall - Single",8110,4055,8110,4055,1,4055,null,null,"Origination/Loan Fees"]
[null,"Rait Hall - Double",4720,2360,4720,2360,1,2360,null,null,"Loan Type","Fee Amount","Notes"]
[null,"Rait Hall - Single",7030,3515,7030,3515,1,3515,null,null,"Subsidized & Unsubsidized",1.057E-2,"Reviewed 5/14/26 - no changes"]
[null,"Tolman Hall - Double",4720,2360,4720,2360,1,2360,null,null,"Parent PLUS",4.2279999999999998E-2,"Reviewed 5/14/26 - no changes"]
[null,"Tolman Hall - Single",7030,3515,7030,3515,1,3515]
[null,"Townhouse Apartments - Double",7030,3515,7030,3515,1,3515]
[null,"Townhouse Apartments - Single",8500,4250,8500,4250,1,4250,null,null,"Payment Plans"]
[null,"Walnut Ridge Apartments - Double",7030,3515,7030,3515,1,3515,null,null,"Payment Plan Type","Dates"]
[null,"Walnut Ridge Apartments - Single",8500,4250,8500,4250,1,4250,null,null,"Monthly","2026-08-16","2026-09-16","2026-10-16","2026-10-17",null,null,null,null,"Payment Plan Amount","Today's Date"]
[null,"Wingate Hall - Apartment Single",10220,5110,10220,5110,1,5110,null,null,"# of Pymts-Monthly",5,4,3,"Deadline Past",null,null,null,null,{"$f":"'Budget Worksheet'!G54-'Budget Worksheet'!N28","v":0},{"$f":"TODAY()","v":"2026-06-05"}]
[null,"Wingate Hall - Double",7030,3515,7030,3515,1,3515,null,null,"Semi-Monthly","2026-08-16","2026-09-02","2026-09-16","2026-10-02","2026-10-16","2026-10-17"]
[null,null,null,null,null,null,null,null,null,null,"# of Pymts-BiMonthly",10,9,8,7,6,"Deadline Past"]
[null,null,null,null,null,null,null,null,null,null,"Weekly","2026-08-14",{"$f":"L53+7","v":"2026-08-21"},{"$f":"M53+7","v":"2026-08-28"},"2026-09-04","2026-09-11","2026-09-18","2026-09-25","2026-10-02","2026-10-09","2026-10-17"]
[null,"Res Hall Activity Fee",null,null,null,null,null,null,null,null,"# of Pymts-Weekly",19,18,17,16,15,14,13,12,11,"Deadline Past"]
[null,"2627 Rate","2526 Rate","Estimated% Increase","Estimated New Rate","Notes"]
[null,30,30,1,{"$f":"C56*D56","v":30},null,null,null,null,null,"Semester Options"]
[null,null,null,null,null,null,null,null,null,null,"Fall 2026"]
[null,null,null,null,null,null,null,null,null,null,"Spring 2027"]
[null,"Res Hall Meal Plans"]
[null,"Name","2627 Rates",null,"2526 Rates",null,"Estimated % Increase","Estimated New Rate","Notes"]
[null,null,"Cost per Year","Cost per Semester","Cost per Year","Cost per Semester",null,null,null,null,"Summary Chart Data"]
[null,"The Unlimited",6620,{"$f":"C62/2","v":3310},6620,{"$f":"E62/2","v":3310},1,{"$f":"F62*G62","v":3310},"Copied actal into estimated with no increase",null,"Category","Tuition & Fees","Housing & Food","Other Expenses","Anticipated Refund","CMU Promise & Merit Scholarships","Grants","Loans","Other Aid","Make a Plan to Pay"]
[null,"Mav 15",6670,{"$f":"C63/2","v":3335},6670,{"$f":"E63/2","v":3335},1,{"$f":"F63*G63","v":3335},null,null,"Estimated Costs",{"$f":"IF('Budget Worksheet'!G14>0,'Budget Worksheet'!G14,NA())","v":{"$error":"#N/A"}},{"$f":"IF('Budget Worksheet'!G19>0,'Budget Worksheet'!G19, NA())","v":{"$error":"#N/A"}},{"$f":"IF('Budget Worksheet'!G27,'Budget Worksheet'!G27,NA())","v":{"$error":"#N/A"}},{"$f":"IF('Budget Worksheet'!G54<0,'Budget Worksheet'!G54*-1,NA())","v":{"$error":"#N/A"}},{"$f":"IF('Budget Worksheet'!G34>0,'Budget Worksheet'!G34, NA())","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"Base 15",5990,2995,5990,{"$f":"E64/2","v":2995},1,2995,null,null,"Estimated Aid",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF('Budget Worksheet'!G35>0,'Budget Worksheet'!G35, NA())","v":{"$error":"#N/A"}},{"$f":"IF('Budget Worksheet'!G40>0,'Budget Worksheet'!G40,NA())","v":{"$error":"#N/A"}},{"$f":"IF('Budget Worksheet'!G51>0,'Budget Worksheet'!G51,NA())","v":{"$error":"#N/A"}},{"$f":"IF('Budget Worksheet'!G46>0,'Budget Worksheet'!G46,NA())","v":{"$error":"#N/A"}},{"$f":"IF('Budget Worksheet'!G54>0,'Budget Worksheet'!G54,NA())","v":{"$error":"#N/A"}}]
[null,"Wingate/Aspen Apartment",3290,1645,3290,{"$f":"E65/2","v":1645},1,1645]
[null,"MAV 20",null,0,318,159,1.0509999999999999,167.10899999999998,"Added 6/11/24"]
[null,"MAV 40",null,0,585,292.5,1.0509999999999999,307.41749999999996,"Added 6/11/24"]
[null,"MAV 80",null,0,1120,560,1.0509999999999999,{"$f":"F68*G68","v":588.55999999999995},"Added 6/11/24"]
[null,"None",0,0,0,0,1,{"$f":"F69*G69","v":0},"N/A"]
[]
[]
[null,"First-Time Student Fees"]
[null,"Fee Name","2627 Amount","2526 Amount","Estimated % Increase","Estimated New Rate","Notes"]
[null,"Matriculation Fee",null,140,1,{"$f":"D74*E74","v":140},"Did not add an estimated increase"]
[null,"New Mav Days",null,90,1,{"$f":"D75*E75","v":90},"Did not add an estimated increase"]
[null,"Total",{"$f":"SUM(C74:C75)","v":0},{"$f":"SUM(D74:D75)","v":230},"N/A",{"$f":"SUM(F74:F75)","v":230}]
[]
[]
[null,"Parking Permits"]
[null,"Parking Permits","2627 Amount","2526 Amount","Estimated % Increase","Estimated New Rate","Notes"]
[null,"None",0,0,1,{"$f":"D81*E81","v":0},"N/A"]
[null,"Residence Hall Permit",null,186,1.03,{"$f":"D82*E82","v":191.58}]
[null,"Residence Reserved Hall Permit",null,275,1.03,{"$f":"D83*E83","v":283.25}]
[null,"Commuter Permit ",null,154,1.03,158.62]
[null,"Faculty/Staff Permit ",null,154,1.03,158.62]
[null,"Value Permit ",null,70,1.03,72.100000000000009]
[null,"Motorcycle Permit",null,38,1.03,39.14]
[]
[]
[null,"Early Start Program"]
[null,"Resident",425,"From Early Start website; updated 4/4/25"]
[null,"Commuter",365,"Added 4/4/25"]

{"sheet":"Loan Proration","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":true,"merged":[[4,9,4,10]]}
[]
[null,"Offered","Semester Half","Fall Actual Paid","Fall Earned Aid","Overpaid","Spring Adjusted"]
["Subsidized",{"$f":"'Budget Worksheet'!E48","v":0},{"$f":"SubOffered/2","v":0},{"$f":"'Budget Worksheet'!F48","v":0},{"$f":"FallSub","v":0},{"$f":"IF((FallPaidSub-E3)<=0, 0, (FallPaidSub-E3))","v":0},{"$f":"G8-F3","v":0}]
["Unsubsidized",{"$f":"'Budget Worksheet'!E49","v":0},{"$f":"UnsubOffered/2","v":0},{"$f":"'Budget Worksheet'!F49","v":0},{"$f":"FallUnsub","v":0},{"$f":"IF((FallPaidUnsub-E4)<=0, 0, (FallPaidUnsub-E4))","v":0},{"$f":"H8-F4","v":0}]
[null,null,null,null,null,null,null,null,null,"Annual Amounts (If Spring Semester is Selected)"]
["Full Time Credit Hours",24,"% Semester Credits","% Annual Credits (Running Total)","Use This %","Eligible","Sub ","Unsub",null,"Total Credit Hours",{"$f":"SUM(B7:B8)","v":0}]
["Fall Semester Credit Hours",{"$f":"_xlfn.IFS('Budget Worksheet'!F4=Data!K57,SUM('Budget Worksheet'!D10:D12), 'Budget Worksheet'!F4=Data!K58, 'Budget Worksheet'!F5, 'Budget Worksheet'!F4=\"\", 0)","v":0},{"$f":"FallCreditHrs/(FTCreditHrs/2)","v":0},{"$f":"MIN((FallCreditHrs/(FTCreditHrs/2)),1)","v":0},{"$f":"IF(FallCredPercent>=1, 1, FallCredPercent)","v":0},{"$f":"IF(B7<6,\"NO\",\"YES\")","v":"NO"},{"$f":"_xlfn.IFS(FallEligible=\"NO\",0,FallCredPercent>=100%,(SubOffered/2),FallCredPercent<100%,(UsePercentFall*(SubOffered/2)))","v":0},{"$f":"_xlfn.IFS(FallEligible=\"NO\",0,FallCredPercent>=100%,(UnsubOffered/2),FallCredPercent<100%,(UsePercentFall*(UnsubOffered/2)))","v":0},null,"% for Year",{"$f":"_xlfn.IFS('Budget Worksheet'!F4=Data!K57,\"N/A\", AND('Budget Worksheet'!F4=Data!K58,SUM('Loan Proration'!B7:B8)>='Loan Proration'!B6), 1, AND('Budget Worksheet'!F4=Data!K58,SUM('Loan Proration'!B7:B8)<'Loan Proration'!B6), SUM('Loan Proration'!B7:B8)/'Loan Proration'!B6)","v":{"$error":"#N/A"}}]
["Spring Semester Credit Hours",{"$f":"_xlfn.IFS('Budget Worksheet'!F4=Data!K57, 0,'Budget Worksheet'!F4=Data!K58, SUM('Budget Worksheet'!D10:D12), 'Budget Worksheet'!F4=\"\",0)","v":0},{"$f":"SpringCreditHrs/(FTCreditHrs/2)","v":0},{"$f":"MIN(B9/FTCreditHrs,1)","v":0},{"$f":"_xlfn.IFS(AND(FallCredPercent<=1, SpringCredPercent<1), SpringCredPercent, AND(FallCredPercent>=1, SpringCredPercent>=1), 1,  AND(FallCredPercent>1, SpringCredPercent<1, (FallCredPercent+SpringCredPercent)>2), 1, AND(FallCredPercent>1, SpringCredPercent<1, (FallCredPercent+SpringCredPercent)<=2), ((FallCredPercent-1)+SpringCredPercent), AND(FallCredPercent<1, SpringCredPercent>=1, (FallCredPercent+SpringCredPercent)>2), (2-FallCredPercent), AND(FallCredPercent<1, SpringCredPercent>=1, (FallCredPercent+SpringCredPercent)<=2), SpringCredPercent)","v":0},{"$f":"IF(B8<6,\"NO\",\"YES\")","v":"NO"},{"$f":"IF(SpringEligible=\"No\",0,(SubOffered/2)*UsePercentSpring)","v":0},{"$f":"IF(SpringEligible=\"No\",0,(UnsubOffered/2)*UsePercentSpring)","v":0},null,"Annual Subsidized",{"$f":"SubOffered*K7","v":{"$error":"#N/A"}}]
["Annual Amounts",{"$f":"SUM(B7:B8)","v":0},null,null,null,"N/A",{"$f":"SUM(G7:G8)","v":0},{"$f":"SUM(H7:H8)","v":0},null,"Annual Unsubsidized",{"$f":"UnsubOffered*K7","v":{"$error":"#N/A"}}]

{"sheet":"Change Log","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Date","Name","Note"]
["2025-08-07","Justin Little","Update for actual 2526 rates"]
["2026-05-07","Brenna Wilkerson","Update for 2627 estimated rates; added summary page and pop-up message"]
["2026-05-14","Brenna Wilkerson","Removed Bunting Super Single option"]
["2026-05-14","Brenna Wilkerson","Reworked estimated rates - Added column for estimated increases, drop down for actual/estimated, and adjusted formulas to go off actual or estimated"]
["2026-05-15","Brenna Wilkerson","Added Loan Proration tab and calculated loan amounts for spring"]
["2026-05-18","Brenna Wilkerson","Fixed formulas for loan payment amounts to remove N/A; unlocked Fall Credits and Fall Paid cells; added text about Legacy Eligibility if Parent PLUS >0."]
["2026-05-20","Justin Little","Inserted new 2627 tuition and fees rates; inserted new residence halls and new 2627 rates; inserted new meal plan names and rates (need commuter prices still)"]
["2026-05-29","Brenna Wilkerson","Unlocked Name cell, added if sub/unsub loans are 0 to insert 0 (to fix N/A error), updated estimated rates for tuition, dorms, res hall meal plans"]