Join the waitlist

Large Loan Program Test for Single Audits (2 CFR 200.518(b)(3))

What is this money worth, or what does it cost, over time?

Whether a program is a loan program and a large loan program, and the Type A threshold recomputed after removing it.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Your figures
Example figuresIllustrative only. Type over them with your own.
Large loan program
Yes: Type A, excluded from the threshold
2 CFR 200.518(b)(3)
Loan share of program
96.88%
A loan program needs 50% or more
Four times largest non-loan program
$24,800,000
Drawn to one scale
Four times largest non-loan program$24,800,000
Expenditures used for the Type A threshold$33,000,000
Type A threshold for other programs$1,000,000
All results
MeasureResult
Loan share of program
A loan program needs 50% or more
96.88%
Program provides loansYes
Four times largest non-loan program$24,800,000
Large loan programYes: Type A, excluded from the threshold
Expenditures used for the Type A threshold$33,000,000
Type A threshold for other programs
Table 1 in 200.518(b)(1)
$1,000,000
How this was worked out
Work shownrecomputed as you type
Loan program: loans are 50% or more of the program's federal awards expended
Large loan program: loan program total > 4 x largest non-loan program
Type A threshold for other programs: Table 1 applied to total expended less large loan programs

Illustrative arithmetic on the figures you enter. Check the result against your firm's methodology before relying on it.

The formulas

  • Loan program: loans are 50% or more of the program's federal awards expended
  • Large loan program: loan program total > 4 x largest non-loan program
  • Type A threshold for other programs: Table 1 applied to total expended less large loan programs

How it works

2 CFR 200.518(b)(3) keeps large loan programs from crowding other programs out of Type A. A program counts as a loan program only if loans make up 50 percent or more of its federal awards expended, and it is a large loan program when it exceeds four times the largest non-loan program. Each large loan program is Type A, and the Type A threshold for the rest is recomputed after removing all large loan programs.

Table 1 in 200.518(b)(1), as revised effective October 1, 2024: $1,000,000 for $1 million to $34 million expended; 3% of expenditures above $34 million to $100 million; $3 million above $100 million to $1 billion; 0.3% above $1 billion to $10 billion; $30 million above $10 billion to $20 billion; 0.15% above $20 billion. A cluster counts as one program.

Illustrative figures only. Check the result against your firm's methodology before relying on it.

Common questions

How are loan expenditures valued?

As described in 2 CFR 200.502, which covers loans made in the year, beginning balances with continuing compliance requirements, and related items.

What if there are two large loan programs?

Remove the total of all large loan programs before recomputing. Enter the combined amount, or run each and subtract both.

Does this tool handle the rest of major program determination?

No. Use the recomputed threshold in the major program determination calculator.

Sources

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

CalculatorType B Risk Assessment Threshold Calculator (2 CFR 200.518(d))Type A threshold, the 25 percent floor for Type B risk assessments, whether a Type B program needs one, and the one-fourth limit on high-risk Type B programs.CalculatorType A Low-Risk Program Test (2 CFR 200.518(c))Checks a Type A program against each low-risk condition, including the 5 percent questioned cost test, and says whether it must be audited as major.CalculatorSearch for Unrecorded Liabilities Coverage CalculatorCoverage of subsequent disbursements examined, the untested amount, and unrecorded liabilities found as a share of performance materiality.
For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required