{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions ","Step 1 US loan application form","Step 2 COA","Step 3 Visa Letter"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"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":"Instructions ","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,1,3,13],[5,1,9,4],[11,1,15,4],[17,1,21,4],[23,1,27,4]]}
[]
[]
[null,"US Federal Loans "]
[]
[]
[null,"STEP 1 : Complete US loan application form "]
[]
[]
[]
[]
[]
[null,"STEP 2 : Complete Cost of Attendance"]
[]
[]
[]
[]
[]
[null,"STEP 3 : Ensure your name, DOB & student number on visa letter is accurate"]
[]
[]
[]
[]
[]
[null,"STEP 4 : Save spreadsheet and send to usloans@rhul.ac.uk"]

{"sheet":"Step 1 US loan application form","index":1,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,1],[9,0,9,1],[12,0,12,1],[17,0,17,1]]}
["Federal Direct Loan Application Form for 2026/27"]
["Section 1 Personal Information"]
["First Name"]
["Surname"]
["Date of Birth "]
["Social Security No."]
["University ID"]
["Course of Study"]
["Level of Study "]
["Section 2 Existing Financial Awards"]
["Will you be in receipt of any bursaries or scholarships during the academic year 2026/27?"]
["if Yes please give full details of the source of funding and amounts"]
["Section 3 Document Checklist"]
["Documents prepared"]
[]
[]
[]
["Section 4 Declaration"]
["I declare that the information I submit to the International Funding Adviser is to the best of my knowledge true and accurate"]
["I understand that the amount RHUL receives will depend on the exchange rate on the day RHUL requests the funds from the US Treasury. If, due to exchange rate fluctuations this means the loans do not cover the full cost of my tuition, I will become liable"]
["Signed & Date"]

{"sheet":"Step 2 COA","index":2,"n_rows":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,1,1,3]]}
["Academic year 2026/27","Complete the yellow boxes"]
["Undergraduate Student"]
["Course",null,null,"Dependent 1st year (campus)"]
["Cost of Attendance","Pound Sterling","US Dollar"]
["Tuition ",null,{"$f":"B5*$B$17","v":0},"Campus"]
["Housing",9797,14499.56]
["Food",4534,6710.32]
["Books/materials",1400,2072]
["Travel ",2440,3611.2]
["Personal",3360,4972.8]
["Immigration Health Sub-charge",2716,4019.68]
["Visa fees",558,825.84]
["Two flights to US",2550,3774]
["Origination fees",{"$f":"C14/B17","v":571.62162162162167},846]
["Total",{"$f":"SUM(B5:B14)","v":27926.62162162162},{"$f":"SUM(C5:C14)","v":41331.399999999994},"Full name"]
[null,null,null,"1st line of address"]
["Exchange Rate  £1:$ ",1.48,null,"City"]
[null,null,null,"State"]
["Total COA is",{"$f":"C15","v":41331.399999999994},null,"Post code/ Zip code"]
[null,null,null,"Country"]
[null,"OFA (£)","OFA ($)","D.O.B. dd/mm/yyyy"]
["Please enter the amount (in GBP or USD, not both) of any scholarships/ grants you are receiving for 2026/27 academic year",null,null,"College ID"]
[null,null,null,"Course Length in years"]
["Loan Eligibility","  Stafford Subsidized","Stafford Unsubsidized","Parent PLUS","Private Loan"]
["COA",{"$f":"B19","v":41331.399999999994},{"$f":"B25","v":41331.399999999994},{"$f":"B25","v":41331.399999999994},{"$f":"B25","v":41331.399999999994}]
["SAI (Student Aid Index)",null," "," "," "]
["OFA (Other Financial Assistance)",{"$f":"(B22*B17)+C22","v":0},{"$f":"B30+B27","v":3500},{"$f":"B27+B30+C30","v":5500},{"$f":"B27+B30+C30+D30","v":25500}]
["Initial Amount",{"$f":"IF(B25-B26-B27<0,0,B25-B26-B27)","v":41331.399999999994},{"$f":"IF(C25-C27<0,0,C25-C27)","v":37831.399999999994},{"$f":"IF(D25-D27<0,0,D25-D27)","v":35831.399999999994},{"$f":"IF(E25-E27<0,0,E25-E27)","v":15831.399999999994}]
["Maximum Amount",3500,2000,{"$f":"E37","v":20000}," "]
["HOW MUCH YOU CAN BORROW ==>",{"$f":"IF(B29<B28,B29,B28)","v":3500},{"$f":"IF(C29<C28,C29,C28)","v":2000},{"$f":"IF(D29<D28,D29,D28)","v":20000},{"$f":"E28","v":15831.399999999994}]
[]
[null,"Stafford Subsidized","Stafford Unsubsidized","Parent PLUS","Private Loan"]
["Please enter the amount you would like to borrow (this may not be more than the Eligible Amount as shown above)",0,0,0,0]
[]
[]
["Annual Limits"]
["Maximum Combined Stafford",5500,null,"Parent annual maximum",20000]
["Subsidized Award",{"$f":"B30","v":3500},null,"Parent max for student",65000]
["Unsubsidized Maximum",{"$f":"B37-B38","v":2000},null,"Previously borrowed by parent for this student",0]
[null,null,null,"Remaining lifetime max",{"$f":"E38-E39","v":65000}]
[]
["Aggregate Limits:","Subsidized","Unsubsidized and Subsidized (combined)","PLUS "]
["Undergraduate - Dependent",23000,31000,"20,000 per year per child"]
["Undergraduate - Independent",23000,57500,"65,0000 per child total"]
["Postgraduate (includes undergraduate amounts)",65500,138500]
[]
["COA = Cost of Attendance"]
["SAI = Student Aid Index"]
["OFA = Other Financial Assistance"]

