Solved by verified expert :You are to create Wine Depot’s financial analyses as of December 31, 2008, and as of December 31, 2009. Following the Chapter 3 examples, use the student file ch3-05.xls to create a vertical analysis of the balance sheet and income statement as of December 31, 2008, and December 31, 2009—as well as a horizontal analysis of both the income statement and balance sheet—in the columns provided. (Note: The horizontal analysis will compare December 31, 2008 with December 31, 2009.) Also create a pie chart of expenses for the year ended December 31, 2009; a column chart of expenses for the years ended December 31, 2008, and December 31, 2009; and a ratio analysis as of December 31, 2009. Save the file as ch3-05_student_name.xls (replacing student_name with your name). Note: You will have to use Excel’s help feature to create the column chart, because the columns are not adjacent to one another as in the chapter example. Use whatever chart layout you prefer.
