Gez petrol station: Spreadsheet modelling for capital budgeting

• Main Author: Ku Ismail, Ku Nor Izah
• Format: Conference or Workshop Item
• Language: English; English
• Published: 2015
• Subjects: HD28 Management. Industrial Management
• Online Access: http://repo.uum.edu.my/23471/1/NCSC%202015%201%2011.pdf; http://repo.uum.edu.my/23471/2/NCSC%202015%201%2012.pdf; http://repo.uum.edu.my/23471/
• Institution: Universiti Utara Malaysia

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 enablethem 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.