This preview shows page 1. Sign up to view the full content.
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 5year 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
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.
 Winter '10
 Munoz
 Business, Interest

Click to edit the document details