Due date/submission: Week 11- Friday 8 October 2021 by 11:59 pm.
1. The assignment is a compulsory Individual assignment and is worth 30% of the marks of the subject.
2. The cover page must have the student name and ID number.
3. The assignment must be in MS word format, double-spacing and 12-pt Times New Roman font.
4. Submissions must be properly referenced.
5. Plagiarism is a serious academic misconduct. Students involved in plagiarism will be referred to the college’s appropriate authority.
6. Maximum Similarity: 30%
7. Late submission will attract penalty: Refer to GBC POLICY
Question 1: Case study/analysis question (10 marks)
Complete the requirements below using the most recent financial statements available on Westfarmers website.
Obtain the statements on the Internet by following the steps below. (The formatting of the company’s website may have changed since these instructions were written.)
1. Go to https://www.wesfarmers.com.au/
.
2. Click on the “Annual Report” link.
3. Go to the company’s financial statements.
Required
a. What was the company’s net income in each of the last three years?
b. What amount of total assets did the company have at the end of the most recent year?
c. How much retained earnings did the company have at the end of the most recent year?
d. For the most recent year, what was the company’s cash flow from operating activities, cash flow from investing activities, and cash flow from financing activities?
e. Because of the diversity of users, their different levels of knowledge, the varying information needs for particular decisions, and the general nature of financial statements, a variety of analysis techniques have been developed.
1. Explain the ratio method of analysis and how this technique appears to provide the most relevant information in a given situation in terms of the users, objectives, decisions and outcomes of the selected ratios.
2. Discuss and calculate 4 ratios of your choice based on data extracted from the financial statements. Briefly explain the interpretation of the result.
Question 2: Critical Analysis questions (5 Marks)
Jemma Swanson was a trustworthy employee of Blue Trust Bank. She was involved in everything. She worked as a teller, accounted for the cash at the other teller windows, and recorded many of the transactions in the accounting records. She was so loyal that she never took a day off, even when very sick. She routinely worked late to see that all the day’s work was posted into the accounting records, and never took a day’s vacation because they might need her at the bank.
Aron and Sarah, CPAs, were hired to perform an audit, the first complete audit that had been done in several years. Johnson seemed somewhat upset by the upcoming audit, saying that everything had been properly accounted for and that the audit was a needless expense. When Aron and Sarah examined some of the bank’s internal control procedures, the firm discovered problems. In fact, as the audit progressed, it became apparent that a large amount of cash was missing. Numerous adjustments had been made to customer accounts with credit memorandums, and many of the transactions had been posted several days late. In addition, there were numerous cash payments for “office expenses.”
When the audit was complete, it was determined that more than $100,000 of funds was missing or improperly accounted for. All fingers pointed to Swanson. The bank’s president, who was a close friend of Swanson, was bewildered. How could this type of thing happen at this bank?
Required
Prepare a written memo to the bank president, outlining the procedures that should be followed to prevent this type of problem in the future.
Question 3: Problem question (15 Marks)
The trial balance of Ripple Security Services Ltd. as of January 1, Year 11, had the following normal balances:
Cash $ 113,718
Petty cash 100
Accounts receivable 39,390
Allowance for doubtful accounts 4,662
Supplies 210
Merchandise inventory (48 @ $300) 14,400
Equipment 9,000
Van 27,000
Building 125,000
Accumulated depreciation 28,075
Land 25,000
Sales tax payable 390
Employee income tax payable 1,000
FICA—Social Security tax payable 840
FICA—Medicare tax payable 210
Warranty payable 918
Unemployment tax payable 945
Notes payable—Building 92,762
Bonds payable 50,000
Discount on bonds payable 800
Common stock 50,000
Retained earnings 124,816
During Year 11, Ripple Security Services experienced the following transactions:
1. Paid the sales tax payable from Year 10.
2. Paid the balance of the payroll liabilities due for Year 10 (federal income tax, FICA taxes, and unemployment taxes).
3. Issued 5,000 additional shares of the $5 par value common stock for $8 per share and 1,000 shares of $50 stated value, 5 percent cumulative preferred stock for $52 per share.
4. Purchased $500 of supplies on account.
5. Purchased 190 alarm systems at a cost of $310. Cash was paid for the purchase.
6. After numerous attempts to collect from customers, wrote off $3,670 of uncollectible accounts receivable.
7. Sold 210 alarm systems for $600 each plus sales tax of 5 percent. All sales were on account. (Be sure to compute cost of goods sold using the FIFO cost flow method.)
8. Billed $125,000 of monitoring services for the year. Credit card sales amounted to $58,000, and the credit card company charged a 4 percent fee. The remaining $67,000 were sales on account. Sales tax is not charged on this service.
9. Replenished the petty cash fund on June 30. The fund had $10 cash and receipts of $75 for yard mowing and $15 for office supplies expense.
10. Collected the amount due from the credit card company.
11. Paid the sales tax collected on $105,000 of the alarm sales.
12. Collected $198,000 of accounts receivable during the year.
13. Paid installers and other employees a total of $96,000 for salaries for the year. Assume the Social Security tax rate is 6 percent and the Medicare tax rate is 1.5 percent. Federal income taxes withheld amounted to $10,600. No employee exceeded $127,200 in total wages. The net salaries were paid in cash.
14. On October 1, declared a dividend on the preferred stock and a $1 per share dividend on the common stock to be paid to shareholders of record on October 15, payable on November 1, Year 11.
15. Paid $1,625 in warranty repairs during the year.
16. On November 1, Year 11, paid the dividends that had been previously declared.
17. Paid $18,500 of advertising expense during the year.
18. Paid $6,100 of utilities expense for the year.
19. Paid the payroll liabilities, both the amounts withheld from the salaries plus the employer share of Social Security tax and Medicare tax, on $88,000 of the salaries plus $9,200 of the federal income tax that was withheld.
20. Paid the accounts payable.
21. Paid bond interest and amortized the discount. The bond was issued in Year 10 and pays interest at 6 percent.
22. Paid the annual installment of $14,238 on the amortized note. The interest rate for the note is 7 percent.
Adjustments
23. There was $190 of supplies on hand at the end of the year.
24. Recognized the uncollectible accounts expense for the year using the allowance method. Ripple now estimates that 1 percent of sales on account will not be collected.
25. Recognized depreciation expense on the equipment, van, and building. The equipment, purchased in Year 8, has a 5-year life and a $2,000 salvage value. The van has a 4-year life and a $6,000 salvage value. The building has a 40-year life and a $10,000 salvage value. The company uses straight-line for the equipment and the building. The van is fully depreciated.
26. The alarm systems sold in transaction 7 were covered with a one-year warranty. Ripple estimated that the warranty cost would be 2 percent of alarm sales.
27. The unemployment tax on the three employees has not been paid. Record the accrued unemployment tax on the salaries for the year. The unemployment tax rate is 4.5 percent and gross wages for all three employees exceeded $7,000.
28. Recognized the employer Social Security and Medicare payroll tax that has not been paid on $8,000 of salaries expense.
Required
a. Record the preceding transactions in general journal form. Round all amounts to the nearest whole dollar.
b. Post the transactions to the T-accounts.
c. Prepare a trial balance.
d. Prepare an income statement, a balance sheet, and a statement of cash flows.
e. Close the temporary accounts to retained earnings.
f. Post the closing entries to the T-accounts and prepare a post-closing trial balance.
