Description
To complete the questions in both pdfs. PRL2 midterm and final.
I don't know how long it should take a person to do, If more time is needed to complete, thats possible.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Mid-Term Exam
Module - Payroll Processing
NAME
ID
MARKS
1
1.
Prince Manufacturing is located in Winnipeg, Manitoba and is preparing its Manitoba
Health and Post-Secondary Education Tax Levy filing. The total amount of its annual gross
Manitoba payroll is $1,682,759.00. Calculate the company’s tax levy owing
(1)
Total Yearly Payroll
Between $1.25 Million and $2.5
Million
Tax Rate
4.3% on the amount in excess of $1.25
Million (notch provision)
1.682.759.00 x 4.3% = $70.08
2. Kim parks her car downtown in Québec City where the head office is located. The employees
who work downtown have their monthly parking fees of $250.00 including taxes paid by their
organization directly to the parking lot. What is Kim's semi‐monthly non‐cash taxable benefit?
A. $125.00
(1)
B. $132.74
C. $143.78
D. $287.56
3. Jamie is married with three children, works in British Columbia and is paid bi weekly. Her
employer pays 50% of her family coverage health care premiums. What amount is included in
Julie's taxable income each pay period?
(1)
4. The British Columbia provincial health insurance premium rate per month for a family of two is:
(1)
Monthly Rates of Contributions to Provincial Health Insurance Premiums is $ 37.50 per
adult thus for two adults it will be 37.50 *2= $75
5. An employee, who lives in Québec and works at an employer’s permanent establishment in
Ontario, will have income tax deducted based on
tax rates and file their personal
income tax return, subject to
tax rates.
a. . Ontario, Ontario
b. . Québec, Ontario
c. . Ontario, Québec
d. . Québec, Québec
(1)
2
6. True or False. New employees must complete a federal Personal Tax Credits Return –TD1
even if they are only claiming the basic personal amount. (1)
False
3
7. Which of the following types of earnings are subject to the Employer Health Tax in Ontario?
Legislated wages in lieu of notice
Retiring allowances
Pension payments
All of the above
(1)
8. Teresa drove a company car 15,000 personal kilometres in 2015. The total kilometres driven for
the year were 25,000 kilometres. The actual operating costs for this automobile were $868.00,
including taxes. What would Teresa's portion of these operating costs be if she was going to
reimburse the organization? (1)
15000/25000= 0.6
0.6 * $868.00 = $ 520.80
9. Tammy's 2015 total automobile benefit was $4,856.00. This amount included her standby
charges of $3,256.00 and operating cost benefit of $1,600.00. Based on these numbers,
calculate Tammy's 2015 estimated bi‐weekly automobile non‐cash taxable benefit.
(1)
= $4,856 / 26 pay periods
=$ 186.77
10. Bonavista Manufacturing is located in St. John’s, Newfoundland and Labrador and is preparing
its annual filing for the Health and Post-Secondary Education Tax. Its total Newfoundland and
Labrador remuneration is $1,652,385.00.
Calculate Bonavista Manufacturing’s employer tax owing
(1)
4
11. Mary Ann took clients to lunch and submitted the receipt to accounts payable with her expense
claim. This is considered a(n):
A. taxable expense
(1)
B. taxable benefit
C. cash allowance
D. expense reimbursement
12.
Trucking Company has employees who report to work at and are paid from the
company's location in Newfoundland and Labrador. The employer also has employees who
report to work at and are paid from their location in British Columbia. What remuneration is
subject to the Health and Post-Secondary Education Tax?
Taxable remuneration for employees working in British Columbia
Taxable remuneration for employees working in Newfoundland and Labrador
Taxable remuneration for employees working in both Newfoundland and Labrador and British
Columbia
None of the above
(1)
13. If a combination allowance of a flat dollar amount and a per kilometre amount is paid for the
same use of the automobile, they are considered Taxable
(1)
14. A Québec employee has received three non‐cash gifts in the current year worth $150.00,
$200.00, and $250.00. What amount is provincially taxable?
(1)
$150 + $200 + $250 = $600
$600 - $500 exemption = $100
= $100
15. Reimbursements of meal expenses incurred by an employee when conducting business are
Not included in
income.
(1)
16. Business driving refers to any driving by an employee for business purposes not including:
A. driving to existing and prospective clients
B. travel between home and work
(1)
C. travelling directly from home to a point of call
D. when the employee travels home from a point of call
5
17. Player Flooring, located in Pointe Claire, Québec has a weekly pay period. France Lavergne works
in the shipping/receiving department, earns $18.50 per hour and works 40 regular hours per
week. France works overtime every week; in this pay period she worked 4 hours overtime each
day from Monday through Thursday. The organization pays employees 1½ times their regular
hourly rate for overtime hours worked and provides a $20.00 meal allowance per day to
employees who work overtime. France has a claim code of 3 on her federal TD1 and a deduction
code of C on her TP1015.3‐V. Calculate France’s net pay. (7)
Regular wages = $18.50 x 40 = $740.00
Overtime wages = $18.50 x 1.5 x 16 = $444.00
Taxable meal allowance = $20.00 x 4 = $80.00
Gross Earnings
Gross Earnings = Earnings + taxable allowances + non-taxable
allowances + cash taxable benefits
($740.00 + 444.00) + 80.00 + 0.00 + 0.00 = $1,264.00
Non-Cash Taxable Benefits = $0.00
Gross Pensionable/Taxable Income = Earnings + taxable allowances + cash
(GPTI) taxable benefits + non-cash taxable benefits
= ($740.00 + 444.00) + 80.00 + 0.00 + 0.00 = $1,264.00
Québec Pension Plan contribution = (GPTI - pay period exemption) x annual QPP
rate
($1,264.00 - 67.30) x 0.054 = $64.62
Employment Insurance (EI) premium
Gross Insurable Earnings = Earnings + taxable allowances + cash taxable
(GIE) benefits
= ($740.00 + 444.00) + 80.00 + 0.00 = $1,264.00
Employment Insurance premium = GIE x annual Québec EI rate
=$1,264.00 x .0127 = $16.05
Québec Parental Insurance Plan (QPIP) premium
Gross Insurable Earnings = Earnings + taxable allowances + cash
(GIE) taxable benefits
= $1,264.00 + 0.00 = $1,264.00
Québec Parental Insurance Plan = GIE x annual QPIP premium rate
= $1,264.00 x 0.00548
= $6.93
Net Taxable Income (federal) = GPTI less authorized deductions
$1,264.00 - 0.00 = $1,264.00
6
federal income tax on Federal Net Taxable Income
Using the federal tax tables for a Québec employee, weekly pay period, claim code 3:
Federal tax = $172.70
Net Taxable Income (Québec) = GPTI less authorized deductions
= $1,264.00 - 0.00 = $1,264.00
Using the provincial tax tables for a Québec employee, weekly pay period, deduction
code C:
Québec tax = $221.96
Total Deductions = C/QPP contributions
= $ 64.62 (QPP) + 16.05 (EI) + 6.93 (QPIP) + 172.70 (Federal income tax) + 221.96
(Québec income tax) = $482.26
Net Pay = Gross Earnings - Total Deductions
= $1,264.00 - 482.26
$ 781.74
18. Out of the following group sickness and accident insurance plans, the non‐cash taxable benefit for
all provinces and territories is
(1)
a. Short term disability
b. Long term disability
c. Accident insurance plans
d. All of the above
19. The insurance levy in Manitoba is
20. Paramedical service is the
.(1)
benefit in Quebec. (1)
21. If the employer pays the cost of an employee’s expenses directly to the provider of the treatment,
the amount the employer pays would be considered
a non-cash taxable benefit to the employee
(1)
7
22. The salary, employee earns in when working in Nunavut and Northwest territories is subject to
a. CPP and EI
b. Federal/Territorial taxes
c. Payroll taxes
d. All of the above
(1)
23. The province of British Columbia funds its health care through premiums collected from
of the province.
a. Employees
b. Employers
c. Residents
d. All of the above
(1)
24. Jonny took $20,000 loan from his employer, with an agreement to pay $1000 instalment every
month, at 3% interest when the government rate was 5%. Jonny had paid 3 instalments. Calculate
the taxable benefit in the 4th month.(1)
25. An Ontario employer pays 50% of their employees' monthly group term life insurance premium.
Coverage is $0.90 per $1,000.00 based on two (2) times annual salary of $34,000.00. The premium
is subject to 8% sales tax. Calculate the weekly non‐cash taxable benefit.
(1)
monthly non-cash taxable benefit:
$34,000.00 x 2 = $68,000.00 (coverage amount).
$68,000.00 x $0.90 (monthly premium rate) = $61,200.00
$61,200.00 / $1,000.00 = $61.20.
$61.20 x 8% (retail sales tax) = $4.90
$61.20 + $4.90 = $66.10
pay period non-cash taxable benefit
$66.10 x 12 / 52 = $15.25
employer's portion
$15.25 x 50% = $7.63
26. What is the operating cost benefit for a company‐owned or company‐leased automobile which
was driven 15,000 personal kilometres?
Operating Cost= 15,000 * 0.26 = $3,900
(1)
8
27. Claire Rozon works for Lebrun Ind. in Montréal and has a company‐leased automobile for her
use during the year. Given the following information, calculate Claire’s annual taxable benefit.
Claire has asked the company to use the optional method of calculating her operating cost
benefit.
a. Monthly cost of the automobile $400
b. GST on monthly cost (5.00%) $ 20.00
c. QST on monthly cost (9.975%) $ 40
d. Days available (Jan 1 – Dec. 31, of the current year) 365
e. Total kilometres driven 50,000
f. Personal kilometres driven 22,000
(2)
g. Employee reimbursement $ 0.00
Calculate the automobile availability.
Availability = 365 /30= 12
Standby charge = 2/3 x (monthly cost of automobile + taxes) x availability
= 2/3 x ($400 + 20.00 + 40) x 12
= 2/3 x $460 x 12
= $3,680
Determine if a reduced standby charge applies. If so, calculate.
Claire used the automobile more than 50% for business purposes and her personal
use of 22,000 kilometres (km) did not exceed the 1,667 km per 30-day period limit
(20,004), so a reduced standby charge will apply in this case.
Reduced standby charge =
Personal kilometres x [2/3 x (monthly cost + taxes) x availability]
1,667 x availability
= (22,000 x $3,680)/20,004
= $4,047.19
Calculate the operating cost benefit.
Operating Cost Benefit = $0.26 x personal km driven
= $0.26 x 22,000
= $5,720.00
Determine if the optional method of calculating the operating cost benefit applies. If
so, calculate.
The optional method of calculating the operating cost benefit can be used if the
following three conditions are met:
the employee notifies the employer in writing to use the optional method
the business use of the automobile is more than 50%
a standby charge component is included in the employee’s income
As Claire met the required conditions, the optional method is calculated as follows:
Optional Method = Standby charge (or reduced standby charge, if applicable) x 50%
9
= $4,047.19 x 50%
= $2,023.59
Calculate the annual taxable benefit.
Automobile taxable benefit = Standby charge (or reduced standby charge) +
operating cost benefit - employee reimbursement
= $4,047.19+ 2,023.59 - 0.00
= $6,070.78
28. Kenneth works in Manitoba and is paid an annual salary of $41,115.00, which is paid semi‐
monthly. Kenneth is also provided with group term life insurance with a monthly premium of
$54.00 including all taxes. The employer pays 50% of this premium. Calculate Kenneth's
Employment Insurance premium per pay period.
(1)
10
29. Marc is an accounts payable administrator for a large retail clothing chain in Québec. He earns
$33,000.00 annually, paid bi‐weekly. Marc’s TD1 claim code is 1 and his TP1015.3‐V deduction
code is A. As part of the 100% employer‐paid benefit package, Marc has group term life insurance
coverage of two times his annual salary. The company pays $0.85 per $1,000 of coverage for the
group term life insurance coverage. Each administrative staff member receives an employer‐paid
parking spot at head office, located in downtown Montréal, where the fair market value of parking
in the vicinity is $250.00 per month, plus tax. Parking benefits are assessed on a pay period basis.
Marc receives a taxable car allowance of $75.00 per pay for using his own automobile for business
purposes
Calculate Net Pay.
Salary per pay period = Annual salary
Pay period frequency
(5)
= $33,000.00/26
= $1,269.23
Group term life insurance = coverage x premium rate
taxable benefit (monthly) $1,000.00
= ($33,000.00 x 2) x 0.85/$1,000.00
= $61.15
Pay period taxable benefit = Monthly taxable benefit x 12/Pay period frequency
= $61.15 x 12/26
= $28.22
Pay period parking = (Cost + GST + QST) x 12 taxable benefit Pay period frequency
= [$250.00 + ($250.00 x 5.0 %) + ( $250.00 x 9.975%)] x 12 /26
= $132.66
Gross Earnings = Earnings + taxable allowances + non-taxable allowances
+ cash taxable benefits
= $1,269.23 + 75.00 + 0.00
= $1,344.23
Non-Cash Taxable Benefits = $28.22 + 132.66
= $160.88
Gross Pensionable/Taxable Income = Earnings + taxable allowances + cash taxable
(GPTI) benefits + non-cash taxable benefits
= $1,269.23 + 75.00 + 0.00 + 160.88
= $1,505.11
Québec Pension Plan contribution = (GPTI - pay period exemption) x annual QPP rate
= ($1,505.11 - 134.61) x 0.054
11
= $74.01
Gross Insurable Earnings (GIE) = Earnings + taxable allowances + cash taxable
benefits
= $1,269.23 + 75.00 + 0.00
= $1,344.23
Employment Insurance premium = GIE x annual Québec EI rate
= $1,344.23 x .0127
= $17.07
Gross Insurable Earnings (GIE) = Earnings + taxable allowances + cash taxable
benefits
= $1,269.23 + 75.00 + 0.00
= $1,344.23
Québec Parental Insurance Plan
premium = GIE x annual QPIP rate
= $1,344.23 x 0.00548
= $ 7.37
Net Taxable Income (Federal) = GPTI less authorized deductions
= $1,505.11 - 0.00
= $1,505.11
Using the federal tax tables for a Québec employee, bi-weekly pay period, claim code 1:
Federal tax = $167.10
Net Taxable Income (Québec) = GPTI less authorized deductions
= $1,505.11 - 0.00
= $1,505.11
Determine Québec income tax on Québec Net Taxable Income
Using the provincial tax tables for a Québec employee, bi-weekly pay period, deduction
code A:
Québec tax = $225.16
Total Deductions = $ 74.01 (QPP) + 17.07 (EI) + 7.37 (QPIP) + 167.10 (Federal income tax) +
225.16 (Québec provincial income tax) = $ 490.71
Net Pay
Net Pay = Gross Earnings - Total Deductions
= $1,344.23 - 490.71 = $ 853.52
30. Michelle Laframboise sits on the Board of Directors for a Québec organization and receives a
12
quarterly director’s fee of $9,300.00. Michelle’s TD1 and TP‐1015.3‐V codes are 1 and A. Michelle
is not an employee of the organization. Calculate her net payment.
(3)
QPP contribution:
QPP quarterly exemption = Annual QPP exemption / 4
= $3,500.00 / 4
= $ 875.00
QPP contribution = (Quarterly payment - quarterly exemption) x
annual rate
= ($9,300.00 - 875.00) x 0.054
= $8,425.00 x 0.054
= $454.95
QPIP premium:
Québec Parental Insurance
Plan premium = Gross Insurable Earnings x annual QPIP rate
= $9,300.00 x 0.00548 = $50.96
Federal and Provincial Income Tax:
Monthly fee = $9,300.00 / 3 = $3,100.00
Québec federal monthly tax table, net taxab...