eco2bmo business, economic and financial modelling with excel
BUSINESS, ECONOMIC AND FINANCIAL MODELLING WITH EXCEL
ECO2BMO
Not currently offered
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.
SchoolLa Trobe Business School
Credit points15
Subject Co-ordinatorGreg Jamieson
Available to Study Abroad/Exchange StudentsYes
Subject year levelYear Level 2 - UG
Available as ElectiveYes
Learning ActivitiesLectures, tutorials, prescribed reading, class discussions
Capstone subjectNo
Subject particulars
Subject rules
PrerequisitesBUS1BUE OR ECO1IMA OR ECO1IMI OR BUS1MIS OR ECO1RIG OR ECO1DSM OR BUS1BAN
Co-requisitesN/A
Incompatible subjectsBUS2BMO
Equivalent subjectsN/A
Quota Management StrategyN/A
Quota-conditions or rulesN/A
Special conditionsN/A
Minimum credit point requirementN/A
Assumed knowledgeN/A
Learning resources
Principles of Macroeconomics
Resource TypeBook
Resource RequirementPrescribed
AuthorStonecash, R., Gans, J., King, S., Mankiw, N
Year2011
Edition/Volume5TH EDITION
PublisherCENGAGE LEARNING
ISBN9780170382656
Chapter/article titleN/A
Chapter/issueN/A
URLN/A
Other descriptionN/A
Source locationN/A
Career Ready
Career-focusedNo
Work-based learningNo
Self sourced or Uni sourcedN/A
Entire subject or partial subjectN/A
Total hours/days requiredN/A
Location of WBL activity (region)N/A
WBL addtional requirementsN/A
Graduate capabilities & intended learning outcomes
Graduate Capabilities
Intended Learning Outcomes
Subject options
Select to view your study options…