Accounting

The unqualified accountant of Sizbiz Trading, Fife Le Bonbon has produced a set of financial statements for the year ended 30 June 2015. These are contained in the excel file “Assignment 1 Appendix A”  in the Material for Assignment 1 folder. The Managing Director of Sizbiz, Mr Fred Wardo thinks the statements are overly optimistic but, as he doesn’t know much about Accounting, he asks you to go through the financial records and see if the statements do make sense.

After a thorough examination of the financial records, you have come across the following anomalies:

a)    The annual insurance premium paid was $36,000 for the year ended 31 August 2015 so two months ($6,000) are prepaid, but this hasn’t been adjusted for.

b)    Mr Wardo is a vintage car enthusiast and his personal 1955 Buick was restored by Classic Carers. Sizbiz paid $9,000 to Classic Carers and Fifi entered the amount as Vehicle Expenses. Fifi says Mr Wardo works so hard that he deserves some reward.

c)    You are surprised to see Frowd Enterprises on the list of Accounts Receivable as at 30 June 2015 with a balance of $21,000. Frowd Enterprises achieved a lot of publicity in March 2015 when Mr Frowd went missing and the company was declared bankrupt. Unsecured creditors (of which Sizbiz is one) were told they would receive nothing. When you ask Fifi about this, she says she is an optimist and who knows, Interpol may catch up with Mr Frowd and make him pay the money back.

d)    When you ask why the depreciation expense has dropped significantly, Fifi explains that no depreciation expense was charged on “Equipment” this year. Unlike cars and furniture which are bought on the open market, the equipment is specialised and replacing it would cost a lot of money. (The equipment originally cost $110,000 with an estimated useful life of five years and a residual value of $10,000. Sizbiz uses the straight line method of depreciation.)

e)    Sizbiz operates the periodic inventory system. A shipment of widgets which cost $32,000 was received into the warehouse at Sizbiz on 25 June (and was included in the stock count). As yet no payment has been made for this shipment nor has an invoice been received. When you question Fifi on this, she says “don’t worry about it. We will pay it when the invoice is received but I have decided to ignore it till then so there won’t be pressure on our cash flow”.

Required:

1.    For the points a) to e) above, on the financial statements in the Excel file “Assignment 1 Appendix A”, make the required adjustments in the column “Adjustments” and then enter the revised amounts in the “Revised” column. An example has been entered for you. An invoice for advertising incurred prior to 20 June 2015 was not entered. To correct this, Advertising expense has been increased by $5,000 and Accounts Payable has also been increased by $5,000.

If there is no adjustment required, simply enter the original amount in the “Revised” column so that you may complete the revised financial statements.
(15 marks)

2.    Prepare a report for Mr Fred Wardo following the structure outlined in the Assessment Guide.

(i)    For each of the adjustments a) to e) explain why you have made them and justify your adjustment by reference to basic accounting concepts and generally accepted accounting practices. Each of the adjustments should be used as a heading in your report.
(27 marks)

(ii)    Evaluate the revised profitability of Sizbiz, given that the industry average percentages are 48% for Gross Profit and 8% for Net Profit. Head this “Evaluation of Profitability”.
(6 marks)

3.    Written Communication:
Communication of ideas, report structure and referencing.                         (12 marks)

[Total: 60 marks]

Assignment Instructions and Information follow.

ASSIGNMENT ONE INSTRUCTIONS AND INFORMATION

How to Approach this Assignment

•    Please read the assignment brief and all instructions before starting the assignment.
•    To complete the assignment you need access to a computer and a word processing package.
•    You should first study the relevant material in the text and make sure you understand the concepts covered.

Completion of the assignment

Complete the report in a Word document file. Instructions for preparing a report are given in the Assessment Guide. http://stream.massey.ac.nz/mod/book/view.php?id=1424529&chapterid=430489

Complete “Assignment 1 Appendix A” excel file. When it is complete, copy and paste the Appendix into your word file, at the end of your report.

To answer this assignment you should look beyond the set readings and text. Looking outside your text will enhance your answers and earn extra marks.

Please acknowledge all sources used. For information on referencing refer to the Massey University Online Writing and Learning Link: http://owll.massey.ac.nz

Your report should range from 800 to 1,000 words. Appendix A and your references are not included in the word count. The marker reserves the right to decline to mark answers over 1,200 words.

Assignment Queries

Please feel free to keep in touch with the 115.102 team regarding this assignment, preferably through the forums. That way all students benefit and often we have found that the best way of learning is through discussion with your peers as well as teaching staff.

