Alphabet Inc. Class C Balance Sheet (Industrial) All figures in millions of U.S. Dollar except per share items. Source: FactSet Fundamentals Cash Only 16,587 Total Short Te 104,469 Short-Term Re 21,317 Inventories 964 4,100 Other Current Total Current 147,437 Property, Plan 101,143 Accumulated I 26,539 Total Investme 12,112 Long-Term No Intangible Ass 19,902 20,204 6/30/2019 3/31/2019 12/31/2018 9/30/2018 6/30/2018 3/31/2018 12/31/2017 9/30/2017 6/30/2017 3/31/2017 12/31/2016 9 19,148 16,701 13,443 14,148 12,658 10,715 10,581 15,711 94,340 92,439 92,973 88,106 90,227 91,156 89,562 79,002 19,260 21,193 18,067 17,244 16,814 18,705 15,577 14,877 1,053 1,107 1,212 698 636 749 4,406 4,236 4,007 3,961 3,426 2,983 138,207 135,676 129,702 124,157 123,761 124,308 94,095 82,507 77.128 71,876 24,730 22,788 21,828 18,132 12,918 74,307 73,415 12,969 14.232 765 2,860 119,345 398 2,398 112,386 280 3,106 108,794 105,408 268 4,575 67,801 59,647 56,358 53,341 50,321 47.527 18,956 17,264 16,238 15,665 14,385 13,293 14,474 13,859 12,673 11,487 10,976 7,813 7,269 6,642 6,131 5,878 - 20,006 Deferred Tax 585 Other Assets Total Assets 2,461 257,101 750 2,547 245,349 20,108 737 2,693 232,792 20,343 682 2,838 221,538 20,557 20,671 19,439 19,614 685 3,052 211,610 678 2,004 206,935 680 2,672 197,295 19,537 505 376 2,683 2,004 189,536 178,621 680 19,684 1,397 19,775 365 1.166 172,756 167,497 383 422 ST Debt & Cur Accounts Paya 1,329 Income Tax Pa 3,925 536 Other Current 32,539 Total Current 37,000 3,710 761 30,439 34,910 4,378 69 30,173 3,789 3,369 3,526 1,189 1,343 3,137 881 2,674 221 2.488 133 2,306 803 2,041 554 27,512 25,345 19,196 20,165 17,798 16,064 12,147 14,161 34,620 31,301 29,903 25,394 24,183 20,693 18,685 15,256 16,756 Long-Term De 13,162 12,272 Deferred Tax 1,892 1,282 4,012 1,264 3,986 3,981 3,973 3,969 3,964 3,955 3,937 3,935 1,318 479 394 430 151 369 604 226 Other Liabiliti 12,855 13,413 Total Liabilitie 64,909 61,877 Common Equi 192,192 183,472 15,268 15,093 55,164 51,698 177,628 169,840 15,247 49,610 162,000 Common Stock 1 1 1 1 16,349 46,110 160,825 1 16,211 7,628 7,326 8,010 7,544 Additional Pai 47,936 46,531 Retained Earn 145,346 Cumulative Tr 138,720 45,048 134,885 (1,802) (1,920) 1 43,110 42,242 41,486 128,405 121,282 120,008 113,247 118,237 (1,884) (1,569) (1,588) (446) (1,103) (1,189) (1,630) 44,793 152,502 1 40,246 32,436 157,100 1 39,608 30.335 148,286 1 27,807 28,461 144,949 139,036 1 1 38,508 111,505 37.697 109,420 36,306 105,131 (2,195) (2,646) Unrealized Ga 704 Other Approp 7 Total Equity 192,192 Total Liabilitie 257,101 38 102 183,472 245,349 232,792 (688) (279) 266 172 177,628 169,840 162,000 221,538 211,610 206,935 (188) 251 (34) (190) 160,825 233 (122) 722 (279) 97 (15) (179) (195) 41 423 152,502 148,286 157,100 197,295 189,536 178,621 172,756 167,497 144,949 139,036 1. Create a transposed copy of the Alphabet's BS in the 'Transposition' sheet ready for Pivot Table use 2. Create a Date variable in the transposed copy