Feasibility Study of PT XYZ's Villa Project In Seminyak, Bali
DOI:
https://doi.org/10.58229/jims.v2i1.159Keywords:
Villa Development, Tourism Recovery, Financial Feasibility, Capital Budgeting, Risk AssessmentAbstract
The tourism industry in Bali, a cornerstone of the local economy, faced a severe downturn due to COVID-19, resulting in declines in tourist arrivals and accommodations. However, the sector has seen a robust recovery, with tourist arrivals now exceeding pre-pandemic levels. Despite this, accommodations recovery has lagged, presenting a significant investment opportunity. PT XYZ aims to capitalize on this by developing a luxury villa in Seminyak, targeting the middle-to-upper tourist market. The planned investment of IDR 2,109,848,475 will be fully financed through equity. This study assesses the financial feasibility and potential risks of the project. It involves constructing pro forma financial statements to forecast operations over 20 years, followed by detailed cash flow analysis. Key metrics such as Free Cash Flow (FCF) and Terminal Cash Flow are calculated, and the Weighted Average Cost of Capital (WACC) is used to discount future cash flows. The analysis employs Net Present Value (NPV), Internal Rate of Return (IRR), Profitability Index (PI), Payback Period, and Discounted Payback Period to evaluate financial returns and investment recovery time. The study indicates a positive NPV of IDR 1.6 billion and an IRR of 19.36%, suggesting substantial returns over the cost of capital. The project’s profitability index of 1.77 underscores its value generation potential, while the payback period and discounted payback period, at 6.06 years and 9.07 years respectively, highlight its efficiency in recouping investments well within its useful life. Risk assessment through sensitivity analysis and Monte Carlo simulations highlights daily and occupancy rates as critical factors, with a low 4.5% probability of a negative NPV. Strategic recommendations include dynamic pricing, enhancing guest experience with exclusive amenities, and listing the property on multiple Online Travel Agencies (OTAs) to boost visibility and bookings.
References
Ahmed, F., Rahman, M. U., Rehman, H. M., Imran, M., Dunay, A., & Hossain, M. B. (2024). Corporate capital structure effects on corporate performance pursuing a strategy of innovation in manufacturing companies. Heliyon. doi: https://doi.org/10.1016/j.heliyon.2024.e24677.
Anand, M. (2002). Corporate finance practices in India: A survey. Vikalpa: The Journal for Decision Makers.
Badan Pusat Statistik Provinsi Bali. (2024). Banyaknya Wisatawan Mancanegara Bulanan ke Bali Menurut Pintu Masuk (Orang), 2023. https://bali.bps.go.id/indicator/16/106/2/banyaknya-wisatawan-mancanegara-bulanan-ke-bali-menurut-pintu-masuk.html.
Badan Pusat Statistik Provinsi Bali. (2024). Number of Domestic Visitor to Bali by Month, 2004-2023. https://bali.bps.go.id/statictable/2018/02/09/29/kunjungan-wisatawan-domestik-ke-bali-per-bulan-2004-2018.html.
Badan Pusat Statistik Provinsi Bali. (2022). Banyaknya Tempat Tidur pada Hotel Non Bintang dan Akomodasi Lainnya Menurut Kelompok Kamar dan Kabupaten/Kota di Provinsi Bali 2020-2022. https://bali.bps.go.id/indicator/16/313/1/jumlah-tempat-tidur-pada-hotel-non-bintang-dan-akomodasi-lainnya-menurut-kelompok-kamar-dan-kabupaten-kota-di-provinsi-bali.html.
Badan Pusat Statistik Provinsi Bali. (2022). Banyaknya Kamar pada Hotel Bintang Menurut Kelas dan Kabupaten/Kota di Provinsi Bali 2020-2022. https://bali.bps.go.id/indicator/16/223/1/banyaknya-kamar-pada-hotel-bintang-menurut-kelas-dan-kabupaten-kota-di-provinsi-bali.html.
Bank Indonesia. (2019). Survei Harga Properti Residential. https://www.bi.go.id/id/publikasi/laporan/Documents/SHPR_Tw1_2019.pdf
Batra, R., & Verma, S. (2014). An Empirical Insight into Different Stages of Capital Budgeting. Global Business Review. doi: https://doi.org/10.1177/0972150914523588.
Bodenhorn, D. (1964). A Cash-flow Concept of Profit. The Journal of Finance. doi: https://doi.org/10.2307/2977477.
Bowen, D. J., Kreuter, M., Spring, B., Cofta-Woerpel, L., Linnan, L., Weiner, D., Bakken, S., Kaplan, C. P., Squiers, L., Fabrizio, C., & Fernandez, M. (2009). How We Design Feasibility Studies. American Journal of Preventive Medicine. doi: https://doi.org/10.1016/j.amepre.2009.02.002.
Brealey, R. A., Myers, S. C., & Allen, F. (2019). Principles of Corporate Finance. McGraw-Hill Education.
Brigham, E. F., & Ehrhardt, M. C. (2017). Financial Management: Theory & Practice. Cengage Learning.
Damodaran, A. (2012). Investment Valuation: Tools and Techniques for Determining the Value of Any Asset, University Edition. Wiley.
Damodaran, A. (2024). Beta, Unlevered beta and other risk measures in emerging markets. Damodaran ONLINE. https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datacurrent.html#discrate.
El-Sharkawy, A. (2005). Economic Feasibility Studies. Pathways to Higher Education.
Gitman, L. J., & Zutter, C. J. (2015). Principles of Managerial Finance, PDF EBook, Global Edition. Pearson Education.
Green, H., & Moore, T. (2020). Effective Interest Rate: A Comprehensive Measure of Borrowing Costs. Financial Practices Review.
Horwathhtl.com. (2004). Bali Hotel & Branded Residences. https://horwathhtl.com/publication/bali-hotel-branded-residences/.
Indonesia Stock Exchange. (2024). Indonesia Government Securities Yield Curve (IGSYC). https://www.idx.co.id/en/market-data/bonds-sukuk/indonesia-government-securities-yield-curve-igsyc/
Jebrin, A. H. (2017). The Theoretical Strategic Approach in the Feasibility Study. Journal of Economics, Management and Trade. doi: https://doi.org/10.9734/JEMT/2017/36268.
Jensen, M. C. (1986). Agency costs of free cash flow, corporate finance, and takeovers. American Economic Review. doi: https://doi.org/10.2139/ssrn.99580.
Johnson, A. (2023). Sensitivity Analysis in Risk Management. Journal of Risk Management.
Kementrian Keuangan Republik Indonesia. (2021). Kajian Fiskal Regional Provinsi Bali .https://djpb.kemenkeu.go.id/portal/images/file_artikel/file_pdf/kfr/2021/22_Bali.pdf.
Leon, F. M., Isa, M., & Kester, G. W. (2008). Capital Budgeting Practices of Listed Indonesian Companies. Asian Journal of Business and Accounting.
Maulana, A., & Koesfardani, C. F. P. P. (2020). Seasonal Pattern of Foreign Tourist Arrivals to Bali. Jurnal Kepariwisataan Indonesia.
Ministry of Finance of the Republic of Indonesia. (2023). Regulation of the Minister of Finance No. 72/PMK.03/2023 on Depreciation of Tangible Assets and/or Amortization of Intangible Assets. https://jdih.kemenkeu.go.id/download/46cededa-86ae-4cc9-93e5-b6bef8892074/2023pmkeuangan072.pdf.
Newlove, G.H. (1927). Depreciation. Journal of Accountancy.
Penman, S. H. (2010). Financial Statement Analysis and Security Valuation. McGraw-Hill/Irwin.
President of the Republic of Indonesia. (2017, September 11). Government Regulation of the Republic of Indonesia Number 34 of 2017 on Income Tax on Income from the Rental of Land and/or Buildings. Ministry of Law and Human Rights of the Republic of Indonesia.
Rayburn, J. (1986). The association of operating cash flow and accruals with security returns. Journal of Accounting Research.
Richardson, S. (2020). Sensitivity Analysis in Capital Budgeting: A Practical Guide. Journal of Business Forecasting.
Santos, A. M., Cincera, M., & Cerulli, G. (2023). Sources of financing: Which ones are more effective in innovation–growth linkage? Economic Systems. doi: https://doi.org/10.1016/j.ecosys.2023.101177.
Shen, L.-Y., Tam, V. W.Y., Tam, L., & Ji, Y. (2009). Project feasibility study: the key to successful implementation of sustainable and socially responsible construction management practice. Journal of Cleaner Production. doi: https://doi.org/10.1016/j.jclepro.2009.10.014.
Smith, J. (2019). The enduring relevance of traditional capital budgeting techniques. Finance Today.
Toit, M. J. D., & Pienaar, A. (2005). A Review of The Capital Budgeting Behavior of Large South African Firms. Meditari Accountancy Research. doi: https://doi.org/10.1108/10222529200500002.
Weston, J. F., & Brigham, E. F. (1981). Managerial Finance, Dryden Press.
Whitfield, R.I., & Duffy, A.H.B. (2013). Extended revenue forecasting within a service industry. Int. J. Production Economics. doi: https://doi.org/10.1016/j.ijpe.2011.11.015.
Wilson, R. (2021). Tax Benefits of Debt Financing. Corporate Finance Journal.
Zhang, X., & Liu, H. (2018). Understanding Yield to Maturity: Implications for Corporate Debt Management. Journal of Financial Analysis.
