{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch10qz02a

# ch10qz02a - c Enter a formula in Cell B24 to calculate the...

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

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 10 - Quiz 02 Loan Amount \$35,500.00 Interest Rate 11% Down Payment Percent 10% Years for Loan 5 Amount Financed \$31,950.00 Finance Charge \$17,572.50 Monthly Payment \$825.38 Directions: a. Enter a formula in Cell B8 to calculate the Amount Financed. b. Enter a formula in Cell B9 to calculate the Finance Charge. c. Enter a formula in Cell B10 to calculate the Monthly Payment. d. Format dollar amounts for Currency, 2 decimal places, and \$. Number of Payments 60 Payments Remaining 30 Sum of Digits Payments Remaining 465 Sum of Digits Total Payments 1830 Finance Charge Rebate \$4,465.14 Balance Remaining \$24,761.25 Loan Payoff \$20,296.11 Directions: a. Enter a formula in Cell B22 to calculate the Sum of Digits Payments Remaining. b. Enter a formula in Cell B23 to calculate the Sum of Digits Total Payments.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: c. Enter a formula in Cell B24 to calculate the Finance Charge Rebate. d. Enter a formula in Cell B25 to compute the Balance Remaining. e. Enter a formula in Cell B26 to find the Loan Payoff. f. Format dollar amounts for Currency, 2 Decimal places, and \$. A. You financed a 5-year loan for \$35,500 and were charged 11% interest with a 10% down payment. Calculate the amount financed, the finance charge, and the monthly payment. B. You have decided to pay off the loan after 30 months. You want to know the amount of finance charge rebate. Calculate the finance charge rebate, the balance remaining, and the loan payoff. g. Save the file as ch10qz02a.xls. A B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online