fx DO NOT change the format of this Excel file. Do not insert or delete rows...

Transcribed Image Text:

fx DO NOT change the format of this Excel file. Do not insert or delete rows or columns on any worksheet. You should only enter formulas or values in the cells provided. This assignment is partially graded by automatic 1 comparison with a key, so changes to the locations of answers will cause numerous errors Koala Industries Inc. began business operations on January 1, 2021. Koala Industries Inc.'s annual reporting period ends December 31. Some events have already occurred and have been recorded; these are reflected in the beginning balances shown on the accounting equation grid. Analyze the following additional events during 2021 and complete the requirements on the other worksheets. 3 Requirements: 23456 1) Record events a) through i) below in the accounting equation ("Grid" worksheet, rows 7-15) 2) Record events al through i) below as journal entries ("I-Es" worksheet, rows 1-46) Note: See the instruction in row 1 of the "-Es" sheet about Account Nomes and Basic Acct Eq. Impacts. Although there was only one column for expenses on the grid, in your journal entries you must use the appropriate expense account names from the chart of accounts 3) Prepare an Unadjusted Trial Balance ("UnAdj TB" worksheet) 4) Record events i) through p) in the accounting equation ("Grid" worksheet, rows 17-24) 5) Record events) through p) below as journal entries ("-Es" worksheet, rows 48-87) T 8 9 10 11 6) Prepare an Adjusted Trial Balance ("Adjusted TB" worksheet) 12 7) Prepare all four financial statements ("Fin Stmts" worksheet) 15 14 15 16 b) Purchased $1,200 supplies on account for future use. 17 18 19 20 21 Events: a) Purchased $14,800 of equipment for use in the business, paid $1,480 in cash and the rest was on account. c) Customers paid $7,500 in advance for future services. d) Earned $127,500 in service revenues for 2021, including $93,800 on credit and $33,700 collected in cash. e) Collected accounts receivable, $17,900. f) Sold an old vehicle (that was fully depreciated) for $2,500 cash g) On Oct. 31, paid $9,600 to rent a building for 12 months, starting on Nov. 1 22 h) Paid accounts payable, $12,400. 23 Declared and paid a 524,000 cash dividend. 25 26 27 24 Information for Adjustments: Koala recorded 53,500 in service provided that had been collected in event (c), but had not yet been recorded. k) During December, Koala accrued $4,740 in service that had been provided to customers on account Wages of $10,600 earned by employees since the December 24 payroll were not yet paid. 28 m) Determined after a year-end count that $3,200 of supplies remained on hand at the year. 29 n) Accrued annual interest at 9.0% on the outstanding balance of the loan (promissory note) 30 o) Building rental expenses for the year, paid in transaction (e), had not yet been recorded. 31 32 p) Depreciation for the year on the equipment was 10% of the year-end Equipment account balance a) Income tax for the year was $23,800. It will be paid in 2022. 33 34 35 36 37 38 39 40 Instructions Grid J-Es UnAdj TB Adjusted TB Fin Stmts + B fx DO NOT change the format of this Excel file. Do not insert or delete rows or columns on any worksheet. You should only enter formulas or values in the cells provided. This assignment is partially graded by automatic 1 comparison with a key, so changes to the locations of answers will cause numerous errors Koala Industries Inc. began business operations on January 1, 2021. Koala Industries Inc.'s annual reporting period ends December 31. Some events have already occurred and have been recorded; these are reflected in the beginning balances shown on the accounting equation grid. Analyze the following additional events during 2021 and complete the requirements on the other worksheets. 3 Requirements: 23456 1) Record events a) through i) below in the accounting equation ("Grid" worksheet, rows 7-15) 2) Record events al through i) below as journal entries ("I-Es" worksheet, rows 1-46) Note: See the instruction in row 1 of the "-Es" sheet about Account Nomes and Basic Acct Eq. Impacts. Although there was only one column for expenses on the grid, in your journal entries you must use the appropriate expense account names from the chart of accounts 3) Prepare an Unadjusted Trial Balance ("UnAdj TB" worksheet) 4) Record events i) through p) in the accounting equation ("Grid" worksheet, rows 17-24) 5) Record events) through p) below as journal entries ("-Es" worksheet, rows 48-87) T 8 9 10 11 6) Prepare an Adjusted Trial Balance ("Adjusted TB" worksheet) 12 7) Prepare all four financial statements ("Fin Stmts" worksheet) 15 14 15 16 b) Purchased $1,200 supplies on account for future use. 17 18 19 20 21 Events: a) Purchased $14,800 of equipment for use in the business, paid $1,480 in cash and the rest was on account. c) Customers paid $7,500 in advance for future services. d) Earned $127,500 in service revenues for 2021, including $93,800 on credit and $33,700 collected in cash. e) Collected accounts receivable, $17,900. f) Sold an old vehicle (that was fully depreciated) for $2,500 cash g) On Oct. 31, paid $9,600 to rent a building for 12 months, starting on Nov. 1 22 h) Paid accounts payable, $12,400. 23 Declared and paid a 524,000 cash dividend. 25 26 27 24 Information for Adjustments: Koala recorded 53,500 in service provided that had been collected in event (c), but had not yet been recorded. k) During December, Koala accrued $4,740 in service that had been provided to customers on account Wages of $10,600 earned by employees since the December 24 payroll were not yet paid. 28 m) Determined after a year-end count that $3,200 of supplies remained on hand at the year. 29 n) Accrued annual interest at 9.0% on the outstanding balance of the loan (promissory note) 30 o) Building rental expenses for the year, paid in transaction (e), had not yet been recorded. 31 32 p) Depreciation for the year on the equipment was 10% of the year-end Equipment account balance a) Income tax for the year was $23,800. It will be paid in 2022. 33 34 35 36 37 38 39 40 Instructions Grid J-Es UnAdj TB Adjusted TB Fin Stmts + B