→ Perform a Horizontal Analysis 

→ You may want to type out your financials to make it easier to perform this analysis 

→ Make sure you have a copy of your financial statements for 3 years attached to this assignment 

→ Analyze your Horizontal analysis (discuss the results, what did you observe? What conclusions can you make from your numbers?)

 

Table 1: Financial Data (GOOGLE Inc.) 2019 152,578,000 2018 135,676,000 2017 124,308,000 Item/Year 2016 Current 105,408,000 Assets Current 45,221,000 34,620,000 24,183,000 16,756,000 Liabilities Inventories 999,000 1,107,000 749,000 268,000 Cash 119,675,000 109,140,000 101,871,000 86,333,000 Receivables 25,326,000 20,838,000 18,336,000 14,137,000 Total Assets 275,909,000 232,792,000 197,295,000 167,497,000 74,467,000 55,164,000 44,793,000 28,461,000 Total Liabilities Total Equity 201,442,000 177,628,000 152,502,000 139,036,000 Sales 161,857,000 136,819,000 110,855,000 90,272,000 Cost of Goods 71,896,000 Sold 59,549,000 45,583,000 35,138,000 EBIT 39,725,000 35,027,000 27,302,000 24,274,000 Interest 100,000 114,000 109,000 124,000 Net Income 34,343,000 30,736,000 12,662,000 19,478,000 All numbers in millions, Source: Yahoo Finance