, Inc.'s consolidated balance sheets from its 2007 annual report are presented in Exhibit 5-3.

Excel format - please show formulasBest Buy Co., Inc.’s consolidated balance sheets from its 2007 annual report are presented in Exhibit 5-3.(attached) a. Using the balance sheets, prepare a vertical common-size analysis for 2007 and 2006. Use total assetsas a base.b. Using the balance sheets, prepare a horizontal common-size analysis for 2007 and 2006. Use 2006 asthe base.c. Comment on significant trends that appear in (a) and (b).