ACC1AMD Individual Assignmen

Page 1 of 5
ACC1AMD
Individual Assignment
15 marks total
This assignment will assess your Ethical Behaviour and
Creative Problem-Solving Graduate Capabilities
General information and requirements
This is an individual assignment due in on Sunday 24th May 2020, by 11.59pm.
Assignment Length
Each question provides a guide as to the approximate word length of each answer. It is recommended
you are close to these limits, but you do not need to achieve them exactly.
Please ensure your overall assignment is +/- 10% of the total word limit. Assignments that vary
significantly from these guidelines will be marked down.
Submission
All submissions must be typed in a minimum 11 font, with 1.5 line spacing using WORD saved as a .pdf
file and submitted via the Turnitin link on LMS. You are only able to submit 1 file.
Referencing
All submissions will be reviewed by a program called “Turnitin” and this will identify instances of
plagiarism (copying). This is a very serious offence and can result in you receiving no marks for the
assessment task.
Please ensure if you have copied information you use quotation marks and appropriate referencing.
If you reword someone else’s work, you still need to refer to the author’s in your sentence. For
example, Hines (1991) discusses how……. – whilst this is not a quote you need to reference the idea.
Refer to the “Assignment Presentation Guide” available under the “Assignment” tab for guidance.
This assignment requires you to analyse data. If you copy financial reports from the internet it will be
obvious and no marks will be awarded, even if correctly referenced. The purpose of the assignment is
to develop your analytical skills which are not those of an investment advisor. A small amount of
referenced information will be acceptable.
Late Assignment Penalty
“The standard penalty for late submission of assessment tasks is 5% of the marks for that task for
each delay in submission of a day or partial day up to a maximum of five (5) working days after the
due date.”
Please note: after 5 days your assignment will not be marked.
Page 2 of 5
Presentation
Assignments must be presented in accordance with the “Assignment Presentation Guide” available
under the “Assignment” tab. (1 mark)
Question 1 (2 marks)
Australia Food Ltd is a company with several branches across Victoria and NSW. The Company
produces various food products including meats and milks. You work as a management accountant in
this company.
Your manager has asked one of your colleagues in the management accounting department to
prepare a comparative profit or loss report for the current and previous month. The manager wants
the report to cover only meat production in Victoria’s branches. Your colleague suggests that since
the company has different branches and products, financial statements should cover all of the
company’s activities. He also suggested that the report should be prepared for a financial year in
accordance with accounting standards.
Using your knowledge of financial and managerial accounting, general and specific purpose financial
reports and various users of accounting information, advise your colleague as to the approach they
should adopt to meet the manager’s requirements and ensure the information correctly reflects the
department’s operations.
Your answer needs to be in your own words and correctly referenced to receive full marks.
(200 words)
Page 3 of 5
Question 2 (6 marks)
You have been provided with the unadjusted and adjusted trial balance for Cleaning Services Ltd as of
30 June 2019.
No Account Name Dr ($) Cr ($) Dr ($) Cr ($)
100 Cash 12,450 12,450
110 Accounts Receivable 54,200 62,541
130 Office Supplies 82,730 54,236
140 Prepaid Insurance 13,000 9,789
150 Cleaning Equipment 259,200 259,200
151 Less Accumulated Depreciation –
Cleaning Equipment 103,680 129,600
200 Accounts Payable 12,300 12,300
220 Interest Payable 620
230 Revenue Received in Advance 52,730 40,430
240 Salaries Payable 2,541
250 Bank Loan (10 years term) 19,580 19,580
300 Share Capital 33,412 33,412
310 Retained Earnings 25,231 25,231
311 Dividends 15,000 15,000
400 Service Revenue 256,587 277,228
500 Salaries Expense 53,240 55,781
505 Insurance Expense 3,211
510 Interest Expense 1,200 1,820
520 Depreciation Expense 25,920
530 Supplies Expense 28,494
540 Rent Expense 12,500 12,500
503,520 503,520 540,942 540,942
Cleaning Services Ltd
Trial balance
as at 30 June 2019
Unadjusted Adjusted
Page 4 of 5
Required:
a) Record the unadjusted opening balance of each account in the correct T–account before
recording adjusting entries.
b) Record the adjusting entries in the General Journal using the below format:
Cleaning Services Ltd
General Journal
Date Account (Narration) Post ref Debit $ Credit $
xxx XXX
xxx (hold your CTRL and TAB key to indent) XXX
(Don’t forget your narration).
c) Record the adjusting entries in the correct T-accounts.
d) Balance the T-accounts. (Only use one set of T-accounts for parts a, c and d – if there is only one
entry in the T-account you may balance using double underlines directly under the individual
figures. Once the account has more than 1 figure please use the full balancing process).
e) Prepare an Income Statement, Statement of Changes in Owners’ Equity and a classified
Statement of Financial Position (Balance Sheet) as at 30 June 2019.
NOTE: to maximise your mark you must include correct titles, narrations, dates etc. This is an
assignment, not under exam conditions, therefore attention to detail is expected.
Page 5 of 5
Question 3 (6 marks)
You need to follow the “Assignment Presentation Guide – Company Analysis Guide” available under
the “Assignment” tab.
Select a company that is not a Bank/Financial institution from the Library database and download the
required financial information.
Please note: do not select a Bank or Financial institution as these companies have minimum liquidity
ratios under law and are not as suitable for this activity.
a) Using the downloaded data, complete a Horizontal Analysis of the Profit and Loss, Balance Sheet,
Cash Flow and Ratios for 2018 and 2019. Set the $ movement to “no decimal places” and the %
movement to “2 decimal places” for the statements. When analysing the ratios please use 2
decimal places for both the $ and % movements.
b) Write a brief report, using the horizontal analysis data, individually analysing the Profit and Loss,
Balance Sheet and Cash Flow Statement. This is to be in your own words and not a report copied
from a financial advisor on the internet. Marks will be significantly deducted if it is not in your
own words and work. It is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse. (200 words)
c) Select a minimum of eight ratios, ensuring you include a range of liquidity, profitability and
solvency ratios and analyse the company. Where possible use the ratios we have covered in class.
As in part b above it is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse.
(200 words)
Please note only refer to those ratios that are provided on the “ratios” tab, do not attempt to
calculate them yourself.
d) Ensure you include a screen copy of each of the four tabs with your horizontal analysis within
your report. Where you include them is up to you based on your report presentation (could be in
an appendix).
Remember: You need to upload 1 document with all the assignment answers structured in a
Business Report format. Please follow the presentation guide and save your completed
assignment as a .pdf document to ensure your layout is retained.Page 1 of 5
ACC1AMD
Individual Assignment
15 marks total
This assignment will assess your Ethical Behaviour and
Creative Problem-Solving Graduate Capabilities
General information and requirements
This is an individual assignment due in on Sunday 24th May 2020, by 11.59pm.
Assignment Length
Each question provides a guide as to the approximate word length of each answer. It is recommended
you are close to these limits, but you do not need to achieve them exactly.
Please ensure your overall assignment is +/- 10% of the total word limit. Assignments that vary
significantly from these guidelines will be marked down.
Submission
All submissions must be typed in a minimum 11 font, with 1.5 line spacing using WORD saved as a .pdf
file and submitted via the Turnitin link on LMS. You are only able to submit 1 file.
Referencing
All submissions will be reviewed by a program called “Turnitin” and this will identify instances of
plagiarism (copying). This is a very serious offence and can result in you receiving no marks for the
assessment task.
Please ensure if you have copied information you use quotation marks and appropriate referencing.
If you reword someone else’s work, you still need to refer to the author’s in your sentence. For
example, Hines (1991) discusses how……. – whilst this is not a quote you need to reference the idea.
Refer to the “Assignment Presentation Guide” available under the “Assignment” tab for guidance.
This assignment requires you to analyse data. If you copy financial reports from the internet it will be
obvious and no marks will be awarded, even if correctly referenced. The purpose of the assignment is
to develop your analytical skills which are not those of an investment advisor. A small amount of
referenced information will be acceptable.
Late Assignment Penalty
“The standard penalty for late submission of assessment tasks is 5% of the marks for that task for
each delay in submission of a day or partial day up to a maximum of five (5) working days after the
due date.”
Please note: after 5 days your assignment will not be marked.
Page 2 of 5
Presentation
Assignments must be presented in accordance with the “Assignment Presentation Guide” available
under the “Assignment” tab. (1 mark)
Question 1 (2 marks)
Australia Food Ltd is a company with several branches across Victoria and NSW. The Company
produces various food products including meats and milks. You work as a management accountant in
this company.
Your manager has asked one of your colleagues in the management accounting department to
prepare a comparative profit or loss report for the current and previous month. The manager wants
the report to cover only meat production in Victoria’s branches. Your colleague suggests that since
the company has different branches and products, financial statements should cover all of the
company’s activities. He also suggested that the report should be prepared for a financial year in
accordance with accounting standards.
Using your knowledge of financial and managerial accounting, general and specific purpose financial
reports and various users of accounting information, advise your colleague as to the approach they
should adopt to meet the manager’s requirements and ensure the information correctly reflects the
department’s operations.
Your answer needs to be in your own words and correctly referenced to receive full marks.
(200 words)
Page 3 of 5
Question 2 (6 marks)
You have been provided with the unadjusted and adjusted trial balance for Cleaning Services Ltd as of
30 June 2019.
No Account Name Dr ($) Cr ($) Dr ($) Cr ($)
100 Cash 12,450 12,450
110 Accounts Receivable 54,200 62,541
130 Office Supplies 82,730 54,236
140 Prepaid Insurance 13,000 9,789
150 Cleaning Equipment 259,200 259,200
151 Less Accumulated Depreciation –
Cleaning Equipment 103,680 129,600
200 Accounts Payable 12,300 12,300
220 Interest Payable 620
230 Revenue Received in Advance 52,730 40,430
240 Salaries Payable 2,541
250 Bank Loan (10 years term) 19,580 19,580
300 Share Capital 33,412 33,412
310 Retained Earnings 25,231 25,231
311 Dividends 15,000 15,000
400 Service Revenue 256,587 277,228
500 Salaries Expense 53,240 55,781
505 Insurance Expense 3,211
510 Interest Expense 1,200 1,820
520 Depreciation Expense 25,920
530 Supplies Expense 28,494
540 Rent Expense 12,500 12,500
503,520 503,520 540,942 540,942
Cleaning Services Ltd
Trial balance
as at 30 June 2019
Unadjusted Adjusted
Page 4 of 5
Required:
a) Record the unadjusted opening balance of each account in the correct T–account before
recording adjusting entries.
b) Record the adjusting entries in the General Journal using the below format:
Cleaning Services Ltd
General Journal
Date Account (Narration) Post ref Debit $ Credit $
xxx XXX
xxx (hold your CTRL and TAB key to indent) XXX
(Don’t forget your narration).
c) Record the adjusting entries in the correct T-accounts.
d) Balance the T-accounts. (Only use one set of T-accounts for parts a, c and d – if there is only one
entry in the T-account you may balance using double underlines directly under the individual
figures. Once the account has more than 1 figure please use the full balancing process).
e) Prepare an Income Statement, Statement of Changes in Owners’ Equity and a classified
Statement of Financial Position (Balance Sheet) as at 30 June 2019.
NOTE: to maximise your mark you must include correct titles, narrations, dates etc. This is an
assignment, not under exam conditions, therefore attention to detail is expected.
Page 5 of 5
Question 3 (6 marks)
You need to follow the “Assignment Presentation Guide – Company Analysis Guide” available under
the “Assignment” tab.
Select a company that is not a Bank/Financial institution from the Library database and download the
required financial information.
Please note: do not select a Bank or Financial institution as these companies have minimum liquidity
ratios under law and are not as suitable for this activity.
a) Using the downloaded data, complete a Horizontal Analysis of the Profit and Loss, Balance Sheet,
Cash Flow and Ratios for 2018 and 2019. Set the $ movement to “no decimal places” and the %
movement to “2 decimal places” for the statements. When analysing the ratios please use 2
decimal places for both the $ and % movements.
b) Write a brief report, using the horizontal analysis data, individually analysing the Profit and Loss,
Balance Sheet and Cash Flow Statement. This is to be in your own words and not a report copied
from a financial advisor on the internet. Marks will be significantly deducted if it is not in your
own words and work. It is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse. (200 words)
c) Select a minimum of eight ratios, ensuring you include a range of liquidity, profitability and
solvency ratios and analyse the company. Where possible use the ratios we have covered in class.
As in part b above it is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse.
(200 words)
Please note only refer to those ratios that are provided on the “ratios” tab, do not attempt to
calculate them yourself.
d) Ensure you include a screen copy of each of the four tabs with your horizontal analysis within
your report. Where you include them is up to you based on your report presentation (could be in
an appendix).
Remember: You need to upload 1 document with all the assignment answers structured in a
Business Report format. Please follow the presentation guide and save your completed
assignment as a .pdf document to ensure your layout is retained.Page 1 of 5
ACC1AMD
Individual Assignment
15 marks total
This assignment will assess your Ethical Behaviour and
Creative Problem-Solving Graduate Capabilities
General information and requirements
This is an individual assignment due in on Sunday 24th May 2020, by 11.59pm.
Assignment Length
Each question provides a guide as to the approximate word length of each answer. It is recommended
you are close to these limits, but you do not need to achieve them exactly.
Please ensure your overall assignment is +/- 10% of the total word limit. Assignments that vary
significantly from these guidelines will be marked down.
Submission
All submissions must be typed in a minimum 11 font, with 1.5 line spacing using WORD saved as a .pdf
file and submitted via the Turnitin link on LMS. You are only able to submit 1 file.
Referencing
All submissions will be reviewed by a program called “Turnitin” and this will identify instances of
plagiarism (copying). This is a very serious offence and can result in you receiving no marks for the
assessment task.
Please ensure if you have copied information you use quotation marks and appropriate referencing.
If you reword someone else’s work, you still need to refer to the author’s in your sentence. For
example, Hines (1991) discusses how……. – whilst this is not a quote you need to reference the idea.
Refer to the “Assignment Presentation Guide” available under the “Assignment” tab for guidance.
This assignment requires you to analyse data. If you copy financial reports from the internet it will be
obvious and no marks will be awarded, even if correctly referenced. The purpose of the assignment is
to develop your analytical skills which are not those of an investment advisor. A small amount of
referenced information will be acceptable.
Late Assignment Penalty
“The standard penalty for late submission of assessment tasks is 5% of the marks for that task for
each delay in submission of a day or partial day up to a maximum of five (5) working days after the
due date.”
Please note: after 5 days your assignment will not be marked.
Page 2 of 5
Presentation
Assignments must be presented in accordance with the “Assignment Presentation Guide” available
under the “Assignment” tab. (1 mark)
Question 1 (2 marks)
Australia Food Ltd is a company with several branches across Victoria and NSW. The Company
produces various food products including meats and milks. You work as a management accountant in
this company.
Your manager has asked one of your colleagues in the management accounting department to
prepare a comparative profit or loss report for the current and previous month. The manager wants
the report to cover only meat production in Victoria’s branches. Your colleague suggests that since
the company has different branches and products, financial statements should cover all of the
company’s activities. He also suggested that the report should be prepared for a financial year in
accordance with accounting standards.
Using your knowledge of financial and managerial accounting, general and specific purpose financial
reports and various users of accounting information, advise your colleague as to the approach they
should adopt to meet the manager’s requirements and ensure the information correctly reflects the
department’s operations.
Your answer needs to be in your own words and correctly referenced to receive full marks.
(200 words)
Page 3 of 5
Question 2 (6 marks)
You have been provided with the unadjusted and adjusted trial balance for Cleaning Services Ltd as of
30 June 2019.
No Account Name Dr ($) Cr ($) Dr ($) Cr ($)
100 Cash 12,450 12,450
110 Accounts Receivable 54,200 62,541
130 Office Supplies 82,730 54,236
140 Prepaid Insurance 13,000 9,789
150 Cleaning Equipment 259,200 259,200
151 Less Accumulated Depreciation –
Cleaning Equipment 103,680 129,600
200 Accounts Payable 12,300 12,300
220 Interest Payable 620
230 Revenue Received in Advance 52,730 40,430
240 Salaries Payable 2,541
250 Bank Loan (10 years term) 19,580 19,580
300 Share Capital 33,412 33,412
310 Retained Earnings 25,231 25,231
311 Dividends 15,000 15,000
400 Service Revenue 256,587 277,228
500 Salaries Expense 53,240 55,781
505 Insurance Expense 3,211
510 Interest Expense 1,200 1,820
520 Depreciation Expense 25,920
530 Supplies Expense 28,494
540 Rent Expense 12,500 12,500
503,520 503,520 540,942 540,942
Cleaning Services Ltd
Trial balance
as at 30 June 2019
Unadjusted Adjusted
Page 4 of 5
Required:
a) Record the unadjusted opening balance of each account in the correct T–account before
recording adjusting entries.
b) Record the adjusting entries in the General Journal using the below format:
Cleaning Services Ltd
General Journal
Date Account (Narration) Post ref Debit $ Credit $
xxx XXX
xxx (hold your CTRL and TAB key to indent) XXX
(Don’t forget your narration).
c) Record the adjusting entries in the correct T-accounts.
d) Balance the T-accounts. (Only use one set of T-accounts for parts a, c and d – if there is only one
entry in the T-account you may balance using double underlines directly under the individual
figures. Once the account has more than 1 figure please use the full balancing process).
e) Prepare an Income Statement, Statement of Changes in Owners’ Equity and a classified
Statement of Financial Position (Balance Sheet) as at 30 June 2019.
NOTE: to maximise your mark you must include correct titles, narrations, dates etc. This is an
assignment, not under exam conditions, therefore attention to detail is expected.
Page 5 of 5
Question 3 (6 marks)
You need to follow the “Assignment Presentation Guide – Company Analysis Guide” available under
the “Assignment” tab.
Select a company that is not a Bank/Financial institution from the Library database and download the
required financial information.
Please note: do not select a Bank or Financial institution as these companies have minimum liquidity
ratios under law and are not as suitable for this activity.
a) Using the downloaded data, complete a Horizontal Analysis of the Profit and Loss, Balance Sheet,
Cash Flow and Ratios for 2018 and 2019. Set the $ movement to “no decimal places” and the %
movement to “2 decimal places” for the statements. When analysing the ratios please use 2
decimal places for both the $ and % movements.
b) Write a brief report, using the horizontal analysis data, individually analysing the Profit and Loss,
Balance Sheet and Cash Flow Statement. This is to be in your own words and not a report copied
from a financial advisor on the internet. Marks will be significantly deducted if it is not in your
own words and work. It is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse. (200 words)
c) Select a minimum of eight ratios, ensuring you include a range of liquidity, profitability and
solvency ratios and analyse the company. Where possible use the ratios we have covered in class.
As in part b above it is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse.
(200 words)
Please note only refer to those ratios that are provided on the “ratios” tab, do not attempt to
calculate them yourself.
d) Ensure you include a screen copy of each of the four tabs with your horizontal analysis within
your report. Where you include them is up to you based on your report presentation (could be in
an appendix).
Remember: You need to upload 1 document with all the assignment answers structured in a
Business Report format. Please follow the presentation guide and save your completed
assignment as a .pdf document to ensure your layout is retained.Page 1 of 5
ACC1AMD
Individual Assignment
15 marks total
This assignment will assess your Ethical Behaviour and
Creative Problem-Solving Graduate Capabilities
General information and requirements
This is an individual assignment due in on Sunday 24th May 2020, by 11.59pm.
Assignment Length
Each question provides a guide as to the approximate word length of each answer. It is recommended
you are close to these limits, but you do not need to achieve them exactly.
Please ensure your overall assignment is +/- 10% of the total word limit. Assignments that vary
significantly from these guidelines will be marked down.
Submission
All submissions must be typed in a minimum 11 font, with 1.5 line spacing using WORD saved as a .pdf
file and submitted via the Turnitin link on LMS. You are only able to submit 1 file.
Referencing
All submissions will be reviewed by a program called “Turnitin” and this will identify instances of
plagiarism (copying). This is a very serious offence and can result in you receiving no marks for the
assessment task.
Please ensure if you have copied information you use quotation marks and appropriate referencing.
If you reword someone else’s work, you still need to refer to the author’s in your sentence. For
example, Hines (1991) discusses how……. – whilst this is not a quote you need to reference the idea.
Refer to the “Assignment Presentation Guide” available under the “Assignment” tab for guidance.
This assignment requires you to analyse data. If you copy financial reports from the internet it will be
obvious and no marks will be awarded, even if correctly referenced. The purpose of the assignment is
to develop your analytical skills which are not those of an investment advisor. A small amount of
referenced information will be acceptable.
Late Assignment Penalty
“The standard penalty for late submission of assessment tasks is 5% of the marks for that task for
each delay in submission of a day or partial day up to a maximum of five (5) working days after the
due date.”
Please note: after 5 days your assignment will not be marked.
Page 2 of 5
Presentation
Assignments must be presented in accordance with the “Assignment Presentation Guide” available
under the “Assignment” tab. (1 mark)
Question 1 (2 marks)
Australia Food Ltd is a company with several branches across Victoria and NSW. The Company
produces various food products including meats and milks. You work as a management accountant in
this company.
Your manager has asked one of your colleagues in the management accounting department to
prepare a comparative profit or loss report for the current and previous month. The manager wants
the report to cover only meat production in Victoria’s branches. Your colleague suggests that since
the company has different branches and products, financial statements should cover all of the
company’s activities. He also suggested that the report should be prepared for a financial year in
accordance with accounting standards.
Using your knowledge of financial and managerial accounting, general and specific purpose financial
reports and various users of accounting information, advise your colleague as to the approach they
should adopt to meet the manager’s requirements and ensure the information correctly reflects the
department’s operations.
Your answer needs to be in your own words and correctly referenced to receive full marks.
(200 words)
Page 3 of 5
Question 2 (6 marks)
You have been provided with the unadjusted and adjusted trial balance for Cleaning Services Ltd as of
30 June 2019.
No Account Name Dr ($) Cr ($) Dr ($) Cr ($)
100 Cash 12,450 12,450
110 Accounts Receivable 54,200 62,541
130 Office Supplies 82,730 54,236
140 Prepaid Insurance 13,000 9,789
150 Cleaning Equipment 259,200 259,200
151 Less Accumulated Depreciation –
Cleaning Equipment 103,680 129,600
200 Accounts Payable 12,300 12,300
220 Interest Payable 620
230 Revenue Received in Advance 52,730 40,430
240 Salaries Payable 2,541
250 Bank Loan (10 years term) 19,580 19,580
300 Share Capital 33,412 33,412
310 Retained Earnings 25,231 25,231
311 Dividends 15,000 15,000
400 Service Revenue 256,587 277,228
500 Salaries Expense 53,240 55,781
505 Insurance Expense 3,211
510 Interest Expense 1,200 1,820
520 Depreciation Expense 25,920
530 Supplies Expense 28,494
540 Rent Expense 12,500 12,500
503,520 503,520 540,942 540,942
Cleaning Services Ltd
Trial balance
as at 30 June 2019
Unadjusted Adjusted
Page 4 of 5
Required:
a) Record the unadjusted opening balance of each account in the correct T–account before
recording adjusting entries.
b) Record the adjusting entries in the General Journal using the below format:
Cleaning Services Ltd
General Journal
Date Account (Narration) Post ref Debit $ Credit $
xxx XXX
xxx (hold your CTRL and TAB key to indent) XXX
(Don’t forget your narration).
c) Record the adjusting entries in the correct T-accounts.
d) Balance the T-accounts. (Only use one set of T-accounts for parts a, c and d – if there is only one
entry in the T-account you may balance using double underlines directly under the individual
figures. Once the account has more than 1 figure please use the full balancing process).
e) Prepare an Income Statement, Statement of Changes in Owners’ Equity and a classified
Statement of Financial Position (Balance Sheet) as at 30 June 2019.
NOTE: to maximise your mark you must include correct titles, narrations, dates etc. This is an
assignment, not under exam conditions, therefore attention to detail is expected.
Page 5 of 5
Question 3 (6 marks)
You need to follow the “Assignment Presentation Guide – Company Analysis Guide” available under
the “Assignment” tab.
Select a company that is not a Bank/Financial institution from the Library database and download the
required financial information.
Please note: do not select a Bank or Financial institution as these companies have minimum liquidity
ratios under law and are not as suitable for this activity.
a) Using the downloaded data, complete a Horizontal Analysis of the Profit and Loss, Balance Sheet,
Cash Flow and Ratios for 2018 and 2019. Set the $ movement to “no decimal places” and the %
movement to “2 decimal places” for the statements. When analysing the ratios please use 2
decimal places for both the $ and % movements.
b) Write a brief report, using the horizontal analysis data, individually analysing the Profit and Loss,
Balance Sheet and Cash Flow Statement. This is to be in your own words and not a report copied
from a financial advisor on the internet. Marks will be significantly deducted if it is not in your
own words and work. It is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse. (200 words)
c) Select a minimum of eight ratios, ensuring you include a range of liquidity, profitability and
solvency ratios and analyse the company. Where possible use the ratios we have covered in class.
As in part b above it is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse.
(200 words)
Please note only refer to those ratios that are provided on the “ratios” tab, do not attempt to
calculate them yourself.
d) Ensure you include a screen copy of each of the four tabs with your horizontal analysis within
your report. Where you include them is up to you based on your report presentation (could be in
an appendix).
Remember: You need to upload 1 document with all the assignment answers structured in a
Business Report format. Please follow the presentation guide and save your completed
assignment as a .pdf document to ensure your layout is retained.Page 1 of 5
ACC1AMD
Individual Assignment
15 marks total
This assignment will assess your Ethical Behaviour and
Creative Problem-Solving Graduate Capabilities
General information and requirements
This is an individual assignment due in on Sunday 24th May 2020, by 11.59pm.
Assignment Length
Each question provides a guide as to the approximate word length of each answer. It is recommended
you are close to these limits, but you do not need to achieve them exactly.
Please ensure your overall assignment is +/- 10% of the total word limit. Assignments that vary
significantly from these guidelines will be marked down.
Submission
All submissions must be typed in a minimum 11 font, with 1.5 line spacing using WORD saved as a .pdf
file and submitted via the Turnitin link on LMS. You are only able to submit 1 file.
Referencing
All submissions will be reviewed by a program called “Turnitin” and this will identify instances of
plagiarism (copying). This is a very serious offence and can result in you receiving no marks for the
assessment task.
Please ensure if you have copied information you use quotation marks and appropriate referencing.
If you reword someone else’s work, you still need to refer to the author’s in your sentence. For
example, Hines (1991) discusses how……. – whilst this is not a quote you need to reference the idea.
Refer to the “Assignment Presentation Guide” available under the “Assignment” tab for guidance.
This assignment requires you to analyse data. If you copy financial reports from the internet it will be
obvious and no marks will be awarded, even if correctly referenced. The purpose of the assignment is
to develop your analytical skills which are not those of an investment advisor. A small amount of
referenced information will be acceptable.
Late Assignment Penalty
“The standard penalty for late submission of assessment tasks is 5% of the marks for that task for
each delay in submission of a day or partial day up to a maximum of five (5) working days after the
due date.”
Please note: after 5 days your assignment will not be marked.
Page 2 of 5
Presentation
Assignments must be presented in accordance with the “Assignment Presentation Guide” available
under the “Assignment” tab. (1 mark)
Question 1 (2 marks)
Australia Food Ltd is a company with several branches across Victoria and NSW. The Company
produces various food products including meats and milks. You work as a management accountant in
this company.
Your manager has asked one of your colleagues in the management accounting department to
prepare a comparative profit or loss report for the current and previous month. The manager wants
the report to cover only meat production in Victoria’s branches. Your colleague suggests that since
the company has different branches and products, financial statements should cover all of the
company’s activities. He also suggested that the report should be prepared for a financial year in
accordance with accounting standards.
Using your knowledge of financial and managerial accounting, general and specific purpose financial
reports and various users of accounting information, advise your colleague as to the approach they
should adopt to meet the manager’s requirements and ensure the information correctly reflects the
department’s operations.
Your answer needs to be in your own words and correctly referenced to receive full marks.
(200 words)
Page 3 of 5
Question 2 (6 marks)
You have been provided with the unadjusted and adjusted trial balance for Cleaning Services Ltd as of
30 June 2019.
No Account Name Dr ($) Cr ($) Dr ($) Cr ($)
100 Cash 12,450 12,450
110 Accounts Receivable 54,200 62,541
130 Office Supplies 82,730 54,236
140 Prepaid Insurance 13,000 9,789
150 Cleaning Equipment 259,200 259,200
151 Less Accumulated Depreciation –
Cleaning Equipment 103,680 129,600
200 Accounts Payable 12,300 12,300
220 Interest Payable 620
230 Revenue Received in Advance 52,730 40,430
240 Salaries Payable 2,541
250 Bank Loan (10 years term) 19,580 19,580
300 Share Capital 33,412 33,412
310 Retained Earnings 25,231 25,231
311 Dividends 15,000 15,000
400 Service Revenue 256,587 277,228
500 Salaries Expense 53,240 55,781
505 Insurance Expense 3,211
510 Interest Expense 1,200 1,820
520 Depreciation Expense 25,920
530 Supplies Expense 28,494
540 Rent Expense 12,500 12,500
503,520 503,520 540,942 540,942
Cleaning Services Ltd
Trial balance
as at 30 June 2019
Unadjusted Adjusted
Page 4 of 5
Required:
a) Record the unadjusted opening balance of each account in the correct T–account before
recording adjusting entries.
b) Record the adjusting entries in the General Journal using the below format:
Cleaning Services Ltd
General Journal
Date Account (Narration) Post ref Debit $ Credit $
xxx XXX
xxx (hold your CTRL and TAB key to indent) XXX
(Don’t forget your narration).
c) Record the adjusting entries in the correct T-accounts.
d) Balance the T-accounts. (Only use one set of T-accounts for parts a, c and d – if there is only one
entry in the T-account you may balance using double underlines directly under the individual
figures. Once the account has more than 1 figure please use the full balancing process).
e) Prepare an Income Statement, Statement of Changes in Owners’ Equity and a classified
Statement of Financial Position (Balance Sheet) as at 30 June 2019.
NOTE: to maximise your mark you must include correct titles, narrations, dates etc. This is an
assignment, not under exam conditions, therefore attention to detail is expected.
Page 5 of 5
Question 3 (6 marks)
You need to follow the “Assignment Presentation Guide – Company Analysis Guide” available under
the “Assignment” tab.
Select a company that is not a Bank/Financial institution from the Library database and download the
required financial information.
Please note: do not select a Bank or Financial institution as these companies have minimum liquidity
ratios under law and are not as suitable for this activity.
a) Using the downloaded data, complete a Horizontal Analysis of the Profit and Loss, Balance Sheet,
Cash Flow and Ratios for 2018 and 2019. Set the $ movement to “no decimal places” and the %
movement to “2 decimal places” for the statements. When analysing the ratios please use 2
decimal places for both the $ and % movements.
b) Write a brief report, using the horizontal analysis data, individually analysing the Profit and Loss,
Balance Sheet and Cash Flow Statement. This is to be in your own words and not a report copied
from a financial advisor on the internet. Marks will be significantly deducted if it is not in your
own words and work. It is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse. (200 words)
c) Select a minimum of eight ratios, ensuring you include a range of liquidity, profitability and
solvency ratios and analyse the company. Where possible use the ratios we have covered in class.
As in part b above it is not acceptable to simply state one number is bigger than the other and
therefore it is better. You need to explain the importance of the number and why it is
better/worse.
(200 words)
Please note only refer to those ratios that are provided on the “ratios” tab, do not attempt to
calculate them yourself.
d) Ensure you include a screen copy of each of the four tabs with your horizontal analysis within
your report. Where you include them is up to you based on your report presentation (could be in
an appendix).
Remember: You need to upload 1 document with all the assignment answers structured in a
Business Report format. Please follow the presentation guide and save your completed
assignment as a .pdf document to ensure your layout is retained.

Homework Ace Tutors

Why Work with Us

Top Quality and Well-Researched Papers

-

Professional and Experienced Academic Writers

-

Free Unlimited Revisions

-

Prompt Delivery and 100% Money-Back-Guarantee

-

Original & Confidential

-

24/7 Customer Support

-

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

-

Admissions

-

Reviews

Editing Support

-

Reviews

Revision Support

-