Submitted:
07 March 2025
Posted:
08 March 2025
You are already at the latest version
Abstract
Keywords:
1. Introduction
1.1. Background & Significance
1.2. Objectives
-
Assess the financial viability of luxury villa development in Canggu, BaliThis study will evaluate whether investing in luxury villas in Canggu is financially feasible by analyzing key financial metrics such as Net Present Value (NPV), Internal Rate of Return (IRR), Payback Period, and Profitability Index (PI). By incorporating detailed cost estimations, projected revenue streams, and operational expenses, the study aims to determine if the expected financial returns justify the required capital investment. The analysis will also consider macroeconomic factors such as inflation, interest rates, and tourism demand trends that influence investment viability.
-
Compare different development scenarios (15, 20, and 25 villas) to determine the optimal investment scaleTo provide investors with a clear decision-making framework, this study evaluates three alternative development scenarios: a low-density model with 15 villas, a balanced mid-scale development with 20 villas, and a high-capacity option with 25 villas. Each scenario presents unique trade-offs between construction costs, expected revenue, operational efficiency, and return on investment. By comparing these models, the study seeks to identify the most financially optimal scale of development, balancing investment risks and profitability.
-
Integrate sustainability considerations into real estate investment decisionsWith the increasing importance of Environmental, Social, and Governance (ESG) factors in real estate investment, this study explores how sustainability initiatives can impact both financial performance and long-term asset value. Key aspects include green building certifications, renewable energy adoption, waste management, and water conservation strategies. The study will examine how integrating sustainable practices can not only reduce operational costs but also enhance investor appeal and market competitiveness, aligning with global trends in responsible property development.
-
Provide actionable insights for investors on risk mitigation and financing strategiesReal estate investments, particularly in emerging tourism markets, are subject to various financial, operational, and regulatory risks. This study aims to identify potential risks such as market fluctuations, changes in government regulations, and shifts in consumer preferences. Additionally, it will explore strategies for risk mitigation, including diversified financing options, phased construction approaches, and adaptive pricing models. By offering practical recommendations, the study intends to equip investors with the knowledge needed to make informed, data-driven investment decisions while maximizing returns and minimizing exposure to external uncertainties.
2. Literature Review
2.1. Investment Feasibility in Real Estate
2.2. Sustainable Tourism and ESG in Hospitality Development
2.3. Sensitivity Analysis in Real Estate Investments
2.4. Post-Pandemic Shifts in the Luxury Hospitality Market
2.5. The Novelty of This Study
3. Methodology
3.1. Net Present Value (NPV) Calculation
- = Net cash flow in year t
- r = Discount rate (12%)
- = Initial investment
- = Investment period (10 years)
- Initial Investment: IDR 243.38 billion
- Annual Net Cash Flow: IDR 25.62 billion
- (Annual Revenue: IDR 32.03B - Operating Cost: IDR 6.41B)
3.2. Internal Rate of Return (IRR) Calculation
- Initial Investment: IDR 275 billion
- Annual Net Cash Flow: IDR 30.25 billion
- (Annual Revenue: IDR 37.81B - Operating Cost: IDR 7.56B)
3.3. Payback Period Calculation
- Initial Investment: IDR 211.75 billion
- Annual Net Cash Flow: IDR 21.35 billion
- (Annual Revenue: IDR 26.69B - Operating Cost: IDR 5.34B)
3.4. Sensitivity Analysis: Impact of Occupancy Rate
- Original Revenue (65%): IDR 32.03B
- Revenue (60%):
- Net Cash Flow: IDR 23.15 billion
- NPV for 20 Villas: IDR 35.2B (down from 50.80B)
4. Data Sources and Results
4.1. Cost Structure and Investment Estimates
4.2. Revenue Projections and Operating Costs
4.3. Financial Assumptions for NPV and IRR Calculations
4.4. Sensitivity Analysis: Impact of Occupancy Rate
- Government & Institutional Reports (e.g., Indonesia Tourism Board, Bank Indonesia, and Construction Cost Indices).
- Market Research & Industry Studies (e.g., Bali Hospitality Market Reports and Real Estate Financing Trends).
- Academic Literature & Investment Models (e.g., Geltner et al., 2018 – Real Estate Investment Analysis).
4.5. Discussion of Results
5. Conclusions
References
- Badan Pusat Statistik. (2023). Tourism Statistics of Indonesia. Jakarta, Indonesia: BPS.
- Geltner, D., Miller, N. G., Clayton, J., & Eichholtz, P. (2018). Commercial real estate analysis and investments (4th ed.). South-Western Cengage Learning.
- Hoesli, M., & MacGregor, B. D. (2014). Property investment: Principles and practice of portfolio management (2nd ed.). Routledge.
- Ling, D. C., & Archer, W. R. (2022). Real estate principles: A value approach (6th ed.). McGraw Hill.
- Novelli, M., Schmitz, B., & Spencer, T. (2022). The changing dynamics of high-end tourism and real estate development. Journal of Tourism Economics, 29(3), 455-470.
- Pranata, Y., & Widodo, R. (2023). Foreign investment trends in Bali’s luxury hospitality sector: A sustainability perspective. Asian Real Estate Journal, 18(2), 215-230.
- United Nations Environment Programme (UNEP). (2022). Sustainable real estate development: A global review of green building initiatives. UNEP Publications.
- United Nations World Tourism Organization (UNWTO). (2023). Sustainable tourism report: Post-pandemic hospitality market shifts. UNWTO.
- World Travel & Tourism Council. (2023). Hospitality market trends post-pandemic. WTTC Publications.
- Indonesia Tourism Board. (2024). Bali hospitality market analysis. Jakarta, Indonesia: ITB.
- Bank Indonesia. (2024). Real estate financing report. Jakarta, Indonesia: Bank Indonesia.
- Indonesia Hospitality Performance Review. (2024). Luxury hotel and villa occupancy trends in Bali. Jakarta, Indonesia: IHPR.
- Indonesia Property Investment Guidelines. (2024). Investment trends and regulatory frameworks in Indonesia. Jakarta, Indonesia: Ministry of Investment.
- Bali Land Market Report. (2024). Market value trends for prime development sites in Bali. Jakarta, Indonesia: Real Estate Indonesia.
- Indonesia Construction Cost Index. (2024). Benchmark data for luxury resort projects in Bali. Jakarta, Indonesia: Ministry of Public Works.
- Hospitality Business Operations Report. (2024). Cost structures and operational benchmarks for luxury hotels and resorts. Jakarta, Indonesia: HBOR.
| Metric | 15 Villas | 20 Villas | 25 Villas |
| NPV (Billion IDR) | 18.22 | 50.80 | 32.59 |
| IRR (%) | 11.76 | 12.71 | 13.69 |
| Payback Period (years) | 7.17 | 6.9 | 6.7 |
| Expense Category | 15 Villas (IDR B) | 20 Villas (IDR B) | 25 Villas (IDR B) |
| Land Acquisition | 105 | 105 | 105 |
| Construction Costs | 70 | 93 | 116 |
| Interior & Furnishings | 17.5 | 23.25 | 29 |
| Contingency (10%) | 19.25 | 22.13 | 25 |
| Total Investment | 211.75 | 243.38 | 275 |
| Metric | 15 Villas | 20 Villas | 25 Villas |
| Room Rate (IDR/night) | 7.5M | 6.75M | 6.375M |
| Occupancy Rate | 65% | 65% | 65% |
| Annual Revenue (IDR B) | 26.69 | 32.03 | 37.81 |
| Operating Cost (IDR B) | 5.34 | 6.41 | 7.56 |
| Financial Parameter | Value Used | Source |
| Discount Rate (r) | 12% | Industry-standard for real estate investments in Indonesia (Bank Indonesia Real Estate Financing Report, 2024). |
| Investment Horizon (n) | 10 years | Common project lifespan for luxury villa developments (Indonesia Property Investment Guidelines, 2024). |
| Growth Rate | 7% | Projected increase in room rates and demand (Bali Tourism Market Analysis, 2024). |
| Occupancy Rate | 15 Villas NPV (B IDR) | 20 Villas NPV (B IDR) | 25 Villas NPV (B IDR) |
| 60% | 10.5 | 35.2 | 21.8 |
| 65% (Base Case) | 18.2 | 50.8 | 32.6 |
| 70% | 26.1 | 68.4 | 46.3 |
| Metric | 15 Villas | 20 Villas | 25 Villas |
| Total Investment (IDR B) | 211.75 | 243.38 | 275.00 |
| NPV (IDR B, 65% Occupancy) | 18.22 | 50.80 | 32.59 |
| IRR (%) | 11.76 | 12.71 | 13.69 |
| Payback Period (Years) | 7.17 | 6.9 | 6.7 |
| Annual Revenue (IDR B) | 26.69 | 32.03 | 37.81 |
| Operating Cost (IDR B) | 5.34 | 6.41 | 7.56 |
| NPV at 60% Occupancy (IDR B) | 10.5 | 35.2 | 21.8 |
| NPV at 70% Occupancy (IDR B) | 26.1 | 68.4 | 46.3 |
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. |
© 2025 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (http://creativecommons.org/licenses/by/4.0/).