{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions ","Step 1 US loan application form","Step 2 COA","Step 3 Visa Letter","Office Use"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"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 2025/26"]
["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 2025/26?"]
["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":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,1,1,3]]}
["Academic year 2025/26","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",9070,12698]
["Food",4320,6048]
["Books/materials",1360,1903.9999999999998]
["Travel ",2360,3304]
["Personal",3240,4536]
["Immigration Health Sub-charge",2716,3802.3999999999996]
["Visa fees",524,733.59999999999991]
["Two flights to US",2450,3430]
["Origination fees",{"$f":"C14/B17","v":2214.2857142857142},3100]
["Total",{"$f":"SUM(B5:B14)","v":28254.285714285714},{"$f":"SUM(C5:C14)","v":39556},"Full name"]
[null,null,null,"1st line of address"]
["Exchange Rate  £1:$ ",1.4,null,"City"]
[null,null,null,"State"]
["Total COA is",{"$f":"C15","v":39556},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 2025/26 academic year",null,null,"College ID"]
[null,null,null,"Course Length in years"]
["Loan Eligibility","  Stafford Subsidized","Stafford Unsubsidized","Parent PLUS"]
["COA",{"$f":"B19","v":39556},{"$f":"B25","v":39556},{"$f":"B25","v":39556}]
["SAI (Student Aid Index)",0," "," "]
["OFA (Other Financial Assistance)",{"$f":"(B22*B17)+C22","v":0},{"$f":"B30+B27","v":3500},{"$f":"B27+B30+C30","v":5500}]
["Initial Amount",{"$f":"IF(B25-B26-B27<0,0,B25-B26-B27)","v":39556},{"$f":"IF(C25-C27<0,0,C25-C27)","v":36056},{"$f":"IF(D25-D27<0,0,D25-D27)","v":34056}]
["Maximum Amount",3500,{"$f":"B39","v":2000}]
["HOW MUCH YOU CAN BORROW ==>",{"$f":"IF(B29<B28,B29,B28)","v":3500},{"$f":"IF(C29<C28,C29,C28)","v":2000},{"$f":"D28","v":34056}]
[]
[null,"Stafford Subsidized","Stafford Unsubsidized","Parent PLUS"]
["Please enter the amount you would like to borrow (this may not be more than the Eligible Amount as shown above)",0,0,0]
[]
["My parent would like to borrow the PLUS loan fees","Please enter Yes or No"]
["Annual Limits",null,"Aggregate Limits"]
["Maximum Combined Stafford",5500,"Subsidized","Unsubsidized and Subsidized (combined)"]
["Subsidized Award",{"$f":"B30","v":3500},"$23,000","$31,000"]
["Unsubsidized Maximum",{"$f":"B37-B38","v":2000}]
[]
["COA = Cost of Attendance"]
["SAI = Student Aid Index"]
["OFA = Other Financial Assistance"]

{"sheet":"Step 3 Visa Letter","index":3,"n_rows":59,"n_cols":8,"rows_kept":59,"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 2025/26"]
[]
[]
["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."]
["Graduate/professional students and 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","2025-09-22"]
["End Date","2026-06-12"]
[]
[" 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]
["Total",{"$f":"SUM(B36:B38)","v":0}]
[]
["The disbursement dates are as follows:"]
["23rd October 2025",{"$f":"H43","v":0},null,null,"Sub Stafford","Unsub Stafford","Plus","Total"]
["12th February 2026",{"$f":"H44","v":0},null,"Term 1",null,null,null,{"$f":"E43+F43+G43","v":0}]
["Total",{"$f":"SUM(B42:B43)","v":0},null,"Term 2",null,null,null,{"$f":"E44+F44+G44","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":"2025-05-20"}]

{"sheet":"Office Use","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,1,10,2],[11,1,11,2],[12,1,12,2],[8,1,8,2],[0,0,0,2],[5,0,5,2],[6,1,6,2],[7,1,7,2],[9,1,9,2]]}
["Approved Loan amounts"]
[null,"Gross","Net"]
["Subsidised"]
["Unsubsidised"]
["PLUS"]
["ISIR checks"]
["US Citizen/Eligible Non-citizen"]
["SSN match"]
["HS diploma or equivalent"]
["Under aggregate limits"]
["Dependency status"]
["EFC"]
["CIP code"]