Unit Outline: Curtin Business School Of Accounting

Curtin Business School School of Accounting

Unit Outline

301224 Accounting Modelling 330 Semester 2, 2013
Unit study package number: Mode of study: Tuition pattern summary: Credit Value: Pre-requisite units: Co-requisite units: Anti-requisite units: Result type: Approved incidental fees: Unit coordinator: 301224 Internal Seminar: 1 x 3 Hours Weekly This unit does not have a fieldwork component. 25.0 11013 (v.0) Management Accounting 201 or any previous version Nil Nil Grade/Mark Information about approved incidental fees can be obtained from our website. Visit f ees.curtin.edu.au/incidental_fees.cfm for details. Name: Phone: Email: Building: Room: Consultation times: Name: Email: Building: Name: Phone: Email: Building: Room: Greg White
[phone] [e-mail] 407 424 To be advised

Teaching Staff:

Sherman Cheah [e-mail] 407 Greg White [phone] [e-mail] 407 424

Administrative contact:

Learning Management System:

Blackboard (lms.curtin.edu.au)

301224 Accounting Modelling 330 Bentley Campus 18 Jun 2013 School of Accounting, Curtin Business School

Page: 1 of 8 CRICOS Provider Code WA 00301J, NSW 02637B

Curtin Business School School of Accounting

Acknowledgement of Country
We respectfully acknowledge the Indigenous Elders, custodians, their descendants and kin of this land past and present.

Syllabus
Decision support software for management accounting. Development of skills in spreadsheet add-in tools to solve capacity problems, develop budget scenarios, simulate cash flows for revenues and expenses, and plan capital investment cash flow.

Introduction
This Unit provides significant training in the use of MS Excel for financial modeling. Students will work through a set of weekly exercises with careful application of new skills to case study company data presented in the textbook. The assessments in the Unit comprise a folio submission, mid-semester test and final assignment which are scored out of a maximum 30%, 40% and 30%, respectively. There is no final exam in this unit.

Unit Learning Outcomes
On successful completion of this unit students can: 1 Analyse financial and business data to identify patterns or cycles 2 Rearrange and combine data to formulate forecasting models 3 Formulate and interpret the output of optimization models for planning 4 Formulate Monte Carlo simulations for business and interpret the output for profit planning 5 Conduct internet searches for financial modelling software; appraise the software and report with recommendations for its application in a specified business situation Graduate Attributes addressed

Curtin's Graduate Attributes
Apply discipline knowledge Communication skills International perspective
(value the perspectives of others)

Thinking skills
(use analytical skills to solve problems)

Information skills
(confidence to investigate new ideas)

Technology skills Cultural understanding
(value the perspectives of others)

Learning how to learn
(apply principles learnt to new situations) (confidence to tackle unfamiliar problems)

Professional Skills
(work independently and as a team) (plan own work)

Find out more about Curtin's Graduate attributes at the Office of Teaching & Learning website: ctl.curtin.edu.au

Learning Activities
Weekly computer lab work using new MS Excel skills. Applying new knowledge to three assessment tasks. Working with fellow students and Tutor in class to achieve learning outcomes.

301224 Accounting Modelling 330 Bentley Campus 18 Jun 2013 School of Accounting, Curtin Business School

Page: 2 of 8 CRICOS Provider Code WA 00301J, NSW 02637B

Curtin Business School School of Accounting

Learning Resources
Essential texts
The required textbook(s) for this unit are: You will need to purchase the following textbook(s) in order to complete this unit: Mayes, T.R., (2012).
Financial Analysis With Microsoft Excel (6th Ed.). Canada: SouthWestern (Cengage Learning). Please note that there had been a change from the 5th to the 6th edition of this textbook. The textbook is available as an eBook through the publisher's website link below.

Online resources
You will need to purchase the following textbook(s) in order to complete this unit: Mayes, T.R., (2012). Financial Analysis With Microsoft Excel (6th Ed.). Canada: SouthWestern (Cengage Learning). Please note that there had been a change from the 5th to the 6th edition of this textbook. The textbook is available as an eBook through the publisher's website link below. (http://www.cengagebrain.com.au/shop/isbn/9781111826246)

Assessment
Assessment schedule
Task Folio 1 Value % 30 percent Date Due Unit Learning Outcome(s) Assessed 1,2,3

Semester Test 2

40 percent

Assignment
3

30 percent

Week: Tuition Free Week beginning Monday 2nd September, Day: 6 Time: 17:00 3,4,5 Week: Teaching Week 8 beginning Monday 7th October, 2013 Day: 2 Time: 00:00 2,3,4 Week: Teaching Week 12 beginning Monday 4th November, 20 Day: 6 Time: 17:00

301224 Accounting Modelling 330 Bentley Campus 18 Jun 2013 School of Accounting, Curtin Business School

Page: 3 of 8 CRICOS Provider Code WA 00301J, NSW 02637B

Curtin Business School School of Accounting
Detailed information on assessment tasks
1.

