Analyze transaction data and financial statement

Assignment Help Other Subject
Reference no: EM132545947

HI5001 Accounting for Business Assignment Help and Solution, Holmes Institute - Assessment Writing Service

Learning Outcome 1. Analyze how various transactions will affect the accounting equation, the balance sheet, and the income statement and communicate this to a range of stakeholders;

Learning Outcome 2. Apply, analyze, synthesize and evaluate information from multiple sources to make decisions about the financial performance of entities including assets, liabilities, owner's equity, revenue and expenses;

Learning Outcome 3. Employ information technologies to analyze transaction data and financial statement to facilitate data-driven decision-making;

Learning Outcome 4. Assess the impact of taxation and other liabilities, relevant legislation and industry codes of practice on business and define management strategies.

Question 1:

Fiona Sporty uses a purchases journal, a cash payments journal, a sales journal, a cash receipts journal and a general journal. Indicate in which journals the following transactions are most likely to be recorded.
1. Purchased inventories on credit.
2. Sales of inventory on credit.
3. Received payment of a customer's account.
4. Payment of monthly rent by cheque.
5. End of period closing entries

Question 2:

Below is information about Lisa Ltd's cash position for the month of June 2019.

1. The general ledger Cash at Bank account had a balance of $21,200 on 31 May.
2. The cash receipts journal showed total cash receipts of $292,704 for June.
3. The cash payments journal showed total cash payments of $265,074 for June.
4. The June bank statement reported a bank balance of $41,184 on 30 June.
5. Outstanding cheques at the end of June were: no. 3456, $1,448; no. 3457, $84; no. 3460, $70 and no. 3462, $410.
6. Cash receipts of $10,090 for 30 June were not included in the June bank statement.
7. Included on the bank statement were:
• a dishonoured cheque written by a client James Ltd, $136
• a credit for an electronic transfer from a customer of $644
• interest earned, $44
• account and transaction fees, $120.

Required

a) Update the cash receipts and cash payments journals by adding the necessary adjustments and calculate the total cash receipts and cash payments for June.
b) Post from cash receipts and cash payments journals to the Cash at Bank ledger account and balance the account.
c) Prepare a bank reconciliation statement at 30 June.
d) What is the amount of cash that should be reported on the 30 June balance sheet?

Question 3:

On 1 June, Mason and Boyce had Accounts Receivable and Allowance for Doubtful Debts accounts as below. Ignore GST.

2103_table.jpg

During June, the following transactions occurred:
1. Revenue earned on credit, $1,195,000.
2. Sales returns, $24,100.
3. Accounts receivable collected, $1,400,000.
4. Accounts written off as uncollectable, $15,851.

Based on an ageing of accounts receivable on 30 June, the firm determined that the Allowance for Doubtful Debts account should have a credit balance of $13,500 on the balance sheet as at 30 June. Ignore GST.

Required

(a) Prepare general journal entries to record the four transactions and to adjust the Allowance for Doubtful Debts account.
(b) Show how accounts receivable and the allowance for doubtful debts would appear on the balance sheet at 30 June.
(c) On 29 June, Kim Ltd, whose $2,400 account had been written off as uncollectable in June, paid its account in full. Prepare journal entries to record the collection.

Question 4:

Tamworth Trading Ltd is a company operating in the retail sector. The beginning inventory of Product EF5089 and information about purchases and sales made during June are shown below.

 

 

 

Units

Unit price $

June

1

Inventory

6,100

2.20

 

4

Purchases

4,600

2.25

 

9

Sales

4,100

 

 

12

Purchases

4,100

2.40

 

21

Sales

6,000

 

 

26

Purchases

3,100

2.50

Tamworth Trading Ltd uses the perpetual inventory system, and all purchases and sales are on credit. Selling price is $5 per unit. A stocktake on 30 June revealed 7700 units in inventory. Ignore GST.

Required

a) Using the FIFO method, prepare an appropriate inventory record for Product EF5089 for June.
b) Prepare an income statement down to the gross profit for Tamworth Trading Ltd for June.

