Investment Decisions – CA Inter FM Study Material is designed strictly as per the latest syllabus and exam pattern.
Investment Decisions – CA Inter FM Study Material
Theory Questions
Question 1.
Distinguish between Net Present Value method and Internal Rate of Return method. (4 Marks Nov. 2011, Nov. 2015)
Answer:
NPV: NPV or net present value refers to the net balance after subtracting present value of outflows from the present value of inflows. Present value is calculated by using cost of capital as discount rate.
As per NPV technique internal cash inflows are re-invested at cost of capital rate. NPV higher than zero indicates that project will provide return higher than cost of capital, zero NPV indicates that expected cash inflow will provide return equal to cost of capital and negative NPV indicates that project will fail to recover even cost of funds to be invested in proposal. Negative NPV leads to rejection of proposal. NPV is expressed in financial values and fails to provide actual rate of return associated with proposal.
IRR : IRR technique refers to actual rate of return associated with proposal. IRR refers to rate of discount at which present value of inflows and outflows are same or NPV is zero.
IRR is expressed in percentage terms. As per IRR technique internal cash inflows are re-invested at IRR rate. IRR rate is compared with desired rate of return. Proposal is accepted when IRR is higher than desired rate of return and rejected when it is lower than desired rate of return.
There may be contradictory results under NPV and IRR techniques in some situations due to size disparity problem, time disparity problem and unequal expected lives.
Question 2.
What is ‘Internal Rate of Return’? Explain. (4 Marks Nov. 2014, 2 Marks Jan. 2021)
Answer:
IRR technique refers to actual rate of return associated with proposal. IRR refers to rate of discount at which present value of inflows and outflows are same or NPV is zero. IRR is expressed in percentage terms. As per IRR technique internal cash inflows are re-invested at IRR rate.
IRR rate is com-pared with desired rate of return. Proposal is accepted when IRR is higher than desired rate of return and rejected when it is lower than desired rate of return.
Question 3.
Which method of comparing a number of Investment proposals is most suited if each proposal involves different amount of cash inflows? Explain and state its limitations. (4 Marks Nov. 2017)
Answer:
The best technique to compare number of investment proposals involves different amount of cash inflows is Profitability Index or Desirability Factor. In this technique present value of cash inflows is compared with present value of outflow and project is accepted if PI is 1 or above. It is calculated as :
Desirability Factor or Profitability index \(=\frac{\text { PV of Inflows }}{\text { PV of Outflows }}\)
Limitations of Profitability Index:
- This technique cannot be used in case of capital rationing with indivisible projects.
- Many times single large project with high NPV is selected and ignored various small projects with higher cumulative NPV than selected single one.
- There is a situation where a project with a lower profitability index may generate cash flows in such a way that another project can be also taken after one or two years later, the total NPV in such case will be higher than NPV of another project with highest Profitability Index today.
Question 4.
Explain the steps while using the equivalent annualized criterion. (3 Marks Nor. 2019)
Answer:
Following are the steps involved in Equivalent Annualised Criterion :
Step 1 : Calculate NPV of the projects or PV of outflow of the projects.
Step 2 : Calculate Equivalent Annualized NPV or Outflow :
Equivalent Annualised NPV or Outflow \(=\frac{\text { NPV or PV of Outflow }}{\text { PVIFA }}\)
Step 3: Select the proposal having higher annualised NPV or Lower annualised outflow.
Practical Problems
Net Present Value
Question 1.
Domestic services (P) Ltd. is in the business of providing cleaning sewerage line services at homes. There is a proposal before the company to purchase a mechanised sewerage cleaning system for a sum of ₹ 20 lakhs. The present system of the company is to use manual labour for the job.
You are provided with the following information :
Proposed Machanised System :
Cost of machine : ₹ 20 lakhs
Life of machine : 10 years
Depreciation (on straight line basis) : 10%
Cash Operating cost of machanised system : ₹ 5 lakhs per annum
Present System (manual):
Manual labour : 200 persons
Cost of manual labour : ₹ 10,000 per person per annum
The company has after tax cost of fund at tax rate is 30%.
PV factor for 10 years at 10% are as given below :
Years | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
PV factor | 0.909 | 0.826 | 0.751 | 0.683 | 0.621 | 0.564 | 0.513 | 0.467 | 0.424 | 0.386 |
You are required to find out whether it is advisable to purchase the machine. Give your recommendation with workings. (8 Marks June 2015)
Answer:
Net Present Value
Year | Particulars | ₹ | DF @ 10% | PV |
0 | Cost of Machine | (20,00,000) | 1.000 | (20,00,000) |
1 – 10 | Incremental CFAT | 11,10,000 | 6.144 | 68,19,840 |
NPV | 48,19,840 |
Recommendation : Company should purchase the machine having positive NPV.
Working Notes:
Calculation of Incremental CFAT:
Question 2.
PD Ltd. an existing company is planning to introduce a new product with projected life of 8 years. Project cost will be ₹ 2,40,00,000. At the end of 8 years no residual value will be realized. Working capital of ₹ 30,00,000 will be needed. The 100% capacity of the project is 2,00,000 units p.a. but the production and sales volume are expected as under :
Other information :
1. Selling price per unit ₹ 200.
2. Variable cost is 40% of sales.
3. Fixed cost p.a. ₹ 30,00,000.
4. In addition to these advertisement expenditure will have to be incurred as under:
Year | (₹ in Lacs) |
1 | 50 |
2 | 25 |
3-5 | 10 |
6-8 | 5 |
5. Income tax is 25%.
6. Straight line method of depreciation is permissible for tax purpose.
7. Cost of capital is 10%.
8. Assume that loss cannot be carried forward.
Present value table
Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
PVF@10% | 0.909 | 0.826 | 0.751 | 0.683 | 0.621 | 0.564 | 0.513 | 0.467 |
Advise about the project acceptability. (10 Marks Nov. 2018)
Answer:
Net Present Value
Company should accept the proposal having positive NPV of the project.
Working Notes:
1. Depreciation \(=\frac{\text { Original Cost less Salvage }}{\text { Life of Equipment }}\) \(=\frac{2,40,00,000}{8 \text { Years }}\) = 30,00,000
2. Statement showing CFAT :
Question 3.
CK Ltd. is planning to buy a new machine. Details of which are as follows:
Cost of the machine at the commencement : ₹ 2,50,000
Economic life of the machine : 8 years
Residual value : Nil
Annual production capacity of the machine : 1,00,000 units
Estimated selling price per unit : ₹ 6
Estimated variable cost per unit : ₹ 3
Estimated annual fixed cost(Excluding depreciation) : ₹ 1,00,000
Advertisement expenses in 1 st year in addition of fixed cost : ₹ 20,000
Maintenance expenses in 5th year in addition of fixed cost : ₹ 30,000
Cost of capital : 12%
Ignore tax.
Analyse the above mentioned proposal using the Net Present Value method and advice.
Note: The PV factors at 12% are
Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
PV Factor | .893 | .797 | .712 | .636 | .567 | .507 | .452 | .404 |
(5 Marks Nov. 2020)
Answer:
Statement of NPV
Working Note:
Calculation of Annual Cash Inflow
Advise : CK limited should buy machine having positive NPV.
Various Techniques
Question 4.
A Ltd. Is considering the purchase of a machine which will perform some operations which are at present preformed by workers. Machines X and Y are alternative models. The following details are available :
Particulars | Machine X | Machine Y |
Cost of machine | ₹ 1,50,000 | ₹ 2,40,000 |
Estimated life of machine | 5 years | 6 years |
Estimated cost of maintenance per annum | ₹ 7,000 | ₹ 11,000 |
Estimated cost of indirect materials per annum | ₹ 6,000 | ₹ 8,000 |
Estimated savings in scrap per annum | ₹ 10,000 | ₹ 15,000 |
Estimated cost of supervision per annum | ₹ 12,000 | ₹ 16,000 |
Estimated saving in wages per annum | ₹ 90,000 | ₹ 1,20,000 |
Depreciation will be charged on straight line basis. The tax rate is 30%. Evaluate the alternation according to :
(a) Average rate of return method, and
(b) Present value index method assuming cost of capital being 10%.
(The present value of ₹ 1.00 @ p.a. for 5 years is 3.79 and for 6 years is 4.354) (8 marks Nov. 2011)
Answer:
(a) Statement Showing Evaluation of Two Machines (ARR)
(b) Statement Showing Evaluation of Two Machines (PI)
Question 5.
SS limited is considering the purchase of a new automatic machine which will carry out some operations which are at present performed by manual labour. NM-A1 and NM-A2 two alternative models are available in the market.
The following details are collected:
Depreciation will be charged on a straight line method. Corporate tax rate is 30 per cent and expected rate of return may be 12 per cent.
You are required to evaluate the alternatives by calculating the :
(1) Pay- back Period.
(2) Accounting (Average) Rate of Return and
(3) Profitability Index or P.V. Index (P.V. factor for ₹ 1 @ 12% 0.893; 0.797; 0.712; 0.636; 0.567) (10 Marks Nov. 2012)
Answer:
Statement of Evaluation
Working Note:
Calculation of Profit After Tax & CFAT:
Question 6.
FH Hospital is considering to purchase a CT. Scan machine. Presently the hospital is outsourcing the CT-Scan Machine and is earning commission of 15,000 per month (net of tax). The following details are given regarding the machine:
Cost of CT-Scan machine : ₹ 15,00,000
Operating cost per annum (excluding depreciation) : ₹ 2,25000
Expected revenue per annum : ₹ 7,90,000
Salvage value of machine (after 5 years) : ₹ 3,00,000
Expected life of machine : 5 years
Assuming tax rate @ 30%, whether it would be profitable for the hospital to purchase the machine?
Give your recommendation under:
(i) Net Present Value Method, and
(ii) Profitability Index Method.
PV factors at 12% are given below:
Year | 1 | 2 | 3 | 4 | 5 |
PV factor | 0.893 | 0.797 | 0.712 | 0.636 | 0.567 |
Answer:
(i) Net Present Value
Recommendation: CT-Scan machine should not be purchased having negative NPV.
(ii) Profitability Index \(=\frac{\text { PV of Inflows }}{\text { PV of Outflows }}\) \(=\frac{12,06,538}{15,00,000}\) = 0.804
Recommendation : Since PI is less than 1, CT-Scan machine should not be purchased.
Working Notes:
Calculation of Incremental CFAT:
Question 7.
X Limited is considering to purchase of new plant worth ₹ 80,00,000. The rate of cost of capital is 10%. You are required to calculate :
(a) Pay-back period
(b) Net present value at 10 discount factor
(c) Profitability index at 10 discount factor
(d) Internal rate of return with the help of 10% and 15% discount factor.
The expected net cash flows after taxes and before depreciation and present value table are as follows :
(8 Marks May 2017)
Answer:
(a) Payback period: = 14,00,000 + 14,00,000 + 14,00,000 + 14,00,000 + 14,00,000 + 10,00,000/16,00,000 = 5.625 Years
(b) Calculation of NPV
(c) Calculation of PI: = PV of Inflow ÷ PV of Outflow
= 97,92,200 ÷ 80,00,000 = 1.224
(d) Calculation of IRR :
NPV at 10% 1792,200
NPV at 15% = 14,00,000 × 3.353 + 16,00,000 × .432 + 20,00,000 × .376 + 30,00,000 × .327 + 2000,000 × .284 + 8,00,000 × .247 – 80,00,000
= – 1,16,000
IRR = L + \(\frac{\mathrm{NPV}_{\mathrm{L}}}{\mathrm{NPV}_{\mathrm{L}}-\mathrm{NPV}_{\mathrm{H}}}\) × H – L
= 10% + \(\frac{17,92,200}{17,92,200(1,16,000)}\) × 5% = 14.7%
Question 8.
A firm can make investment in either of the following projects. The firm anticipates its cost of capital to be 10%. Pre-tax cash flows of the projects for five years are as follows :
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Project A (₹) | (2,00,000) | 35.000 | 80,000 | 90,000 | 75,000 ; | 20,000 |
Project B (₹) | (2,00,000) | 2,18,000 | 10,000 | 10,000 | 4,000 | 3,000 |
Ignore taxation. An amount of ₹ 35,000 will be spent on account of sales promotion in year 3 in case of project A. This has not been taken into account in pre-tax cash inflows.
The discount factors are as under :
Year | 0 | 1 | 2 | 3 | 4 | 5 |
PVF at 10% | 1 | 0.91 | 0.83 | 0.75 | 0.68 | 0.62 |
You are required to calculate for each project;
(a) The payback period
(b) The discounted payback period
(c) Desirability factor
(d) Net present value (8 Marks Nov. 2017)
Answer:
(a) Payback period:
Payback period A = 35,000 + 80,000 + 55,000 + 30,000/75,000 = 3.4 Years
Payback period B = 2,00,000/2,18,000 = 0.92 Years
Calculation of Present Value of pre-tax cash inflows :
(b) Discounted payback period:
Project A = 31,850 + 66,400 + 41,250 + 51,000 + 9,500/12,400 = 4.77 Years
Project B = 1,98,380 + 1,620/8,300 = 1.2 Years
(c) Desirability factor = PV of Inflow -F PV of Outflow
Project A = 2,02,900 ÷ 2,00,000 = 1.0145
Project B = 2,18,760 ÷ 2,00,000 = 1.0938
(d) NPV = PV of Inflow – PV of Outflow
Project A = 2,02,900 – 2,00,000 = 2,900
Project B = 2,18,760 – 2,00,000 = 18,760
Question 9.
AT Limited is considering three projects A, B and C. The cash flows associated with the projects are given below :
Projects | C0 | C1 | C2 | C3 | C4 |
A | (10,000) | 2,000 | 2,000 | 6,000 | 0 |
B | (2,000) | 0 | 2,000 | 4,000 | 6,000 |
C | (10,000) | 2,000 | 2,000 | 6,000 | 10,000 |
You are required to:
(a) Calculate the payback period of each of the three projects.
(b) If the cut-off period is two years, then which projects should be ac-cepted?
(c) Projects with positive NPV’s if the opportunity cost of capital is 10 per cent.
(d) “Payback gives too much weight to cash flows that occur after the cut-off date”. True or false?
(e) “If a firm used a single cut-off period for all projects, it is likely to accept too many short lived projects.” True or false?
Present value table:
Year | 0 | 1 | 2 | 3 | 4 | 5 |
PVF@ 10% | 1.000 | 0.909 | 0.826 | 0.751 | 0.683 | 0.621 |
(10 Marks May 2019)
Answer:
(a) Calculation of Cumulative Cash Flows:
Payback Period:
Project A = 3 Years
Project B = 2 Years
Project C = 3 Years
(b) If cut-off period is two years then company should accept
(c) NPV = Present value of Inflow – Present value of
Project A = 2,000 × 0.909 + 2,000 × 0.826 + 6.000 × 0.75) – 10,000 = (2,024)
Project B = 0 × 0.909 + 2,000 × 0.826 + 4,000 × 0.75 1 + 6,000 × 0.683 – 2,000 = 6,754
Project C = 2,000 × 0.909 + 2,000 × 0.826 + 6,000 × 0.751 + 10.000 × 0.683 – 10,000 = 4,806
Project B and C have positive NPV.
(d) False : Pavback only considers cash flows from the initiation of the project till it’s payback period is being reached, and ignores cash flows after the payback period.
(e) True : When a firm use a single cut-off period for all projects, it is likely to accept too many short lived projects having payback period within such cut-off date. Long term projects take time to reach at payback, in case of single cut-off date these long term projects arc ignored. Thus, payback is biased towards short-term projects.
Question 10.
A company wants to buy a machine, and two different models namely A and B are available. Following further particulars are available :
Particulars | Machine A | Machine B |
Original Cost (₹) | 8,00,000 | 6,00,000 |
Estimated life in years | 4 | 4 |
Salvage value (₹) | 0 | 0 |
The company provides depreciation under straight line method. Income tax rate applicable is 30%. The present value of ₹ 1 at 12% discounting factor and net profit before depreciation and tax are as under:
Calculate:
(1) NPV (Net Present Value)
(2) Discounted Pay- back Period
(3) PI (Profitability Index)
Suggest: Purchase of which machine is more beneficial under Discounted pay-back period method, NPV method and PI method. (10 Marks Jan. 2021)
Answer:
(1) NPV (Net Present Value) = PV of Inflows – PV of Outflows
Machine A = 8,18,909 – 8,00,000 = 18,909
Machine B = 6,17,425 – 6,00,000 = 17,425
(2) Discounted pay-back Period Machine A = 3 years + (8,00,000 – 5,31,437)/2,87,472 = 3.93 years
Machine B = 3 years + (6,00,000 – 5,22,025)/95,400 = 3.82 years
(3) PI (Profitability Index) = PV of Inflows ÷ PV of Outflows
Machine A = 8,18,909 ÷ 8,00,000 = 1.023
Machine B = 6,17,425 ÷ 6,00,000 = 1.029
Suggestion : As per NPV method Machine A is more beneficial and as per Discounted pay-back period method and PI method Machine B is more bene-ficial.
Working Notes:
1. Statement showing Present Value of CFAT and cumulative PV of CFAT of Machine A:
2. Statement showing Present Value of CFAT and cumulative PV of CFAT of Machine B :
Unequal Life
Question 11.
APZ limited is considering selecting a machine between two machines ‘A’ and ‘B’ The two machines have identical capacity, do exactly the same job, but designed differently. Machine A costs ₹ 8,00,000, having useful life of three years. It costs ₹ 1,30,000 per year to run. Machine B is an economic model costing ₹ 6,00,000, having useful life of two years. It costs ₹ 2,50,000 per year to run.
The cash flows of machines ‘A’ and ‘B’ are real cash flows. The costs are forecasted in rupees of constant purchasing power. Ignore taxes. The opportunity cost of capital is 10%.
The present value factors at 10% are:
Which machine would you recommend the company to buy? (8 marks Nov. 2013)
Answer:
Statement Showing Evaluation of Two Machines
Select the Machine A having lower equivalent annualized outflow.
Project Cost & Cost Of Capital
Question 12.
ANP Ltd. Is providing the following information :
Annual cost of saving : ₹ 96,000
Useful life : 5 years
Salvage value : zero
Internal rate of return : 15%
Profitability index : 1.05
Table of discount factor:
You are required to calculate:
(a) Cost of the project
(b) Payback period
(c) Net present value of cash Inflow
(d) Cost of capital (8 Marks May 2012)
Answer:
(a) Cost 0f the project:
At IRR.
PV of inflows = PV of outflows
PV of outflows = Annual cost of saving × Cumulative discount factor @ IRR for 5 years
= ₹ 96,000 × 3.353
Cost of project = ₹ 3,21,888
(b) Payback Period: \(=\frac{\text { Initial Outflow }}{\text { Equal Annual Cash Inflows / Saving }}\) = \(\frac{3,21,888}{96,000}\) = 3.353 year
(c) Net Present Value of cash inflows:
PI \(=\frac{\text { PV of Inflows }}{\text { PV of Outflows }}\)
1.05 = \(=\frac{\text { PV of Inflows }}{3,21,888}\)
PV of Inflows = 3.21,888 × 1.05 = ₹ 3,3 7,982.4
NPV = PV of inflows – PV of outflows
= ₹ 3,37,982.40 – ₹ 3,21,888 = ₹ 16,094.40
(d) Cost of Capital:
Cum DF @ cost of capital for 5 years \(=\frac{\text { Present Value of Inflows }}{\text { Annual Inflows }}\)
= \(\frac{3,37,982.40}{96,000}\) = 3.52
Cost of Capital = 13% (Given in table)
Question 13.
Given below are the data on a capital project ‘M’:
Annual cash inflow : ₹ 60,000
Useful life : 4 years
Salvage value : zero
Internal rate of return : 15%
Profitability index : 1.064
Table of discount factor:
You are required to calculate;
(i) Cost of the project
(ii) Payback period
(iii) Cost of capital
(iv) Net present value of cash inflow (8 Marks May 2015)
Answer:
(i) Cost of the project:
At IRR,
Present value of inflows = Present value of out flows
Present value of out flows = Annual cost of saving × Cumulative discount factor @ IRR for 4 years
= ₹ 60,000 × 2.855
Cost of project = ₹ 1,71,300
(ii) Payback Period: \(=\frac{\text { Initial Outflow }}{\text { Equal Annual Cash Inflows }}\) = \(\frac{1,71,000}{60,000}\)
= 2.855 years
(iii) Cost of Capital:
Cum DF @ cost of capital for 4 years \(=\frac{\text { Present Value of Inflows }}{\text { Annual Inflows }}\) = \(\frac{1,82,263.20}{60,000}\)
= 3.038
From the discount factor table, at discount rate of 12%, the cumulative discount factor for four years is 3.038 (0.893 + 0.797 + 0.712 4- 0.636)
Hence, Cost of capital = 12%
(iv) Net Present Value of cash inflows :
PI \(=\frac{\text { PV of Inflows }}{\text { PV of Outflows }}\)
1.064 = \(=\frac{\text { PV of Inflows }}{1,71,300}\)
PV of Inflows = 1,71,300 × 1.064 = ₹ 1,82,263.2
= PV of inflows – PV of outflows
= ₹ 1,82,263.20 – ₹ 1,71,300 = ₹ 10,963.20
Question 14.
Given below are the data on a capital project ‘C’:
Cost of the project : 12,28,400
Useful life : 4 years
Salvage value : zero
Internal rate of return : 15%
Profitability index : 1.0417
You are required to calculate:
(a) Annual cash flow
(b) Cost of capital
(c) Net present value (NPV)
(d) Discounted Payback period
Table of discount factor:
(8 Marks May 2016)
Answer:
(a) Annual cash flow:
At IRR,
Present value of inflows = Present value of outflows
Present value of outflows = Annual cash inflow × Cumulative discount factor @ IRR for 4 years
2,28,400 = Annual cash inflow × 2.855
Annual cash Inflow = ₹ 80,000
(b) Cost of Capital:
Present Value of inflows = Annual cash inflow × Cumulative discount factor @ Cost of Capital for 4 years
Cost of project + NPV = 80,000 × Cumulative discount factor @ Cost of Capital for 4 years
2,28,400 + 9,524 = 80,000 × PVIFA4
PVIFA = 2.974
Cost of capital = 13%
Alternatively
Cost of capital = 13%
From the discount factor table, at discount rate of 13%, the cumulative discount factor for four years is 2.974 (0.885 + 0.783 + 0.693 + 0.613)
(c) Nez Present Value (NPV): = Cost of project × (PI – 1)
= 2,28,400 × (1.0417 – 1) = ₹ 9,524
(d) Discounted Pay back Period = 3 years + \(\frac{2,28,400-1,88,80}{49,040}\) = 3.806 years
Working notes:
Calculation of PV of cash inflow cumulative PV of cash inflow:
Years | PV of cash inflow | Cumulative PV of cash inflow |
1 | 80,000 × 0.885 = 70,800 | 70,800 |
2 | 80,000 × 0.783 = 62,640 | 1,33,440 |
3 | 80,000 × 0.693 = 55,440 | 1,88,880 |
4 | 80,000 × 0.613 = 49,040 | 2,37,920 |
Question 15.
A proposal to invest in a project, which has a useful life of 5 years and no salvage value at the end of useful life, is under consideration of a firm. It is anticipated that the project will generate a steady cash inflow of ₹ 70,000 per annum. After analyzing other facts of the project, the following information were revealed :
Internal rate of return : 13%
Profitability index : 1.07762
Table of discount factor:
You are required to calculate:
(1) Cost of the project
(2) Payback period
(3) Net present value
(4) Cost of capital (8 Marks May 2018)
Answer:
(1) Cost of the project:
At IRR,
Present value of inflows = Present value of outflows
Present value of outflows = Annual cash inflows × Cumulative discount factor @ IRR for 5 years
= ₹ 70,000 × 3.517
Cost of the project = ₹ 2,46,190
(2) Payback period \(=\frac{\text { Initial Outflow }}{\text { Annual Cash Inflow }}\) = \(\frac{2,46,190}{70,000}\) = 3.517 years
(3) Net Present Value:
PI = \(\frac{2,65,299}{70,000}\) \(=\frac{\text { PV of Inflow }}{2,46,190}\)
PV of Inflows = ₹ 2,46,190 × 1.07762 = ₹ 2,65,299
NPV = PV of inflows – PV of outflows
= ₹ 2,65299 – ₹ 2,46,190 = ₹ 19,109
(4) Cost of Capital: Cum DF @ cost of capital for 5 years \(=\frac{\text { Present Value of Inflows }}{\text { Annual Inflows }}\) = \(\frac{2,65,299}{70,000}\)
= 3.790
Cost of capital = 10% (Given in table)
Capital Rationing
Question 16.
A company has ₹ 1,00,000 available for investment and has identified the following four investment in which to invest:
Project Name | Initial Investment | NPV |
C | ₹ 40,000 | ₹ 20,000 |
D | ₹ 1,00,000 | ₹ 35,000 |
E | ₹ 50,000 | ₹ 24,000 |
F | ₹ 60,000 | ₹ 18,000 |
You are required to optimise the returns from a package of projects within the capital spending limit if:
(a) The projects are independent of each other and are divisible.
(b) The projects are not divisible. (5 Marks Nov. 2019)
Answer:
(a) Statement of Rank and Selection of Projects
(Divisible Situation)
Optimum investment: 100% of C, E and 1/10 of D.
(b) Statement of Possible Combinations and Combined NPV
(Indivisible Situation)
Possible Combinations | Combined Investment | Combined NPV |
C + E | ₹ 90,000 | ₹ 44,000 |
C + F | ₹ 1,00,000 | ₹ 38,000 |
D | ₹ 1,00,000 | ₹ 35,000 |
Invest in combination of C and E having highest combined NPV and invest remaining ₹ 10,000 elsewhere.
Important Questions
Question 1.
XYZ Ltd. is planning to introduce a new product with a projected life of 8 years. The project to be set up in a backward region, qualifies for a one time (as its starting) tax free subsidy from the government of ₹ 20,00,000 equipment cost will be ₹ 140 lakhs and additional equipment costing ₹ 10,00,000 wall be needed at the beginning of the third year.
At the end of 8 years the original equipment will have no resale value but the supplementary equipment can be sold for ₹ 1,00,000. A working capital of ₹ 5,00,000 will be needed. The sales volume over the eight years period has been forecasted as follows :
A sale price of ₹ 100 per unit is expected and variable expenses will amount to 40% of sales revenue. Fixed cash operating costs will amount to ₹ 16,00,000 per year. In addition an extensive advertising campaign will be implemented requiring annual outlays as follows :
The company is subject to 50% tax rate and considers 12% to be an appropriate after tax cost of capital for this project. The company follows the straight line method of depreciation.
Should the project be accepted?
Answer:
Net Present Value
Company should accept the proposal having positive NPV of the project. Working Notes:
Working Notes:
1. Statement of CFAT
2. Depriciation :
3. Tax for year 2 = 50% of (26,00,000 – 13,00,000) = 6,50,000
Note : As per section 32 of Income Tax Act “Depreciation is not allowed on subsidized part of asset”
Question 2.
A Company is considering a proposal of installing a drying equipment. The equipment would involve a cash outlay of ₹ 6,00,000 and net Working Capital of ₹ 80,000. The expected life of the project is 5 years without any salvage value. Assume that the company is allowed to charge depreciation on straight-line-basis for Income-tax purpose.
The estimated before-tax cash inflows are given below :
year | 1 | 2 | 3 | 4 | 5 |
Before tax cash | ₹ 2,40,000 | ₹ 2,75,000 | ₹ 2,10,000 | ₹ 1,80,000 | ₹1,60,000 |
The applicable Income-tax rate to the Company is 35%. If the Company’s opportunity cost of capital is 12%, calculate the equipment’s net present value, discounted payback period, payback period, and internal rate of return.
The PV factors at 12%, 14% and 15% are :
Answer:
(1) Net Present Value
Working Notes:
Calculation of CFAT:
(2) Discounted Payback Period = 4 years + \(\frac{6,80,000-5,80,877}{1,28,234}\) = 4.77 years
(3) Payback Period = 3 years + \(\frac{6,80,000-5,97,250}{1,59,000}\) = 3.52 years
(4) Internal Rate of Return :
Calculation of NPV by Using DF @ 12% and 14%
Question 3.
A Ltd. Is considering the purchase of a machine which will perform some operations which are at present preformed by workers. Machines X and Y are alternative models. The following details are available :
Depreciation will be charged on straight line basis. The tax rate is 30%. Evaluate the alternation according to :
(a) Average rate of return method, and
(b) Present value index method assuming cost of capital being 10%.
(The present value of ₹ 1.00 @ p.a. for 5 years is 3.79 and for 6 years is 4.354)
Answer:
(a) Statement Showing Evaluation of Two Machines (ARR)
(b) Statement Showing Evaluation of Two Machines (PI)
Question 4.
Lockwood Limited wants to replace its old machine with a new automatic machine. Two models A and B are available at the same cost of ₹ 5 lakhs each. Salvage value of the old machine is ₹ 1 lakh. The utilities of the existing machine can be used if the company purchases A.
Additional cost of utilities to be purchased in that case are ₹ 1 lakh. If the company purchases B then all the existing utilities will have to be replaced with new utilities costing ₹ 2 lakhs. The salvage value of the old utilities will be ₹ 0.20 lakhs. The cash flows after taxation are expected to be :
The targeted return on capital is 15%. You are required to:
(a) Compute, for the two machines separately, Net Present Value, Dis-counted Payback Period and Desirability Factor and
(b) Advice which of the machines is to be selected?
Answer:
(a) Net Present Value
Discounted Payback Period
Machine A = 4 years + \(\frac{5,00,000-4,33,085}{1,09,384}\) = 4.612 years
Machine B = 4 years + \(\frac{5,80,000-5,48,257}{49,720}\) = 4.638 years
Profitability Index(PI) \(=\frac{\text { PV of Inflows }}{\text { PV of Outflows }}\)
Machine A = \(\frac{5,42,469}{5,00,000}\) = 1.085
Machine B = \(\frac{5,97,977}{5,80,000}\) = 1.031
Working note:
Calculation of Initial Investment
(b) Since the absolute surplus in the case of A is more than B and also the desirability factor, it is better to choose A. The discounted payback period in both the cases is same, also the net present value is positive in both the cases but the desirability factor (profitability index) is higher in the case of Machine A, it is therefore better to choose Machine A.
Question 5.
Hindlever Company is considering a new product line to supplement its range line. It is anticipated that the new product line will involve cash investments of ₹ 7,00,000 at time 0 and ₹ 10,00,000 in year 1.
After-tax cash inflows of ₹ 2,50,000 are expected in year 2, ₹ 3,00,000 in year 3, ₹ 3,50,000 in year 4 and ₹ 4,00,000 each year thereafter through year 10. Although the product line might be viable after year 10, the company prefers to be conservative and end all calculations at that time.
(a) If the required rate of return is 15 per cent, what is the net present value of the project? Is it acceptable?
(b) What would be the case if the required rate of return were 10 per cent?
(c) What is its internal rate of return?
(d) What is the project’s payback period?
Answer:
(a) Statement of NPV
(b) Statement of NPV
(c)
(d) Payback Period = -7,00,000 – 10,00,000 + 2,50,000 + 3,00,000 + 3,50,000 + 4,00,000 + 4,00,000
= 6 Years
Question 6.
Elite Cooker Company is evaluating three investment situations :
(1) produce a new line of aluminum skillets,
(2) expand its existing cooker line to include several new sizes, and
(3) develop a new, higher-quality line of cookers. If only the project in question is undertaken, the expected present values and the amounts of investment required are :
Project | Investment required | Present value of future cash flows |
1 | ₹ 2,00,000 | ₹ 2,29,000 |
2 | ₹ 1,15,000 | ₹ 1,85,000 |
3 | ₹ 2,70,000 | ₹ 4,00,000 |
If projects 1 and 2 are jointly undertaken, there will be no economies; the investments required and present values will simply be the sum of the parts. With projects 1 and 3, economies are possible in investment because one of the machines acquired can be used in both production processes.
The total investment required for projects 1 and 3 combined is ₹ 4,40,000. If projects 2 and 3 are undertaken, there are economies to be achieved in marketing and producing the products but not in investment.
The expected present value of future cash flows for projects 2 and 3 is ₹ 6,20,000. If all three projects are undertaken simultaneously, the economies noted will still hold. However, a ₹ 1,25,000 extension on the plant will be necessary, as space is not available for all three projects.
Which project or projects should be chosen ?
Answer:
Statement of Cumulative NPV of Different Combinations
Calculation of total investment required if all the three projects are undertaken simultaneously:
‘Totalinvestment = Investment in projects 1 & 3 + Investment in project 2 + Plant extension cost
= 4,40,000 + 1,15,000 + 1,25,000 = 16,80,000
Advise : Projects 1 and 3 should be chosen, as they provide the highest net present value.
Question 7.
Alley Pvt. Ltd. is planning to invest in a machinery that would cost ₹ 1,00,000 at the beginning of year 1. Net cash inflows from operations have been estimated at ₹ 36,000 per annum for 3 years. The company has two options for smooth functioning of the machinery: one is service, and another is replacement of parts. If the company opts to service a part of the machinery at the end of year 1 at ₹ 20,000, in such a case, the scrap value at the end of year 3 will be ₹ 25,000.
However, if the company decides not to service the part, then it will have to be replaced at the end of year 2 at ₹ 30,800 and in this case, the machinery will work for the 4th year also and get operational cash inflow of ₹ 36,000 for the 4th year. It will have to be scrapped at the end of year 4 at ₹ 18,000.
Assuming cost of capital at 10% and ignoring taxes, determine the purchase of this machinery based on the net present value of its cash flows?
If the supplier gives a discount of ₹ 10,000 for purchase, what would be your decision?
The PV factors at 10% are :
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
PV Factor | 1 | 0.9091 | 0.8264 | 0.7513 | 0.6830 | 0.6209 | 0.5645 |
Answer:
Option 1 (Part of the Machine is serviced) :
Statement of NPV
Option 2 (Part of the Machine is replaced):
Statement of NPV
Decision : Option I has a negative NPV whereas option II has a positive NPV ₹ 954. Therefore, option II (replacement of part) shall be opted.
If the supplier gives a discount of ₹ 10,000 for purchases:
Option 1: NPV = (9,875) + 10,000 = 125
Option 2: NPV = 954 + 10,000 = 10,954
Decision : Option I with very small NPV is not considerable, Option II having higher NPV shall be opted (student can also show annualized NPV due to difference in life of projects).
Question 8.
MNP Limited is thinking of replacing its existing machine by a new machine which would cost ₹ 60 lakhs. The company’s current production is ₹ 80,000 units, and is expected to increase to 1,00,000 units, if the new machine is bought. The selling price of the product would remain unchanged at ₹ 200 per unit. The following is the cost of producing one unit of product using both the existing and new machine :
The existing machine has an accounting hook value of ₹ 1,00,000, and it has been fully depreciated for tax purpose. It is estimated that machine will be useful for 5 years. The supplier of the new machine has offered to accept the old machine for ₹ 2,50,000.
However, the market price of old machine today is ₹ 1,50,000 and it is expected to be ₹ 35,000 after 5 years. The new machine has a life of 5 years and a salvage value of ₹ 2,50,000 at the end of its economic life.
Assume corporate Income tax rate at 40%, and depreciation is charged on straight line basis for Income-tax purposes. Further assume that book profit is treated as ordinary income for tax purpose. The opportunity cost of capital of the Company is 15%.
Required:
(i) Estimate net present value of the replacement decision.
(ii) Estimate the internal rate of return of the replacement decision.
(iii) Should Company go ahead with the replacement decision? Suggest.
Answer:
(i) Statement of NPV
Working Notes:
1. Calculation of initial outflow:
Cost of new machine : ₹ 60,00,000
Less : Exchange value of old machine : (₹ 2,50,000)
Add : Tax payment on profit on exchange of old machine (2,50,000 – Nil) × 40% : ₹ 1,00,000
Initial outflow : ₹ 58,50,000
2. Calculation of incremental CFAT:
Increase in sales (200 × 20,000 units) ₹ 40,00,000
Less : Increase in operating cost (1,00,000 × 148) – (80,000 × 173) (excluding Depreciation and Allocated overheads) : ₹ 9,60,000
Less : Increase in depreciation [(60,00,00 – 2,50,000) ÷ 5] – Nil : ₹ 11,50,000
Profit before tax : ₹ 18,90,000
Less : Tax @ 40% : ₹ 7,56,000
Profit after tax : ₹ 11,34,000
Add: Depreciation : ₹ 11,50,000
Incremental CFAT ₹ 22,84,000
3. Calculation of Incremental Salvage:
Notes :
(a) The old machine could be sold for ₹ 1,50,000 in the market. Since ex-change value is more than the market value, company will exchange it at ₹ 2,50,000.
(b) Old machine has fully depreciated for tax purpose, therefore depreciation of old machine as well as WDV are NIL.
(c) Allocated overheads are allocations from corporate office therefore they are irrelevant for computation of CFAT.
(ii) Calculation of IRR :
Since NPV computed in Part (i) is positive. Let us discount cash flows at higher rate say at 25% or 30%
Statement of NPV
IRR = 25% + \(\frac{3,67,404}{3,67,404+2,25,648}\) × 5% = 28.10%
(iii) Advise : The company should go ahead with replacement project, since it has positive NPV.
Question 9.
APZ limited is considering selecting a machine between two machines ‘A’ and ‘B’. The two machines have identical capacity, do exactly the same job, but designed differently.
Machine A costs ₹ 8,00,000, having useful life of three years. It costs ₹ 1,30,000 per year to run. Machine B is an economic model costing ₹ 6,00,000, having .iseful life of two years. It costs ₹ 2,50,000 per year to run.
The cash flows of machines ‘A’ and ‘B’ are real cash flows. The costs are forecasted in rupees of constant purchasing power. Ignore taxes. The opportunity cost of capital is 10%.
The present value factors at 10% are :
Which machine would you recommend the company to buy?
Answer:
Select the Machine A having lower equivalent annualized outflow
Question 10.
Total fund available is ₹ 3,00,000. Determine the optimal combination of projects assuming that the projects are
(a) Divisible or
(b) Indivisible.
Answer:
(a) Statement of Rank and Selection of Projects
(Divisible Situation)
Optimum investment: 100% of P, R, T and 1/4 of S.
(b) Statement of Possible Combinations and Combined NPV
(Indivisible Situation)
Invest in combination of P, R and T having highest combined NPV and invest remaining ₹ 50,000 elsewhere.
Question 11.
Using details given below, calculate MIRR considering 8% cost of Capital. Year Cash Plow
Answer:
Statement of Compounding Value
Calculation of MIRR :
Compound Factor \(=\frac{\text { Compound value of inflow }}{\text { Initial outflow }}\) = \(\frac{2,13,587}{1,36,000}\) = 1.5705
MIRR = \(\sqrt[5]{1.5705}\) – 1 = 9.45%
Question 12.
A large profit making company is considering the installation of a machine to process the waste produced by one of its existing manufacturing process to be converted into a marketable product. At present, the waste is removed by a contractor for disposal on payment by the company of ₹ 150 lakh per annum for the next four years.
The contract can be terminated upon installation of the aforesaid machine on payment of a compensation of ₹ 90 lakh before the processing operation starts. This compensation is not allowed as deduction for tax purposes.
The machine required for carrying out the processing will cost ₹ 600 lakh to be financed by a loan repayable in 4 equal instalments commencing from end of the year 1. The interest rate is 14% per annum. At the end of the 4th year, the machine can be sold for ₹ 60 lakh and the cost of dismantling and removal will be ₹ 45 lakh.
Sales and direct costs of the product emerging from waste processing for 4 years are estimated as under :
Initial stock of materials required before commencement of the processing operations is ₹ 60 lakh at the start of year 1. The stock levels of materials to be maintained at the end of year 1, 2 and 3 will be ₹ 165 lakh and the stocks at the end of year 4 will be nil. The storage of materials will utilise space which would otherwise have been rented out for ₹ 30 lakh per annum.
Labour costs include wages of 40 workers, wrhose transfer to this process will reduce idle time payments of ₹ 45 lakh in the year 1 and ₹ 30 lakh in the year 2. Factory overheads include apportionment of general factory overheads except to the extent of insurance charges of ₹ 90 lakh per annum payable on this venture. The company’s tax rate is 30%.
Present value factors for four years are as under:
Year | 1 | 2 | 3 | 4 |
PV Factors | 0.877 | 0.769 | 0.674 | 0.592 |
Advise the management on the desirability of installing the machine for processing the waste. All calculations should form part of the answer.
Answer:
Net present Value
Advice : Since the net present value of cash flows is ₹ 577.37 lakhs which is positive the management should install the machine for processing the waste.
Working Notes:
Statement of CFAT
Note : Income tax saving loss on sale of machine at the end of the project is ignored, student may calculate loss on sale of machine and tax saving.