eco2bmo business modelling with excel
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.
FacultyFaculty of Business, Economics and Law
Credit points15
Subject Co-ordinatorJames Bugden
Available to Study Abroad StudentsYes
Subject year levelYear Level 2 - UG
Exchange StudentsYes
Subject particulars
Subject rules
Prerequisites Pre-Requisites: BUS1MIS or BUS1BUE or BUS1BAN, ECO1DSM or ECO1RIG or ECO1IMI or ECO1IMA
Co-requisitesN/A
Incompatible subjects Incompatible Subjects: BUS2BMO
Equivalent subjectsN/A
Special conditionsN/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) |
Subject options
Select to view your study options…
Melbourne, 2014, Semester 1, Day
Overview
Online enrolmentYes
Maximum enrolment sizeN/A
Enrolment information
Subject Instance Co-ordinatorJames 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 |