DEC 48 DEC 47 DEC 46 DEC 15 DEC 14 DEC 3 DEC 12 365 Days 365 Days 366 Days 365 Days 365 Days 365 Days 366 Days 158.2 3,168.8 291.4 3,732.7 530.4 145.2 220.3 3,547.6 459.2 155.9 264.2 3,380.6 436.6 157.1 345.4 314.3 3,768.1 776.1 153.0 0.0 86.9 408.9 5,507.3 289.9 3,392.1 390.0 159.0 11.7 136.0 357.6 4,736.3 266.5 3,145.8 366.1 156.7 12.5 141.6 352.4 4,441.5 635 401.6 5,164.9 45.3 360.5 4.788.7 23.2 366.8 4,628.6 161.9 11.3 136.4 344.1 4,326.1 2.196.0 290.0 2 Mercury General Corporation 3 MCY 589400100 2578464 NYSE Common stock 4 Source: FactSet Fundamentals s Al figures in millions of U.S. Dollar except per share items 6 7 Balance Sheet 8 Assets 9 Cash 10 Investments 11 Premium Balance Receivables 12 Net Property, Plant & Equipment 13 Investment in Unconsolidated Subs. 14 Deferred Tax Assets 15 Other Assets 16 Total Assets 17 Liabilities & Shareholders' Equity 18 Insurance Policy Liabilities 19 Total Debt 20 Deferred Tax Liabilities 21 Other Liabilities 22 Total Liabilities 23 24 Common Equity 25 Total Shareholders' Equity 26 Total Equity 27 Total Liabilities & Shareholders' Equity 28 Per Share 29 Book Value per Share 30 Tangible Book Value per Share 31 Supplemental 32 Bonds Below Investment Grade 33 Net Debt 34 Total Capital 35 Stock Option Comp Exp (Net of Tax) 36 Stock Option Comp Exp - Adj to Net Income 37 # Non-Qualified Option/Warrant Awards Outstanding at Beginning of Period 38 # Non-Qualified Option/Warrant Awards Outstanding at End of Period 39 Non-Qualified Option/Warrant Awards Exercisable 40 sparatiLease Commitments 3,065.6 371.7 73.6 378.7 3.889.6 2.612.5 371.3 86.5 333.1 3,403,5 2,364.7 320.0 0.0 - 351.6 3,036.3 2,091.6 290.0 1413 337.9 2,860.8 1,992.5 190.0 126.3 310.2 2.619.0 1.956.6 140.0 136.9 250.2 2,483.6 321.8 2,807.8 1.618 1.618 1,618 5,507 1,761 1,761 1,761 5.165 1,752 1.752 1.752 4,789 1.821 1,821 1.821 4,629 1.875 1.875 1.875 4,736 1,822 1.822 1,822 4.442 1.842 1,842 1.842 4,326 29.23 28.18 31.83 30.69 31.70 30.46 33.01 31.66 34.02 32.60 33.15 31.62 33.55 31.90 0.00 0.00 - 0.00 - 57.44 79.92 99,68 25.78 0.09 1.989.42 2.132.72 2,072.40 2.110.89 2.165.45 3.96 -76.51 2.012.49 0.77 -18.18 1.982.50 0.25 1.99 5.18 0.17 0.25 0.17 0.30 41 CS Scanned ann 0.04 0.10 0.04 45.69 12.81 11.55 8.73 0.09 0.04 0.37 31.93 10.82 8.02 5.79 0.09 0.59 27.10 14.65 6.78 2.71 0.43 0.25 1.16 40.04 14.18 12.75 8.87 0.45 0.43 0.86 44.63 13.28 11.21 9.51 31.99 14.77 11.01 4.68 0.54 0.45 0.39 41.72 14.22 10.07 6.99 11 42 10 Year 3 8.73 6.97 3.66 1.97 0.00 153.02 42.80 42.80 5.79 3.86 2.77 0.67 0.00 145.22 42.80 42.80 2.71 1.95 0.86 0.15 20.00 155.91 42.80 42.80 4.68 1.01 0.46 0.06 0.00 157.13 42.80 42.80 8.87 3.70 0.51 0.03 0.00 158.98 42.80 42.80 9.51 7.35 3.11 0.17 0.00 156.72 42.80 42.80 6.99 5.66 3.84 0.95 1.01 161.94 42.80 42.80 7.85 0.95 4633 5.37 32.27 5.22 15.52 -6.85 -18.62 4.94 5.16 -0.78 8.86 -0.34 11.95 -1.18 8.78 7.83 6.54 1.44 -6.61 -25.17 3.47 19.59 8.90 68.48 -0.73 5.99 -3.23 10.99 3.77 2.40 -6.82 2.67 36.78 1.82 -8.18 6.63 40.34 11.39 -7.16 94.90 -1.72 -8.16 3.46 -82.92 2.58 -5.00 -2.27 1.48 -7.09 6.64 10.84 6.49 -6.43 3.33 7.85 Year 3 Year 4 Year 5 Over 5 Years Long Term Debt Maturities Net Property, Plant & Equipment Gross Goodwill Goodwill Annual Growth - % change from previous period 2 Assets 8 Cash Investments Premium Balance Receivables Net Property, Plant & Equipment 3 Investment in Unconsolidated Subs B Deferred Tax Assets Other Assets 0 Intangible Assets 1 Total Assets 2 Liabilities & Shareholders' Equity 3 Insurance Policy Liabilities 4 Total Debt 5 ST Debt & Curr. Portion LT Debt 6 Long-Term Debt 7 Deferred Tax Liabilities 8 Other Liabilities 9 Total Liabilities 0 *1 Common Equity 2 Total Shareholders' Equity 3 Total Equity 14 Total Liabilities & Shareholders' Equity 5 Net Property. Plant & Equipment 76 27 98 09 80 31 4.97 17.34 0.11 7.68 10.34 4.99 0.00 6.99 0.00 52.63 10.48 16.04 -100.00 23.78 1.84 35.71 -100.00 36.70 -7.68 23.98 3.45 0.00 0.11 -14.92 - 13.69 14.28 52.63 11.85 8.94 9.23 -0.72 17.41 2.61 5.26 12.09 9.28 8.14 4.78 -1.86 5.45 -8.16 8.16 8.16 6.63 5.37 0.51 0.51 0.51 7.85 -5.85 -3.76 -3.76 -3.76 3.46 -0.78 -2.91 -2.91 -2.91 -2.27 -1.16 2.91 2.91 2.91 6.64 1.44 -1.09 -1.09 -1.09 2.67 3.23 -0.81 -0.81 -0.81 3.33 -8.90 CS Scanne 33 84 B D E F DEC 18 IDEC 17 DEC 46 DEC 15 DEC 14 DEC 365 Days 365 Days 366 Days 365 Days 365 Days 365 3,516.3 2,576.8 953.1 -13.6 17.0 30.6 0.0 3,326.0 2,444.9 702.1 179.0 15.2 163.8 3.3 3,078.5 2,145.5 859.2 73.7 3.2 70.6 0.0 3,249.1 2,353.1 819.2 76.7 4.0 72.7 0.0 2.0 - 70.7 -2.3 73.0 73.0 73.0 2,967.6 1,986.1 731.4 250.1 2.6 247.4 0.0 2.8 1,5 7 1 1 1: 30.6 -24.9 -5.7 -5.7 -5.7 167.1 222 144.9 144.9 144.9 70.6 3.9 74.5 74.5 74.5 247.4 69.5 177.9 177.9 177.9 11 11 11 -0.10 -0.10 84.63 2.50 2.62 2.62 96.17 2.49 1.35 1.32 96.54 2.48 1.35 1.35 93.50 2.47 3.23 3.23 86.75 2.46 2 2. 89 2 5 Al figures in Millions of U.S. Dollar except per share items. 6 7 Income Statement 8 Sales 9 Losses, Claims & Reserves 10 Selling, General & Admin. Expenses & Other 11 Operating Income Before Interest Expense 12 Interest Expense, Net of Interest Capitalized 13 Operating Income After Interest Expense 14 Nonoperating Income (Expense) 15 Unusual Expense - Net 16 Pretax Income 17 Income Taxes 18 Consolidated Net Income 19 Net Income 20 Net Income available to Common 21 Per Share 22 EPS (recurring) 23 EPS (diluted) 24 Eamings Persistence 25 Dividends per Share 26 Supplemental 27 Rental Expense 28 Stock Option Comp Exp (Net of Tax) 29 Tax Rate 30 Annual Growth - % change from previous period 31 Sales 32 Losses, Claims & Reserves 33 Selling, General & Admin. Expenses & Other 34 Selling. General & Admin. Expenses Other Operating Expense 36 Operating Income Before Interest Expense 37 Interest Expense, Net of Interest Capitalized 38 Operating Income After Interest Expense 39 Nonoperating Income (Expense) 40 Unusual Expense - Net 41 Pretax Income 42 Income Taxes 43 Consolidated Net Income 44 Not Income 45 ha 46 (recurring) 47 EPS (diluted) 14.90 14.70 19.70 16.00 5.18 -5.54 14.60 3.96 28.08 19 0. 15. 13.29 -3.28 3.72 1.19 5.72 5.40 35.75 3.55 3.74 8.02 17.48 1.87 4.4 0.0 20.3 5.8 2.37 3.90 -14.30 -1.13 -505.54 133.36 282.84 125.21 5.54 9.68 4.66 0.99 -69.09 - 4.00 25.06 3.06 35 -107.59 12.32 -118.69 -100.00 - -70.51 20.14 -71.48 6.98 -210.58 - 87.51 109.29 87.31 -2.5 -18.3 136.25 -118.32 -212.06 - -103.95 -103.95 0.22 40.70 -1.93 -1.93 -71.48 -105.63 -58.15 -58.15 87.31 248.20 58.68 58.68 -2.31 8.45 4.04 4.08 98.34 98.34 94.52 98.48 -0.22 -2.22 -58.29 -58.20 58.52 58.33 4.15 4.23 -103.95 3 4 + Fill in the blue color cells 5 Use the inputs in the previous worksheet to answer the questions here. 6 Turn in this file to Canvas "Assignments" 7 8 $ billion 9 TROW MCY Dec, 2018 10 Month/Year 11 Sales ($billion) 12 Net Income ($billion) 13 Total assets ($billion) 14 Total equity ($billion) 15 Dec, 2018 5.373 1.794 7.786 -0.0057 1.6177 6.865 16 33.39% 69.01% 1.13 17 18 Net profit margin 19 Asset utilization 20 Equity multiplier 21 Equity ratio 22 ROE 23 Major business 24 25 26 Which firm is more profitable: 27 28 asthm mainly relve un powdh to inance asies 29 30 88.17% 26.13% fund company (managing various funds) DEC 48 DEC 47 DEC 46 DEC 15 DEC 14 DEC 3 DEC 12 365 Days 365 Days 366 Days 365 Days 365 Days 365 Days 366 Days 158.2 3,168.8 291.4 3,732.7 530.4 145.2 220.3 3,547.6 459.2 155.9 264.2 3,380.6 436.6 157.1 345.4 314.3 3,768.1 776.1 153.0 0.0 86.9 408.9 5,507.3 289.9 3,392.1 390.0 159.0 11.7 136.0 357.6 4,736.3 266.5 3,145.8 366.1 156.7 12.5 141.6 352.4 4,441.5 635 401.6 5,164.9 45.3 360.5 4.788.7 23.2 366.8 4,628.6 161.9 11.3 136.4 344.1 4,326.1 2.196.0 290.0 2 Mercury General Corporation 3 MCY 589400100 2578464 NYSE Common stock 4 Source: FactSet Fundamentals s Al figures in millions of U.S. Dollar except per share items 6 7 Balance Sheet 8 Assets 9 Cash 10 Investments 11 Premium Balance Receivables 12 Net Property, Plant & Equipment 13 Investment in Unconsolidated Subs. 14 Deferred Tax Assets 15 Other Assets 16 Total Assets 17 Liabilities & Shareholders' Equity 18 Insurance Policy Liabilities 19 Total Debt 20 Deferred Tax Liabilities 21 Other Liabilities 22 Total Liabilities 23 24 Common Equity 25 Total Shareholders' Equity 26 Total Equity 27 Total Liabilities & Shareholders' Equity 28 Per Share 29 Book Value per Share 30 Tangible Book Value per Share 31 Supplemental 32 Bonds Below Investment Grade 33 Net Debt 34 Total Capital 35 Stock Option Comp Exp (Net of Tax) 36 Stock Option Comp Exp - Adj to Net Income 37 # Non-Qualified Option/Warrant Awards Outstanding at Beginning of Period 38 # Non-Qualified Option/Warrant Awards Outstanding at End of Period 39 Non-Qualified Option/Warrant Awards Exercisable 40 sparatiLease Commitments 3,065.6 371.7 73.6 378.7 3.889.6 2.612.5 371.3 86.5 333.1 3,403,5 2,364.7 320.0 0.0 - 351.6 3,036.3 2,091.6 290.0 1413 337.9 2,860.8 1,992.5 190.0 126.3 310.2 2.619.0 1.956.6 140.0 136.9 250.2 2,483.6 321.8 2,807.8 1.618 1.618 1,618 5,507 1,761 1,761 1,761 5.165 1,752 1.752 1.752 4,789 1.821 1,821 1.821 4,629 1.875 1.875 1.875 4,736 1,822 1.822 1,822 4.442 1.842 1,842 1.842 4,326 29.23 28.18 31.83 30.69 31.70 30.46 33.01 31.66 34.02 32.60 33.15 31.62 33.55 31.90 0.00 0.00 - 0.00 - 57.44 79.92 99,68 25.78 0.09 1.989.42 2.132.72 2,072.40 2.110.89 2.165.45 3.96 -76.51 2.012.49 0.77 -18.18 1.982.50 0.25 1.99 5.18 0.17 0.25 0.17 0.30 41 CS Scanned ann 0.04 0.10 0.04 45.69 12.81 11.55 8.73 0.09 0.04 0.37 31.93 10.82 8.02 5.79 0.09 0.59 27.10 14.65 6.78 2.71 0.43 0.25 1.16 40.04 14.18 12.75 8.87 0.45 0.43 0.86 44.63 13.28 11.21 9.51 31.99 14.77 11.01 4.68 0.54 0.45 0.39 41.72 14.22 10.07 6.99 11 42 10 Year 3 8.73 6.97 3.66 1.97 0.00 153.02 42.80 42.80 5.79 3.86 2.77 0.67 0.00 145.22 42.80 42.80 2.71 1.95 0.86 0.15 20.00 155.91 42.80 42.80 4.68 1.01 0.46 0.06 0.00 157.13 42.80 42.80 8.87 3.70 0.51 0.03 0.00 158.98 42.80 42.80 9.51 7.35 3.11 0.17 0.00 156.72 42.80 42.80 6.99 5.66 3.84 0.95 1.01 161.94 42.80 42.80 7.85 0.95 4633 5.37 32.27 5.22 15.52 -6.85 -18.62 4.94 5.16 -0.78 8.86 -0.34 11.95 -1.18 8.78 7.83 6.54 1.44 -6.61 -25.17 3.47 19.59 8.90 68.48 -0.73 5.99 -3.23 10.99 3.77 2.40 -6.82 2.67 36.78 1.82 -8.18 6.63 40.34 11.39 -7.16 94.90 -1.72 -8.16 3.46 -82.92 2.58 -5.00 -2.27 1.48 -7.09 6.64 10.84 6.49 -6.43 3.33 7.85 Year 3 Year 4 Year 5 Over 5 Years Long Term Debt Maturities Net Property, Plant & Equipment Gross Goodwill Goodwill Annual Growth - % change from previous period 2 Assets 8 Cash Investments Premium Balance Receivables Net Property, Plant & Equipment 3 Investment in Unconsolidated Subs B Deferred Tax Assets Other Assets 0 Intangible Assets 1 Total Assets 2 Liabilities & Shareholders' Equity 3 Insurance Policy Liabilities 4 Total Debt 5 ST Debt & Curr. Portion LT Debt 6 Long-Term Debt 7 Deferred Tax Liabilities 8 Other Liabilities 9 Total Liabilities 0 *1 Common Equity 2 Total Shareholders' Equity 3 Total Equity 14 Total Liabilities & Shareholders' Equity 5 Net Property. Plant & Equipment 76 27 98 09 80 31 4.97 17.34 0.11 7.68 10.34 4.99 0.00 6.99 0.00 52.63 10.48 16.04 -100.00 23.78 1.84 35.71 -100.00 36.70 -7.68 23.98 3.45 0.00 0.11 -14.92 - 13.69 14.28 52.63 11.85 8.94 9.23 -0.72 17.41 2.61 5.26 12.09 9.28 8.14 4.78 -1.86 5.45 -8.16 8.16 8.16 6.63 5.37 0.51 0.51 0.51 7.85 -5.85 -3.76 -3.76 -3.76 3.46 -0.78 -2.91 -2.91 -2.91 -2.27 -1.16 2.91 2.91 2.91 6.64 1.44 -1.09 -1.09 -1.09 2.67 3.23 -0.81 -0.81 -0.81 3.33 -8.90 CS Scanne 33 84 B D E F DEC 18 IDEC 17 DEC 46 DEC 15 DEC 14 DEC 365 Days 365 Days 366 Days 365 Days 365 Days 365 3,516.3 2,576.8 953.1 -13.6 17.0 30.6 0.0 3,326.0 2,444.9 702.1 179.0 15.2 163.8 3.3 3,078.5 2,145.5 859.2 73.7 3.2 70.6 0.0 3,249.1 2,353.1 819.2 76.7 4.0 72.7 0.0 2.0 - 70.7 -2.3 73.0 73.0 73.0 2,967.6 1,986.1 731.4 250.1 2.6 247.4 0.0 2.8 1,5 7 1 1 1: 30.6 -24.9 -5.7 -5.7 -5.7 167.1 222 144.9 144.9 144.9 70.6 3.9 74.5 74.5 74.5 247.4 69.5 177.9 177.9 177.9 11 11 11 -0.10 -0.10 84.63 2.50 2.62 2.62 96.17 2.49 1.35 1.32 96.54 2.48 1.35 1.35 93.50 2.47 3.23 3.23 86.75 2.46 2 2. 89 2 5 Al figures in Millions of U.S. Dollar except per share items. 6 7 Income Statement 8 Sales 9 Losses, Claims & Reserves 10 Selling, General & Admin. Expenses & Other 11 Operating Income Before Interest Expense 12 Interest Expense, Net of Interest Capitalized 13 Operating Income After Interest Expense 14 Nonoperating Income (Expense) 15 Unusual Expense - Net 16 Pretax Income 17 Income Taxes 18 Consolidated Net Income 19 Net Income 20 Net Income available to Common 21 Per Share 22 EPS (recurring) 23 EPS (diluted) 24 Eamings Persistence 25 Dividends per Share 26 Supplemental 27 Rental Expense 28 Stock Option Comp Exp (Net of Tax) 29 Tax Rate 30 Annual Growth - % change from previous period 31 Sales 32 Losses, Claims & Reserves 33 Selling, General & Admin. Expenses & Other 34 Selling. General & Admin. Expenses Other Operating Expense 36 Operating Income Before Interest Expense 37 Interest Expense, Net of Interest Capitalized 38 Operating Income After Interest Expense 39 Nonoperating Income (Expense) 40 Unusual Expense - Net 41 Pretax Income 42 Income Taxes 43 Consolidated Net Income 44 Not Income 45 ha 46 (recurring) 47 EPS (diluted) 14.90 14.70 19.70 16.00 5.18 -5.54 14.60 3.96 28.08 19 0. 15. 13.29 -3.28 3.72 1.19 5.72 5.40 35.75 3.55 3.74 8.02 17.48 1.87 4.4 0.0 20.3 5.8 2.37 3.90 -14.30 -1.13 -505.54 133.36 282.84 125.21 5.54 9.68 4.66 0.99 -69.09 - 4.00 25.06 3.06 35 -107.59 12.32 -118.69 -100.00 - -70.51 20.14 -71.48 6.98 -210.58 - 87.51 109.29 87.31 -2.5 -18.3 136.25 -118.32 -212.06 - -103.95 -103.95 0.22 40.70 -1.93 -1.93 -71.48 -105.63 -58.15 -58.15 87.31 248.20 58.68 58.68 -2.31 8.45 4.04 4.08 98.34 98.34 94.52 98.48 -0.22 -2.22 -58.29 -58.20 58.52 58.33 4.15 4.23 -103.95 3 4 + Fill in the blue color cells 5 Use the inputs in the previous worksheet to answer the questions here. 6 Turn in this file to Canvas "Assignments" 7 8 $ billion 9 TROW MCY Dec, 2018 10 Month/Year 11 Sales ($billion) 12 Net Income ($billion) 13 Total assets ($billion) 14 Total equity ($billion) 15 Dec, 2018 5.373 1.794 7.786 -0.0057 1.6177 6.865 16 33.39% 69.01% 1.13 17 18 Net profit margin 19 Asset utilization 20 Equity multiplier 21 Equity ratio 22 ROE 23 Major business 24 25 26 Which firm is more profitable: 27 28 asthm mainly relve un powdh to inance asies 29 30 88.17% 26.13% fund company (managing various funds)