Credit Analysis for Vonage

profileBLUT16
table_1a-13a_fiancial_ratio.xlsx

Sheet1

Financial Statements Ratios
Table 1A
Vonage (VG) (value in 000's) 2013 2014 2015 2016 Table 2A
Income Statement Profit Margin 2013 2014 2015 2016
Sales/Revenue 829,067 868,854 895,072 955,621 Vonage 3.41% 2.33% 2.53% 1.87%
COGS 274,830 267,883 295,978 355,150 AT&T 14.31% 4.86% 9.09% 7.92%
EBIT 54,178 58,289 52,239 43,887 *Information Retrieved from Table 1A and Table 1B.
Interest Expense 6,557 6,823 8,786 13,042
Net Income 28,289 20,266 22,655 17,907 Table 3A
Balance Sheet Return on Assets 2013 2014 2015 2016
Accounts Receivable 38,010 39,681 43,898 36,688 Vonage 4.75% 3.08% 3.11% 2.08%
Inventory 10,584 10,081 5,542 4,116 AT&T 6.70% 2.24% 3.82% 3.22%
Total Current Assets 155,140 115,240 136,807 102,281 *Information Retrieved from Table 1A and Table 1B.
Net Fixed Assets 595,069 658,605 729,513 862,494
Total Assets 642,749 674,460 784,566 940,422 Table 4A
Total Curernt Liabilites 194,115 185,821 190,928 194,426 Return on Equity 2013 2014 2015 2016
Total Debt 134,756 166,233 218,153 322,302 Vonage 8.58% 5.94% 6.18% 4.31%
Shareholder Equity 338,074 344,345 388,741 441,297 AT&T 20.09% 7.13% 12.57% 10.56%
Total Equity 338,074 344,345 388,741 441,297 *Information Retrieved from Table 1A and Table 1B.
Cash Flow Sheet
Working Capital (38,975) (70,581) (54,121) (92,145) Table 5A
*Information Retrieved from http://www.nasdaq.com Inventory Turnover 2013 2014 2015 2016
Vonage 34.24 25.93 37.89 73.55
Table 1B AT&T NA 62.23 22.48 25.32
AT&T (T) (value in 000's) 2013 2014 2015 2016 *Information Retrieved from Table 1A and Table 1B.
Income Statement
Sales 128,752,000 132,447,000 146,801,000 163,786,000 Table 6A
COGS 51,191,000 60,145,000 67,046,000 76,884,000 Days' Sales in Inventory 2013 2014 2015 2016
EBIT 31,990,000 13,968,000 24,812,000 24,722,000 Vonage 10.66 14.08 9.63 4.96
Interest Expense 3,940,000 3,613,000 4,120,000 4,910,000 AT&T NA 5.87 16.24 14.41
Net Income 18,418,000 6,442,000 13,345,000 12,976,000 *Information Retrieved from Table 1A and Table 1B.
Balance Sheet
Accounts Receivable 14,117,000 14,527,000 16,532,000 16,794,000 Table 7A
Inventory 1,933,000 4,033,000 2,039,000 Receivables Turnover 2013 2014 2015 2016
Total Current Assets 23,196,000 33,606,000 35,992,000 38,369,000 Vonage 21.53 22.37 21.42 23.72
Net Fixed Assets 275,051,000 287,310,500 349,753,000 403,246,500 AT&T 9.16 9.25 9.45 9.83
Total Assets 277,787,000 296,834,000 402,672,000 403,821,000 *Information Retrieved from Table 1A and Table 1B.
Total Current Liabilites 34,995,000 37,282,000 47,816,000 50,576,000
Total Debt 74,788,000 81,834,000 126,151,000 123,513,000 Table 8A
Shareholder Equity 90,988,000 89,716,000 122,671,000 123,135,000 Net Working Capital Turnover 2013 2014 2015 2016
Cash Flow Sheet Vonage -21.27 -12.31 -16.54 -10.37
Working Capital (11,799,000) (3,676,000) (11,824,000) (12,207,000) AT&T -10.91 -36.03 -12.42 -13.42
*Information Retrieved from http://www.nasdaq.com *Information Retrieved from Table 1A and Table 1B.
Table 9A
Current Ratio 2013 2014 2015 2016
Vonage 0.80 0.62 0.72 0.53
AT&T 0.66 0.90 0.75 0.76
*Information Retrieved from Table 1A and Table 1B.
Table 10A
Quick Ratio 2013 2014 2015 2016
Vonage 0.74 0.57 0.69 0.50
AT&T 0.66 0.85 0.67 0.72
*Information Retrieved from Table 1A and Table 1B.
Table 11A
Debt To Equity Ratio 2013 2014 2015 2016
Vonage 0.40 0.48 0.56 0.73
AT&T 0.82 0.91 1.03 1.00
*Information Retrieved from Table 1A and Table 1B.
Table 12A
Debt To Assets Ratio 2013 2014 2015 2016
Vonage 0.21 0.25 0.28 0.34
AT&T 0.27 0.28 0.31 0.31
*Information Retrieved from Table 1A and Table 1B.
Table 13A
Interest Coverage Ratio 2013 2014 2015 2016
Vonage 8.26 8.54 5.95 3.37
AT&T 8.12 3.87 6.02 5.04
*Information Retrieved from Table 1A and Table 1B.
Table 14A
Financial Average Ratio 2013 2014 2015 2016
Vonage 1.90 1.96 2.02 2.13
AT&T 3.05 3.31 3.28 3.28
*Information Retrieved from Table 1A and Table 1B.

Sheet2

https://www.google.com/finance?fstype=ii&q=NYSE:T
https://www.thebalance.com/use-asset-management-ratios-in-financial-ratio-analysis-393187
http://quotes.wsj.com/VG/financials/annual/balance-sheet
http://financials.morningstar.com/ratios/r.html?t=VG
http://financials.morningstar.com/ratios/r.html?t=VG

Sheet3