Copy of 304 Quiz 1

# Copy of 304 Quiz 1 - Quiz 1 Tasks A. For the Quiz 1 sheet...

This preview shows pages 1–4. Sign up to view the full content.

Quiz 1 Tasks A. For the Quiz 1 sheet tab, complete the following 2. Compute the total revenue for the company for each year using the sum() function 5. Compute the average revenue for all divisions for each year. 6. Using a new worksheet, Create a formula sheet of your work. Note: Remember to use absolute and relative cell referencing where appropriate and format all work B. Use Research Insight to get me the following 1. Create a report that shows the 5yr annual balance sheet with footnotes for Target Corp. Be sure to import that to excel, with labels and values, and save inside a single workbook with part A. 1. Project revenue growth for each division through 2013 using the revenue growth assumption Make sure you set up the calculations so that it is easy to experiment with different growth rate 3. Project COGS growth for the company through 2013 using the COGS growth assumption an Make sure you set up the calculations so that it is easy to experiment with different growth rate 4. Compute dollars of gross margin, where gross margin (\$) = revenue - COGS

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

View Full Document
rk for professionalism and appearance. . Submit via digital dropbox, but save a copy just in case!!! n and the 2006 revenue figures. es. nd the 2006 COGS. es.
QUIZ 1 Growth Assumptions: Section: Finan 304 - 001 Annual % Increases Revenue 3.5% COGS 2.5% Division 2007 2008 2009 2010 2011 2012 2013 West Coast \$500.00 \$517.50 \$535.61 \$554.36 \$573.76 \$593.84 \$614.63 \$636.14 Midwest \$2,000.00 \$2,070.00 \$2,142.45 \$2,217.44 \$2,295.05 \$2,375.37 \$2,458.51 \$2,544.56 Southwest \$12,000.00

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 04/12/2011 for the course FIN 304 taught by Professor Doug during the Spring '11 term at Boise State.

### Page1 / 7

Copy of 304 Quiz 1 - Quiz 1 Tasks A. For the Quiz 1 sheet...

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

View Full Document
Ask a homework question - tutors are online