Please note that this assignment is at individual, not group level. Discussion is fine but do not post your answers to the assignment on STREAM through discussion forums or other methods, as that will lead to penalties. If you are uncertain of how much you can share, please contact the teaching staff. Sharing answers can lead to penalties for all involved, not just the copier.

There are a large number of students in this paper, but that does not mean that you are not each individually very important to us. We value each student and will try to provide appropriate guidance to the best of our ability.

Naming Convention and Backups.

Once you have started working on the assignment you should make backups.
It pays to rename different versions of your work.  A simple way to do this is to use the Save as file instruction and add a number or letter to the end of the file name.  (This allows you to go back to an earlier version.)

Use the following naming convention for the file that you are submitting: use
your Last Name Student ID number as the name of the file [Do not change the file extension or you (and the marker) will not be able to use the file].  For example, if your Last Name is Smith and your Student ID number is 88888888, your file will be smith88888888.doc.

Submission of the Assignment (Uploading your file to Stream)

To access the submission points you must have completed the Honesty Declaration Quiz. The submission point for Assignment 1 is under “Activities which are Assessed”.
a.    In the “Activities which are Assessed’ section on Stream click on “Assignment 1 Submission Point”.
b.    A box with Submission Draft and no files uploaded yet will appear with Upload a file at the bottom of the page. Click on Upload a file.
c.    Depending on your version of internet software you may be able to drag and drop the file from your computer to stream. If not, click on Add, then Upload the file, then click Browse,  click on the file you wish to upload, then on Open, then on Upload this file. You will now see your uploaded file showing on the left side of the page.
d.    Click Save changes.  The submission is shown as Submission draft.
e.    When you are satisfied that the correct file has been uploaded, click on Send for Marking under the heading Final submission for assignment marking. The screen will then show the following message: Once the assignment is sent for marking, you will no longer be able to delete or attach file(s). Do you want to continue? You can then choose Cancel or Continue?
f.    Late submissions will be accepted by the system after the due date for a week only.  For the purpose of determining if electronic assignments are handed in on time, STREAM records the submission date and time. See the Assessment Guide for policies re extensions and late submissions. Penalties will be applied to submissions received after the due date for which an extension has not been granted.

Accounting

The unqualified accountant of Sizbiz Trading, Fife Le Bonbon has produced a set of financial statements for the year ended 30 June 2015. These are contained in the excel file “Assignment 1 Appendix A”  in the Material for Assignment 1 folder. The Managing Director of Sizbiz, Mr Fred Wardo thinks the statements are overly optimistic but, as he doesn’t know much about Accounting, he asks you to go through the financial records and see if the statements do make sense.

After a thorough examination of the financial records, you have come across the following anomalies:

a)    The annual insurance premium paid was $36,000 for the year ended 31 August 2015 so two months ($6,000) are prepaid, but this hasn’t been adjusted for.

b)    Mr Wardo is a vintage car enthusiast and his personal 1955 Buick was restored by Classic Carers. Sizbiz paid $9,000 to Classic Carers and Fifi entered the amount as Vehicle Expenses. Fifi says Mr Wardo works so hard that he deserves some reward.

c)    You are surprised to see Frowd Enterprises on the list of Accounts Receivable as at 30 June 2015 with a balance of $21,000. Frowd Enterprises achieved a lot of publicity in March 2015 when Mr Frowd went missing and the company was declared bankrupt. Unsecured creditors (of which Sizbiz is one) were told they would receive nothing. When you ask Fifi about this, she says she is an optimist and who knows, Interpol may catch up with Mr Frowd and make him pay the money back.

d)    When you ask why the depreciation expense has dropped significantly, Fifi explains that no depreciation expense was charged on “Equipment” this year. Unlike cars and furniture which are bought on the open market, the equipment is specialised and replacing it would cost a lot of money. (The equipment originally cost $110,000 with an estimated useful life of five years and a residual value of $10,000. Sizbiz uses the straight line method of depreciation.)

e)    Sizbiz operates the periodic inventory system. A shipment of widgets which cost $32,000 was received into the warehouse at Sizbiz on 25 June (and was included in the stock count). As yet no payment has been made for this shipment nor has an invoice been received. When you question Fifi on this, she says “don’t worry about it. We will pay it when the invoice is received but I have decided to ignore it till then so there won’t be pressure on our cash flow”.

Required:

