Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have attached the instructions and worksheet. thank you Wine Depot, Inc. Income Statemnt for the period ended Sales Less: Cost of Goods Sold Gross

I have attached the instructions and worksheet. thank youimage text in transcribed

Wine Depot, Inc. Income Statemnt for the period ended Sales Less: Cost of Goods Sold Gross Margin Expenses: Advertising Marketing Depreciation Interest Salary Wages Supplies Utilities Net income before taxes Income taxes Net income Student Name 09/24/2014 December2008 % Sales $275,000 115,000 160,000 $7,000 5,000 8,000 4,000 50,000 20,000 4,600 7,400 106,000 54,000 6,000 $48,000 December2009 % Sales $450,000 225,000 225,000 $12,000 7,000 8,000 2,500 70,000 25,000 7,500 10,000 % Change 142,000 83,000 8,000 $75,000 qattachments_ece557aa16f389f3004509aa5bce5571acd6029c.xlsx Wine Depot, Inc. Balance Sheet as of Assets Current Assets: Cash ShortTerm Investments Accounts Receivable Inventory Prepaid Expenses Supplies Equipment Less: Accumulated Depreciation Total Liabilities and Stockholders' Equity Liabilities Current Liabilities: Accounts Payable Income Tax Payable Notes Payable Equipment Notes Payable Other Payroll Liabilities Stockholders' Equity Common Stock Retained Earnings Total Student Name 09/24/2014 December2008 $5,000 2,000 6,000 6,500 700 1,800 85,000 8,000 $16,000 6,000 9,000 18,000 2,000 1,000 47,000 22,000 77,000 $99,000 51,000 48,000 $99,000 % Assets December2009 $20,000 25,000 15,000 32,000 4,000 10,000 85,000 16,000 $20,000 8,000 6,000 15,000 4,000 1,000 121,000 % Assets % Change 106,000 69,000 $175,000 53,000 122,000 $175,000 qattachments_ece557aa16f389f3004509aa5bce5571acd6029c.xlsx Wine Depot, Inc. Ratio Analysis December 2009 Profitability Return on owners' investment Return on total investment Profit margin Gross margin Liquidity Current ratio Quick ratio Receivable turnover Inventory turnover Solvency Debttoequity Liability 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, 2009as well as a horizontal analysis of both the income statement and balance sheetin 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. a. Print each completed worksheet in Value view, with landscape orientation, scaling to fit to 1 page wide by 1 page tall, and with your name and date printed in the lower left footer and the file name in the lower right footer. Use Excel's help feature to move charts on your worksheet so that they print on a separate page. b. Print each completed worksheet in Formula view, with gridlines and row and column headings, landscape orientation, scaling to fit to 1 page wide by 1 page tall, and with your name and date printed in the lower left footer and the file name in the lower right footer

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: James Jiambalvo

3rd Edition

0470038152, 978-0470038154

More Books

Students also viewed these Accounting questions

Question

3. What is my goal?

Answered: 1 week ago

Question

2. I try to be as logical as possible

Answered: 1 week ago