Scenarios It is 31th December 2019. Your team of four people form a financial analysis team at Aussie Finance Consulting (AFC), a renowned financial institution. The executive management of AFC has assigned you a task to carry out a special project for its client Yarra Digital Limited (YDL), which requires preparing a business report. This report will be presented to AFC executive management and also to the senior management of YDL. YDL is a Victorian pay television companyoperating in cable television, direct broadcast satellite television, and IPTV streaming services. It was formed in 1999 through a joint venture established between Yarra Broadcasting Corporation and Ultra Digital Network Limited, with Yarra Broadcasting Corporation being the 65% and Ultra Digital Network the 35% shareholders respectively. They provide a full range of television services to corporate and government customers including pay TV, data networks and mobility services through a range of carriers offering choice, control and cost reduction. YDL has been in the business for 20 years now. It is well established and profitably running business thus far. YDL has recently undertaken a market study which costed them $50,000. Findings of the study indicate that it is critical for YDL to upgrade their infrastructure to meet the demand of its customers. They plan to do the upgrade systematically in stages gradually over next few years. They also need to plan their finances to fund the upgrade plan. For the upgrade, they need some critical hardware components. The management has identified two options: (1) In-house production which requires the company to establish their own production facility; and (2) Outsourcing which implies external procurement of the necessary hardware. After a careful analysis, the management has worked out the following details for the two options: Option 1: In-house production The purchase and installation of the machinery shall cost $3,500,000 and has an economic life of twelve years. The machinery is expected to depreciate to zero on a straight-line basis over its economic life. However, the company expects to keep their in-house production for only seven years. At the end of Year 7, the machinery can be sold at an estimated market value of $1,700,000. Currently YDL has a warehouse which generates a rental income of $200,000 each Page 3 of 10 year. To save on investment costs, the management intends to convert this warehouse into a factory for manufacturing various hardware components. The conversion cost is estimated to be $140,000 and treated as a capital expense. YDL also requires training its staff on the new machinery immediately after the installation. Training fees are expected to be $10,000 and fully tax-deductable. Annual maintenance cost of the machinery is $160,000. The collective cost of the hardware components to be manufactured is estimated to be $1,800,000 in Year 1 with an expected increase of 4% per annum in the following years. YDL also needs to invest in necessary development software and maintain the licenses. The negotiated licensing fee for the software is estimated to be $57,000 per year. Finally, the management estimates that they shall need additional net working capital of $30,000 at the beginning of the production with an expected increase of 3% per annum in the following years. Option 2: Outsourcing Alternatively, YDL can contract with a firm named Innovative Equipment Limited (IEL) which is specialised in manufacturing the required hardware. Based on the types and expected number of units YDL would need, IEL management has quoted a total cost of $3,100,000 in Year 1 which will continue to grow at 6% per annum to keep up with the rising cost and forecasted growth in the number of the required units. IEL, however, has offered this rate on a condition of a five-year contract. Also, IEL requires that YDL pays 50% of the expected cost for a year in advance at the beginning of that year. From the accounting perspective, equipment that are procured from IEL may be classified as cost of goods sold in the books of YDL. Hence, they will be treated as operating expense for the business. Furthermore, as in Option 1 YDL still needs the warehouse to store the hardware. You are required to analyse the two given options and make recommendations to YDL about the option they should choose. For the purpose of the analysis, you have already assembled the following information:

, evaluate the two options using NPV analysis and clearly identify which of the two alternatives is better for YDL.