1.    For the points a) to e) above, on the financial statements in the Excel file “Assignment 1 Appendix A”, make the required adjustments in the column “Adjustments” and then enter the revised amounts in the “Revised” column. An example has been entered for you. An invoice for advertising incurred prior to 20 June 2015 was not entered. To correct this, Advertising expense has been increased by $5,000 and Accounts Payable has also been increased by $5,000.

If there is no adjustment required, simply enter the original amount in the “Revised” column so that you may complete the revised financial statements.
(15 marks)

2.    Prepare a report for Mr Fred Wardo following the structure outlined in the Assessment Guide.

(i)    For each of the adjustments a) to e) explain why you have made them and justify your adjustment by reference to basic accounting concepts and generally accepted accounting practices. Each of the adjustments should be used as a heading in your report.
(27 marks)

(ii)    Evaluate the revised profitability of Sizbiz, given that the industry average percentages are 48% for Gross Profit and 8% for Net Profit. Head this “Evaluation of Profitability”.
(6 marks)

3.    Written Communication:
Communication of ideas, report structure and referencing.                         (12 marks)

[Total: 60 marks]

Assignment Instructions and Information follow.

ASSIGNMENT ONE INSTRUCTIONS AND INFORMATION

How to Approach this Assignment

•    Please read the assignment brief and all instructions before starting the assignment.
•    To complete the assignment you need access to a computer and a word processing package.
•    You should first study the relevant material in the text and make sure you understand the concepts covered.

Completion of the assignment

Complete the report in a Word document file. Instructions for preparing a report are given in the Assessment Guide. http://stream.massey.ac.nz/mod/book/view.php?id=1424529&chapterid=430489

Complete “Assignment 1 Appendix A” excel file. When it is complete, copy and paste the Appendix into your word file, at the end of your report.

To answer this assignment you should look beyond the set readings and text. Looking outside your text will enhance your answers and earn extra marks.

Please acknowledge all sources used. For information on referencing refer to the Massey University Online Writing and Learning Link: http://owll.massey.ac.nz

Your report should range from 800 to 1,000 words. Appendix A and your references are not included in the word count. The marker reserves the right to decline to mark answers over 1,200 words.

Assignment Queries

Please feel free to keep in touch with the 115.102 team regarding this assignment, preferably through the forums. That way all students benefit and often we have found that the best way of learning is through discussion with your peers as well as teaching staff.

Please note that this assignment is at individual, not group level. Discussion is fine but do not post your answers to the assignment on STREAM through discussion forums or other methods, as that will lead to penalties. If you are uncertain of how much you can share, please contact the teaching staff. Sharing answers can lead to penalties for all involved, not just the copier.

There are a large number of students in this paper, but that does not mean that you are not each individually very important to us. We value each student and will try to provide appropriate guidance to the best of our ability.

Naming Convention and Backups.

Once you have started working on the assignment you should make backups.
It pays to rename different versions of your work.  A simple way to do this is to use the Save as file instruction and add a number or letter to the end of the file name.  (This allows you to go back to an earlier version.)

Use the following naming convention for the file that you are submitting: use
your Last Name Student ID number as the name of the file [Do not change the file extension or you (and the marker) will not be able to use the file].  For example, if your Last Name is Smith and your Student ID number is 88888888, your file will be smith88888888.doc.

Submission of the Assignment (Uploading your file to Stream)

To access the submission points you must have completed the Honesty Declaration Quiz. The submission point for Assignment 1 is under “Activities which are Assessed”.
a.    In the “Activities which are Assessed’ section on Stream click on “Assignment 1 Submission Point”.
b.    A box with Submission Draft and no files uploaded yet will appear with Upload a file at the bottom of the page. Click on Upload a file.
c.    Depending on your version of internet software you may be able to drag and drop the file from your computer to stream. If not, click on Add, then Upload the file, then click Browse,  click on the file you wish to upload, then on Open, then on Upload this file. You will now see your uploaded file showing on the left side of the page.
d.    Click Save changes.  The submission is shown as Submission draft.
e.    When you are satisfied that the correct file has been uploaded, click on Send for Marking under the heading Final submission for assignment marking. The screen will then show the following message: Once the assignment is sent for marking, you will no longer be able to delete or attach file(s). Do you want to continue? You can then choose Cancel or Continue?
f.    Late submissions will be accepted by the system after the due date for a week only.  For the purpose of determining if electronic assignments are handed in on time, STREAM records the submission date and time. See the Assessment Guide for policies re extensions and late submissions. Penalties will be applied to submissions received after the due date for which an extension has not been granted.