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...
| Main Author: | |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English English |
| Published: |
2015
|
| Subjects: | |
| Online Access: | https://repo.uum.edu.my/id/eprint/23471/1/NCSC%202015%201%2011.pdf https://repo.uum.edu.my/id/eprint/23471/2/NCSC%202015%201%2012.pdf |
| _version_ | 1825804929831272448 |
|---|---|
| author | Ku Ismail, Ku Nor Izah |
| author_facet | Ku Ismail, Ku Nor Izah |
| author_sort | Ku Ismail, Ku Nor Izah |
| collection | UUM |
| 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. |
| first_indexed | 2024-07-04T06:23:40Z |
| format | Conference or Workshop Item |
| id | uum-23471 |
| institution | Universiti Utara Malaysia |
| language | English English |
| last_indexed | 2024-07-04T06:23:40Z |
| publishDate | 2015 |
| record_format | eprints |
| spelling | uum-234712018-02-15T01:56:43Z https://repo.uum.edu.my/id/eprint/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 https://repo.uum.edu.my/id/eprint/23471/1/NCSC%202015%201%2011.pdf application/pdf en https://repo.uum.edu.my/id/eprint/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. |
| spellingShingle | HD28 Management. Industrial Management Ku Ismail, Ku Nor Izah Gez petrol station: Spreadsheet modelling for capital budgeting |
| title | 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_short | Gez petrol station: Spreadsheet modelling for capital budgeting |
| title_sort | gez petrol station spreadsheet modelling for capital budgeting |
| topic | HD28 Management. Industrial Management |
| url | https://repo.uum.edu.my/id/eprint/23471/1/NCSC%202015%201%2011.pdf https://repo.uum.edu.my/id/eprint/23471/2/NCSC%202015%201%2012.pdf |
| work_keys_str_mv | AT kuismailkunorizah gezpetrolstationspreadsheetmodellingforcapitalbudgeting |