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 ElectiveNo

Learning ActivitiesLectures, tutorials, prescribed reading, class discussions

Capstone subjectNo

Subject particulars

Subject rules

PrerequisitesECO1RIG OR BUS1MIS OR ECO1DSM OR ECO1IMA OR BUS1BAN OR ECO1IMI OR BUS1BUE

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

Readings

Principles of Macroeconomics

Resource TypePrescribed

Resource RequirementN/A

AuthorStonecash, R., Gans, J., King, S., Mankiw, N

Year2011

Edition/Volume5

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

01. Deriving Excel formulas for valuing a firm's equity, dependent on its sources of capital
02. Set up alternative financial forecasting systems (Percent sales method, smoothing methods, regression), and appreciate the strengths and weaknesses of the systems.
03. Use Excel spreadsheets for leverage analysis
04. Use Excel spreadsheets for automating the display of basic financial statements (Income statement, Balance sheet, Statement of cash flows), and financial statement analysis.
05. Use Excel spreadsheets for capital budgeting under risk and Monte Carlo simulation for determining and displaying the range of present values of firm returns allowing for uncertain parameters
06. Use 'Solver' in Excel for break-even analysis and for profit maximisation.
07. Using Excel spreadsheets for linear programming

Subject options

Select to view your study options…

Start date between: and    Key dates

Subject not currently offered - Subject options not available.