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

• Main Author: Togu, Kevin
• Format: Theses
• Language: Indonesia
• Subjects: Manajemen umum
• Online Access: https://digilib.itb.ac.id/gdl/view/52111
• Institution: Institut Teknologi Bandung

PT Bugar Hospital is a hospital that plans to build its business in 2021, this hospital needs f unding 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. By making long-term loans, Bank Mandiri must carry out a 5C analysis. The difficulty is the company that want to borrow is a company that planning to build its business, which means that there is no f inancial historical data, therefore the data available is future projection data. Every ratio made by this hospital needs to be verified. However, the banking sector has a f airly tight time and therefore does not have time to examine every assumption. Responding to the lack of time for bankers to assess whether bank loans are acceptable f rom the perspective of financial project investment assumptions, this study aims to examine every assumption and calculation made by the borrower, as well as the borrower's ability to repay any longterm loans. Bank Mandiri has calculated the loan principal, interest and tenor. Even though the bank loan instrument has been calculated, Bank Mandiri has not informed the borrower about the calculated amount of the tenor, interest, and principal of the loan, so this bank loan has not reached an agreement whether it is accepted or not. The methodology discusses internal analysis research and external analysis. Internal analysis clarifies the company' s stakeholder. The external analysis describes demographics, Regency X's workforce, summary of health infrastructure, Porter's five f orces f or market prospects and a SWOT analysis. Risk management will be carried out with a sensitivity analysis after the calculation of the f easibility 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 f ound that the decision to have an NPV was IDR 2, 141,364,503. 95, while f rom the DSCR perspective it was 1. 15. The WACC used is 10.15%. The internal rate of return f or purchasing decisions is 10. 48%, which means that it is greater than the total loan interest of 10.5%. The payback period for the buying decision takes 7 years. In addition, for the average value the company gets a DSCR of 0. 75.