Fin622 solution
Monday, May 10, 2010 Posted In Fin Edit ThisBeing the finance manager of XYZ Company, you are to select one project of two available options i.e. Project A and Project B. The relevant cash flows for both the projects are summarized in given table.
Project A
Project B
Initial investment
Rs. 57,000
Rs. 54,000
Year(n)
Cash inflows (CFn)
Cash inflows (CFn)
1
Rs. 20,000
Rs. 22,000
2
20,000
20,000
3
20,000
18,000
4
20,000
16,000
Assume the discount rate to be 14 percent.
Required:
• Calculate the payback period of each project.
• Calculate the Net present value (NPV) of each project.
• On the basis of results of pay back period and NPV, which project would you recommend to your company and why?
Important Note: Give formulae and show calculations properly as they also carry marks
Project A
Project B
Initial investment
Rs. 57,000
Rs. 54,000
Year(n)
Cash inflows (CFn)
Cash inflows (CFn)
1
Rs. 20,000
Rs. 22,000
2
20,000
20,000
3
20,000
18,000
4
20,000
16,000
Assume the discount rate to be 14 percent.
Required:
• Calculate the payback period of each project.
• Calculate the Net present value (NPV) of each project.
• On the basis of results of pay back period and NPV, which project would you recommend to your company and why?
Important Note: Give formulae and show calculations properly as they also carry marks
Solution:-
1) The payback period of each project
THE PAYBACK PERIOD (PP); For the Project A that has equal receipts
= Initial Investment / Cash Flow (I0/Ct)
= 57000/20000
= 2.85year
THE PAYBACK PERIOD (PP); For the Project B
Payback period lie between 2nd year and 3rd year
Sum of the money recovered by the end of second year
= (22000+20000)
= 42000
Sum of money recovered by the end of 3rd year
= (54000 – 42000)
= 12000
= [2+ 12000/18000) years
= 2.667 years
2) The Net present value (NPV) of each project.
NPV for project A;
Formula:
(CFn * PVFA at 14% for 4 years) – Initial Investment
PVFA at 14% for 4 years:
= [1/ (1+i) ^ n + 1/ (1+i) ^ n + 1/ (1+i) ^ n + 1/ (1+i) ^ n]
= [1/ (1+0.14) ^1 + 1/ (1+0.14) ^2 + 1/ (1+0.14) ^3 + 1/ (1+0.14) ^4]
= [0.8772 + 0.7695 + 0.6749 + 0.5920]
= [2.9136]
By putting values in Formula:
= (20000 * 2.9136) – 57000
= 1272
NPV for project B;
Formula:
Sum of the NPV (CFn) – Initial investment
Sum of the NPV (CFn)
= [CF1/ (1+i) ^ n + CF2/ (1+i) ^ n + CF3/ (1+i) ^ n + CF4/ (1+i) ^ n]
= [22000/ (1+0.14) ^1 + 20000/ (1+0.14) ^2 + 18000/ (1+0.14) ^3 + 16000/ (1+0.14) ^4]
= 19298.246 + 15389.352 + 12149.487 + 9473.284
= 56310.368
By putting values
= 56310.368 – 54000
= 2310.368
3) Decision
Project A 1272.00 NPV
Project B 2310.368 NPV
According to the NPV of both projects, I will recommend project B due to greater NPV of project B from A.
Project A 2.85 year PP
Project B 2.667 year PP
According to the PP of both projects, I will also recommend Project B, because in Project B the payback period (PP) is little than Project A.
