Project 2: Financial Statement Analysis-YUM! Brands, Inc.
the financial statements for YUM! Brands, Inc. located in Appendix A of your
Textbook, you will calculate Vertical and Horizontal Analysis and the
Financial Ratios listed below for the year ended in 2006.
|The project is due by the end
of Week 7.
|Grade Weight:(75 points)|
financial statement analysis project will count for 7.5% of your overall
course grade. The Worksheets contained in this Workbook will aid in
completing the requirements for submission.
Complete the Excel Spreadsheet in this Workbook labeled Horizontal &
Vertical. Calculate the Horizontal
& Vertical Analysis of YUM Brands, Inc.
|2. Complete the Excel Spreadsheet in this Workbook labeled
Ratios. Calculate the 2006 Ratios and
show your computations and the formulas for YUM! Brands, Inc. Financial
Statements in Appendix A.
|3. Inventory turnover|
|4. Accounts Receivable
|5. Average Collection Period
(Daysâ€™ sales in receivables)
|B. Solvency Ratios|
|1. Debt ratio|
|C. Profitability Ratios|
|1. Gross Profit Percentage|
|2. Rate of return on net
sales (Profit Margin rate)
|3. Rate of return on total
|4. Rate of return on common
|5. Earnings per share of
|6. Price/earnings ratio|
|7. Dividend Yield|
|8. Book value per share of
|*Note: If you are unable to locate an item needed for a ratio, make
an assumption and make sure you note your assumption in your work.