Rubric – FINM7409 Assignment
Task Low Achievement Moderate Achievement High Achievement
Excel Spreadsheet
Other inputs tab Most inputs and formulas used are incorrect.
Some errors and/or
incorrect inputs and wrong
formulas used.
All inputs and formulas
used are correct.
Common-size & trend
analysis
Hard to determine where the
numbers come from. Wrong
formulas used.
Some computation errors
and/or incorrect inputs
without appropriate
justification.
All ratios computed
correctly. Any judgements
needed to determine the
correct inputs are noted and
justified.
Ratio analysis
Hard to determine where the
numbers come from. Wrong
formulas used.
Some computation errors
and/or incorrect inputs
without appropriate
justification.
All ratios computed
correctly. Any judgements
needed to determine the
correct inputs are noted and
justified.
Essay
Trend description and
analysis
Mostly incomplete or incorrect
description, with no analysis on
the underlying factors driving the
trend.
Some incomplete or
incorrect description, with
some analysis on the
underlying factors driving
the trend.
Complete and accurate
description, with good
analysis on the underlying
factors driving the trend.
Supporting graphs No/incorrect graph is provided. Minor errors in the graph provided.
Complete and accurate
graph is provided.
Profitability/Efficiency/
Liquidity/Solvency
analysis
No/incorrect key factors
identified.
Some incomplete or
incorrect factors identified.
Complete and accurate
factors identified.
Supporting graphs No/incorrect graph is provided. Minor errors in the graph provided.
Complete and accurate
graph is provided.
Overall analysis
Insufficient/incorrect reasoning
provided, including not
referencing relevant ratio
analysis.
Some incomplete/incorrect
reasoning provided, with
some reference to relevant
ratio analysis.
Complete and accurate
reasoning provided, with
good reference to relevant
ratio analysis and
independent research.
Presentation
Meet word limit < 1,000
words
Word count not listed and/or
exceeds specified limit (strictly
enforced).
--
Word count is listed, is
accurate, and is strictly
under the specified limit.
Professional
Presentation
Presentation is sloppy and/or
English grammar is significantly
deficient.
Minor problems with
formatting or grammar.
Report is of professional
standard with appropriate
headings, references if
required, and grammatical
English.