Erskine Consulting Ltd. has been in business for several years,providing software consulting to its customers on an annualcontract or special assignment basis. All work is done over theInternet, although some travel is occasionally required for meetingwith customers to negotiate contracts and renewals of contracts, aswell as resolving possible disputes in invoicing for theirservices. Erskine operates out of rented premises and has a modestinvestment in equipment that is used by the consulting team.Erskine is a private company that follows ASPE and that has acalendar year end.
At the end of each year, Erskine obtains the services of anaccountant to complete the annual accounting cycle of the businessand prepare any year-end adjusting of journal entries, financialstatements, and corporate tax returns.
Upon arrival in early 2018, the accountant was given anunadjusted trial balance and obtained the following additionalinformation to complete his work.
ERSKINE CONSULTING LTD. Unadjusted Trial Balance December 31, 2017 |
---|
Account | Debit | Credit |
Petty cash | $ 600 | |
Cash | 18,500 | |
Accounts receivable | 44,700 | |
Allowance for doubtful accounts | | 1,800 |
Interest receivable | 0 | |
Prepaid insurance | 4,000 | |
Supplies | 2,000 | |
FV-NI investments | 20,000 | |
Notes receivable | 25,000 | |
Equipment | 94,000 | |
Accumulated depreciation—equipment | | 36,000 |
Goodwill | 22,000 | |
Bank loans | | 18,000 |
Accounts payable | | 7,950 |
Salaries and wages payable | | 0 |
Accrued liabilities | | 0 |
Unearned revenue | | 4,200 |
Litigation liability | | 0 |
Income tax payable | 30,000 | |
Common shares | | 36,000 |
Retained earnings | | 59,800 |
Dividends | 26,000 | |
Service revenue | | 242,768 |
Interest revenue | | 1,042 |
Unrealized gain or loss—FV-NI | | 0 |
Gain on disposal of equipment | | 300 |
Depreciation expense | 0 | |
Office expense | 4,100 | |
Travel expense | 6,700 | |
Insurance expense | 900 | |
Interest expense | 1,300 | |
Utilities expense | 750 | |
Rent expense | 54,000 | |
Salaries and wages expense | 49,510 | |
Supplies expense | 0 | |
Bad debt expense | 0 | |
Telephone and Internet expense | 3,200 | |
Repairs and maintenance expense | 600 | |
Litigation expense | 0 | |
Income tax expense | 0 | |
| $407,860 | $407,860 |
Additional information:
- 1.Management has been going over the list of accountsreceivable for possible accounts that are not collectible. Oneaccount for $700 must be written off. In the past, 5% of thebalance of all accounts receivable has been the basis of anestimate for the required balance in the allowance for doubtfulaccounts. Management feels that this estimate should be followedfor 2017.
- 2.After doing a count of supplies on hand, managementdetermined that $400 of supplies remained unused at December 31,2017.
- 3.The account balance in Prepaid Insurance of $4,000 representsthe annual cost of the renewal of all of Erskine's insurancepolicies that expire in one year. The policies' coverage startedApril 1, 2017.
- 4.FV-NI Investments are long-term investments. The fair valueof the portfolio of investments was $22,500 at December 31,2017.
- 5.In January 2017, some old equipment was sold for proceeds of$300 cash. The entry made when depositing the cash was debit Cash,credit Gain on Disposal of Equipment. The original cost of theequipment was $4,300 and the accumulated depreciation was$4,200.
- 6.The depreciation expense for the remaining equipment wascalculated to be $7,200 for the 2017 fiscal year.
- 7.The notes receivable from customers are due October 31, 2020,and bear interest at 5%, with interest paid semi-annually. The lastinterest collected related to the notes was for the six monthsended October 31, 2017.
- 8.Bank loans are demand bank loans for working capital needsand vary in amount as the needs arise. The bank advised that theinterest charge for December 2017 that will go though on theJanuary 2018 bank statement is in the amount of $200.
- 9.Unpaid salaries and wages at December 31, 2017, totalled$790. These will be paid as part of the first payroll of 2018.
- 10.After some analysis, management informs the accountant thatthe Unearned Revenue account should have a balance of $1,000.
- 11.Erskine was sued by one of its former clients for $50,000for giving bad advice and instructions. Upon discussion with legalcounsel, it has been agreed that it will likely take $5,000 tosettle this dispute out of court. No entry has yet beenrecorded.
- 12.The accountant is told that a sublet lease arrangement forsome excess office space has been negotiated and signed. It willprovide Erskine with rent revenue starting on February 1, 2018, ata rate of $400 per month.
- 13.Erskine has been making income tax instalments as requiredby the Canada Revenue Agency. All instalment payments have beendebited to the Income Taxes Payable account.
- 14.After recording all of the necessary adjustments and postingto the general ledger, management drafted a new trial balance toarrive at the income before income taxes. Using this result, theaccountant prepared the tax returns, and determined that a tax rateof 28% needed to be applied to the income before income tax amount.The necessary adjusting entry for taxes has not yet beenrecorded.
QUESTIONS:
(a) Prepare all necessary adjusting andcorrecting entries required based on the information given, up toitem 13.
(b) Post the journal entries in adjustmentcolumns and arrive at an adjusted trial balance. Enter the journalentries in the following worksheet format:
| Unadjusted Trial Balance | Adjustments | Adjusted Trial Balance |
Account | Debit | Credit | Debit | Credit | Debit | Credit |
(c) Using the adjusted trial balance columnsof your worksheet, calculate the amount of income before incometaxes. Use the information provided in item 14 to record income taxexpense for the year.
(d) Prepare a single-step statement ofincome, a statement of retained earnings, and a statement offinancial position for 2017.
(e) Calculate the current ratio and thepayout ratio.