ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Canada Emergency Wage Subsidy Calculator
2
Created by Owais Lightwala - if I made a mistake here let me know at owais@whynot.theatre
3
Last updated Apr 27, 2020
4
5
The Canadian gov has released their own, much more detailed, calculator on their website. You can get it here - https://www.canada.ca/en/revenue-agency/services/subsidy/emergency-wage-subsidy/cews-calculate-subsidy-amount.html
6
7
To use this sheet, you'll need to click on "File" in the top right corner and then click on "Download As", then select "Microsoft Excel" and that version you download is editable (and you can also upload it back to Google Sheets on your own Google Account)
8
GREEN Cells are where you input your info - all values in here are for demo purposes
9
GREY Cells are formulas, leave those be, or you'll break the spreadsheet
10
RED Cells are formulas too and ALSO important totals, those are the numbers i built this thing for in the first place
11
12
Weekly Wage Calculator (all the calculators below require weekly pay numbers)
13
AnnualMonthlyWeekly
14
If you know the Annual Salary, enter it into the green box 100 000 8 333 1 923
15
If you know the Monthly Salary, enter it into the green box 24 000 2 000 462
16
17
18
Weekly Subsidy Amount Calculator
19
# of employeescurrent individual weekly salaryCEWS Eligible amount (each)total weekly payrolltotal weekly CEWS subsidy
20
Pay Scale 11.0 1 500 847 1 500 847
21
Pay Scale 22.0 500 375 1 000 750
22
Pay Scale 3 - - -
23
Pay Scale 4 - - -
24
Pay Scale 5 - - -
25
Pay Scale 6 - - -
26
Pay Scale 7 - - -
27
Pay Scale 8 - - -
28
Pay Scale 9 - - -
29
Pay Scale 10 - - -
30
- - -
31
TOTALS3.0 2 500 1 597
32
33
34
Long Term Subsidy Amount Calculator
35
total weekly payroll (PULLED FROM ABOVE) 2 500
36
total weekly CEWS subsidy (PULLED FROM ABOVE) 1 597
37
38
Pay Period 1
39
Are you eligible for subsidy for the first Pay Period (March 15 - April 11)?
IF YES, put in any text here, if NO LEAVE BLANK
yes
**Details on the revenue requirements (15% drop) are here
40
total payroll in Pay Period 1 10 000
41
total CEWS subsidy in Pay Period 1 6 388
42
43
Pay Period 2
44
Are you eligible for subsidy for the second Pay Period (April 12 - May 9)?
IF YES, put in any text here, if NO leave blank
yes
**Details on the revenue requirements (30% drop) are here
45
total payroll in Pay Period 2 10 000
46
total CEWS subsidy in Pay Period 2 6 388
47
48
Pay Period 3
49
Are you eligible for subsidy for the third Pay Period (May 10 - June 6)?
IF YES, put in any text here, if NO leave blank
yes
**Details on the revenue requirements (30% drop) are here
50
total payroll in Pay Period 3 10 000
51
total CEWS subsidy in Pay Period 3 6 388
52
53
Total Payroll (for all three pay periods) 30 000
54
Total CEWS subsidy (for all three pay periods) 19 164
**If your employees are on leave with pay, you are also eligible for a refund on the employer portion of EI and CPP - which I ballpark at about 7% of salary, but it will vary based on what salaries you are starting with
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100