Gez petrol station: Spreadsheet modelling for capital budgeting

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

全面介紹

Saved in:
書目詳細資料
主要作者: Ku Ismail, Ku Nor Izah
格式: Conference or Workshop Item
語言:English
English
出版: 2015
主題:
在線閱讀: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/
標簽: 添加標簽
沒有標簽, 成為第一個標記此記錄!
id my.uum.repo.23471
record_format eprints
spelling my.uum.repo.234712018-02-15T01:56:43Z http://repo.uum.edu.my/23471/ Gez petrol station: Spreadsheet modelling for capital budgeting Ku Ismail, Ku Nor Izah HD28 Management. Industrial Management 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. 2015-10-06 Conference or Workshop Item PeerReviewed application/pdf en http://repo.uum.edu.my/23471/1/NCSC%202015%201%2011.pdf application/pdf en http://repo.uum.edu.my/23471/2/NCSC%202015%201%2012.pdf 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.
institution Universiti Utara Malaysia
building UUM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Utara Malaysia
content_source UUM Institutionali Repository
url_provider http://repo.uum.edu.my/
language English
English
topic HD28 Management. Industrial Management
spellingShingle HD28 Management. Industrial Management
Ku Ismail, Ku Nor Izah
Gez petrol station: Spreadsheet modelling for capital budgeting
description 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.
format Conference or Workshop Item
author Ku Ismail, Ku Nor Izah
author_facet Ku Ismail, Ku Nor Izah
author_sort Ku Ismail, Ku Nor Izah
title Gez petrol station: Spreadsheet modelling for capital budgeting
title_short Gez petrol station: Spreadsheet modelling for capital budgeting
title_full Gez petrol station: Spreadsheet modelling for capital budgeting
title_fullStr Gez petrol station: Spreadsheet modelling for capital budgeting
title_full_unstemmed Gez petrol station: Spreadsheet modelling for capital budgeting
title_sort gez petrol station: spreadsheet modelling for capital budgeting
publishDate 2015
url 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/
_version_ 1644283790169735168
score 13.154949