Please use this identifier to cite or link to this item: 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
Payment Link: http://epay.uum.edu.my/go.php?billcode=CDRCASE&productid=TC090-1
Appears in Collections:Cases in CDR

Files in This Item:
There are no files associated with this item.


Items in CDR Repository are protected by copyright, with all rights reserved, unless otherwise indicated.