I have attached the assignment
FIN80005 Corporate Financial Management - Individual Assignment Prepared by Dr Mardy Chiah Semester 2, 2019 The objective of this assignment is to encourage students to use Excel spread sheets to aid in solving a capital budgeting problem, and to analyse how the market impounds new information into stock prices. Topics 4 - 8 are particularly relevant for this assignment. Weight: 20% of total assessment Due date: 27 October, 2019. You must submit your report, in word or PDF format, electron- ically using the assignment submission link on Canvas. Late submissions: Late assignments cannot be accepted without penalty unless a time extension has been requested from, and approved by, the Unit Convenor. Such requests must be made in writing via email prior to due date. A late penalty of 10% per day will be applied for all late submissions. Format: This assignment is a problem solving exercise, using Excel spreadsheets for analysis, with discussion of findings. It should be written in a report format. The word limit of the report is 1,500 words (approximately 1,000 words for Part 1 and 500 words for Part 2). Report writing resources are provided under unit information on Canvas. A completed coversheet (available from Canvas) must be attached to your submission as a separate file. 1 Hypothetical company background Bestfood Limited is a public listed company that specializes in the production of Asian delicacy. The production relies heavily on the use of machinery. The company has 1,680,000 number of shares outstanding trading on the stock exchange. Part 1 Bestfood is currently in negotiation with a large supermarket chain, 888Groceries Limited, to supply its Asian delicacy in a private label for 888Groceries. Under the terms, Bestfood is expected to supply Asian delicacy to 888Groceries every year for the next ten years. If Bestfood proceeds with the supply of delicacy, the company needs to purchase machinery to cope with the increase in production. New machinery is expected to cost $1,000,000 with an additional $150,000 installation and shipping costs. The machinery is expected to have a working life of 10 years. The company’s accounting policy is to depreciate using the straight line approach. For the new machinery, the company decides to use a depreciation rate of 5% per annum. It is expected that the new machinery can be sold for $200,000 at the end of its useful life. If Bestfood is to proceed with the supply of delicacy to 888Groceries, it is expected that the yearly operating revenues would increase by $650,000 in year one. From year two onwards, it is expected that the increase in yearly operating revenues would grow at a rate of 5% per annum. Fixed operating cost with the increased production is expected to be $200,000 per year. Variable operating costs associated with increased production is 20% of the increase in yearly operating revenues. However, as the private label delicacy’s selling price is cheaper than Bestfood’s brand, it is expected that Bestfood’s existing operating revenues would fall by $200,000 per annum and existing total operating costs would decrease by $80,000 per annum if Bestfood proceeds with the supply of delicacy. Moreover, there would be an initial increase in net working capital of $150,000. From year one to year nine, net working capital is expected to increase by $20,000 per year. All the net working capital can be recovered at the end of the project’s life. The company requires you to calculate an appropriate discount rate using the company’s weighted average cost of capital. The company’s capital structure has remained fairly stable, with a debt-to-equity ratio of 0.8. The company has no plan to adjust its capital structure in 2 FIN80005 19S2 the future. Given that the company is listed on the stock exchange, you are able to obtain the historical returns over the last 20 years for the company, the market portfolio and the risk-free asset as tabulated in Table 1. The company debentures have a face value of $1000 and a coupon rate of 10%. They mature in 5 years time. Similar debentures are currently yielding 11%. The company tax rate is 30%. Table 1 Historical yearly returns for Bestfood, market and risk-free bond Year Bestfood Market Risk-free 1999 13.22% 13.81% 6.01% 2000 30.55% 12.77% 6.31% 2001 -10.05% 7.65% 5.62% 2002 -19.35% -10.64% 5.84% 2003 10.01% 14.61% 5.37% 2004 50.21% 29.48% 5.59% 2005 40.41% 23.83% 5.34% 2006 10.29% 20.93% 5.59% 2007 -7.68% 1.73% 5.99% 2008 -208.09% -33.58% 5.82% 2009 50.21% 33.84% 5.04% 2010 15.39% 8.03% 5.37% 2011 -10.54% -6.43% 4.88% 2012 28.28% 18.56% 3.38% 2013 0.12% 10.38% 3.70% 2014 17.98% 11.67% 3.66% 2015 -25.44% -6.43% 2.71% 2016 36.23% 16.29% 2.34% 2017 0.20% 5.70% 2.72% 2018 10.53% -3.40% 2.54% Furthermore, the CEO suggests conducting sensitivity analysis as follows because of uncer- tainty in relation to some of the expected cash flows: 1. Allow for a 30% probability that incremental revenues associated with the supply of private label delicacy would be 40% lower than expected starting from year six; 2. Allow for a 20% probability that incremental revenues associated with the supply of private label delicacy would be 30% higher than expected starting from year six. 3 FIN80005 19S2 Part 2 Semi-strong form efficiency tests are concerned with whether security prices reflect all publicly available information. The event study methodology can be used to investigate the effects of many events such as a corporate announcement. By studying the stock price reaction before, during and after an announcement, an examination of whether the market is semi-strong form efficient can be conducted. After performing the full analysis in Part 1, assume that Bestfood decides to proceed with the supply of private label delicacy to 888Groceries. As such, the company announces details related to the expected increase in profits and cash flows that it would achieve from the supply of private label delicacy. The table below shows the daily returns of Bestfood (stock), the market and the risk-free asset 5 days before and after the announcement. Day 0 is the day of the announcement and there is no other price-sensitive announcement within the event window. Table 2 Daily returns for Bestfood, market and risk-free asset during the event window Day Stock Return Market Return Risk-free -5 0.40% 0.32% 0.0075% -4 0.50% 0.22% 0.0075% -3 0.20% 0.50% 0.0075% -2 -0.60% -0.42% 0.0075% -1 1.50% 0.25% 0.0075% 0 2.50% 0.38% 0.0075% 1 1.30% -0.21% 0.0075% 2 1.66% -0.10% 0.0075% 3 -1.50% 0.10% 0.0075% 4 -0.80% 0.20% 0.0075% 5 -0.50% 0.35% 0.0075% 4 FIN80005 19S2 Required You are to prepare a report, to present to the CEO, based on the Excel analysis you conduct for Part 1 and Part 2. Show all workings in the appendix of the report Part 1 Show the various cash flows based on the different scenarios; assuming that the Bestfood decides to proceed with the supply of private label delicacy to 888Groceries; taking into consideration of the various scenarios. You should also clearly state any assumptions (if any) made in your analysis. Part 2 Using Capital Asset Pricing Model (CAPM), calculate the daily abnormal return of Bestfood during the event window and plot the daily abnormal returns on a diagram. Daily abnormal return is computed as: Abnormal Return = Actual Return− Expected Return (1) Discuss the abnormal return pattern of Bestfood before, during and after the announcement and justify whether the stock price reaction is consistent with semi-strong form market efficiency. Your response should also include: (1) whether the abnormal return pattern is consistent with the analysis conducted from Part 1; (2) recommendations to exploit mispricing opportunities, if any, from the perspective of the company; and (3) expectations of what would happen to the share price subsequent to the analyzed event window. 5 FIN80005 19S2