Appendix C - Appendix C to Subpart B of Part 668—90/10 Revenue Calculation
Sample Student Account Ledger
Line | Date | Charge/Payment | Memo | Debit | Credit | Balance | 1 | 12/31/2021 | Federal Direct Loan | 1,000.00 | (1,000.00) | 2 | 1/1/2022 | Tuition and Fees | 17,000.00 | 16,000.00 | 3 | 2/1/2022 | Cash Payment | 175.00 | 15,825.00 | 4 | 2/1/2022 | Federal Funds 1 | 2,000.00 | 13,825.00 | 5 | 2/1/2022 | FSEOG | (Fed. 375/Inst. 125) | 500.00 | 13,325.00 | 6 | 5/1/2022 | Cash Payment | (Federal funds 3) | 500.00 | 12,825.00 | 7 | 7/1/2022 | Federal Pell Grant | 1,700.00 | 11,125.00 | 8 | 7/1/2022 | Institutional Scholarship | 500.00 | 10,625.00 | 9 | 7/1/2022 | Federal Direct Loan | 1,500.00 | 9,125.00 | 10 | 7/1/2022 | Cash Payment | (Federal funds 4) | 3,700.00 | 5,425.00 | 11 | 8/1/2022 | Federal Funds 2 | 3,725.00 | 1,700.00 | 12 | 9/1/2022 | City Grant | 2,200.00 | (500.00) | 13 | 9/1/2022 | Refund Check | 500.00 |
---|
Line item in the sample | Amount in the sample | 12 | Grant funds for the student from non-Federal public agencies or private sources independent of the institution | 2,200.00 | Funds provided for the student under a contractual arrangement with a Federal, State, or local government agency for the purpose of providing job training to low-income individuals | Funds used by a student from savings plans for educational expenses established by or on behalf of the student that qualify for special tax treatment under the Internal Revenue Code | 8 | Qualified institutional scholarships disbursed to the student | 500.00 | Adjustment: If the amount of Total Funds Applied First is more than Tuition and Fees, then Adjusted Total Funds Applied First is reduced by the amount over Tuition and Fees | Total Funds Applied First | 2,700.00 | 1 | Prior Year Title IV Carried Over Credit Balance | 1,000.00 | 9 | Federal Direct Loan | 1,500.00 | 7 | Federal Pell Grant | 1,700.00 | 5 | FSEOG (subject to matching reduction) ($500 −$375 FSEOG and $125 Institutional Match) | 500.00 | Federal Work Study Applied to Tuition and Fees (subject to matching reduction) | 5 | Adjustment: The amount of FSEOG funds disbursed to a student and the amount of FWS funds credited to the student's account are reduced by the amount of the institutional matching funds | −125.00 | Adjustment: If the amount of Adjusted Total Funds Applied First + Total Student Title IV Revenue is more than Tuition and Fees, then Adjusted Total Student Title IV Revenue is reduced by the amount over Tuition and Fees | Adjustment: If Title IV funds are returned for a student under § 668.22, then Student Title IV Revenue is reduced by the amount returned | Adjusted Total Title IV Aid | 4,575.00 | 4 | Federal Funds 1 | 2,000.00 | 11 | Federal Funds 2 | 3,725.00 | Adjustment: If the amount of Adjusted Total Funds Applied First + Adjusted Total Student Title IV Revenue + Total Other Federal Funds Paid Directly to the Institution is more than Tuition and Fees, then Adjusted Total Other Federal Funds Paid Directly to the Institution is reduced by the amount over Tuition and Fees | Adjusted Total Other Federal Funds Paid Directly to the Institution | 5,725.00 | 6 | Federal Funds 3 | 500.00 | 10 | Federal Funds 4 | 3,700.00 | Adjustment: If the amount of Adjusted Funds Applied First + Adjusted Student Title IV Revenue + Adjusted Total Other Federal Funds Paid Directly to the Institution + Total Other Federal Funds Paid Directly to Student is more than Tuition and Fees, then Adjusted Federal Funds Paid Directly to Student is reduced by the amount over Tuition and Fees | −200.00 | Adjusted Total Other Federal Funds Paid Directly to Student | 4,000.00 | 3 | Student payments | 175.00 | 5 | Adjustment: The amount of FSEOG funds disbursed to a student and the amount of FWS funds credited to the student's account are added to cash for the institutional matching funds | 125.00 | Adjustment: If the amount of Adjusted Total Funds Applied First + Adjusted Total Student Title IV Revenue + Adjusted Total Other Federal Funds Paid Directly to the Institution + Adjusted Total Other Federal Funds Paid to Student + Total Cash and Other Non- Title Payments are more than Tuition and Fees, then Adjusted Total Cash and Other Non-Title Payments is reduced by the amount over
Tuition and Fees | −300.00 | Adjusted Total Cash and Other Non-Title IV Aid | 0 | Adjusted Total All Federal and Cash Payments | 17,000.00 |
---|
Section 2—Revenue by Source—One Student Example
Line item in the sample | Amount disbursed | Adjusted amount | 1 | Title IV Credit Balance Carried Over from Prior Year | 1,000.00 | 1,000.00 | 9 | Federal Direct Loan | 1,500.00 | 1,500.00 | 7 | Federal Pell Grant | 1,700.00 | 1,700.00 | 5 | FSEOG (federal portion only) | 375.00 | 375.00 | Total Student Title IV Revenue | 4,575.00 | 4,575.00 | 6 | Federal Funds 1 | 2,000.00 | 2,000.00 | 10 | Federal Funds 2 | 3,725.00 | 3,725.00 | Total Student Federal Funds Paid Directly to the Institution | 5,725.00 | 5,725.00 | 4 | Federal Funds 3 | 500.00 | 500.00 | 11 | Federal Funds 4 | 3,700.00 | 3,700.00 | 13 | Refunds Paid to Student | −200.00 | Adjusted Student Federal Funds Paid Directly to Student | 4,200.00 | 4,000.00 | Adjusted Student Federal Revenue | 14,500.00 | 14,300.00 | 12 | Grant funds for the student from non-Federal public agencies or private sources independent of the institution | 2,200.00 | 2,200.00 | 8 | Institutional scholarships disbursed to the student | 500.00 | 500.00 | 3,5,13 | Student payments | 300.00 | 0 | Student Non-Title IV Revenue | 3,000.00 | 2,700.00 | Total Federal and Non-Federal Revenue | 17,500.00 | 17,000.00 |
---|
Section 2—Revenue by Source—Calculation
Amount disbursed | Adjusted amount | Title IV Credit Balance Carried Over from Prior Year | 45,000.00 | 45,0000.00 | Federal Direct Loan | 1,500,000.00 | 1,500,000.00 | Federal Pell Grant | 400,700.00 | 400,700.00 | FSEOG (subject to matching reduction) | 11,500.00 | 8,625.00 | Total Student Title IV Revenue | 1,957,200.00 | 1,954,325.00 | Refunds Paid to Students | −35,500.00 | Federal Funds 3 | 50,000.00 | 50,000.00 | Federal Funds 4 | 3,700.00 | 3,700.00 | Total Student Federal Funds Paid Directly to Student | 53,700.00 | 53,700.00 | Refunds Paid to Student | −200.00 | Adjusted Student Federal Funds Paid Directly to Student | 53,700.00 | 53,500.00 | Adjusted Student Federal Revenue | 3,575,625.00 | 3,517,050.00 | Adjusted Student Title IV Revenue | 1,957,200.00 | 1,918,825.00 | Federal Funds 1 | 200,000.00 | 200,000.00 | Federal Funds 2 | 1,355,725.00 | 1,355,725.00 | Federal Portion of Other Funds | 9,000.00 | 9,000.00 | Total Student Federal Funds Paid Directly to the Institution | 1,564,725.00 | 1,564,725.00 | Refunds Paid to Students | −20,000.00 | Adjusted Student Title IV Federal Funds Paid Directly to the Institution | 1,564,725.00 | 1,544,725.00 | Activities conducted by the institution that are necessary for education and training | 25,000.00 | 25,000.00 | Funds paid to the institution by, or on behalf of, students for education and training in qualified non-Title IV eligible programs | 143,000.00 | 143,000.00 | Revenue from Other Sources | 168,000.00 | 168,000.00 | Adjusted Non-Federal Revenue and Revenue from Other Sources | 587,800.00 | 559,500.00 | Total Federal and Non-Federal Revenue | 4,163,425.00 | 4,076,550.00 |
---|
Student non-Federal revenue | Amount | Adjusted amount | Grant funds for the student from non-Federal public agencies or private sources independent of the institution | —State Grant (9.0451 percent Federal Funds) | 99,500.00 | 90,500.00 | —ABC Scholarship | 500.00 | 500.00 | Funds provided for the student under a contractual arrangement with a Federal, State, or local government agency for the purpose of providing job training to low-income individuals | Funds used by a student from savings plan for educational expenses established by or on behalf of the student that qualify for special tax treatment under the Internal Revenue Code | Qualified institutional scholarships disbursed to the student | 500.00 | 500.00 | Student payments | —Third Party Loans | 50,000.00 | 50,000.00 | —Third Party Loans-related Party/Institutional Loans | 107,000.00 | 100,000.00 | —ISA Institutional or Related Party | 37,000.00 | 25,000.00 | —ISA | 75,000.00 | 75,000.00 | —Student Cash | 50,300.00 | 50,300.00 | Student Non-Title IV Revenue | 419,800.00 | 391,800.00 | Refunds Paid to Student | −300.00 | Adjusted Non-Federal Revenue | 419,800.00 | 391,500.00 |
---|
Numerator 3,517,050.
Denominator 4,076,550 = 86.27 percent.
Section 3—Calculating the Revenue Percentage
∑ Adjusted Student Federal Revenue * ÷ ∑ Adjusted Student Federal Revenue + ∑ Adjusted Non-Federal Revenue and Revenue from Other Sources = 90/10 Revenue Percentage. |
* Adjusted Student Federal Revenue = Adjusted Student Title IV Revenue + Adjusted Other Federal Funds Paid Directly to the Institution + Adjusted Other Federal Funds Paid Directly to Student
∑ Adjusted Student Federal Revenue = The sum of the amounts of all Federal funds, as adjusted, for each student at the institution during the fiscal year to whom the institution disbursed Title IV Aid and Other Federal Funds and Federal funds that students directly receive.
∑ Adjusted Non-Federal Revenue = The sum of the amounts of items applied first and adjusted cash payments for each student at the institution during the fiscal year whose non-Federal funds were used to pay all or some of those student's Tuition and Fee charges.