Payment Worksheets and Tutorials

Determining a family’s financial obligation is an important part of preparing for college — and it can be confusing to figure out how much you will have to pay each quarter. We have developed a worksheet to help you arrive at a good estimate of what your family will need to pay.

Interactive payment worksheets

To fill out your worksheet, you will need to know several things.

  1. Quarterly costs. Please see tuition costs to determine your specific tuition and room and board costs. These are based on the credits and housing/meal plans you have chosen.
  2. Your current Offer of Financial Assistance. See the offer you received for quarterly amounts of financial aid. You can also view your offer for the year in Banner. If you have not yet received an Offer of Financial Assistance, or do not plan to receive financial aid, you can leave the second section of the worksheet blank.
  3. If you are receiving loans, note that some loans have fees, and the amount you are borrowing will not be the amount available to pay your account. Please adjust each of the following loan types by the percentage indicated.
    1. Direct Loans, Subsidized and Unsubsidized:
      1. First disbursement on or after October 1, 2016, and before October 1, 2017: 1.069%
    2. Direct PLUS loans:
      1. First disbursement on or after October 1, 2016, and before October 1, 2017: 4.276%
    3. Institutional loans: 5%
    4. Alternative loans: varies, refer to your promissory note.

Example: A Direct loan of $4,500 for the full year is $1,500 per quarter. $1,500 x .98913 (the net 1.069% adjustment) = $1,484. Someone borrowing a Direct loan of $4,500 should list $1,484 as the amount received for each quarter. (Note: All disbursements will be in whole dollars with no cents.)

Direct Loan fees are subject to change as determined by the U.S. Department of Education. Additional information about Direct loan fees is available at

View your payment plan options.