Folio Submit online through the Unit's FLECS Blackboard site assessment dropbox. The Folio assessment guidance and all requirements related to Folio will be available from the Unit's FLECS Blackboard site in the first week of semester.
2.

Test The semester test will be conducted as a true/false, muliple-choice, short answer online test through Blackboard. More details of the semester test format and procedures will be communicated through Blackboard announcement early during semester. The test will assess students' developing practical knowledge of MS Excel as a tool for financial analysis. It will be conducted in normal seminar time during this week of semester.

3.

Assignment Two parts of the Assignment are due separately: Part 1: A presentation of the proposed assignment financial model for a real ASX-listed company.
Peer-assessed (by a fellow student) in seminar classes in the week beginning 28th October, 2013. Submit presentation MS Powerpoint file online through the Unit's FLECS Blackboard site assessment dropbox and give interview rubric to Tutor after marking on the day of the seminar. The marking guide is focussed on presentation content so your Tutor will check marking rubrics from students against the submitted powerpoint slides, re-mark and record results online in My Grades (marks 5/30). Part 2: Due 17:00 Friday on Friday 8th November. Submit an MS Excel worksheet online through the Unit's FLECS Blackboard site assessment dropbox. The Assignment assessment guidance and all requirements related to the Assignment will be available from the Unit's FLECS Blackboard site in the first week of semester (25/30).

Fair assessment through moderation
Moderation describes a quality assurance process to ensure that assessments are appropriate to the learning outcomes, and that student work is evaluated consistently by assessors. Minimum standards for the moderation of assessment are described in the Assessment Manual, available from policies.curtin.edu.au/policies/teachingandlearning.cfm

301224 Accounting Modelling 330 Bentley Campus 18 Jun 2013 School of Accounting, Curtin Business School

Page: 4 of 8 CRICOS Provider Code WA 00301J,
NSW 02637B

Curtin Business School School of Accounting
Late assessment policy
This ensures that the requirements for submission of assignments and other work to be assessed are fair, transparent, equitable, and that penalties are consistently applied. 1. All assessments which students are required to submit will have a due date and time specified on the Unit Outline. 2. Accepting late submission of assignments or other work will be determined by the unit coordinator or Head of School and will be specified on the Unit Outline. 3. If late submission of assignments or other work is not accepted, students will receive a penalty of 100% after the due date and time ie a zero mark for the late assessment. 4. If late submission of assignments or other work is accepted, students will be penalised by ten percent per calendar day for a late assessment submission (eg a mark equivalent to 10% of the total allocated for the assessment will be deducted from the marked value for every day that the assessment is late). This means that an assignment worth 20 will have two marks deducted per calendar day late. Hence if it was handed in three calendar days late and marked as 12/20, the student would receive 6/20. An assessment more than seven calendar days overdue will not be marked. Work submitted after this time (due date plus seven days) may result in a Fail - Incomplete (F-IN) grade being awarded for the unit.

Assessment extension
A student must apply for an assessment extension on the Assessment Extension Form, as prescribed by the Academic Registrar. The form is available on the Forms page at http://students.curtin.edu.au/administration. The student will be expected to lodge the form and supporting documentation with the unit coordinator before the assessment date/time or due date/time. An application may be accepted up to five working days after the date or due date of the assessment task where the student is able to provide an acceptable explanation as to why he or she was not able to submit the application prior to the assessment date. An application for an assessment extension will not be accepted after the date of the Board of Examiners’ meeting.

Additional assessment information Pass requirements
Receive an overall grade of 5 or above and a mark greater than or equal to 50 after completion and submission of all assessments.

Referencing style
The referencing style for this unit is Chicago. More information can be found on this style from the Library web site: library.curtin.edu.au.

Plagiarism
Plagiarism occurs when work or property of another person is presented as one's own, without appropriate acknowledgement or referencing. Plagiarism is a serious offence. For more information refer to academicintegrity.curtin.edu.au.

Plagiarism monitoring
Work submitted may be subjected to a plagiarism detection process, which may include the use of systems such as 'Turnitin'. For further information, see academicintegrity.curtin.edu.au/students/turnitin.cfm.

301224 Accounting Modelling 330 Bentley Campus 18 Jun 2013 School of Accounting, Curtin Business School

Page: 5 of 8 CRICOS Provider Code WA 00301J, NSW 02637B

Curtin Business School School of Accounting

Additional information
During seminars in Accounting Modelling 330 it is very important to carefully read the textbook chapter and work through the activities prescribed for the class. For External and Bentley students alike the important learning outcomes related to practical use and knowledge of MS Excel functions can only be achieved by steady work throughout semester and by asking your Tutor and fellow students questions when you do not understand.

Enrolment:
It is your responsibility to ensure that your enrolment is correct - you can check your enrolment through the eStudent option on OASIS, where you can also print an Enrolment Advice.

