FIN80005 Corporate Financial Management – Individual
Prepared bSemester 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, electronically 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
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.
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.
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
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 uncertainty 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
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
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
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
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
The post FIN80005 Corporate Financial Management – Individual Assignment appeared first on mynursinghomeworks.