MCD2160 Trimester 2 2023 MYOB Group report
MYOB Group Report (10% of grade) Due Wednesday 30 August 2023 6pm
AEST
Group work in groups of 2-3 and all group members must be enrolled in the same tutorial class.
Groups can be organised by group members and approved with your Tutorial Class teacher. If you
do not form your own group by week 4, you will be assigned to a group by your Tutorial Class
teacher. Only one member from each group must submit the report to Turnitin in the MYOB Group
Report Assessment Folder.
Task
Write a Report of 1300 – 1500 words to the owner detailed on the top left of your individual data
sheet which helps the owner use the financial statements you have produced from MYOB for the
month of June 2023.
Your report should include the following explanations:
- how the business performed during the month of June 2023 (use 4 ratios in your
explanation).
- why prepayments (including insurance and rent) is an asset for the business and why
manual journals were prepared at month end for these items
- suggest 3 things the business could do to improve performance.
Calculations for your ratios should be provided in an appendix.
Ratio Benchmarks are:
Ratio
Liquidity / short term stability
Current ratio 47.8513
Liquid ratio 40.0000
Accounts Receivable T.O (Days) 72.44
Accounts Payable T.O (Days) 30.29
Gearing / Long term stability
Debt Ratio 36.98%
Times Interest Earned 118.68
Profitability
Return on equity 37.91%
Return on assets 23.69%
Return on sales 58.43%
Sales/services Turnover (times) 0.4054
Expenses Ratio 42.06%
For the ratio calculations use the opening balances from your individual data sheets
2
Your report must be in a Word document so that there is a Turnitin similarity report. Student’s must
include a PDF of one group members MYOB Income statement, MYOB Balance sheet and MYOB
Adjusted Trial Balance to support their ratio calculations. The statements must be PDF as if included
as Excel or Word it will impact similarity reports. If the reports are not PDF then the group mark will
be reduced.
Further students must provide evidence in the appendix for how they contributed to the report
(such as a Screen print out from Google sheets showing each student who contributed to the
report and their contributions or written comments for how each member contributed to the
report).
Marking Rubric attached.
3
Task 0 mark 0.5 mark 1 mark 1.5 marks 2 marks 2.5 marks 3 marks
Report addressed to
business owner in
report format
Report not
addressed or not
appropriately
addressed
Report
appropriately
addressed to
business owner
Ratios Less than 2 ratios
with average or poor
discussion of each
Less than 2 ratios
with good
discussion of each
2 ratios with
poor discussion
of each
2 ratios with
average
discussion of
each
2 ratios with
good discussion
of each
4 ratios with
poor discussion
of each
4 ratios with
average
discussion of
each
4 ratios with
good discussion
of each
Accounting for
Prepayments
No discussion Poor discussion of
only one of why
there is an asset OR
an expense
Average
discussion of
only one of why
there is an asset
OR an expense
Good discussion
of only one of
why there is an
asset OR an
expense
Poor discussion
why there is an
asset and an
expense
Average
discussion why
there is an asset
and an expense
Good discussion
why there is an
asset and an
expense
Possible
improvements
No discussion Discussion of only
one improvement
Poor discussion
of two
improvements
Good discussion
of two
improvements
OR poor
discussion of
three
improvements
Good discussion
of three
improvements
Calculations of ratios
provided
No calculations Errors in
calculations
Correct
calculations for
ratios discussed
PDF of MYOB reports
AND evidence of
contributions from
each group member
No MYOB reports or
reports in Word or
Excel. Or No
evidence of
contributions from
each group member
PDF reports
included. AND
evidence of
contributions from
each group member
If Turnitin report similarity is too high or Turnitin cannot produce a similarity report due to your report format, the most your group mark can be is 4 marks.
10% Penalty applies for each day or part day the report is late unless special consideration has been granted.
4
Report Format
Cover page
Executive summary (Considered in word count)
Contents Page
Introduction (Considered in word count)
Ratio discussion (Considered in word count)
Prepayments treatment discussion (Considered in word count)
Possible improvements discussion (Considered in word count)
Summary (Considered in word count)
Appendix (ratio calculations, statement of member contributions)