{"sheet":"Step 3 Visa Letter","index":3,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Step 2 COA'!E15","v":0}]
[{"$f":"'Step 2 COA'!E16","v":0}]
[{"$f":"'Step 2 COA'!E17","v":0}]
[{"$f":"'Step 2 COA'!E18","v":0}]
[{"$f":"'Step 2 COA'!E19","v":0}]
[{"$f":"'Step 2 COA'!E20","v":"00:00:00"}]
[]
[]
[]
[]
["Notification of Student Loan"]
["For Academic Year 2026/27"]
[]
[]
["This is to certify that "]
[]
["Student Name",{"$f":"'Step 2 COA'!E15","v":0}]
["Date of Birth (dd/mm/yyyy)",{"$f":"'Step 2 COA'!E21","v":"00:00:00"}]
["Student/Applicant ID",{"$f":"'Step 2 COA'!E22","v":0}]
[]
["has been accepted in a degree-granting program (or otherwise eligible program) 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. "]
["Eligible students from the U.S. who attend our school may borrow through the Direct Loan Program. "]
["Undergraduate students  may receive Direct Subsidized Loans and Direct Unsubsidized Loans. "]
["Graduate/professional students may receive Direct Unsubsidized Loans."]
["Parents may receive Direct PLUS Loans. "]
[]
["Based on our calculation of the student’s financial needs and Direct Loan eligibility for the loan period"]
["Start Date","2026-09-21"]
["End Date","2027-06-11"]
[]
[" the student (or, in some cases, the student’s parent) will receive the following Direct Loan awards:"]
["Loan Type","Loan Amount"]
["Direct Subsidized Loan",0]
["Direct Unsubsidized Loan",0]
["Direct PLUS Loan",0]
["Private Loan",0]
["Total",{"$f":"SUM(B36:B39)","v":0}]
[]
["The disbursement dates are as follows:"]
[" 22nd October 2026",{"$f":"I44","v":0},null,null,"Sub Stafford","Unsub Stafford","Plus","Private","Total"]
["12th February 2027",{"$f":"I45","v":0},null,"Term 1",null,null,null,null,{"$f":"E44+F44+G44+H44","v":0}]
["Total",{"$f":"SUM(B43:B44)","v":0},null,"Term 2",null,null,null,null,{"$f":"E45+F45+G45+H45","v":0}]
[]
["This certificate is only valid if printed on school headed paper and signed by the International Funding "]
["Adviser and stamped by the Office stamp."]
[]
[]
[]
[]
[]
[]
["Amanda Ellis"]
[]
["International Funding Adviser"]
[]
[]
["Date Issued",{"$f":"TODAY()","v":"2026-06-23"}]