{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Directions","Overview","College","Funding","Career","Glossary","Resources"],"not_rendered":{"macros":1,"defined_names":13,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Directions","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"merged":[[1,0,1,1],[6,0,7,1],[9,0,9,1]]}
[]
["Directions"]
[null,"**Note: this workbook best displayed on a laptop or desktop computer**"]
[1,"Review the Overview tab"]
[2,"Complete the College, Funding & Career tabs"]
[3,"Save your file"]
[" Please reach out to Sarah@zeniefoundation.org or your ZF coach with any questions."]
[]
[]
["Please Note\nThis workbook is intended to be used as a resource to help you and your parents gauge the potential post-graduation impact of your college decision making. In no way does this tool provide financial advice or guidance. ZF is not a financial adviser. This tool should guide you to questions to ask, areas of concern, balance of loans vs tuition vs ability to pay back post-college. Please use this tool as a resource."]

{"sheet":"Overview","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[1,1,1,3],[2,1,2,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3]]}
[]
[null,"College Affordability Overview"]
[null,"Welcome! Our College Affordability Toolkit (CAT) is the result of listening to our students over the years and putting together an exercise to help students & parents make informed decisions about the student's future. Note, this tool should not be used exclusively in your decision making nor does it provide any financial advice. It is a tool to help guide you toward an successful college experience.\n\nThe CAT is designed to provide both you with a snapshot of your financial situation and the potential impact of your choices on college, debt and career. It allows you to test a variety of scenarios and \"estimate\" the impact. We recommend you save various scenarios to compare.\n\nAs a student, the exercise assumes the you:\n  1. Want to be financially self-sufficient after graduation.\n  2. Intend to fulfill student loan obligations within ten years following graduation.\n\nZF believes that college affordability and fiscal responsibility are based on your projected financial situation after you graduate. We hope this workbook is of value to you."]
[null,"\nCollege Tab\nHelps you estimate and calculate your:\n1. College Expenses: the cost of attendance, non-school expenses associated with attendance\n2. Committed Funding: Your family's contribution, your personal contribution (definite money)\n3. Gap Amount: projected scholarships and grants (projected money)\n4. Remaining Gap Amount: your financial gap and student loan need","\nFunding Tab\nGives you a snapshot of your current loan situation and extrapolates it out to predict 4yr debt\n1. Estimate your student loan amount for current year & possible remaining gap amount\n2. How past debt combined with current helps determine your possible 4 year debt amount","\nCareer Tab\nCollege affordability based on post-graduation career and cost of living/lifestyle choices.\nThis spreadsheet helps you estimate your income and expenses after graduation, including the repayment of your student loans over a ten-year period. It will provide links and recommendations about estimating these items:\n1. Income: Gross pay, Taxes and Net Pay\n2. Expenses: Living expenses, savings and student loan repayment\n3. Affordability results: Net pay less expenses; monthly and annually\n"]
[null,"Remember, you have a great deal of control over your college affordability. "]
[null,"1. School Choice – Less expensive schools, state schools or community colleges with transfer credits to 4-year colleges."]
[null,"2. Course of Study – Prepares you for higher paying jobs."]
[null,"3. College Lifestyle – Be more cost-conscious - apply to be an Resident Asst. & receive discount Room & Board; live off-campus to have more control over your expenses."]
[null,"4. Post Graduation – Lower cost of living location."]
[null,"5. Lifestyle – Cost control over discretionary expenses – housing, transportation, travel and entertainment."]

{"sheet":"College","index":2,"n_rows":41,"n_cols":10,"rows_kept":41,"merged":[[1,1,1,4],[1,6,1,9],[2,3,2,4],[4,2,4,4],[7,3,7,4],[7,6,7,8],[8,3,8,4],[9,3,9,4],[10,3,10,4],[10,6,10,9],[11,3,11,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,2,18,4],[19,2,19,3],[20,3,20,4],[20,6,20,8],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[28,3,28,4],[29,2,29,4],[30,3,30,4],[31,3,31,4],[31,6,31,8],[32,3,32,4],[33,3,33,4]]}
[]
[null,"Annual College Budget Worksheet"]
[null,null,"Your Name (type over)","Today's Date (type over)"]
[null,null,"Your College (first choice; type over)","This fall I will be a: ",1]
[null,null,"For this exercise, please use your college of choice and enter data in the white cells only. \nGuidance & information is in brown.\n\nCost of College\nYou will need to know the expenses associated with attending your college as well as the school's financial aid generally given to students. The Net Price Calculator (NPC) is a good tool to gather cost of attending (COA) expenses and projected financial aid/student loan/work study $ amounts. You can find the NPC on your college's website. The NPC information requested of students varies by college and you will need to complete with your parent/guardian to get accurate information. \n*If your college does not have an NPC, search the school's site for \"Cost of Attendance.\" The COA shows you average costs associated with attending the college and average financial aid information you will need to complete the CAT."]
[]
[null,1,"COLLEGE EXPENSES Actual cost of attending (COA).",{"$nulls":3},"Based on Current College Expenses"]
[null,null,"Tuition",0,null,null,"This will calculate autmoatically based on your entries at left."]
[null,null,"Books",0,{"$nulls":3},"UpcomingYr","4Years"]
[null,null,"Fees",0,null,null,"Expenses",{"$f":"D18","v":0},{"$f":"D18*4","v":0}]
[null,null,"Other Course Related/Lab Fees",0,null,null,"This could well be the largest investment in your self that you (and others!) will ever make."]
[null,null,"Room & Board (incl off-campus living)",0]
[]
[null,null,"Computer, Supplies, etc.",0]
[null,null,"Spending Money (gas, travel, clothes, incidentals, etc.)",0]
[null,null,"Other - please type description here",0]
[null,null,"Other - please type description here",0]
[null,null,"Total Expenses",{"$f":"SUM(D8:D17)","v":0}]
[null,null,"This is a good time to talk to your parents again about what recommendations they may have or help they can give to help pay for your college costs. Family contribution can include loan amounts your parents are responsible to repay (not you). These number should reflect realistic affordable amounts. **Note: Family Contribution amount entered should reflect an annual contribution amount --- family will pay this amount each year, for 4 years. College funding is a four year commitment.**"]
[null,2,"COMMITTED FUNDING"]
[null,null,"Family Contribution",0,null,null,"This will calculate autmoatically based on your entries at left."]
[null,null,"Your Contribution",0,{"$nulls":3},"UpcomingYr","4Years"]
[null,null,"Other Financial Assistance (please explain)",0,null,null,"Expenses",{"$f":"D18","v":0},{"$f":"D18*4","v":0}]
[null,null,"Awarded Outside Scholarships (please list multi-year awards only; list multiple awards/line & enter combined total)",{"$nulls":3},"Committed Funding",{"$f":"D27","v":0},{"$f":"D27*4","v":0}]
[{"$nulls":3},0,null,null,"You need:",{"$f":"H23-H24","v":0},{"$f":"I23-I24","v":0}]
[{"$nulls":3},0]
[null,null,"Total Committed",{"$f":"SUM(D21:D26)","v":0}]
[]
[null,null,"Gap Amount",{"$f":"D18-D27","v":0}]
[null,null,"Now you know your Gap Amount (how much additional money you need to attend this college). In the next Section, please outline how you intend to help close this gap. Grants & Scholarships are monies you do not need to pay back. School Grant $ should be on your NPC report or the average grant amount from the college's website. You anticipate receiving these funds. They could be school aid grants, work-study, Pell Grants, outside scholarships; money that does not have to be paid back. Do not include loans in this category - only include money you do not have to pay back."]
[null,3,"GRANTS, SCHOLARSHIPS, ETC. (Money I do not have to pay back)",{"$nulls":3},"Adding your Grants, Scholarships, etc."]
[null,null,"School Grant (money the college contributes toward your tuition)",0,null,null,"This will calculate autmoatically based on your entries at left."]
[null,null,"Work Study ($1,500-2,500 if qualify)",0,{"$nulls":3},"UpcomingYr","4Years"]
[null,null,"Pell Grant",0,null,null,"Expenses",{"$f":"D18","v":0},{"$f":"D18*4","v":0}]
[null,null,"Pending Outside Scholarships  (please list multi-year awards only; scholarship names & award amounts)",{"$nulls":3},"Committed Funding",{"$f":"D27","v":0},{"$f":"D27*4","v":0}]
[null,null,"1. ",0,null,null,"Grants, Scholarships, etc.",{"$f":"D39","v":0},{"$f":"D39*4","v":0},"assumes 4 year scholarships/grants"]
[null,null,"2. ",0,null,null,"You still need:",{"$f":"H34-H35-H36","v":0},{"$f":"I34-(I36+I35)","v":0}]
[null,null,"Other - please specify",0]
[null,null,"Total Grants, Scholarships, etc.",{"$f":"SUM(D32:D38)","v":0}]
[]
[null,4,"REMAINING GAP AMOUNT & ESTIMATED  STUDENT LOAN NEED FOR UPCOMING YEAR (Gap Amt-Total Grants, Scholarships)",{"$f":"D29-D39","v":0}]

{"sheet":"Funding","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"merged":[[0,1,0,4],[1,2,1,4],[2,2,2,4],[2,6,2,11],[3,3,3,4],[3,6,3,7],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[9,3,9,4],[11,2,17,3],[12,6,12,8],[19,2,19,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[28,3,28,4],[29,3,29,4],[31,2,32,2]]}
[null,"Annual College Funding Worksheet"]
[]
[null,null,"Indicate the amount of loans you intend to extend during your upcoming college year. These are monies you are responsible for repaying."]
[null,4,"REMAINING GAP AMOUNT & ESTIMATED  STUDENT LOAN NEED FOR UPCOMING YEAR (Gap Amount - Projected Funding)",{"$f":"College!D41","v":0},null,null,"Federal Government StuLoan Maximums"]
[null,null,"Subsidized Student Loan",0,null,null,"Fresh",{"v":5500,"d":"$5,500.00"}]
[null,null,"Unsubsidized Student Loan",0,null,null,"Soph",{"v":6500,"d":"$6,500.00"}]
[null,null,"Other loan in student's name",0,null,null,"Junior",{"v":7500,"d":"$7,500.00"}]
[null,null,"Anticipated Student Loan Total",{"$f":"SUM(D5:E7)","v":0},null,null,"Senior",{"v":7500,"d":"$7,500.00"}]
[{"$nulls":6},"Max Total Allowable",{"$f":"SUM(H5:H8)","v":{"v":27000,"d":"$27,000.00"}}]
[null,5,"YOU STILL NEED",{"$f":"REMAINING_GAP_AMOUNT___ESTIMATED__STUDENT_LOAN_NEED_FOR_UPCOMING_YEAR__Gap_Amount___Projected_Funding-D8","v":0}]
[null,null,"If the \"You Still Need\" $ amount is red, this indicates you need additional funding for the upcoming school year. Please explain how you intend to obtain these funds? What will you do if are unable to close the gap?"]
[]
[{"$nulls":6},"This will calculate autmoatically based on your entries."]
[{"$nulls":7},"UpcomingYr","4Years"]
[{"$nulls":6},"Expenses",{"$f":"College!D18","v":0},{"$f":"H15*4","v":0}]
[{"$nulls":6},"Committed Funding",{"$f":"College!D27","v":0},{"$f":"H16*4","v":0}]
[{"$nulls":6},"Grants, Scholarships, etc.",{"$f":"College!D39","v":0},{"$f":"H17*4","v":0}]
[{"$nulls":6},"StuLoan Amt",{"$f":"D8","v":0},{"$f":"H18*4","v":0}]
[{"$nulls":6},"You still need:",{"$f":"H15-H16-H18-H17","v":0},{"$f":"I15-I16-I18-I17","v":0}]
[null,null,"If you are entering soph/jr/sr year,  please indicate the total amount of loans/category you have extended already."]
[null,6,"CURRENT OUTSTANDING COLLEGE DEBT (Loans extended and you are responsible for repaying)"]
[null,null,"Subsidized Loan Extended",0]
[null,null,"Unsubsidized Loan Extended",0]
[null,null,"Federal Perkins Loan Extended",0]
[null,null,"Private/Personal Loan Extended",0]
[null,null,"Other Loans Extended you are responsible for",0]
[null,null,"Current Extended Debt",{"$f":"SUM(D22:D26)","v":0}]
[]
[null,7,"TOTAL DEBT AFTER UPCOMING YEAR",{"$f":"D27+D8","v":0}]
[null,8,"YOUR EST TOTAL COLLEGE DEBT AFTER 4 YEARS - These are monies will be responsible for repaying.",{"$f":"((D8+D27)/Year)*4","v":0}]
[null,null,"If this is your funding picture for each of your 4 years, this indicates your total debt post-graduation."]
[null,null,"Let's see what your post-college life will look like based on attending this college!"]

{"sheet":"Career","index":4,"n_rows":61,"n_cols":9,"rows_kept":61,"merged":[[1,1,1,5],[2,2,2,5],[8,2,8,4],[11,2,12,5],[13,1,17,1],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[26,8,28,8],[28,4,44,5],[46,4,46,5],[48,4,48,5],[51,4,51,5]]}
[]
[null,"Career & Cost of Living Worksheet"]
[null,null,"This spreadsheet will help you estimate your income and expenses after graduation, including the repayment of your student loans in a ten-year period. It will help determine if your college choice and student loan amount is affordable. Additionally, it provides links and advice about estimating these items.\n1.    Income – Gross Pay\n2.    Federal and State Tax – Deductions made from gross pay\n3.    Net Pay – Amount of paycheck left over after deductions (i.e., Federal & State Tax, Social Security)\n3.    Living Expense Estimates\n4.    Affordability Alerts\n\nYou have a great deal of control over your discretionary expenses – housing, transportation, travel and entertainment."]
[]
[null,1,"INCOME"]
[null,"a","Job and where you live: Identify a job - you need not be definite, just realistic; choose a city, state you wish to live in post-graduation."]
[null,null,"JobTitle: ",null,"Location (City,State):"]
[]
[null,"b","Annual Salary Amount: Click Salary Finder button to search and determine the salary for your job in the location listed above. A reminder that when first out of college you are generally an \"entry level\" employee. When searching Salary Finder please use the lower end of the salary range provided."]
[null,null,"Annual Salary:",0]
[{"$nulls":3},"You will be starting your career so choose the salary at the low end of the scale"]
[null,"c","Annual Net Pay: Determine deductions and actual take home pay. Click Payroll Deduction calculator link and follow directions below to complete. \n(leave payroll site entries as is unless specified below)"]
[]
[null,null,"1. State for withholding: Select         5. Enter Federal Filing Status: Single"]
[null,null,"2. Enter Gross Pay=Salary  $              6. Enter # of Federal Allowances=1"]
[null,null,"3. Enter Gross Pay Type=Annually    7. State & Local Information: Total Allowances=1"]
[null,null,"4. Enter Pay Frequency=Annual        8. Click the CALCULATE BUTTON at bottom"]
[]
[null,null,"Annual Net Pay",0,"Total Annual Deductions:",{"$f":"D10-D19","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"This is the number in the Net Pay section of the page"]
[]
[null,"d","MONTHLY Net Pay: This auto-calcs to estimate your monthly income."]
[{"$nulls":3},"Gross Salary (total amount paid for work)",{"$f":"D10/12","v":0}]
[{"$nulls":3},"Taxes (Federal, State, etc.)",{"$f":"F19/12","v":0}]
[{"$nulls":3},"Monthly Take Home Pay",{"$f":"E23-E24","v":0}]
[]
[null,2,"MONTHLY EXPENSES",{"$nulls":5},"% of Monthly Income"]
[null,"This exercise is not inclusive but designed to help you estimate your living expenses & debt post-college against your potential earnings."]
[null,"a","Living Expenses \n(rec 70% of take home pay)",null,"ALL OF THESE ITEMS ARE WITHIN \nYOUR CONTROL\n\nSearch the web for the cost estimates. Consider having roommates, taking public transportation, having coffee at home rather than buying out\n(a $2.40 cup of coffee x 365 days a year=$876/yr)",null,null,"Some Reasonable Budget Guidelines"]
[null,null,"Rent",0,{"$nulls":3},"Housing and utilities",{"v":0.3,"d":"30%"}]
[null,null,"Food",0,{"$nulls":3},"Transportation (includes car payment, insurance, gas, and maintenance)",{"v":0.15,"d":"15%"}]
[null,null,"Utilities (electricity, heat, hot water)",0,{"$nulls":3},"Credit card, auto, and personal loan repayment",{"v":0.12,"d":"12%"}]
[null,null,"Cell Phone",0,{"$nulls":3},"Food (includes groceries and eating out)",{"v":0.1,"d":"10%"}]
[null,null,"Internet",0,{"$nulls":3},"Savings/Investment",{"v":0.1,"d":"10%"}]
[null,null,"Health Insurance",0,{"$nulls":3},"Student loan repayment",{"v":0.08,"d":"8%"}]
[null,null,"Clothes",0,{"$nulls":3},"Clothing",{"v":0.05,"d":"5%"}]
[null,null,"Shoes/Sneakers",0,{"$nulls":3},"Medical and dental expenses",{"v":0.05,"d":"5%"}]
[null,null,"Home Misc (cleaning supplies, toiletries)",0,{"$nulls":3},"Miscellaneous",{"v":0.05,"d":"5%"}]
[null,null,"Transportation (public or car) ",0]
[null,null,"Credit Cards",0,{"$nulls":3},"Car Expenses"]
[null,null,"Technologies (xbox, gadgets, etc.)",0,{"$nulls":3},"Gas",0]
[null,null,"Vacation",0,{"$nulls":3},"Insurance ",0]
[null,null,"Eat Out",0,{"$nulls":3},"Car payment",0]
[null,null,"Drinks (coffee, tea, beer, wine)",0,{"$nulls":3},"Car repairs",0]
[null,null,"Entertainment (Concert, Sports) ",0,{"$nulls":4},{"$f":"SUM(I41:I44)","v":0}]
[{"$nulls":3},0]
[null,null,"Sub-total Living Expenses",{"$f":"SUM(D30:D46)","v":0},"Green=Affordable; Red=Of Concern"]
[]
[null,"b","Savings\n(rec approx 10% of takehome  pay)",0,"Rainy day fund/GraduateSchool/Mortgage/Car/Retirement"]
[]
[{"$nulls":3},"Est Student Loan Amount Post-College:",{"$f":"Funding!D30","v":{"v":0,"d":"$0"}}]
[null,"c","Student Loan Repayment\n (rec <10% of take home pay)",0,"Click on link to calculate monthly student loan payments.\n1. Enter Student Loan amount from above\n2. Annual Interest Rate: 5.50%\n3. Loan Term: 10 years"]
[{"$nulls":3},{"$f":"D52/E25","v":{"$error":"#DIV/0!"}},"Percentage of Net Pay"]
[]
[null,null,"TOTAL EXPENSES",{"$f":"D47+D49+D52","v":0},"Green=Affordable; Red=Of Concern"]
[]
[]
[]
[null,null,"Net Pay-Total Expenses",{"$f":"E25-D55","v":{"v":0,"d":"$0.00"}},"Green=Affordable; Red=Of Concern"]
[]
[null,null,"Annualized",{"$f":"D59*12","v":{"v":0,"d":"$0.00"}},"Green=Affordable; Red=Of Concern"]

{"sheet":"Glossary","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"merged":[[0,1,0,2]]}
[null,"Glossary"]
[null,"Net Price Calculator (NPC)","Determines the amount you pay to attend an institution in a single academic year after subtracting contributions, scholarships and grants. It is a good estimation of need-based financial aid."]
[null,"Net Price","The amount you pay to attend an institution in a single academic year AFTER subtracting scholarships and grants the student receives."]
[null,"Cost of Attendance (COA)","Average expenses for one academic year of attendance. Can generally be found on the tuition page of the school's website."]
[null,"Expected Family Contribution\n(EFC)","EFC is the family contribution amount determined by the federal government through FAFSA."]
[null,"Free Application for \nFederal Student Aid\n(FAFSA) ","Completion of the FAFSA determines a family's EFC. Based on the EFC, the government then determines a student's eligibility for federal student aid. The EFC formula is calculated based on financial information provided on your FAFSA application."]
[null,"Institution's EFC","Each college or university has an algorithm to determine a student's EFC. This is generally derived from information on the student's application, FAFSA, CSS profile (if required). Every college has its own system to calculate."]
[null,"Financial Awards","There are a number of public and private financial awards available to qualified students."]
[null,"Scholarships","Scholarships are financial awards that do not have to be repaid. Many are renewable during your full college attendance as long as you meet academic requirements and do not have a material change in financial status.  \nAt some institutions, you are autmoatically eligible for school scholarships once you apply. Check with your particular school.  "]
[null,"Loans","Loans differ from grants in that they must be repaid and with interest."]
[null,"Subsidized","Loans from the federal government. These loans are \"subsidized\" by the U.S. government because you do not start to accrue interest on your loan until after you graduate. You must income qualify in order to receive a subsidized loan. Your FAFSA wil determine eligibility."]
[null,"Unsubsidized","Loans from the federal government. The interest begins to accrue as soon as you access your loan monies. "]
[null,"Private","There are many private student loan organizations and options. Beware, most of these options are at a significantly higher interest than federal subsidized/unsubsidized loans and with various fee schedules and penalty structures."]
[null,"College Award Letter","As part of its acceptance letter, your college will send you an award package indicating your financial assistance eligibility. This letter generally includes detailed Cost of Attendance, the school's Expected Family Contribution (EFC) for both student and parent, and financial package (federal, state and school funded awards)."]

{"sheet":"Resources","index":6,"n_rows":8,"n_cols":2,"rows_kept":8,"merged":[[0,0,0,1]]}
["Resources & Links"]
["College Board - Net Price Calculator","professionals.collegeboard.org/higher-ed/financial-aid/netprice/participating-schools"]
["Payscale","http://www.payscale.com/salary-calculator"]
["Federal and State Tax Finder","paycheckcity.com/calculator/salary/"]
["Student Loan Calculator","nerdwallet.com/blog/loans/student-loans/student-loan-calculator/"]
["Student Loan Calculator","bigfuture.collegboard.org/pay-for-college/loans/student-loan-calculator"]
["Comparing Financial Aid Packages","consumerfinance.gov/paying-for-college/compare-financial-aid-and-college-cost"]
["College's website - web search by CollegeName+Net Price Calculator"]