Introductory Business Financial Modelling
Run the numbers on spreadsheets, financial statements and capital budgeting. Get the lowdown on key economic concepts. Become a financial problem solver, drawing on trusted modelling techniques. Learn about business portfolios and bond valuations.
Enrolments for this year have closed. Keep exploring subjects.
Subjects may require attendance
QS RANKING 2022
Times Higher Education Ranking 2022
At the completion of this subject students will be able to:
- investigative and analytical skills in financial problem solving
- implement and demonstrate financial programming techniques in problem solving
- design financial models for forecasting, valuation and what-if analysis
- a range of financial for strategic and managerial decision making
- strategic and managerial decision-making using quantitative modelling techniques.
- Helpful Tools for Modelling in Microsoft Excel
- Time Value of Money I
- Time Value of Money II
- Capital Budgeting
- Choosing a Discount Rate
- Statistics for Portfolios
- CAPM and SML
- SML and Investment Performance
- Bond Valuation
- Valuing Stocks
You must either have successfully completed the following subject(s) before starting this subject, or currently be enrolled in the following subject(s) in a prior study period; or enrol in the following subject(s) to study prior to this subject:
Please note that your enrolment in this subject is conditional on successful completion of these prerequisite subject(s). If you study the prerequisite subject(s) in the study period immediately prior to studying this subject, your result for the prerequisite subject(s) will not be finalised prior to the close of enrolment. In this situation, should you not complete your prerequisite subject(s) successfully you should not continue with your enrolment in this subject. If you are currently enrolled in the prerequisite subject(s) and believe you may not complete these all successfully, it is your responsibility to reschedule your study of this subject to give you time to re-attempt the prerequisite subject(s)
No additional requirements
This subject develops the rationale and spreadsheet techniques in using the Microsoft Excel. Topics covered include: time value of money, capital budgeting, weighted average cost of capital, statistical analysis and portfolio theory.
Please Note: If it’s your first time studying a Curtin University subject 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 subject grades will be withheld.
Find out more about the Academic Integrity module.
The new CRIS (Curtin Remote Invigilation System) will be used for this unit’s test and exam. Student will need to use the system which monitors their camera/microphone as well as monitors their desktop activity during the duration of the exam.
- Financial Analysis Project (25%)
- Online Test (25%)
- Online Examination (School Invigilated) (50%)
Current study term: 29 Aug 21 to 28 Nov 21
Principles of Finance with Excel, 3rd ed.
Benninga, S. and Mokfadi, D.