perhitungan studi kelayakan apotek
Post on 14-Nov-2015
164 Views
Preview:
DESCRIPTION
TRANSCRIPT
Sheet1Tugas PertamaInvestasi (Z)500,000,000Df (i)0.15Sisa (TCF)50,000,000PV TFC24,858,837NCFDFPVNCFTotal (PV NCF+TFC)100,000,0000.869565217486,956,522545,667,314150,000,0000.7561436673113,421,550200,000,0000.6575162324131,503,246200,000,0000.5717532456114,350,649150,000,0000.497176735374,576,510NPV520,808,47845,667,314Karena NPV (+) maka usulan proyek investasi diterimaTugas KeduaInvestasi (Z)125,000,000NPV0Sisa15,000,000NCFIRRNPV45,000,0000.12063088-035,000,00030,000,00025,000,000IRR yang diminta 15%20,000,000Karena IRR yang didapatkan 12,06% ( 1 PVNCF dan PVTC bisa untuk menutup invesmant (Z).
Tugas KeempatInvestasi (Z)500,000,000NCF120,000,000Sisa (CTF)50,000,000DF20%(120.000.000 x 2,9906)+(50.000.000 x 0,4019) - 500.000.000NVP-121033000Usulan ditolak karena NPV nya negatif, dimana PVNCF belum cukup untuk menutupi initial invesment (Z)
Sheet2
Sheet3
top related