Select a company to analyze. The company must be a well-known publicly traded company whose shares...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Select a company to analyze. The company must be a well-known publicly traded company whose shares are listed on a Canadian or American stock exchange. Consider selecting a company whose products or services you use. Now the tricky part, you must select a company whose name begins with the same letter as your last name. So, if your name is James Campbell, you must select a company name that begins with the letter "C". Download and save the company's latest complete annual report. You will review and examine the annual report to complete the case study. All of the analysis provided by you must be your own work and reflect your own original thought. Do not provide any copy/paste material, do not reference or provide citations for other material. I want to receive your opinion, your research and your thoughts. You will submit two documents through Brightspace. Use this document to complete the assignment, complete all worksheets in this Excel Workbook. Include your LAST NAME in the file name when you save the file. You must submit this Excel file through Brightspace (do not email it to the professor). Submit a PDF copy of the company annual report through Brightspace puny PART TWO-25% 1.Ratios WorkSheet - Refer to the company current year financial statements. -Compute the ratios on the Ratios worksheet. - Ensure you use the correct excel formula to calculated the Ratio. Include the page reference from the Company Financials to indicate where you found the financial data. - Briefly in your own words summarize what the results mean in terms of the financial analysis of the company. 2. Stock Tracking - Use the Template included on the "STOCK TRACKING" worksheet. - You will purchase your own stock and at least 2 other stocks. - Over the next 5-6 weeks track your stock on a daily basis (Business days only). - Enter the data on the worksheet. At the end of the tracking period write a brief summary of your stock performance. (250-450 words). - There is a textbox on the Stock Tracking Worksheet for you to write your summary. Ratio Current Ratio Quick ratio Debt-to total-assets ratio Debt-to-equity ratio Times-interest earned ratio Return on Revenue (ROR) Return on Equity Ratio (ROE) Return on total Assets Earnings Per Share Price/Earnings Ratio (P/E) Earnings per share Formula Calculation Annual Report What does this tell me about the Company's Page Reference financial positon DATE STOCK INVESTMENT PERFORMANCE Total cost of accounts Value of accounts Difference $ Difference % $0.00 $0.00 $0.00 #DIV/O! Investment Name Account Name or Number Symbol Quantity Purchase Price Per Share Trade Fees Total Cost (Purchase Price + Fees) Current Quote Market Value Gain/Loss ($) Gain/Loss (%) A Datum Corporation Microsoft Corporation Woodgrove Bank Microsoft ZZZZ MFST $0.00 $0.00 $0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A Stock Summary Select a company to analyze. The company must be a well-known publicly traded company whose shares are listed on a Canadian or American stock exchange. Consider selecting a company whose products or services you use. Now the tricky part, you must select a company whose name begins with the same letter as your last name. So, if your name is James Campbell, you must select a company name that begins with the letter "C". Download and save the company's latest complete annual report. You will review and examine the annual report to complete the case study. All of the analysis provided by you must be your own work and reflect your own original thought. Do not provide any copy/paste material, do not reference or provide citations for other material. I want to receive your opinion, your research and your thoughts. You will submit two documents through Brightspace. Use this document to complete the assignment, complete all worksheets in this Excel Workbook. Include your LAST NAME in the file name when you save the file. You must submit this Excel file through Brightspace (do not email it to the professor). Submit a PDF copy of the company annual report through Brightspace puny PART TWO-25% 1.Ratios WorkSheet - Refer to the company current year financial statements. -Compute the ratios on the Ratios worksheet. - Ensure you use the correct excel formula to calculated the Ratio. Include the page reference from the Company Financials to indicate where you found the financial data. - Briefly in your own words summarize what the results mean in terms of the financial analysis of the company. 2. Stock Tracking - Use the Template included on the "STOCK TRACKING" worksheet. - You will purchase your own stock and at least 2 other stocks. - Over the next 5-6 weeks track your stock on a daily basis (Business days only). - Enter the data on the worksheet. At the end of the tracking period write a brief summary of your stock performance. (250-450 words). - There is a textbox on the Stock Tracking Worksheet for you to write your summary. Ratio Current Ratio Quick ratio Debt-to total-assets ratio Debt-to-equity ratio Times-interest earned ratio Return on Revenue (ROR) Return on Equity Ratio (ROE) Return on total Assets Earnings Per Share Price/Earnings Ratio (P/E) Earnings per share Formula Calculation Annual Report What does this tell me about the Company's Page Reference financial positon DATE STOCK INVESTMENT PERFORMANCE Total cost of accounts Value of accounts Difference $ Difference % $0.00 $0.00 $0.00 #DIV/O! Investment Name Account Name or Number Symbol Quantity Purchase Price Per Share Trade Fees Total Cost (Purchase Price + Fees) Current Quote Market Value Gain/Loss ($) Gain/Loss (%) A Datum Corporation Microsoft Corporation Woodgrove Bank Microsoft ZZZZ MFST $0.00 $0.00 $0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A 0.00 0.00 0.00 N/A Stock Summary
Expert Answer:
Answer rating: 100% (QA)
ANSWER Company Selection Since the last name is Anderson I would look for a wellknown publicly traded company beginning with the letter A Potential ch... View the full answer
Related Book For
Modern Advanced Accounting In Canada
ISBN: 9781259066481
7th Edition
Authors: Hilton Murray, Herauf Darrell
Posted Date:
Students also viewed these finance questions
-
Fall 2022 J. Rico 1. An observer spots a hot air balloon descending vertically to a spot directly on the ground At first sight, the angle of elevation to the balloon from where the observer stands is...
-
Briefly, what changes might result in the need for additional space for a service operation (of your own choice)? Under what circumstances might such changes lead to the need for an entirely new...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Calculate the half life potential for Zn electrode is 0.01M Zn(NO 3 ) 2. Given that Zn 2+ + 2e= Zn E o = 0.763
-
The data set of calls received by a switchboard given in DS 6.1.6. Use a statistical software package to obtain sample statistics and boxplots for the following data sets. What do the sample...
-
What are Delta Airlines distinctive competencies? Distinctive competencies are FIRM SPECIFIC STRENGTHS THAT ALLOW A COMPANY TO DIFFERENTIATE ITS PRODUCTS AND/OR ACHIEVE LOWER COSTS THAN ITS RIVALS....
-
Go to PWC.com, Deloitte.com, EY.com, or KPGM.com and search for "blockchain." Choose a topic and write about how the firm is using blockchain to help its clients.
-
Continental Insurance Co. issued a policy to cover shipments by Oakley Fertilizer, Inc. Oakley agreed to ship three thousand tons of fertilizer by barge to Ameropa North America in Caruthersville,...
-
The production manager of Rordan Corporation has submitted the following quarterly production forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 10,600 Units to be...
-
Biome Startup, Inc. (BS) is dedicated to improving the world's soil health one farm at a time. BS implements AI technology in the science of soil management and crop production to create a virtual...
-
Using the propogation of random error rules, determine the error in the result of the following equation. [2.15(+0.50)-0.98(+0.20)] 1.62 (+0.06) O 0.23 O 0.33 O 0.54 O 0.76 = = 0.72 (+?)
-
Think about the following relation: {(0,2), (-2,0), (0,7), (-1,0)} What is the domain of the relation? { What is the range of the relation? { }
-
Find the cost of buying 400 shares of Idno Tech (ITX) at the closing price, and the annual dividend that would have been paid for the year on 400 shares of ITX stock. Ignore any broker\'s fees. VOL...
-
The Simple Circular Flow Model: A. Draw Graph (p. 40 in McConnell and Brue Text) . . . B. Describe... Sectors: 1. Businesses: 2. Households: 3. Government: 4. Foreign: Markets: 1. Product: 2....
-
Recall a moment or experience where your life couldn't get any better and you felt aligned. If you cannot recall a moment, imagine what this could look like (in other words, visualize a perfect...
-
Ayden's Toys, Incorporated, just purchased a $500,000 machine to produce toy cars. The machine will be fully depreciated by the straight-line method over its 7-year economic life. Each toy sells for...
-
15. Use the below information to answer the following question. Income Statement For the Year Sales $42,700 Cost of goods sold 29,250 Depreciation 3,750 Earnings before interest and taxes $ 9,700...
-
Graph one period of each function. y = 4 cos x
-
Access the 2011consolidated financial statements for Barrick Gold Corporation by going to investor relations section of the company's website. Answer the questions below. For each question, indicate...
-
Explain how the use of the information provided in segment disclosures can aid in the assessment of the overall profitability of a company.
-
How does the presentation of non-controlling interest on the consolidated balance sheet differ under the four theories of consolidating a non-wholly owned subsidiary?
-
Write a computing procedure to make draws from a univariate truncated normal density T N [ a , b ] [ , 2 ] using the inverse transform method given in Section 12.8.2. Here [ a , b ] are lower and...
-
Consider the standard binary logit regression model (see Section 14.3). (a) Write down the log-likelihood function. (b) Introduce a random intercept assumption in which the intercept is drawn from a...
-
Show that if N [ , 1 ] , and Gamma [ / 2 , / 2 ] , then the unconditional distribution of is a multivariate t -distribution with parameters ( , , ) .
Study smarter with the SolutionInn App