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

2456

Replies to: Fafsa spreadsheet

  • RdtsmithRdtsmith Registered User Posts: 868 Member
    You'll have to pm one of us as emails don't show up here.
  • rgosulargosula Registered User Posts: 641 Member
    make sure your email to me is in format:

    name at xxx dot com
  • rgosulargosula Registered User Posts: 641 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
  • rgosulargosula Registered User Posts: 641 Member
    You can find on google drive:

    2015-2016 FAFSA spreadsheet : document id : 0B4Z-pPX4-i5vaFBhblhXTU8wOFE
    2016-2017 FAFSA spreadsheet : document id : 0B4Z-pPX4-i5vS29SQ013QTdhR2s
    2017-2018 FAFSA spreadsheet : document id : 0B4Z-pPX4-i5vRXlxVTBTM0FzTlU
  • 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,218 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,218 Senior Member
    2014 tax return was only used for 2015/16 FAFSA
  • rgosulargosula Registered User Posts: 641 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: 641 Member
    pdf information is the correct one if it differs from spreadsheet.
  • rgosulargosula Registered User Posts: 641 Member
    Corrected dates
    Widened some columns people were having trouble with.

    updated links below:
    https://drive.google.com/open?id=
    2015-2016 FAFSA spreadsheet : document id : 0B4Z-pPX4-i5veHRZWUk3dzFHRkk
    2016-2017 FAFSA spreadsheet : document id : 0B4Z-pPX4-i5vdmtmNE15RzFnNXc
    2017-2018 FAFSA spreadsheet : document id : 0B4Z-pPX4-i5vS2ZXR3hFNTFGVHc

    you have to download, and edit the "yellow" shaded cells with your data.
  • 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: 641 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.
Sign In or Register to comment.