Copy of 304 Quiz 1

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

This preview shows pages 1–3. 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
k for professionalism and appearance.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern