diff_months: 18

25300 Fundamentals of Business Finance Assignment

Download Solution Now
Added on: 2023-01-21 09:15:20
Order Code: TV403
Question Task Id: 0
  • Subject Code :


  • Country :


  1. Collins Foods Limited (hereafter known as “Collins”) ordinary shares are listed on the  Australian Securities Exchange (ASX). Collins owns and operates the KFC, Sizzler and Snag  Stand brands. Although there are over 600 KFC stores across Australia, Collins is the largest KFC franchisee in Australia. According to the recent announcement made to the ASX on  28/06/2016 titled Presentation re FY16 Financial Results (hereafter “Presentation”),  Collins is keen to pursue further growth opportunities such as building 7 to 8 new stores. Collins has already performed a substantial amount of data analysis related to one particular  planned new store in the north-western Sydney suburb of Vineyard. The planned new store  satisfies many of the criteria that are likely to ensure its financial success such as the recently  completed nearby North-West rail link, the forecasted large population growth rate, and  access to major arterial roads. However, costs associated with the construction of a new KFC  restaurant and the operating expenses are substantial. Therefore, before Collins commits to  building the new restaurant a financial analysis is needed to determine if it will contribute to  the goal of creating wealth for its shareholders. 
  2. You are employed in Collins’ finance department and have impressed senior  management with your aptitude for financial analysis. This talent was developed through the practice-oriented assignments that you completed at University. You recall how exciting it  was learning about listed companies by searching and reading announcements made to the  ASX. The Chief Financial Officer (CFO) has asked you to perform a financial analysis of the  planned Vineyard store using a purpose-built preformatted EXCEL spreadsheet. The CFO  has suggested you liaise with company employees from a variety of different departments to  collect the information that is necessary to perform the analysis. You will also search through  public documents to identify some of the assumptions that will be required in your financial  analysis, and to locate the data required to analyse Collins’ equity and debt. Your analysis  will be provided to the Board of Directors who must approve substantial capital expenditures. 
  3. The two major cash outflows associated with a new restaurant are the cost of the  building and the equipment such as grills, fryers and refrigeration. The directors are  accountable to the shareholders and so a rigorous financial analysis is necessary to be  confident that the investment in the new Vineyard KFC restaurant is justified. The following  paragraphs contain a substantial amount of information that has been gathered from across  the business and it is your job to determine which information is relevant to the analysis. 
  4. Forecasted sales in 2017 for the new Vineyard store The annual sales for a new store are difficult to predict. However, Collins is confident that the  Vineyard KFC store can achieve sales in the first year of operation that are equal to an  ‘average’ KFC store. You read the Presentation to identify the following two figures

         a) FY16 Statutory Revenue and 

         b) Number of restaurants at Year end 

and then calculate an average sales figure per KFC restaurant in 2016. However, because the  new Vineyard store opens in 2017, the average sales figure needs to be adjusted for one year’s sales growth. Consequently, you assume that sales in 2017 increase at the same rate as  the 2016 KFC Same-Store-Sales (SSS) growth rate (using Collins Foods’ methodology). 

Forecasted sales for 2018 (and beyond) for the new Vineyard store Collins’ assumptions regarding the growth rate in sales for KFC restaurants are contained in  Note F5 of the 2016 annual report that was announced to the ASX on 28/07/2016. For  simplicity you assume that sales for the Vineyard restaurant for 2018 until 2021 increase at  the annual cash flow growth rate stated in the first paragraph. Sales from 2021 then increase  at a marginally slower annual rate, which is specified in the second paragraph of Note F5. 

  1. Collins owns a block of land at Vineyard on which they plan to build the new KFC. In  2013 when Collins constructed the $1.7 million Rouse Hill KFC restaurant they also  purchased salt processing equipment which is situated on the land at Vineyard. This  equipment is outdated and must be sold before the Vineyard store is built. The processing  equipment had a capital cost of $100,000 three years ago. It has a remaining depreciable life  of two years and a buyer has agreed to pay $84,000 cash today for the equipment. It will have  zero value in two years. Because the $100,000 cash outflow relating to the salt processor has  already occurred the accountant suggests it be treated as a sunk cost in the analysis. Collins  will continue to own the land if the Vineyard KFC store does not proceed. 
  2. Collins’ 2011 prospectus reveals that KFC enjoys gross profit margins of  approximately 54%. Therefore, your analysis assumes that costs of goods sold at the  Vineyard store are 46% of sales. Fixed costs at the Vineyard store in 2017 are $240,000.  Management is confident that with rigorous cost control they will be able to contain the  increase in fixed costs to 2% p.a. for each subsequent year. If the Vineyard KFC is built,  Collins’ anticipates that total cash operating expenses in the first year of operation will equal 26% of sales. With the greater economies of scale associated with increasing annual sales and  a “disciplined focus on operational performance” (Source: Presentation, Page 4),  management are confident they can achieve a 0.5% reduction in operating costs to 25.5% in  2018, and then continue to achieve further annual reductions of 0.5% for each following year. 
  3. Starting in 2017, employees at the Vineyard KFC will receive annual training. Collins  performs all training in-house using a dedicated facility that was established in 2011. The  facility has an annual budget of $655,000 and inducts new employees in all aspects of proper  food handling associated with working in KFC, Sizzler and Snag Stand stores. Ordinarily,  Collins would charge an arms-length amount of $75,000 per annum staff training. However,  the training division has sufficient spare capacity to train the Vineyard store’s employees  without the facility incurring any additional costs. The accounts department recommends internally invoicing the $75,000 training expense to the Vineyard store each year. 
  4. The capital cost of the Vineyard KFC building is expected to be $2.3 million today (similar to the estimated cost of an average store according to page 6 of the Presentation).  Collins already has $23,512,333 cash and it plans to use $700,000 cash to pay for the  building to reduce the cash cost to just $1.6 million. Throughout 2015 Collins incurred $260,000 of expenses on external architectural plans relating to the new restaurant. There is  some debate among management about whether the cost of these plans should be classified as  a tax-deductible expense in the analysis. 
  5. For taxation purposes the new building has a twenty-year life. However, Collins will  perform the financial analysis of the Vineyard store over a ten-year time period. The new  store will also require $300,000 worth of deep fryers and refrigeration equipment today. The  Australian Taxation Office (ATO) confirms that fryers and refrigeration equipment have a  five-year tax life. In Collins’ experience, if the fryers and refrigeration equipment are regularly maintained they can actually operate them effectively for a full six years before they  need replacing. The replacement cost in the year 2022 is also assumed to be $300,000.  Collins’ management accountants depreciate all assets over an operational six-year life. 
  6. Collins’ research department has spent $130,000 in recent years studying digital menu boards for its KFC stores. To ensure this expense is not wasted the directors want to include it in the analysis as a cash outflow in 2016. They believe that it will then earn a fair return. 
  7. To maintain a AA+ credit rating, Collins will borrow $1.2 million today to finance the  Vineyard store. The ten-year interest-only loan has annual interest repayments of $48,000  (assuming a 4% p.a. rate). Collins’ accountant confirms that interest is classified as a business  expense and is tax deductible. 
  8. Collins plans a promotional campaign to generate publicity for the Vineyard store’s  grand opening. The marketing department has budgeted $85,000 of advertising for the grand  opening. Because this expense will reduce the new store’s profitability in 2016, Collins’ managers have suggested that the advertising expense be spread out over the new store’s ten year useful life. The ATO states that expenses associated with the Vineyard KFC restaurant’s  grand opening can be claimed as a business expense in the year incurred. Collins’ total KFC  advertising budget for 2017 is $3.4 million and predicted to increase by $200,000 each year. If the Vineyard store opens, the annual advertising budget will remain unchanged. For cost  accounting purposes Collins must allocate overheads across each business unit. Therefore, it  is proposed that the Vineyard store be assigned 1/192 of the total KFC advertising budget. 
  9. Collins assumes that the Vineyard building can be sold for $400,000 in the year 2026.  At any point in time the resale value of the fryers and refrigeration equipment is just $26,000.  In ten years’ time Collins assumes that it will have cash holdings of $12 million. You note the  ATO regulation that all non-current assets be depreciated to zero. 
  10. Collins’ nearby Rouse Hill KFC restaurant has annual sales of $2,500,000. If the  Vineyard store proceeds then management expects that the Rouse Hill store’s sales will  decrease by $150,000 p.a. However, an offsetting effect of opening the Vineyard store is that  customers who currently purchase food at nearby non-Collins’ owned restaurants in the  vicinity will instead purchase their food from the Vineyard KFC. Management expects that  the sales forecasts for the Vineyard store (in paragraph 5) include $340,000 sales per annum  gained from restaurants that are not already owned by Collins. Management is debating if this  $340,000 figure should be included in the analysis because these sales are already occurring. 
  11. If the new Vineyard store goes ahead, then Collins will implement a rights issue to  raise $800,000 from shareholders to partly finance the store. Because the capital is held in the  parent company (Collins) and not at the divisional level it has been recommended that this  $800,000 figure be excluded from the financial analysis. The CEO’s annual salary in 2016 is  $1,511,738 and is not expected to change if the Vineyard KFC opens or not. 
  12. If the directors approve the Vineyard KFC restaurant Collins anticipates that it will  require an additional $400,000 of inventory today on top of the existing level of $1.5 million,  and accounts payable will increase by $270,000. Because all sales are either cash or cash equivalent, Collins does not expect any change to its existing accounts receivable balance of  $750,000 if the Vineyard KFC restaurant is constructed. 
  13. Assume the required return for KFC restaurants is 8% and that the company tax rate  will remain at 30%. Sizzler restaurants and have a higher required return of 13.5% due to the  higher level of risk compared to KFC restaurants.
  • Uploaded By : Katthy Wills
  • Posted on : January 21st, 2023
  • Downloads : 0
  • Views : 263

Download Solution Now

Can't find what you're looking for?

Whatsapp Tap to ChatGet instant assistance

Choose a Plan


80 USD
  • All in Gold, plus:
  • 30-minute live one-to-one session with an expert
    • Understanding Marking Rubric
    • Understanding task requirements
    • Structuring & Formatting
    • Referencing & Citing


30 50 USD
  • Get the Full Used Solution
    (Solution is already submitted and 100% plagiarised.
    Can only be used for reference purposes)
Save 33%


20 USD
  • Journals
  • Peer-Reviewed Articles
  • Books
  • Various other Data Sources – ProQuest, Informit, Scopus, Academic Search Complete, EBSCO, Exerpta Medica Database, and more