TASK back to top Your task is to prepare one year of management accounts for a farm business. This is part A of a two part excel spreadsheet task. Part B (assessment 3) will build on what you have...

TASK

Your task is to prepare one year of management accounts for a farm business. This is part A of a two part excel spreadsheet task. Part B (assessment 3) will build on what you have completed in this assessment task.
You will be allocated an assessment case study with information about a mixed enterprise. The assessment case study allocated to you will be available via the Interact2 subject site during the second week of the session. You will be notified by an announcement when the case studies are available.
The information provided in the assessment case study is to be used for completing both Assessments 1 and 3. The case study you will be assigned contains information about the property and its enterprises, a spreadsheet containing an incomplete cash flow statement and a spreadsheet containing an incomplete depreciation schedule.
Topics 1 to 3 are related directly to this assessment and maintaining progress through these topics lectures and tutorials will enable you to confidently undertake and complete this assessment.
The task for this assessment is part A of a two part assessment
You are required to prepare the following management financial statements:

• Statement of Financial Position (Opening Balance Sheet) at the beginining of the year


• Cash Flow report
  
  
  • In completing the information in the 'CashMth' sheet, you will have to include any interest paid by the business in the row called “Interest - Overdraft”
  
  
  • At the end of the cash flow report you will provide the following
    
    
    • A quarterly GST reconciliation
    
    
    • A graph reflecting receipts, payments and monthly cash flow
    
    
    
    
  
  
  
  

You will be provided a template on the Interact2 site you can use as guidance.

You MUST ensure you include you case study number, name and student number is included on cover page of your assessment.

RATIONALE

SUBJECT LEARNING OUTCOMES

This assessment task will assess the following learning outcome/s:

• Be able to identify the financial resources and demonstrate an understanding of the financial management objectives of agricultural business


• Be able to construct, analyse and interpret the meaning of biophysical and financial statements that define the performance of an agricultural business

This assessment case study based on an agricultural production business is designed to

• Develop your financial management knowledge and skills in preparing, balancing and presenting financial statements.


• Agribusiness decisions are supported by modelling financial evidence. Whilst this assessment covers financial statements, the development of your excel skills will enable alternative scenario's to be modelled as a budget for a subsequent year by changing some variables.


• Develop professional, simple models of complex business systems to support decision making for profitable businesses.


• Assist you to develop your learning through application of principles covered in Modules 1-3 of the subject.

GRADUATE LEARNING OUTCOMES

This task also contributes to the assessment of the followingCSU Graduate Learning Outcome/s:

• Academic Literacy and Numeracy (Skill) - Charles Sturt Graduates demonstrate the literacy and numeracy skills necessary to understand and interpret information and communicate effectively according to the context.


• Academic Literacy and Numeracy (Application) - Charles Sturt Graduates consider the context, purpose, and audience when gathering, interpreting, constructing, and presenting information.


• Information and Research Literacies (Skill) - Charles Sturt Graduates demonstrate the skills required to locate, access and critically evaluate existing information and data.


• Information and Research Literacies (Application) - Charles Sturt Graduates synthesize and apply information and data to different contexts to facilitate planning, problem solving and decision making.


• Digital Literacies (Skill) - Charles Sturt Graduates use, create, communicate and share multimodal information in digital environments.


• Digital Literacies (Application) - Charles Sturt Graduates ethically, legally, safely and critically use technology to select, create and share information and participate in online learning, professional and social communities.

MARKING CRITERIA AND STANDARDS

Rubric

PRESENTATION

PLEASE NOTE: Clear presentation of financial information is important for management decision making. Markers reserve the right not to mark poorly presented statements.

The management financial reports, Assessment 1, are to be prepared utilising spreadsheet software and must be submitted in a Microsoft Excel (.xls) or compatible format.

• All spreadsheets must be neatly presented (i.e. is appropriately formatted on the spreadsheet), accurate and in accordance with the information contained in the allocated case study


• Your cover sheet, is the first workbook in the spreadsheet, will include your case study number, name and student number

REQUIREMENTS

Please note you are expected to complete and submit this assessment item using Microsoft Excel spreadsheet software.