Question 5:

Nevertire Ltd purchased a delivery van costing $52,000. It is expected to have a residual value of $12,000 at the end of its useful life of 4 years or 200,000 kilometres. Ignore GST.

Required

a) Assume the van was purchased on 1 July 2019 and that the accounting period ends on 30 June. Calculate the depreciation expense for the year 2019-20 using each of the following depreciation methods
• straight-line
• diminishing balance (depreciation rate has been calculated as 31%)
• units of production (assume the van was driven 78,000 kilometres during the financial year).
b) Record the adjusting entries for the depreciation at 30 June 2021 using diminishing balance method.
c) Show how the van would appear in the balance sheet prepared at the end of year 2 using Straight-line method.

Attachment:- Accounting for Business Decisions.rar

Reference no: EM132545947

Questions Cloud

Make adjusting entries to be made for the preparation : Make adjusting entries to be made for the preparation of the monthly financial statements as of October 31, 2015
Why an organization would be interested in being ethical : Why an organization would be interested in being ethical, and classify those reasons in terms of whether they represent moral motivation
Prepare journal entry to record north company payroll : On January 15, the end of the first biweekly pay period of the year, Prepare journal entry to record North Company payroll
Explain the impact of convergence of multiple technologies : What technologies are emerging that could be used to solve the problem? What are the costs associated with it? What cost level would be needed
Analyze transaction data and financial statement : Assess the impact of taxation and other liabilities, relevant legislation and industry codes of practice on business and define management strategies
Find an example of two corporate innovations-one brought : Find an example of two corporate innovations-one brought about through autonomous strategic behavior and one developed through induced strategic behavior.
Compute the cost of the ending inventory : Assuming there are 360 units on hand, compute the cost of the ending inventory under the FIFO method and LIFO method. Waterway uses a periodic inventory system
Prepare fund journal entries to summarize the property tax : Prepare fund journal entries to summarize the property tax and grant activity for the fiscal years ending December 31, 2021, and 2022
Make a short customer satisfaction surveys : Explain how core factors, cues to quality, and interpersonal factors of a product influence your buying decisions. Explain with supporting examples.

Reviews

Write a Review

Other Subject Questions & Answers

  What direct effects do these systems have on customers

How do ERP and CRM help a company? What are the drawbacks to setting up those different types of systems in a business? What direct effects do these systems have on customers?

  What are the major sections of a journal article

How might you determine the credibility, reliability, and validity of a source located online? How do you know if information in a source is credible.

  State the selected theory of motivation

Over the decades, numerous theories of motivation have been developed. Most of the older theories have been shown to not be particularly valid.

  Discuss the osha construction standards

What are the four classifications of employers under OSHA is multi employer worksite policy? How do they relate to each other?

  Why does grendel attack heorot

Explore Grendel and Heorot. Write an essay in which you think about how Grendel and Heorot are represented in the poem so far.

  Prepare a description of the agency

Prepare a description of the agency, the population it serves, and the services it provides. Identify the person you are going to interview by title and provide a brief description of this person's duties and/or role in the agency or organization

  How do you create cohesive action plan to increase awareness

Due to the record high chronic absentee rate in our schools, our organization's focus is to reduce the attendance rate. Considering that some school staff.

  What is a star rating

What is a STAR Rating? and What is the purpose and how does it impact the quality in the health care industry.

  How much would the government have to change

How large is the recessionary gap after the fall in planned investment and by how much would the government have to change its purchases to restore the economy to full employment?

  Develop an annotated bibliography to indicate the quality

Reflect: Reflect back on the Week 1 discussion in which you shared with the class the global societal issue that you would like to further address.

  Discuss the project significance on the local system

Impact on systems? Discuss the project's significance on the local system and any findings that may be generalizable to other systems

  What were the main discussion points on the agenda

Were there issues that may have had a different outcome, in your opinion, had there been more involvement by the school principals in your district?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd