Reference no: EM13922364
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.
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.
|
Absorption costing pre-tax income statement
: Prepare an absorption (traditional) costing pre-tax income statement for Trace for the year 2010.
|
|
Highlights various techniques used in persuasive messaging
: Table in your textbook highlights various techniques used in persuasive messaging, including foot-in-the door, low-ball, door-in-the face, reciprocity, etc. After examining all the techniques, choose three to address in your discussion. For each ..
|
|
Calculate the financial ratios for the assigned company
: Calculate the financial ratios for the assigned company's financial statements, and then interpret those results against company historical data as well as industry benchmarks:
|
|
Margaret died on september
: Margaret died on September 16, 2015, when she owned securities with a basis of $50,000 and a FMV of $60,000. Caroline inherited the property and sold it on December 19, 2015 for $67,000. What is Caroline's reported gain on this sale? a.) $17,000 LTCL..
|
|
Create a vertical analysis of the balance sheet
: 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..
|
|
Reduced material waste
: This machine would replace six welders at a cost savings of $120,000 per year. And we would save another $8,100 per year in reduced material waste. When you figure that the automated welder would last for six years, I'm sure the return would be great..
|
|
Halifax manufacturing allows its customers
: Halifax Manufacturing allows its customers to return merchandise for any reason up to 90 days after delivery and receive a credit to their accounts. All of Halifax's sales are for credit (no cash is collected at the time of sale). The company began 2..
|
|
Maximize the companies profitability
: In order to maximize the company's profitability, prepare an analysis that will show which product or products Sportway Corporation should manufacture or purchase.
|
|
Power of love and relationship
: Describe the factors of attraction. What attracts us to one another? Why are we less likely to befriend someone from another culture than someone from a similar background with a similar physical aesthetic? Be sure to identify and describe all (6)..
|