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...

1 answer below »
Please check attach


FINM4000_T2_2021_Assessment_02_Description Page 1 Kaplan 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 be 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] https://www.colesgroup.com.au/Annual_Report Page 2 Kaplan Business School Assessment Outline Source 1: Annual Report 2020 https://www.colesgroup.com.au/FormBuilder/_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) b) What is the Net Working Capital for COL both in 2019 and 2020. What type of current 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 risks systematic or unsystematic? Why? (2 marks) d) You are trying to value COL share today (End of 2020). Assume the current 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-current) 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-current “lease liabilities” (2020) with 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-current “lease liabilities”? (5 marks) Page 3 Kaplan 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 revenues 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) b) 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 rubric 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 Kaplan Business School Assessment Outline Video Marking Rubric: 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 irrelevant information. • Presentation doesn’t exceed 5 minutes. 2 Total Marks 10 Page 5 Kaplan 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/current-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
Answered Same DaySep 29, 2021

Answer To: FINM4000_T2_2021_Assessment_02_Description Page 1 XXXXXXXXXXKaplan Business School Assessment...

Harshit answered on Sep 30 2021
124 Votes
1. Company Perspective – Coles Group
a. James Graham AM is the chairman of the board of directors of Coles group Limited who is also an independent and non-executive director. Steven Cain acts as the Managing Director and the chief executive officer of the company. There are al
so 6 independent and non executive director. The main feature of the the company's board of directors is that along with all the directors the Chairman and the Managing Director of the company are independent directors. When the board of directors are independent majority the interest of the stakeholders are always protected. James Graham holds 500,188 shares and the company making him the highest share holder and the Managing Director Steve Cain holds 50000 shares. The Other directors of the company also hold some part of shares of the company.
b.                                     AUS$’ Million
    Sr No
    Particulars
    2020
    2019
    A
    Total current assets
    3779
    3406
    B
    Total current liabilities
    5681
    4291
    A-B
    Working Capital
    -1902
    -885
    A/B
    Current Ratio
    0.67
    0.79
As per the calculations made above the working capital of the company for both the ears are in negative figures which means that the company's current liabilities are more than the current assets. Therefore, signifying that the liquidity position of the company is very poor. This also reflects a good sign that all the current assets of the company are financed with current liabilities which reduces the requirements of the funds of the company and hence the cost of capital is also reduced. Still strategy is very risky and reflects liquidity issues and company’s inability to meet its short-term liabilities and obligations

c. As per the annual report of Coles group Limited, the two major risk factors which are discussed in the annual report are as follows:
· Pandemic of covid-19: As the the virus covid-19 affected at a global level it is a systematic risk and all the industries were affected.
· Competition: This is an un-systematic risk as the company is facing competition due to change in consumer behaviour and the acceleration of business due to digitisation. The making of the company could not manage with the competitive pressure and the Expectations of the consumers which were volatile.
d. Given:
    Rf
    =
    1.57%
    
    Rm
    =
    4.45%
    
    Beta
    =
    0.46
    
    g1
    =
    7%
    
    g2
    =
    5%
    
    Gt
    =
    1%
    
    Current Dividend (2020)
    =
    0.655
    AUS$
    
    
    
    
    Re
    =
    Rf+ beta (Rm-Rf)
    
    =
    1.57% +0.46(4.45%-1.57%
    
    =
    2.89%
    
    Growth Period
    Year
    Dividend
    Discount Factor
    PV
    1
    0.7009
    0.97191
     0.68
    2
    0.7359
    0.94461
     0.70
    
     1.38
    
    
    
    
    Terminal Period
    
    
    
    
    3rd-year Dividend
    =
    0.7433
    The present value at end of 2nd...
SOLUTION.PDF

Answer To This Question Is Available To Download