700 likes | 716 Views
For more course tutorials visit<br>www.tutorialrank.com<br><br>FIN 571 Week 1 Financial Ratio Analysis (Walmart)<br> <br>FIN 571 Week 1 Financial Ratio Analysis (General Motors)<br>
E N D
FIN 571 Entire Course+ Final Guide For more course tutorials visit www.tutorialrank.com FIN 571 Week 1 Financial Ratio Analysis (Walmart) FIN 571 Week 1 Financial Ratio Analysis (General Motors) FIN 571 Week 2 Stock Valuation and Analysis (Apple) FIN 571 Week 2 Stock Valuation and Analysis (Amazon) FIN 571 Week 2 Stock Valuation and Analysis (Target) FIN 571 Week 2 Stock Valuation and Analysis (Walmart) FIN 571 Week 2 Stock Valuation and Analysis (Ford) FIN 571 Week 3 Using the Payback Method, IRR, and NPV
FIN 571 Week 4 Assignment Rate of Return for Stocks and Bonds (2 Papers) FIN 571 Week 3 Researching Industry Financial Statistics FIN 571 Week 6 Signature Assignment Short Term Funding (2 PPT) FIN 571 Week 5 Assignment Capital Market Efficiency Paper (2 Papers) FIN 571 Week 5 Assignment Effect of Debt Issuance on Stock Valuation FIN 571 Final Exam Guide (New, 2017) ============================================== FIN 571 Week 1 DQ 1 (UOP Course) For more course tutorials visit
www.tutorialrank.com What is ethics? If you follow all applicable rules and regulations, are you an ethical person? ============================================== FIN 571 Week 1 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com Assume that interest rates have increased substantially. Would this tend to increase or decrease the market value (meaning the price an investor in the firm's paper is willing to pay) of a firm’s liabilities (relative to the book value of liabilities)? This question is referring to a firm's liability such as a bond or debenture that has been issued in the markets. What happens to the price an investor who is looking to purchase that bond or debenture is willing to pay if the market interest rate increases above the rate that the bond or debenture pays. ============================================== FIN 571 Week 1 Financial Ratio Analysis (Apple)
For more course tutorials visit www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions. Assignment Steps Select a Fortune 500 Company from one of the following industries: Pharmaceutical Energy Retail Automotive Computer Hardware Review the balance sheet and income statement in the company's 2015 Annual Report. Calculate the following ratios using Microsoft® Excel®: Current Ratio Quick Ratio Debt Equity Ratio Inventory Turnover Ratio Receivables Turnover Ratio Total Assets Turnover Ratio Profit Margin (Net Margin) Ratio
Return on Assets Ratio Analyze in 1,050 words why each ratio is important for financial decision making. Submit your analysis as well as your calculations. Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 1 Financial Ratio Analysis (General Motors) For more course tutorials visit www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions. Assignment Steps Select a Fortune 500 Company from one of the following industries:
Pharmaceutical Energy Retail Automotive Computer Hardware Review the balance sheet and income statement in the company's 2015 Annual Report. Calculate the following ratios using Microsoft® Excel®: Current Ratio Quick Ratio Debt Equity Ratio Inventory Turnover Ratio Receivables Turnover Ratio Total Assets Turnover Ratio Profit Margin (Net Margin) Ratio Return on Assets Ratio Analyze in 1,050 words why each ratio is important for financial decision making. Submit your analysis as well as your calculations. Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 1 Financial Ratio Analysis (Pfizer)
For more course tutorials visit www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions. Assignment Steps Select a Fortune 500 Company from one of the following industries: Pharmaceutical Energy Retail Automotive Computer Hardware Review the balance sheet and income statement in the company's 2015 Annual Report. Calculate the following ratios using Microsoft® Excel®: Current Ratio Quick Ratio Debt Equity Ratio Inventory Turnover Ratio Receivables Turnover Ratio Total Assets Turnover Ratio Profit Margin (Net Margin) Ratio Return on Assets Ratio
Analyze in 1,050 words why each ratio is important for financial decision making. Submit your analysis as well as your calculations. Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 1 Financial Ratio Analysis (Walmart) For more course tutorials visit www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to help students gain a better understanding of the financial statements used for corporate financial reporting and the key ratios used to make business decisions. Assignment Steps Select a Fortune 500 Company from one of the following industries: • Pharmaceutical • Energy
• Retail • Automotive • Computer Hardware Review the balance sheet and income statement in the company's 2015 Annual Report. Calculate the following ratios using Microsoft® Excel®: • Current Ratio • Quick Ratio • Debt Equity Ratio • Inventory Turnover Ratio • Receivables Turnover Ratio • Total Assets Turnover Ratio • Profit Margin (Net Margin) Ratio • Return on Assets Ratio Analyze in 1,050 words why each ratio is important for financial decision making. Submit your analysis as well as your calculations. Click the Assignment Files tab to submit your assignment. ==============================================
FIN 571 Week 1 Individual Assignment Business Structures For more course tutorials visit www.tutorialrank.com Watch the "Your Business Structure" and "Corporate Business Structures" videos on the Electronics Reserve Readings page. Identify the different business structures. Write a 350 to 700 word explanation of how each business structure might and might not be advantageous. Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 2 DQ 1 (UOP Course) For more course tutorials visit www.tutorialrank.com Assume that interest rates have increased substantially. Would this tend to increase or decrease
the market value (meaning the price an investor in the firm's paper is willing to pay) of a firm’s liabilities (relative to the book value of liabilities)? This question is referring to a firm's liability such as a bond or debenture that has been issued in the markets. What happens to the price an investor who is looking to purchase that bond or debenture is willing to pay if the market interest rate increases above the rate that the bond or debenture pays. What is the value of the shareholders' equity account for this firm? How much is net working capital? 2. Which one of the following assets is generally the most liquid? 3. Which one of the following accounts is included in stockholders' equity? Operating cash flow is defined as:
4. It is easier to evaluate a firm using its financial statements when the firm: If a firm is currently profitable, then: 5. Which one of these accounts is classified as a current asset on the balance sheet? During 2015, Rainbow Umbrella Corp. had sales of $720,000. Cost of goods sold, administrative and selling expenses, and depreciation expenses were $500,000, $90,000, and $85,000, respectively. In addition, the company had an interest expense of $90,000 and a tax rate of 35 percent. (Ignore any tax loss carryback or carryforward provisions.)
a. What is the company's net income for 2015? (Do not round intermediate calculations. A negative answer should be indicated by a minus sign.) Net income $ b. What is its operating cash flow? (Do not round intermediate calculations.) Operating cash flow $
6. Please use excel sheet in case the values changes Sankey, Inc., has current assets of $4,500, net fixed assets of $23,500, current liabilities of $2,750, and long-term debt of $12,900. (Do not round intermediate calculations.) What is the value of the shareholders' equity account for this firm? Shareholders' equity $
How much is net working capital? Net working capital $ 7. Please use excel sheet in case the values changes Shelton, Inc., has sales of $396,000, costs of $184,000, depreciation expense of $49,000, interest expense of $30,000, and a tax rate of 35 percent. (Do not round intermediate calculations.) What is the net income for the firm?
Suppose the company paid out $39,000 in cash dividends. What is the addition to retained earnings? 8. Please use excel sheet in case the values changes During the year, the Senbet Discount Tire Company had gross sales of $1.12 million. The firm’s cost of goods sold and selling expenses were $531,000 and $221,000, respectively. The firm also had notes payable of $860,000. These notes carried an interest rate of 6 percent. Depreciation was $136,000. The firm’s tax rate was 40 percent.
a. What was the firm’s net income? (Do not round intermediate calculations. Enter your answer in dollars, not millions of dollars, e.g., 1,234,567. Round your answer to the nearest whole number, e.g., 32.) b. What was the firm’s operating cash flow? (Do not round intermediate calculations. Enter your answer in dollars, not millions of dollars, e.g., 1,234,567. Round your answer to the nearest whole number, e.g., 32.) 9. Please use excel sheet in case the values changes
Use the following information for Ingersoll, Inc., (assume the tax rate is 35 percent): a. Prepare an income statement for this company for 2014 and 2015. b. Prepare the balance sheet for this company for 2014 and 2015. 10. Please use excel sheet in case the values changes
Jessica's Boutique has cash of $54, accounts receivable of $52, accounts payable of $220, and inventory of $160. What is the value of the quick ratio? 11. Please use excel sheet in case the values changes Al's Sport Store has sales of $3,020, costs of goods sold of $2,020, inventory of $523, and accounts receivable of $448. How many days, on average, does it take the firm to sell its inventory assuming that all sales are on credit? 12. Which statement expresses all accounts as a percentage of total assets?
13. The inventory turnover ratio is measured as: The quick ratio is measured as: 14. The total asset turnover ratio measures the amount of: 15. A firm has a debt-equity ratio of .44. What is the total debt ratio? 16. Please use excel sheet in case the values changes
A firm has total debt of $1,340 and a debt-equity ratio of .27. What is the value of the total assets? 17. Please use excel sheet in case the values changes A firm has a total debt ratio of .47. This means the firm has 47 cents in debt for every: 18. Which one of the following sets of ratios would generally be of the most interest to stockholders?
19. Ratios that measure how efficiently a firm's management uses its assets and equity to generate bottom line net income are known as _______ ratios. Ratios that measure a firm's ability to pay its bills over the short run without undue stress are known as: 20. The higher the inventory turnover, the: 21. The debt-equity ratio is measured as:
22. Please use excel sheet in case the values changes The Purple Martin has annual sales of $4,600, total debt of $1,220, total equity of $2,300, and a profit margin of 6 percent. What is the return on assets? 23. Please use excel sheet in case the values changes Galaxy United, Inc. 2009 Income Statement ($ in millions)
Galaxy United, Inc. 2008 and 2009 Balance Sheets ($ in millions) What is the return on equity for 2009? 24. P lease use excel sheet in case the values changes If Wilkinson, Inc., has an equity multiplier of 1.57, total asset turnover of 1.7, and a profit margin of 6.7 percent, what is its ROE? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
25. The financial ratio measured as net income divided by sales is known as the firm's: 26. The financial ratio that measures the accounting profit per dollar of book equity is referred to as the: 27. Puffy's Pastries generates five cents of net income for every $1 in equity. Thus, Puffy's has _______ of 5 percent. 28. If stockholders want to know how much profit the firm is making on their entire investment in that firm, the stockholders should refer to the: .
29. The most effective method of directly evaluating the financial performance of a firm is to compare the financial ratios of the firm to: 30. Which one of these equations is an accurate expression of the balance sheet? 31. The financial statement summarizing a firm's accounting performance over a period of time is the: ============================================== FIN 571 Week 2 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com
Suppose rf is 5% and rM is 10%. According to the SML and the CAPM, an asset with a beta of −2.0 has a required return of negative 5% [= 5 − 2(10 − 5)]. Can this be possible? Does this mean that the asset has negative risk? Why would anyone ever invest in an asset that has an expected and required return that is negative? Explain ============================================== FIN 571 Week 2 Individual Assignment Business Structure Advice For more course tutorials visit www.tutorialrank.com Write a 350 to 700 word response to the following e-mail: Dear Consultant,
I am currently starting a business and developing my business plan. I'm in need of some advice on how to start forming my business. I am not sure exactly how it will be financed and whether or not I want to take on partners. I am interested and willing to learn the intricacies of my options to determine how to best proceed with my plan. Please advise on what my options are, the advantages and disadvantages of each, and possible tax consequences for each scenario? Respectfully, John Owner Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 2 Individual Assignment Ethics and Finance For more course tutorials visit www.tutorialrank.com
The Sarbanes-Oxley Act of 2002 (SOX) was passed as the result of the Enron scandal and other instances of accounting fraud. This act was passed to strengthen the role of the Securities and Exchange Commission (SEC). Research a case of corporate financial abuse related to the Sarbanes- Oxley Act of 2002 and apply this to your current work or desired place of employment. Create a 1,400-word analysis of the application of SOX in which you include the following: Discuss the mistakes made by the company and their leadership. Discuss the steps leadership could have taken to prevent or mitigate the repercussions. Explain the role of market pressures on unethical behavior. Examine the influence of the basics of finance and how the Sarbanes- Oxley Act of 2002 changed things. Evaluate the influence of Sarbanes-Oxley Act on ethical behavior. Are businesses more ethical since the enactment? Explain the changes companies needed to make in how they use and present financial statements. Discuss how SOX has affected your current place of employment if at all, and if not, how it has affected others in the same industry. Cite a minimum of 2 scholarly sources.
Format your paper consistent with APA guidelines. Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 2 Individual Assignment Ratio Analysis Problems For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 2 Times, Rating: A+ Ratio Analysis Problems Ratio Analysis (Individual Assignment) You may use excel or word.doc format for this assignment. Please post your homework as a word.doc or excel file in the class discussion section below by the due date.
1. Analysis of cost of goods sold problem. 1992 1993 1994 Gross Profit Margin 60% 55% 51% What is happening to cost of goods sold? As was done in the week 2 online lecture on ratio analysis, please assume sales of 1 dollar each year as you do your analysis. This problem follows the process shown in the Week 2 Ratio Analysis online lecture section titled: "Another Income Statement Analytical Approach: Percent of Sales" (5 points) 2. Overhead (or Sales, General and Administrative Expense) problem. 1992 1993 1994 Gross Profit Margin 40% 39% 41% Operating Margin (NOI/Sales) 15% 10% 5% What is happening to S,G and A (or overhead expenses)? Please set up an illustration assuming sales of 1.00 dollar each year just as you did in problem number one. (5 points) 3. Balance Sheet Problem 1992 1993 1994
Annual Sales Growth (over prior yr) + 1% 0% +1% Current Ratio 3.5X 2X 1.2X Average Collection Period 25 days 30 days 55 days What is happening to liquidity? Why? What are some follow-up questions your would ask? (5 points) 4. Using the data provided below, which is the better managed company? Why? Please support your answers by calculating appropriate ratios. (5 points) Company A Company B Sales 10 million dollars 20 million dollars Net Income 1 million dollars 2 million dollars Total Assets 10 million dollars 15 million dollars Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 2 Stock Valuation and Analysis (Amazon) For more course tutorials visit
www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest. Assignment Steps Resources: Yahoo Finance Select a Fortune 500 Company from one of the following industries: Pharmaceutical Energy Retail Automotive Computer Hardware Manufacturing Mining Access Yahoo Finance and enter the company name. Review the financial information and statistics provided for the stock you selected and answer the following: What is the ticker symbol of the company you chose? What is the Current Stock Price? What is the Market Cap for the stock you chose? What is the Price to Earnings Ratio? What is the Dividend and Yield?
What is the Enterprise Value? What is the Beta? Was there a Stock Split, and if so, when? What was the closing stock price for the last 5 days? What was the 52 Week High for this stock? What is the Book Value per Share? What type of rating are analysts recommending (i.e. buy, hold, etc.)? What is the target price analysts are predicting for this stock? What is the analyst's average revenue estimate for next year? What are some of the significant news items and press releases made by the company over the last year? Explain in 700 words why you would or would not recommend investing in this stock. Describe the relationship between the value of the stock and the price to earnings ratio. What information does the Market Capitalization (Market Cap) and Beta provide to the investor? Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 2 Stock Valuation and Analysis (Apple) For more course tutorials visit www.tutorialrank.com
Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest. Assignment Steps Resources: Yahoo Finance Select a Fortune 500 Company from one of the following industries: • Pharmaceutical • Energy • Retail • Automotive • Computer Hardware • Manufacturing • Mining Access Yahoo Finance and enter the company name. Review the financial information and statistics provided for the stock you selected and answer the following: • What is the ticker symbol of the company you chose? • What is the Current Stock Price?
• What is the Market Cap for the stock you chose? • What is the Price to Earnings Ratio? • What is the Dividend and Yield? • What is the Enterprise Value? • What is the Beta? • Was there a Stock Split, and if so, when? • What was the closing stock price for the last 5 days? • What was the 52 Week High for this stock? • What is the Book Value per Share? • What type of rating are analysts recommending (i.e. buy, hold, etc.)? • What is the target price analysts are predicting for this stock? • What is the analyst's average revenue estimate for next year? • What are some of the significant news items and press releases made by the company over the last year? Explain in 700 words why you would or would not recommend investing in this stock. • Describe the relationship between the value of the stock and the price to earnings ratio. • What information does the Market Capitalization (Market Cap) and Beta provide to the investor? Click the Assignment Files tab to submit your assignment.
============================================== FIN 571 Week 2 Stock Valuation and Analysis (Ford) For more course tutorials visit www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest. Assignment Steps Resources: Yahoo Finance Select a Fortune 500 Company from one of the following industries: Pharmaceutical Energy Retail Automotive Computer Hardware Manufacturing
Mining Access Yahoo Finance and enter the company name. Review the financial information and statistics provided for the stock you selected and answer the following: What is the ticker symbol of the company you chose? What is the Current Stock Price? What is the Market Cap for the stock you chose? What is the Price to Earnings Ratio? What is the Dividend and Yield? What is the Enterprise Value? What is the Beta? Was there a Stock Split, and if so, when? What was the closing stock price for the last 5 days? What was the 52 Week High for this stock? What is the Book Value per Share? What type of rating are analysts recommending (i.e. buy, hold, etc.)? What is the target price analysts are predicting for this stock? What is the analyst's average revenue estimate for next year? What are some of the significant news items and press releases made by the company over the last year? Explain in 700 words why you would or would not recommend investing in this stock. Describe the relationship between the value of the stock and the price to earnings ratio. What information does the Market Capitalization (Market Cap) and Beta provide to the investor? Click the Assignment Files tab to submit your assignment.
============================================== FIN 571 Week 2 Stock Valuation and Analysis (Target) For more course tutorials visit www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest. Assignment Steps Resources: Yahoo Finance Select a Fortune 500 Company from one of the following industries: Pharmaceutical Energy Retail Automotive Computer Hardware Manufacturing Mining
Access Yahoo Finance and enter the company name. Review the financial information and statistics provided for the stock you selected and answer the following: What is the ticker symbol of the company you chose? What is the Current Stock Price? What is the Market Cap for the stock you chose? What is the Price to Earnings Ratio? What is the Dividend and Yield? What is the Enterprise Value? What is the Beta? Was there a Stock Split, and if so, when? What was the closing stock price for the last 5 days? What was the 52 Week High for this stock? What is the Book Value per Share? What type of rating are analysts recommending (i.e. buy, hold, etc.)? What is the target price analysts are predicting for this stock? What is the analyst's average revenue estimate for next year? What are some of the significant news items and press releases made by the company over the last year? Explain in 700 words why you would or would not recommend investing in this stock. Describe the relationship between the value of the stock and the price to earnings ratio. What information does the Market Capitalization (Market Cap) and Beta provide to the investor? Click the Assignment Files tab to submit your assignment. ==============================================
FIN 571 Week 2 Stock Valuation and Analysis (Tesla) For more course tutorials visit www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest. Assignment Steps Resources: Yahoo Finance Select a Fortune 500 Company from one of the following industries: Pharmaceutical Energy Retail Automotive Computer Hardware
Manufacturing Mining Access Yahoo Finance and enter the company name. Review the financial information and statistics provided for the stock you selected and answer the following: What is the ticker symbol of the company you chose? What is the Current Stock Price? What is the Market Cap for the stock you chose? What is the Price to Earnings Ratio? What is the Dividend and Yield? What is the Enterprise Value? What is the Beta? Was there a Stock Split, and if so, when? What was the closing stock price for the last 5 days? What was the 52 Week High for this stock? What is the Book Value per Share? What type of rating are analysts recommending (i.e. buy, hold, etc.)? What is the target price analysts are predicting for this stock? What is the analyst's average revenue estimate for next year? What are some of the significant news items and press releases made by the company over the last year?
Explain in 700 words why you would or would not recommend investing in this stock. Describe the relationship between the value of the stock and the price to earnings ratio. What information does the Market Capitalization (Market Cap) and Beta provide to the investor? Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 2 Stock Valuation and Analysis (Walmart) For more course tutorials visit www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest. Assignment Steps
Resources: Yahoo Finance Select a Fortune 500 Company from one of the following industries: Pharmaceutical Energy Retail Automotive Computer Hardware Manufacturing Mining Access Yahoo Finance and enter the company name. Review the financial information and statistics provided for the stock you selected and answer the following: What is the ticker symbol of the company you chose? What is the Current Stock Price? What is the Market Cap for the stock you chose? What is the Price to Earnings Ratio? What is the Dividend and Yield? What is the Enterprise Value? What is the Beta? Was there a Stock Split, and if so, when? What was the closing stock price for the last 5 days? What was the 52 Week High for this stock? What is the Book Value per Share? What type of rating are analysts recommending (i.e. buy, hold, etc.)? What is the target price analysts are predicting for this stock? What is the analyst's average revenue estimate for next year? What are some of the significant news items and press releases made by the company over the last year?
Explain in 700 words why you would or would not recommend investing in this stock. Describe the relationship between the value of the stock and the price to earnings ratio. What information does the Market Capitalization (Market Cap) and Beta provide to the investor? Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 3 DQ 1 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 2 Times, Rating: A Why are interest rates on short-term loans not necessarily comparable to each other? Give three possible reasons. ==============================================
FIN 571 Week 3 DQ 2 (UOP Course) For more course tutorials visit www.tutorialrank.com Tutorial Purchased: 0 Times, Rating: No rating Optical Supply Company offers credit terms of 2/10, net 60. If Optical Supply is considering a change in its credit terms to one of those indicated, explain whether the change should increase or decrease sales. (a) 2/10, net 30, (b) net 60, (c) 3/15, net 60, (d) 2/10, net 30, 30 extra ============================================== FIN 571 Week 3 Individual Assignment Interpreting Financial Results For more course tutorials visit www.tutorialrank.com
Tutorial Purchased: 4 Times, Rating: B+ Resource: Financial Statements for the company assigned by your instructor in Week 2. Review the assigned company's financial statements from the past three years. Calculate the financial ratios for the assigned company's financial statements, and then interpret those results against company historical data as well as industry benchmarks: Compare the financial ratios with each of the preceding three (3) years (e.g. 2014 with 2013; 2013 with 2012; and 2012 with 2011). Compare the calculated financial ratios against the industry benchmarks for the industry of your assigned company. Write a 500 to 750 word summary of your analysis. Show financial calculations where appropriate. Click the Assignment Files tab to submit your assignment. ============================================== FIN 571 Week 3 Researching Industry Financial Statistics
For more course tutorials visit www.tutorialrank.com Purpose of Assignment The purpose of this assignment is to allow the students an opportunity to complete their financial evaluation of a company using the financial research database Plunkett Research Online. Plunkett Research Online provides in-depth analysis of a company's financials, comparisons to industry averages, a list of top executives, how the company compares to other competitors in terms of revenue, number of employees, market capitalization and other key financial metrics. Assignment Steps Resources: Plunket Research Online located in the Week 3 Electronic Reserve Readings; Microsoft® Excel® Access the the Plunkett Research database in the University Library by following these steps: 1. Click on the University Library link. 2. Click "Company Directories and Financials" under Library Resources. 3. Click "Plunkett Research Online" under Company Directory and Financials. 4. Review the following "HOW TO USE" videos:
o Plunkett Research Online Overview o How to Export Company and Exec. Lists o How to Build-a-Report o How to Use Industry Analytics o How to Research an Industry o How to Use Company Profiles 5. Click "Research A Company." 6. Select a company (i.e. Walmart) and input into the Search Box. 7. Scroll through the search results to choose the correct company. 8. Click the link to the company profile (in blue). Review the Company Profile and answer the following questions in Microsoft® Word: • What is the Ticker Symbol for the company you have selected? • When was the company established? • How many employees does it have? • What is the NAICS Code? • Who is the CEO? • Where does the company rank in terms of Total Revenue when compared to its competitors? • Where does the company rank in terms of Net Income when compared to its competitors?
• Where does the company rank in terms of Return on Assets when compared to its competitors? • What is the Revenue in 2014 and 2015? • What was the Gross Margin in 2014 and 2015? • What was the Earnings per Share in 2014 and 2015? Save the Company Profile as a PDF document. Compare the 2015 Company Financials to the Industry Averages and export the results into a Microsoft® Excel® document. Add a new column in your Microsoft® Excel® document titled "Change" and calculate the difference between the company's 2015 financial results and the industry averages. Explain in 1,050 words how the company you selected compares to the industry averages in terms of financial profitability, liquidity and solvency, and why the difference is important. Also review the financial statements over the last three years, and discuss any positive and negative trends would you report to the company's management. Submit the calculations as well as the explanation. Click the Assignment Files tab to submit your assignment. Note: Grades are awarded based upon individual contributions to the Learning Team assignment. Each Learning Team member receives a grade based upon his/her contributions to the team assignment. Not all students may receive the same grade for the team assignment. ==============================================