numerical ans on excel

Source 1: Coles Limited (COL) Annual Report 2022 https:Hwww.colesgroup.com au/FormBulden__Resourcel_moduleirsskeTxxEOndzdh0ohWUwfil e/Annual Report.paf Source 2: Yahoo Finance https:lau. finance. yahoo, corniquote/COL AXV Docharntclasufication Puble Kaplan Dusess School Assessment Outline 4 1. Company Perspective (25 marks) Consider the 2022 Annual Report for Coles Limited (COL). a) Briefly ilisstrate how COL governance is organized. Do you notice any strategies in place to align manager and shareholder interests at COL based on the Annual Peport? Provide one example. ( 3 marks) b) What is the net working captal for COL in 2021 and 2022 . What type of current asset management strategy is COL probably pursuing? Explain why, and what are the pros and cons of this strategy? (3 marks) c) Identify two of the major risks discussed in the annual report. Are these risks systematic or unsystematic? Why? (2 marks) d) You are trying to value COL shares today (end of 2022). Assume the current price of COL shares is \$16.69. Assume that the sotal dividend paid by COC in 2022 was a lump sum. You alse estimate that for the next two years dividends will grow respectively at 15% and 10% per year. After this (starting in time 3) you estimate dividends will grow at a constant rate of 4% forever. Assume that today the Australian 10 year government bond has a yield of 3.6%, the market risk premium is 6.5% and the beta of COL is 0.6 . (The yahoo finance page says the beta is 0.20 , but let's use 0.6.) Based on this price would you purchase COL shares? Why or why not? (7 marks) e) What was the market capitalization of COL on 31 Deoember 2022, assuming that the total number of shares outstanding on this day is the same as that reported in the annual report? (Use the closing price on that day). (2 marks) 5) What source of funding (non-current) is COL primarily using to finance its operations? What are the advantages and disadvartages of this source of financing? (3 marks) g) Consider the COL bond issue with a coupon rate of 2.65% and a 10 year original maturity. Assume the bonds are semiannual with payment dates of 6 May and 6 November of every year, the bonds have a face value of $10,000 and the required rate of retum for similar bonds in the market is 4.87\%. Calculate the market price of these bonds loday (end of 2022). (You may the to visit: htips-fixtbs com.aulxtbs-proflelytmeol)