Introductory Business Financial Modelling - 2018

Unit summary

BAN27

  • Level of Study: Undergraduate Level 2
  • Study load: 0.125 EFTSL
  • Delivery method: Fully Online
  • Prerequisites: Yes
  • Duration: 13 weeks
  • Government loans available: FEE-HELP, HECS-HELP
  • Availability for 2018: SP1 , SP3
  • Assessment: Assignment (20%) , Invigilated Exam (40%) - Learn more

Unit provided by

or
2018 Fees
AUD$
Domestic 1,368.00
HECS 1,368.00
International 1,618.00

Working with and building financial models on computer spreadsheets; integration of finance theories with spreadsheet techniques; utilising concepts such as financial mathematics, capital budgeting and risk management; evaluating shares, companies and and projects on spreadsheets; financial statement analysis, introduction to the design of spreadsheet-based financial models.

Introduction to economic concepts and principles, Demand and supply analysis, Elasticity ,Economic Efficiency,

Market failure, Introduction to macroeconomics, Unemployment and inflation, Model of aggregate demand and aggregate supply, Global markets.

Please Note: If it’s your first time studying a Curtin University unit you’ll need to complete their compulsory ‘Academic Integrity Program’. It only takes two hours to complete online, and provides you with vital information about studying with Curtin University. The Academic Integrity Program is compulsory, so if it’s not completed your unit grades will be withheld.

Find out more about the Academic Integrity module.

At the completion of this unit students will be able to:

  1. develop investigative and analytical skills in financial problem solving
  2. apply financial programming techniques in problem solving
  3. design financial models for forecasting, valuation and what-if analysis
  4. communicate a range of financial solutions for strategic and managerial decision making
  5. validate strategic and managerial decision-making using quantitative modelling techniques.
  • Assignment (20%)
  • Invigilated Exam (40%)
  • Test (40%)
For more information on invigilated exams see Exams and results

Mandatory prerequisites

You must have successfully completed the following unit(s) before starting this unit:

If you have completed equivalent study at another university, please contact a Student Advisor for advice.

This unit addresses the following topics.

NumberTopic
1Helpful Tools for Modelling in Microsoft Excel
2Time Value of Money I
3Time Value of Money II
4Capital Budgeting
5Choosing a Discount Rate
6Statistics for Portfolios
7CAPM and SML
8SML and Investment Performance
9Bond Valuation
10Valuing Stocks

This unit is delivered using the following methods and materials:

Instructional Methods

  • Online Quizzes/Tests
  • Online assignment submission
  • Standard Media

Online materials

  • Online Assessment
  • Resources and Links

This unit is part of a major, minor, stream or specialisation in the following courses:

This unit may be eligible for credit towards other courses:

  1. Many undergraduate courses on offer through OUA include 'open elective' where any OUA unit can be credited to the course. You need to check the Award Requirements on the course page for the number of allowed open electives and any level limitations.
  2. In other cases, the content of this unit might be relevant to a course on offer through OUA or elsewhere. In order to receive credit for this unit in the course you will need to supply the provider institution with a copy of the Unit Profile in the approved format, which you can download here. Note that the Unit Profile is set at the start of the year, and if textbooks change this may not match the Co-Op textbook list.

Textbook information for this unit is currently being updated and will be available soon. Please check back regularly for updates. Alternatively, visit the The Co-op website and enter the unit details to search for available textbooks.

Enquire online

Need to ask a question that's best put down in words?
Make an online enquiry.

Enquire now

Ready to enrol?

Start studying this unit now.

or

Got a question?

Get an answer from one of our friendly Student Advisors.