During the year ended 30 June 2014, TooBakko Ltd sold each unit of its goods at $9. Purchases and sales of the goods are shown below. Ignore GST. 2013 July 1 Inventory on hand 200 units @ $5.00 each 30 Sales 120 units Aug. 25 Purchases 300 @ $5.25 30 Sales 250 units Sept. 3 Purchases 450 units @ $5.30 10 Purchases returns 50 damaged units from 3 September purchase 30 Sales 300 units Oct. 5 Purchases 300 units § $5.40 Dec. 8 Purchases 250 units at $5.45 11 Sales 500 units 2014 Feb. 21 Purchases 150 units @ $5.50 Marc 18 Purchases 100 units at $5.60 April 30 Sales 300 units May 2 Sales returns 30 unitsfrom 30 April sales,…Details
Accounting Information System – Excel Assignment (Simple Contracts Ltd, a public company specialising in contract labour force)
Assessment Information Subject Code: CISM4000 Subject Name: Accounting Information Systems Assessment Title: Excel Assignment Learning Outcome 5: Develop practical skills in using excel spreadsheets to collate, manage and present accounting information to users in an acceptable format. Introduction to the individual assignment: This assignment must be completed using Microsoft Excel. These introductory excel skills you learn will be used in later units and in your professional life. Employers expect students to have good worksheet skills. BUSINESS SCHOOL AUSTRALIA QUESTION 1 The following employees work for Simple Contracts Ltd, a public company specialising in contract labour force for different projects in construction industry. The employees are paid an hourly rate, based on…Details
QUESTION 1 Richard Reid commenced business as an architect trading as Archi-pro. He has provided the first month’s business transactions for July 2017. July 3 Invested $120,000 of his own funds into a business bank account and took out a personal loan for $30,000, also deposited into the business account. 4 Purchased business premises located in Hawthorn for $450,000. Richard paid a 10% deposit and the balance was financed through a mortgage with Jaz Finance Corporation at 6% per annum interest. 5 Richard purchased architectural equipment for $15,000 cash. $3,600 was paid to Design Australia for six months database subscription. Office supplies was purchased for $800 on 30 day credit terms 6 Office equipment was acquired for $4,000 cash. Paid $3,600…Details
Scenario 2 Property, Plant and Equipment ChiHerbal Ltd had the following information regarding its equipment as at 30 June 2015: Equipment (at cost) $520,000 Accumulated depreciation 150,000 370,000 The equipment consisted of two machines, Machine A and Machine B. Machine A had cost $310 000 and had a carrying amount of $190 000 at 30 June 2015, and Machine B had cost $210 000 and was carried at $180 000. Both machines are measured using the cost model, and depreciated on a straight-line basis over a 10-year period. On 31 December 2015, the company’s directors decided to change the basis of measuring the equipment from the cost model to the revaluation model. Machine A was revalued to $190 000 with…Details
Background Adrenaline Junkies Rafting (AJR) is a local provider of white-water rafting trips. AJR has been in business for five years and is a sole proprietorship. The owner, Bill Flip, has asked you to take on the responsibility of maintaining the business books. Project Instructions Open T accounts for all of the accounts on the May 31, 20xx trial balance. Post the June transactions and adjusting entries to the T accounts. Prepare an adjusted trial balance after you have posted all of the transactions. Prepare an income statement and balance sheet for the month ended June 30, 20xx. Submission Instructions Submit the adjusted trial balance, income statement and balance sheet you have prepared on either MS Excel or MS Word or…Details
On 1 July 2016, Yoshi Ltd acquired 70% of the share capital of Wario Ltd for $210,000. At thisdate, the equity of Wario Ltd consisted of: $Share capital 170,000 General reserve 30,000 Retained earnings 50,000 At the date of acquisition all assets and liabilities of Wario Ltd were carried in their accountingrecords at fair values with the exception of a block of land with the fair value being $25,000above the carrying amount. Additional information: (a)On 1 January 2017, Wario Ltd purchased inventory from Yoshi Ltd for $20,000 at amark-up of 25%. By 30 June 2017, Wario Ltd still held inventory that it had bought fromYoshi Ltd for $8,000. (b)The transfer to the general reserve by Wario Ltd during the year was from post-acquisition retained…Details
Taps and Plumbing Supplies (TaPS) The case scenario The Taps and Plumbing Supplies (TaPS) business began as a brass and iron foundry, before moving to manufacturing taps. Today, TaPS is one of Auckland’s established supplier of tapware. Taps and Plumbing Supplies (TaPS) manufactures two models of bathroom taps at their Panmure plant. The plant has two production departments – machining and assembly. Two models of taps are manufactured – a basic and a premier model. The premier model was introduced in 1998 and it has proved to be both popular and profitable. In 2012 it accounted for 40% of the total units sold and over 50% of the company’s profit. These statistics are shown in the 2012…Details
ACCT19060 T1 2017 Assessment task 2: Part B — Assignment Due date: Monday of Week 9 [11:45pm [AEST] 8 May 2017] ASSESSMENT Weighting: 20% 2 Objectives This assessment item relates to the unit learning outcomes 3 and 5. Details and instructions This is the second part of assessment task 2. Similar to Part A, you can choose to do Part B either as an individual or you can pair up with another student currently enrolled in the unit. This student may be the same student you paired up for Part A or can be a different student. For administration purposes, you must email the Unit Coordinator (UC) if you intend to work in a pair by 4pm on Monday 1…Details
The comparative statement of financial position and statement of profit or loss of HUSKY Ltd for the year ended 30 June 2017 are as follows: HUSKY Ltd Statement of Financial Position as at 30 June 2017 2017 2016 Current assets Cash at bank $ 402 000 $ 70 000 Cash deposits (30-day) 80 000 30 000 Accounts receivable 181 000 75 000 Allowance for doubtful debts (10 000) (5 000) Interest receivable 5 000 3 000 Inventories 146 000 200 000 Prepayments 4 000 7 000 808 000 380 000 Non-current assets Land 120 000 100 000 Plant 710 000 600 000 Accumulated depreciation (190 000) (140 000) Investment in associate 97 000 80 000 Brand names 90 000…Details
Accounting Corporate and Reporting – Zack Ltd acquired all the issued shares (ex div.) of William Ltd for $227 500
Trimester 1, 2017 Assignment ACC705 Accounting Corporate and Reporting Question 1 Consolidation worksheet entries On 1 July 2015, Zack Ltd acquired all the issued shares (ex div.) of William Ltd for $227 500. At this date the equity of William Ltd consisted of: Share capital $ 150 000 General reserve 34 000 Retained earnings 20 000 At acquisition date, William Ltd reported a dividend payable of $8000. All the identifiable assets and liabilities of William Ltd were recorded at amounts equal to their fair values except for: Carrying amount Fair value Plant (cost $200 000) $175 000 …Details
Please provide answers to the following problems using Excel. For your Excel answer, please follow the Excel format and functions presented in Chapter 5 of the textbook. Suppose today is July 1, 2010, and you deposit KD 3,000 into an account today. Then you deposit KD 1,500 into the same account each July 1, beginning in 2011 and continuing until the last KD 1,500 deposit is made on July 1, 2016. Also, assume you withdraw KD 5,000 on July 1, 2018. Assuming a 7% annual compound interest rate, what will be the balance in the account at the end of July 1, 2020? (hint: find the present value for CFs then the future value for lump sum) Sara is…Details
Given the profit loss (income statement) and balance sheet for Sam’s Sandwich Delivery (Table 4-8), answer the following:
- Calculate the following ratios: current, quick, accounts receivable turnover, fixed asset turnover.
- Using the inventory figure on the balance sheet as average inventory, calculate the inventory turnover ratio.
- Calculate the debt-to-equity ratio, debt-to-total asset ratio, and operating profit margin ratio.
- Perform a vertical analysis of the income statement.
- Perform a vertical analysis of the balance sheet.