Short and simple financial findings

sumeetmadh
PA2_Excel.xlsx

Income 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