The purpose of this analysis is to estimate the cost of equity and the weighted average cost of capital for a firm. You will apply some of the methods we will learn in class. In particular, you will be estimating the cost of equity capital using the dividend growth model (described in
Chapter 7 of your text), estimating beta and using the Capital Asset Pricing Model (described in
Chapter 12), and calculating a Weighted Average Cost of Capital (described in Chapter 13).
This will introduce you to some of the sources available for financial data, provide the opportunity for manipulating real data, and allow practice in using Excel or another spreadsheet program. You will be randomly assigned a company for this analysis. Your task is to determine your company’s current Weighted Average Cost of Capital. You will be collecting data related to your company and calculating the cost of equity capital in three different ways and using those values to calculate the WACC. For simplicity, we will assume that it is January 2012.
Please note that this is a term assignment, so you should be working on it throughout the semester. I have included suggested dates to complete each part to help you manage your time.
The analysis is due on Wednesday, November 14, but you can submit parts earlier if you would like to have them checked so that you can fix any problems (but no later than November 7). You will be provided with Excel templates on courselink which you should use for submitting your data and calculations. For those without access to Excel, pdf versions of the templates are also provided on courselink. You do not have to use the exact version of my templates, but you do need to use a spreadsheet program (you should not do the calculations by hand) and present your results in an easily understood format with sources and calculations shown. Hard copies of all three templates should be submitted in class or to the box in MacK 723 by 4:00 pm on November
14. Please make sure that they are formatted and sized appropriately so that they can be easily read and understood. Late submissions will lose 10% per class day.
Data Collection (October 3)
Company Data
• Monthly closing stock prices (in Canadian dollars) for your company for the period
Jan. 1, 2008 - Dec. 31, 2011 (NOTE: These can be adjusted closing prices as they will make your subsequent calculations easier, but you must state whether the prices you provide are adjusted or unadjusted. You will need the actual closing price for Dec. 31,
2011).
• The best source is www.ca.finance.yahoo.com.
• Dividends paid by your company for the years 2007 - 2011. You should also provide information about any stock splits or stock dividends.
•
•
• A good source is www.ca.finance.yahoo.com, but it sometimes misses dividends or records them incorrectly, so it is best to verify by checking the company’s website.
Financial statement information from year end 2011: Long-Term Debt, Book Value of
Equity, number of shares outstanding, Net Income, and Earnings per Share.
• These can be found at www.google.ca/finance, www.tmx.com, or on the company’s website. Your company’s debt rating.
• Sometimes this will be listed on the company’s website. Some sites to check are moodys.com, fitchratings.com or standardandpoors.com. These sites may require registration, but, at least at the moment, they are free. You can also get bond ratings from FP Bonds–Corporate, located in the reference section of the library. A google search may also turn up the debt rating. Some companies do not get their debt rated, so you can assume a BBB rating for those.
Market Data
• Monthly closing prices for the S&P-TSX Composite Index for the period Jan. 1, 2008 Dec. 31, 2011.
• The best source is www.ca.finance.yahoo.com. The company symbol will be
^GSPTSE.
• The 3-month Canada Treasury Bill yield and the yield on a 7-year Government of Canada
bond
Related Documents: Weighted Average Cost Of Capital
Organization Analysis: Just Group Prepared for Barbara Evans Prepared by Rangsikul Likhitthanawong 6189458 Executive Summary This report will examine Just Group Ltd, the number one market leader in fashion and apparel retail store in Australia. The objective of this report is to review current strategies used by Just Group with regarding to seven traits model according to Schumann, P. A. 1994. Besides, future strategies recommendation will be provided as the key for the company to sustain…
The company has realised that its SG&A costs are high and are eating into their revenues to the extent of causing growing losses. During 2012, the company made several changes to improve their balance sheet. This included changes in senior management bringing down people cost by 7%, debtor days were reduced aiming at improvements in working capital management, reducing agency brands so that focus can shift to the core brands and finally, talk about migrating to a new transaction system which will…
Analysis of companies- Part one Keziah Sullivan 13227025 Work count: Introduction to companies: The two companies that I have chosen to analyse are Network Nine Australia and Network Seven. Both companies are centralized around T.V, which suits me, as this is the profession that I aim to gain entry into. Background and history Network Nine Australia: The Nine Network is part of the Nine-entertainment cooperation, which includes Nine Network Australia, NBN Television, Australian…
SUBMISSION: WORD COUNT: 1443 CONTENT PAGE Introduction……………………………………………………………………………….3 Biography of henry ford………………………………………………………………….3 Background of the company……………………………………………………………..4 Products of the company………………………………………………………………...5 Marketing strategies of the company……………………………………………………6 Organizational culture of the company………………………………………………….7 Motivating factors of the employees…………………………………………………….8 Conclusion…………………………………………………………………………………9 INTRODUCTION This report aims…
In the News The Comeback Company; Siemens tries to recover from a bribery scandal by striking integrity pacts with its rivals. IN ATTEMPTING TO REBOUND from the biggest antibribery enforcement action in memory, Siemens AG is trying to write a redemption story on the same scale. And in doing so, it's not only trying to show that it's built a world-class compliance program, it's also testing its competitors' appetite for fighting corruption. Since the bribery scandal erupted in 2006, the giant Munich-based…
3.6 Number of employees working In the company providing good employment opportunity according to their educational background and presently the to the number of employees working in the organization is more than 1000 employees and they are happy telling that good environment provided by the company and happy working under klenepacks ltd 3.7 Department structures Department structures 3.8 The major products manufactures of klene packs…
To Stephen E. Ambrose, the men of the Easy Company were the best men he had ever met. Easy Company is officially known as the 506th Parachute Infantry Regiment in the 101st Airborne Division of the US Army. The men of this infantry served during World War II. They had different jobs and came from different areas, classes, and backgrounds (Ambrose 15). However, these differences did not deter this infantry of men from becoming a family. Through all the battles and causalities, the infantry experienced…
ABSTRACT Ford Motor Company have been around since 1903, and although in the past they lost market shares due to production and marketing scandals, they remain robust in 2005. This paper has been written to thoroughly analysed Ford through PESTEL analysis to comprehend the macro environment in, Porter’s Five Forces analysis to determine the competition and lastly SWOT analysis to depict the micro environmental factors of the company in question. It has been concluded that due to the fierce competition…
Boeing [pic] Presented by: Urvishkumar Patel Amitkumar Patel Bhavikkumar Patel Manojkumar Patel Vishal Patel Jonathan Mayes MG - 640 Management Policy Dr. Santanu Borah July 27, 2008 TABLE OF CONTENTS INTRODUCTION 5 Company Overview 5 Boeing Commercial Airplanes 5 Boeing Integrated Defense Systems 6 Boeing Capital Corporation 6 Background 7 Sales/Operations 9 Constituent Contributions to Corporate Portfolio and Revenue 12 Market Share, Revenues…
Lining Company Ltd Analysis 1.0 Introduction This essay will discuss the history of Lining Company Ltd. In the past 20th century, Lining was a noticeable athlete throughout the world, who was the winner of six gold medals of men’s artistic gymnastics during the 6th World Cup Competition of 1982. In 1984 Olympic Games, as the “Prince of Gymnastics”, Lining was the only athlete who got the most medals by winning one bronze medal, two silvers, and three gold, as all would expect. Then, in the…