Assignment 1
Task
Complete all four (4) questions below.
Question 1
Ethics
As the chief financial officer of Toys For U Pty Ltd, you discover a significant misstatement that has overstated assets and understated expenses in this year's financial statements. The misleading financial statements are contained in the company's annual report, which is about to be issued to shareholders, banks, creditors and other users. After much consideration you decide to advise the director Jack Lack about the misstatement. Jack advises 'what they don't know won't hurt them; we'll just fix it up in next year's statements, which will work well as we are expecting a large profit in that year'.
Required:
In no more than 200 words answer the following:
(a) Who are the stakeholders in this situation?
(b) What are the ethical issues?
(c) What would you do as the chief financial officer?
Question 2
Forms of Business Entities
Presented below are four independent situations.
a) Michael, Alex and Miranda have all graduated with business degrees. Each has specialised in a different area, Accounting, Marketing and IT. They wish to combine their skills and create a new business focusing on business mentoring.
b) William has been in business as a sole trader for many years and has built up a substantial client base. William's profits have increased to over $300,000 over the last financial year. He would like to expand the business but will need to borrow a large sum from the bank.
c) Wendy has graduated from university and would like to start up her own events management business. Wendy has a small amount of savings and has been offered a few positions from established business's but would like to try it on her own as she would prefer to maintain control over the business.
d) Jill and Joan are both stay at home mothers who have been making jewellery and selling it at the local market. The jewellery has become quite popular and the ladies have been approached by a local jewellery chain to stock some of their pieces. Both women would like to expand the business and feel they could also handle a website to sell their jewellery online.
Required:
In each case explain what form of entity the business is likely to take- sole ownership, partnership or company. Give reasons to support your choice.
Question 3
The use of financial statements
Financial decisions often place heavier emphasis on one type of financial statement over the others. Consider each of the following hypothetical situations independently.
(a) The accountant of a company is trying to determine whether the company is generating enough cash to increase the amount of dividends paid to investors and still have enough money for a much needed office refurbishment.
(b) An investor is planning on purchasing shares in Myer. The investor plans to hold the investment for at least 5 years.
(c) Big Bank is considering extending a loan to a small local company. The company would be required to make interest payments at the end of each year for 10 years and to repay the loan at the end of the 10th year.
(d) West Wing Ltd is considering extending credit to a new customer. The terms of the credit would require the customer to pay within 60 days of receipt of goods.
Required:
For each situation, state whether the decision maker would be most likely to place the main emphasis on information provided by the income statement, statement of financial position or statement of cash flows. Include a brief justification for each choice.
Note: Although the decision makers should refer to all financial statements, you should choose only one financial statement in each case.
Question 4.
Financial statements and Analysing business transactions
Bob runs a pest spraying business called Bob's Pest Spraying. His Statement of financial position as at 31st March 2014 is as follows:
|
Assets
|
$
|
Liabilities
|
$
|
|
Cash at bank
|
15,000
|
Bank loan on Equipment
|
20,000
|
|
Accounts Receivable
|
1,500
|
Owners Equity
|
|
|
Motor Vehicle
|
35,000
|
Capital
|
56,500
|
|
Equipment
|
25,000
|
|
|
|
|
76,500
|
|
76,500
|
Bob's Pest Spraying had the following transactions in the month of April 2014.
|
April
|
Transaction Detail
|
$
|
|
5
|
Sprayed a large warehouse for a local business. The business paid in cash for this service.
|
2,500
|
|
6
|
St Joseph's school paid their outstanding account for Spraying in March.
|
1,500
|
|
10
|
Bob paid monthly loan repayment on equipment. (Includes $75 Interest)
|
500
|
|
10
|
Sprayed local council chambers for termites. Received cash.
|
2,300
|
|
15
|
Bob paid the following monthly expenses in cash
Telephone
Electricity
Rent
|
89
350
850
|
|
20
|
Purchased new generator for spraying
|
2,500
|
|
25th
|
Invoiced M Smith for April house Spraying
|
950
|
|
30th
|
Bob withdrew money for a holiday to Bali
|
3,000
|
Required:
Part A:
1. Identify the business transactions for Bob's Pest Spraying for April and construct an accounting worksheet using excel. Illustrative example 3.2 on the bottom of pg 62 of the text should be used as a guide to the format required.
2. In your worksheet you must demonstrate the use of the following excel functions.
- 'Sum'
- Bordering
- Cell merging
- Wrap Text
3. For guidance on using excel functions and features required for this assignment please refer to the excel tutorials located in your online study guide on the ACC100 interact site
Part B:
1. Using the accounting worksheet from Part A. Prepare the following for Bob's Pest Spraying for the month of April:
- Income statement.
- Statement of financial position.
- Statement of changes in equity
2. Illustrative example 3.2 on the top of pg 63 of the text should be used as a guide to the format required.
3. In your financial statements you must demonstrate the use of the following excel functions.
- 'SUM' '+/-'
- Bordering
- Cell merging
- Wrap text