REVALUATION OF FEASIBILITY STUDY IN DETERMINING LOAN FACILITY AND TENOR FROM BANK MANDIRI (CASE OF PT BUGAR HOSPITAL)

Abstract

PT Bugar Hospital is a hospital that plans to build its business in 2021, this hospital needs funding to execute the plan, the amount of shortfall in this business investment is 35 billion rupiah, therefore the hospital is trying to refer to Bank Mandiri to carry out a long-term loan. There is no financial historical data, the only data available is future projection data. Every ratio made by this hospital needs to be verified. This study aims to examine every assumption and calculation made by the borrower, as well as the borrower's ability to repay any long-term loans. Bank Mandiri has calculated the loan principal, interest and tenor. The methodology discusses internal analysis research & external analysis. Internal analysis clarifies the company's stakeholder analysis. External analysis describes Porter's five forces for market prospects and a SWOT analysis. Risk management will be carried out with a sensitivity analysis after the calculation of the feasibility study analysis of the hospital. In addition, the Monte Carlo simulation is conducted to determine the probability of the debt service coverage ratio that may occur. From the results of the calculation of this study, it was found that the decision to have an NPV was IDR -61,118,610,207.94, while from the DSCR perspective it was 0.97. The WACC used is 21.91%. The internal rate of return is 5%.