Question 1
Examine PepsiCo, Inc.?s Consolidated Balance Sheet on p. A6 in Appendix A of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004. ? Calculate the following for PepsiCo, Inc. and show your work: o The Current Ratio for 2005 o The Current Ratio for 2004 o Two measures of vertical analysis?for example, compute the current assets divided by total assets for each year, and express your result as a percentage o Two measures of horizontal analysis?for example, compute the total change in assets by percentage, by dividing current assets in 2005 by current assets in 2004. Compute a similar percentage for current liabilities ? Examine The Coca-Cola Company?s Consolidated Balance sheet on p. B2 in Appendix B of Financial Accounting, especially its Current Assets, Current Liabilities, and Total Assets for years 2005 and 2004. ? Calculate the following for Coca-Cola and show your work: o The Current Ratio for 2005 o The Current Ratio for 2004 o Two measures of vertical analysis?for example, compute the current assets divided by total assets for each year, and express your result as a percentage o Two measures of horizontal analysis?for example, compute the total change in assets by percentage, by dividing current assets in 2005 by current assets in 2004. Compute a similar percentage for current liabilities ? Post your explanation as an attachment in Microsoft Word and your calculations as an attachment in Microsoft Excel to the Assignment Link. I appriciate any help you are able to give me. Thank you I have included additional documents.
Question 2
"The comparative financial statements of Optical Solutions Inc. are as follows. The market price of Optical Solutions Inc. common stock was $60.00 on December 31, 2010. Optical Solutions Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2010 and 2009 2010 2009 Retained earnings, January 1 $ 604,000 $306,000 Add net income for year 428,000 314,000 Total $1,032,000 $620,000 Deduct dividends: On preferred stock $ 4,000 $ 4,000 On common stock 12,000 12,000 Total $ 16,000 $ 16,000 Retained earnings, December 31 $1,016,000 $604,000 Optical Solutions Inc. Comparative Income Statement For the Years Ended December 31, 2010 and 2009 2010 2009 Sales $1,608,000 $1,481,600 Sales returns and allowances 5,920 6,000 Net sales $1,602,080 $1,475,600 Cost of goods sold 480,200 499,200 Gross profit $1,121,880 $ 976,400 Selling expenses $ 324,000 $ 352,000 Administrative expenses 234,000 211,200 Total operating expenses $ 558,000 $ 563,200 Income from operations $ 563,880 $ 413,200 Other income 24,000 19,200 $ 587,880 $ 432,400 Other expense (interest) 110,720 80,000 Income before income tax $ 477,160 $ 352,400 Income tax expense 49,160 38,400 Net income $ 428,000 $ 314,000 Dec. 31, 2010 Dec. 31, 2009 Assets Current assets: Cash $ 240,000 $ 162,400 Temporary investments 364,000 328,800 Accounts receivable (net) 260,000 211,200 Inventories 208,000 66,400 Prepaid expenses 44,000 23,200 Total current assets $1,116,000 $ 792,000 Long-term investments 204,800 256,000 Property, plant, and equipment (net). 1,539,200 976,000 Total assets. $2,860,000 $2,024,000 Liabilities Current liabilities $ 360,000 $ 320,000 Long-term liabilities: Mortgage note payable, 8%, due 2015 $ 384,000 ? Bonds payable, 10%, due 2019 800,000 $ 800,000 Total long-term liabilities $1,184,000 $ 800,000 Total liabilities. $1,544,000 $1,120,000 Stockholders? Equity Preferred $2.00 stock, $50 par $ 100,000 $ 100,000 Common stock, $5 par 200,000 200,000 Retained earnings 1,016,000 604,000 Total stockholders? equity $1,316,000 $ 904,000 Total liabilities and stockholders? equity. $2,860,000 $2,024,000 Instructions Determine the following measures for 2010, rounding to one decimal place: 1. Working capital 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days? sales in receivables 6. Inventory turnover 7. Number of days? sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders? equity 10. Number of times interest charges earned 11. Number of times preferred dividends earned 12. Ratio of net sales to assets 13. Rate earned on total assets 14. Rate earned on stockholders? equity 15. Rate earned on common stockholders? equity 16. Earnings per share on common stock 17. Price-earnings ratio 18. Dividends per share of common stock 19. Dividend yield",Disregard I will re-submit
Question 3
Please open attachment..,Just in case you are not able to open the attachment... 4- Bond Yields: The Timberlake-Jackson Wardrobe Co. has 8 percent coupon bonds on the market with nine years left to maturity. The bonds make annual payments. If the bond currently sells for $1047.50, what is its YTM? 6- Bond Prices: Brittany Co. issued 15 years bonds one year ago at a coupon rate of 8.50 percent. The bonds make semiannual payments. I the YTM on these bonds is 7.90 percent, what is the current bond price? 8- Coupon Rates: Young Corporation has bonds on the market with 10.5 years to maturity, a YTM of 6.9 percent, and a current price of $1,070. The bonds make semiannual payments. What must the coupon rete be on the bonds? 2- Stock values: The next dividend payment by Carroll, Inc,. will be $1.90 per share. The dividends are anticipated to maintain a 5.5 percent growth rate, forever. If the stock currently sells for $47.00 per share, what is the required return? 4- Stock Values: Diamond Corporation will pay a $3.75 per share dividend next year. The company pledges to increase its dividend by 5.5 percent per year, indefinitely. If you require a 12 percent return on your investment, how much will you pay for the company?s stock today? 8- Valuing Preferred Stock: Gesto, Inc., has an issue of preferred stock outstanding that pays a $5 dividend every year, in perpetuity. If this issue currently sells for $84.12 per share, what is the required return? 10- Growth Rates: The stock price of Retro Co is $65. Investors require a12 percent rate of return on similar stocks. If the company plans to pay a dividend of $3.80 next year, what growth rate is expected for the company?s stock price? 12- Stock Valuation: Barnard Corp. will pay a dividend of $3.05 next year. The company has stated that it will maintain a constant growth rate of 5 percent a year forever. If you want a 15 percent rate of return, how much will you pay for the stock? What if your want a 10 percent rate of return? What does this tell you about the relationship between the required return and the stock price?
Question 5
" Accounting Information Krogers: (KR) http://finance.yahoo.com/q/bs?s=KR+Balance+Sheet&annual Competitors: Wal-Mart: (WMT) http://cdn.walmartstores.com/sites/AnnualReport/2010/PDF/01_WMT%202010_Financials.pdf Target: (TGT) http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Income&Symbol=US%3aTGT&stmtView=Qtr Kroger is the major company and Wal-Mart and Target are the competitors. Prepare a draft of the financial analysis for the previous 3 companies. Please submit analysis, relevant charts, diagrams, and graphics. Overall requirements: A thorough analysis would include comparisons in the common size statements and financial ratios relative to the company?s past financial results and relative to a group of leading competitors. Past results only. Conclusions that emerge from the analysis should be summarized in a professional manner. Charts, diagrams and graphics should be used throughout the report to enhance the clarity and professionalism of the document. Analysis Process The following steps describe the process for this analysis. 1. Obtain company reports and company financial statements from public sources. LexisNexis and annual reports from corporate Web sites for public companies are sources that may be useful. 2. Develop common size financial statements and compare them both through time and relative to benchmark companies for the most recent year. 3. Develop relevant financial ratios for comparison through time and for comparison to benchmark companies?no more than two. Where possible, choose companies of similar size and industry. 4. Prepare a financial statement analysis with relevant charts, diagrams, and graphics. 5. Present the analysis in a professional manner with persuasive arguments with respect to your major conclusions. Analysis Structure The project will be the completion of a financial assessment of a publicly traded company of your choice. The content of the report will be structured as follows. 1. Executive Summary with overall assessment. Characterize the strength of the company, along with the level of risk assumed. 2. Company Background. To provide context for this analysis, include a brief discussion of the company?history, a review of the key managers, and the nature of the products/services. This summary should be no more than 2 pages. 3. Operations and Products/Services. Include a brief description of the key products or services offered by the company. The primary competitors within each product/service area should be defined as discussed. How does your company fit within the industry as a whole? Are they a leader? Follower? Strong performer? Weak performer? 4. Financial Statements and Common Size Statements. Include a presentation and discussion of the financial statements and the common size statements. Provide a general discussion of the metrics in the financial statements and common size statements. Explain any substantial issues that appear on the financial statements and common size statements. Identify any material differences or variances from year to year and relative to key competitors. Three years of financial statements should be used. 5. Financial Ratios. Provide the calculation and presentation of three years of financial ratios together with the most recent financial ratios for the key competitors. You should aggregate the financial statements of the key competitors and then calculate these competitor ratios based upon this aggregated set of financial statements. You should discuss each financial ratio by referencing differences or variances of your company to the competitor ratios, and you should discuss each financial ratio by referencing differences or variances of your company to itself across time. The financial ratios of interest should be those that have been examined within our course. Project Objectives To successfully complete this project: 1. Develop common size financial statements for use in financial statement analysis. 2. Evaluate financial statements by analyzing financial ratios through time. 3. Evaluate financial statements by analyzing financial ratios relative to a benchmark company or companies. 4. Demonstrate differential/variance analysis through development of relevant financial ratios. 5. Present the analysis in a professional manner with persuasive arguments with respect to your major conclusions. Length of paper: Approximately 15 double-spaced pages including reference page in APA format. Documentation: Written analysis, relevant charts, diagrams, and graphics.,I submitted another $200.00 dollar payment. Counting the first payment that makes a total of $280.00
