{"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":2,"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":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,2],[9,0,9,1],[12,0,12,1],[15,0,15,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":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,1,3]]}
["Academic year 2026/27","Complete the yellow boxes"]
["Postgraduate Student"]
[]
["Cost of Attendance (COA)","Pound Sterling","US Dollar","Off-campus"]
["Tuition ",null,{"$f":"B5*$B$17","v":0}]
["Housing",23611,34944.28]
["Food",9788,14486.24]
["Books/materials",1820,2693.6]
["Travel ",3172,4694.5599999999995]
["Personal",4368,6464.64]
["Immigration Health Sub-charge",1164,1722.72]
["Visa fees ",558,{"$f":"B12*$B$17","v":825.84}]
["Two flights to US",2550,{"$f":"B13*$B$17","v":3774}]
["Stafford loan origination fees ",{"$f":"C14/B17","v":146.62162162162161},217]
["Total",{"$f":"SUM(B5:B14)","v":47177.62162162162},{"$f":"SUM(C5:C14)","v":69822.87999999999},"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":69822.87999999999},null,"Post code/ Zip code"]
[null,null,null,"Country"]
[null,"OFA (£)","OFA ($)","D.O.B. "]
["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 Unsubsidized","Private"]
["COA",{"$f":"B19","v":69822.87999999999},{"$f":"B26","v":69822.87999999999}]
["OFA (Other Financial Assistance)",{"$f":"(B22*B17)+C22","v":0},{"$f":"B27+B31","v":20500}]
["SAI (Student Aid Index)",0]
["Initial Amount",{"$f":"B26-B27","v":69822.87999999999},{"$f":"IF(C26-C27<0,0,C26-C27)","v":49322.87999999999}]
["Maximum Amount",20500]
["HOW MUCH YOU CAN BORROW ==>",{"$f":"IF(B30<B29,B30,B29)","v":20500},{"$f":"C29","v":49322.87999999999}]
[]
[]
[null,"Stafford Unsubsidized"," Private"]
["Please enter the amount you would like to borrow (this may not be more than the Eligible Amount as shown above)"]
[]
["Annual Limit"]
["Stafford Unsubsidized"]
["$20,500"]
[]
["Aggregate Limits:","Base level (Subsidized/Unsubsidized)","Graduate Unsubsidized","Graduate and Undergraduate combined maximum"]
["Undergraduate - Dependent","31,000 of which no more than 23,000 subsidized"," ",131000]
["Undergraduate - Independent","$57,500 of which no more than 23,000 subsidized"," ",157500]
["Postgraduate (excluding undergraduate amounts)",null,100000]
[]
["COA = Cost of Attendance"]
["SAI = Student Aid Index"]
["OFA = Other Financial Assistance"]

{"sheet":"Step 3 Visa Letter","index":3,"n_rows":58,"n_cols":7,"rows_kept":58,"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."]
[]
[]
["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-09-20"]
[]
[" the student (or, in some cases, the student’s parent) will receive the following Direct Loan awards:"]
["Loan Type","Loan Amount"]
["Direct Unsubsidized Loan",0]
["Private Loan",0]
["Total",{"$f":"SUM(B36:B37)","v":0}]
[]
["The disbursement dates are as follows:"]
["2026-10-22",{"$f":"G42","v":0},null,null,"Stafford","Private","Total"]
["2027-03-22",{"$f":"G43","v":0},null,"Term 1"]
["Total",{"$f":"SUM(B41:B42)","v":0},null,"Term 2"]
[]
["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"}]