Ku Ismail, Ku Nor Izah (2015) Gez petrol station: Spreadsheet modelling for capital budgeting. In: 2nd National Case Study Conference 2015, 6th- 8th October 2015, Kuching, Sarawak, Malaysia.

Preview	PDF (TEACHING CASE) Download (154kB) | Preview
Preview	PDF (TEACHING NOTES) Download (496kB) | Preview

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

Item Type:	Conference or Workshop Item (Paper)
Additional Information:	eISBN: 978-967-11030-4-3 Organized by: Institute for Management and Business Research (IMBRe) Universiti Utara Malaysia
Subjects:	H Social Sciences > HD Industries. Land use. Labor > HD28 Management. Industrial Management
Divisions:	Tunku Puteri Intan Safinaz School of Accountancy (TISSA)
Depositing User:	Mrs. Norazmilah Yaakub
Date Deposited:	15 Feb 2018 01:56
Last Modified:	15 Feb 2018 01:56
URI:	https://repo.uum.edu.my/id/eprint/23471

Actions (login required)

View Item