Question 1: Capital Budgeting
Initech is in the process of evaluating two long term investment projects. A capital budgeting analysis was performed for both the proposals and the results are presented below. NPV analysis has been used for both the proposals project as this is the most common and useful technique of capital budgeting. NPV is the difference of the present value of all cash inflows and the cash outflows. NPV is the chosen method because it has many advantages like it considers the time value of money, it takes into consideration all the cash flows related to the project, it gives a fair estimate of the profits and the value which would be added to the company because of the project.
In this project, the company is considering whether it should expand into production of a part for new generation mobile devices as the company expects high growth in this sector for the next five years.
Year |
0 |
1 |
2 |
3 |
4 |
5 |
Sales |
$40,00,000 |
$44,00,000 |
$48,40,000 |
$41,14,000 |
$34,96,900 |
|
Variable costs |
$20,00,000 |
$22,00,000 |
$24,20,000 |
$20,57,000 |
$17,48,450 |
|
Building rental, fixed salaries and other fixed costs |
$15,00,000 |
$15,30,000 |
$15,60,600 |
$15,91,812 |
$16,23,648 |
|
Depreciation |
$80,000 |
$80,000 |
$80,000 |
$80,000 |
$80,000 |
|
Operating income |
$4,20,000 |
$5,90,000 |
$7,79,400 |
$3,85,188 |
$44,802 |
|
$1,26,000 |
$1,77,000 |
$2,33,820 |
$1,15,556 |
$13,441 |
||
Income after tax |
$2,94,000 |
$4,13,000 |
$5,45,580 |
$2,69,632 |
$31,361 |
|
Cash flows from operations |
$3,74,000 |
$4,93,000 |
$6,25,580 |
$3,49,632 |
$1,11,361 |
|
Additional after tax profits |
$1,50,000 |
$1,50,000 |
$1,50,000 |
$1,50,000 |
$1,50,000 |
|
Initial investment |
-$8,00,000 |
|||||
Investment in working capital |
-$4,40,000 |
-$4,84,000 |
-$4,11,400 |
-$3,49,690 |
||
Recovery of working capital |
$16,85,090 |
|||||
After tax salvage value of P&E |
$2,60,000 |
|||||
Net cash flows |
-$8,00,000 |
$84,000 |
$1,59,000 |
$3,64,180 |
$1,49,942 |
$22,06,451 |
Cost of capital @ 14% |
$1 |
$0.877 |
$0.769 |
$0.675 |
$0.592 |
$0.519 |
Present value of cash flows |
-$8,00,000 |
$73,684 |
$1,22,345 |
$2,45,811 |
$88,777 |
$11,45,962 |
NPV = sum of present value of cash inflows – cash outflows
= $16, 76,580 – $8, 00,000
= $8, 76,580
IRR = 36%
Salvage value of P&E |
|
Sale value |
$2,00,000 |
Book value |
$4,00,000 |
Loss on sale |
$2,00,000 |
Tax on loss |
$60,000 |
After tax salvage value |
$2,60,000 |
Here we see that the NPV of the project is positive which means that the project will add value to the company to the extent of the value of NPV. Also the IRR of the project is more than the discount factor which means that it is more than the required rate of return by the company. Hence, it is recommended that the company should go ahead with its proposal of production of a part for the new generation mobile devices.
Under this project, the company needs to install a new conveyer system as soon as possible because the existing system is beyond repair. The company has three options to choose from. The options are System A, System B and System C. Again a NPV analysis has been performed to give recommendation as to which option must be chosen.
Since all the systems only involve cash outflows, tax benefit on the cash outflows has been taken into consideration.
The table of cash flows for the three systems is presented below:
Net cash outflows |
Tax on cash outflows @ 30% |
After tax cash outflows |
Cost of capital |
Present value of cash outflows |
|||||||||
Year |
System A |
System B |
System C |
System A |
System B |
System C |
System A |
System B |
System C |
System A |
System B |
System C |
|
0 |
$40,000 |
$55,000 |
$1,30,000 |
$0 |
$0 |
$0 |
$40,000 |
$55,000 |
$1,30,000 |
$1 |
$40,000 |
$55,000 |
$1,30,000 |
1 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.877 |
$14,825 |
$10,263 |
$1,596 |
2 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.769 |
$13,004 |
$9,003 |
$1,400 |
3 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.675 |
$11,407 |
$7,897 |
$1,228 |
4 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.592 |
$10,006 |
$6,927 |
$1,078 |
5 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.519 |
$8,777 |
$6,077 |
$945 |
6 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.456 |
$7,699 |
$5,330 |
$829 |
7 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.400 |
$6,754 |
$4,676 |
$727 |
8 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.351 |
$5,924 |
$4,102 |
$638 |
9 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.308 |
$5,197 |
$3,598 |
$560 |
10 |
$13,000 |
$9,000 |
$1,400 |
$3,900 |
$2,700 |
$420 |
$16,900 |
$11,700 |
$1,820 |
$0.270 |
$4,559 |
$3,156 |
$491 |
11 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.237 |
$0 |
$0 |
$431 |
||
12 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.208 |
$0 |
$0 |
$378 |
||
13 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.182 |
$0 |
$0 |
$331 |
||
14 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.160 |
$0 |
$0 |
$291 |
||
15 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.140 |
$0 |
$0 |
$255 |
||
16 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.123 |
$0 |
$0 |
$224 |
||
17 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.108 |
$0 |
$0 |
$196 |
||
18 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.095 |
$0 |
$0 |
$172 |
||
19 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.083 |
$0 |
$0 |
$151 |
||
20 |
$1,400 |
$0 |
$0 |
$420 |
$0 |
$0 |
$1,820 |
$0.073 |
$0 |
$0 |
$132 |
||
NPV |
$128,152 |
$116,029 |
$142,054 |
Here we will select the system which has the lowest NPV because there are all cash outflows. Hence, System B is the most profitable as it has the lowest NPV and hence would require minimum cash outflows.
a) An average risk capital investment project by Mantra group could be getting the management Letting Rights (MLR) to operate a property owned by someone else. The capital investment required for such an arrangement would be the up gradation of the apartment which the company wishes to get the rights for. A hypothetical investment of $10 million would be required which would include apartment up gradation costs and an increase in working capital required for operations. It is expected, the project would continue for 5-8 years after which the company will hand over the property to the owner. The cash inflows would be in the form of rent from room occupied by the customers. The cash outflows would be in the form of rent paid to the owner, salaries paid to the employees, the expenses relating to restaurant expenses, cleaning and laundry, sales and marketing costs.
The device part project
The most sensitive factor to the NPV would be the number of rooms occupied. If the rooms occupied are less than the anticipated, it would lead to losses because the company would have many fixed operating costs like rent and salary. Also WACC would be a sensitive factor. The company could take its current WACC as the cost of capital as the project relates to the current company business.
b) Working capital management is the firm’s ability to meet its short term obligations i.e. pay for its current liabilities with its current assets. An efficient working capital management ensures that a company uses its current assets like cash, inventories and receivables to pay for its liabilities like short term debt and payables.
The working capital management of Mantra Group Ltd. was analysed. In order to do so, cash conversion cycle was worked upon to see how well the company is managing its working capital.
Cash conversion cycle = Days inventory outstanding + days sales outstanding – days payables outstanding
On the basis of the annual report of the company for the years 2015 and 2016, the cash conversion cycle has been calculated as follows:
In $Million |
||
Particulars |
2015 |
2016 |
Inventory |
2 |
3 |
Receivables |
36 |
41 |
Payables |
14 |
15 |
Revenue |
466 |
574 |
2015 |
2016 |
|
Days inventory outstanding |
1.6 |
1.9 |
Days sale outstanding |
28.2 |
26.1 |
Days payables outstanding |
11.0 |
9.5 |
Cash conversion cycle |
18.7 days |
18.4 days |
From the above table, we see that the cash conversion cycle is almost similar for both the years 2015 and 2016. This means the company takes on an average 18 days to convert its investment in inventory into cash. The company’s day’s inventory outstanding is very low at 2 days which means the inventory is fast moving. Inventory for the company is in the form of rooms, linen, cutlery etc. The company’s days sales outstanding is more than the days payables outstanding which means it pays its suppliers faster than it receives payment from its debtors. This has led to an increase in the conversion cycle.
However, if we compare the cycle to a competitor which is InterContinental Hotels Group which had a cash conversion cycle of 23 in 2016 (gurufocus, 2017), we see that Mantra group has a better management of working capital as it has a lower cash conversion cycle. InterContinental has very high day’s sales outstanding at 76 days. Hence, we can say Mantra has a good working capital management where inventory is fast moving, thus enabling free funds to meet in business expenses and also reasonable funds locked in receivables most of which is offset by outstanding payables.
a) Commercial papers are unsecured promissory note which are issued at a discount and are repaid at their face value on a specified date. They are used by corporations to finance their short term needs like working capital as they are cheaper than bank loans. Since commercial papers do not give high returns and are risky (as they are unsecured), they are normally issued by companies having a good credit rating (Gustke, 2011)
Hence, it can be said that Telstra has a low credit risk which is why it is able to finance its working capital with the issuance of commercial paper.
b) Telstra is using matching the maturities principle to finance its current assets i.e. it is using short term finance. It means the company is using short term finance to finance its short term assets or current assets. Alternatively the company may use long term finance like long term debt to finance its current assets but it is disadvantageous because the interest rate would be high and the risk exposure would also be high (Citeman, 2008)
Advantages of short term financing include low cost, convenient, flexibility in terms of obtaining finance as and when needed, easily available, no control of lenders in the business. All the above advantages are not there in long term financing.
Reference
Gurufocus, (2017), InterContinental Hotels Group PLC (NYSE:IHG), Cash Conversion Cycle, accessed online on 27th April, 2017, available at https://www.gurufocus.com/term/CCC/IHG/Cash-Conversion-Cycle-CCC/InterContinental-Hotels-Group-PLC
Gustke, C., (2011), Commercial Paper: More Risk, Less Return, accessed online on 27th April, 2017, available at, https://www.bankrate.com/investing/commercial-paper-more-risk-less-return/
Citeman, (2008), Current Assets Financing Policy, accessed online on 28th April, 2017, available at https://www.citeman.com/3679-current-assets-financing-policy.html