Objectives and the Timeline: The objective of this project is to conduct an in-depth ratio analysis...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Objectives and the Timeline: The objective of this project is to conduct an in-depth ratio analysis of a firm's performance in last five years and forecast its performance of next year using the forecasted financial statement (FFS) method introduced in chapter 9 of our textbook. You also need to give recommendations on whether investors would buy/hold/sell the stock of this firm based on your analysis. The requirements are: 1. Conduct the ratio analysis of the selected company (40% - 80 points) * 2. Conduct the financial planning of next year for the selected company (30% - 60 points) 3. Given recommendations to investors on this selected company (10% - 20 points) *: Students who submit the initial report receive 20% (40 points) of the final grade of the project automatically. The overall score of the project = 200 = 40 (initial report) + 80 (ratio analysis) + 60 (planning) + 20 (recommendation). Each student is to select an individual company and download the firm/industry level data from Mergent Online. Consolidated version of financial statements can be downloaded from SEC.gov for financial forecasting. Here is a schedule to help you finish the project on time: 1. Initial Report due on 09/21. The report should include the following items: a. What is your selected company? (A US public, non-financial company is required). b. What is the industry category of your target company? Identify companies in the same industry and select a group of companies to be used to calculate the industry average, with justifications. c. Collect raw data of the target company and its competitors, including 5-year financial statements of your target company, 5-year ratios of your target company and of its competitors. d. Propose a detailed outline (table of contents) of your final report. 2. The final report is due on 12/07/2022. Industry Classification: To find companies of the same industry, you can use different industry classification codes (SIC, NAICS, etc.). You will find that different code results in different groups of companies. Please do your own research and choose one code to use in the study with explanations/defense on your choice. Please note that Mergent usually includes 10 competitors in the "Competitor" tab of each company. However, the 10 companies selected are not necessarily a complete nor is it an appropriate set of companies to compute the industry average. If you choose to take those companies listed in the "Competitor" tab as your sample, you bear the burden of justifying each company and that the sample is sufficient. You are suggested to do your own research. Mergent Online Data: Mergent Online is an online data source that provides last 15 years of US company data. Data includes company overview, financial statements, stock information, SEC Reports, news headlines, annual reports, tear sheets, and competitor/industry analysis. Mergent Online is accessible through the website of the library on and off campus. You may use the tutorials of "How to Access Mergent Online" (click here) and "Finding Company Financial Data" (click here) to help with your data search. Other Useful Resources: U.S. Industrial Outlook, (Washington, D.C., U.S. Government Printing Office). Quarterly Financial Report for Manufacturing Companies (U.S. Federal Trade Commission). (a) (b) (c) exseeSoe Industry Norms and Key Business Ratios (Dun & Bradstreet Credit Services) (Also see (1) Cost of Doing Business and (2) Dun's Business Month). Annual Statement Studies (Robert Morris Associates, Philadelphia). Expenses In Retail Business (National Cash Register Co., Dayton). Almanac of Business and Industrial Financial Ratios (Prentice-Hall). Analysts Handbook (Standard and Poor's Corp.) Fairchild's Financial Manual of Retail Stores (Fairchild Publications, N.Y.). Barometer of Small Business (Acctg. Corp. of America, San Diego). Value Line Investment Survey, 3 Parts, (Value Line Pub.,N.Y.). Standard & Poor's Industry Surveys (Standard & Poor's Corp.). Moody's Manuals (Moody's Investors Service). Objectives and the Timeline: The objective of this project is to conduct an in-depth ratio analysis of a firm's performance in last five years and forecast its performance of next year using the forecasted financial statement (FFS) method introduced in chapter 9 of our textbook. You also need to give recommendations on whether investors would buy/hold/sell the stock of this firm based on your analysis. The requirements are: 1. Conduct the ratio analysis of the selected company (40% - 80 points) * 2. Conduct the financial planning of next year for the selected company (30% - 60 points) 3. Given recommendations to investors on this selected company (10% - 20 points) *: Students who submit the initial report receive 20% (40 points) of the final grade of the project automatically. The overall score of the project = 200 = 40 (initial report) + 80 (ratio analysis) + 60 (planning) + 20 (recommendation). Each student is to select an individual company and download the firm/industry level data from Mergent Online. Consolidated version of financial statements can be downloaded from SEC.gov for financial forecasting. Here is a schedule to help you finish the project on time: 1. Initial Report due on 09/21. The report should include the following items: a. What is your selected company? (A US public, non-financial company is required). b. What is the industry category of your target company? Identify companies in the same industry and select a group of companies to be used to calculate the industry average, with justifications. c. Collect raw data of the target company and its competitors, including 5-year financial statements of your target company, 5-year ratios of your target company and of its competitors. d. Propose a detailed outline (table of contents) of your final report. 2. The final report is due on 12/07/2022. Industry Classification: To find companies of the same industry, you can use different industry classification codes (SIC, NAICS, etc.). You will find that different code results in different groups of companies. Please do your own research and choose one code to use in the study with explanations/defense on your choice. Please note that Mergent usually includes 10 competitors in the "Competitor" tab of each company. However, the 10 companies selected are not necessarily a complete nor is it an appropriate set of companies to compute the industry average. If you choose to take those companies listed in the "Competitor" tab as your sample, you bear the burden of justifying each company and that the sample is sufficient. You are suggested to do your own research. Mergent Online Data: Mergent Online is an online data source that provides last 15 years of US company data. Data includes company overview, financial statements, stock information, SEC Reports, news headlines, annual reports, tear sheets, and competitor/industry analysis. Mergent Online is accessible through the website of the library on and off campus. You may use the tutorials of "How to Access Mergent Online" (click here) and "Finding Company Financial Data" (click here) to help with your data search. Other Useful Resources: U.S. Industrial Outlook, (Washington, D.C., U.S. Government Printing Office). Quarterly Financial Report for Manufacturing Companies (U.S. Federal Trade Commission). (a) (b) (c) exseeSoe Industry Norms and Key Business Ratios (Dun & Bradstreet Credit Services) (Also see (1) Cost of Doing Business and (2) Dun's Business Month). Annual Statement Studies (Robert Morris Associates, Philadelphia). Expenses In Retail Business (National Cash Register Co., Dayton). Almanac of Business and Industrial Financial Ratios (Prentice-Hall). Analysts Handbook (Standard and Poor's Corp.) Fairchild's Financial Manual of Retail Stores (Fairchild Publications, N.Y.). Barometer of Small Business (Acctg. Corp. of America, San Diego). Value Line Investment Survey, 3 Parts, (Value Line Pub.,N.Y.). Standard & Poor's Industry Surveys (Standard & Poor's Corp.). Moody's Manuals (Moody's Investors Service).
Expert Answer:
Answer rating: 100% (QA)
To conduct a ratio analysis you will need to gather the financial statements of the selected company ... View the full answer
Related Book For
Transportation A Global Supply Chain Perspective
ISBN: 9781337406642
9th Edition
Authors: Robert A. Novack, Brian Gibson, Yoshinori Suzuki, John J. Coyle
Posted Date:
Students also viewed these finance questions
-
This is the introduction of the project followed by four submission drop boxes, each of which has its own instructions. You are expected to complete the whole project and submit all requirements to...
-
1. Contextual Application For a Specific Workplace : If your program is tailored for a specific workplace, clarify how it aligns with the unique culture, goals, and challenges of that organization....
-
Simplify each expression in Problems 722. Classify each answer by number of terms and degree. 3(x5) 2(x + 8)
-
Describe the major components of a business plan.
-
Find the impedance, Z, shown in figure at a frequency of 60Hz. Z- 500 F 10 mH
-
What are the two possible translation processes that may be necessary to translate a foreign operations financial statements?
-
This problem continues the Daniels Consulting situation from Problem P7-33 of Chapter 7 and Problem P6-38 of Chapter 6. Daniels Consulting reviewed the receivables list from the January transactions....
-
Marshall's concept of external economies and diseconomies refers to: a) Changes in output resulting from changes in input levels b) The effects of production on the environment c) The benefits or...
-
Overview The milestone for Project One involves applying accounting principles and methods to long-term liabilities and equity. You will also evaluate these financial statement components for...
-
A sample of field soil is tested in the laboratory. The results of Standard and Modified Proctor tests at optimum moisture content are given in the Table below: Standard Proctor test Modified Proctor...
-
Playing pool, you send the cue ball head-on (that is, along the line joining the centers of the two balls) into the stationary 8 ball, and the cue ball stops as a result of the collision. (a)...
-
In a head-on collision between two cars of different inertias, you might prefer to be the driver of the car that has the greater inertia, at least if you considered momentum only. Why?
-
A golf ball has one-tenth the inertia and five times the speed of a baseball. What is the ratio of the magnitudes of their momenta?
-
A \(1200-\mathrm{kg}\) automobile traveling at \(15 \mathrm{~m} / \mathrm{s}\) collides headon with a \(1600 \mathrm{~kg}\) automobile traveling at \(10 \mathrm{~m} / \mathrm{s}\) in the opposite...
-
A jeweler pounds a small ingot of gold into a thin sheet. What happens to the inertia of the gold?
-
Company XYZ in previous three years (2016,17,18) has lost $1,000,000 in each year. From 2019 and 2020 it is making $ 1,500,000 per year. Please show how this situation can be compensated in these two...
-
Critical reading SAT scores are distributed as N(500, 100). a. Find the SAT score at the 75th percentile. b. Find the SAT score at the 25th percentile. c. Find the interquartile range for SAT scores....
-
What roles do individual states play in transportation regulation?
-
Discuss how companies can use the Internet of Things and other technologies to understand and respond to transportation risk.
-
Hardee is a medium-sized, regional LTL carrier servicing the chemical industry. Because many of the shipments hauled by Hardee are hazardous in nature, its drivers need specialized training and must...
-
Komissarov Company has a debt investment in the bonds issued by Keune Inc. The bonds were purchased at par for 400,000 and, at the end of 2015, have a remaining life of 3 years with annual interest...
-
On January 2, 2015, Jones Company purchases a call option for \($300\) on Merchant ordinary shares. The call option gives Jones the option to buy 1,000 shares of Merchant at a strike price of \($50\)...
-
On January 2, 2015, Parton Company issues a 5-year, $10,000,000 note at LIBOR, with interest paid annually. The variable rate is reset at the end of each year. The LIBOR rate for the first year is...
Study smarter with the SolutionInn App