Hypothetical company background You are a financial analyst working in the finance department of Healthy Crops Limited. Healthy Crops is a publicly listed company that specializes in the production of organic fertilizers. The mass production of Healthy Crops relies heavily on the use of ingredients and machinery. The company has 4,390,000 shares outstanding trading on the stock exchange, and it is currently trading at $1.28 per share. Part 1 Healthy Crops Limited is an organic fertilizer manufacturer with a large customer base due to its high-quality safe products. Currently, Healthy Crops is in negotiation with a large farm supplies chain, Growmore Limited, to supply its Fast-Grow fertilizer on a private label for Growmore. Under the terms, Healthy Crops is expected to supply multiple grades of Fast-Grow fertilizers to Growmore every year for the next seven years. However, some managers and employees of Healthy Crops are not happy with this negotiation as they are anticipating that the overall production quality of the company will wane by producing fertilizers for Growmore using chemicals with detrimental side effects and it will damage the reputation of Healthy Crops. If Healthy Crops proceeds with the supply of Fast-Grow, the company needs to purchase machinery to cope with the increase in production. New machinery is expected to cost $7,600,000, with an additional $650,000 in transportation and installation costs. The machinery is expected to have a working life of 8 years. The companys accounting policy is to depreciate using the straight-line approach of 11% per year. It is expected that this new machinery can be sold for $1,150,000 at the end of the project life. If Healthy Crops is to proceed with the supply of Fast-Grow chemical fertilizers to Growmore, it is expected that the yearly operating revenues will increase by $9,000,000 in year one. From year two onwards, it is expected that the increase in yearly operating revenues will grow at a rate of 6% per annum. Total variable costs associated with the increased production would be 55% of the increase in yearly operating revenues. The fixed costs associated with the increased production are expected to be $1,350,000 per year. Furthermore, there would be an initial increase in net working capital of $840,000. Individual Assignment- I FIN80005 Corporate Financial Management Prepared by: Dr Miraj Ahmmod From year one to year six, net working capital is expected to increase by $37,500 per year. All the net working capital can be recovered at the end of the projects life. The sales manager predicts that the existing organic fertilizer sales revenue of Healthy Crops will decrease by $950,000 per annum if Healthy Crops proceeds with the supply of chemical fertilizers to Growmore as some marginal or one-off customers will switch from Healthy Crops quality brand to economy brand of Growmore. Consequentially, decreasing sales will decrease production and the existing relevant operating costs would decrease by $312,500 per annum. Given that this projects risk level is not significantly different, you believe that it is appropriate to use the existing WACC of 16.50%. The companys capital structure has remained fairly stable, with a debt-to-equity ratio of 0.65. The company has no plan to adjust its capital structure in the future. The company tax rate is 30%. Furthermore, the CEO is concerned about the uncertainties in relation to some of the cash flows and suggested conducting a sensitivity analysis as follows: 1. Allow for a 30% probability that incremental revenues associated with the supply of private-label fertilizer would be 25% lower than expected starting from year four. 2. Allow for a 20% probability that incremental revenues associated with the supply of private-label fertilizer would be 25% higher than expected starting from year four. 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, Healthy Crops decides to proceed with the supply of private-label chemical fertilizer to Growmore (regardless of the NPV and other investment analyses). As such, the company announces details related to the expected increase in profits and net cash flows that it would achieve from the supply of private- Individual Assignment- I FIN80005 Corporate Financial Management Prepared by: Dr Miraj Ahmmod label chemical fertilizer. The table below shows the daily returns of Healthy Crops (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. The company has an equity beta of 1.45. Table 1 Daily returns for Healthy Crops, market, and risk-free assets during the event window Day Stock Return Market Return Risk-free -5 0.23% 0.13% 0.0063% -4 0.11% -0.09% 0.0063% -3 0.39% 0.28% 0.0063% -2 0.36% 0.53% 0.0063% -1 -0.15% 0.15% 0.0063% 0 -2.93% 0.23% 0.0063% 1 -0.21% 0.66% 0.0063% 2 0.29% 0.82% 0.0062% 3 1.13% 0.20% 0.0062% 4 1.90% 0.41% 0.0062% 5 2.83% 0.35% 0.0062% 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. Part 1 Show the various cash flows based on the different scenarios; assuming that Healthy Crops decides to proceed with the supply of private-label chemical fertilizers to Growmore; taking into consideration of the various scenarios. You should also clearly state any assumptions (if any) made in your analysis. Based on your analysis, is this project a good investment project for Healthy Crops? Individual Assignment- I FIN80005 Corporate Financial Management Prepared by: Dr Miraj Ahmmod Part 2 Using the Capital Asset Pricing Model (CAPM), calculate the daily abnormal return of Healthy Crops during the event window and plot the cumulative 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 Healthy Crops 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 in Part 1; and (2) expectations of what would happen to the share price subsequent to the analyzed event window. i also want help eith excel sheet , it would be great you provide sheets too.