please do it on excel

i PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, E21 X You pay salaries expenses (secretary) 2 weeks (dec 3 B D F G H 4. 1 E Accounting 1 Final Exam 2019 V 2 Name: 3 Student No 9 4 5 Year Month Day 6 1 2018 Dec You invest to open a business called, >, consultant 7 2 2018 Dec 2 You pay the rent 8 3 2018 Dec 3 You buy cash Computer Equipment for +GST +QST Note 1 2018 Dec 4 You provide Professional services on account for a customer +GSTOST 10 5 2018 Dec You paid the insurance Note 4 11 6 2018 Dec 6 You buy publicity cash +GST + QST 12 7 2018 Dec 7 You get professional fees from supplier and pay cash +GST+QST 13 8 2018 Dec You pay the accountant *GST + QST Note 5 14 9 2018 Dec 9 You provide Professional services for customer on account +GST + QST 15 10 2018 Dec You buy on account Office Equipment for GST + QST Note 2 16 11 2018 Dec 11 You sign a contract starting today with a customer Note 3 17 12 2018 Dec 12 You buy cash Office supplies +GST + QST Note 6 18 13 2018 Dec 13 You receive partial payment from customer for services done last month. 19 14 2018 Deo 14 You paid the telephone bill cash +GST + QST 20 15 2018 Dec 15 You withdraw for personal use 21 16 2018 Dec 20 You pay salaries expenses (secretary) 2 weeks (dec 3 to dec 14) 22 23 24 Salaries are for 2 weeks, paid the week after on Thursday 25 26 Week 1 27 Week 2 28 Week 3 paiement for weeks 1 and 2 $45,000.00 $1,500.00 $7,450.00 $3,450.00 $3,600.00 $1,275.00 $7,280.00 $1,500.00 $4,257.00 $6,500.00 $5,600.00 $2,548.00 $2,300.00 $142.00 $2,500.00 $1,200.00 Week 1 Week 2 Week 3 paiement for weeks 1 and 2 26 27 28 29 30 31 32 33 34 Prepare the following documents 35 1 General Journal Entries 2 Post entries to General Ledger book 3 Trial Balance 4 Income statement 5 Statement of Owner's Equity 6 Balance Sheet 36 37 38 39 40 41 Note $1,490 00 $0.00 42 43 1 Computer Equipment linear depreciation on 36 months residual value - 2 Office Equipment linear depreciation on 24 months residual value 3 You sign a contract for 6 months 4 The Insurance is a contract for 24 months 5 The Accountant is a contract for 12 months 6 The Office Supplies used for the month is $856 $856.00 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 0 need to edit, it's safer to stay in Protected View. Enable Editing weeks (dec 3 to dec 14) w U > * AA Enter number of months here Enter Percentage here 36 months residual value = 20.00 Computer Equipment linear depreciation Omice Equipment linear deprecation on 24 months residual value= 15 00 The Insurance is a contract for 24 months 12 months The Accountant is a contract for You sign a contractor 6 months Enter number the amount for the month The Office Supplies used for the month is 5856 Calculate how many days are left in the month for the salary due Number of days not paid this month 11 300 TB OE Worksheet IS BS Ledger 400 Ledger 500 i PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, E21 X You pay salaries expenses (secretary) 2 weeks (dec 3 B D F G H 4. 1 E Accounting 1 Final Exam 2019 V 2 Name: 3 Student No 9 4 5 Year Month Day 6 1 2018 Dec You invest to open a business called, >, consultant 7 2 2018 Dec 2 You pay the rent 8 3 2018 Dec 3 You buy cash Computer Equipment for +GST +QST Note 1 2018 Dec 4 You provide Professional services on account for a customer +GSTOST 10 5 2018 Dec You paid the insurance Note 4 11 6 2018 Dec 6 You buy publicity cash +GST + QST 12 7 2018 Dec 7 You get professional fees from supplier and pay cash +GST+QST 13 8 2018 Dec You pay the accountant *GST + QST Note 5 14 9 2018 Dec 9 You provide Professional services for customer on account +GST + QST 15 10 2018 Dec You buy on account Office Equipment for GST + QST Note 2 16 11 2018 Dec 11 You sign a contract starting today with a customer Note 3 17 12 2018 Dec 12 You buy cash Office supplies +GST + QST Note 6 18 13 2018 Dec 13 You receive partial payment from customer for services done last month. 19 14 2018 Deo 14 You paid the telephone bill cash +GST + QST 20 15 2018 Dec 15 You withdraw for personal use 21 16 2018 Dec 20 You pay salaries expenses (secretary) 2 weeks (dec 3 to dec 14) 22 23 24 Salaries are for 2 weeks, paid the week after on Thursday 25 26 Week 1 27 Week 2 28 Week 3 paiement for weeks 1 and 2 $45,000.00 $1,500.00 $7,450.00 $3,450.00 $3,600.00 $1,275.00 $7,280.00 $1,500.00 $4,257.00 $6,500.00 $5,600.00 $2,548.00 $2,300.00 $142.00 $2,500.00 $1,200.00 Week 1 Week 2 Week 3 paiement for weeks 1 and 2 26 27 28 29 30 31 32 33 34 Prepare the following documents 35 1 General Journal Entries 2 Post entries to General Ledger book 3 Trial Balance 4 Income statement 5 Statement of Owner's Equity 6 Balance Sheet 36 37 38 39 40 41 Note $1,490 00 $0.00 42 43 1 Computer Equipment linear depreciation on 36 months residual value - 2 Office Equipment linear depreciation on 24 months residual value 3 You sign a contract for 6 months 4 The Insurance is a contract for 24 months 5 The Accountant is a contract for 12 months 6 The Office Supplies used for the month is $856 $856.00 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 0 need to edit, it's safer to stay in Protected View. Enable Editing weeks (dec 3 to dec 14) w U > * AA Enter number of months here Enter Percentage here 36 months residual value = 20.00 Computer Equipment linear depreciation Omice Equipment linear deprecation on 24 months residual value= 15 00 The Insurance is a contract for 24 months 12 months The Accountant is a contract for You sign a contractor 6 months Enter number the amount for the month The Office Supplies used for the month is 5856 Calculate how many days are left in the month for the salary due Number of days not paid this month 11 300 TB OE Worksheet IS BS Ledger 400 Ledger 500