Capital Budgeting Techniques
|
|||||
Year |
Opening Loan Balance(i) |
Instalment Amount (ii) |
Interest Amount (iii) = (I * 5.70%) |
Principle Amount (iv)= (ii-iii) |
Closing Loan Balance (v)= (i-iv) |
1 |
$ 1.20 |
$ 0.28 |
$ 0.07 |
$ 0.21 |
$ 0.99 |
2 |
$ 0.99 |
$ 0.28 |
$ 0.02 |
$ 0.27 |
$ 0.72 |
3 |
$ 0.72 |
$ 0.28 |
$ 0.02 |
$ 0.27 |
$ 0.45 |
4 |
$ 0.45 |
$ 0.28 |
$ 0.02 |
$ 0.27 |
$ 0.19 |
5 |
$ 0.19 |
$ 0.28 |
$ 0.09 |
$ 0.19 |
$ – |
Years |
0 |
1 |
2 |
3 |
4 |
5 |
5 |
Initial Investment |
$ -2.400 |
||||||
Cash flows before loan repayment and interest |
$ 1.040 |
$ 0.600 |
$ 0.965 |
$ 0.550 |
$ 0.700 |
||
Less: Principle |
$ 0.214 |
$ 0.266 |
$ 0.266 |
$ 0.266 |
$ 0.190 |
||
Less: Interest |
$ 0.068 |
$ 0.016 |
$ 0.016 |
$ 0.016 |
$ 0.093 |
||
Salvage Value |
$ 0.240 |
||||||
Net Cash Flows |
$ -2.400 |
$ 0.757 |
$ 0.317 |
$ 0.682 |
$ 0.267 |
$ 0.417 |
$ 0.240 |
Discounting Factors at 12.50% |
$ 1.000 |
$ 0.889 |
$ 0.790 |
$ 0.702 |
$ 0.624 |
$ 0.555 |
$ 0.555 |
Present Values |
$ -2.400 |
$ 0.673 |
$ 0.251 |
$ 0.479 |
$ 0.167 |
$ 0.232 |
$ 0.133 |
NPV |
$ -0.465 |
Net Present Value= $ -0.465
Year |
Total Cash flows |
0 |
$ -2.400 |
1 |
$ 0.757 |
2 |
$ 0.317 |
3 |
$ 0.682 |
4 |
$ 0.267 |
5 |
$ 0.417 |
5 |
$ 0.240 |
3.85% |
Internal Rate of Return= 3.85%
Year |
Cash flows |
Cumulative Cash Flows |
0 |
$ -2.400 |
$ -2.400 |
1 |
$ 0.757 |
$ -1.643 |
2 |
$ 0.317 |
$ -1.325 |
3 |
$ 0.682 |
$ -0.643 |
4 |
$ 0.267 |
$ -0.375 |
5 |
$ 0.417 |
$ 0.042 |
5 |
$ 0.240 |
$ 0.282 |
3.10 Years |
Payback Period= 3.10 Years
Accounting Rate of Return= Average Annual Accounting Profit
Average Investment
|
Average Profits = 0.012 + 0.008 + 0.603 + 0.327 + 0.483 =$ 0.286
5
Average Investment= salvage value + 0.5 (Initial investment – salvage value)
= .0240 + 0.5 (2.40-.0240)
= $ 1.32
Accounting Rate of Return= 22%
Profitability Index =
NPV + Initial investment |
Initial investment |
= 1.935
2.40
= .81
- Analysis
The net present value of the project is negative ($ -0.465) and it indicates that the project will not generate sufficient cash inflows to recover its cash outflows and hence it must not be accepted (Bierman & Smidt, 2012).
The payback period of 3.10 years whereas DCL has a policy of repaying its capital investment within 2.50 years. Payback of 3.10 years signifies that the project will recover its initial outlays in 3.10 years and after this period it will start generating returns. Hence, it must not be accepted (Kahraman, 2001).
The internal rate of return of the project is 3.85% which is quite lesser than the required rate of return of the project i.e. 12.50% and hence it must not be accepted as IRR is the discounting rate at which the project has no profit and no loss (Ryan & Ryan, 2002).
The accounting rate of return of the project is 21.70% which is greater than the project’s desired rate of return. Hence, the project can be accepted from the standpoint of ARR.
Lastly, the profitability index of any project must be at least one for its acceptance by the managers. However, in the present project, the PI is 0.81. Hence, the project must not be accepted from the viewpoint of profitability index (Graham & Harvey, 2002).
The four out of five capital budgeting techniques which are mostly used to evaluate the appropriateness of capital investment decision are providing unfavourable results for the acceptance of the project. Those techniques are NPV, IRR, Payback period and Profitability index.
The treatment of loan repayments and salvage value of the project equipment is explained as below:
The loan instalment includes both interest and principle element. The entire instalment amount of the loan per year is deducted from the cash flow amount of each particular year to reach at the amount of net cash flows. However, for the purpose of calculation of Accounting rate of return, where net profits are required to be taken into consideration, only the interest element was deducted from the cash flows and not the principle amount as it is a capital amount and need not be deducted from the profits of the company. Salvage value which is 10% of the initial investment in the new equipment will be treated as cash inflow of year 5, i.e. end of project’s life. Hence, for the calculation of net cash flows such inflow will be added to the cash flows of 5th year. However, since the question is silent on the tax rate applicable on the company it is assumed that the company is operating in tax free zone and hence it is not required to pay any tax obligations (Drake, 2006).
Net Present Value (NPV)
Therefore, the tax treatment of both interest payments and capital gain ($0.240 – $0.190= $0.50) is to be ignored (Ross, Westerfield & Jaffe, 1990).
Workings:
Total cost of new equipment |
$ 2.40 |
||
Rate of depreciation |
40% |
||
Depreciation |
|||
Year |
Opening Balance |
Depreciation |
Closing Balance |
1 |
$ 2.40 |
$ 0.96 |
$ 1.44 |
2 |
$ 1.44 |
$ 0.58 |
$ 0.86 |
3 |
$ 0.86 |
$ 0.35 |
$ 0.52 |
4 |
$ 0.52 |
$ 0.21 |
$ 0.31 |
5 |
$ 0.31 |
$ 0.12 |
$ 0.19 |
The tax benefits of depreciation is ignored in the present case as there is no tax rate given and it is assumed that there is no tax imposed on the company.
Unit sale |
143000 |
Unit price |
$ 99.00 |
Sales |
$ 141,57,000.00 |
Cash operating expenses |
$ 89,18,910.00 |
Administration Expenses |
$ 2,89,000.00 |
Equipment cost |
$ 107,00,000.00 |
Depreciation |
|
Salvage value |
$ 13,37,500.00 |
Working capital |
$ 4,20,000.00 |
Tax rate |
30% |
WACC |
10.16% |
Price inflation |
3.3% |
Variable cost and cash fixed cost inflation |
2.7% |
Depreciation Calculation |
||||
Years |
1 |
2 |
3 |
4 |
Opening WDV |
107,00,000.00 |
53,50,000.00 |
26,75,000.00 |
13,37,500.00 |
Depreciation rate |
50% |
50% |
50% |
50% |
Depreciation amount |
53,50,000.00 |
26,75,000.00 |
13,37,500.00 |
6,68,750.00 |
Closing WDV |
53,50,000.00 |
26,75,000.00 |
13,37,500.00 |
6,68,750.00 |
First of all, the rate of depreciation as per Straight line method is calculated by dividing the whole percentage by years of useful life i.e. years. This provided SLM depreciation rate of 25% p.a. This rate was then doubled as per the requirement of method of depreciation given in the question. The doubled rate of depreciation i.e. 50% was applied according to the diminishing balance method of depreciation.
Table showing calculations of cash flows after tax:
1 |
2 |
3 |
4 |
4 |
||
A. Sale Units |
1,43,000.00 |
1,43,000.00 |
1,43,000.00 |
1,43,000.00 |
||
B. Sale price |
99.00 |
102.27 |
105.64 |
109.13 |
||
Total Sales |
141,57,000.00 |
146,24,181.00 |
151,06,778.97 |
156,05,302.68 |
||
F. Cash operating cost |
(89,18,910.00) |
(92,13,234.03) |
(95,17,270.75) |
(98,31,340.69) |
||
Administration Expenses |
(2,89,000.00) |
(2,96,803.00) |
(3,04,816.68) |
(3,13,046.73) |
||
H. Depreciation |
(53,50,000.00) |
(26,75,000.00) |
(13,37,500.00) |
(6,68,750.00) |
||
I. Operating Profit |
(4,00,910.00) |
24,39,143.97 |
39,47,191.54 |
47,92,165.26 |
13,37,500.00 |
|
J. Tax @ 30% |
(1,20,273.00) |
7,31,743.19 |
11,84,157.46 |
14,37,649.58 |
2,00,625.00 |
|
K. Operating Profit after tax |
(2,80,637.00) |
17,07,400.78 |
27,63,034.08 |
33,54,515.68 |
11,36,875.00 |
|
Add Back: Depreciation (non-cash) |
53,50,000.00 |
26,75,000.00 |
13,37,500.00 |
6,68,750.00 |
||
Operating cash flows |
50,69,363.00 |
43,82,400.78 |
41,00,534.08 |
40,23,265.68 |
||
Working capital |
(2,10,000.00) |
|||||
Cash flows after tax |
-95,15,000.00 |
$ 50,69,363.00 |
$ 43,82,400.78 |
$ 38,90,534.08 |
$ 40,23,265.68 |
11,36,875.00 |
Cash flows |
-95,15,000.00 |
$ 50,69,363.00 |
$ 43,82,400.78 |
$ 38,90,534.08 |
$ 40,23,265.68 |
11,36,875.00 |
PVF @ 12.50% |
1 |
0.908 |
0.824 |
0.748 |
0.679 |
0.679 |
CFAT |
-95,15,000.00 |
46,01,818.26 |
36,11,305.57 |
29,10,297.87 |
27,32,014.52 |
7,71,999.48 |
NPV |
51,12,435.71 |
|
The net present value of the project is positive i.e. $ 5112435.71 and hence the project must be accepted.
Part 2: Sensitivity Analysis:
The sensitivity of the project on sales revenue will have to be examined in two parts as the sales figure covers two elements that are: the selling price per unit and the number of units. If change is made in any of these input variables, the net present value of the project will be adjusted accordingly. Following range of selling price and selling units will be taken to show the project’s sensitivity to the sales revenue.
- Sensitivity to change in number of units sold
With each 5% change in original sales units’ i.e.143000, the NPV will change as follows
Table-1:Sales Units |
|
NPV |
% Change |
Unit sales |
$ 51,12,435.71 |
5% |
1,50,150.00 |
5718492.216 |
10% |
1,57,300.00 |
6324548.722 |
15% |
1,64,450.00 |
6930605.228 |
20% |
1,71,600.00 |
7536661.734 |
25% |
1,78,750.00 |
8142718.241 |
Base value |
1,43,000.00 |
5112435.709 |
-5% |
1,35,850.00 |
4506379.203 |
-10% |
1,28,700.00 |
3900322.697 |
-15% |
1,21,550.00 |
3294266.191 |
-20% |
1,14,400.00 |
2688209.684 |
-25% |
1,07,250.00 |
2082153.178 |
- Sensitivity to change in unit price
With each 5% change in unit selling price i.e. $ 99, the NPV will change as follows
Table-2: Unit price |
|
NPV |
% Change |
Unit price |
$51,12,435.71 |
5% |
$ 103.95 |
5718492.216 |
10% |
$ 108.90 |
6324548.722 |
15% |
$ 113.85 |
6930605.228 |
20% |
$ 118.80 |
7536661.734 |
25% |
$ 123.75 |
8142718.241 |
Base value |
$ 99.00 |
5112435.709 |
-5% |
$ 94.05 |
4506379.203 |
-10% |
$ 89.10 |
3900322.697 |
-15% |
$ 84.15 |
3294266.191 |
-20% |
$ 79.20 |
2688209.684 |
-25% |
$ 74.25 |
2082153.178 |
- Sensitivity to change in Cost of capital
With each 5% change in original cost of capital i.e. 12.50%, the NPV will change as follows
Table-3: Cost of capital |
|
NPV |
% Change |
Rate |
$ 51,12,435.71 |
5% |
10.67% |
5036033.517 |
10% |
11.18% |
5030905.366 |
15% |
11.68% |
5025745.757 |
20% |
12.19% |
5020554.582 |
25% |
12.70% |
5015331.732 |
Base value |
10.16% |
5041130.318 |
-5% |
9.65% |
5046195.876 |
-10% |
9.14% |
5051230.3 |
-15% |
8.64% |
5056233.698 |
-20% |
8.13% |
5061206.178 |
-25% |
7.62% |
5066147.848 |
Scenario analysis considers 3 scenarios of the project situation. These are: worst case, base case and best case. Worst case is the case where the situations under which the project operates are unfavourable and best case is the case where the situations under which the project operates are favourable. In case of base case the project is operated under normal situations.
In all these cases the net present values of the projects are determined and analysed using the probability of all the three potential cases, under scenario analysis. Therefore, scenario analysis gives broader insights to the project manager about the effect of changes in the situations or parameters on project’s NPV. However, the sensitivity analysis undertakes only one input variable in one to check the project’s sensitivity. It is not capable of showing the impact of change in overall situation on the project’s net present value (Horngren et al., 2002). Scenario analysis, on the other hand takes into account all the factors in one go to determine the impact of changes on project’s returns. Hence, it gives additional insights while dealing with the probability of all the possible cases (Meier, Christofides & Salkin, 2001).
Risk is the uncertainty of returns to be generated from the project due to fluctuations resulting from factors like change in economic growth rate, inflation rate, demand of units to be sold etc. (Alessandri, Ford, Lander, 2004). In the present case the risk is priced on the basis of sensitivity analysis where the sensitivity of the project is analysed with respect to change in unit selling price and the number of units sold and also the change in cost of capital. Also, to check the risk of project, its net present value is also determined. The positive net present value of the project shows that project is capable of generating sufficient returns for the investors. In the present case, the NPV of the project is positive and hence it shows that the project will generate good amount of returns. Hence the project manager must be confident enough that its returns are in accordance with the risk of the project due to fluctuating cash flows.
References:
Alessandri, T.M., Ford, D.N., Lander, D.M., Leggio, K.B. and Taylor, M., 2004. Managing risk and uncertainty in complex capital projects. The Quarterly Review of Economics and Finance, 44(5), pp.751-767.
Bierman Jr, H. and Smidt, S., 2012. The capital budgeting decision: economic analysis of investment projects. Routledge.
Drake, P.P., 2006.Capital budgeting techniques: < www. fau. edu/~ ppeter/fin3403/module6/capbudtech. Pdf >
Graham, J. and Harvey, C., 2002. How do CFOs make capital budgeting and capital structure decisions?. Journal of applied corporate finance, 15(1), pp.8-23.
Horngren, C.T., Bhimani, A., Datar, S.M., Foster, G. and Horngren, C.T., 2002. Management and cost accounting. Harlow: Financial Times/Prentice Hall.
Kahraman, C., 2001. Capital budgeting techniques using discounted fuzzy cash flows. In Soft Computing for Risk Evaluation and Management (pp. 375-396). Physica, Heidelberg.
Meier, H., Christofides, N. and Salkin, G., 2001. Capital budgeting under uncertainty—an integrated approach using contingent claims analysis and integer programming. Operations Research, 49(2), pp.196-206.
Ross, S.A., Westerfield, R. and Jaffe, J.F., 1990. Corporate finance (Vol. 2). Homewood: Irwin.
Ryan, P.A. and Ryan, G.P., 2002. Capital budgeting practices of the Fortune 1000: how have things changed?. Journal of business and management, 8(4), p.355.