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 TypeTitleResource RequirementAuthor and YearPublisher
ReadingsPrinciples of Macroeconomics;PrescribedStonecash, R., Gans, J., King, S., Mankiw, NCENGAGE LEARNING 5TH EDITION (2011)

Subject options

Select to view your study options…

Start date between: and    Key dates

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 elementComments%
one 2-hour final examination (hurdle)55
three 700-word spreadsheet-based assignments45