Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Internet financial statement analysis ratio worksheet. I will attached the file later, just filled out all the blank in the file ACCT 2331 Internet Financial

image text in transcribed

Internet financial statement analysis ratio worksheet. I will attached the file later, just filled out all the blank in the file

image text in transcribed ACCT 2331 Internet Financial Statement Analysis Ratio Project The goal of this assignment is for you to experience finding out relevant accounting and other information about a corporation as if you were an investor. You will find out that it is relatively easy to look up information about any publicly traded company on line. Instructions: Follow the directions for each question below to look up the answers to the questions on the worksheet. Write the appropriate response in the spaces provided on the worksheet. Then STARTING 11/26 use the worksheet to answer the multiple choice questions on BLACKBOARD ON LINE ASSESSMENT. The worksheet is for you to look up your answers and write them down so that you can answer the multiple choice questions without guessing. To receive credit you must complete the BLACKBOARD ON LINE ASSESSMENT on or before 12/4 BY 11 PM. Your score will be based on approximately 1.5 points for each correct answer out of 17 (up to a maximum of 25 points). Please be sure to look up the answers and fill out the worksheet before doing the online assessment. If you just guess you will probably end up with a low score. THE ON LINE ASSESSMENT WILL BE AVAILABLE ONLY BETWEEN 11/26 AND 12/4 . Project Worksheet The following assignment is designed to introduce you to some of the FREE financial information that is available on the web. This can be especially useful for personal investing decisions. We focus on a single site, Yahoo! Finance. There are, however, various other good sites such as Google Finance. We encourage you to explore these web sites on your own. Use the glossary of terms for any items that are new to you. For the purposes of this exercise, we will be examining Walmart and in the second part of the project comparing it to Target. The fiscal year end of Walmart is January 31, and the fiscal year end of Target is January 31. In order to use recent comparable information in the second part of the project you will gather financial statement facts from the 2nd quarterly report (of fiscal year 2015) of Walmart ending July 31, 2015 and compare those with the 2nd quarter (of fiscal year 2015) of Target ending August 1, 2015. FIRST PART OF THE PROJECT First, go to the following web site: http://finance.yahoo.com Type \"Walmart\" in the box next to \"get quotes\" Then click on \"get quotes\" Select the ticker symbol \"WMT\" from the menu of choices This will take you to a page of basic information about Walmart's stock. It will show you the current price and the volume of trading. There are several links to other information about Walmart in the left column of the page you will find the links menu. From this menu, you will click on the following links to obtain the necessary information: (NOTE: The ticker symbol for Walmart is WMT. The ticker symbol is a letter designation that is assigned to stocks and mutual funds traded on U.S. exchanges. You may use it to \"get quotes\" instead of typing in the whole company name) Profile (under company) Historical Prices (under quotes) Income Statement and Balance Sheet (under financials - quarterly data) Competitors (under company) Analyst Estimates (under analyst coverage) Each of the above links will be discussed in the following pages. You will be asked to go to each of the linked pages and record information in the spaces provided. Before clicking on the links answer the following questions from the basic information (summary) page. Internet Financial Statement Analysis and Ratio Project Worksheet Basic Information The earnings per share of a company measures the amount of income earned for each share of stock, which is net income divided by shares of common stock outstanding Earnings per share are abbreviated as \"EPS\" The earnings per share (EPS) for Walmart for the most recent year shown on this page are (Note: ttm = trailing twelve months (the past 12 months) _____________ The current price of Walmart's common stock is? _____________ on Date:____________________(Record the Last Trade price and the date you looked at it) Profile From this page, you can obtain a brief Business Summary and Financial Summary. There is also general contact information as well as links to several other items, such as the company web site. From this page, answer the following questions about Walmart: 1. What Industry is Walmart in? ___________________ 2. How many full time employees work for Walmart? __________________ 3. Who is the Chief Executive Officer? 4. Who is the Chief Financial Officer? ________________________ Internet Financial Statement Analysis and Ratio Project Worksheet _______________________ Historical Prices From this page, you can obtain daily, weekly, and monthly prices for your company for a range of dates. You can also obtain information on dividends. Select July 31, 2015 as the start and end date to capture the historical price at the end of latest quarter. Make sure that the daily price quote is chosen: Daily Weekly Monthly Dividends Look at the column listing the adjusted closing price (this price is adjusted for stock splits and stock dividends). What was the adjusted Closing price of the company for July 31, 2015? Closing Price How much money would you have made or lost from the price change if you had purchased 1 share of Walmart stock on Jan 30, 2015 and sold it on the day you looked up the current price? ___________________ Analyst Estimates From this page, you can see current broker recommendations and estimates of future earnings. (See \"growth estimates\") What is the consensus estimate for the rate of growth of Walmart's earnings over the next five years? _______________________________ What is the consensus estimate for the rate of growth of the Industry's earnings over the next five years? ___________________________________ Competitors This page provides summary ratios for firms that are in the same industry as Walmart. This page can be very useful for identifying close competitors and/or to see how Walmart compares to other firms in the same industry. Internet Financial Statement Analysis and Ratio Project Worksheet Answer the following questions from this page. 1. How does Walmart's gross margin %( gross profit %) compare to the industry average? 2. How does Walmart's revenue growth compare to the industry average? 2nd PART OF THE PROJECT Financials From these pages, you can view the recent quarterly financial statements of the company. In order to compare Walmart to a close competitor we will use data for the quarter ending July 31, 2015. Click on income statement or balance sheet as requested below. Then be sure you are viewing Quarterly Data. If you get \"Annual Data\" then switch to quarterly by clicking on the Quarterly Data link at the top. Notice that all numbers are in thousands of dollars (for example 200,000 is really 200,000 x 1,000 or 200 million), but write them on your worksheet just as they are. If it says 200,000 just write 200,000. 1. From the quarterly Income Statement, what was the total revenue for the quarter ending on July 31, 2015? 2. From the quarterly Income Statement, what was the total revenue for the previous quarter ending on April 30, 2015? 3. Now use your answers to 1 and 2 to calculate the % growth in revenue for the quarter (subtract revenues for the quarter ending April 30, 2015 from revenues for the quarter ending July 31, 2015 and divide the result by the revenues for the quarter ending April 30, 2015. Then express the result as a percentage). 4. % Growth in Revenue = ______________________________ From the quarterly Income Statement, what was Net Income for the quarter ending on July 31, 2015? ____ Internet Financial Statement Analysis and Ratio Project Worksheet 5. From the quarterly Income Statement, what was the Gross Profit for the quarter ending on July 31, 2015? 6. From the quarterly Income Statement, what was the Cost of Revenues (cost of goods sold) for the quarter ending on July 31, 2015? 7. From the quarterly Balance Sheet, what was the value of inventories as of July 31, 2015? 8. From the quarterly Balance Sheet, what was the value of inventories as of April 30, 2015? 9. From the quarterly Balance Sheet, what was the total asset value as of July 31, 2015? 10. From the quarterly Balance Sheet, what were the total liabilities as of July 31, 2015? 11. From the quarterly Balance Sheet, what was the total current assets value as of July 31, 2015? 12. From the quarterly Balance Sheet, what was the total current liabilities value as of July 31, 2015? 13. The largest current asset category is: __________ 14. The largest current liability category is: __________ 15. The largest non-current asset category is: ___________ 16. The largest non-current liability category is: FINANCIAL RATIOS: Internet Financial Statement Analysis and Ratio Project Worksheet ___ Use the information gathered from Walmart's Financials on the previous pages to calculate the following ratios for Walmart. Do not try to look these up on the website. Instead you must make the calculation yourself. Inventory Turnover ___________________ (Use the formula of ratios taught in class: assume \"cost of revenues\" is the same as cost of goods sold) Gross profit % (Use the formula of ratios taught in class) __________________ Debt Ratio ________________________ (Use the formula of ratios taught in class) Current Ratio (Use the formula of ratios taught in class) _______________________ COMPARISON OF WALMART TO A CLOSE COMPETITORTARGET. Now open up the income statement and balance sheet for Target: In \"get quotes\" enter TGT for Target. On the left menu find the income statement and the balance sheet under Financials. Look up the following income statement information: Total Quarter Revenues (August 1, 2015) _______________ Total Quarter Revenues (May 2, 2015) ______________ Quarter Gross Profit (August 1, 2015) ________________ Look up the following balance sheet information for August 1, 2015 Total Assets ____________________ Total Liabilities ___________________ Current Assets ___________________ Current Liabilities ___________________ Internet Financial Statement Analysis and Ratio Project Worksheet Now use these 7 values (above) to calculate the following ratios for Target in order to compare them to Walmart. Use the same calculation methods as for Walmart. Revenue Growth Gross Profit Margin _______________________ (it could be negative) ________________________ Debt (total liabilities) to Total Assets Current Ratio ____________________ _______________________ Based on a comparison of these two ratios between Walmart and Target which company seems to have better liquidity, which has better margin which has better solvency and which has better revenue growth? Revenue Growth? ____________________ Margin? __________________ Solvency? __________________ Liquidity? __________________ Internet Financial Statement Analysis and Ratio Project Worksheet ACCT 2331 Internet Financial Statement Analysis Ratio Project The goal of this assignment is for you to experience finding out relevant accounting and other information about a corporation as if you were an investor. You will find out that it is relatively easy to look up information about any publicly traded company on line. Instructions: Follow the directions for each question below to look up the answers to the questions on the worksheet. Write the appropriate response in the spaces provided on the worksheet. Then STARTING 11/26 use the worksheet to answer the multiple choice questions on BLACKBOARD ON LINE ASSESSMENT. The worksheet is for you to look up your answers and write them down so that you can answer the multiple choice questions without guessing. To receive credit you must complete the BLACKBOARD ON LINE ASSESSMENT on or before 12/4 BY 11 PM. Your score will be based on approximately 1.5 points for each correct answer out of 17 (up to a maximum of 25 points). Please be sure to look up the answers and fill out the worksheet before doing the online assessment. If you just guess you will probably end up with a low score. THE ON LINE ASSESSMENT WILL BE AVAILABLE ONLY BETWEEN 11/26 AND 12/4 . Project Worksheet The following assignment is designed to introduce you to some of the FREE financial information that is available on the web. This can be especially useful for personal investing decisions. We focus on a single site, Yahoo! Finance. There are, however, various other good sites such as Google Finance. We encourage you to explore these web sites on your own. Use the glossary of terms for any items that are new to you. For the purposes of this exercise, we will be examining Walmart and in the second part of the project comparing it to Target. The fiscal year end of Walmart is January 31, and the fiscal year end of Target is January 31. In order to use recent comparable information in the second part of the project you will gather financial statement facts from the 2nd quarterly report (of fiscal year 2015) of Walmart ending July 31, 2015 and compare those with the 2nd quarter (of fiscal year 2015) of Target ending August 1, 2015. FIRST PART OF THE PROJECT First, go to the following web site: http://finance.yahoo.com Type \"Walmart\" in the box next to \"get quotes\" Then click on \"get quotes\" Select the ticker symbol \"WMT\" from the menu of choices This will take you to a page of basic information about Walmart's stock. It will show you the current price and the volume of trading. There are several links to other information about Walmart in the left column of the page you will find the links menu. From this menu, you will click on the following links to obtain the necessary information: (NOTE: The ticker symbol for Walmart is WMT. The ticker symbol is a letter designation that is assigned to stocks and mutual funds traded on U.S. exchanges. You may use it to \"get quotes\" instead of typing in the whole company name) Profile (under company) Historical Prices (under quotes) Income Statement and Balance Sheet (under financials - quarterly data) Competitors (under company) Analyst Estimates (under analyst coverage) Each of the above links will be discussed in the following pages. You will be asked to go to each of the linked pages and record information in the spaces provided. Before clicking on the links answer the following questions from the basic information (summary) page. Internet Financial Statement Analysis and Ratio Project Worksheet Basic Information The earnings per share of a company measures the amount of income earned for each share of stock, which is net income divided by shares of common stock outstanding Earnings per share are abbreviated as \"EPS\" The earnings per share (EPS) for Walmart for the most recent year shown on this page are (Note: ttm = trailing twelve months (the past 12 months) _____________ The current price of Walmart's common stock is? _____________ on Date:____________________(Record the Last Trade price and the date you looked at it) Profile From this page, you can obtain a brief Business Summary and Financial Summary. There is also general contact information as well as links to several other items, such as the company web site. From this page, answer the following questions about Walmart: 1. What Industry is Walmart in? ___________________ 2. How many full time employees work for Walmart? __________________ 3. Who is the Chief Executive Officer? 4. Who is the Chief Financial Officer? ________________________ Internet Financial Statement Analysis and Ratio Project Worksheet _______________________ Historical Prices From this page, you can obtain daily, weekly, and monthly prices for your company for a range of dates. You can also obtain information on dividends. Select July 31, 2015 as the start and end date to capture the historical price at the end of latest quarter. Make sure that the daily price quote is chosen: Daily Weekly Monthly Dividends Look at the column listing the adjusted closing price (this price is adjusted for stock splits and stock dividends). What was the adjusted Closing price of the company for July 31, 2015? Closing Price How much money would you have made or lost from the price change if you had purchased 1 share of Walmart stock on Jan 30, 2015 and sold it on the day you looked up the current price? ___________________ Analyst Estimates From this page, you can see current broker recommendations and estimates of future earnings. (See \"growth estimates\") What is the consensus estimate for the rate of growth of Walmart's earnings over the next five years? _______________________________ What is the consensus estimate for the rate of growth of the Industry's earnings over the next five years? ___________________________________ Competitors This page provides summary ratios for firms that are in the same industry as Walmart. This page can be very useful for identifying close competitors and/or to see how Walmart compares to other firms in the same industry. Internet Financial Statement Analysis and Ratio Project Worksheet Answer the following questions from this page. 1. How does Walmart's gross margin %( gross profit %) compare to the industry average? 2. How does Walmart's revenue growth compare to the industry average? 2nd PART OF THE PROJECT Financials From these pages, you can view the recent quarterly financial statements of the company. In order to compare Walmart to a close competitor we will use data for the quarter ending July 31, 2015. Click on income statement or balance sheet as requested below. Then be sure you are viewing Quarterly Data. If you get \"Annual Data\" then switch to quarterly by clicking on the Quarterly Data link at the top. Notice that all numbers are in thousands of dollars (for example 200,000 is really 200,000 x 1,000 or 200 million), but write them on your worksheet just as they are. If it says 200,000 just write 200,000. 1. From the quarterly Income Statement, what was the total revenue for the quarter ending on July 31, 2015? 2. From the quarterly Income Statement, what was the total revenue for the previous quarter ending on April 30, 2015? 3. Now use your answers to 1 and 2 to calculate the % growth in revenue for the quarter (subtract revenues for the quarter ending April 30, 2015 from revenues for the quarter ending July 31, 2015 and divide the result by the revenues for the quarter ending April 30, 2015. Then express the result as a percentage). 4. % Growth in Revenue = ______________________________ From the quarterly Income Statement, what was Net Income for the quarter ending on July 31, 2015? ____ Internet Financial Statement Analysis and Ratio Project Worksheet 5. From the quarterly Income Statement, what was the Gross Profit for the quarter ending on July 31, 2015? 6. From the quarterly Income Statement, what was the Cost of Revenues (cost of goods sold) for the quarter ending on July 31, 2015? 7. From the quarterly Balance Sheet, what was the value of inventories as of July 31, 2015? 8. From the quarterly Balance Sheet, what was the value of inventories as of April 30, 2015? 9. From the quarterly Balance Sheet, what was the total asset value as of July 31, 2015? 10. From the quarterly Balance Sheet, what were the total liabilities as of July 31, 2015? 11. From the quarterly Balance Sheet, what was the total current assets value as of July 31, 2015? 12. From the quarterly Balance Sheet, what was the total current liabilities value as of July 31, 2015? 13. The largest current asset category is: __________ 14. The largest current liability category is: __________ 15. The largest non-current asset category is: ___________ 16. The largest non-current liability category is: FINANCIAL RATIOS: Internet Financial Statement Analysis and Ratio Project Worksheet ___ Use the information gathered from Walmart's Financials on the previous pages to calculate the following ratios for Walmart. Do not try to look these up on the website. Instead you must make the calculation yourself. Inventory Turnover ___________________ (Use the formula of ratios taught in class: assume \"cost of revenues\" is the same as cost of goods sold) Gross profit % (Use the formula of ratios taught in class) __________________ Debt Ratio ________________________ (Use the formula of ratios taught in class) Current Ratio (Use the formula of ratios taught in class) _______________________ COMPARISON OF WALMART TO A CLOSE COMPETITORTARGET. Now open up the income statement and balance sheet for Target: In \"get quotes\" enter TGT for Target. On the left menu find the income statement and the balance sheet under Financials. Look up the following income statement information: Total Quarter Revenues (August 1, 2015) _______________ Total Quarter Revenues (May 2, 2015) ______________ Quarter Gross Profit (August 1, 2015) ________________ Look up the following balance sheet information for August 1, 2015 Total Assets ____________________ Total Liabilities ___________________ Current Assets ___________________ Current Liabilities ___________________ Internet Financial Statement Analysis and Ratio Project Worksheet Now use these 7 values (above) to calculate the following ratios for Target in order to compare them to Walmart. Use the same calculation methods as for Walmart. Revenue Growth Gross Profit Margin _______________________ (it could be negative) ________________________ Debt (total liabilities) to Total Assets Current Ratio ____________________ _______________________ Based on a comparison of these two ratios between Walmart and Target which company seems to have better liquidity, which has better margin which has better solvency and which has better revenue growth? Revenue Growth? ____________________ Margin? __________________ Solvency? __________________ Liquidity? __________________ Internet Financial Statement Analysis and Ratio Project Worksheet

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting IFRS

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield

3rd edition

1119372933, 978-1119372936

More Books

Students also viewed these Accounting questions

Question

Am I trying to change or control others?

Answered: 1 week ago