Managerial Finance: Analysis of In-house Production vs Outsourcing

Managerial Finance
Introduction
ETT is a company engaged in the business if telecommunications. The company provides the
following services like call, internet, mobile and other ancillaries. The company has its footprint for
25 years and is a profitable entity. Recently, company in order to further mark its presence in the
industry has explored two means of business i.e. purchasing machinery itself and bearing all the
incidental cost and secondly outsourcing the activities to any third party. The proposed analysis
deals with the cost incurred under each model and choosing the best model post conducting a
sensitivity analysis of the two opportunities.
Analysis
Computation of Weighted Average Cost of Capital
The company has four sources of finance for its present business encompassing:
(a) Common Stock i.e common shares with a required rate of return 10.87% before and after tax;
(b) Bonds i.e. debt with a required rate of return 4.66% before and 3.496% after tax;
(c) Preference Shares with a required rate of return of 5.75% before and after tax;
(d) Mortgage i.e. debt with a required rate of return 5.02% before and 3.766% after tax;
Further, the value of instruments have been considered as weight for the purpose of computing
weighted average cost of capital of the company:
(a) Common Stock: $ 10,85,00,000/-
(b) Bonds: 5,23,50,000/-
(c) Shares: 60,60,000/-;
(d) Mortgage: 55,00,00/-
Based on above values, the computation of weighted average cost of capital has been done using
the following formula:
Summation of (Value * Cost after tax)/ (Summation of Value)
The computation has been presented here-in-under:
Item Value
Weig
ht
Cost
Before Tax
Cost
After Tax
Weighted
Cost
Stock
$
10,85,00,000
0.629
3 10.87% 10.87% 0.068406415
bonds
$
5,23,50,000
0.303
6 4.66% 3.496% 0.010615037
shares
$
60,60,000
0.035
1 5.75% 5.75% 0.002021054
mortg
age
$
55,00,000
0.031
9 5.02% 3.766% 0.001201466
Total
$
17,24,10,000 8.224%
NPV Analysis of two Opportunities

Net Present Value analysis is a financial analysis tool to determine the feasibility of project based on
cash flows. The said decision making analysis involves comparing the present value of cash inflows of
an investment opportunity with the present value of proposed outflows from the opportunity. The
higher the positive value, the better the project shall be. In the present case, since details of inflow
are missing the best project shall be which has the lowest cash out flow in terms of present value. In
addition to above, since the project has different life the net present value of outflows for the
project shall be annualised for the purpose of comparison and determining the best alternative.
The two opportunities at the disposal of the company are :
(a) Inhouse production of the hardware components;
(b) Out sourcing option where the required hardware shall be prepared by third entity.
The analysis involves understanding the cost incurred for each options under different dimension.
Further, since the life of both the options are different, they are annualised to reflect the annual cost
to be incurred for the proposed plan.
Alternative -1 Analysis
Under alternative 1, the company is proposing to set up its own hardware plant which will have
following traits:
(a) Cost of the machinery shall be $ 10,00,000;
(b) Life of the plant shall be 4 years;
(c) Since the entity is profit making tax shied shall be provided;
(d) One time training cost of $40,000 shall be incurred;
(e) Rent shall be incurred for warehousing of goods;
(f) Maintenance fee shall be incurred for marinating the warehouse;
(g) Charges for land conversion shall be incurred.
(h) There shall be revenue forgone on account of such expansion.
On the basis of above characteristic of project, the computation of annualised NPV for the project
has been detailed here-in-below:
NPV ANALYSIS OPTION A
Year 0 Year 1 Year 2 Year 3 Year 4
Machinary
$
(10,00,000.00)
$
80,000.00
Net Working Capital
$
(50,000.00)
Depreciation tax shield
$
57,500.00
$
57,500.00
$
57,500.00
$
57,500.00
Training Cost
$
(40,000.00)
Tax on training cost
$
10,000.00
Manufacturing Variable
cost
$
(30,00,000.00
)
$
(31,20,000.00
)
$
(32,44,800.00
)
$
(33,74,592.00
)
Tax on Manufacturing
Variable cost
$
7,50,000.00
$
7,80,000.00
$
8,11,200.00
$
8,43,648.00
Warehouse Rent
$
(1,00,000.00)
$
(1,02,000.00)
$
(1,04,040.00)
$
(1,06,120.80)
Tax on Warehouse Rent
$
25,000.00
$
25,500.00
$
26,010.00
$
26,530.20
Maintainance fee
$
(1,50,000.00)
$
(1,53,000.00)
$
(1,56,060.00)
$
(1,59,181.20)
$
(1,62,364.82)
Tax on Maintainance fee
$
37,500.00
$
38,250.00
$
39,015.00
$
39,795.30
$
40,591.21
Land Conversion $