{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","Introduction","Basis of Costs","Cost of Attendance","School DATA","Visa Letter (Office use only)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"The Courtauld"]

{"sheet":"Introduction","index":1,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Cost of Attendance - How to use this spreadsheet"]
[]
["This spreadsheet is to help you and us"]
["a. To make the process as speedy and as simple as possible"]
["b. To cut out the risk of your application being rejected and you having to start again"]
["You should also use the flowchart from our website to see the order in which you need to do each stage of your application"]
[]
["There is nothing which tells the school that everything the applicant needs to do has been completed."]
["There is nothing which tells the applicant that everything they need to do has been completed."]
["Information sent by the US Dept of Ed to schools also includes all those who may not apply or enroll."]
["There are some documents which we have to receive before we can even start to certify or complete your loans"]
[]
["You must complete and send us the spreadsheet \"Cost of Attendance\" tab"]
[]
["It is used to help you and the school in several ways"]
["1. You tell us what we need to know about you before we can start to process your application (Section 1)"]
["2. You can re-calculate your costs (Sections 2 & 3) and if needed you can change our values shown in blue"]
["3. It calculates how much you need and are eligible to borrow (Section 4)"]
["4. It tells you whether the school will accept the costs you have proposed (Section 5)"]
["5. It tells you how much of your loan will be retained by the government as origination fee"]
["6. It calculates the cost of the originations fees and increases the PLUS loan to cover them"]
["7. You tell us how much you want to borrow (Section 6) You adjust the figures shown in blue"]
[]
["For your information …"]
["The Basis of Costs tab shows you how we calculated the Cost of Attendance"]
["To ensure that your application is as smooth as possible, you must complete the Cost of Attendance spreadsheet and the checklist"]
[]
["We will start the eligibility checking once all required documents as per The Courtauld website's US Loans page have been received"]

{"sheet":"Basis of Costs","index":2,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["How these Costs are Calculated"]
[]
["Exchange Rate","The exchange rate is set by a review of High Street banks and selecting the worst possible rate and incrementing it by the worst possible commission. This is sufficient to enable loans to be calculated and originated. The rate will not be re-assessed until after the end of the registration period. Should the rate change unfavourably once the course has started, then the whole Cost of Attendance can be reviewed again. ."]
[]
["Room - Rent","First, Check the prices of all halls of residence and select the highest below self-contained suite. Second, search for the average price of a room in a shared flat and for a studio flat in the close area (use the web and general estate agent searches). Select the higher average price of the two scenarios."]
[]
[]
["Books & Copying","The cost of a single course pack (for the term) applied for each week which is more than sufficient for book purchase."]
[]
["Travel","Normal cost of one return journey for 7 days or a weekly travel card covering the area, whichever is the greater"]
[]
[]
["2 return flights","Cost of two BA return flights Heathrow/LA  travelling at weekends and rounded up by £100 to nearest £100"]
[]
["PC","Cost of a laptop plus a printer"]
[]
["Visa application","Visa costs plus cost of midweek return next day flight US New York to LA and rounded"]
[]
["PLUS Loan","The balance of the cost of attendance after Sub & Unsub and grossed up to include Origination Fee  on Sub & Unsub added to PLUS loan needs and then increased again to include the origination fee charged on PLUS Loans as quoted on Direct Lending website, and reduced by any rebate offered by USDE. This ensures that the cash you receive, after foreign exchange and deduction of origination fees, is the sterling cost of attendance."]
[]
["Government Fees","Your government takes an origination fee. "]
[]
[]
[]
["Year Dates","These dates are set to minimise the risk of your loan being rejected by overlapping a previous year."]
[null,"Postgraduates - The loan year will be 365 days"]
[null,"Undergraduates - The loan year will be start of academic year to end of final term"]
[]
["Disbursement Dates","WARNING - THESE DATES ARE EXPECTED AND NOT ACTUAL"]

{"sheet":"Cost of Attendance","index":3,"n_rows":97,"n_cols":15,"rows_kept":97,"cut":false,"hidden":false,"merged":[[18,2,18,4],[11,2,11,3],[58,1,58,4],[48,4,49,4],[48,3,49,3],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4]]}
[]
["The Courtauld",null,"Cost of Attendance"]
[null,null,"& Loan Calculation"]
[null,null,{"$f":"\"for Academic Year \"& 'School DATA'!D6","v":"for Academic Year 2024/25"}]
[null,null,"RETAIL (Main Street) RATE - NOT INTERBANK RATE",null,null,null,null,{"$f":"'School DATA'!H48","v":110857},"Max CoA before Interview"]
[null,null,"This form and exchange rates revised",null,{"$f":"'School DATA'!D8","v":"22/08/2024"},null,null,{"$f":"'School DATA'!H50","v":115544.03396},"Max Loan after grossing up for Fees adjustments"]
[null,null,"Worst possible rate for Retail US Dollar Rate - best guess",{"$f":"'School DATA'!H44","v":1.4021999999999999},{"$f":"'School DATA'!I29","v":"2024-04-24"}]
[null,null,"Next review date for Exchange Rate",null,{"$f":"'School DATA'!I30","v":"2024-12-01"},null,"Depend","Choice","Year"]
[null,null,"No of Weeks for Undergraduates",{"$f":"'School DATA'!E11","v":45},null,null,"I","N",1]
[null,null,"No of Weeks for Postrgraduates",{"$f":"'School DATA'!E13","v":52},null,null,"D","Y",2]
[null,null,null,null,null,null,null,null,"3 or above",null,null,null,"ONLY ENTER DATES"]
["Section 1",null,"COMPLETE ALL YELLOW BOXES ONLY",null,null,null,"Private Loan","STANDING DATA","Loan Dates",null,null,"DISBURSEMENTS","Disburse Dates","VALUES ARE AUTOMATIC"]
[null,null,null,null,null,null,"Government Loan","Undergrads","Start",{"$f":"'School DATA'!D7","v":"16/09/2024"},null,{"$f":"COUNT(M13:M19)","v":3},{"$f":"IF(('School DATA'!D18>10/10/2010),'School DATA'!D18,\"\")","v":"2024-09-23"},{"$f":"IF((ISNUMBER(M13)),(E91/L13),\"\")","v":0}]
["Family Name (Surname)",null,null,null,null,null,null,null,"End",{"$f":"'School DATA'!D11","v":"2025-07-23"},null,"put 2nd date",{"$f":"IF(('School DATA'!D19>10/10/2010),'School DATA'!D19,\"\")","v":"2025-01-27"},{"$f":"IF((ISNUMBER(M14)),(E91/L13),\"\")","v":0}]
["Given Name (Forename)",null,null,null,null,null,null,"Postgrads","Start",{"$f":"'School DATA'!D7","v":"16/09/2024"},null,"put 3rd date or blank",{"$f":"IF(('School DATA'!D20>10/10/2010),'School DATA'!D20,\"\")","v":"2025-05-12"},{"$f":"IF((ISNUMBER(M15)),(E91/L13),\"\")","v":0}]
["Address Line 1",null,null,null,null,null,null,null,"End",{"$f":"'School DATA'!E7","v":{"$error":"#VALUE!"}},null,"put 4th date or blank",{"$f":"IF(('School DATA'!D21>10/10/2010),'School DATA'!D21,\"\")","v":""},{"$f":"IF((ISNUMBER(M16)),(E91/L13),\"\")","v":""}]
["Address Line 2"]
["Address Line 3"]
["Address Line 4"]
["Zipcode / Postcode"]
["Email",null,null,null,null,null,null,"MAXIMUM LOAN LEVELS FOR THIS STU",null,null,"MAXIMUM LOAN LEVELS AVAILABLE"]
["Date of Birth dd/mm/yyyy",null,null,null,null,null,"Sub","Unsub Depend","Unsub Ind",null,"Sub","Unsub Depend","Unsub Ind"]
["Full Social Security Number",null,null,null,null,null,{"$f":"IF(D27=\"Y\",0,K23)","v":0},null,{"$f":"IF((D27=\"N\"),M23,0)","v":20500},"postgraduates",0,0,20500]
["Application/Student Number",null,null,null,null,null,{"$f":"IF((AND(D27=\"Y\",D28=\"N\",D30=1)),K24,0)","v":0},{"$f":"IF((AND(D27=\"Y\",D31=\"D\",D30=1)),L24,0)","v":0},{"$f":"IF((AND(D27=\"Y\",D31=\"I\",D30=1)),M24,0)","v":0},"Undergraduate1",3500,2000,6000]
["Full name of your course",null,null,null,null,null,{"$f":"IF((AND(D27=\"Y\",D28=\"N\",D30=2)),K25,0)","v":0},{"$f":"IF((AND(D27=\"Y\",D31=\"D\",D30=2)),L25,0)","v":0},{"$f":"IF((AND(D27=\"Y\",D31=\"I\",D30=2)),M25,0)","v":0},"Undergraduate2",4500,2000,6000]
["Section 2",null,null,null,null,null,{"$f":"IF((AND(D27=\"Y\",D28=\"N\",D30>2)),K26,0)","v":0},{"$f":"IF((AND(D27=\"Y\",D31=\"D\",D30>2)),L26,0)","v":0},{"$f":"IF((AND(D27=\"Y\",D31=\"I\",D30>2)),M26,0)","v":0},"Undergraduate>2",5500,2000,7000]
["Please answer each question in this section",null,"Is this course for BA? ","N",null,null,{"$f":"IF((AND(D27=\"Y\", D28=\"Y\", D29=\"Y\")),K27,0)","v":0},{"$f":"IF((AND(D28=\"Y\",D32=\"D\",D31>2)),L27,0)","v":0},{"$f":"IF((AND(D27=\"Y\", D28=\"Y\", D29=\"Y\")),M27,0)","v":0},"Law",{"$f":"K23","v":0},{"$f":"L23","v":0},{"$f":"M23","v":20500}]
[null,null,{"$f":"IF(D27=\"N\", \"Do not adjust this line\", \"Are you taking a profesional course but at undergraduate level? Only answer Y or N\")","v":"Do not adjust this line"},"n",null,null,{"$f":"MAX(G23:G27)","v":0},null,{"$f":"MAX(H23:I27)","v":20500},"Max Loan Available",null,"From July 2012 there is no Subsidised Loan for postgraduates"]
[null,null,{"$f":"IF((AND( D27=\"Y\", D28=\"Y\")), \"Do you already have another undergraduate degree - answer Y or N\", \"Do not adjust this line\" )","v":"Do not adjust this line"},"n"]
[null,null,"What will be your year of study - select from the dropbox only",1,null,null,null,"CONVERTING FEES AND CONTRIBUTIONS TO DOLLARS",null,null,null,"Undergrad Courses which could get Postgrad funding"]
[null,null,"What does your SAR say for \"dependancy status\" Only answer I or D","I",null,null,"Rate","Convert £ ","Already $","Actual Loans",null,"Law"]
[null,null,"What is you SAI Student Aid Index (top right of front page of SAR) Even zero must be entered",0,null,null,{"$f":"D7","v":1.4021999999999999},{"$f":"D33*G32","v":0},{"$f":"E33","v":0},"Fees"]
[null,null,"Enter the Tuition Fees - only write the figures - don't type in the £ sign as it is already formatted",0,null,null,{"$f":"G32","v":1.4021999999999999},{"$f":"D34*G33","v":0},{"$f":"E34","v":0},"Sponsors"]
[null,null,"How much of the tuition fees will be paid to your school by a sponsor (only enter in the $ or £ box - not both)",0,0,null,{"$f":"G33","v":1.4021999999999999},{"$f":"D35*G34","v":0},{"$f":"E35","v":0},"School Aid"]
[null,null,"How much has already been awarded by this school as a Scholarship or Financial Aid",0,null,null,{"$f":"G34","v":1.4021999999999999},{"$f":"D36*G35","v":0},{"$f":"E36","v":0},"Other Aid £UK"]
[null,null,"How much has been awarded by any other Scholarship or Financial Aid in the UK",0,null,null,{"$f":"G34","v":1.4021999999999999},{"$f":"D37*G36","v":0},{"$f":"E37","v":0},"Other Aid $USA"]
[null,null,"How much has been awarded by any other Scholarship or Financial Aid from the USA",null,0,null,null,null,{"$f":"SUM(H33:I36)","v":0},"Deduct from \"Need\""]
[null,null,"Is this application for a Private loan (Sallie Mae), please select from this drop-box","Government Loan"]
[null,null,null,null,null,null,null,"CONVERTING WEEKLY COSTS TO DOLLARS"]
["Section 3 ","Weekly Essential Costs - School Max Estimates - you can adjust the values but may be asked for proofs of your adjusted costs",null,null,null,null,"UG Weeks","UG Costs","PG Costs","PG Weeke"]
[null,null,null,"School's Estimate per week","Your Request",null,{"$f":"D9","v":45},{"$f":"E42*G32*G41","v":0},{"$f":"J41*G32*E42","v":0},{"$f":"D10","v":52}]
[null,null,"Room - Rent",{"$f":"'School DATA'!I11","v":400},0,null,{"$f":"D9","v":45},{"$f":"E43*G33*G42","v":0},{"$f":"J42*G33*E43","v":0},{"$f":"J41","v":52}]
[null,null,"Board - Food and Power",{"$f":"'School DATA'!H12+'School DATA'!H13","v":140},0,null,{"$f":"G42","v":45},{"$f":"E44*G32*G43","v":0},{"$f":"J43*G34*E44","v":0},{"$f":"J42","v":52}]
[null,null,"Books & Copying",{"$f":"'School DATA'!H14","v":20},0,null,{"$f":"G43","v":45},{"$f":"E45*G33*G44","v":0},{"$f":"J44*G35*E45","v":0},{"$f":"J43","v":52}]
[null,null,"Travelcard/Transport Costs",{"$f":"'School DATA'!H15","v":50},0,null,{"$f":"G44","v":45},{"$f":"E46*G34*G45","v":0},{"$f":"J45*G36*E46","v":0},{"$f":"J44","v":52}]
[null,null,"Personal",{"$f":"'School DATA'!H16","v":70},0]
[]
[null,null,null,null,null,null,null,"CONVERTING ANNUAL COSTS TO DOLLARS",null,null,"Origination Fees"]
["Section 4","Single Costs for the year - you may adjust or add extras in these columns",null,"School's Estimate per Year",{"$f":"E41","v":"Your Request"}]
[null,"you may be asked for proof of your extra needs",null,null,null,null,{"$f":"D7","v":1.4021999999999999},{"$f":"E51*G50","v":0},null,null,null,"% Rate","Interest","Final","Actual"]
[null,null,"Cost of 2 return flights - write here - only in £",{"$f":"'School DATA'!H19*2","v":2900},0,null,{"$f":"G50","v":1.4021999999999999},0,null,null,"Loan Type",null,"Rebate","Rate","Factor"]
[null,null,"Visa Application and flights to interview",{"$f":"'School DATA'!H20","v":500},0,null,1.4021999999999999,0,null,null,"Sub Orig Fee",{"$f":"'School DATA'!D38","v":1.0569999999999999},{"$f":"'School DATA'!E38","v":0},{"$f":"L52-M52","v":1.0569999999999999},{"$f":"N52*0.01","v":1.057E-2}]
[null,null,"PC and Printer",{"$f":"'School DATA'!H21","v":1200},0,null,1.4021999999999999,0,null,null,"Unsub Orig Fee",{"$f":"'School DATA'!D39","v":1.0569999999999999},{"$f":"'School DATA'!E39","v":0},{"$f":"L53-M53","v":1.0569999999999999},{"$f":"N53*0.01","v":1.057E-2}]
[null,null,{"$f":"'School DATA'!G22","v":"Visa £322 and NHS charge £150.00"},{"$f":"SUM('School DATA'!H22)","v":472},0,null,1.4021999999999999,0,null,null,"PLUS Orig fee",{"$f":"'School DATA'!D40","v":4.2279999999999998},{"$f":"'School DATA'!E40","v":0},{"$f":"L54-M54","v":4.2279999999999998},{"$f":"N54*0.01","v":4.2279999999999998E-2}]
[null,null,{"$f":"'School DATA'!G23","v":"Add any other essential costs - write here - only in £"},{"$f":"'School DATA'!H23","v":0},{"$f":"D55","v":0},null,1.4021999999999999,0]
[null,null,{"$f":"'School DATA'!G24","v":"Add any other essential costs - write here - only in £"},{"$f":"'School DATA'!H24","v":0},{"$f":"D56","v":0},null,1.4021999999999999,0]
[null,null,{"$f":"'School DATA'!G25","v":"Add any other essential costs - write here - only in £"},{"$f":"'School DATA'!H25","v":0},{"$f":"D57","v":0}]
[null,null,null,null,null,null,null,"FINAL CALCULATIONS",null,null,"SUB NEED","UNSUB NEED","ORIG FEE NOT INC","ORIG FEE INC"]
["Section 5","YOUR ESTIMATED FINAL COSTS & US ED DEPT MAXIMUM LOAN ELIGIBILITY - YOU MAY BORROW LESS IF YOU CHOOSE",null,null,null,null,"Requested Cost of Attendance (Values rounded)","$",null,"CoA",{"$f":"H69","v":0}]
[null,null,{"$f":"G59","v":"Requested Cost of Attendance (Values rounded)"},{"$f":"H59","v":"$"},null,null,"Tuition Fees",{"$f":"ROUND(H32,0)","v":0},null,"Less EFC",{"$f":"-D32","v":0}]
[null,null,{"$f":"G60","v":"Tuition Fees"},{"$f":"H60","v":0},null,null,"Room",{"$f":"ROUND((IF(D27=\"N\",I41,H41)),0)","v":0},null,"Need for Sub",{"$f":"IF((SUM(K59:K60)>0),(SUM(K59:K60)),0)","v":0},null,null,{"$f":"IF((K61<K63),(K63-K61),0)","v":0}]
[null,null,{"$f":"G61","v":"Room"},{"$f":"H61","v":0},null,null,"Board",{"$f":"ROUND((IF(D27=\"N\",I42,H42)),0)","v":0},null,"Sub available",{"$f":"G28","v":0}]
[null,null,"Board",0,null,null,"Books",{"$f":"ROUND((IF(D27=\"N\",I43,H43)),0)","v":0},null,"Sub Calc",{"$f":"IF((((K61/(100-N52))*100)<K62),((K61/(100-N52))*100),K62)","v":0},null,{"$f":"IF((N61>0),0,(K63*O52))","v":0}]
[null,null,"Books",0,null,null,"Travel",{"$f":"ROUND((IF(D27=\"N\",I44,H44)),0)","v":0}]
[null,null,"Travel",0,null,null,"Personal",{"$f":"ROUND((IF(D27=\"N\",I45,H45)),0)","v":0},null,"Need for Unsub",null,{"$f":"IF((N61>0),(K59+N61-K63),(K59-K63+M63))","v":0},null,{"$f":"IF((((L67-L65)>0)),(L67-L65),0)","v":0}]
[null,null,"Personal",0,null,null,"Other Essential Costs",{"$f":"SUM(H50:H56)","v":0},null,"Unsub available",null,{"$f":"G28+I28-K63","v":20500}]
[null,null,"Other Essential Costs",0,null,null,"Total Cost of Attendance",{"$f":"SUM(H60:H66)","v":0},null,"Unsub Calc",null,{"$f":"IF((((L65/(100-N53))*100)<L66),((L65/(100-N53))*100),L66)","v":0},{"$f":"+IF((N65>0),0,(L67*O53))","v":0}]
[null,null,"Total Cost of Attendance",0,null,null,"Adjust for Sponsorship, Awards or other Aid",{"$f":"ROUND((-I37),0)","v":0}]
[null,null,"Adjust for Sponsorship, Awards or other Aid",0,null,null,"Total Requested Cost of Attendance",{"$f":"ROUND((SUM(H67:H68)),0)","v":0},null,"PLUS NEED"]
[{"$f":"IF((D38=\"Private Loan\"),\"Private loan requested\",\"\")","v":""},null,{"$f":"G69","v":"Total Requested Cost of Attendance"},0,null,null,null,null,null,"Need for PLUS",{"$f":"IF((N65=0),(K59-K63-L67+M63+M67),0)","v":0}]
[]
[null,null,{"$f":"IF((D38=G12),\"Maximum Private (Sallie Mae) loan we will certify is\",\" \")","v":" "},{"$f":"IF((D38=G12),D80,\" \")","v":" "}]
[null,null,{"$f":"IF((D38=G12),\"As you said (in cell D38) that you are seeking a Sallie Mae loan there is no need to complete anything below this line.\",\" \")","v":" "},null,null,null,"Maximum Govt. Loan you can borrow","$",null,"PLUS Available",{"$f":"H5-K63-L67","v":110857}]
[null,null,null,null,null,null,"You could have borrowed these Govt. Loans"]
[null,null,{"$f":"IF((D38=G12),G74,G73)","v":"Maximum Govt. Loan you can borrow"},null,null,null,"Subsidised - Adjusted by EFC",{"$f":"K63","v":0},null,"PLUS Calc",{"$f":"IF((((K70/(100-N54)*100))<K73),((K70/(100-N54)*100)),(((K73+M63+M67)/(100-N54))*100))","v":0}]
[null,null,{"$f":"IF((D27=\"N\"),L28,G75)","v":"From July 2012 there is no Subsidised Loan for postgraduates"},{"$f":"H75","v":0},{"$f":"IF((N61>0),\"Grossed up for fees\",\"\")","v":""},null,"Unsubsudised",{"$f":"L67","v":0}]
[null,null,"Unsubsudised",{"$f":"H76","v":0},{"$f":"IF((N65>0),\"Grossed up for fees\",\"\")","v":""},null,{"$f":"IF((J78=2),K78,(IF((H69>H5),\"PLUS Loan to fulfil this CoA\",\"\")))","v":""},null,{"$f":"IF((K73<K70),K70,\"\")","v":""},"Indep Undergrad Score"]
[null,null,"",null,{"$f":"I77","v":""},null,{"$f":"IF((J78=2),\"\",\"Maximum PLUS Loan allowed for this CoA\")","v":"Maximum PLUS Loan allowed for this CoA"},{"$f":"IF((J78=2),\"\",(IF((K70<K73),(K70-M67-M63),K73)))","v":0},null,{"$f":"(IF((D27=\"Y\"),1,0))+(IF((D31=\"I\"),1,0))","v":1},"Independent Undergraduates are not eligible for a PLUS Loan"]
[null,null,"Maximum PLUS Loan allowed for this CoA",{"$f":"H78","v":0},null,null,"Total Eligible before adjustment for Fees",{"$f":"SUM(H75:H78)","v":0}]
[null,null,"Total Eligible before adjustment for Fees",{"$f":"H79","v":0}]
[]
["Section 6 ",null,"SCHOOL COMMENT ON YOUR PROPOSED COSTS & ELIGIBLE LOANS",null,null,null,null,"Qualify 1","THE COSTS YOU HAVE SUGGESTED ARE TOO HIGH TO BE ACCEPTABLE"]
[null,null,{"$f":"IF(H67>H5, I82,\"  \")","v":"  "},null,null,null,null,"Qualify 2","Provide evidence of your needs for any increase to  PLUS to be considered or borrow less in Section 6"]
[null,null,{"$f":"IF(H67>H5, I83,I84)","v":"You are allowed to borrow up to the values above"},null,null,null,null,"OK Statement","You are allowed to borrow up to the values above"]
[]
["Section 7",null,{"$f":"IF((D38=G12),\"THIS SECTION DOES NOT APPLY TO SALLIE MAE LOANS\",\"YOU TELL US HOW MUCH WOULD YOU LIKE TO BORROW - YOU MAY REDUCE THE FIGURES IN BLUE\")","v":"YOU TELL US HOW MUCH WOULD YOU LIKE TO BORROW - YOU MAY REDUCE THE FIGURES IN BLUE"},null,null,null,"Max Loans Allowed Adjusted for Fees","After Origination Fees You Get"]
["Max Loans Allowed Adjusted for Fees","Government Fees *** Deducted","State how much you would like to borrow for each loan type - adjust the figures in blue in the \"Your Request\" column","Your Request  -  you may reduce these values","After Origination Fees You Get",null,{"$f":"ROUND(K63,0)","v":0},{"$f":"ROUND(((G87*(1-O52))),0)","v":0}]
[{"$f":"IF((D38=G12),0,G87)","v":0},{"$f":"O52","v":1.057E-2},{"$f":"C76","v":"From July 2012 there is no Subsidised Loan for postgraduates"},0,{"$f":"ROUND(((D88*(1-O52))),0)","v":0},null,{"$f":"ROUND(L67,0)","v":0},{"$f":"ROUND(((G88*(1-O53))),0)","v":0}]
[{"$f":"IF((D38=G12),0,G88)","v":0},{"$f":"O53","v":1.057E-2},"Unsubsudised",0,{"$f":"ROUND(((D89*(1-O53))),0)","v":0},null,{"$f":"IF((J78=2),\"\",(ROUND(K75,0)))","v":0},{"$f":"ROUND(((G89*(1-O54))),0)","v":0}]
[{"$f":"IF((D38=G12),0,G89)","v":0},{"$f":"O54","v":4.2279999999999998E-2},{"$f":"IF((J78=2),K78,\"PLUS Loan (Adjusted up to include all fees)\")","v":"PLUS Loan (Adjusted up to include all fees)"},0,{"$f":"ROUND(((D90*(1-O54))),0)","v":0},null,{"$f":"SUM(G87:G89)","v":0},{"$f":"SUM(H87:H89)","v":0}]
[{"$f":"IF((D38=G12),0,G90)","v":0},null,"Total (after rounding, may be slightly higher than total of section 4)",{"$f":"SUM(D88:D90)","v":0},{"$f":"SUM(E88:E90)","v":0},null,null,"OK Statement 1","We will check everything you have provided with the USDE data and regulations"]
["Section 8",null,{"$f":"IF((D91<(H5*1.04)),I91,I93)","v":"We will check everything you have provided with the USDE data and regulations"},null,null,null,null,"OK Statement 2","If everything is correct we will originate your loans and issue a certificate for visa application"]
[null,null,{"$f":"IF((D91<(H5*1.04)),I92,I94)","v":"If everything is correct we will originate your loans and issue a certificate for visa application"},null,null,null,null,"Qualify 1","You must provide evidence of your costs/needs before we can process your application"]
[null,null,null,null,null,null,null,"Qualify 2"]
["Section 9 Government Fees ",{"$f":"B88","v":1.057E-2},{"$f":"C88&\" Origination Fee of \"&L52&\"% less Interest Rebate of \"&M52&\"%\"","v":"From July 2012 there is no Subsidised Loan for postgraduates Origination Fee of 1.057% less Interest Rebate of 0%"}]
[null,{"$f":"B89","v":1.057E-2},{"$f":"C89&\" Origination Fee of \"&L53&\"% less Interest Rebate of \"&M53&\"%\"","v":"Unsubsudised Origination Fee of 1.057% less Interest Rebate of 0%"}]
[null,4.2279999999999998E-2,{"$f":"C90&\" Origination Fee of \"&L54&\"% less Interest Rebate of \"&M54&\"%\"","v":"PLUS Loan (Adjusted up to include all fees) Origination Fee of 4.228% less Interest Rebate of 0%"}]

{"sheet":"School DATA","index":4,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[null,"FOR SCHOOL USE ONLY",null,"DON'T TOUCH THE BLUE BOXES - They are calculations going to other parts of this workbook"]
[null,null,null,"School to Complete ONLY the yellow boxes"]
[null,null,null,"SCHOOL INFORMATION",null,null,null,"MONEY INFORMATION"]
[]
[null,null,null,"Academic Year Calculations",null,null,null,"Calculates max allowed before prroof of costs needed"]
[1,"Which Academic Year is this","Year format yyyy/yy","2024/25",null,6,"Complete this Fee Estimate"]
[null,null,"Start day of the year","16/09/2024",{"$f":"D7+363","v":{"$error":"#VALUE!"}},null,"Avg highest Tuition Fee charged in London for MSc",31440,null,{"$f":"H7","v":31440}]
[null,null,"When did you complete this form","22/08/2024"]
[null,"Complete these dates",null,null,null,7,"Complete these Cost Estimates which are PER WEEK","Calculates school CoA"]
[null,"When do think your undergraduates start to arrive (occupy their bedroom)",null,"2024-09-09","Undergrad weeks",null,"What is the highest charge for your halls of residence per week",400]
[null,"What is the date of your last Bachelors' graduation ceremony in the summer ",null,"2025-07-23",{"$f":"ROUND(((MAX(D11:D12)-D10)/7),0)","v":45},null,"What is your best estimate at the high-end going rate for a room per week in the area",350,{"$f":"MAX(H10:H11)","v":400}]
[null,"AND/OR","official end of summer term - ONLY if earlier",null,"Postgrad weeks",null,"What is your best estimate for electricity/gas for a week (use our own home direct debits?)",70]
[null,null,null,null,52,null,"What is your normal family shopping for a week and adjust for one adult",70]
[2,"What will be the dates your students get their disbursements",null,null,null,null,"What is your best estimate for book buying or photocopying or course packs per week",20]
[null,"Your dates in COD might be earlier [to allow processing time]",null,null,null,null,"What is your best estimate at travel costs for the area for a week",50]
[null,"Only put in the date against each term",null,null,null,null,"What is your estimate for enough pocket money per week",70,{"$f":"SUM(H12:H16)","v":280},{"$f":"(SUM(I11:I16))*E13","v":35360}]
[null,"Do NOT put in a date where you don't have a disbursement",null,"Payment periods - terms"]
[null,"Term 1 [could be autumn or 1st semester]",null,"2024-09-23",{"$f":"D19-1","v":"2025-01-26"},8,"Look up these costs on the web"]
[null,"Term 2 [could be spring - after Christmas - or 2nd semester]",null,"2025-01-27",{"$f":"IF((D20>0),(D20-1),(MAX(D10:D11)))","v":"2025-05-11"},null,"midweek return flights with BA from  Los Angeles to London",1450,null,{"$f":"H19*2","v":2900}]
[null,"Term 3 [could be summer - after Easter]",null,"2025-05-12",{"$f":"IF((D21>0),(D21-1),(MAX(D11:D12)))","v":"2025-07-23"},null,"midweek return flight for visa interview Los Angeles to New York",500]
[null,"Term 4 [could be the writing up term after May/June exams if you have such a term]",null,null,{"$f":"IF((D22>0),(D22-1),(MAX(D11:D12)))","v":"2025-07-23"},null,"Powerful laptop and printer [Apple MacBook  - PC World March 2022]",1200]
[null,null,null,null,{"$f":"E18","v":"2025-01-26"},"PG T1","Visa £322 and NHS charge £150.00",472]
[3,"What are the initials of your staff allowed to sign visa letters USE BLOCK CAPS",null,null,{"$f":"IF((D20>1),(D20-1),E7)","v":"2025-05-11"},"PG T2","Add any other essential costs - write here - only in £",0]
[null,null,"Only put in the staff you authorise",null,{"$f":"IF((D21>1),(D21-1),E7)","v":{"$error":"#VALUE!"}},"PG T3","Add any other essential costs - write here - only in £",0]
[null,null,"Do not put in initials where you don't have staff",null,{"$f":"IF((D22>1),(D22-1),E7)","v":{"$error":"#VALUE!"}},"PG T4","Add any other essential costs - write here - only in £",0,null,{"$f":"SUM(H20:H25)","v":2172}]
[null,null,"person 1","AH"]
[null,null,"person 2","KA"]
[null,null,"person 3","LD",null,9,"Go to the banks near you and collect their exchange rates",null,"Calculates exchange rate for CoA"]
[null,null,"person 4","SP",null,null,"When did you do this","Write in the date","2024-04-24","LONDON"]
[null,null,"person 5","RB",null,null,"When - long after the first disbursement - will you review the exchange rate","Write in the date","2024-12-01"]
[null,null,"person 6",null,null,null,"If any bank showed a commission rate then enter it against that bank","Bank Number","Rate","Commission %"]
[null,null,"person 7",null,null,null,"Do not write the name of any bank","XE",1.24461]
[null,null,"person 8",null,null,null,null,"Post Office",1.2215]
[null,null,null,null,null,null,null,"M&S",1.2215]
[4,"These are 01 Oct 2014 - If they've changed, go to the USDE website and check origination/rebates for each loan type and adjust below",null,null,null,null,null,"Bank 4"]
[null,"Be absolutely sure you are looking at the right year",null,"Calculates gross loan to cash",null,null,"only 6 banks would accept or exchange dollars","Bank 5"]
[null,"Rate per https://studentaid.gov/understand-aid/types/loans/interest-rates","Loan Type","Origination Fee %","Rebate %",null,null,"Bank 6"]
[null,null,"Subsidised Loans",1.0569999999999999,0,null,null,"Bank 7"]
[null,null,"Unsubsidised Loans",1.0569999999999999,0,null,null,"Bank 8"]
[null,null,"PLUS Loans",4.2279999999999998,0,null,null,"Bank 9"]
[null,null,"Worst Fee Rate",{"$f":"MAX(D38:D40)","v":4.2279999999999998},null,null,null,"Bank 10"]
[null,null,null,null,null,null,null,"Worst case rates",{"$f":"MAX(I32:I41)","v":1.24461},{"$f":"MAX(J32:J41)","v":0}]
[5,"These are 15/16 - If you know levels have changed, go to the USDE website and find the loan levels for each type of student"]
[null,"The information in the FSA Handbook is confusing so use another site to confirm details",null,null,null,null,"Worst combination goes to the CoA",1.4021999999999999]
[null,null,null,"Loan values eligible"]
[null,"Undergrads","Subsidised","Dependent Unsubsidised","Independent Unsubsidised",null,"Worst case costs at worst exchange ",{"$f":"ROUND(((SUM(J7:J25))*H44),0)","v":100779},null,"Select"]
[null,"Year 1",3500,2000,6000,null,"and inflated by 10%",{"$f":"ROUND((H46*0.1),0)","v":10078},null,"Federal Direct Subsidised Loan "]
[null,"Year 2",4500,2000,6000,null,null,{"$f":"SUM(H46:H47)","v":110857},null,"Federal Direct Unsubsidised Loan "]
[null,"Year 3",5500,2000,7000,null,"plus worst origination rates",{"$f":"H48/100*D41","v":4687.0339599999998},null,"Federal Direct PLUS (Parent/Graduate) Loans."]
[null,"Year 4",5500,2000,7000,null,"Max Loans allowed before review",{"$f":"SUM(H48:H49)","v":115544.03396}]
[null,"Postgrads",0,0,20500]
[]
[]
[10,"Calculating fields for late starters - do not adjust these fields"]
[null,null,"Start","End","weeks"]
[null,"PG",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E7","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((D56-C56)/7),0)","v":{"$error":"#VALUE!"}}]
[null,"UG",{"$f":"C56","v":{"$error":"#REF!"}},{"$f":"D11","v":"2025-07-23"},{"$f":"ROUND(((D57-C57)/7),0)","v":{"$error":"#REF!"}}]

{"sheet":"Visa Letter (Office use only)","index":5,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":true,"merged":[[18,0,18,1],[17,0,17,1]]}
[]
[{"$f":"'Cost of Attendance'!C15&\" \"&'Cost of Attendance'!C14","v":" "},"The Courtauld"]
[{"$f":"'Cost of Attendance'!C16","v":0}]
[{"$f":"'Cost of Attendance'!C17","v":0}]
[{"$f":"'Cost of Attendance'!C18","v":0}]
[{"$f":"'Cost of Attendance'!C19","v":0}]
[{"$f":"'Cost of Attendance'!C20","v":0}]
[]
["Notification of Student Loan"]
[{"$f":"'Cost of Attendance'!C4","v":"for Academic Year 2024/25"}]
[]
[]
["This is to certify that "]
[]
["Student Name",{"$f":"'Cost of Attendance'!C15&\" \"&'Cost of Attendance'!C14","v":" "}]
["Date of Birth",{"$f":"'Cost of Attendance'!C22","v":"00:00:00"}]
["Student/Applicant ID",{"$f":"'Cost of Attendance'!C24","v":0}]
["Has been accepted in a degree-granting programme(or otherwise eligible programme) at our School "]
["We participate in the William D. Ford Federal Direct Loan (Direct Loan) Program administered by the United States (U.S.) Department of Education. \nEligible students from the U.S. who attend our school may borrow through the Direct Loan Program. \nUndergraduate students and graduate/professional students may receive Direct Subsidized Loans and Direct Unsubsidized Loans.\nGraduate/professional students and parents may receive Direct PLUS Loans. \n"]
[]
["Based on our calculation of the student’s financial needs and Direct Loan eligibility for the loan period"]
["Start Date","2024-09-16"]
["End Date","2025-09-26"]
[]
[" The student (or, in some cases, the student’s parent) will receive the following Direct Loan awards"]
["which come from the US Dept of Education and are administered through this school."]
["Loan Type","Loan Amount"]
["Direct Subsidized Loan",{"$f":"'Cost of Attendance'!E88","v":0}]
["Direct Unsubsidized Loan",{"$f":"'Cost of Attendance'!E89","v":0}]
["Direct PLUS Loan",{"$f":"'Cost of Attendance'!E90","v":0}]
["Total",{"$f":"'Cost of Attendance'!E91","v":0}]
[]
["The disbursement dates are as follows:"]
[{"$f":"'Cost of Attendance'!M13","v":"2024-09-23"},{"$f":"'Cost of Attendance'!N13","v":0}]
[{"$f":"'Cost of Attendance'!M14","v":"2025-01-27"},{"$f":"'Cost of Attendance'!N14","v":0}]
[{"$f":"'Cost of Attendance'!M15","v":"2025-05-12"},{"$f":"'Cost of Attendance'!N15","v":0}]
[{"$f":"IF(('Cost of Attendance'!M16>'Cost of Attendance'!J15),'Cost of Attendance'!M16,\"\")","v":""},{"$f":"IF(('Cost of Attendance'!N16>'Cost of Attendance'!K15),'Cost of Attendance'!N16,\"\")","v":""}]
["Total",{"$f":"SUM(B34:B37)","v":0}]
[]
["This certificate has been issued by Alex Hawkins at The Courtauld Institute of Art, and can be verified by emailing alex.hawkins@courtauld.ac.uk"]
[]
[]
["Date Issued",{"$f":"TODAY()","v":"2024-08-22"}]
[]
["Please note: This is a summary of loans originated, however this is not a guarantee of Federal student loans"]