304 Quiz 2

# 304 Quiz 2 - This Quiz has 2 parts. The first is to...

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

The second part is to work up 3 pivot tables based on the instructions on the Pivot table problem worksheet, usin the data from the Pivot table data worksheet. Be sure to format and label, as well as make it as professional and presentable as possible. Please turn in one workbook containing the 4 solutions to the digital drop box. This Quiz has 2 parts. The first is to complete a data table using the information provided on the next worksheet.

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

View Full Document
g t.
QUIZ 2 Loan amount \$20,000.00 Loan term 24 (number of months) Annual Percentage Rate 6% Monthly payment \$941.47 (prototype formula) Interest Rates: 5%, 6%, 8%, 10%, 12% Loan Terms (in months): 24, 30, 36, 42, 48, 60, 72 Rates \$941.47 5% 6% 8% 10% 12% 24 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 30 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 Months 36 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 42 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 48 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 60 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 72 \$941.47 \$941.47 \$941.47 \$941.47 \$941.47 You want to purchase a \$20,000 vehicle. You have no down payment. The loan term is 24 months and the Annual Percentage Rate is 6%. Based on this, your monthly payment is \$886.41, which is far too high. If you were able to manipulate the interest rate and the loan term, what payment options would you have? (NOTE: Assume ordinary annuity) What are the payments on \$20,000 over various interest rates and time periods? Using the information in the tables above, set up a data table displaying your payment options with the given interest rates and loan terms.

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

View Full Document
Create pivot tables to do the following: Part One Part Two Part Three Your manager wants to investigate ordering information for the North sales region for May, 2003. Specifically she wants to know the total number of orders (count of Order Size) for each product for each sales person. Your manager wants to investigate shipment information for the Mace product in the 3rd Quarter of 2003. Specifically she wants to know the total number of units shipped (Shipment size) to each sales region from each plant. Be sure to name fields approprately. Your manager wants to investigate shipment information for the West sales region during March of 2004. Specifically she wants to know the total number of units of each product that were shipped (shipment size) by each plant. Be sure to name fields appropriately. Create a Pivot Chart, and make sure to label!!!
Years2 2003 Order Date May Sales Region North Count of Order Size Sales Person Product Brown Lopez Miller Smith Grand Total Ace 1 1 2 Mace 1 1 2 Tace 1 1 Grand Total 1 2 1 1 5

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

View Full Document
Shipment Date (All) Product Mace Sum of Shipment Size Sales Region Plant East North South West Cleveland 561 496 385 386 Miami 382 373 723 Seattle 400 887 217 608 Grand Total 961 1765 975 1717
Grand Total 1828 1478 2112 5418

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

View Full Document
Years 2004 Shipment Date Mar Sales Region West Sum of Shipment Size Product Plant Ace Mace Pace Tace Grand Total Miami 108 146 136 108 498 Seattle 132 132 Grand Total 240 146 136 108 630
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 / 22

304 Quiz 2 - This Quiz has 2 parts. The first is to...

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

View Full Document
Ask a homework question - tutors are online