Case-Study Digitalised Repository (CDR)
Real world business scenarios for the classroom
Teaching cases offer students the opportunity to explore real world challenges in the classroom environment, allowing them to test their assumptions and decision-making skills before taking their knowledge into the workplace. Management and Leadership Case Study Centre, Universiti Utara Malaysia specialises in case content from, and about, emerging markets – regions which are traditionally underrepresented in teaching case collections, but which offer unique and important insights. Through digitalisation, we intend to ease and increase accesses for, and usages of, our teaching cases as well as to widen our user-base to not only for local academics/trainers, but also for our international counterparts.
http://cdr.uum.edu.my/jspui/handle/123456789/29| Title: | GEZ Petrol Station: Spreadsheet Modelling for Capital Budgetting |
| Authors: | Ku Ismail, Ku Nor Izah Wan Hussin, Wan Nordin |
| Issue Date: | 2015 |
| Publisher: | IMBRe |
| Abstract: | Purpose – This case requires students to prepare a good financial model to find the net present value of the business and make a capital budgeting decision, using Excel spreadsheet. In order to prepare the capital budget, students need to prepare a cash flow statement by business segments. The financial model should be sufficiently flexible to allow various what if analysis to be performed. Students should be able to apply what if analysis tools in Excel such as Goal Seek and Data Tables. Design/methodology/ approach - The operational and financial data are obtained from the owner of Baron Service Station. Other data are obtained through interviews with the area manager of GEZ Berhad and websites of the relevant institutions. Findings – The case is suitable for Management Accounting, Financial Modelling, Integrated Case Study, Financial Management courses, both at the undergraduate and postgraduate levels, and Executive Development Programme on Entrepreneurship for business entrepreneurs and sole proprietors. Value of the paper – This case is expected to enhance students’ critical thinking and enable them to integrate IT in decision making decisions. This is one of the avenues where lecturers can integrate IT in teaching and learning, in line with the requirements of the accounting profession and Ministry of Education of Malaysia. Besides being able to design a financial model, students at the same time should be able to assume the role of a user and use the model in making business decisions. |
| URI: | http://cdr.uum.edu.my/jspui/handle/123456789/29 |
| Appears in Collections: | Cases in CDR |
| File | Description | Size | Format | |
|---|---|---|---|---|
| (TC090-1) GEZ PETROL STATION SPREADSHEET MODELLING FOR CAPITAL BUDGETING.pdf | 427.22 kB | Adobe PDF |  View/Open |
Items in IMBRE Repository are protected by copyright, with all rights reserved, unless otherwise indicated.