FINM4000_T2_2021_Assessment_02_Description
Page 1 XXXXXXXXXXKaplan Business School Assessment Outline
Assessment 2 Information
Subject Code: FINM4000
Subject Name: Finance
Assessment Title: Individual Assignment
Assessment Type: Written Assignment and Excel Spreadsheet
Video Length: 5 Minutes
Word Count: 1000 Words (+/-10%)
Weighting: 30 %
Total Marks: 60
Submission: Online (MyKBS)
Due Date: Friday (19:55pm AEST) Week 11
Assessment Instructions
• Complete this individual assignment (parts 1-3) by the due date above.
• Please submit written answers and final numbers through the Turnitin “Written Report”
link and submit ONE excel spreadsheet you used in calculating answers through “Excel
Submission” link (you can use multiple sheets in your one file). Both of these sections
will be marked. Please submit your video presentation through “Video” link.
• The written part of your assignment will be put through Turnitin and any plagiarism will
e traced and penalised. Please refer to the policy
Assessment Description
Answer the questions below with reference to the following sources:
Complete all three parts of the written assignment below.
1. Company Perspective – Coles Group [25 marks]
XXXXXXXXXXhttps:
www.colesgroup.com.au/Annual_Report
Page 2 XXXXXXXXXXKaplan Business School Assessment Outline
Source 1: Annual Report 2020
https:
www.colesgroup.com.au/FormBuilde
_Resource/_module/ir5sKeTxxEOndzdh00hWJw/file/Annual_Report.pdf
Source 2: Coles Group Ltd. (COL.AX) Yahoo Finance
https:
au.finance.yahoo.com/quote/COL.AX/
a) Consider the 2020 Annual Report of Coles Group Ltd. (COL). Briefly illustrate how COL’
governance (BoD) is organized. Do you notice any strategies in place to align manager and
shareholder interests at COL based on the Annual Report? Provide one example. (3 marks)
) What is the Net Working Capital for COL both in 2019 and 2020. What type of cu
ent asset
management strategy is the company pursuing? Explain why and what are the pros and
cons of this strategy. (3 marks)
c) Consider the COL 2020 Annual Report. Identify two of the major risks discussed. Are these
isks systematic or unsystematic? Why? (2 marks)
d) You are trying to value COL share today (End of XXXXXXXXXXAssume the cu
ent price of the
share in the stock market is $16.54. Assume that the total dividend paid by COL in the 2020
year were paid as a lump sum (at once) today. You also estimate that for the next two years
dividends will grow respectively at 7% and 5% per year. After this (starting in time 3) you
estimate dividends will grow at a constant rate of 1% forever. Assume that today the
Australian 10Y Government bond has a yield of 1.57%, the market risk premium is 4.45%
and the beta of COL is 0.46. Based on this price would you purchase the share? Why or
why not? (7 marks)
e) What was the market capitalization of COL on the 21 June 2021, assuming that the total
number of share outstanding is the same as per the end of the 2020FY? (Use the closing
price on that day). (2 marks)
f) What type of source (non-cu
ent) is COL primarily using to finance its operations? What
are the advantages and disadvantages of this source of financing? (3 marks)
g) Assume that COL would like to replace its non-cu
ent “lease liabilities” XXXXXXXXXXwith a new
issuing of bonds. Assume that the issue will have a coupon rate of 5% with a 10 year
maturity. Assume this are semi-annual coupon bonds and each have a face value of $1,000
and the required rates of return for similar bonds in the market is 3%. What would be the
issuing price of these bonds? How many bonds COL will have to issue in order to replace
its non-cu
ent “lease liabilities”? (5 marks)
Page 3 XXXXXXXXXXKaplan Business School Assessment Outline
2. Capital Budgeting – Coles Group Ltd. [25 marks]
Answer the below questions in your word file and refer to your excel spreadsheet as a supporting
document. Upload your excel spreadsheet under “Excel Submissions”.
All amounts are in $AUD. In order to increase its market penetration and boost profitability,
Coles Group (COL) is evaluating investing in a “Mega Automated Convenience Store” (MACS).
COL has already identified a facility that could be ideal for this new format of convenience store.
In order to mitigate the risk and assess the fit for purpose of the facility COL asked “Stem
Consulting Ltd.” to conduct a technical due diligence. “Stem Consulting Ltd.” is asking $150,000
as a fixed fee for its consulting services.
The MACS will have a size of 5,000 square meters (sqm) and will require an initial investment
of $100 million. As part of the initial investment, COL will also have to invest additional $50
million in state of the art AI Robotics Technologies.
It is believed that the MACS will be able to generate 20% more revenues compared to a
traditional convenience store. The average annual sales per sqm of a traditional convenience
store is $18,000. The MACS will generate revenue starting at the end of year 1 until the end of
year 10. It will also incur additional working capital expenses of $5million immediately, this
working capital will be recovered at the end of the project.
It is believed that the MACS will reduce the revenues of a close grocery store that the company
also own. The total impact on the annual revenues of this store is expected to be a reduction of
$10 million.
The management team is forecasting that operating costs will be only 15% of the incremental
evenues from year 1-10. The initial investment will be depreciated on a straight-line basis over
ten years to 0 book value. COL has estimated that the MACS can be sold at the end of year 10
for $15 million. The tax rate is 30%. All cash flows are annual and are received at the end of
the year. The weighted average cost of capital is 5.5%.
a) Calculate the FCFs for this project. (10 marks)
) What is the NPV for the project? (5 marks)
c) What is the Discounted Payback Period? (2.5 marks)
d) What is the IRR? (2.5 marks)
e) Assume that the risk of investing in the MACS is higher than the overall risk of the company,
what would happen to the discount rate and consequently NPV of the project? Why? (2
marks)
f) Suppose that COL’ management discounted payback rule is 5 years. Based on your
analysis in b), c) and d) should the company undertake this project? Justify your answer
with reference to theory. What other factor might affect the final decision? (3 marks)
3. Video Presentation [10 marks]
Students are required to produce a video presentation regarding “Section 2” of this
assessment. See marking ru
ic below for focus. The goal of the presentation is to explain
the steps taken in order to estimate the FCFs and other capital budgeting measures. Moreover,
students are required to justify their recommendation regarding the feasibility of this
investment. Upload this video under the link in the assessment table.
Page 4 XXXXXXXXXXKaplan Business School Assessment Outline
Video Marking Ru
ic:
Section Criteria Marks Available
Presentation Skills
• The presentation is engaging, creative
and of professional standard.
• The presentation uses a financial
management language.
3
Analytical Skills
• The steps taken for the computation of
FCFs are clearly outlined.
• The computation of FCFs is justified
with reference to theory.
• Clear recommendations, regarding the
feasibility, backed by financial theory.
5
Practical Skills
• Presentation is concise and doesn’t
contain i
elevant information.
• Presentation doesn’t exceed 5 minutes.
2
Total Marks 10
Page 5 XXXXXXXXXXKaplan Business School Assessment Outline
Important Study Information
Academic Integrity Policy
KBS values academic integrity. All students must understand the meaning and consequences
of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct
Policy.
What is academic integrity and misconduct?
What are the penalties for academic misconduct?
What are the late penalties?
How can I appeal my grade?
Click here for answers to these questions:
http:
www.kbs.edu.au/cu
ent-students/student-policies/.
Word Limits for Written Assessments
Submissions that exceed the word limit by more than 10% will cease to be marked from the point
at which that limit is exceeded.
Study Assistance
Students may seek study