ANALYZING FINANCIAL REPORTS WALL STREET PREP ACTUAL EXAM (COMPLETE) 40 QUESTIONS AND 100% CORRECT ANSWERS GRADED A+/ ANALYZING FINANCIAL REPORTS ACTUAL EXAM FROM WALL STREET PREP 2024 -2025 (B RAND NEW!!) Question 1 What is the latest actual share count reported in the 2013 Colgate -Palmolive 10-K? Please provide your answer without comma separator or decimal (Ex: 23456326563) Note: This exam also tests your ability to locate financial reports. All reports required to answer exam questions can be found online at sec.gov. Your answer is correct. 918,943,637 as of January 31, 2014 – front cover of the 10-K Question 2 According to its 2013 10-K, how many more shares can Colgate repurchase in the future under it share repurchase program? 25,937,562 Your answer is incorrect. The company can yet repurchase 25,937,562 shares according to Colgate’s 2013 10-K. Question 3 According to Colgate’s 2013 10-K, what factors led to lower effective non-GAAP tax rate during the year as compared to the company’s effective GAAP tax rate? I. 2012 Restructuring Program II. Venezuela devaluation charge III. Charges for French competition law matters IV. Business realignment and other cost -saving initiatives I and II only I, II, and III only I and III only I, II, and IV only Your answer is incorrect. 2012 Restructuring Program and Charges for French competition law matters led to effective non-GAAP tax rate of 31.7% compared to effective GAAP tax rate of 32.4% for 2013. Question 4 Colgate reported Diluted EPS of $2.38 in accordance with GAAP. How much higher would EPS be if Colgate ignored the impact of restructuring and other one-time charges during the period? Please provide your answer with 2 decimal places, but without $ sign (Ex: 0.50) Your answer is correct. 2013 diluted EPS would increase from $2.38 (GAAP) to $2.84 (non -GAAP), per MD&A. $2.84 -$2.38=$0.46 Question 5 What was the weighted average interest rate Colgate faced on its short -term borrowings in 2013? Enter with 1 decimal place and with % sign (Ex: 9.9%) 6,760,592 30,425,271 31,905,271 Your answer is correct. 2.2% weighted average interest rate per the company’s note 6. Question 6 Based on the company’s 2013 10-K, how much long term debt is maturing between 2014 and 2016? Please provide your answer in millions without comma separator or decimal (Ex: 2345). Your answer is correct. $895m + $491m + $255m = $1,641m – per the company’s note 6. Question 7 Colgate declared a common stock split during 2013. True False Your answer is correct. True – per financial note 8 of the company’s 10-K. Question 8 How many Colgate options were outstanding as of December 31, 2013? Please provide your answer in thousands, without comma separator or decimal (Ex: 23456) Your answer is correct. According to Colgate’s 10-K, 42,832 options remained outstanding as of 12/31/13. Question 9 As of December 31, 2013, how many deferred tax liabilities (net of deferred tax assets) did Colgate have? Please provide your answer in millions, without comma separator or decimal (Ex: 23456) Your answer is correct. DTL’s of $1,087m – $DTA’s of $1,004m = $83m – per financial footnote 11. Question 10 The number of shares Colgate used to compute its 2013 diluted EPS was: Please provide your answer as found in the report without comma separator with 1 decimal (Ex: 23.5) Your answer is correct. 939.9 million diluted shares – per company’s financial footnote 12. Question 11 As of December 31, 2013, Colgate had preference stock outstanding. True False Your answer is incorrect. False: Colgate has the authority to issue 50,262,150 shares of preference stock, but no preference stock is currently outstanding. Question 12 For 2014, Colgate anticipates its capital expenditures to be approximately at what % of sales? Enter with 1 decimal place and with % sign (Ex: 9.9%) Your answer is correct. Colgate anticipates it’s capital expenditures to be about 4.5% of sales, per the company’s note 6. Question 13 As of December 31, 2013, Colgate assumes amortization expense for each of next five years to be approximately: (Please provide your answer as found in the report without comma separator with 1 decimal (Ex: 23.5))