Abstract :

The level of coffee consumption continues to increase from year to year due to the influence of third wave coffee, this also affects the sales of Coffee Shop XYZ which continue to increase. Departing from this success, management wants to open two new branches, namely in Purwakarta and in Subang through raising funds on the equity crowdfunding platform. That’s why Coffee Shop XYZ needs steps for company valuation to find out the business value and share price that Coffee Shop XYZ will provide. Coffee Shop XYZ’s company valuation assessment uses absolute and non-absolute valuation methods, where the absolute valuation method uses discounted cash flow with terminal value, while the non-absolute valuation method uses a relative model which compares Coffee Shop XYZ’s financial ratios with similar companies in the same industry. , namely the restaurant. Based on the results of the study using the absolute valuation method, it was found that Coffee Shop XYZ had an enterprise value of Rp 19.930.457.260, with a share price of Rp 49.706,38 and 390.000 outstanding shares. Meanwhile, based on the non-absolute method, the EV/EBIT, P/E and P/B ratios indicate that Coffee Shop XYZ is undervalued, meaning that the business will generate greater profits, and the business is considered not too high-risk for investment. It also has a fair share price and the ratios show its ability to distribute dividends to investors. In conclusion, based on Coffee Shop XYZ’s valuation, it is known as a declining overvalued company. Even so, Coffee Shop XYZ will still provide positive residual income.

 

---

Keywords :

Business Valuation, Coffee Shop, Discounted cash flow, Relative Model, Terminal Value.

---

References :

