Highlights
The Subject Learning Outcomes demonstrated by successful completion of this task include:
a) Explain the role and importance of financial information in business decision making.
b) Analyse and apply financial information to facilitate business decision making.
d) Recommend financial decisions to relevant stakeholders.
You are required to calculate financial information for a given business case study and then interpret and analyse the results to demonstrate how business decisions are informed by financial analysis.
This assessment requires you to apply financial statement analysis using the provided company data. You will perform calculations, interpret numerical outcomes, and explain how these financial results influence business decision making.
By completing this assessment, you will demonstrate:
The importance of financial information in business decisions
How to apply financial statement analysis
How to interpret results and use them for practical decision making
You must download both files from the Assessment 2 section on MyLearn:
Assessment 2 – Student Workbook.xlsx
Financial Statements Document
These will be the only permitted sources for calculations and analysis.
Conduct a percentage-based horizontal analysis of “Statement of Financial Position as at 30 June 2025” in the Balance Sheet worksheet of the Excel workbook.
Round all results to two decimal places
Use Excel formulas only
Perform a ratio analysis for the years ended 30 June 2025 and 2024 in the Income Statement worksheet.
You must calculate ratios for:
Profitability
Efficiency
Liquidity
Solvency
All calculations must be completed using Excel formulas. Numerical answers without formulas will not be accepted.
Using the ratio analysis, write a detailed analysis of the company’s:
Profitability
Efficiency
Liquidity
Solvency
Your analysis must:
Explain why each ratio changed
Identify what numerical factors caused the change
Compare ratios to industry standards or similar entities
Include in-text references to the annual report with specific page numbers
Provide specific, company-focused recommendations (not generic solutions)
Highlight areas needing improvement or investigation
This section should be 1000–1100 words.
Using the Statement of Cash Flows (in the Excel workbook):
Explain reasons for changes in Net Increase/(Decrease) in Cash and Cash Equivalents between 2024 and 2025
All reasons must be supported with specific page-referenced evidence from the annual report
No recommendations are required for this part
All calculations in Excel must show formulas. Providing values without formulas will result in zero marks.
Your final submission must follow a professional report structure and correct academic writing standards.
Must include:
Student Name and ID
Subject Code and Title
Assessment Number
University Name
Learning Facilitator’s Name
Submission Date
Word Count
You are encouraged to be creative with the design.
The executive summary should:
Summarise the key content
Highlight major findings and outcomes
Allow readers to understand the purpose without reading the full report
This is not an introduction to the company.
Include headings, sub-headings, and page numbers.
(Not included in word count.)
Briefly introduce the company.
Do not summarise the report itself.
Must include references.
This section contains:
Explain ratio changes, numerical factors, annual report references, industry comparisons, and recommendations.
Explain ratio movements, causes, benchmarks, and actionable recommendations.
Discuss changes, reasons supported by report data, comparison to standards, and improvement strategies.
Interpret ratio shifts, identify financial risks, compare with the industry, and recommend solutions specific to the business.
If separated, ensure the structure is:
Analysis Section
Recommendations Section
Recommendations must be:
Specific
Justified
Tailored to the company
Based on ratio findings
This assessment requires the student to analyse financial information using real company data and demonstrate how financial analysis informs business decision making. The key tasks include:
1. Downloading the required documents
Assessment 2 – Student Workbook.xlsx
Financial Statements Document
These are the only allowed sources for calculation and interpretation.
2. Completing financial analyses using Excel formulas
Conduct a percentage-based Horizontal Analysis of the Statement of Financial Position as at 30 June 2025.
Perform Ratio Analysis (Profitability, Efficiency, Liquidity, Solvency) for 2024 and 2025.
All answers must be calculated with Excel formulas, rounded to two decimals.
3. Writing a detailed report (1000–1100 words)
Based on the ratio analysis, the student must explain:
Why each ratio changed
What numerical factors caused the change
How the ratio compares with industry benchmarks
Page-referenced evidence from the annual report
Specific, company-focused recommendations for improvement
4. Analysing the Statement of Cash Flows
Explain reasons for changes in the net increase/decrease in cash equivalents between 2024 and 2025 using page-referenced evidence.
No recommendations required.
5. Following formal report structure
Cover page
Executive summary
Table of contents
Introduction
Analysis & recommendations
References
Professional academic writing
APA 7 citation
Word count compliance
Completing all tasks demonstrates the application of financial information, ratio interpretation, and decision-making based on financial analysis.
The Academic Mentor followed a structured guidance approach, ensuring the student understood each requirement and progressed logically from calculations to interpretation and decision making.
The mentor first explained the purpose of the task: to connect financial calculations with business decisions. The student was guided to read the learning outcomes so they understood the objectives behind calculations and analysis. The mentor clarified the marking criteria and emphasised that Excel formulas were mandatory.
The mentor showed the student where to access the Student Workbook and the Financial Statements Document. The student was instructed to review the balance sheet, income statement, and cash flow statement to understand the structure and available data before calculations began.
The mentor demonstrated how to use Excel formulas to calculate percentage changes from one year to the next. The student learned to:
Reference correct cells
Apply percentage formulas
Round results to two decimals
Identify significant changes
The mentor encouraged the student to note major increases or decreases for later interpretation.
Looking to understand how to structure your assessment or analyse complex requirements? Our sample solution is available for instant download to help you get clarity and build confidence. This sample is strictly for reference and learning purposes only, and submitting it as your own work may lead to plagiarism penalties. Use it wisely to understand format, structure, and academic expectations.
If you need a fresh, fully customised, and plagiarism-free assignment, our expert academic writers are ready to deliver a solution tailored exactly to your topic, university guidelines, and marking rubric. Every order includes original content, proper referencing, and guaranteed academic accuracy perfect for students who want reliable support and higher grades without academic risk.
100 percent original and plagiarism-free content
Written by qualified academic specialists
Customised to your instructions and assessment criteria
Delivered on time with guaranteed quality
Safe, confidential, and student-friendly service
The downloadable sample is meant only for reference. Do not copy, submit, or reproduce it as your own work. To avoid academic misconduct, always order a fresh, custom-written solution.
Download Sample Solution Order Fresh Assignment
© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.