RATIO ASSIGNMENT ACCTG 231 - SPRING 2020 You have recently come into a little money and have decided to invest it. You have a fairly low tolerance for risk, so have narrowed your selection down to two, long-time stable companies: Proctor and Gamble, a company specializing in personal care, home care, and baby care products. General Mills, a company specializing in packaged foods. In addition to the requirements presented here, you have been provided with the 2019 annual reports of both companies in order to prepare a ratio analysis of each company for its fiscal year 2019. Within each company's annual report are the Consolidated Statements of Earnings and the Consolidated Balance Sheets that you will need to compute the ratios. Requirements To receive full credit, you must show your calculations and they are to be based on the formulas used in the textbook for this class (note: ratio formulas can vary slightly from source to source). For your convenience, a handy summary of ratio formulas is presented on pages 678- 679 of the text. Evaluate the LIQUIDITY of each company Compute each company's 2019 Current Ratio, and Acid Test ratio (2 points). Explain IN YOUR OWN WORDS (in one or two sentences) which company you rate higher on liquidity (1 points). Evaluate the ASSET MANAGEMENT of each company Compute each company's 2019 A/R Collection period, Average Sale period, Total Asset Turnover. For the A/R Collection period, assume all sales are on credit (3 points). Explain IN YOUR OWN WORDS (in one or two sentences) which company you rate higher on Asset Management (2 points). Evaluate the DEBT MANAGEMENT of each company 1. Compute each company's 2019 Times Interest Earned ratio and Debt to Equity ratio (2 points) 2. Explain IN YOUR OWN WORDS (in one or two sentences) which company you rate higher on Debt Management (2 points). Evaluate the PROFITABILITY of each company Compute each company's 2019 Gross Margin %, Net Profit %, Return on Total Assets and Return on Equity (for simplicity, assume the income tax rate is 30%). (4 points) Explain IN YOUR OWN WORDS (in one or two sentences) which company you rate higher on Profitability (2 points). Choose a company Explain IN YOUR OWN WORDS (in two or three sentences) which company you would prefer to invest in and why. (2 points). Table of Contents Letter to Shareowners P&G's 10-Category Portfolio Noticeable Superiority Constructive Disruption Form 10-K Company and Shareholder Information Measures Not Defined by U.S. GAAP Company Leadership Board of Directors Recognition and Commitments Citizenship at P&G 77 78 Inside Back Cover FINANCIAL HIGHLIGHTS (UNAUDITED) Amounts in billions, except per share amounts 2019 2018 2017 2016 2015 Net Sales $67.7 $66.8 $65.1 $65.3 $70.7 Operating Income $5.5 $13.4 $13.8 $15.3 $13.3 $10.5 $11.1 $7.0 Net Earnings Attributable to P&G $3.9 $9.8 Net Earnings Margin from Continuing Operations 5.9% 11.7% 14.8% $3.67 15.7% $3.69 15.4% $3.49 Diluted Net Earnings per Common Share from Continuing Operations! $1.43 $2.84 Diluted Net Earnings per Common Share $2.44 $3.76 Core Earnings per Share 2 $1.43 $4.52 $15.2 $2.90 $3.67 $4.22 $14.9 $5.59 $3.92 $12.8 $2.70 $2.70 $3.69 $3.67 $15.4 $2.66 Operating Cash Flow $14.6 Dividends per Common Share $2.79 $2.59 2019 NET SALES BY BUSINESS SEGMENT 2019 NET SALES BY GEOGRAPHIC REGION 45% 23% Fabric & Home Care Baby, Feminine & Family Care Beauty Health Care Grooming 33% 27% 19% 12% 10% North America* Europe Asia Pacific Greater China India, Middle East & Africa (IMEA) Latin America RATIO ASSIGNMENT ACCTG 231 - SPRING 2020 You have recently come into a little money and have decided to invest it. You have a fairly low tolerance for risk, so have narrowed your selection down to two, long-time stable companies: Proctor and Gamble, a company specializing in personal care, home care, and baby care products. General Mills, a company specializing in packaged foods. In addition to the requirements presented here, you have been provided with the 2019 annual reports of both companies in order to prepare a ratio analysis of each company for its fiscal year 2019. Within each company's annual report are the Consolidated Statements of Earnings and the Consolidated Balance Sheets that you will need to compute the ratios. Requirements To receive full credit, you must show your calculations and they are to be based on the formulas used in the textbook for this class (note: ratio formulas can vary slightly from source to source). For your convenience, a handy summary of ratio formulas is presented on pages 678- 679 of the text. Evaluate the LIQUIDITY of each company Compute each company's 2019 Current Ratio, and Acid Test ratio (2 points). Explain IN YOUR OWN WORDS (in one or two sentences) which company you rate higher on liquidity (1 points). Evaluate the ASSET MANAGEMENT of each company Compute each company's 2019 A/R Collection period, Average Sale period, Total Asset Turnover. For the A/R Collection period, assume all sales are on credit (3 points). Explain IN YOUR OWN WORDS (in one or two sentences) which company you rate higher on Asset Management (2 points). Evaluate the DEBT MANAGEMENT of each company 1. Compute each company's 2019 Times Interest Earned ratio and Debt to Equity ratio (2 points) 2. Explain IN YOUR OWN WORDS (in one or two sentences) which company you rate higher on Debt Management (2 points). Evaluate the PROFITABILITY of each company Compute each company's 2019 Gross Margin %, Net Profit %, Return on Total Assets and Return on Equity (for simplicity, assume the income tax rate is 30%). (4 points) Explain IN YOUR OWN WORDS (in one or two sentences) which company you rate higher on Profitability (2 points). Choose a company Explain IN YOUR OWN WORDS (in two or three sentences) which company you would prefer to invest in and why. (2 points). Table of Contents Letter to Shareowners P&G's 10-Category Portfolio Noticeable Superiority Constructive Disruption Form 10-K Company and Shareholder Information Measures Not Defined by U.S. GAAP Company Leadership Board of Directors Recognition and Commitments Citizenship at P&G 77 78 Inside Back Cover FINANCIAL HIGHLIGHTS (UNAUDITED) Amounts in billions, except per share amounts 2019 2018 2017 2016 2015 Net Sales $67.7 $66.8 $65.1 $65.3 $70.7 Operating Income $5.5 $13.4 $13.8 $15.3 $13.3 $10.5 $11.1 $7.0 Net Earnings Attributable to P&G $3.9 $9.8 Net Earnings Margin from Continuing Operations 5.9% 11.7% 14.8% $3.67 15.7% $3.69 15.4% $3.49 Diluted Net Earnings per Common Share from Continuing Operations! $1.43 $2.84 Diluted Net Earnings per Common Share $2.44 $3.76 Core Earnings per Share 2 $1.43 $4.52 $15.2 $2.90 $3.67 $4.22 $14.9 $5.59 $3.92 $12.8 $2.70 $2.70 $3.69 $3.67 $15.4 $2.66 Operating Cash Flow $14.6 Dividends per Common Share $2.79 $2.59 2019 NET SALES BY BUSINESS SEGMENT 2019 NET SALES BY GEOGRAPHIC REGION 45% 23% Fabric & Home Care Baby, Feminine & Family Care Beauty Health Care Grooming 33% 27% 19% 12% 10% North America* Europe Asia Pacific Greater China India, Middle East & Africa (IMEA) Latin America