Enter FTE Details
Example Data Table
| Employee | Covered Avg Weekly Hours | Reference Avg Weekly Hours | Exception |
|---|---|---|---|
| Alice Smith | 40 | 40 | No |
| Ben Carter | 25 | 40 | Yes |
| Mina Khan | 38 | 40 | No |
| Omar Lewis | 15 | 20 | No |
Formula Used
Standard employee FTE: Average weekly hours ÷ 40, rounded to one decimal, capped at 1.0.
Simplified employee FTE: 1.0 for 40 or more weekly hours. 0.5 for employees below 40 hours. Zero hours count as 0.
Covered FTE total: Sum of employee FTE values during the covered period.
Reference FTE total: Sum of employee FTE values during the chosen reference period.
Adjusted covered FTE: Covered FTE total + exception credit + manual adjustment.
FTE reduction quotient: Adjusted covered FTE ÷ reference FTE total. The result is capped at 1.0000.
Estimated forgiveness after FTE test: Forgiveness amount before FTE test × FTE reduction quotient.
How to Use This Calculator
Choose the standard or simplified FTE method. Enter business and loan labels if needed. Add the forgiveness amount before the FTE reduction test. Enter each employee on a separate line. Use the format shown below the textarea. Mark exceptions only when supported by records. Press Calculate FTE. Review the result above the form. Export the CSV or PDF for your files.
Paycheck Protection Program FTE Calculation Guide
Why FTE Counts Matter
The Paycheck Protection Program used full time equivalent counts to test staffing levels. This calculator helps estimate that comparison. It does not replace official guidance. It gives a structured view for planning, review, and record keeping.
How the Comparison Works
FTE matters because forgiveness could be reduced when staffing dropped. The core comparison uses an average FTE count during the covered period and compares it with a selected reference period. A quotient near one suggests little reduction. A lower quotient may show a possible forgiveness adjustment.
Standard and Simplified Methods
The standard method uses average weekly hours for each worker. Divide each worker's hours by forty. Cap each worker at one. Then add all worker values. The simplified method assigns one to workers at forty hours or more. Other workers count as one half.
Records and Exceptions
Good records are important. Payroll reports, schedules, rehire letters, and written refusals may support the numbers. Enter covered period hours and reference period hours from consistent reports. Use the same method across the calculation.
Safe Harbor Review
Exceptions can affect the final view. Some workers may be excluded when a valid rehire offer was refused. Other safe harbor rules may also apply. The calculator includes an adjustment field. Use it only for documented items.
Planning Limits
The reduction quotient is not a final forgiveness decision. It is a planning estimate. Lenders and program forms may require specific entries, dates, and certifications. Keep source files with the exported report.
Scenario Testing
This tool is useful before preparing forgiveness worksheets. It can also compare scenarios. For example, a business can test staffing restoration, partial rehiring, or expected exceptions. The result explains the formula and shows a table for each employee.
Clean Entry Tips
Use clean employee names or IDs. Enter hours as weekly averages. Review any warning messages. Download the CSV for spreadsheet checks. Download the PDF for a summary file. Store both with payroll backup.
Final Review
Always verify the covered period, reference period, and method before relying on results. When rules are uncertain, use professional help. A careful process reduces mistakes. It also makes later reviews easier for owners, bookkeepers, and advisors. Use the same employee list when possible. Separate owners, contractors, and employees if your worksheet requires it. Check seasonal choices carefully. Save screenshots of any assumptions used for management review later and audit support.
FAQs
What is a PPP FTE calculation?
It estimates average full time equivalent staffing for forgiveness review. It compares covered period staffing with a selected reference period.
What does FTE mean here?
FTE means full time equivalent. It converts weekly employee hours into staffing units, usually capped at 1.0 per employee.
Which method should I use?
Use the method required by your forgiveness worksheet or lender. The standard method uses hours divided by forty. The simplified method uses preset values.
Can I enter part time employees?
Yes. Enter each worker's average weekly hours. The calculator converts those hours into FTE values using your selected method.
What is an exception credit?
It represents documented items that may reduce the effect of staffing drops. Use it only when supported by valid records.
What does the quotient show?
The quotient compares adjusted covered period FTE with reference period FTE. A result below one may suggest a possible forgiveness reduction.
Is this a final forgiveness decision?
No. It is an estimate for planning. Final forgiveness depends on lender review, program forms, certifications, and proper documentation.
Can I export the results?
Yes. Use the CSV button for spreadsheet records. Use the PDF button after calculating to save a summary report.