READ 1st - delete before submit IMPORTANT: Read this before you continue on to the assignment. 1. There are comments on the cells that you will need to make changes or that show hints on how to do...

Could you do this excel assignment for me? Please let me know ASAP including prizing!


READ 1st - delete before submit IMPORTANT: Read this before you continue on to the assignment. 1. There are comments on the cells that you will need to make changes or that show hints on how to do that section. 2. Delete the comments (right click on the cell and click on delete comment) before you submit it. 3. Anywhere that says "your name" needs to be changes to reflect your own name. 4. Delete this tab before you submit 5. Feel free to add colours, font changes, customize it to be nice looking for the company you work for. 6. Add a personal image in place of the cheque images on the Property Tax tab. Payroll Sanjeev Pawar Insurance Inc. Amanda: Kimberly: Use calculations!! Do not just fill in the cells with the answers you work out yourself. Show us your excel skills :) PAYROLL STATEMENT Name: B. SimpsonEmployee ID:200465928 Amanda: Kimberly: Use your student number hereSaturday, February 20, 2021 Gross WagesHourly RateHours workedCurrent Gross TotalDeductionsPercentageCurrent total 37.545921 Gross payDeductionsNet PayPrepared by:Sanjeev Pawar Amanda: Kimberly: Put your first and last name here Sanjeev Pawar Insurance Inc.PAYROLL STATEMENT Name:L. SimpsonEmployee ID:200465928 Amanda: Kimberly: Use your student number here Amanda: Kimberly: Use your student number here Amanda: Kimberly: Show each calculation as a separate line item. Ex. One line should be regular rate wages and the next line should be overtime wages. Saturday, February 20, 2021 Gross WagesHourly RateHours workedCurrent Gross TotalDeductionsPercentageCurrent total Gross payDeductionsNet PayPrepared by:Sanjeev Pawar Amanda: Kimberly: Put your first and last name here Sanjeev Pawar Insurance Inc.PAYROLL STATEMENT Name:Sanjeev Pawar Amanda: Kimberly: Use your own name hereEmployee ID:200465928 Amanda: Kimberly: Use your student number hereSaturday, February 20, 2021 SalesCommission Rate for 1st tierCommission Rate for 2nd tierBase pay Gross payPrepared by:Sanjeev Pawar Amanda: Kimberly: Put your first and last name here Amanda: Kimberly: Put your first and last name here Amanda: Kimberly: Use your own name here Amanda: Kimberly: Put your first and last name here Amanda: Kimberly: Use your student number here HST Remittance Sanjeev Pawar Insurance Inc.Period start:Sunday, January 01, 2017 HST Remittance formPeriod EndMarch 31 2017 Sales and Other Revenue101 Net Tax Calculations HST amounts collected Amanda: Kimberly: Use the Sales to calculate Kimberly Thomas: Kimberly Thomas: You can insert your sales calculation table right on this sheet103 Adjustments Amanda: Kimberly: None this quarter Amanda: Kimberly: This is 13% of sales104 Total HST and adjustments for the period (add lines 103 and 104)105 Input tax credits (ITC's) for the current period106 Adjustments Amanda: Amanda: None this quarter Amanda: Kimberly: This is 13% of purchases107 Total ITCs and adjustments (add lines 106 and 107)108 Net Tax (Subtract lines 108 from line 105)109 Balance113 Refund ClaimedPayment Enclosed 114115 Property Taxes Sanjeev Pawar Insurance Inc. Property Tax Calculation Building one:Sanjeev Pawar Insurance Inc.No.2017033 Assessed Value:Date:2/18/21 Kimberly Thomas: Kimberly Thomas: Use the date function to insert today's date RatesAmount of tax based on assessed valuePay to the Order ofDDMM YYYY Municipal Levy$ County Levy/100 Dollars Education Levy MemoSanjeev Pawar TotalRoll Number:200465928 Amanda: Kimberly: Use your student number hereCEO and President Building Two: Assessed Value:Sanjeev Pawar Insurance Inc.No.2017033 RatesAmount of tax based on assessed value Municipal LevyDate:2/18/21 Kimberly Thomas: Kimberly Thomas: Use the date function to insert today's date County LevyPay to the Order ofDDMM YYYY Education Levy$ Amanda: Kimberly: This is the payment amount Amanda: Kimberly: Use your student number here Amanda: Kimberly: This is the payment amount Amanda: Kimberly: This is where the company name you are paying goes Amanda: Kimberly: Type out the amount you need to pay in words Kimberly Thomas: Kimberly Thomas: Use the date function to insert today's date Amanda: Kimberly: This is where the company name you are paying goes/100 Dollars Total MemoSanjeev Pawar Roll Number:200465928 Amanda: Kimberly: Use your student number here Amanda: Kimberly: Type out the amount you need to pay in wordsCEO and President First Bank of Barrie First Bank of Barrie