Homework 4 Excel File

Homework 4 Excel File - Sales Tax: Magic Price: Highest...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Name: Your Name Recitation Section: UB Person Number: Uncle Tom's Auto Sales Date: Selling Price Sale # Car Type Trade In Cash Total Paid 99995 Odyssey $30,270 $5,000 $7,001 8.0% 99996 Taurus $14,670 $2,501 7.0% 99997 Cougar $18,160 $3,000 $16,749 99998 Accord $22,700 $10,000 $0 6.5% 99999 Caravan $19,850 $4,900 $16,687 100000 Excalibur $1,001 8.0% 100001 Sonata $16,450 $17,889 100002 Camry $21,460 $5,600 $1,000 6.5% 100003 Pinder $289,995 $70,000 $150,000 7.5% 100004 Escort $45,870 $5,500 $30,000 7.0% Car Statistics Total Number of Cars Sold
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sales Tax: Magic Price: Highest Price 8.75% Lowest Price Average Interest Rate Percentage of Cars Financed Total Sales: My Commissions: Commission Rate: 1.5% My Bonus: Bonus Sales Level: $550,000 Bonus Payment: $5,000 B 4: A 1 A 2 A 3 A 4 A 5 F 5: A 6 A 7 A 8 A 9 A 10 F 7: ID Code B-44751--123456789-FB F 10: Price (incl. tax) Amount to be Financed Annual Interest Rate Payment each Month...
View Full Document

Ask a homework question - tutors are online