|
Abstract:
|
This property investment feasibility study is an activity carried out regarding whether or not a project is feasible from a financial perspective before the project is implemented, the purpose of this activity is to find out whether the construction of subsidized housing is needed or not and to find out the function of the building services desired by the residents. The increasing need for subsidized housing creates investment opportunities. With the right method of investing in subsidized housing projects, investors can get a decent rate of return on capital. For that, we need a model that can be used to conduct a feasibility study of an investment plan for a subsidized housing development project. Users of this feasibility study model can subjectively enter the input value according to the user's subsidized housing project investment plan. This model is a simple program using Microsoft Excel that will calculate the value of the Internal Rate of Return. Three Cash Flow scenarios in this model are made for NPV (Net Present Value), IRR (Internal Rate of Return) and BCR. NPV yield = interest rate (i) + 2021 Net Cash Inflow + 2022 Net Cash Inflow is Rp. 2,603,066,000.00 so that the investment deserves to be accepted. IRR = Total Cash Expenditure + Total Cash Income = 41% and BCR Value = (Present Value of Benefits / Present Value of Costs) = 1.20 > 1, so the investment is acceptable. Based on the results of the analysis of various possible risks that are simulated, the IRR value is still higher than the rate (5%). |