Short and simple financial findings
sumeetmadh
PA2_Excel.xlsxIncome Statement
| Period Ending: | 12/31/18 | 12/31/17 | 12/31/16 | 12/31/15 |
| Total Revenue | $232,887,000 | $177,866,000 | $135,987,000 | $107,006,000 |
| Cost of Revenue | $139,156,000 | $111,934,000 | $88,265,000 | $71,651,000 |
| Gross Profit | $93,731,000 | $65,932,000 | $47,722,000 | $35,355,000 |
| Operating Expenses | ||||
| Sales, General and Admin. | $81,310,000 | $61,826,000 | $43,536,000 | $33,122,000 |
| Operating Income | $12,421,000 | $4,106,000 | $4,186,000 | $2,233,000 |
| Add'l income/expense items | $257,000 | $548,000 | $190,000 | ($206,000) |
| Earnings Before Interest and Tax | $12,678,000 | $4,654,000 | $4,376,000 | $2,027,000 |
| Interest Expense | $1,417,000 | $848,000 | $484,000 | $459,000 |
| Earnings Before Tax | $11,261,000 | $3,806,000 | $3,892,000 | $1,568,000 |
| Income Tax | $1,197,000 | $769,000 | $1,425,000 | $950,000 |
| Equity Earnings/Loss Unconsolidated Subsidiary | $9,000 | ($4,000) | ($96,000) | ($22,000) |
| Net Income-Cont. Operations | $10,073,000 | $3,033,000 | $2,371,000 | $596,000 |
| Net Income | $10,073,000 | $3,033,000 | $2,371,000 | $596,000 |
| Net Income Applicable to Common Shareholders | $10,073,000 | $3,033,000 | $2,371,000 | $596,000 |
Balance Sheet
| Period Ending: | 12/31/18 | 12/31/17 | 12/31/16 | 12/31/15 | ||
| Current Assets | ||||||
| Cash and Cash Equivalents | $31,750,000 | $20,522,000 | $19,334,000 | $15,890,000 | ||
| Short-Term Investments | $9,500,000 | $10,464,000 | $6,647,000 | $3,918,000 | ||
| Net Receivables | $16,677,000 | $13,164,000 | $8,339,000 | $5,654,000 | ||
| Inventory | $17,174,000 | $16,047,000 | $11,461,000 | $10,243,000 | ||
| Other Current Assets | $0 | $0 | $0 | $0 | ||
| Total Current Assets | $75,101,000 | $60,197,000 | $45,781,000 | $35,705,000 | 0.0323789136 | |
| Long-Term Assets | ||||||
| Long-Term Investments | $0 | $0 | $0 | $0 | ||
| Fixed Assets | $61,797,000 | $48,866,000 | $29,114,000 | $21,838,000 | ||
| Goodwill | $14,548,000 | $13,350,000 | $3,784,000 | $3,759,000 | ||
| Intangible Assets | $0 | $0 | $0 | $0 | ||
| Other Assets | $11,202,000 | $8,897,000 | $4,723,000 | $3,445,000 | ||
| Deferred Asset Charges | $0 | $0 | $0 | $0 | ||
| Total Assets | $162,648,000 | $131,310,000 | $83,402,000 | $64,747,000 | ||
| Current Liabilities | ||||||
| Accounts Payable | $61,855,000 | $52,786,000 | $39,048,000 | $30,769,000 | ||
| Short-Term Debt / Current Portion of Long-Term Debt | $0 | $0 | $0 | $0 | ||
| Other Current Liabilities | $6,536,000 | $5,097,000 | $4,768,000 | $3,118,000 | ||
| Total Current Liabilities | $68,391,000 | $57,883,000 | $43,816,000 | $33,887,000 | ||
| Long-Term Debt | $23,495,000 | $24,743,000 | $7,694,000 | $8,227,000 | ||
| Other Liabilities | $27,213,000 | $20,975,000 | $12,607,000 | $9,249,000 | ||
| Deferred Liability Charges | $0 | $0 | $0 | $0 | ||
| Misc. Stocks | $0 | $0 | $0 | $0 | ||
| Minority Interest | $0 | $0 | $0 | $0 | ||
| Total Liabilities | $119,099,000 | $103,601,000 | $64,117,000 | $51,363,000 | ||
| Stock Holders Equity | ||||||
| Common Stocks | $5,000 | $5,000 | $5,000 | $5,000 | ||
| Capital Surplus | $26,791,000 | $21,389,000 | $17,186,000 | $13,394,000 | ||
| Retained Earnings | $19,625,000 | $8,636,000 | $4,916,000 | $2,545,000 | ||
| Treasury Stock | ($1,837,000) | ($1,837,000) | ($1,837,000) | ($1,837,000) | ||
| Other Equity | ($1,035,000) | ($484,000) | ($985,000) | ($723,000) | ||
| Total Equity | $43,549,000 | $27,709,000 | $19,285,000 | $13,384,000 | ||
| Total Liabilities & Equity | $162,648,000 | $131,310,000 | $83,402,000 | $64,747,000 | ||
| Cost of Debt |
Return
| Date | Amazon Stock Price | Annual Return of Amazon | S&P 500 Index | Annual Return of S&P 500 |
| 4/1/09 | 80.519997 | 872.809998 | ||
| 4/1/10 | 137.100006 | 70.27% | 1186.689941 | 35.96% |
| 4/1/11 | 195.809998 | 42.82% | 1363.609985 | 14.91% |
| 4/1/12 | 231.899994 | 18.43% | 1397.910034 | 2.52% |
| 4/1/13 | 253.809998 | 9.45% | 1597.569946 | 14.28% |
| 4/1/14 | 304.130005 | 19.83% | 1883.949951 | 17.93% |
| 4/1/15 | 421.779999 | 38.68% | 2085.51001 | 10.70% |
| 4/1/16 | 659.590027 | 56.38% | 2065.300049 | -0.97% |
| 4/1/17 | 924.98999 | 40.24% | 2384.199951 | 15.44% |
| 4/1/18 | 1566.130005 | 69.31% | 2648.050049 | 11.07% |
| 4/1/19 | 1814.19 | 15.84% | 2867.19 | 8.28% |
| The Estimated Beta is 0.1408 |
Amazon Vs S&P 500
0.70268270129220201 0.42822749402359617 0.18431130365467846 9.4480399167237647E-2 0.19825856899459088 0.38684112736591053 0.56382481047898148 0.4023710974029025 0.69313184135106143 0.1583904236609017 0.35962001319787834 0.14908700064560498 2.5153855851238829E-2 0.14282744035300349 0.17925975993541879 0.10698801148778496 -9.6906564356409024E-3 0.15440850938555326 0.11066609488408628 8.2755214948733821E-2
S&P 500
Amazon
NPV
| Year | Cash Flow | |
| 0 | -10 | |
| 1 | 15 | |
| 2 | 15 | |
| 3 | 15 | |
| 4 | 15 | |
| 5 | 15 | |
| 6 | 15 | |
| 7 | 15 | |
| 8 | 15 | |
| 9 | 15 | |
| 10 | 15 | |
| NPV = | $87.29 | Million |
