90.2K

Verified Solution

Link Copied!

5103 A1 Part B-S20.pdf SMBAC-5103-A1B-Boya-Yang X D + 158.0995 FOffice 1/1 PDF , During December the following transactions occurred: 8. EX Date Dec 3 3 4 10 14 17 18 20 Transaction Paid $1,500 for advertising on the local radio station Paid $1,200 to repair the company computer te Received $3,000 for the final payment on the November 12th billing Paid Bob Smith for 6 days of work Signed a contract to complete $15,000 of computer work for XYZ CO. XYZ paid $4,000 in advance on December 14th Purchased $1,800 of computer supplies on credit Received $5,000 from Y Co for the November 28th billing Received a cash payment of $7,000 from Z Co for work completed in December Took the week off to celebrate Christmas Paid Joseph for 800 km of business mileage at a rate of $.80/km Paid Joseph a $4,000 dividend Billed Y Ltd $2,000 for work completed in December 24-28 31 31 31 99 SER w 103 A1 Part B-520.pdf SMBAC-5103-A1B-Boya-Yang X + 2 158.09% Office- PDF PSE CES 17 18 20 1 Q DMR DO 21. 3 B. Purchased $1,800 of computer supplies on credit Received $5,000 from Y Co for the November 28th billing Received a cash payment of $7,000 from Z Co for work completed in December Took the week off to celebrate Christmas Paid Joseph for 800 km of business mileage at a rate of $.80/km Paid Joseph a $4,000 dividend Billed Y Ltd $2,000 for work completed in December 24-28 31 31 31 Additional information: a. Of the $4,000 advance payment received from XYZ Co, $2,500 has been earned b. A count of supplies on December 31 revealed $700 of supplies on hand c. Bob Smith worked for 10 days in December which have not been paid d. A project for T Ltd was completed in December but the $5,000 was not billed Part B Requirements: 50 1. Prepare a tabular analysis of all the November transactions. Include dates and descriptions MAC 5103 A1 Dart B-520.pdf X MBAC 5103 A18 BY-Yang X + 158.09 aQ 8 CE PDF Additional information: a. Of the $4,000 advance payment received from XYZ Co, $2,500 has been earned b. A count of supplies on December 31 revealed $700 of supplies on hand C. Bob Smith worked for 10 days in December which have not been paid d. A project for T Ltd was completed in December but the $5,000 was not billed Part B Requirements: 1. Prepare a tabular analysis of all the November transactions. Include dates and descriptions to help organize your work. [11 marks] 2. Enter any month-end adjustments (accruals and deferrals) into the table, including dates and descriptions. [14 marks] 3. Prepare an income statement for the month ended November 30, 2020 [10 marks] 4. Prepare a retained earnings statement for the month ended November 30, 2020 (5 marks] 5. Prepare a balance sheet as at November 30, 2020. [20 marks] 8 PMBAC 5103 A1 Part B-S20.pdf EMBAC-5103 A1B-Boya Yang.xlsx X + 122 TR q 12 - AA 135 GEY AL OP BIU 9.9.A. O ES - % Tott. A mito ,,, B D E F G H Date Description Accounts Receivable + Cash Computer Supplies M N ASSETS Prepaid Office Insurance - Furnitur Prepaid Rent A Part 2 + PMBAC 5103 Al Part-520.pdf MAC-5101 AID BY Yong X + 12 - BIU - 2-A QE WIR OM Q 3 GEY 21 AU3 D E F G H 0 P 2 3 Cash Accounts Receivable + + Computer Supplies M N ASSETS Prepaid Office + Insurance - Furniture Prepaid Rent + Ace. Dep Computer Acc eo Furniture - Equipment - Computer . Accounts Payable 6 8 9 10 11 12 13 15 16 17 18 19 5900 Al Part + MBAC 5103 A1 Part B-520.pdf PO MAC-5101-416-boo-Yong X HE + X 123 12 A A BIU - 2. 2 A QE Q A. % 3 GEY 2. AU3 fx ) M N Q R S T U Prepaid Rent K ASSETS Prepaid + Insurance Office Furniture Acc. Dep. Computer Acc Dep. Furniture - Equipment - Computer - w Z LIABILITIES Wages Unearned + Payable - Revenue Accounts Payable + Common Shares 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 So 17 18 A Part SS MBAC 5103 AT Part B-520.pdf a> MENC 5101 A1 Borgo + 2 PH HA Q - 12 BIU.AA. O - % GEY AI AUS @fx W Y Z AA AB AC 1 AD AE AF AG LIABILITIES Wages Payable 2 3 4 5 + Unearned Revenue AD AK AL AN Ag AP AG SHAREHOLDERS' EQUITY Retained Earnings Rent Exp. - Adv. Exp - Supplies Exp - Repair Exp- Common Shares + Service Rev. - Wages Exp. - Ins. Exp 7 8 9 10 11 12 13 16 12 18 50+ Al Pant 15 e MBAC 5103 Al Part B-520.pdf EMP 50 i | Blog | Tags + a PO MA TH Q BE 12 ' ' BIUB. 2- A QE GEY 2. AUS @fx 4 AC AD AE AF AG AH 2 AI AJ AK AL AM AN AC AP AG AR AS AT AD AV SHAREHOLDERS' EQUITY Retained Earnings Rent Exp. Adv. Exp - Supplies Exp - Repair Exp. Dep. Exp. - Mileage expl Dividends + Service Rev. - Wages Exp. - Ins. Exp 3 4 5 6 7 9 10 11 12 13 15 16 17 18 19 So04- A1 Part 2 HE 2MBAC 5103 A1 Part B-S20.pdf - goes MBAC-5103-A1B-Boya-Yang.xlsx X + Q 12 ATA BIU = OP -% 53 199 Cookie Creations in Income Statement : : 91.00 Cookie Creations in Metained lamingement Top - Y Dows 1.00 pers December, 2000 ASSETS Experts , Name NAUTIES 5103 A1 Part B-S20.pdf SMBAC-5103-A1B-Boya-Yang X D + 158.0995 FOffice 1/1 PDF , During December the following transactions occurred: 8. EX Date Dec 3 3 4 10 14 17 18 20 Transaction Paid $1,500 for advertising on the local radio station Paid $1,200 to repair the company computer te Received $3,000 for the final payment on the November 12th billing Paid Bob Smith for 6 days of work Signed a contract to complete $15,000 of computer work for XYZ CO. XYZ paid $4,000 in advance on December 14th Purchased $1,800 of computer supplies on credit Received $5,000 from Y Co for the November 28th billing Received a cash payment of $7,000 from Z Co for work completed in December Took the week off to celebrate Christmas Paid Joseph for 800 km of business mileage at a rate of $.80/km Paid Joseph a $4,000 dividend Billed Y Ltd $2,000 for work completed in December 24-28 31 31 31 99 SER w 103 A1 Part B-520.pdf SMBAC-5103-A1B-Boya-Yang X + 2 158.09% Office- PDF PSE CES 17 18 20 1 Q DMR DO 21. 3 B. Purchased $1,800 of computer supplies on credit Received $5,000 from Y Co for the November 28th billing Received a cash payment of $7,000 from Z Co for work completed in December Took the week off to celebrate Christmas Paid Joseph for 800 km of business mileage at a rate of $.80/km Paid Joseph a $4,000 dividend Billed Y Ltd $2,000 for work completed in December 24-28 31 31 31 Additional information: a. Of the $4,000 advance payment received from XYZ Co, $2,500 has been earned b. A count of supplies on December 31 revealed $700 of supplies on hand c. Bob Smith worked for 10 days in December which have not been paid d. A project for T Ltd was completed in December but the $5,000 was not billed Part B Requirements: 50 1. Prepare a tabular analysis of all the November transactions. Include dates and descriptions MAC 5103 A1 Dart B-520.pdf X MBAC 5103 A18 BY-Yang X + 158.09 aQ 8 CE PDF Additional information: a. Of the $4,000 advance payment received from XYZ Co, $2,500 has been earned b. A count of supplies on December 31 revealed $700 of supplies on hand C. Bob Smith worked for 10 days in December which have not been paid d. A project for T Ltd was completed in December but the $5,000 was not billed Part B Requirements: 1. Prepare a tabular analysis of all the November transactions. Include dates and descriptions to help organize your work. [11 marks] 2. Enter any month-end adjustments (accruals and deferrals) into the table, including dates and descriptions. [14 marks] 3. Prepare an income statement for the month ended November 30, 2020 [10 marks] 4. Prepare a retained earnings statement for the month ended November 30, 2020 (5 marks] 5. Prepare a balance sheet as at November 30, 2020. [20 marks] 8 PMBAC 5103 A1 Part B-S20.pdf EMBAC-5103 A1B-Boya Yang.xlsx X + 122 TR q 12 - AA 135 GEY AL OP BIU 9.9.A. O ES - % Tott. A mito ,,, B D E F G H Date Description Accounts Receivable + Cash Computer Supplies M N ASSETS Prepaid Office Insurance - Furnitur Prepaid Rent A Part 2 + PMBAC 5103 Al Part-520.pdf MAC-5101 AID BY Yong X + 12 - BIU - 2-A QE WIR OM Q 3 GEY 21 AU3 D E F G H 0 P 2 3 Cash Accounts Receivable + + Computer Supplies M N ASSETS Prepaid Office + Insurance - Furniture Prepaid Rent + Ace. Dep Computer Acc eo Furniture - Equipment - Computer . Accounts Payable 6 8 9 10 11 12 13 15 16 17 18 19 5900 Al Part + MBAC 5103 A1 Part B-520.pdf PO MAC-5101-416-boo-Yong X HE + X 123 12 A A BIU - 2. 2 A QE Q A. % 3 GEY 2. AU3 fx ) M N Q R S T U Prepaid Rent K ASSETS Prepaid + Insurance Office Furniture Acc. Dep. Computer Acc Dep. Furniture - Equipment - Computer - w Z LIABILITIES Wages Unearned + Payable - Revenue Accounts Payable + Common Shares 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 So 17 18 A Part SS MBAC 5103 AT Part B-520.pdf a> MENC 5101 A1 Borgo + 2 PH HA Q - 12 BIU.AA. O - % GEY AI AUS @fx W Y Z AA AB AC 1 AD AE AF AG LIABILITIES Wages Payable 2 3 4 5 + Unearned Revenue AD AK AL AN Ag AP AG SHAREHOLDERS' EQUITY Retained Earnings Rent Exp. - Adv. Exp - Supplies Exp - Repair Exp- Common Shares + Service Rev. - Wages Exp. - Ins. Exp 7 8 9 10 11 12 13 16 12 18 50+ Al Pant 15 e MBAC 5103 Al Part B-520.pdf EMP 50 i | Blog | Tags + a PO MA TH Q BE 12 ' ' BIUB. 2- A QE GEY 2. AUS @fx 4 AC AD AE AF AG AH 2 AI AJ AK AL AM AN AC AP AG AR AS AT AD AV SHAREHOLDERS' EQUITY Retained Earnings Rent Exp. Adv. Exp - Supplies Exp - Repair Exp. Dep. Exp. - Mileage expl Dividends + Service Rev. - Wages Exp. - Ins. Exp 3 4 5 6 7 9 10 11 12 13 15 16 17 18 19 So04- A1 Part 2 HE 2MBAC 5103 A1 Part B-S20.pdf - goes MBAC-5103-A1B-Boya-Yang.xlsx X + Q 12 ATA BIU = OP -% 53 199 Cookie Creations in Income Statement : : 91.00 Cookie Creations in Metained lamingement Top - Y Dows 1.00 pers December, 2000 ASSETS Experts , Name NAUTIES

Answer & Explanation Solved by verified expert

See Answer