WALL STREET PREP FINANCIAL MODELING PRACTICE EXAM QUESTIONS WITH CORRECT DETAILED ANSWERS | ALREADY GRADED A+RECENT VERSION

WALL STREET PREP FINANCIAL MODELING PRACTICE EXAM QUESTIONS WITH CORRECT DETAILED ANSWERS | ALREADY GRADED A+RECENT VERSION 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: ) - ANSWER 2) According to its 2013 10-K, how many more shares can Colgate repurchase in the future under it share repurchase program? - ANSWER 25,937,562 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 - ANSWER I and III only 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) - ANSWER 0.46 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%) - ANSWER 2.2% 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). - ANSWER 1641 7) Colgate declared a common stock split during 2013. - ANSWER True 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) - ANSWER 42832 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) - ANSWER 83 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) - ANSWER 939.9 11) As of December 31, 2013, Colgate had preference stock outstanding. - ANSWER False 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%) - ANSWER 4.5% 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)) - ANSWER 29 14) It is March 31, 2014. What is EBay's latest available actual share count? Please provide your answer without comma separator or decimal (Ex: ) - ANSWER 15) It is March 31, 2014. What is the latest reported number of E-Bay shares beneficially owned by the company's CEO? Please provide your answer without comma separator or decimal (Ex: ) - ANSWER 2663844 16) The Coca-Cola Company reported its 1Q 2014 results on or before April 14, 2014. - ANSWER False 17) Based on its 1Q 2014 press release, what is the maximum $ amount the Coca-Cola Company expects to spend in repurchasing its shares during the current fiscal year. Please provide your answer in billions, with 1 decimal place (Ex: 6.2) - ANSWER 3 18) Based on its 1Q 2014 press release, the Coca-Cola Company expects its effective annual tax rate to stay the same in 2014. - ANSWER True 19) Based on its 1Q 2014 press release, the Coca-Cola Company did not have any restructuring charges during the quarter. - ANSWER False 20) Looking at Tesla Motors' 2013 10-K, in what quarter what was the company's stock at its lowest price in 2013? - ANSWER Q1 21) According to Tesla's 10-K, how many Model S cars did the company deliver in 2013? - ANSWER 22,477 22) In 2013, how much money did Tesla raise via common stock term-26offerings, net of fees and expenses? - ANSWER 410.1 23) What are the terms of the convertible notes that Tesla raised in May 2013? - ANSWER $660 million 1.50% Convertible Notes due 2018 24) What is the range of useful life estimates that Tesla provides for office furniture, machinery and equipment in the 2013 10-K? - ANSWER 3 to 12 years 25) How much stock-based compensation expense was embedded within Tesla's selling, general and administrative expenses in 2011, 2012 and 2013 respectively (in millions)? - ANSWER $15.372, $21.371, $39.090 26) In 2013, what percentage of sales did Tesla generate in North America? - ANSWER 76.8% 27) What is Tesla's long-term portion of capital lease obligations as of December 31, 2013 (in $ thousands)? Please provide your answer without comma separator or decimal (Ex: 23456) - ANSWER 12862 28) What was Tesla's 4Q 2013 gross profit margin? - ANSWER 25.5% 29) According to Twitter's amended S-1 filed November 4, 2013, approximately how many shares of common stock would be outstanding after the offering? Please provide your answer without comma separator or decimal (Ex: ) - ANSWER 30) According to Twitter's amended S-1 filed November 4, 2013, what were the estimated amounts of net proceeds to be received by the company after the offering, excluding and including the over-allotment option? - ANSWER $1.62 billion; $1.86 billion 31) According to Twitter's amended S-1 filed November 4, 2013, what was Twitter's 9-month adjusted EBITDA for the period ending September 30, 2013? Please provide your answer in thousands without comma separator or decimal (Ex: ) - ANSWER 30685 32) What is the pro-forma as adjusted cash and cash equivalents amount on Twitter's balance sheet as mentioned in the amended S-1 filed November 4, 2013? Please provide your answer in thousands without comma separator or decimal (Ex: ) - ANSWER 1777009 33) Per Twitter's amended S-1 filing, what are the maximum estimated capital expenditures in 2013? Please provide your answer in millions without comma separator or decimal (Ex: ) - ANSWER 98 34) What is the latest actual share count reported in Chevron Corporation's 3Q 2013 filing? Please provide your answer without comma separator or decimal (Ex: ) - ANSWER 1,923,173,013 35) Per Chevron's 3Q 2013 filing, what was the percentage change in the cost of purchased oil products when comparing nine months ended September 30, 2013 versus the same period in 2012? - ANSWER -4.5% 36) Per Chevron's 3Q 2013 filing, what was the percentage change in diluted EPS when comparing nine months ended September 30, 2013 versus the same period in 2012? - ANSWER -11.4% 37) How much did Chevron pay in cash dividends to common shareholders during the first nine months of 2013? Please provide your answer in millions without comma separator or decimal (Ex: ) - ANSWER 5571