{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch09qz01a

# ch09qz01a - Name BUSINESS MATH USING EXCEL Date A 1 B C D...

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

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.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Ask a homework question - tutors are online