Abstract :

After the financial sector underwent a dramatic transformation in 2020, primarily brought on by the COVID-19 Pandemic, certain areas of the market have recovered while others are still struggling to recover from the financial losses brought on by the pandemic. Despite the drop of sales, and the growth trend was declining. PT. Tirta Chemoil show a good trend of oil sales that shows it is gradually increasing from 2018 which means that oil industry is generating a good revenue to the company. Thus, being told that there is an opportunity to be an agent of brand R, the stakeholder asked me to do the financial feasibility study to see whether their investment are worth it and able to generate a return in 10 years ahead. The research objectives on this study mainly about the feasibility of the company invest in being an agent for the lubricants oil brand. The feasibility study mainly use the indicator on discounted cash flow (DCF) such as net present value (NPV), internal rate of return (IRR), Profitability Index (PI), and payback period. This feasibility study use sensitivity analysis to see the effect on the change of price and quantity to the generated NPV, also use monte carlo analysis to complete with the simulation analysis. Lubricants industry in Indonesia is growing year to year and projected to generate a constant growth on the next few years. The segmentation is all of the industrial oil, targeting West Java market especially industry that use lubricants as the main component for their machinery, and positioning in a premium grade oil. The generated NPV is Rp 5,394,761,715.48, IRR 46%, PI 5,94, and payback period in 4 years. The conclusion is PT. Tirta Chemoil should take the chance to invest in the new product with lowering the initial investment and Capital expenditure so that the payback period can be faster and it can generate more revenue.

---

Keywords :

Agent Distribution, Discounted cash flow, Feasibility Study, Internal Rate of Return, Lubricants, Net Present Value

---

References :

1. BPS RI. (2022). QUARTERLY GROSS DOMESTIC PRODUCT OF INDONESIA: PRODUK DOMESTIK BRUTO INDONESIA TRIWULANAN. BPS RI/BPS-Statistics Indonesia. https://www.bps.go.id/id/publication/2022/10/10/8cc1ae509d93e0f7a1f8f6d7/produk-domestik-bruto-indonesia-triwulanan-2018-2022.html
2. CFI TEAM. (2023, October 16). Serviceable obtainable market (SOM). Corporate Finance Institute. https://corporatefinanceinstitute.com/resources/management/serviceable-obtainable-market-som/#:~:text=Summary%201%20The%20serviceable%20obtainable%20market%20%28SOM%29%20is,to%20consider%20historical%20performance%2C%20competition%2C%20and%20external%20research.
3. Choubey, P. (n.d.). Serviceable available market – wallstreetmojo. https://www.wallstreetmojo.com/serviceable-available-market/
4. Country default spreads and risk premiums. Welcome to Pages at the Stern School of Business, New York University. (n.d.). https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/ctryprem.html
5. Damodaran, A. (n.d.). Applied Corporate Finance. Wiley India.
6. Distributions derived the normal distribution – MIT OpenCourseWare. (n.d.-a). https://ocw.mit.edu/courses/18-443-statistics-for-applications-spring-2015/d49600c6145f78b8e44f71319aeb2292_MIT18_443S15_LEC1.pdf
7. GovBonds, M. (2023, October 28). Indonesia government bonds – yields curve. World Government Bonds. https://www.worldgovernmentbonds.com/country/indonesia/
8. Hitt, M. A., Ireland, R. D., & Hoskisson, R. E. (2017). Strategic management: Competitiveness & globalization: Concepts and cases. Cengage Learning Asia Pte Ltd.
9. Indonesia – OECD data. theOECD. (n.d.). https://data.oecd.org/indonesia.htm
10. Indonesia, B. P. S. (n.d.). Produk domestik bruto Indonesia triwulanan 2019-2023. Badan Pusat Statistik Indonesia. https://www.bps.go.id/id/publication/2023/10/13/9f14d43dc0c01b6d1883fb7c/produk-domestik-bruto-indonesia-triwulanan-2019-2023.html
11. Jilcha Sileyew, K. (2020). Research design and methodology. Cyberspace. https://doi.org/10.5772/intechopen.85731
12. Kenton, W. (n.d.). Monte Carlo Simulation: History, how it works, and 4 key steps. Investopedia. https://www.investopedia.com/terms/m/montecarlosimulation.asp
13. Lubricants market size, share – industry analysis, trends. Lubricants Market Size, Share – Industry Analysis, Trends. (n.d.). https://www.mordorintelligence.com/industry-reports/lubricants-market
14. Mukherjee, M., & Roy, S. (2017). Feasibility studies and important aspect of Project Management. INTERNATIONAL JOURNAL OF ADVANCED ENGINEERING AND MANAGEMENT, 2(4), 98. https://doi.org/10.24999/ijoaem/02040025
15. Perkembangan Jumlah Kendaraan Bermotor Menurut Jenis (unit), 2019-2021. (n.d.). https://www.bps.go.id/indicator/17/57/1/perkembangan-jumlah-kendaraan-bermotor-menurut-jenis.html
16. PT Penilai Harga Efek Indonesia. (n.d.). https://www.phei.co.id/
17. Sensus penduduk 2010 – Badan Pusat Statistik. WEB SENSUS BPS – Badan Pusat Statistik Republik Indonesia. (n.d.-a). https://sensus.bps.go.id/main/index/sp2010
18. Sensus penduduk 2020 – Badan Pusat Statistik. WEB SENSUS BPS – Badan Pusat Statistik Republik Indonesia. (n.d.-b). https://sensus.bps.go.id/main/index/sp2020
19. Ssegawa, J. K., & Muzinda, M. (2021). Feasibility Assessment Framework (FAF): A systematic and objective approach for assessing the viability of a project. Procedia Computer Science, 181, 377–385. https://doi.org/10.1016/j.procs.2021.01.180
20. Talerico, A. (2023, November 22). Total addressable market (TAM). Corporate Finance Institute. https://corporatefinanceinstitute.com/resources/management/total-addressable-market-tam/