Capital Budgeting
Capital Budgeting
Capital Budgeting
ARR
Year 1 Year 2 Year 3
Net Cash Saving 125000 130000 110000
Depreciation 245000/3 81667 81667 81667
Profit for the Period 43333 48333 28333
Payback Period
Cash Flows Cu. Cash Flows
Year 0 -250000 -250000
Year 1 125000 -125000
Year 2 130000 5000 one Year 11 Months
Year 3 115000 120000
11.53846154 0.538461538
NPV 57476
15%
Year 0 Year 1 Year 2 Year 3
Intial Investment -245000
Working Capital -5000 5000
Net Cash Saving 125000 130000 110000
Net Cash flows -250000 125000 130000 115000
Discount Factor 15% 1/(1+R)^n 1 0.8696 0.7561 0.6575
Discounted Cash Flows -250000 108696 98299 75614
NPV 32609
20%
Year 0 Year 1 Year 2 Year 3
Intial Investment -245000
Working Capital -5000 5000
Net Cash Saving 125000 130000 110000
Net Cash flows -250000 125000 130000 115000
Discount Factor 20% 1/(1+R)^n 1 0.8333 0.6944 0.5787
Discounted Cash Flows -250000 104167 90278 66551
NPV 10995
25%
Year 0 Year 1 Year 2 Year 3
Intial Investment -245000
Working Capital -5000 5000
Net Cash Saving 125000 130000 110000
Net Cash flows -250000 125000 130000 115000
Discount Factor 25% 1/(1+R)^n 1 0.8000 0.6400 0.5120
Discounted Cash Flows -250000 100000 83200 58880
NPV -7920
22.91%
16%
16 days
16.153846154
22.827%
Months
A Company plan to invest in equipment that will cost Rs 1,000,000 and expected to generate a net cash flow of Rs 275,000 en
end of the second year, 460,000 ends of the third year, Rs 310,000 at the end of the fouth year, and Rs 125,000 end of the fift
equipment will be five years and scrap value of end of five year Rs 25,000. Evaluate the investment project by using
ARR
Payback
NPV if the expected rate of return is 18%. and IRR
ARR
Year 1 Year 2 Year 3 Year 4 Year 5
Net Cash Flows 275000 380000 460000 310000 125000
Depreciation -195000 -195000 -195000 -195000 -195000
Profit 80000 185000 265000 115000 -70000
PayBack Period
Cash Flows Cu. Cash Flows
Year 0 -1000000 -1000000
Year 1 275000 -725000
Year 2 380000 -345000 2 years and 9 Months
Year 3 460000 115000
Year 4 310000 425000
Year 5 150000 575000
NPV 11392
NPV 23%
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
NPV -89335
Total
1550000
-975000
575000 115000
Kalindu Company LED plan to invest in new machinery that will cost Rs 2,500,000 and expected to generate a cash inflow of R
year, Rs 990,000 end of the second year, 960,000 ends of the third year, Rs 900,000 at the end of the fourth year, and Rs 925
In order to generate the above cash flows, the company will incur the following cash outflow of Rs 275,000 end of the first ye
second year, 360,000 ends of the third year, Rs 210,000 at the end of the fourth year, and Rs 315,000 end of the fifth year.
The useful lifetime of machinery will be five years and scrap value of end of five Rs 500,000. The company adopt the straight-
The corporate tax rate is 28%, a a capital allowance is 25% can claim against the profit.
Tax Calculation
Net Cash flows Before Tax 700000 640000 600000 690000 610000
Capital Allowance 25% -625000 -625000 -625000 -625000
Profit from Scrap Value 500000
Taxable Profit 75000 15000 -25000 65000 1110000
28% Tax 21000 4200 -7000 18200 310800
Payback Period
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Net Cash flows before Tax -2500000 700000 640000 600000 690000 610000
Scrap Value 500000
Tax Amount -21000 -4200 7000 -18200 -310800
Net Cash flows After Tax -2500000 679000 635800 607000 671800 799200
Cum. Cash Flows -2500000 -1821000 -1185200 -578200 93600 892800
NPV
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Intial Investment -2500000
Scrap Values 500000
Net Cash flows Before Tax 700000 640000 600000 690000 610000
Tax Amount -21000 -4200 7000 -18200 -310800
Net Cash flows After Tax -2500000 679000 635800 607000 671800 799200
Discount Factor 10% 1 0.9091 0.8264 0.7513 0.6830 0.6209
Discounted Cash Flows -2500000 617273 525455 456048 458848 496240
NPV 53864
NPV 15%
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Intial Investment -2500000
Scrap Values 500000
Net Cash flows Before Tax 700000 640000 600000 690000 610000
Tax Amount -21000 -4200 7000 -18200 -310800
Net Cash flows After Tax -2500000 679000 635800 607000 671800 799200
Discount Factor 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972
Discounted Cash Flows -2500000 590435 480756 399112 384104 397344
NPV -248249.24
Total
4750000
-1510000
3240000
-2000000
1240000
-347200
892800 178560
-2500000
Net after tax cash flows (*000)
Project Years
0 1 2 3 4 5
A -5000 1500 1400 1800 1200 1200
B -5000 1500 1200 1500 2500 1000
Project B
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Cash Flows -5000 1500 1200 1500 2500 1000
Cu. Cash flow -5000 -3500 -2300 -800 1700 2700
ARR
Project B
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Cash Flows after Tax -5000 1500 1200 1500 2500 1000
Depreciation -1000 -1000 -1000 -1000 -1000
Profit After tax 500 200 500 1500 0
Average Profit
NPV
Project A Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Cash Flows after Tax -5000 1500 1400 1800 1200 1200
Discount Factor 10% 1 0.9091 0.8264 0.7513 0.6830 0.6209
Discounted Cash flows -5000 1364 1157 1352 820 745
NPV 1197
Project B
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Cash Flows after Tax -5000 1500 1200 1500 2500 1000
Discount Factor 10% 1 0.9091 0.8264 0.7513 0.6830 0.6209
-5000 1364 992 1127 1708 621
NPV 811
IRR
Project B
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Cash Flows after Tax -5000 1500 1200 1500 2500 1000
Discount Factor 15% 1 0.8696 0.7561 0.6575 0.5718 0.4972
Discounted Cash flows -5000 1304 907 986 1429 497
IRR 16.10%
5 and 7
Equal Life Method
NPV 2372
Project B
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Cash Flows after Tax -5000 1500 1200 1500 2500 1000
-5000
NPV 2063
1 2 3 4 5
Annual Equalant Value Method 1 0.9091 0.8264 0.7513 0.6830 0.6209
0.9091 1.7355 2.4869 3.1699 3.7908
Project A 3.7908
NPV at 10% 1197 7 Year Prasent Value Annivity factor PVAF
Project B
NPV at 10% 811 5 year present Value Annivity Factor
6 7
800 600
Year 6 Year 7
800 600
2900 3500
Year 6 Year 7
Year 6 Year 7
800 600
-714 -714
86 -114 3500
500
2700
540
Year 6 Year 7
800 600
0.5645 0.5132
452 308
Year 6 Year 7
800 600
0.4323 0.3759
346 226
Year 6 Year 7
800 600
0.3349 0.2791
268 167
Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15
800 600
-5000 1500 1400 1800 1200 1200 800 600
-5000 1500
800 -4400 1500 1400 1800 1200 1200 800 -4400 1500
0.5645 0.5132 0.4665 0.4241 0.3855 0.3505 0.3186 0.2897 0.2633 0.2394
452 -2258 700 594 694 421 382 232 -1159 359
Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15
1500 1200 1500 2500 -4000 1500 1200 1500 2500 -4000
0.5645 0.5132 0.4665 0.4241 0.3855 0.3505 0.3186 0.2897 0.2633 0.2394
847 616 700 1060 -1542 526 382 434 658 -958
6 7
0.5645 0.5132 4.8684
4.3553 4.8684
Year 16 Year 17 Year 18 Year 19 Year 20 Year 21 Year 22 Year 23 Year 24 Year 25
1400 1800 1200 1200 800 -4400 1500 1400 1800 1200
0.2176 0.1978 0.1799 0.1635 0.1486 0.1351 0.1228 0.1117 0.1015 0.0923
305 356 216 196 119 -595 184 156 183 111
Year 16 Year 17 Year 18 Year 19 Year 20 Year 21 Year 22 Year 23 Year 24 Year 25
1500 1200 1500 2500 -4000 1500 1200 1500 2500 -4000
0.2176 0.1978 0.1799 0.1635 0.1486 0.1351 0.1228 0.1117 0.1015 0.0923
326 237 270 409 -595 203 147 168 254 -369
Year 26 Year 27 Year 28 Year 29 Year 30 Year 31 Year 32 Year 33 Year 34 Year 35
1200 800 -4400 1500 1400 1800 1200 1200 800 600
0.0839 0.0763 0.0693 0.0630 0.0573 0.0521 0.0474 0.0431 0.0391 0.0356
101 61 -305 95 80 94 57 52 31 21
Year 26 Year 27 Year 28 Year 29 Year 30 Year 31 Year 32 Year 33 Year 34 Year 35
project feasibility study already Spend 1000 This will not consider for
IRR 30.3%
Tax Calculation
Net Cash flow before Tax 36740 40240 44000
Capital Allowence or Taxable Depreciation Capital ALL. = Depreciation -16000 -16000 -16000
Taxable Profit 20740 24240 28000
Tax Amount 10% 2074 2424 2800
143224
Year 04 Year 05
12,500 13,000
000
Year 04 Year 05
2315 2431
12.5 13
28,941 31,603
12.5 13
3.75 3.9
8000 8000
30000 31200
This will not consider for Evaluation. Why, This is Sunk Cost
480 480
360 360
420 420
2000 2000
9000 11000
Year 04 Year 05
20000
28,941 31,603
30,000 31,200
-480 -480
-360 -360
-420 -420
-2000 -2000
-9000 -11000
46681 68543
-3068 -3254
43613 65289
0.5718 0.4972
If profitability index is more one, We will select the Projects and
24936 32460 143224 1.4322 also when we we have morethan one project we will use highest
PI to select the Best Project
Cost 100000
A. Depre. -80000
BV 20000
Dis. Price 20000
46681 48543 0
-16000 -16000
30681 32543
3068 3254
43612.5625 65288.846
0.4823 0.4019
21032 26238
43612.5625 65288.846
0.4096 0.3277
17864 21394
43612.5625 65288.846
0.3501 0.2693
15270 17584
43612.5625 65288.846
0.3396 0.2592
14809 16923
itial Investment
e, We will select the Projects and
an one project we will use highest
he Best Project
Initial Cost Discounted Net Cash Fows
Project A 75000 84000
Project B 60000 69000
Project C 90000 102000
NPV Profitability Index Rank
9000 84000/75000 1.1200 3
9000 69000/60000 1.1500 1
12000 102000/90000 1.1333 2
Activity Predecesso Duration
r(s) (Months)
A Purchase of a suitable land 1
B Prepare Architectural Drawings A 2
C Prepare Prospectus and Advertisements A 1
D Selection of new customers to purchase C 3
condominiums
E Select a Building Contractor B,D 1
F Prepare Building Permits D 1
G Obtain Approval for Building Permits F 2
H Obtain Key money D 10
I Perform construction G,E 36
J Receipt of Final payment and complete H,I 11
legal documentation procedures with new
customers
K Owners move In J 1
Total Months 69
Months 1 2 3 4 5 6 7 8 9 10
A
B
C
D
E
F
G
39 10 29 H
I
J
K
11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
55 56 57 58 59 60 61 62 63 64 65 66 67 68
000
years 0 1 2 3
cost of the land (50000)
activities B, C and D Cost (12000)
activities E, F and G Cost (500)
key-money Received 10%*A*20
total estimated construction cost is Rs.200
Pay 20% of the total cost of 200 (40000)
Pay 15% of the total cost (30000)
Pay 15% of the total cost upon 65% of (30000)
the completion
Pay 30% of the total cost upon
completion
Remain Part 20%
final Receipts from the customers
Total Cash flows (62000) (40500) 10%*A*20-30000 (30000)
Discount Factor 1 0.8333 0.6944 0.5787
Discounted Cash flows (62000) (33750) 1.3889A-20833 (17361)
2A-30000
1.3889
20833
000
years 0 1 2 3
cost of the land (50000)
activities B, C and D Cost (12000)
activities E, F and G Cost (500)
key-money Received 40000
total estimated construction cost is Rs.200
Pay 20% of the total cost of 200 (40000)
Pay 15% of the total cost (30000)
Pay 15% of the total cost upon 65% of (30000)
the completion
Pay 30% of the total cost upon
completion
Remain Part 20%
final Receipts from the customers
Total Cash flows (62000) (40500) 10000 (30000)
Discount Factor 20% 1 0.8333 0.6944 0.5787
Discounted Cash flows (62000) (33750) 6944 (17361)
NPV 29207
12809
(757)
25% + 12809/(12809-(-757)) *
IRR 29.72%
29.69%
4 5 6 7 8
(60000)
(40000)
90%*A*20
90%*A*20-60000 0 0 0 (40000)
0.4823 0.4019 0.3349 0.2791 0.2326
8.6806A-28935 0 0 0 (9303)
18A-60000
8.6806
28935
4 5 6 7 8
(60000)
(40000)
360000
300000 0 0 0 (40000)
0.4823 0.40 0.33 0.28 0.2326
144676 0 0 0 (9303)
300000 0 0 0 (40000)
0.4096 0.328 0.262 0.210 0.1678
122880 0 0 0 (6711)
300000 0 0 0 (40000)
0.3501 ### ### ### 0.1226
105038 0 0 0 (4904)
(30%-25%
0 1 2
-22000
24000 20000
-10000 -9000
1 0.9091 0.8264
-22000 21818.1818 16528.9256 38347.1074
-9090.9091 -7438.0165 -16528.9256
-22000 12727 9091 -182
Ye a r 0 Ye a r s 1 - 1 2
I n v e s t me n t - 5, 400
Sa l e s 16, 000
Va r i a b l e Co s t s 13, 000
Fi x e d Co s t s 2, 000
De p r e c i a t i o n 450
Pr e t a x p r o f i t 550
. Ta x e s @ 4 0 % 220
Pr o f i t a f t e r t a x 330
Op e r a t i n g c a s h f l o w 780
Ne t Ca s h Fl o w - 5, 400 780
0 1 2 3 4 5
Investment -5400
Sales 16000 16000 16000 16000 16000
Variable Cost -13000 -13000 -13000 -13000 -13000
FC -2000 -2000 -2000 -2000 -2000
TAX -220 -220 -220 -220 -220
Cash flows -5400 780 780 780 780 780
Discount factor 8% 1 0.9259 0.8573 0.7938 0.7350 0.6806
Discounted Cash flows -5400 722 669 619 573 531
NPV 478
0 1 2 3 4 5
Investment 15% -6200
Sales 16000 16000 16000 16000 16000
Variable Cost -13000 -13000 -13000 -13000 -13000
FC -2000 -2000 -2000 -2000 -2000
TAX -220 -220 -220 -220 -220
Cash flows -6200 780 780 780 780 780
Discount factor 8% 1 0.9259 0.8573 0.7938 0.7350 0.6806
Discounted Cash flows -6200 722 669 619 573 531
0 1 2 3 4 5
Investment -5400
Sales -10% 14400 14400 14400 14400 14400
Variable Cost -13000 -13000 -13000 -13000 -13000
FC -2000 -2000 -2000 -2000 -2000
TAX -220 -220 -220 -220 -220
Cash flows -5400 -820 -820 -820 -820 -820
Discount factor 8% 1 0.9259 0.8573 0.7938 0.7350 0.6806
Discounted Cash flows -5400 -759 -703 -651 -603 -558
NPV 2522% -11580
0 1 2 3 4 5
Investment -5400
Sales 16000 16000 16000 16000 16000
Variable Cost 10% -14300 -14300 -14300 -14300 -14300
FC -2000 -2000 -2000 -2000 -2000
TAX -220 -220 -220 -220 -220
Cash flows -5400 -520 -520 -520 -520 -520
Discount factor 8% 1 0.9259 0.8573 0.7938 0.7350 0.6806
Discounted Cash flows -5400 -481 -446 -413 -382 -354
6 7 8 9 10 11 12
6 7 8 9 10 11 12