Monday, May 4, 2020

Capital Budgeting Decision Of Equator Ltd

Questions: 1.Calculate the NPV, Non-Discounted Payback, and the IRR of Plant A and Plant B. Interpret your results. (If relevant, state any assumptions you have made.)2.Describe and Analyse 4 keys risks associated with the Project you recommend (Project A or B). 3.Briefly define an Efficient Capital Market. To what extent is Equators ability to borrow funds in the Capital Market dependent upon the Capital Market Operating in an Efficient Manner? Answers: 1.Equator Ltd, an Australian manufacturer of laptop computers, is considering expanding its Australian operation into producing tablet computers. For this expansion the CFO has two options. The first option, Plant A, is a highly automated process that involves significant capital outlays but has lower running costs. Plant B is a more labour intensive facility that has lower initial capital outlays but higher running costs. Plant A and Plant B are mutually exclusive projects. A capital budgeting analysis of both the options was carried out to decide which project the company must choose to manufacture the tablet computers. The incremental cash flow for both the projects is presented below: PLANT A Year 0 1 2 3 4 5 6 Sales Units 155000 163525 172518.875 182007.4131 192017.8208 202578.801 Selling price $320.0 $331.2 $342.8 $354.8 $367.2 $380.1 Revenue $4,96,00,000.0 $5,41,59,480.0 $5,91,38,090.2 $6,45,74,359.1 $7,05,10,357.1 $7,69,92,021.7 Cash operating expenses: Variable cost $33,79,000.0 $35,64,845.0 $37,60,911.5 $39,67,761.6 $41,85,988.5 $44,16,217.9 Labour costs $22,01,000.0 $23,22,055.0 $24,49,768.0 $25,84,505.3 $27,26,653.1 $28,76,619.0 Fixed costs $6,00,000.0 $6,00,000.0 $6,00,000.0 $6,00,000.0 $6,00,000.0 $6,00,000.0 Sales and marketing exp. $19,00,000.0 $19,66,500.0 $20,35,327.5 $21,06,564.0 $21,80,293.7 $22,56,604.0 Total cash operating expenses $80,80,000.0 $84,53,400.0 $88,46,007.0 $92,58,830.8 $96,92,935.3 $1,01,49,440.8 Depreciation $29,20,083.3 $29,20,083.3 $29,20,083.3 $29,20,083.3 $29,20,083.3 $29,20,083.3 Total operating expenses $1,10,00,083.3 $1,13,73,483.3 $1,17,66,090.3 $1,21,78,914.2 $1,26,13,018.6 $1,30,69,524.1 Operating income before taxes $3,85,99,916.7 $4,27,85,996.7 $4,73,71,999.9 $5,23,95,445.0 $5,78,97,338.5 $6,39,22,497.5 Tax @30% $1,15,79,975.0 $1,28,35,799.0 $1,42,11,600.0 $1,57,18,633.5 $1,73,69,201.6 $1,91,76,749.3 Operating income after taxes $2,70,19,941.7 $2,99,50,197.7 $3,31,60,399.9 $3,66,76,811.5 $4,05,28,137.0 $4,47,45,748.3 After tax operating cash flow $2,99,40,025.0 $3,28,70,281.0 $3,60,80,483.2 $3,95,96,894.8 $4,34,48,220.3 $4,76,65,831.6 Terminal year after tax non operating cash flow After tax salvage value $86,29,500 Return of net working capital $35,00,000 Initial investment -$12,65,00,000 Total after tax cas flow -$12,65,00,000 $2,99,40,025.0 $3,28,70,281.0 $3,60,80,483.2 $3,95,96,894.8 $4,34,48,220.3 $5,97,95,331.61 Discount at 13.35% $1.0 $0.882 $0.778 $0.687 $0.606 $0.534 $0.471 Present value of cash flows -$12,65,00,000.0 $2,64,13,784.7 $2,55,83,524.1 $2,47,74,663.9 $2,39,86,950.1 $2,32,20,115.2 $2,81,92,794.9 NPV = sum of present value of all cash flows = $25,671,833 IRR = 20% (using the excel formula) Payback period Year Amount Cumulative value 0 -$12,65,00,000.0 -$12,65,00,000.0 1 $2,99,40,025.0 -$9,65,59,975.0 2 $3,28,70,281.0 -$6,36,89,694.0 3 $3,60,80,483.2 -$2,76,09,210.8 4 $3,95,96,894.8 $1,19,87,684.1 5 $4,34,48,220.3 $5,54,35,904.4 6 $5,97,95,331.6 $11,52,31,236.0 Payback period = 3+(-$2,76,09,210.8 / $3,95,96,894.8) = 3.7 years Working Notes 1. Initial Investment Land $1,16,50,000 Building $8,20,00,000 Machinery $2,61,50,000 Furnishing fittings $32,00,000 Increase in working capital $35,00,000 $12,65,00,000 2. Terminal value Salvage value $86,29,500 Book value $86,29,500 Profit on sale $0 Terminal value $86,29,500 Depreciation Machinery $2,61,50,000 Salvage value 33% $86,29,500 Depreciable value $1,75,20,500 Depreciation $29,20,083.33 The incremental cash flow for project B is presented below: Year 0 1 2 3 4 5 Sales Units 95000 100225 105737.375 111552.9306 117688.3418 Selling price $440.0 $455.4 $471.3 $487.8 $504.9 Revenue $4,18,00,000.0 $4,56,42,465.0 $4,98,38,148.6 $5,44,19,520.4 $5,94,22,034.8 Cash operating expenses: Variable cost $34,01,000.0 $35,88,055.0 $37,85,398.0 $39,93,594.9 $42,13,242.6 Labour costs $23,75,000.0 $25,05,625.0 $26,43,434.4 $27,88,823.3 $29,42,208.5 Fixed costs $8,00,000.0 $8,00,000.0 $8,00,000.0 $8,00,000.0 $8,00,000.0 Sales and marketing exp. $28,00,000.0 $28,98,000.0 $29,99,430.0 $31,04,410.1 $32,13,064.4 Total cash operating expenses $93,76,000.0 $97,91,680.0 $1,02,28,262.4 $1,06,86,828.2 $1,11,68,515.6 Depreciation $13,60,100.0 $13,60,100.0 $13,60,100.0 $13,60,100.0 $13,60,100.0 Total operating expenses $1,07,36,100.0 $1,11,51,780.0 $1,15,88,362.4 $1,20,46,928.2 $1,25,28,615.6 Operating income before taxes $3,10,63,900.0 $3,44,90,685.0 $3,82,49,786.2 $4,23,72,592.2 $4,68,93,419.2 Tax @30% $93,19,170.0 $1,03,47,205.5 $1,14,74,935.9 $1,27,11,777.7 $1,40,68,025.8 Operating income after taxes $2,17,44,730.0 $2,41,43,479.5 $2,67,74,850.3 $2,96,60,814.5 $3,28,25,393.5 After tax operating cash flow $2,31,04,830.0 $2,55,03,579.5 $2,81,34,950.3 $3,10,20,914.5 $3,41,85,493.5 Terminal year after tax non operating cash flow After tax salvage value $33,49,500 Return of net working capital $48,00,000 Initial investment -$8,90,80,000 Total after tax cash flow -$8,90,80,000 $2,31,04,830.0 $2,55,03,579.5 $2,81,34,950.3 $3,10,20,914.5 $4,23,34,993.5 Discount at 13.35% $1.0 $0.882 $0.778 $0.687 $0.606 $0.534 Present value of cash flows -$8,90,80,000.0 $2,03,83,617.1 $1,98,49,889.4 $1,93,18,863.7 $1,87,91,805.1 $2,26,25,171.2 NPV = $1, 18, 89,346.5 IRR = 18% (using the excel formula) Payback period Year Amount Cumulative value 0 -$8,90,80,000.0 -$8,90,80,000.0 1 $2,31,04,830.0 -$6,59,75,170.0 2 $2,55,03,579.5 -$4,04,71,590.5 3 $2,81,34,950.3 -$1,23,36,640.2 4 $3,10,20,914.5 $1,86,84,274.4 5 $4,23,34,993.5 $6,10,19,267.8 Payback period = 3+ (-$1,23,36,640.2 / $3,10,20,914.5) = 3.4 years Working Notes1. Initial Investment Land $1,16,50,000 Building $5,95,00,000 Machinery $1,01,50,000 Furnishing fittings $29,80,000 Increase in working capital $48,00,000 $8,90,80,000 2. Terminal value Salvage value $33,49,500 Book value $33,49,500 Profit on sale $0 Terminal value $33,49,500 3. Depreciation Machinery $1,01,50,000 Salvage value 33% $33,49,500 Depreciable value $68,00,500 Depreciation $13,60,100.00 The result of the analysis is given below: Particulars Plant A Plant B NPV $25,671,833 $11,889,346.5 Non-discounted payback 3.7 years 3.4 years IRR 20% 18% Plant A has a higher NPV and IRR while plant B has a better payback period. However, we will consider Plant A and decide on choosing Plant A for manufacturing the tablet computers because for mutually exclusive projects, the project with a higher NPV should be preferred over all other capital budgeting techniques. This is NPV is considered the best technique as it takes into account the time value of money unlike IRR and non discounted payback period. Also NPV considers all the future cash flows of the project unlike payback period. NPV is the excess of cash inflows over the cash outflows. Hence, higher the NPV, higher is the profitability of the project. Therefore the company should set up Plant A which is highly automated as it has a higher NPV. There were certain assumptions which were made while doing the analysis. The discount rate considered for discounting the future cash flows is the WACC used by the Computer Tablet industry. This is because the discount factor should be such that it incorporates the risk of the project, and since this project is related to the Computer Tablet industry, hence, it is better to take WACC of industry instead of the WACC of the company. The working capital is assumed to be recovered at the end of life of the project. The head office expenses have not been considered in the analysis because it is not an incremental expense and does not arise as a result of the project. 2.Capital budgeting is based on the estimation of the various inflows and outflows related to the project. The management of the company expects the project to deliver the required benefits in order to be profitable. The various types of risks that may be associated with the Project A (recommended) are discussed below: a) Stand alone risk this risk pertains only to the project in question and does not affect the other assets of the company. The risk is associated with the estimation of the future inflows outflows and is quantified by the amount of deviation of the actual inflows and outflows to the estimated one (Burja1, Burja2, 2009) b) Company risk the project is part of the company and hence it also poses risk for the company as a whole as to how the earnings of the company will be affected as a result of undertaking the project. Also the risk of the project may be diversified by the companys other assets. c) Market risk this risk is associated with the market conditions of the economy. The future estimations are based on the overall economic growth and the inflation rate, as given in this case also, so there is a risk that the economic conditions may change and as such all the estimations may go wrong resulting in negative effects for the project. Market risk also includes the change in demand of the tablet computers. The estimations are based on the current market scenario, however if the demand changes, risk of project failure increases. d) Industry specific risk this involves the legal and technological risk of the industry. Under legal risk, there might be a change in the government policies for the industry which may affect the companys earnings. Also a technological advancement may render the tablet computers outdated which would decrease its market demand. 3.Efficient capital market is a market where the prices of a security reflect the new information accurately and that too in real time. A market is said to be efficient if the share prices can fully incorporate and induct the information which includes the basic value of the share. The value of the share is the present value of all the future cash flows associated with the share. The cash flows are in the form of dividends and the selling price of the share in the end. Such efficient markets are said to exist in the real world due to the capital markets being more and more organized and with the transaction costs being very low and information being easily available to all participants, the markets are said to be efficient. The efficient market hypothesis assumes that no analyst or trader can profits from trading as the trading will push the prices of the shares to its real value and thus the shares will be accurately priced. Three forms of efficiency in capital markets are said to e xist which are weak form efficiency in which assumes that all the past activities and information of the stock is incorporated into its price and hence technical analysis is useless in this market form. Under semi strong form, the stock prices are assumed to reflect all publicly available information accurately. However, there exists scope for making abnormal gains by accessing private information available to the insiders of the company. Under strong form, the share prices reflect all information whether public or private and neither technical nor fundamental analysis is useful in this market form. The importance of efficiency of capital markets lies in two ways. First, if the investors can make excess profits by applying trading strategies and second if the stock price reflects all information accurately, the new capital goes to the investment which has it highest valued use (Jones, Netter, NA) Capital markets are used to raise funds by government for infrastructure projects and by private firms for growth and expansion (Marwa, 2016). The primary role of a capital market is allocation of the ownership of the capital stock of the economy. Therefore a capital market allows the firms to make investment decisions and the investors can choose from the various stocks available in the market which represent the firms activities. Also the investors assume that the prices of the stock fully reflect the available information (Fama, 2010). The shareholders of a company want the companys management to maximize the stock prices and thus will ensure the company invest in high valued investments which will increase the shareholder return. Thus if the stock market is efficient, the company can emphasize on investing in long term projects as the funds are easily available and also the prices of new share at which the investors are willing to invest are determine by the market and reflects t he value of the future cash flows of the project. Moreover, a company whose stocks have appreciated finds it easier to raise funds in a capital market because higher share prices means a small ownership of the company needs to be given to raise capital. Favourable economic conditions also make it easier to raise funds. Since the tablets computer industry is a hot industry, thus it will be easier for Equator Ltd. to raise funds in the capital market and that too at the correct prices. References: Burja1, C., Burja2, V., (2009), The Risk Analysis for Investments Projects Decision, Annales Universitatis Apulens Series Oeconomica, Vol.11, No.1 Fama, E.F., (2010), Efficient Capital Markets: A review of Theory and Empirical Work, The Journal of Finance, Vol.25, N0.2 Marwa, M., (2016), Market Data Review: The Role of Capital Markets in Financing Development, accessed online on 13th Feb, 2016, available at https://www.thecitizen.co.tz/News/Business/The-role-of-capital-markets-in-financing-development/1840414-3445302-vd9vvi/index.html Jones, S.L, Netter, J.M., (NA), Efficient Capital Markets, accessed online on 13th February, 2017, available at, https://www.econlib.org/library/Enc/EfficientCapitalMarkets.html

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.