Supplementary/Deferred exams:
Supplementary and deferred examinations will be held at a date to be advised. Notification to students will be made after the Board of Examiners meeting via the Official Communications Channel (OCC) in OASIS. It is the student's responsibility to check their OASIS account on a weekly basis for official Curtin correspondence. If your results show that you have been awarded a supplementary or deferred exam you should immediately check your OASIS email for details.

Student Rights and Responsibilities
It is the responsibility of every student to be aware of all relevant legislation, policies and procedures relating to their rights and responsibilities as a student. These include: the Student Charter the University's Guiding Ethical Principles the University's policy and statements on plagiarism and academic integrity copyright principles and responsibilities the University's policies on appropriate use of software and computer facilities Information on all these things is available through the University's "Student Rights and Responsibilities website at: students.curtin.edu.au/rights.

Disability
Students with a disability or medical condition (e.g. mental health condition, chronic illness, physical or sensory disability, learning disability) are encouraged to seek advice from Disability Services www.disability.curtin.edu.au. A Disability Advisor will work with you and liaise with staff to identify strategies to assist you to meet unit (including fieldwork education) and course requirements, where possible. It is important to note that the staff of the university may not be able to meet your needs if they are not informed of your individual circumstances.

Recent unit changes
We welcome feedback as one way to keep improving this unit. Students are encouraged to provide unit feedback through eVALUate, Curtin's online student feedback system (see evaluate.curtin.edu.au/info/). Recent changes to this unit include:

The Unit has been subject to a major review of teaching materials for new students enrolling for semester 1 2013. This was necessary because the textbook has been updated to the 6th Edition.The assessment has been changed to include a semester test and the proportion of marks allocated to each assessment and timetable improved to enable students early feedback about their learning progress. The Unit Coordinator is currently working to develop work integrated learning for this Unit in the form of a business case and financial model solution. This change is proposed for semester 1 2014.

See evaluate.curtin.edu.au to find out when you can eVALUate this unit.

301224 Accounting Modelling 330 Bentley Campus 18 Jun 2013 School of Accounting, Curtin Business School

Page: 6 of 8 CRICOS Provider Code WA 00301J, NSW 02637B

Curtin Business School School of Accounting

Program calendar
Wk Begin Seminar Date
29 Jul 1 5 Aug Orientation Week Topic 1 Introduction to MS Excel p. 11-17 entering and formatting p. 17-27 relative referencing and built in Excel functions p. 27-38 graphs, printing, saving and best practice 2 12 Aug Topic 2 The basic financial statements p. 44-54 financial statements and auto functions p. 54-57 common-size and trend analysis p. 57-64 cash flow statements and outliner function 3 19 Aug Topic 3 The Cash Budget p. 69-80 cash budgeting, calculating text strings and using date functions p. 81-90 short term borrowing requirements and using what-if analysis p. 90-98 formula auditing tools to avoid errors 4 26 Aug 2 Sep 5 9 Sep No Classes (Folio preparation in own time) Tuition Free Week Topic 4 Financial Statement Analysis p. 150-121 calculating ratios of liquidity, efficiency, leverage, coverage, profitability p. 122-126 Du Pont analysis, original z-score and financial distress p. 132-135 Economic profits measures of financial performance 6 16 Sep Topic 5 Financial Forecasting p. 142-146 forecasting the income statement p. 146-154 determining finance requirements by forecasting assets and liabilities p. 154-164 trend analysis and extrapolation
301224 Accounting Modelling 330 Bentley Campus 18 Jun 2013 School of Accounting, Curtin Business School Page: 7 of 8 CRICOS Provider Code WA 00301J, NSW 02637B

Pre-readings

Seminar activites

Assessment Due

1,2&3

None

1,2&3

None

1,2&3

None

FOLIO 1,2&3 None

1,2&3

None

Curtin Business School School of Accounting
8. 23 Sep Topic 6 p. 169-174 break even point measurement p. 175-183 degree of leverage calculation 9. 10. 11. 30 Sep 7 Oct 14 Oct Tuition Free Week Online Mid-semester test held during normal seminar class Topic 7 Capital Budgeting p. 322-332 analysing and calculating total cash flow p. 333-350 using pay back period, NPV, PI, IRR, and MIRR and scenario manager 12. 21 Oct Topic 8 Capital Budgeting p. 350-352 creating an MCC and IOS schedule to optimize capital budgeting p. 352-359 using constraints in MS Excel’s Solver for investment decision-making 13. 28 Oct Topic 9 Risk and the Capital Budget p. 371-375 calculating after-tax cash flows and using MACRS function to calculate depreciation p. 375-382; 386-393 sensitivity analysis and Monte Carlo simulation to analyse risk 14 15. 16. 17. 4 Nov 11 Nov 18 Nov 25 Nov No Classes (Assignment preparation in own time) Study Week Examinations Examinations ASSIGNMENT 1&2 None 1&2 None 1&2 TEST None 1&2 None

301224 Accounting Modelling 330 Bentley Campus 18 Jun 2013 School of Accounting, Curtin Business School

Page: 8 of 8 CRICOS Provider Code WA 00301J, NSW 02637B