Initial investment = 10,000,000
Annual Savings = 2,500,000
Study Period = 4 years
Salvage Value = 6,000,000
Calculating the IRR using the Trial and Error Method.
Let the MARR is 15%
Calculate the PW of the investment at MARR of 15%
"PW = -10,000,000 + 2,500,000 (P\/A, 15 \\%, 4) + 6,000,000 (P\/F,15 \\%, 4)\\\\\n\nPW = -10,000,000 + 2,500,000 (2.8550) + 6,000,000 (0.5718) = 568,300"
The PW is positive. So, increase the rate of interest to get negative PW.
Increase the MARR to 16% and calculate the PW.
"PW = -10,000,000 + 2,500,000 (P\/A, 16 \\%, 4) + 6,000,000 (P\/F,16 \\%, 4)\\\\\n\nPW = -10,000,000 + 2,500,000 (2.7982) + 6,000,000 (0.5523) = 309,300"
The PW is still positive. So, increase the rate of interest to get negative PW.
Increase the MARR to 18% and calculate the PW.
"PW = -10,000,000 + 2,500,000 (P\/A, 18 \\%, 4) + 6,000,000 (P\/F,18 \\%, 4)\\\\\n\nPW = -10,000,000 + 2,500,000 (2.6901) + 6,000,000 (0.5158) = -179,950"
Now, use interpolation and calculate the IRR.
"IRR = 16 \\% + [309,300 \u2013 0 \u00f7 309,300 \u2013 (-179,950)] * 2 \\%\\\\\n\nIRR = 17.26 \\%"
The IRR is 17.26 (not using the % sing as the question is mentioning)
Comments
Leave a comment