Welcome to College Confidential!

The leading college-bound community on the web

Sign Up For Free

Join for FREE, and start talking with other members, weighing in on community discussions, and more.

Also, by registering and logging in you'll see fewer ads and pesky welcome messages (like this one!)

As a CC member, you can:

  • Reply to threads, and start your own.
  • Post reviews of your campus visits.
  • Find hundreds of pages of informative articles.
  • Search from over 3 million scholarships.

Fafsa spreadsheet

24567

Replies to: Fafsa spreadsheet

  • rgosulargosula Registered User Posts: 632 Member
    make sure your email to me is in format:

    name at xxx dot com
  • rgosulargosula Registered User Posts: 632 Member
    I have not updated it for 2016/17 because I did not have a personal need to do so.

    I unprotected all cells, so you can modify it if you wish.
    If you just use it as is, it might be $200s off. But you still get a feeling for the tradeoffs.

    Here are links to where the 2016/17 information is at:
    http://www.ifap.ed.gov/efcformulaguide/attachments/100615EFCFormulaGuide1617Attach.pdf
    http://www.ifap.ed.gov/dpcletters/GEN1601.html
  • FraugherFraugher Registered User Posts: 5 New Member
    edited August 2016
    Thank you so much for your contributions, these are great links.

    Wanted to clarify in your 1617 xls and 1718 xls the year reference in "Parent's Income in 20XX" is different from the year referenced in the PDF. For example, your 1617 worksheet is asking for income from 2014 but so is your 1516 worksheet, and 1718 is asking for income from 2015. My kid is a 17-18 freshman, and base year I believe is now 2016. I see that you have posted the caveat that you have not made certain changes to the current sheets, but this is pretty big one, so thought I would note it, not as criticism but help for others. Many thanks again.
  • mommdcmommdc Registered User Posts: 10,527 Senior Member
    No, 2015 tax return is used for 2016/17 FAFSA and 2017/18 FAFSA. From October 2016 on is when prior prior year applies.
  • mommdcmommdc Registered User Posts: 10,527 Senior Member
    2014 tax return was only used for 2015/16 FAFSA
  • rgosulargosula Registered User Posts: 632 Member
    @mommdc is correct:

    I did not really fix all dates correctly when copying one year to the next and making the updates to the spreadsheet. I made it a point to correct the dates on the 2017-2018 FAFSA because I knew there would be more confusion there.

    2015-2016 FAFSA spreadsheet is supposed to use 2014 tax year
    2016-2017 FAFSA spreadsheet is supposed to use 2015 tax year -> I think this is the one I did not update the dates correctly.
    2017-2018 FAFSA spreadsheet is supposed to use 2015 tax year due to new PPY (prior-prior year) rule


    Looking back only, 2016-2017 FAFSA spreadsheet is wrong, where it is indicating 2014 tax year, but it really should be 2015 tax year.
  • rgosulargosula Registered User Posts: 632 Member
    pdf information is the correct one if it differs from spreadsheet.
  • 2muchquan2muchquan Registered User Posts: 2,030 Senior Member
    Thanks for the links. So helpful!
  • SJL512SJL512 Registered User Posts: 1 New Member
    edited August 2016
    I am interested in your spreadsheet - thank you so much for taking the time do do this -

    Deleted EMail address. PM the poster for the file.
    ED
    Post edited by Erin's Dad on
  • rgosulargosula Registered User Posts: 632 Member
    Look at comment #26
  • WhataProcessWhataProcess Registered User Posts: 580 Member
    Thank you for this.

    I find Table A3 interesting....that income protection per student declines as number of children in college increases. Never thought about that aspect or saw the numbers in black & white.
  • mommdcmommdc Registered User Posts: 10,527 Senior Member
    Yes, it does, maybe they figure you have fewer kids at home then?
  • rgosulargosula Registered User Posts: 632 Member
    edited August 2016
    Yes allowance per kid in college goes down apparently increasing EFC, but then when you get to line 27 of the main sheet, you see that that 26 gets divided by line 27 (#kids in college) to generate parent contribution. So overall your EFC is lower.
  • ProfPlumProfPlum Registered User Posts: 1 New Member
    Many thanks for your work on this! Would you be willing to share the spreadsheet password so that I could make changes for it work for my larger family?
  • bgbg4usbgbg4us Registered User Posts: 907 Member
    just want to say that a year-plus ago i used this spreadsheet, (thanks!) and it helped us sort things out tremendously. I was confused about it all -- I was on a spending spree to lower our cash on hand so our EFC would be <15K for particular need-based scholarship. DUH -- not too smart -- and this spreadsheet really showed how income is a big determining factor.

    This is why I like this forum so much. It's been setting us straight for the next 2!
This discussion has been closed.