Prompt: Milestone Two should contain the following sections:
Michelle_Michy
20200423193337jp_morgan_milestone_one.xlsxJPM Income Statement
| JPMORGAN CHASE & CO (JPM) Income Statement | |||
| Fiscal year ends in December. USD in millions except per share data. | 2017-12 | 2018-12 | 2019-12 |
| Revenue | $99,624.00 | $109,029.00 | $115,627.00 |
| Gross profit | $99,624.00 | $109,029.00 | $115,627.00 |
| Operating expenses | |||
| Sales, General and administrative | $41,615.00 | $45,209.00 | $47,555.00 |
| Other operating expenses | ($41,615.00) | ($45,209.00) | ($47,555.00) |
| Total operating expenses | |||
| Operating income | $99,624.00 | $109,029.00 | $115,627.00 |
| Interest Expense | $14,275.00 | $22,383.00 | $26,795.00 |
| Other income (expense) | ($49,449.00) | ($45,882.00) | ($44,287.00) |
| Income before taxes | $35,900.00 | $40,764.00 | $44,545.00 |
| Provision for income taxes | $11,459.00 | $8,290.00 | $8,114.00 |
| Net income from continuing operations | $24,441.00 | $32,474.00 | $36,431.00 |
| Net income | $24,441.00 | $32,474.00 | $36,431.00 |
| Preferred dividend | $1,663.00 | $1,551.00 | $1,587.00 |
| Net income available to common shareholders | $22,778.00 | $30,923.00 | $34,844.00 |
| Earnings per share | |||
| Basic | 6.35 | 9.04 | 10.75 |
| Diluted | 6.31 | 9 | 10.72 |
| Weighted average shares outstanding | |||
| Basic | 3552 | 3396 | 3222 |
| Diluted | 3577 | 3414 | 3230 |
JPM Balance Sheet
| JPMORGAN CHASE & CO (JPM) Balance Sheet | ||||
| Fiscal year ends in December. USD in millions except per share data. | 2016-12 | 2017-12 | 2018-12 | 2019-12 |
| Assets | ||||
| Current assets | ||||
| Cash | ||||
| Cash and cash equivalents | $389,635.00 | $430,121.00 | $278,793.00 | $263,631.00 |
| Short-term investments | $325,321.00 | |||
| Total cash | $389,635.00 | $755,442.00 | $278,793.00 | $263,631.00 |
| Receivables | $52,330.00 | $67,729.00 | $73,200.00 | $72,861.00 |
| Other current assets | ($441,965.00) | ($823,171.00) | ($351,993.00) | ($336,492.00) |
| Total current assets | ||||
| Non-current assets | ||||
| Property, plant and equipment | ||||
| Net property, plant and equipment | $14,131.00 | $14,159.00 | $14,934.00 | $25,813.00 |
| Equity and other investments | $661,189.00 | $575,279.00 | $675,542.00 | $809,342.00 |
| Goodwill | $47,288.00 | $47,507.00 | ||
| Intangible assets | $6,958.00 | $6,885.00 | $54,349.00 | $53,341.00 |
| Other long-term assets | ($729,566.00) | ($643,830.00) | ($744,825.00) | ($888,496.00) |
| Total non-current assets | ||||
| Total assets | $2,490,972.00 | $2,533,600.00 | $2,622,532.00 | $2,687,379.00 |
| Liabilities and stockholders' equity | ||||
| Liabilities | ||||
| Current liabilities | ||||
| Short-term debt | $11,738.00 | $24,186.00 | $69,276.00 | $40,920.00 |
| Accounts payable | $190,543.00 | $102,727.00 | $114,794.00 | $118,375.00 |
| Other current liabilities | ($202,281.00) | ($126,913.00) | ($184,070.00) | ($159,295.00) |
| Total current liabilities | ||||
| Non-current liabilities | ||||
| Long-term debt | $295,245.00 | $284,080.00 | $282,031.00 | $291,498.00 |
| Other long-term liabilities | ($295,245.00) | ($284,080.00) | ($282,031.00) | ($291,498.00) |
| Total non-current liabilities | ||||
| Total liabilities | $2,236,782.00 | $2,277,907.00 | $2,366,017.00 | $2,426,049.00 |
| Stockholders' equity | ||||
| Preferred stock | $26,068.00 | $26,068.00 | $26,068.00 | $26,993.00 |
| Common stock | $4,105.00 | $4,105.00 | $4,105.00 | $4,105.00 |
| Additional paid-in capital | $91,627.00 | $90,579.00 | $89,162.00 | $88,522.00 |
| Retained earnings | $162,440.00 | $177,676.00 | $199,202.00 | $223,211.00 |
| Treasury stock | ($28,854.00) | ($42,595.00) | ($60,494.00) | ($83,049.00) |
| Accumulated other comprehensive income | ($1,196.00) | ($140.00) | ($1,528.00) | $1,548.00 |
| Total stockholders' equity | $254,190.00 | $255,693.00 | $256,515.00 | $261,330.00 |
| Total liabilities and stockholders' equity | $2,490,972.00 | $2,533,600.00 | $2,622,532.00 | $2,687,379.00 |
JPM Cash Flow
| JPMORGAN CHASE & CO (JPM) Statement of Cash Flow | |||
| Fiscal year ends in December. USD in millions except per share data. | 2017-12 | 2018-12 | 2019-12 |
| Cash Flows From Operating Activities | |||
| Net income | $24,441 | $32,474 | $36,431 |
| Depreciation & amortization | $6,179 | $7,791 | $8,368 |
| Deferred income taxes | $2,312 | $1,721 | $949 |
| Change in working capital | ($49,304) | ($26,994) | ($61,178) |
| Accounts receivable | ($15,868) | ($5,849) | ($78) |
| Other working capital | ($33,436) | ($21,145) | ($61,100) |
| Other non-cash items | $13,871 | ($805) | $21,476 |
| Net cash provided by operating activities | ($2,501) | $14,187 | $6,046 |
| Cash Flows From Investing Activities | |||
| Purchases of investments | ($107,658) | ($104,459) | ($255,576) |
| Sales/Maturities of investments | $150,881 | $86,413 | $125,804 |
| Other investing activities | ($53,506) | ($179,947) | $75,759 |
| Net cash used for investing activities | ($10,283) | ($197,993) | ($54,013) |
| Cash Flows From Financing Activities | |||
| Debt issued | $56,271 | $71,662 | $61,085 |
| Debt repayment | ($83,079) | ($76,313) | ($69,610) |
| Preferred stock issued | $1,258 | $1,696 | $5,000 |
| Preferred stock repaid | ($1,258) | ($1,696) | ($4,075) |
| Common stock repurchased | ($15,410) | ($19,983) | ($24,001) |
| Dividend paid | ($8,993) | ($10,109) | ($12,343) |
| Other financing activities | $65,853 | $68,901 | $76,931 |
| Net cash provided by (used for) financing activities | $14,642 | $34,158 | $32,987 |
| Effect of exchange rate changes | $96 | ($2,863) | ($182) |
| Net change in cash | $1,954 | ($152,511) | ($15,162) |
| Cash at beginning of period | $23,873 | $431,304 | $278,793 |
| Cash at end of period | $25,827 | $278,793 | $263,631 |
| Free Cash Flow | |||
| Operating cash flow | ($2,501) | $14,187 | $6,046 |
| Free cash flow | ($2,501) | $14,187 | $6,046 |
Ratio
| 2017-12 | 2018-12 | 2019-12 | |
| Profitability | |||
| Profit margin | 0.245 | 0.298 | 0.315 |
| Return on Asset | 0.010 | 0.013 | 0.014 |
| Return on equity | 0.096 | 0.127 | 0.139 |
| Liability ratios | |||
| Debt to equity ratio | 8.909 | 9.224 | 9.283 |
| Effciency ratios | |||
| Asset turnover | 0.040 | 0.042 | 0.044 |
| Receivables turnover | 1.660 | 1.547 | 1.583 |
| Fixed asset turnover | 7.043 | 7.495 | 5.675 |
| Leverage ratio | |||
| debt/asset | 0.899 | 0.902 | 0.903 |
| Market value | |||
| Market capitalization ($millions) | $366,301.58 | $319,780.67 | $429,909.60 |
| Reference | |||
| (https://www.gurufocus.com/term/mktcap/NYSE:JPM/Market-Cap/JPMorgan-Chase) |
