ࡱ> ED  \p John Lahr Ba==Z=,28Z@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1( Book Antiqua1( Book Antiqua1( Book Antiqua1( Book Antiqua1( Book Antiqua1( Book Antiqua1 Arial1$Arial1( Book Antiqua1( Book Antiqua1(@ Book Antiqua1( Book Antiqua"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *        1! 1" 1 1" ) ! !           (   @*   @   "@    @*   @   "@    !@7 *   !@7   "!@ 7   @@ *   "@ @   "@ @ *   @ *   "@    "@  *   !@ *   "!@    "!@  *   @   !@  @@ *  @@  "@ @      !   @ *   "@   "@ *   "@      " @          @   H 0  1 " @ *  1 " @  1 " @   1 "@ *  1   "@ @  ""@ @*  ""@ @  "  @ !"@ @  @*  @  "@   !"@   !"@   !"!@  !"@@ +  @@  !@  !@  !!@          "@@ +  "@ @      !"@ @  "@  !"@ @  "@   !"@@ +   !"@      (   ""@ @ +   @ *   "@    "@  *   @ *   "@    "@  *   @ *   "@    "@  *   !@ *   "!@    "!@  *   @*   @   "@  #@ * #"@  #"@  *   !@ *   "!@    "!@  *    *"@@  *"@  *@  *  @ ""@@ ""@ " " @  "@@  ""@   " " @  "@@ "@  " @  `Q& Instructions L2Tool  ;a"}kTotal Grants and Scholarships Total WorkTotal Student LoansTOTAL AID AWARD%How to Use This Award Comparison ToolDo not enter Federal PLUS Loan or "Estimated" Federal PLUS Loan in the Student Loan section. Federal PLUS Loans are parent loans.1.2.3.4.5.6."Gift Aid as Percent of Total Costs'Student Loans as Percent of Total CostsRemaining BalanceTGather cost information for each school. Possible sources for this information are:oEnter your financial aid from your award letter in the applicable category (grants/scholarships, work or loan).|Your Vermont Grant (й Grant) award may be different for different cost schools. Contact й for specific award amounts.Multiply the Federal Stafford/Unsubsidized Federal Stafford Loan amount(s) on your award letter by 96% to account for the loan fees that are deducted before the funds are disbursed to the school. Award letter/Supplemental information sent with award letterSchool publicationsSchool websiteIf you've won private scholarships, have you notified the school? Do you know how or if your school award will change? Make sure that's reflected on the worksheet.SEnter the school names at the top of the worksheet. You can enter up to 4 schools.Cost of Attendance Award PackageiCompare the percent of total costs covered by grants/scholarships, work, loan and family for each school.4How much will you need to borrow in student loans? If work-study is included in your award package, how many hours will you need to work to earn the awarded amount? Is that realistic?oIf not, revise the work-study award amount in your package to reflect the amount you expect to be able to earn.Compare your awardslEstimate how you will meet the family contribution for your first year and subsequent years of your program.Family ResponsibilityTotal Estimated Billed Costs Total LoansTotal Gift AidNot ApplicableTotal Work-Study** Colleges typically do not allow students to use anticipated work-study earnings to settle their bill. Students use these funds for books and personal expenses.TOTAL ESTIMATED COSTS$Work-Study as Percent of Total Costs%Total Estimated Family ResponsibilityLaundry ToiletriesOtherOther transportation costs EntertainmentSchool"Cost of Attendance (Academic Year)Award Package (Academic Year)Other Costs - Your EstimatesTuition Required FeesPossible Other Fees:RoomOn-Campus Meal PlanBooksSuppliesComputer CostsTransportation: Personal: Federal Pell GrantFSEOGVT State Grant (й Grant)Institutional Grant/ScholarshipOutside Grant/ScholarshipFederal Work-StudyInstitutional Work-Study Other WorkFederal Perkins LoanInstitutional LoanAlternative Loan!Other Loan (not parent PLUS Loan) +Federal Stafford/Unsubsidized Stafford LoanTotal Work-StudyStudent Savings/Assets$Student Summer Earnings ContributionParent Savings/AssetsParent PLUS LoanInstallment Payment Plan!Student Loans not on award letter&Billed Costs - From School InformationLab FeesClinical Course Fees AthleticsHealth InsurancegEnter tuition, fees, room and board for each school for the academic year into the billed cost section.Home to campus/campus to homeEnter your estimates of other academic year costs for each school. For transportation, calculate the cost of a round trip from home to campus and multiply by the number of round trips expected. Consult the school's academic calendar for the number of breaks during the year.QFor instructions, click on the Instructions tab at the bottom of the spreadsheet.(Comparing Costs and Financial Aid AwardsStudent Loans (Self-Help)Work-Study (Self-Help) "Grants and Scholarships (Gift Aid)Aid Available for Billed CostsSummaryEstimated Billed CostsEstimated Family Responsibility%Total Award and Family Responsibility  (Aid and Family as Percent of Total Costs qThe calculated family responsibility is the difference between your estimated costs and your financial aid award.FNote: The yellow-shaded areas of the worksheet are calculated fields.uCompare how much of your expected billed costs financial aid will cover and how much will you have to pay the school.Meals not on the meal planTotal Estimated Other Costs Estimated Balance Due the SchoolrI U#jZ  u8 : # 6! y#<`%#cc   $+01  dMbP?_*+%(?)?M\\CAMELSHUMP\Grants-HP4050-PTR1?dXLetter.HP LaserJet 4050 Series PCL 62vxeKK[QIB[J_UERK(ADąILnf½Y(,E7_Ï᮵ڦ^5og̙(Pg6=ȤcJxݮL1q#h탧l׶>?B̶JANrh;,Cc_ _?&$G2 ?P9T!Ð!A2e9߽j?TOi*bQ,Zˈ*r$8km9_˩6FSdndWzÀ۵*Q-|ce m\,=+4Z;TfaF{-/'|cj[\"dX??U} I} s$;                   W  Y              g  b e  @D      !"# !" "f# < > @ 7gghOh     a7nCQVc"e  dMbP?_*+%"A(?)?M\\CAMELSHUMP\Grants-HP4050-PTR1?dXLetter.HP LaserJet 4050 Series PCL 62vxeKK[QIB[J_UERK(ADąILnf½Y(,E7_Ï᮵ڦ^5og̙(Pg6=ȤcJxݮL1q#h탧l׶>?B̶JANrh;,Cc_ _?&$G2 ?P9T!Ð!A2e9߽j?TOi*bQ,Zˈ*r$8km9_˩6FSdndWzÀ۵*Q-|ce m\,=+4Z;TfaF{-/'|cj[\"dX??cU} * }  } $ aG  @ @ ,Y@ ,      J# w@ J# ; [*llllllllllllll Z*l!!!!!!!!!!!!! 1*!!!!!!!!!!!!!!N O0 P0 O0 Q0"!!!!!!!!!!!!!!,CIKLM!!!!!!!!!!!!!! RR*STSU!!!!!!!!!!!!!! V4*()(*"""!!!!!!!!!!! V5*()(*"""!!!!!!!!!!! V6*()(*"""!!!!!!!!!!! WS* ()(*"""!!!!!!!!!!! WT* ()(*"""!!!!!!!!!!! WU* ()(*"""!!!!!!!!!!! WV* ()(*"""!!!!!!!!!!! W-* ()(*"""!!!!!!!!!!! V7*()(*"""!!!!!!!!!!! X8*+,+-"""!!!!!!!!!!! Y"#p P %#p P %#p P %#p P %"mmmnnnnnnnnnnn Z3*0<./"""!!!!!!!!!!! [9*3<32"""!!!!!!!!!!! [:*3<32"""!!!!!!!!!!! [;*3<32"""!!!!!!!!!!! [h*3<32"""!!!!!!!!!!! [<*3<32"""!!!!!!!!!!! \X*3<32"""!!!!!!!!!!! \.*3<3A"""!!!!!!!!!!! [=*@B>?"""!!!!!!!!!!! \/*3<12"""!!!!!!!!!!! \+*3<12"""!!!!!!!!!!! \,*3<12"""!!!!!!!!!!! ]-*6=45"""!!!!!!!!!!! Yi#p / %F#p  %F#p  %F#p  %F"nnnnnnnnnnnnnn,^_```!!!!!!!!!!!!!!D< l<<<h0<<<<<<<<<<<<<<<<<<<<<<<< J# !;# "$ #,$Y@ %I@&'()*+,-. /J 0I@123 4J 5I@6789:; ;J <; =Y >; ?Y a(! p 4 DD! p 4 DD! p 4 DD! p 4 DD" nnnnnnnnnnnnnn,!^DEEEnnnnnnnnnnnnnn "2*"oooooooooooooo#N #O0 #P0 #O0 #Q0"#!!!!!!!!!!!!!!$C$I D$K $D$I $D$K $D"$!!!!!!!!!!!!!! %b^*%9:9;!!!!!!!!!!!!!! &V>*&1712"!!!!!!!!!!!!! 'V?*'1712"!!!!!!!!!!!!! (V@*(1712"!!!!!!!!!!!!! )VA*)1712"!!!!!!!!!!!!! *VA**1712"!!!!!!!!!!!!! +VA*+1712"!!!!!!!!!!!!! ,VB*,1712"!!!!!!!!!!!!! -VB*-1712"!!!!!!!!!!!!! .X-*.4845"!!!!!!!!!!!!! /Y#/p E %%. #/p E %%. #/p E %%. #/p E %%. "/!!!!!!!!!!!!!! 0b]*09:9;!!!!!!!!!!!!!! 1VC*1>F>?"!!!!!!!!!!!!! 2VD*21712"!!!!!!!!!!!!! 3XE*34845"!!!!!!!!!!!!! 4Y#4p = %03#4p = %03#4p = %03#4p = %03"4!!!!!!!!!!!!!! 5b\*59:9;!!!!!!!!!!!!!! 6VJ*6>F>?"!!!!!!!!!!!!! 7VF*71232"!!!!!!!!!!!!! 8VG*81232"!!!!!!!!!!!!! 9VH*91232"!!!!!!!!!!!!! :XI*:4565"!!!!!!!!!!!!! ;Y#;p G %5:#;p G %5:#;p G %5:#;p G %5:";!!!!!!!!!!!!!!,<^_```!!!!!!!!!!!!!! =a'=p ?D/D4D;'=p ?D/D4D;'=p ?D/D4D;'=p ?D/D4D;"=!!!!!!!!!!!!!!,>^_```!!!!!!!!!!!!!! ?a*!?p H D D=!?p H D D=!?p H D D=!?p H D D="?!!!!!!!!!!!!!!D l0<h<<<<<<<<<<<<<<<<<<<<00@; A B,@CY@ DI@EFGHIJJKLM N; O@P,QR,S TY U,HVH WY XYZ[\]^_ ,@^cddd!!!!!!!!!!!!!! A`*A!!!!!!!!!!!!!!BN BO0 BP0 BO0 BQ0"B!!!!!!!!!!!!!!CCCI $DCJ CDCI CDCJ CD"C!!!!!!!!!!!!!! Dec*DSTSU!!!!!!!!!!!!!! EV$Eq D/Er QD/Es QD/Er QD/"E!!!!!!!!!!!!!! FVKFq WD4Fr D4Fs FD4Fr FD4"F!!!!!!!!!!!!!! GVGq SD;Gr SD;Gs SD;Gr SD;"G!!!!!!!!!!!!!! HV!Hq FD?Hr FD?Hs D?Hr D?"H!!!!!!!!!!!!!! Ifd*Ituvu!!!!!!!!!!!!!! JV !Jw & D/D !Jx L D/D !Jy M D/D !Jx M D/D "J!!!!!!!!!!!!!! KV)!Kw M D4D !Kx J D4D !Ky J D4D !Kx J D4D "K!!!!!!!!!!!!!! LV !Lw K D;D !Lx K D;D !Ly K D;D !Lx K D;D "L!!!!!!!!!!!!!! MX!4Mz JD D/D4D;D 4M{ LD D/D4D;D 4M| LD D/D4D;D 4M{ LD D/D4D;D "M!!!!!!!!!!!!!!,N^_```!!!!!!!!!!!!!! Og_*O%&%'!!!!!!!!!!!!!! PhaP} QDP~ /DP} /DP /D"P!!!!!!!!!!!!!! QV$Qq ;DEQr ;DEQs ;DEQr ;DE"Q!!!!!!!!!!!!!! RV& R% R% R% R%"R!!!!!!!!!!!!!! SX#S TDGS TDGS TDGS TDG"S!!!!!!!!!!!!!! Tij'Tp DPDQDS'Tp DPDQDS'Tp DPDQDS'Tp DPDQDS"T!!!!!!!!!!!!!! U'*Ujjjjjjjjjjjjjj,Vjjjjjjjjjjjjjj WabWp `D?Wp `D?Wp `D?Wp `D?"W!!!!!!!!!!!!!! XkL*X>?@?!!!!!!!!!!!!!! YVM*Y1232!!!!!!!!!!!!!! ZVN*Z1232!!!!!!!!!!!!!! [VO*[1232!!!!!!!!!!!!!! \VP*\1232!!!!!!!!!!!!!! ]VQ*]1232!!!!!!!!!!!!!! ^V-*^1232!!!!!!!!!!!!!! _X-*_4565!!!!!!!!!!!!!!Dhl0<h<<0<l<0<<<<<<<`J `YK`p M5DWDXDYDZD[D\D]D^D_K`p W5DWDXDYDZD[D\D]D^D_K`p W5DWDXDYDZD[D\D]D^D_K`p W5DWDXDYDZD[D\D]D^D_"`!!!!!!!!!!!!!!><d2UVAA"" 7ggDgghWhLMLMJKJKJKLMJMh7hPP$$CC@ Oh+'0 PX ,Comparing Costs and Financial Aid Awardsй John LahrMicrosoft Excel@T)c.@v~@r(՜.+,D՜.+,h$ PX  $Vermont Student Assistance Corp.'  InstructionsToolTool!Print_Area  Worksheets Named RangestH4L`h_AdHocReviewCycleID_EmailSubject _AuthorEmail_AuthorEmailDisplayName_PreviousAdHocReviewCycleID_ReviewingToolsShownOncev$Help with Spiffing Up a SpreadsheetAmato@vsac.org Tara Amatoi  !"#$%&'()*+,-./012356789:;=>?@ABCRoot Entry F`(WorkbookafSummaryInformation(4DocumentSummaryInformation8<