Capital Budgeting Numericals
Capital Budgeting Numericals
Capital Budgeting Numericals
5 years
200000
30000 30000
35000 65000
35000 100000
25000 125000
25000 150000
20000 170000
20000 190000
20000 210000
7+ 10000/20000
EVEN CASH FLOWs
Profit 300000
Tax 150000
PAT 150000
add Dep
2000000*12.5 250000
400000
2000000/400000
5 years
PBP= P+ B/C
3+2000/12000
56000/100000
PPBP= Cash Inflow (Est Life-PBP)
25000(6-4)
50000
year CI PVF
1 500 0.909 454.5
2 500 0.826 413
3 4600 0.751 3454.6
4 10000 0.683 6830
TPV 11152.1
CO 10000
NPV 1152.1
Project X Project Y
Initial Inv 20000 30000
Est Life 5years 5years
Scrap 1000 2000
Project X Project Y
1 5000 0.909 4545 20000 0.909 18180
2 10000 0.826 8260 10000 0.826 8260
3 10000 0.751 7510 5000 0.751 3755
4 3000 0.683 2049 3000 0.683 2049
5 2000 0.621 1242 2000 0.621 1242
6 1000 0.621 621 2000 0.621 1242
24227 34728
Outflow Inflow
112
544
432
0.259259
0.39881
0.909 10000 9090
0.826 10000 8260
0.751 10000 7510
0.683 10000 6830
Project A Project B
Cost 22000 20000
CI
1 12000 2000
2 4000 2000
3 2000 4000
4 10000 20000
28000
28000/4
7000
PVF
PVF 22000/7000
3.14
CI 10% PV CI 11% PV
12000 0.909 10908 12000 0.901 10812
4000 0.826 3304 4000 0.812 3248
2000 0.751 1502 2000 0.731 1462
10000 0.683 6830 10000 0.659 6590
22544 22112
22000 22000
NPV 544 NPV 112
10%+(544/432)*11%-10%
10%+1.26
11.26%
CI 15% PV CI 16% PV
2000 0.87 1740 2000 0.862 1724
2000 0.756 1512 2000 0.743 1486
4000 0.658 2632 4000 0.641 2564
20000 0.572 11440 20000 0.552 11040
17324 16814
20000 20000
NPV -2676 NPV -3186
15.83%
RISK ADJUSTED CUT_OFF RATE
Initial Inv. Rs. 150000 each
Inv. X
1 60000
2 45000
3 35000
4 30000
target roc 10%, risk premium rate are 2% ant 8% resp. for Project X and Project Y.
Investment X
Year DF 10%+2%=12% CI
1 0.893 60000 53580
2 0.797 45000 35865
3 0.712 35000 24920
4 0.636 30000 19080
133445
150000
-16555
YEAR Project A
Cash Inflows Certainty Co-efficient Certain Cash Flows
1 35000 0.8 28000
2 30000 0.7 21000
3 20000 0.9 18000
Project X Project Y
Cost 100000 100000
Cash flows till 5 years
optimistic 60000 55000
Most Likely 35000 30000
Pessimistic 20000 20000
Cut off rate 15% 15%
CI Dicount Factor@15%
optimistic 60000 3.3522
Most Likely 35000 3.3522
Pessimistic 20000 3.3522
PROBABILITY TECHNIQUE
DF@10%
1 0.909 10000 9090
2 0.826 18000 14868
3 0.751 8000 6008
Project B
Cerainty Co-efficient
0.9
0.8
0.7
PVF @10%PV
0.909 25452
0.826 17346
0.751 13518
56316
50000
NPV 6316
PV NPV
201132 101132 84371
117327 17327 566
67044 -32956 -32956
Risky
Probability
0.2
0.6
0.2
0.2 1818
0.6 8921
0.2 1202
1941
DECISION TREE ANALYSIS
Year-I
Event Cash Inflow Probability
i 16000 0.3
ii 24000 0.5
iii 20000 0.2
Year-II
16000 24000 20000
Cash Inflow ProbabilityCash Inflow Probability Cash Inflo
i 30000 0.2 40000 0.1 5000
ii 40000 0.6 60000 0.8 8000
iii 50000 0.2 80000 0.1 12000
using 10% as cost of capital. Advice about the acceptability of the proposal
Year I prob Year 2 prob NPV of Inflow
Year Prob Cash Inflow Prob Cash Inflow Joint Prob
0.2 30000 -676 0.06
0.3 16000 0.6 40000 7584 0.18
0.2 50000 15844 0.06
Workings
0.909 16000 14544
0.826 30000 24780
39324
-676
Year-I
Event Cash Inflow Probability
i 12000 0.2
ii 14000 0.6
iii 9000 0.2
Year-II
12000 14000 9000
Cash Inflow ProbabilityCash Inflow Probability Cash Inflo
i 18000 0.3 22000 0.2 28000
ii 20000 0.4 26000 0.7 32000
iii 20000 0.3 30000 0.1 35000
using 10% as cost of capital. Advice about the acceptability of the proposal
20000
Probability
0.2
0.5
0.3
Expected NPV
-40.56
1365.12
950.64
742.8
12550.4
2394.8
-707.6
-1521.2
-714.48
15019.92
9000
Probability
0.4
0.5
0.1