Capital Budgeting Analysis, Sensitivity Analysis, and Monte Carlo Simulator for Mbah Jingkrak's New Outlet
Main Authors: | Maharani, Nadia Putri, Murtaqi, Isrochmani |
---|---|
Format: | Article info eJournal |
Bahasa: | eng |
Terbitan: |
The Indonesian Journal of Business Administration
, 2015
|
Online Access: |
http://journal.sbm.itb.ac.id/index.php/IJBA/article/view/1587 |
ctrlnum |
article-1587 |
---|---|
fullrecord |
<?xml version="1.0"?>
<dc schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/ http://www.openarchives.org/OAI/2.0/oai_dc.xsd"><title lang="en-US">Capital Budgeting Analysis, Sensitivity Analysis, and Monte Carlo Simulator for Mbah Jingkrak's New Outlet</title><creator>Maharani, Nadia Putri</creator><creator>Murtaqi, Isrochmani</creator><description lang="en-US">Abstract.This research was conducted in order to assess the expansion plan of Mbah Jingkrak, a Javanese traditional restaurant located, that is going to build new outlet in Serpong, South Tangerang. The objective of this research is to make sure that the investment will give positive financial outcome to the company. In order to give clear projection of its financial performance, 3 steps of study are conducted, which are feasibility study for capital budgeting assessment, sensitivity analysis, and Monte Carlo Simulation. The results of feasibility study shows that the NPV of the project is positive, the internal rate of return exceed the project’s cost of capital, and there are no indications of negative cash flow, which show that the project of the expansion plan is financially feasible and viable. On the next step, which is sensitivity analysis, the project shows that the 4 most sensitive factors are: the cost of raw materials, the first year occupancy, spending per customer, and the growth of restaurant’s occupancy. These 4 most sensitive factors need to have higher attention from management since these factors have the lowest tolerance scale and need to be kept as close as possible to the assumptions in order to maintain positive financial outcome. Lastly, under Monte Carlo Simulation, the project shows a promising result, where the probability of expecting positive Net Present Value is above 85,90%, supported with only 3,80% probability of cash shortage. These indicators lead to a conclusion that the restaurant’s plan to open new outlet should be executed. Using these conclusions, Mbah Jingkrak can design implementation plan for its new outlet. The implementation of these results includes setting sales and cost target, complemented with menu combination and innovation to increase customer’s spending and restaurant’s occupancy.Keywords : Capital Budgeting, Feasibility Study, Sensitivity Analysis, Monte Carlo Simulation. </description><publisher lang="en-US">The Indonesian Journal of Business Administration</publisher><contributor lang="en-US"/><date>2015-06-20</date><type>Journal:Article</type><type>Other:info:eu-repo/semantics/publishedVersion</type><type>Journal:Article</type><identifier>http://journal.sbm.itb.ac.id/index.php/IJBA/article/view/1587</identifier><source lang="en-US">The Indonesian Journal of Business Administration; Vol 4, No 5 (2015)</source><source>2252-9284</source><source>2252-3464</source><language>eng</language><recordID>article-1587</recordID></dc>
|
language |
eng |
format |
Journal:Article Journal Other:info:eu-repo/semantics/publishedVersion Other Journal:eJournal |
author |
Maharani, Nadia Putri Murtaqi, Isrochmani |
title |
Capital Budgeting Analysis, Sensitivity Analysis, and Monte Carlo Simulator for Mbah Jingkrak's New Outlet |
publisher |
The Indonesian Journal of Business Administration |
publishDate |
2015 |
url |
http://journal.sbm.itb.ac.id/index.php/IJBA/article/view/1587 |
contents |
Abstract.This research was conducted in order to assess the expansion plan of Mbah Jingkrak, a Javanese traditional restaurant located, that is going to build new outlet in Serpong, South Tangerang. The objective of this research is to make sure that the investment will give positive financial outcome to the company. In order to give clear projection of its financial performance, 3 steps of study are conducted, which are feasibility study for capital budgeting assessment, sensitivity analysis, and Monte Carlo Simulation. The results of feasibility study shows that the NPV of the project is positive, the internal rate of return exceed the project’s cost of capital, and there are no indications of negative cash flow, which show that the project of the expansion plan is financially feasible and viable. On the next step, which is sensitivity analysis, the project shows that the 4 most sensitive factors are: the cost of raw materials, the first year occupancy, spending per customer, and the growth of restaurant’s occupancy. These 4 most sensitive factors need to have higher attention from management since these factors have the lowest tolerance scale and need to be kept as close as possible to the assumptions in order to maintain positive financial outcome. Lastly, under Monte Carlo Simulation, the project shows a promising result, where the probability of expecting positive Net Present Value is above 85,90%, supported with only 3,80% probability of cash shortage. These indicators lead to a conclusion that the restaurant’s plan to open new outlet should be executed. Using these conclusions, Mbah Jingkrak can design implementation plan for its new outlet. The implementation of these results includes setting sales and cost target, complemented with menu combination and innovation to increase customer’s spending and restaurant’s occupancy.Keywords : Capital Budgeting, Feasibility Study, Sensitivity Analysis, Monte Carlo Simulation. |
id |
IOS2617.article-1587 |
institution |
Institut Teknologi Bandung |
affiliation |
onesearch.perpusnas.go.id |
institution_id |
79 |
institution_type |
library:university library |
library |
Perpustakaan Institut Teknologi Bandung |
library_id |
100 |
collection |
The Indonesian Journal of Business Administration |
repository_id |
2617 |
city |
KOTA BANDUNG |
province |
JAWA BARAT |
repoId |
IOS2617 |
first_indexed |
2016-09-21T13:29:20Z |
last_indexed |
2018-11-16T02:49:58Z |
recordtype |
dc |
merged_child_boolean |
1 |
_version_ |
1685803018066329600 |
score |
17.60897 |