1. Ali, Kim Ehab Shelbaya. 2014. Fundamental Analysis and Relative Valuation Multiples: A Determination of Value Drivers and Development of a Value Model for the US and UK Markets. United Kingdom. University of Portsmouth.
2. Arzac, Enrique. 2005. Valuation For Mergers, Buyouts, and Restructuring. John Wiley & Sons.
3. Bailetti, Tony., Stoyan Tanev, and Christian Keen. What Makes Value Propositions Distinct and Valuable to New Companies Committed to Scale Rapidly?. Technology Innovation Management Review.
4. Basu, S. 1977. Investment Performance of Common Stocks in Relation to Their Price- Earnings Ratios: A Test of the Efficient Market Hypothesis. The Journal of Finance, 32 (3), pp. 663-682.
5. Brealey, R. A., Meyers, S.C., Allen, F. 2010. Principles of corporate Finance 10th edition (Global Edition). McGraw-Hill-Irwin.
6. Chan, Ronald W., and Brian C. Lui. 2011. EV/EBIT Ratio: The Best of Both Worlds. Hong Kong. Chartwell Capital.
7. Choiriya, Choiriyah., et al. 2020. The Effect of Return on Assets, Return on Equity, Net Profit Margin, Earning per Share, and Operating Profit Margin on Stock Prices of Banking Companies In Indonesia Stock Exchange. Bandung. International Journal of Finance Research, Vol. 1, No.2.
8. , and Brian Owen Franjaja. 2021. The Impact Of Current Ratio And Gross Profit Margin Towards Financial Distress In Technology Sector Companies Listed In Indonesia Stock Exchange For Period 2016-2020. Medan, Indonesia. Journal of Industrial Engineering & Management Research, Vol. 3 No. 1.
9. Creswell, John W. Research Design: Qualitative, Quantittive, and Mixed Methods Approaches. California, USA. SAGE Publications, Inc.
10. Damodaran, Aswath. 2005. Valuation Approach and Metrics: A Survey of The Theory and Evidence. Stern. Stern School of Business.
11. Doblas, M.P, Lagaras, M.C.P., and Enriquez, J.A. 2020. Price to Earnings and Price to Book Ratios as Determinants of Stock Return: The Case of Financial Institutions Listed in Bahrain Bourse. Journal of Applied Economic Sciences, Volume XV, Fall, 3(69): 532-539.
12. Faiteh, Anouar., and Mohammed Rachid Aasri. 2022. Accounting Beta as an Indicator of Risk Measurement: The Case of the Casablanca Stock Exchange. Rabat, Morocco. MDPI.
13. Fernández, Pablo. 2008. Levered and Unlevered Beta. Madrid, Spain. IERE Business School.
14. Fernández, Pablo. 2013. WACC: Definition, Misconceptions and Errors. Madrid, Spain. Business Valuation Review 29(4).
15. Findlay III, M. Chapman., and Edward E. Williams. 1975. Toward More Adequate Debt Service Coverage Ratios. Financial Analysit Journal, Vol. 31, No. 6.
16. Fitch, S. 2022. P/Es fot the Smart Money. Forbes; 5/13/2002, Vol. 169 Issue 11, p184-186.
17. Gitman, L.J., Juchau, R., and Flanagan, J. 2015. Principles of managerial finance. Pearson Higher Education AU. ISBN: 1292018208 978-1292018201, 929 p.
18. Gürel, Emet. 2017. SWOT ANALYSIS: A THEORETICAL REVIEW. Journal of International Social Research.
19. Hamada, R. 1972. The Effect of the Firm’s Capital Structure on the Systematic Risk of Common Stocks. Journal of Finance, 27, 435-452.
20. Handayani, Novia., and Srihadi Winarningsih. 2020. The Effect of Net Profit Margin and Return on Equity Toward Profit Growth. Jurnal Akuntansi dan Keuangan.
21. Herbohn, John., and Steve Harrison. 2002. Introduction to Discounted Cash Flow Analysis and Financial Functions in Exce Socio-economic Research Methods in Forestry.
22. Jayaraj, Prabhuraj. 2022. Study on Ratio Analysis at TNPL. Conference: Business Finance and Social Science at TAMILNADU.
23. Kao, Lanfeng., Anlin Chen., and Cheng-Shou Lu. 2018. Ex ante and ex post overvalued equities: The roles of corporate governance and product market competition. Taiwan. Asia Pasific Management Review 23 (2018), pp 209-221.
24. Kenton, W. 2021. Corporate Finance & Accounting. [Online] Available at: https://www.investopedia.com [Accessed 20 January 2023].
25. , and Muammar Khaddafi. 2020. The Influence of Gross Profit Margin, Operating Profit Margin and Net Profit Margin on the Stock Price of Consumer Good Industry in the Indonesia Stock Exchange on 2012-2014. Aceh. International Journal of Business, Economics and Social Development, vol. 1, No. 33, pp. 153-163.
26. Manglik, Manish., and Dr. Akhil Goyal. 2016. Operating Margin Ratio (A Comparative Study of Selected Public and Private Sector Companies). Jaipur. Indian Journal of Research, Vol. 5, Issue 5.
27. Osterwalder, Alexander., et al. 2014. Value Proposition Design: How to Create Products and Services Customers Want. Wiley.
28. Park, Han-Up. 2017. CHANGES IN OPERATING MARGINS DURING A SALES DECLINE AND ABNORMAL RETURNS. Temple university Graduate Board.
29. Pozos Brewer, Rose. 2015. Coffee Shops: Exploring Urban Sociability and Social Class in the Intersection of Public and Private Space. Swarthmore College, Dept. of Sociology & Anthropology.
30. Riedho, M. Roehman Zainur. 2022. Larangan Ekspor Bijih Nikel Oleh Pemerintah Indonesia Setelah Meningkatnya Tren Industri Otomotif Berbasis Listrik. Universitas Islam Negeri Sunan Ampel Surabaya.
31. Rizky, Zulfi Noor. 2020. Pengaruh Third Wave Coffee Culture Terhadap Modernisasi Budaya Kopi di Indonesia. Universitas Muhammadiyah Malang.
32. Rubinstein, M. 1973. The Fundamental Theorem of Parameter Preference Security Valuation. Journal of Financial and Quantitative Analysis, 8, 61-69.
33. Sammut-Bonnici, Tanya., and David Galea. 2015. PEST Analysis. Wiley Encyclopedia of Management. John Wiley & Sons, Ltd.
34. Sharpe, W.F. 1964. Capital Asset Prices: A Theory of market equilibrium under conditions of risk. Journal of Finance 19: 425-442.
35. Tofallis, Dr. Chris. 2011. INVESTMENT VOLATILITY: A CRITIQUE OF STANDARD BETA ESTIMATION AND A SIMPLE WAY FORWARD. Hatfield, United Kingdong. Department of Management Systems The business School University of Hertfordshire.
36. Wu, Wan-Ting. 2014. The P/E Ratio and Profitability. Massachusetts, USA. Journal of Business & Economics Research, First Quarter 2014, Vol. 12 Number 1.