Calculate the federal tax rate. The federal tax rate is a function of the adjusted income and the employee's marital status. Reference the tax tables in the model assumptions and the marital status in the employee information section to construct a formula (or set of nested formulas) to calculate the tax rate. For example, a single employee with $15,000 in income would have a 33% marginal tax rate