{"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":1,"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":[[5,1,9,4],[11,1,15,4],[2,1,3,13],[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":[[1,0,1,1],[0,0,0,2],[9,0,9,1],[12,0,12,1],[17,0,17,1]]}
["Federal Direct Loan Application Form for 2022/23"]
["Section 1 Personal Information"]
["First Name"]
["Surname"]
["Date of Birth "]
["Social Security No."]
["College 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 2022/23?"]
["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 Coordinator 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":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,1,3]]}
["Academic year 2022-23","Complete the yellow boxes"]
["Postgraduate Student"]
[]
["Cost of Attendance (COA)","Pound Sterling","US Dollar"]
["Tuition fees",null,{"$f":"B5*$B$15","v":0}]
["Room",10660,14923.999999999998]
["Board",5616,7862.4]
["Books/materials",1664,2329.6]
["Travel",2808,3931.2]
["Personal",3900,5460]
["Two flights to US",2266,3172.3999999999996]
["Loan origination fees ",{"$f":"C12/B15","v":1764.2857142857144},2470]
["Total",{"$f":"SUM(B5:B12)","v":28678.285714285714},{"$f":"SUM(C5:C12)","v":40149.599999999999},"Full name"]
[null,null,null,"1st line of address"]
["Exchange Rate  £1:$ ",1.4,null,"City"]
[null,null,null,"State"]
["Total COA is",{"$f":"C13","v":40149.599999999999},null,"Post code/ Zip code"]
[null,null,null,"Country"]
[null,"EFA (£)","EFA ($)","D.O.B. "]
["Please enter the amount (in GBP or USD, not both) of any scholarships/ grants you are receiving for 2022-2023 academic year",null,null,"College ID"]
[null,null,null,"Course Length in years"]
[]
["Loan eligibility","Stafford Unsubsidised","GRAD PLUS"]
["COA",{"$f":"B17","v":40149.599999999999},{"$f":"B24","v":40149.599999999999}]
["EFA (other aid)",{"$f":"(B20*B15)+C20","v":0},{"$f":"B25+B29","v":20500}]
["EFC",0]
["Initial Amount",{"$f":"B24-B25","v":40149.599999999999},{"$f":"IF(C24-C25<0,0,C24-C25)","v":19649.599999999999}]
["Maximum Amount",20500,{"$f":"C27","v":19649.599999999999}]
["HOW MUCH YOU CAN BORROW ==>",{"$f":"IF(B28<B27,B28,B27)","v":20500},{"$f":"C27","v":19649.599999999999}]
[]
[]
[null,"Stafford Unsubsidised","GRAD PLUS"]
["Please enter the amount you would like to borrow (this may not be more than the Eligible Amount as shown above)"]
[]
["I would like to borrow the PLUS loan fees","Please enter Yes or No"]
["Annual Limit","Aggregate Limit"]
["Stafford Unsubsidised","Unsubsidised and subsidised loans(combined)- including undergraduate loans"]
["$20,500","$138,500"]
[]
["COA=Cost of Attendance"]
["EFC=Estimated Financial Contribution"]
["EFA=Estimated 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'!E13","v":0}]
[{"$f":"'Step 2 COA'!E14","v":0}]
[{"$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":"00:00:00"}]
[]
[]
[]
[]
["Notification of Student Loan"]
["For Academic Year 2022/23"]
[]
[]
["This is to certify that "]
[]
["Student Name",{"$f":"'Step 2 COA'!E13","v":0}]
["Date of Birth (dd/mm/yyyy)",{"$f":"'Step 2 COA'!E19","v":"00:00:00"}]
["Student/Applicant ID",{"$f":"'Step 2 COA'!E20","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","2022-09-19"]
["End Date","2023-09-18"]
[]
[" 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]
["Direct PLUS Loan",0]
["Total",{"$f":"SUM(B36:B37)","v":0}]
[]
["The disbursement dates are as follows:"]
["6th October 2022",{"$f":"G42","v":0},null,null,"Stafford","Plus","Total"]
["27th March 2023",{"$f":"G43","v":0},null,"Term 1",null,null,{"$f":"E42+F42","v":0}]
["Total",{"$f":"SUM(B41:B42)","v":0},null,"Term 2",null,null,{"$f":"E43+F43","v":0}]
[]
["This certificate is only valid if printed on school headed paper and signed by the International Funding "]
["Coordinator and stamped by the Office stamp."]
[]
[]
[]
["Amanda Ellis"]
[]
[]
[]
[]
["International Funding Coordinator"]
[]
[]
["Date Issued",{"$f":"TODAY()","v":"2022-05-31"}]

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