Cpp Ei Fed and ON stub

Originally Posted by Cutter

I believe you want:

In E2:
=ROUND((D2-ROUND(3500/26,2))*0.0495,2)

In F2
=E2

In F3
=MIN(2163.15,F2+E3)

Thanks Cutter. It solved my one problem.

Now Please If you can help me to determine Employee E.I and Employer E.I. and Ontario and Federal TAX for payroll. that would be great.

Employee E.I
* Maximum Annual Insurable Earnings - $42,300.00
* Premium/Contribution Rate (employee) - 1.73%
* Annual Maximum Premium (employee) EI - $747.36
Employer contribution rate - 2.492%
Annual Employer maximum - 1101.46

Provincial and Federal tax rate can be found on this website:
http://www.cra-arc.gc.ca/tx/ndvdls/fq/txrts-eng.html

Thanks