BUSINESS, ECONOMIC AND FINANCIAL MODELLING WITH EXCEL
ECO2BMO
2014
Credit points: 15
Subject outline
Computer based spreadsheet modelling techniques are introduced for the analysis, planning and control of business operations. Techniques include forecasting using time series and causal methods, goal seeking and optimal decision making, capital budgeting and Monte Carlo simulation. The evaluation of firm performance through ratio analysis based on financial statements is covered. Three spreadsheet assignments are set for practising skills and techniques introduced in the subject. Familiarity with basic spreadsheet operations is assumed.
Faculty: Faculty of Business, Economics and Law
Credit points: 15
Subject Co-ordinator: James Bugden
Available to Study Abroad Students: Yes
Subject year level: Year Level 2 - UG
Exchange Students: Yes
Subject particulars
Subject rules
Prerequisites: Pre-Requisites: BUS1MIS or BUS1BUE or BUS1BAN, ECO1DSM or ECO1RIG or ECO1IMI or ECO1IMA
Co-requisites: N/A
Incompatible subjects: Incompatible Subjects: BUS2BMO
Equivalent subjects: N/A
Special conditions: N/A
Learning resources
Readings
| Resource Type | Title | Resource Requirement | Author and Year | Publisher |
|---|---|---|---|---|
| Readings | Principles of Macroeconomics; | Prescribed | Stonecash, R., Gans, J., King, S., Mankiw, N | CENGAGE LEARNING 5TH EDITION (2011) |
Melbourne, 2014, Semester 1, Day
Overview
Online enrolment: Yes
Maximum enrolment size: N/A
Enrolment information:
Subject Instance Co-ordinator: James Bugden
Class requirements
TutorialWeek: 10 - 22
One 1.0 hours tutorial per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.
LectureWeek: 10 - 22
Two 1.0 hours lecture per week on weekdays during the day from week 10 to week 22 and delivered via face-to-face.
Assessments
| Assessment element | Comments | % |
|---|---|---|
| one 2-hour final examination (hurdle) | 55 | |
| three 700-word spreadsheet-based assignments | 45 |