Task: Final Assignment (40% of the Final grade)
You must answer all the questions in the proposed business case.
This task assesses the following learning outcomes:
- Critically understand and apply all the steps of the accounting cycle.
- Properly elaborate a company´s financials.
- Critically interpret a company’s financials to evaluate its performance, liquidity and solvency.
LAUNCH: WEEK 4 / DELIVERY: 21 JUNE, 2020, 23:59HRS ON MOODLE
Submission file format: Excel document with all the answers, clearly identifying all steps, results, journals and including comments besides each answer.
TASKS (100 points)
Powerjob Inc. provides employment consulting services. The company adjusts its accounts monthly but performs closing entries annually on December 31. The firm’s unadjusted trial balance dated December 31, 2020 is shown below.
Other data:
- Accrued but unrecorded and uncollected consulting fee earned at December 31 totals: $25000.
- The company determined that $15000 of previously unearned consulting fees had been earned at December 31.
- Office supplies on hand at December 31 total $300
- The company purchased all of its equipment when it first began business. At that time, the estimated useful life of the equipment was six years.
- The company prepaid its nine-month rent agreement on June 1, 2020.
- The company prepaid its six-month insurance policy on December 1, 2020 7. Accrued but unpaid salaries total $12000 at December 31,2020.
8. On September 1, 2020, the company borrowed $60000 by signing an eight-month, 4 percent note payable. The entire amount, plus interest, is due March 31, 2021.
| PowerJo | b Inc. | ||||||||
| UNADJUSTED TRI | AL BALANCE | ||||||||
| DECEMBE | R 31, 2020 | ||||||||
| Account | Debit | Credit | |||||||
| Cash | $276500 | ||||||||
| Accounts receivable | $90000 | ||||||||
| Office supplies | $800 | ||||||||
| Prepaid rent | $3600 | ||||||||
| Unexpired insurance | $1500 | ||||||||
| Office equipment | $72000 | ||||||||
| Accumulated depreciation : office equipment | $24000 | ||||||||
| Accounts payable | $4000 | ||||||||
| Notes payable (due 3/1/12) | $60000 | ||||||||
| Interest payable | $600 | ||||||||
| Income taxes payable | $9000 | ||||||||
| Dividends payable | $3000 | ||||||||
| Unearned consulting fees | $22000 | ||||||||
| Capital stock | $200000 | ||||||||
| Retained earnings | $40000 | ||||||||
| Dividends | $3000 | ||||||||
| Consulting fees earned | $500000 | ||||||||
| Rent expense | $14700 | ||||||||
| Insurance expense | $2200 | ||||||||
| Office supplies expense | $4500 | ||||||||
| Depreciation expense : office equipment | $11000 | ||||||||
| Salaries expense | $330000 | ||||||||
| Utilities expense | $4800 | ||||||||
| Interest expense | $3000 | ||||||||
| Income taxes expense | $45000 | ||||||||
| Totals | $862600 | $862600 |
Instructions:
- Prepare the necessary adjusting journal entries on December 31, 2020. Also prepare an adjusted trial balance dated December 31, 2020 (20 points).
- From the adjusted trial balance prepared in part a, prepare an income statement and statement of retained earnings for the year ended December 31, 2020. Also prepare the company’s balance sheet dated December 31, 2020 (20 points).
- Prepare the necessary year-end closing entries (15 points).
- Prepare an after-closing trial balance (15 points).
- Compute the company’s average monthly insurance expense for January through November 2020 (5 points).
- Compute the company’s average monthly rent expense for January through May 2020 (5 points).
- If the company purchased all of its office equipment when it first incorporated, for how long has it been in business as of December 31, 2020? (5 points).
- Using the financial statements prepared in part b., evaluate the company´s (i) profitability, (ii) liquidity, and (iii) solvency. (15 points).
Rubrics
| Descriptor | |
| 9-10 | The student demonstrates an excellent understanding of the concepts. |
| 8-8.9 | The student demonstrates a good understanding of the concepts. |
| 7-7.9 | The student demonstrates a fair understanding of the concepts. |
| 6-6.9 | The student demonstrates some, but insufficient understanding of the concepts. |
| 3-5.9 | The student demonstrates insufficient understanding of the concepts. They may mention some relevant ideas or concepts, although it is clear that the relationship between them is not understood by the student. |
| 1-2.9 | The student demonstrates insufficient understanding of the concepts and does not mention any relevant ideas or concepts. |
| 0 | The student leaves the question blank or cheats. |
95% of the grade based on the approach, calculations and comments, and 5% based on the presentation and look & field of the spreadsheet.
Points are at the end of each question.
