ch09qz01a - Name_ BUSINESS MATH USING EXCEL Date_ A 1 B C D...

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

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 09 - Quiz 01 A. Calculate simple, ordinary, and exact interest. Simple Ordinary Exact Principal $5,700.00 $5,700.00 $5,700.00 Loan Date 1/15/2003 1/15/2003 1/15/2003 Rate 12.3% 12.3% 12.3% Time 24 120 90 months days days Interest $1,402.20 $233.70 $172.87 Maturity Value $7,102.20 $5,933.70 $5,872.87 Due Date 1/15/2005 5/15/2003 4/15/2003 Directions: d. In Cells B12 through D12, enter formulas to compute the Maturity Value. e. In Cell B13, enter the Due Date of 1/15/05 (1/15/03 plus 24 months). f. In Cells C13 and D13, compute the Due Date. Face Value $9,000 Rate 12% Time in Days 180 Maturity Value $9,517.50 Date of Note 6/15/2003 Maturity Date 12/12/2003 Days Before Discount 60 Discount Date 8/14/2003 Discount Rate 12% Days Remaining 120 Bank Discount $380.70 Bank Proceeds $9,136.80 Directions: a. In Cell D30, enter a formula to calculate the Maturity Value. b.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/19/2012 for the course BUS bus 130 taught by Professor Munoz during the Winter '10 term at Everett CC.

Ask a homework question - tutors are online