Please do a horizontal analysis of the balance sheet using the information given. Use the 3rd picture as an example of what it should look like when it's done. Thank you!

Company exclusing Ford Crede Fond Crede Tolai current liasdiles Oener labises and defened revenue (Note 16 and Note 25) Lono-serm dett (Note 19 ) Company excluing Ford Coda Fond Crede Delerred income taxes (Note 7 ) Tolat lisbiclet Eourty Capes in excess of par value of stock. Retained eamingt Treatury shock Told equity acributatile to Ford Motor Company Cquicy abributable to nonconteoting ristests Total eavity: foted habilites and equaty Assets: Cash and cash equevalents Fond Credi trance recenvabies, net Net inviment hoperiving leaset Over aviess Lheilmes Oner labilities and detered trevenue Wendy's Co. Horizontal Analysis of Balance Sheets As of January 3, 2016, December 28, 2014, and December 29, 2013 $s in thousands ASSETS Current assets: Cash and cash equivalents Accounts and notes receivable Inventories Prepaid expenses and other current assets Deferred income tax benefit Advertising funds restricted assets Total current assets Properties Goodwill Other intangible assets investments other asets Total assets 1an.01,2016 Schange XChange Dec.28.2014 schance Xchange Dec, 20,2011. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline 5 & 327,216 & 5 & 59,540 & 2x & $ & 267,278 & 5 & (012,575) & & 380,152 \\ \hline & 104,554 & & 11,406 & & & n.3ss & & 10,473 & in & \\ \hline & 4,312 & & (4,435) & .51% & & 4,807 & & (14.419) & & 10,238 \\ \hline & 112,78 & & 39.056 & sin6 & & 7,692 & & {[2,067)} & & n.35s \\ \hline & & & (n,tsi) & 100% & & n,661 & & (45,545) & & 120,206 \\ \hline & 57,3% & & 2.091 & W & & & & (1.) & x & 6713 \\ \hline & 616,500 & & 54,467 & & & 562,102 & & {[36,90)} & m & on:a1i \\ \hline & 1,227,244 & & (41,23) & & & 1,2n,233 & & 105,751 & N & 1.16s,an \\ \hline & mo,n & & (S1,7a1) & 6s & & & & (19,989) & & ressu \\ \hline & 1,310,399 & & (11,7) & 1k & & 1,351,365 & & 45,345 & N & 1,xos,7ne \\ \hline & 52,36 & & (15,68s) & 21K & & 74,034 & & (9,149) & 118 & 21, 13 \\ \hline & 95.470 & & 10,947 & & & 64.521 & & 20,500 & as & \\ \hline 5 & 4.108,x=2 & 3 & (9,12) & 1x & 5 & 4.145,842 & 5 & (217,151) & ass & 43604 \\ \hline \end{tabular} Fields usang formulas