PLEASE USE Yahoo Finance: TIF (Tifanny & Co.) Only fill out 2019 Q3 and 2019 Q4 columns
Company Name Tiffany & Co. Ticker Symbol TIF historical dates may not match ratio dates below Historical Stock Price: 29-Mar-19 105.559 28-Jun-19 93.64 30-Sep-19 92.63 30-Dec-19 133.48 Today's Stock Price: 114.05 Today's Date 9/15/20 Today's Beta: 0.89 Date Beta Observed 9/15/20 Financial Ratio Analysis *To identify Q3 & Q4, click on "Statistics" under "Financial Highlights". Next, see "Fiscal Year End" date, which indicates end of Q4. Now, count backwards approx. three months to end of Q3. JAN-FEB-MAR-APR-MAY-JUN-JUL-AUG-SEP-OCT-NOV-DEC (count backwards) 2019 Q3* 2019 Q4* Actual Change in Value % Change in Value 92.63 Performance Measure Parameters: Price per Share on Quarter's Last Trading Day Shares Outstanding Book Value of Equity (a.k.a. Book Value) 1200 133.65 1200 3335400 $41.0 $ 0 $0 $192,900 44% 0% 6% 3142500 Performance Measures: Market Value Added (= market value-book value) Market-to-Book ratio (= market value/book value) -3031344 0.035 3193620 0.048 $6,224,964 $0 -205% 37% I. Leverage Ratio Parameters: Long-Term Debt Book Value of Equity Total Liabilities Total Assets EBIT Interest Payments (a.k.a. Interest Expense) Depreciation $0 #REF! $0 $0 $0 $0 $0 #DIV/0! #REF! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Leverage Ratios (5 ratios): Long-Term Debt Long-Term Debt-Equity Total Debt Times Interest Eamed Cash Coverage 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 II. Liquidity Ratio Parameters: Net Working Capital Total Assets Current Assets Current Liabilities Cash Marketable Securities $0 $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Receivables Liquidity Ratios (4 ratios): Net Working Capital to Total Assets Current Ratio Quick Ratio Cash Ratio 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! III. Efficiency Ratio Parameters: Sales (a.k.a. Revenue) Total Assets Receivables Daily Sales Cost of Goods Sold Inventory 0 0 0 0 $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Efficiency Ratios (5 ratios): Asset Turnover Average Collection Period (days) Inventory Turnover Days in Inventories Receivables Turnover #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! IV. Profitability Ratio & Growth Parameters: Net Income (a.k.a. Earnings) Sales (a.k.a. Revenue) Interest Payments (a.k.a. Interest Expense) Total Assets Book Value of Equity Dividends (input as a positive value) 0 0 0 #REF! 0 0 0 0 $0 $0 $0 $0 #REF! $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #REF! #DIV/0! Profitability Ratios (5 ratios): Return on Equity (ROE) Return on Assets (ROA) Return on Capital (ROC) Economic Value Added (EVA) Operating Profit Margin OOOOO #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 Growth Measures (3 ratios) Payout Plowback Growth in Equity from Plowback 0 #DIV/0! #DIV/0! #DIV/0! 0 Company Name Tiffany & Co. Ticker Symbol TIF historical dates may not match ratio dates below Historical Stock Price: 29-Mar-19 105.559 28-Jun-19 93.64 30-Sep-19 92.63 30-Dec-19 133.48 Today's Stock Price: 114.05 Today's Date 9/15/20 Today's Beta: 0.89 Date Beta Observed 9/15/20 Financial Ratio Analysis *To identify Q3 & Q4, click on "Statistics" under "Financial Highlights". Next, see "Fiscal Year End" date, which indicates end of Q4. Now, count backwards approx. three months to end of Q3. JAN-FEB-MAR-APR-MAY-JUN-JUL-AUG-SEP-OCT-NOV-DEC (count backwards) 2019 Q3* 2019 Q4* Actual Change in Value % Change in Value 92.63 Performance Measure Parameters: Price per Share on Quarter's Last Trading Day Shares Outstanding Book Value of Equity (a.k.a. Book Value) 1200 133.65 1200 3335400 $41.0 $ 0 $0 $192,900 44% 0% 6% 3142500 Performance Measures: Market Value Added (= market value-book value) Market-to-Book ratio (= market value/book value) -3031344 0.035 3193620 0.048 $6,224,964 $0 -205% 37% I. Leverage Ratio Parameters: Long-Term Debt Book Value of Equity Total Liabilities Total Assets EBIT Interest Payments (a.k.a. Interest Expense) Depreciation $0 #REF! $0 $0 $0 $0 $0 #DIV/0! #REF! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Leverage Ratios (5 ratios): Long-Term Debt Long-Term Debt-Equity Total Debt Times Interest Eamed Cash Coverage 0 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 0 II. Liquidity Ratio Parameters: Net Working Capital Total Assets Current Assets Current Liabilities Cash Marketable Securities $0 $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Receivables Liquidity Ratios (4 ratios): Net Working Capital to Total Assets Current Ratio Quick Ratio Cash Ratio 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! III. Efficiency Ratio Parameters: Sales (a.k.a. Revenue) Total Assets Receivables Daily Sales Cost of Goods Sold Inventory 0 0 0 0 $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Efficiency Ratios (5 ratios): Asset Turnover Average Collection Period (days) Inventory Turnover Days in Inventories Receivables Turnover #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! IV. Profitability Ratio & Growth Parameters: Net Income (a.k.a. Earnings) Sales (a.k.a. Revenue) Interest Payments (a.k.a. Interest Expense) Total Assets Book Value of Equity Dividends (input as a positive value) 0 0 0 #REF! 0 0 0 0 $0 $0 $0 $0 #REF! $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #REF! #DIV/0! Profitability Ratios (5 ratios): Return on Equity (ROE) Return on Assets (ROA) Return on Capital (ROC) Economic Value Added (EVA) Operating Profit Margin OOOOO #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 Growth Measures (3 ratios) Payout Plowback Growth in Equity from Plowback 0 #DIV/0! #DIV/0! #DIV/0! 0
