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 6year loan for $55,000 and were charged 8.5% interest with a 15% 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 ch10test02a.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
 Winter '10
 Munoz
 Business, Debt, Interest, Finance charge, Payment, Credit card

Click to edit the document details