Question
I need someone to help me complete the Financial Analysis of the McDonalds Company. I have completed part I, but need help inputting the numbers
I need someone to help me complete the Financial Analysis of the McDonalds Company. I have completed part I, but need help inputting the numbers for part 2, 3 and 4. I have attached all of the sources that are needed to complete the assignment. I have to have the assignment completed within the next two weeks, and its due on October 1st. I am new to this site, but I am willing to pay more for quality work. This is for Webster BUSN 5200. If this is not enough resources please email and let me know so I can find more. Once again, this is not due in 2 days. Please let me know your price for this project.
Financial Analysis of the McDonalds Company NYSE: MCD One McDonald's Plaza Oak Brook, IL 60523 630-623-3000 Raquel Page PART 1, COMPANY OVERVIEW: a. Brief description of the company McDonald's is a well- known fast food company. They are recognized worldwide by the look of their golden arches. This case study will examine the McDonald's corporation's financial information. Each McDonald's restaurant is operated by a franchise or by the main company. b. Company history Two brothers, Dick and Mac McDonald, originally founded McDonald's in 1940. This original California restaurant was designed to be a Bar-B-Q, with a diverse menu and car hop service. In 1948 the brothers decided to reinvent their restaurant so they closed it for a few months. When the restaurant reopened, it now offered only nine items with the most desired being the 15-cent hamburger. In 1954 the brothers get a visit from a man named Roy Kroc. At the time he was a salesman but upon seeing the brothers operation, he felt he could be the one to take the business to the next level. Kroc opened the first chain of McDonalds in 1955 in Illinois. There were close to 700 restaurants all across the United States by 1965 and the company celebrated with its first public stock offering selling at $22.50 per share. McDonald's went global in 1967, opening stores in Canada and Puerto Rico, while today the company operates in 117 countries around the world. c. Organization McDonald's business model is based on the belief that \"the power of their franchisees, suppliers and employees working together toward a common goal is what makes the company the world's leading quick-service restaurant brand\" (www.aboutmcdonalds.com). Although McDonald's is a global brand the majority of its restaurants are \"owned and operated by approximately 5,000 independent, small- and mid-sized businessmen and women\" (www.aboutmcdonalds.com). The company's strategy is built on the collective \"system\" of its franchisees and suppliers - \"by leveraging our System, we have been able to identify, implement and scale ideas that meet customers' changing needs and preferences, allowing our business model to consistently deliver locally-relevant restaurant experiences to customers and be an integral part of the communities we serve\" (www.aboutmcdonalds.com). d. Main products and services McDonald's is best known for their burgers but they offer an array of different products, such as chicken nuggets, fish sandwiches, and the McRib. For those looking to a healthier option, they also offer salads, wraps, smoothies, and fruit. Breakfast is also served and the menu offers everything from eggs and sausage, to pancakes and oatmeal. Depending on the location of the restaurant, the menu can sometimes vary. International restaurants often have menu items that are exclusive to that country, such as India where the cow is considered sacred and is not consumed in the locals diet. e. Geographic area of operations The business was managed as distinct geographic segments through June 30, 2015, that included the U.S., Europe, Asia/Pacific, Middle East and Africa (APMEA) and Other Countries & Corporate (OCC) including Canada, Latin America and Corporate. Beginning July 1, 2015, McDonald's started operating under a new organizational structure with the following four segments that combine markets with similar characteristics, challenges, and opportunities for growth: U.S. - the Company's largest segment, accounting for more than 40% of the Company's 2014 operating income; International Lead Markets - established markets including Australia, Canada, France, Germany, and the UK, which operate within similar economic and competitive dynamics, offer similar growth opportunities and collectively represented about 40% of the Company's 2014 operating income; High Growth Markets - markets with relatively higher restaurant expansion and franchising potential including China, Italy, Poland, Russia, Korea, Spain, Switzerland and the Netherlands. Together these markets accounted for about 10% of the Company's 2014 operating income; and Foundational Markets & Corporate - the remaining markets in the McDonald's system, each of which has the potential to operate under a largely franchised model. Corporate activities will also be reported within this segment (www.aboutmcdonals.com). f. Recent developments Fast food chain McDonald's said on Monday it planned to shut all 169 of its restaurants in India's northern and eastern regions, escalating a dispute with its local partner and potentially putting thousands of workers out of jobs. The decision will likely lead to thousands of job losses and further dent McDonald's share of India's booming quick service restaurants market, where it has already been losing ground to rivals like Domino's Pizza. (http://www.firstpost.com) PART 2, FINANCIAL OVERVIEW: a. Sales and Income Record: ------------- Fiscal Years ------------2012 2013 2014 2015 2016 -- Sales -- Percent change in sales each year ____ ____ ____ ____ ____ ____ ____ ____ ____ -- Net Income ____ -- Percent change in net income each year ____ ____ ____ ____ ____ ____ ____ ____ GRAPH OF SALES & NET INCOME, FY 2012 - 2016 -| -| -| (Plot Sales and Net Income for the -| last five fiscal years on the graph) -| -| (Recommend you prepare the graph in Excel, -| then copy and paste it into the report) -| -| -| -|--------|---------|---------|---------| 2012 2013 2014 2015 2016 COMMENTS: Comment on the trends you see in your numbers and on the graph. Be sure to include comments! The numbers and the chart are meaningless by themselves. Comment on what you see. b. Expense Distribution: FY 2016 Major Expenses: ________ (list the major expense categories ________ from the latest income statement) ________ PIE CHART OF EXPENSES, FY 2016 Note - Do not \"explode\" the pie slices COMMENTS: Comment on the company's expense distribution. c. Assets Distribution: Year-end FY 2016 Assets: Cash Accounts receivable Inventory Fixed Assets Other Assets ________ ________ ________ ________ ________ PIE CHART OF ASSETS, Year-end FY 2016 COMMENTS: Comment on the company's asset distribution. c. Capital Structure: Year-end FY 2016 Capital Structure: Current Liabilities Long-term & Other Liabilities Preferred Stock (if any) Common Equity ________ ________ ________ ________ CAPITAL STRUCTURE PIE CHART, Year-end FY 2016 COMMENTS: Comment on the company's capital structure. PART 3, RATIO ANALYSIS: (1) LIQUIDITY: FY 2016 FY 2015 ____ ____ ____ ____ ____ ____ ____ ____ Current Ratio: McDonalds Wendy's Quick Ratio: McDonalds Wendy's Comments On McDonalds Liquidity: Be sure to include comments! The numbers are meaningless by themselves. Comment on what you see. What story do the numbers tell? (2) ASSET MANAGEMENT FY 2016 FY 2015 ____ ____ ____ ____ ____ ____ ____ ____ Total Asset Turnover: McDonalds Wendy's Average Collection Period: McDonalds Wendy's Comments On McDonalds Asset Management: (3) DEBT MANAGEMENT: FY 2016 FY 2015 ____ ____ ____ ____ ____ ____ Total Debt to Total Assets: McDonalds Wendy's Times Interest Earned: McDonalds Wendy's ____ ____ Comments On McDonalds Debt Management: (4) PROFITABILITY: FY 2016 FY 2015 ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ Net profit Margin: McDonalds Wendy's Return on Assets: McDonalds Wendy's Return on Equity: McDonalds Wendy's Modified Du Pont Equation, FY 2016: Net Profit Margin Total Asset Turnover Equity Multiplier McDonalds ____ ____ ____ Wendy's ____ ____ ____ Comments On McDonalds Profitability: (5) MARKET VALUE RATIOS: FY 2016 FY 2015 ____ ____ ____ ____ ____ ____ ____ ____ PE Ratio: McDonalds Wendy's Market to Book Ratio: McDonalds Wendy's Comments On McDonalds Market Value Ratios: PART 4, CONCLUSIONS AND RECOMMENDATIONS - Summarize your analysis. Review your comments in the financial analysis section and provide your assessment of the overall status of the firm. Include any recommendations you think are appropriate. - List any other recommendations you have for the firm in view of your analysis. * End of report Outline * As you can see, the general approach is to apply what you learn each week to your analysis, thereby building the report as you go through the course. Two weeks are allowed for each major phase of the report, which is enough time to conduct the analysis, record your findings, submit them for review, and receive feedback from your instructor. In weeks 7 and 8 you will finalize the document and prepare the formal version for submission and grading. In the final week of the course you will discuss your findings with the instructor and your classmates. Information Sources Use this web page, the company's latest annual and quarterly reports, and business publications on the Internet as the basis for your analysis. Good information sources on the Internet include: The company' own website (good for overview information, annual and quarterly reports). The U.S. Securities and Exchange Commission (Links to an external site.)Links to an external site. Search EDGAR for 10K and 10Q reports. See SEC Website Instructions below. Yahoo Finance (Links to an external site.)Links to an external site. Yahoo Financial Research Annual Reports (Links to an external site.)Links to an external site. This free service allows users to review an annual report in an easy and convenient manner. Boasting the most complete and uptodate listings of annual reports on the Internet, AnnualReports.com provides instant access to annual reports in their actual format in one single location. For educated investors, corporate annual reports are the most important research tool available. Annual Reports enable investors to stay up to date on a company's yearly outlook. Hoover's (Links to an external site.)Links to an external site. This site delivers comprehensive insight and analysis about the companies, industries and people that drive the economy, along with the powerful tools to find and connect to the right people to get business done. Reuters (Links to an external site.)Links to an external site. This site combines industry expertise with innovative technology to deliver critical information to leading decision makers in the financial, legal, tax and accounting, healthcare, science and media markets, powered by the world's most trusted news organization. MSN > Money > Investing (Links to an external site.)Links to an external site. Great resource for stock research. Many others (Google search for your company's name, for example) Important Note: Wikipedia.com is not an acceptable information source for your report. Since anybody can edit its information and the owners of the site do not attempt to verify the accuracy of what is posted, it does not meet minimum academic standards. Format Use the busn5200_casestudy_complete_outline_McDonalds 2016.doc for your report. Using Information Obtained from the Internet Most of the words in your report should be your own. You should only quote when what has been stated is so unique that it would lose its impact or value if it were not kept together as a quote (this is rarely the case). You may paraphrase and use quotes for emphasis when you need to, but when you do you must use quotes and identify the source of the information. Remember that you MUST provide a source for anything that is not your original words or thoughts. Failure to do so is a breach of the Webster University honor policy and will negatively impact your grade. Simply stated, it is plagiarism. To summarize: When you extract information from sources on the Internet for use in reports, there will be a strong temptation to copy and paste the information into your financial statement analysis. You should not routinely do this. Citing sources on a reference page is not enough. Remember that words shown in your paper are presented as if they are your own unless you enclose them in quotes and provide a citation so your readers know where the information came from. The identification of a source must be sufficient to allow the reader to go directly to the source...including the page! There are multiple style sheets available to show you how to cite outside work in your document. Remember, the requirement is to enable the reader to go directly to the source to confirm its veracity. Be sure to ask your instructor if you have any questions about the report in general or using quoted information in particular. Instructions for Obtaining Company Information from the Securities and Exchange Commission's Website 1. With your computer online, go to www.sec.gov (Links to an external site.)Links to an external site.. This is the U.S. Securities and Exchange Commission's website. 2. At the website, click on Search for Company Filings (its in the Filings and Forms section). That will take you to the Search the NextGeneration EDGAR System page. 3. At the Search the EDGAR System page, click on Company or fund name, ticker symbol, CIK (Central Index Key), file number, state, country, or SIC (Standard Industrial Classification). This will take you to the Company Search page. 4. At the Company Search page, enter the name of your company in the box. Select Starts with or Contains as needed. Leave the other boxes blank. When you are done, click the Find Companies button at the bottom. 5. A list of companies matching the name you typed in will appear. The list may be short or long, depending on how many companies share the same words in their company names. Scroll down the list and locate the specific company you are interested in (you may have to go through several pages if the list is really long.) When you find your company, click the long red number in the left hand column next to the company name. This will bring up a Search Results page with a list of forms on it. Important Note: if there is only one company matching the name you typed in, the system will take you directly to the forms page. See the next paragraph. 6. On the forms page, scroll down the left hand column until you find an entry marked 10K. These forms are the company's annual report. o Note: you will normally find more than one 10K Form listed, because the companies file one for each year. The one you want is the one with the latest date. Check the date of the form in the Filing Date column on the right. o Note: you can shorten the forms search process by entering 10K in the Filing Type: window. Then scroll over to the right and click the Search button. The list of forms at the bottom of the page will then adjust to contain only 10K forms. 7. When you have located the 10K form that you want, click the Documents button for that form. This will take you to a Filing Detail page that contains a list of things that are in the 10K report. You will normally want the first entry, which, in the Document column, will be identified with something like form10k.htm. Click the red entry in the Document column to take you to the form. 8. At this point you can print the entire report (100+ pages!) or you can scroll down through the document to locate the part you are interested in. When you find it, simply highlight it with your mouse, and copy and paste it into a Word document for your review later on. Be careful here! Do not just paste information from the form into your report unless you enclose the text in quotes and insert a footnote saying where you obtained itStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started