FIN80005 Corporate Financial Management - Individual
Assignment
Prepared by Dr Mardy Chiah
Semester 2, 2018
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: 19 October, 2018. 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 unless a time extension has been re-
quested from, and approved by, the Unit Convenor. Such requests must be made in writing via
email prior to due date.
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
esources are provided under unit information on Canvas. A completed coversheet (downloadable
from Canvas) must be included.
1
Hypothetical company background
Tastegood Limited is a public listed company that specializes in the production of confectionery.
The production relies heavily on the use of machinery. The company has 215,000 number of
shares outstanding trading on the stock exchange.
Part 1
Tastegood is cu
ently in negotiation with a large supermarket chain, Cheap & Good Limited,
to supply its confectionery in a private label for Cheap & Good. Under the terms, Tastegood is
expected to supply confectionery to Cheap & Good every year for the next ten years.
If Tastegood proceeds with the supply of confectionery, the company needs to purchase ma-
chinery to cope with the increase in production. New machinery is expected to cost $2,600,000,
with an additional $200,000 installation and shipping costs. The machinery is expected to have
a working life of 10 years. The companys accounting policy is to depreciate using the reducing
alance approach. For the new machinery, the company decides to use a depreciation rate of
20% per annum. It is expected that the new machinery can be sold for $200,000 at the end of
its useful life.
If Tastegood is to proceed with the supply of confectionery to Cheap & Good, it is expected
that the yearly operating revenues would increase by $800,000 in year one. From year two
onwards, it is expected that the increase in yearly operating revenues would grow at a rate of 10%
per annum. Variable total and fixed operating costs associated with increased production would
e 40% of the increase in yearly operating revenues. However, as the private label confectionerys
selling price is cheaper than Tastegood’s
and, it is expected that Tastegood’s existing operating
evenues would fall by $200,000 per annum and existing operating costs would decrease by
$80,000 per annum if Tastegood proceeds with the supply of confectionery. Moreover, there
would be an initial increase in net working capital of $50,000. From year one to year nine, net
working capital is expected to increase by $10,000 per year. All the net working capital can be
ecovered 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 18S2
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
ate of 12%. They mature in 5 years time. Similar debentures are cu
ently yielding 15%. The
company tax rate is 30%.
Table 1 Historical yearly returns for Branson ltd, market and risk-free bond
Year Tastegood Market Risk-free
XXXXXXXXXX% 10.43% 5.49%
XXXXXXXXXX% 13.81% 6.01%
XXXXXXXXXX% 12.77% 6.31%
XXXXXXXXXX% 7.65% 5.62%
XXXXXXXXXX% -10.64% 5.84%
XXXXXXXXXX% 14.61% 5.37%
XXXXXXXXXX% 29.48% 5.59%
XXXXXXXXXX% 23.83% 5.34%
XXXXXXXXXX% 20.93% 5.59%
XXXXXXXXXX% 1.73% 5.99%
XXXXXXXXXX% -33.58% 5.82%
XXXXXXXXXX% 33.84% 5.04%
XXXXXXXXXX% 8.03% 5.37%
XXXXXXXXXX% -6.43% 4.88%
XXXXXXXXXX% 18.56% 3.38%
XXXXXXXXXX% 10.38% 3.70%
XXXXXXXXXX% 11.67% 3.66%
XXXXXXXXXX% -6.43% 2.71%
XXXXXXXXXX% 16.29% 2.34%
XXXXXXXXXX% 5.70% 2.72%
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 confectionery 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 confectionery would be 20% higher than expected starting from year six.
3 FIN80005 18S2
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 Tastegood decides to proceed with
the supply of private label confectionery to Cheap & Good. 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 confectionery. The table below shows the daily returns of Tastegood
(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 Tastegood, market and risk-free asset during the event window
Day Stock Return Market Return Risk-free
-5 0.30% 0.30% 0.0075%
-4 0.45% 0.20% 0.0075%
XXXXXXXXXX% 0.01% 0.0075%
XXXXXXXXXX% -0.50% 0.0075%
-1 1.20% 0.20% 0.0075%
0 2.50% 0.30% 0.0075%
1 1.30% -0.20% 0.0075%
2 1.66% -0.10% 0.0075%
3 1.50% 0.10% 0.0075%
4 1.40% 0.20% 0.0075%
5 1.26% 0.35% 0.0075%
4 FIN80005 18S2
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 the Tastegood
decides to proceed with the supply of private label confectionery to Cheap & Good; taking
into consideration of the various scenarios. Show all formulae, adjacent to the co
esponding
calculated amounts in the spreadsheet. 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 Tastegood
during the event window and plot it on a diagram. Daily abnormal return is computed as:
Abnormal Return = Actual Return− Expected Return (1)
Discuss the abnormal return pattern of Tastegood 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 18S2