hey whats going on i was wondering if you were down to do this project for me
No answer yet for this question.
Ask a Tutor
Question:
hey whats going on i was wondering if you were down to do this project for me every formula has to be shown in excel i have chosen Sea world everything can be found on http://www.seaworldinvestors.com/financial-reports/default.aspx but i also have listed below financial reports
ACCT 212 INDIVIDUAL LEARNING PROJECT INSTRUCTIONS This project will allow you the opportunity to explore a company's annual report and become familiar with the items it contains. Choose a company from Standard & Poor's Net Advantage whose company's name begins with the same letter as your last name. Locate the most recent annual report, either from the Liberty University library's access to Standard & Poor's website, the EDGAR database (http://www.sec.gov/), or the company's website. Once located, open Individual Learning Project Questions document and add your answers underneath each question. Do not delete the questions. Questions 1-49 must be answered with Microsoft Word. Your answers for these do not need to be in complete sentences. Questions 50-52 must be answered in Microsoft Excel and your answers must include formulas. Questions 53-55 must be answered with complete sentences and justification within the Word document. Both documents (Word and Excel) must be uploaded into the Assignment link. To access the Liberty University Library online resources from off campus: From the Blackboard log-in page, right-hand side \"Quicklinks\" pull-down menu -choose \"Library.\" Click log-in button. Off-site access cannot be gained unless the user successfully completes the log-in. This must take you to the \"Library Research Portal\"; if not, click on \"Portal.\" Click on the \"databases\" tab. Click on the \"Databases by Letter,\" and select the letter \"S.\" Scroll down until you see \"Standard & Poor's NetAdvantage.\" Click on the link and then you may begin your search. Tips for choosing a company: This project will be easier and more meaningful if you select a company that you have heard of before and one whose basic operations you are familiar with. If the company you select is no longer in operation, either because they have been acquired, been through bankruptcy, etc., it is not an appropriate selection; if you want to do a company that has been acquired, you may do the project on the new parent company instead - please clear this with your instructor in advance if the parent company does not begin with the same letter as your last name. Locate the company's annual report before you begin substantial work on the project! That way, if you run into an issue mentioned above, you will not need to start over. The company you choose needs to have issued a 10-K/Annual Report within the past year. This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 7. ACCT 212 INDIVIDUAL LEARNING PROJECT QUESTIONS Name_______________________________ General Information: 1. 2. 3. 4. 5. 6. 7. What is the name of your corporation? Where are the corporate headquarters? What is the corporation's fiscal year end? What are the primary products or services of the corporation? Graph the high and low price of the company's stock for each quarter of the last two years. What was the high and what was the low? Who is the company's transfer agent and where are they located? Who are your company's competitors? Market Information: 8. 9. 10. On which stock exchange is your corporation's stock traded? What is the current market price of their stock? What is the ticker symbol used to identify your corporation on the stock exchange? Internet Information: 11. 12. 13. 14. 15. What is the Internet address of your corporation? Be sure it appears as a hyperlink. Is the corporation's Annual Report online? Are its financial statements on-line? Is your company listed on Annualreports.com? How long is your company's 10-K report at the Securities and Exchange Commission website (Edgar Database)? Cash Flow and Retained Earnings: 16. 17. 18. 19. 20. 21. 22. 23. List the amount of cash flows from each of the 3 activities: Operating, Investing, and Financing for the 2 most recent years. What was the increase or decrease in cash for each of these years? Were there any Non-Cash Investing/Financing Transactions? Describe the type and amount. What is the dollar difference between accrual net income and Cash provided by Operations? What investing activity provided the largest inflow of cash in the current year? What investing activity used the largest amount of cash in the current year? What financing activity provided the largest inflow of cash in the current year? What financing activity used the largest amount of cash in the current year? Does the company have sufficient cash inflows from the appropriate category? Describe any problems the company many experience with cash flow from your analysis of the cash flow statement. Page 1 of 3 ACCT 212 24. 25. 26. 27. 28. 29. 30. Show the change in Retained Earnings for the 2 most recent years. What was net income for each year? How much was paid out in dividends each year? Were the dividends on common stock and/or preferred stock? What was the amount of each? Did Retained Earnings change for any reasons other than net income or dividends? Explain. What classes of stock does your company have? How many shares of each class of stock are authorized, how many are issued, and how many are outstanding? Does your company have any treasury stock? How many shares and what dollar amount? What is the par or stated value of each of your company's stocks? Footnote Disclosures: 31. 32. 33. 34. 35. 36. 37. 38. 39. How many footnote disclosures does your company have? How many significant accounting policies are listed under its Summary of Significant Accounting Policies? What does it include as Cash and Cash Equivalents? What method does it use to value Inventory? What method(s) does it use to depreciate its assets? Does it have any leased assets? If yes, describe them. What policies does it have in regard to Foreign Currency Translations? Describe any pending lawsuits in which it is involved. Provide its Earnings per Share for the 2 most recent years? Report of the Independent Auditor(s): 40. 41. 42. 43. 44. 45. 46. Who is/are your company's auditor(s)? Where are they located? Does the auditor(s) give a qualified opinion, an unqualified opinion, a disclaimer of opinion, or an adverse opinion? What does that opinion mean? Is it good? What is the auditor's responsibility in regard to the financial statements? What is management's responsibility in regard to the financial statements? What financial statements were included in the auditor's opinion? Did the auditor believe that the statements were presented fairly? Management's Report: 47. 48. 49. Who bears the responsibility for the integrity and the objectivity of the financial statements? What does management say they are doing to assure the public that the financial information is reliable? What is the responsibility of the Audit Committee of the Board of Directors? Page 2 of 3 ACCT 212 Analysis: (use Excel to complete this section) 50. 51. 52. Provide common-size analysis of your company's income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas). Provide horizontal analysis of your company's income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas). Perform ratio analysis on your company using the ratios listed in Exhibit 13.16 on page 529 of your text (these must be in an Excel spreadsheet, using formulas to calculate the ratios). You should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusions about your company after each category of ratios (i.e. How liquid is your company? How efficiently is it using its assets? etc.). Conclusions: 53. 54. 55. Are you optimistic or pessimistic regarding the future of your chosen corporation? Explain. Would you invest in the stock of the company? Explain. Would you invest in the bonds of the company? Explain. Page 3 of 3 ACCT 212 INDIVIDUAL LEARNING PROJECT QUESTIONS Name_______________________________ General Information: 1. 2. 3. 4. 5. 6. 7. What is the name of your corporation? Where are the corporate headquarters? What is the corporation's fiscal year end? What are the primary products or services of the corporation? Graph the high and low price of the company's stock for each quarter of the last two years. What was the high and what was the low? Who is the company's transfer agent and where are they located? Who are your company's competitors? Market Information: 8. 9. 10. On which stock exchange is your corporation's stock traded? What is the current market price of their stock? What is the ticker symbol used to identify your corporation on the stock exchange? Internet Information: 11. 12. 13. 14. 15. What is the Internet address of your corporation? Be sure it appears as a hyperlink. Is the corporation's Annual Report online? Are its financial statements on-line? Is your company listed on Annualreports.com? How long is your company's 10-K report at the Securities and Exchange Commission website (Edgar Database)? Cash Flow and Retained Earnings: 16. 17. 18. 19. 20. 21. 22. 23. List the amount of cash flows from each of the 3 activities: Operating, Investing, and Financing for the 2 most recent years. What was the increase or decrease in cash for each of these years? Were there any Non-Cash Investing/Financing Transactions? Describe the type and amount. What is the dollar difference between accrual net income and Cash provided by Operations? What investing activity provided the largest inflow of cash in the current year? What investing activity used the largest amount of cash in the current year? What financing activity provided the largest inflow of cash in the current year? What financing activity used the largest amount of cash in the current year? Does the company have sufficient cash inflows from the appropriate category? Describe any problems the company many experience with cash flow from your analysis of the cash flow statement. Page 1 of 3 ACCT 212 24. 25. 26. 27. 28. 29. 30. Show the change in Retained Earnings for the 2 most recent years. What was net income for each year? How much was paid out in dividends each year? Were the dividends on common stock and/or preferred stock? What was the amount of each? Did Retained Earnings change for any reasons other than net income or dividends? Explain. What classes of stock does your company have? How many shares of each class of stock are authorized, how many are issued, and how many are outstanding? Does your company have any treasury stock? How many shares and what dollar amount? What is the par or stated value of each of your company's stocks? Footnote Disclosures: 31. 32. 33. 34. 35. 36. 37. 38. 39. How many footnote disclosures does your company have? How many significant accounting policies are listed under its Summary of Significant Accounting Policies? What does it include as Cash and Cash Equivalents? What method does it use to value Inventory? What method(s) does it use to depreciate its assets? Does it have any leased assets? If yes, describe them. What policies does it have in regard to Foreign Currency Translations? Describe any pending lawsuits in which it is involved. Provide its Earnings per Share for the 2 most recent years? Report of the Independent Auditor(s): 40. 41. 42. 43. 44. 45. 46. Who is/are your company's auditor(s)? Where are they located? Does the auditor(s) give a qualified opinion, an unqualified opinion, a disclaimer of opinion, or an adverse opinion? What does that opinion mean? Is it good? What is the auditor's responsibility in regard to the financial statements? What is management's responsibility in regard to the financial statements? What financial statements were included in the auditor's opinion? Did the auditor believe that the statements were presented fairly? Management's Report: 47. 48. 49. Who bears the responsibility for the integrity and the objectivity of the financial statements? What does management say they are doing to assure the public that the financial information is reliable? What is the responsibility of the Audit Committee of the Board of Directors? Page 2 of 3 ACCT 212 Analysis: (use Excel to complete this section) 50. 51. 52. Provide common-size analysis of your company's income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas). Provide horizontal analysis of your company's income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas). Perform ratio analysis on your company using the ratios listed in Exhibit 13.16 on page 529 of your text (these must be in an Excel spreadsheet, using formulas to calculate the ratios). You should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusions about your company after each category of ratios (i.e. How liquid is your company? How efficiently is it using its assets? etc.). Conclusions: 53. 54. 55. Are you optimistic or pessimistic regarding the future of your chosen corporation? Explain. Would you invest in the stock of the company? Explain. Would you invest in the bonds of the company? Explain. Page 3 of 3 Here are some common questions I get and errors I encounter for question #52 - ratio analysis. It is possible that a few of the ratios will not apply to your company. The ratios that might not apply are as follows: (1) If your company provides a service rather than selling a product, then they will probably not have inventory, and may not have cost of goods sold - in this case, inventory turnover and days sales in inventory would not apply; (2) If your company is a retail or restaurant company, then they may not have accounts receivable if their customers pay them at the time of the sale - in this case, accounts receivable turnover and days sales uncollected would not apply; (3) If you company has very little long term debt, and interest expense is immaterial, then interest expense may not be shown on the income statement or may be combined with other items - in this case, times interest earned would not apply. All of the other ratios should apply to all companies. Don't think that a ratio doesn't apply simply because your company doesn't have one of the items in the formula. Just show that item as zero and calculate the ratio. For example, a common error is return on common stockholders' equity. If a company doesn't have any preferred dividends, then the numerator for that ratio is just net income since you would be subtracting zero. When you are using Excel formulas, make sure to include parentheses where needed. If you need to add or subtract two or more numbers together before multiplying or dividing, then you need to put the numbers to be added or subtracted in parentheses (just like in elementary school math - Excel uses the standard order of operations). Make sure you are using averages where required by the formula. You can use just a simple average of the ending balance plus the beginning balance (prior year ending) divided by 2. Pay attention to when you use current assets/liabilities and when you use total assets/liabilities. Shareholders' equity applicable to common shares is all shareholders' equity except preferred shares. Some students make the mistake of only including the par value. But additional paid in capital, retained earnings, etc. is also equity applicable to common shares. The number of shares outstanding is usually included in the equity section of the balance sheet in the description of common stock. It will say something like, "Common stock, $1 par value, 1,000,000 shares authorized, 500,000 shares issued, 300,000 shares outstanding." Be careful of decimal errors for ratios involving number of shares - if the financial statement numbers are in thousands or millions, make sure your number of shares is comparable. You can double check your earnings per share calculation by looking at the EPS reported on the income statement - you might not come up with the exact same number, but it should be close. \fDividend yield is used to compare the dividend-paying performance of different investment alternatives. We compute dividend yield is shown. Some companies, such as Google, do not declare and pay dividends because they wish to reinvest the cash to grow their businesses in the hope of generating greater future earnings and dividends. Computation of the price-earnings ratio is shown. Predicted earnings per share for the next period is often used in the denominator of this computation. Reported earnings per share for the most recent period is also commonly used. In both cases, the ratio is used as an indicator of the future growth and risk of a company's earnings as perceived by the stock's buyers and sellers. We can calculate the return on common stockholders' equity. The numerator is net income available to common shareholders, which is net income less preferred dividends, divided by average common stockholders' equity. Perhaps the most important goal in operating a company is to earn net income for its owner(s). Return on common stockholders' equity measures a company's success in reaching this goal and is defined as shown. Return on total assets is defined as shown
Posted Date: