Students
ACST829 – Capital Budgeting and Financial Modelling
2015 – S1 Day
General Information
Download as PDF
| Unit convenor and teaching staff |
Unit convenor and teaching staff
Unit Convenor
Timothy Kyng
Contact via timothy.kyng@mq.edu.au
Two hours per week, timing to be advised, and otherwise by mutual agreement.
|
|---|---|
| Credit points |
Credit points
4
|
| Prerequisites |
Prerequisites
ACST603 or (admission to MActPrac post 2014)
|
| Corequisites |
Corequisites
|
| Co-badged status |
Co-badged status
|
| Unit description |
Unit description
This unit covers established methods for the valuation and appraisal of investment projects and related financial decisions. It also covers the new 'real options approach' to investment appraisal, including the application of exotic options pricing formulae to real options using Microsoft Excel to build financial models, and introducing students to Visual Basic/Excel macros for financial modelling.
|
Important Academic Dates
Information about important academic dates including deadlines for withdrawing from units are available at https://www.mq.edu.au/study/calendar-of-dates
Learning Outcomes
On successful completion of this unit, you will be able to:
- To gain an understanding of current established methods for the valuation and appraisal of investment projects, their advantages and disadvantages and the development of financial models for this purpose
- To gain an understanding of how to implement financial mathematics in an excel spreadsheet and to become adept in using some of excel's built in financial and statistical functions and other useful tools
- Develop an introductory understanding of the “real options approach” to investment appraisal
- To learn to use microsoft excel to build the financial models and perform the calculations to implement these methods
- Learn how to develop user defined functions using visual basic and use them from within excel
- Learn how to properly document a financial decision making problem and its solution using spreadsheet software and communicate the results to interested stakeholders.
General Assessment Information
It is the responsibility of students to view their marks for each within session assessment on iLearn within 20 days of posting. If there are any discrepancies, students must contact the unit convenor immediately. Failure to do so will mean that queries received after the release of final results regarding assessment tasks (not including the final exam mark) will not be addressed.
Extensions for the assignments and the case study:
No extensions will be granted. Late tasks will be accepted up to 72 hours after the submission deadline. There will be a deduction of 20% of the total available marks made from the total awarded mark for each 24 hour period or part thereof that the submission is late (for example, 25 hours late in submission – 40% penalty). This penalty does not apply for cases in which an application for special consideration is made and approved.
Assessment Tasks
| Name | Weighting | Due |
|---|---|---|
| Final Examination | 50% | Examination period |
| Case Study | 10% | Week 12 |
| Assignment 1 | 20% | Week 6 |
| Assignment 2 | 20% | Week 10 |
Final Examination
Due: Examination period
Weighting: 50%
Submission
THE EXAM WILL BE CONDUCTED EITHER DURING THE NORMAL EXAMINATION PERIOD OR JUST BEFORE IT. YOU MUST ATTEND AND DO THE EXAM IN THE NORMAL WAY
Extension
IF YOU DON'T ATTEND THE FINAL EXAM YOU WILL FAIL THE UNIT. IF YOU CAN'T ATTEND THE EXAM DUE TO ILLNESS OR MISADVENTURE YOU CAN APPLY FOR SPECIAL CONSIDERATION, BUT YOU MUST PROVIDE SUPPORTING EVIDENCE TO EXPLAIN WHY YOU DIDN'T ATTEND.
Penalties
IF YOU DON'T ATTEND THE FINAL EXAM AND YOU ARE GRANTED SPECIAL CONSIDERATION, YOU MAY HAVE TO SIT A SUPPLEMENTARY EXAM. OTHERWISE YOU WOULD FAIL THE UNIT.
On successful completion you will be able to:
- To gain an understanding of current established methods for the valuation and appraisal of investment projects, their advantages and disadvantages and the development of financial models for this purpose
- To gain an understanding of how to implement financial mathematics in an excel spreadsheet and to become adept in using some of excel's built in financial and statistical functions and other useful tools
- Develop an introductory understanding of the “real options approach” to investment appraisal
- To learn to use microsoft excel to build the financial models and perform the calculations to implement these methods
- Learn how to develop user defined functions using visual basic and use them from within excel
- Learn how to properly document a financial decision making problem and its solution using spreadsheet software and communicate the results to interested stakeholders.
Case Study
Due: Week 12
Weighting: 10%
Submission
SUBMIT YOUR WORD AND EXCEL FILES ELECTRONICALLY (METHOD TO BE ADVISED)
On successful completion you will be able to:
- To gain an understanding of how to implement financial mathematics in an excel spreadsheet and to become adept in using some of excel's built in financial and statistical functions and other useful tools
- Develop an introductory understanding of the “real options approach” to investment appraisal
- To learn to use microsoft excel to build the financial models and perform the calculations to implement these methods
- Learn how to properly document a financial decision making problem and its solution using spreadsheet software and communicate the results to interested stakeholders.
Assignment 1
Due: Week 6
Weighting: 20%
Submission
SUBMIT YOUR WORD AND EXCEL FILES ELECTRONICALLY (METHOD TO BE ADVISED)
On successful completion you will be able to:
- To gain an understanding of current established methods for the valuation and appraisal of investment projects, their advantages and disadvantages and the development of financial models for this purpose
- To gain an understanding of how to implement financial mathematics in an excel spreadsheet and to become adept in using some of excel's built in financial and statistical functions and other useful tools
- To learn to use microsoft excel to build the financial models and perform the calculations to implement these methods
Assignment 2
Due: Week 10
Weighting: 20%
Submission
SUBMIT YOUR WORD AND EXCEL FILES ELECTRONICALLY (METHOD TO BE ADVISED)
On successful completion you will be able to:
- To gain an understanding of current established methods for the valuation and appraisal of investment projects, their advantages and disadvantages and the development of financial models for this purpose
- To gain an understanding of how to implement financial mathematics in an excel spreadsheet and to become adept in using some of excel's built in financial and statistical functions and other useful tools
- To learn to use microsoft excel to build the financial models and perform the calculations to implement these methods
Delivery and Resources
Classes
For campus students:
- A 2-hour lecture will be held each week.
- A 1-hour tutorial / computer laboratory session will be held each week.
For distance students:
- All lecture and tutorial exercises and solutions will be available on iLearn.
- The timetable for classes can be found on the University web site at: http://www.timetables.mq.edu.au/
Required and Recommended Texts and/or Materials Prescribed
Textbooks:
There is no specific required text for this unit. However the following books are useful references:
- Capital budgeting: by Dayananda et al (ISBN 0 521 52098 3)
- Financial Modelling: by Simon Beninga (ISBN 0 262 02482 9)
- For the novice excel user, the book Teach Yourself Visually Excel 2003 by Maran
- (ISBN 0-7645-3996-5) is a good way to quickly learn the basics of excel assumed for this unit.
The recommended texts are not available from the Macquarie University Co-op Bookshop.
The recommended texts are not available in the Macquarie Library.
Technology Used and Required
- Students will require access to the internet to download lecture slides and tutorial solutions.
- The assignment and most tutorial exercises will require the use of word processing and/or spreadsheet programs.
- In most weeks we will be using excel spreadsheets for the various financial calculations needed. Our classes are held in a computer laboratory and all students will have access to a computer with the required software installed on it.
- Students will be instructed in how to use excel for the purposes of the unit.
Unit Web Page
Course material is available on the learning management system (iLearn)
The web page for this unit can be found at: [URL to be advised]
Teaching and Learning Activities
- The unit is taught via lectures, tutorial exercises and the use of spreadsheet software for implementing models and calculations for the purpose of financial decision making
- Each lecture is self-contained and structured according to the summary provided in the “weekly curriculum” section below. Students are expected to read the relevant lecture notes prior to the lecture, so that they are familiar with the material to be covered. This will greatly enhance your learning experience.
- Dealing with advanced material in our subject area requires a range of generic skills. This unit aims at developing such skills. The lectures and in particular the assignments and tutorial exercises are tailored to enhance critical analysis, problem-solving and creative thinking, comprehension, computing and writing skills.
- You should take the time to work on the problem sets, since they will tend to be similar in nature to the problems you see on the test and exam. Solutions will be provided.
- We cover many examples of financial valuation and decision making problems and how to solve these using spreadsheets. Our approach is one of learning by example and by practicing using excel to solve financial decision making problems.
Changes since last offering
- There have been no changes to this unit since the last offering in 2014
Unit Schedule
|
Important information: 1) Timetable for lectures is available at: https://timetables.mq.edu.au/2015/ 2) Semester dates: http://students.mq.edu.au/student_admin/enrolmentguide/academicdates/ 3) Weeks 1-6: 23rd February - 3rd April 2015, Weeks 7-13: 20th April - 5th June 2015, Mid Term Break 6th April - 17th April 2015 4) NSW public holidays: http://www.industrialrelations.nsw.gov.au/oirwww/NSW_public_holidays/NSW_Public_Holidays.page 5) Lectures this semester are scheduled for Friday 2-5pm. Friday of week 6 is 3rd april 2015 and this is a public holiday. No lecture that day. Lectures will be held in weeks 1-5 and 7-13 of semester 1. Lectures 1-5 will be in weeks 1-5 and lectures 6-12 will be in weeks 7-13 respectively |
|
week commencing |
week |
lecture |
content |
|
Monday, 23 February 2015 |
1 |
1 |
Basic Financial mathematics: Interest rates, present value, future value, annuities, perpetuities, bonds; intro to excel |
|
Monday, 2 March 2015 |
2 |
2 |
Introduction to capital budgeting. Further topics in financial mathematics: Present value and future value loans and leases, loan repayment schedules |
|
Monday, 9 March 2015 |
3 |
3 |
Project cashflows and methods for their estimation. Examples of asset expansion, retirement and replacement projects |
|
Monday, 16 March 2015 |
4 |
4 |
(i) Elementary methods of forecasting. (ii) Matrix algebra and implementation in excel |
|
Monday, 23 March 2015 |
5 |
5 |
(i) Analysis of leasing decisions, (ii) leveraged leases and their analysis using alternative measures of return. |
|
Monday, 30 March 2015 |
6 |
public holiday |
|
|
Monday, 6 April 2015 |
mid term break |
|
|
|
Monday, 13 April 2015 |
mid term break |
|
|
|
Monday, 20 April 2015 |
7 |
6 |
(i) Project evaluation methods: npv, irr, pp, arr. Application to asset replacement, retirement and expansion projects. (ii) Methods for choosing the discount rate for npv analysis. |
|
Monday, 27 April 2015 |
8 |
7 |
(i) Project evaluation methods: npv, irr, pp, arr. Application to asset replacement, retirement and expansion projects. (ii) Methods for choosing the discount rate for npv analysis. |
|
Monday, 4 May 2015 |
9 |
8 |
(i) Methods for estimating model parameters, (ii) Sensitivity and breakeven analysis: implementation in excel |
|
Monday, 11 May 2015 |
10 |
9 |
(1) Introduction to options and valuation via the black scholes model, (2) monte carlo simulation modelling for stock prices and option valuation |
|
Monday, 18 May 2015 |
11 |
10 |
Binomial option pricing methods and implementation in excel |
|
Monday, 25 May 2015 |
12 |
11 |
The flaws in the traditional methods of investment appraisal and introduction to the real options approach to valuation of projects with flexibility |
|
Monday, 1 June 2015 |
13 |
12 |
More on real options analysis: parameter estimation, embedded exotic options, application of exotic option valuation theory to real options examples |
Policies and Procedures
Macquarie University policies and procedures are accessible from Policy Central. Students should be aware of the following policies in particular with regard to Learning and Teaching:
Academic Honesty Policy http://mq.edu.au/policy/docs/academic_honesty/policy.html
Assessment Policy http://mq.edu.au/policy/docs/assessment/policy.html
Grading Policy http://mq.edu.au/policy/docs/grading/policy.html
Grade Appeal Policy http://mq.edu.au/policy/docs/gradeappeal/policy.html
Grievance Management Policy http://mq.edu.au/policy/docs/grievance_management/policy.html
Disruption to Studies Policy http://www.mq.edu.au/policy/docs/disruption_studies/policy.html The Disruption to Studies Policy is effective from March 3 2014 and replaces the Special Consideration Policy.
In addition, a number of other policies can be found in the Learning and Teaching Category of Policy Central.
Student Code of Conduct
Macquarie University students have a responsibility to be familiar with the Student Code of Conduct: https://students.mq.edu.au/support/student_conduct/
Results
Results shown in iLearn, or released directly by your Unit Convenor, are not confirmed as they are subject to final approval by the University. Once approved, final results will be sent to your student email address and will be made available in eStudent. For more information visit ask.mq.edu.au.
Supplementary Exams Policy
http://www.businessandeconomics.mq.edu.au/current_students/undergraduate/how_do_i/special_consideration
Student Support
Macquarie University provides a range of support services for students. For details, visit http://students.mq.edu.au/support/
Learning Skills
Learning Skills (mq.edu.au/learningskills) provides academic writing resources and study strategies to improve your marks and take control of your study.
Student Services and Support
Students with a disability are encouraged to contact the Disability Service who can provide appropriate help with any issues that arise during their studies.
Student Enquiries
For all student enquiries, visit Student Connect at ask.mq.edu.au
IT Help
For help with University computer systems and technology, visit http://informatics.mq.edu.au/help/.
When using the University's IT, you must adhere to the Acceptable Use Policy. The policy applies to all who connect to the MQ network including students.
Graduate Capabilities
PG - Discipline Knowledge and Skills
Our postgraduates will be able to demonstrate a significantly enhanced depth and breadth of knowledge, scholarly understanding, and specific subject content knowledge in their chosen fields.
This graduate capability is supported by:
Learning outcomes
- To gain an understanding of current established methods for the valuation and appraisal of investment projects, their advantages and disadvantages and the development of financial models for this purpose
- To gain an understanding of how to implement financial mathematics in an excel spreadsheet and to become adept in using some of excel's built in financial and statistical functions and other useful tools
- Develop an introductory understanding of the “real options approach” to investment appraisal
- To learn to use microsoft excel to build the financial models and perform the calculations to implement these methods
- Learn how to develop user defined functions using visual basic and use them from within excel
- Learn how to properly document a financial decision making problem and its solution using spreadsheet software and communicate the results to interested stakeholders.
Assessment tasks
- Final Examination
- Case Study
- Assignment 1
- Assignment 2
PG - Critical, Analytical and Integrative Thinking
Our postgraduates will be capable of utilising and reflecting on prior knowledge and experience, of applying higher level critical thinking skills, and of integrating and synthesising learning and knowledge from a range of sources and environments. A characteristic of this form of thinking is the generation of new, professionally oriented knowledge through personal or group-based critique of practice and theory.
This graduate capability is supported by:
Learning outcomes
- To gain an understanding of current established methods for the valuation and appraisal of investment projects, their advantages and disadvantages and the development of financial models for this purpose
- To gain an understanding of how to implement financial mathematics in an excel spreadsheet and to become adept in using some of excel's built in financial and statistical functions and other useful tools
- Develop an introductory understanding of the “real options approach” to investment appraisal
- To learn to use microsoft excel to build the financial models and perform the calculations to implement these methods
- Learn how to develop user defined functions using visual basic and use them from within excel
- Learn how to properly document a financial decision making problem and its solution using spreadsheet software and communicate the results to interested stakeholders.
Assessment tasks
- Final Examination
- Case Study
- Assignment 1
- Assignment 2
PG - Research and Problem Solving Capability
Our postgraduates will be capable of systematic enquiry; able to use research skills to create new knowledge that can be applied to real world issues, or contribute to a field of study or practice to enhance society. They will be capable of creative questioning, problem finding and problem solving.
This graduate capability is supported by:
Learning outcomes
- To gain an understanding of current established methods for the valuation and appraisal of investment projects, their advantages and disadvantages and the development of financial models for this purpose
- To gain an understanding of how to implement financial mathematics in an excel spreadsheet and to become adept in using some of excel's built in financial and statistical functions and other useful tools
- Develop an introductory understanding of the “real options approach” to investment appraisal
- To learn to use microsoft excel to build the financial models and perform the calculations to implement these methods
- Learn how to develop user defined functions using visual basic and use them from within excel
- Learn how to properly document a financial decision making problem and its solution using spreadsheet software and communicate the results to interested stakeholders.
Assessment tasks
- Final Examination
- Case Study
- Assignment 1
- Assignment 2
Changes from Previous Offering
no changes
Research and Practice
- This unit gives you practice in applying research findings in your assignments
- This unit gives you opportunities to conduct your own research