Select a company to analyze. The company must be a well-known publicly traded company whose shares...

 

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

Answer rating: 100% (QA)

Answer 1 Fill in some basic information about your company Name of company KOHLS CORPORATION Princip... View the full answer