SA7Frances Drew ib_e04_groupproject

SA7Frances Drew ib_e04_groupproject - 2 3 4 Look at the...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Company Name CoF Company F $9.89 CoD Company D $57.60 CoB Company B $42.50 CoC Company C $23.18 CoA Company A $78.60 CoE Company E $32.50 Stock Symbol Current Stock Price
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Historical Data for Company D 2000 2001 2003 2004 2005 Gross Sales $15,000,000 $25,000,000 $40,000,000 $38,500,000 $52,000,000 Returns $200,000 $325,000 $500,000 $425,000 $550,000 Net Sales $14,800,000 $24,675,000 $39,500,000 $38,075,000 $51,450,000 Cost of Goods Sold $10,360,000 $17,272,500 $27,650,000 $26,652,500 $36,015,000 Gross Profit $4,440,000 $7,402,500 $11,850,000 $11,422,500 $15,435,000 Expenses $4,125,000 $6,950,000 $10,250,000 $10,450,000 $12,500,000 Net Income $315,000 $452,500 $1,600,000 $972,500 $2,935,000
Background image of page 2
Analysis of Company D HISTORICAL DATA Year: 2005 (Data exists for the year 2000 through 2005) Net Sales $550,000 Gross Profit $36,015,000 Net Income $12,500,000 STOCK COMPARISON Stock Symbol Coe Company Name Company E Current Price $32.50 $57.60 Current Price for Company D
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Questions 1
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2 3 4 Look at the data on the Company D Analysis worksheet. Does the data appear to make any sense? Test drive the spread sheet. When you change the year and stock symbol, does the data still make sense? What method is your teammate using to show the data in cells C4:C6 and C10:C11? Do these methods appear to be entered correctly? How many worksheets does this workbook contain? What will you need to do to check the accuracy of the data appearing in the company D analysis worksheet? Solutions yes you can see where the information on histrical data is located and also where the comparisi o the symbols do not match with the company names. Changed the vlookup from absolute to a norm a hlookup for the first and vlookup for the second. They seem to be used correctly not including blank pages and answers 3 sheets. You need to unhid the stock info and historica l...
View Full Document

Page1 / 5

SA7Frances Drew ib_e04_groupproject - 2 3 4 Look at the...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online