A company car valued under the lease value rule and the cents-per-mile rule side by side, the commuting rule, group-term life imputed income from Table 2-2, mileage reimbursements and per diem split at the 2026 rates, the 2026 limits for parking, tuition, dependent care, discounts and awards, gross-ups for three tax positions and the inventory of taxable benefits: eight tabs, one fictional employer, no macros.
Enter your own vehicles, employees and payments. The workbook values a $48,500 car at $4,171.50 under the lease value rule against $4,683.00 under the cents-per-mile rule with the July 2026 mileage rate change, computes $1,021.20 of group-term life imputed income for a 52-year-old with $420,000 of coverage, splits a $20,300.00 per diem into $18,682.00 substantiated and $1,618.00 taxable, grosses up a $10,000 net payment to $14,214.64, and lists $147,811.18 of taxable benefits for the year. A Checks tab runs 68 checks against the book.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 181 free models.
Fringe_Benefit_Valuation_Workbook.xlsx (25 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind the workbook:The Fringe Benefits Tax Handbook, PDF and paperback, with the full case, the controls and the checklists.
What is in the workbook
Inputs
the 2026 rates and limits (FICA rates and the wage base, supplemental withholding rates, mileage rates for each half of 2026, the maximum vehicle value, the transportation, education, dependent care and award limits, the high-low per diem rates before and after 1 October), Table 3-1 of annual lease values, Table 2-2 of group-term life rates, and the Corvane case inputs.
Vehicles
the lease value rule for a company car (annual lease value looked up from the car's fair market value, personal share, fuel at 5.5 cents per personal mile), the cents-per-mile rule with the 2026 mileage split by half-year, the eligibility tests for the cents-per-mile rule, the comparison of the two rules, the prorated annual lease value for a partial year, the commuting rule for a group of employees and the lease value alternative for a van.
Group-term life
a roster of employees with age at year-end, pay, coverage formula and cap, coverage above $50,000, the Table 2-2 rate looked up from the age, annual cost, after-tax contributions and imputed income for box 12 code C.
Expenses
mileage reimbursements at the standard rate by half-year, flat car allowances treated as wages with the employer's FICA, and the per diem split between the amount deemed substantiated at the high-low rates and the taxable excess.
Limits
the tests against the 2026 limits for gift cards (always wages), achievement awards, educational assistance, dependent care, the employee discount against the gross profit percentage, parking against the monthly exclusion and gym reimbursements, plus the loss of the employer's meal deduction from 2026.
Gross-up
the gross payment for a net target in three tax positions (below the wage base, above the wage base and $200,000, supplemental wages above $1,000,000), the shortcut that adds the tax rate and what it actually nets, and the gross-up of a gift card.
Inventory
the 12 lines of taxable benefits with their amounts, the employer FICA rate that applies to each line and the employer's payroll tax on it, the total added to wages and the split between noncash and cash items.
Checks
the comparisons with the book, ending with a single result cell that reads ALL CHECKS OK when every check passes.
Every assumption is shaded in a light color on the Inputs tab; every other cell is a formula, with no macros, no links to other files and no circular references. Every ratio is guarded against an empty divisor. Replace the inputs with your own company's figures; the Checks tab will then show differences from the book by design.