A student looking at a student loan of a size of $10,000, an interest rate of 9%, and a monthly payment of $127 makes the following observation:  The text states that the interest rate on the loan is 9%, but this calculation is obviously wrong. Each monthly payment is $127, so the student will be paying back $127×12 = $1, 524 per year. Therefore, because the principal of the loan is $10,000, the interest rate must be $1,524 = 0.1524, or 15.24%. Briefly explain whether you agree with the student’s reasoning.

Can you please explain me how to solve this in excel

Your credit score is in the range of 720-739 and you want to buy a house in Davis (CA). You have 20% down payment to put on a house that has a market value of $450,000. a) Use www.bankrate.com website to identify the bank with the most convenient APR for your 30- year fixed mortgage and accordingly calculate your annual payment. Ignore external and additional costs in your calculation that may vary from one bank to another b) After 20 years of annual payment, how much you should pay in lump sum to your bank to end up all your debts. Ignore penalties or any other additional cost c) According to your finance, your maximum annual payment for your mortgage cannot exceed $24,000. Under this condition, how much should be your minimum down payment for your mortgage?

You ran a little short on your spring break vacation, so you put $1,000 on your other credit card. You can afford only the minimum payment of $60 per quarter. The interest rate on the credit card is 18 per year compounded quarterly. How many years will you need to pay off the $1,000? I want to solve this problem using the financial calculator so if your able to show me what to punch in that would be great