A Navy pilot has a 25-year mortgage at an annual interest rate of 4.625 %. After making payments of $2, 392.54 for 4 years, the pilot would like to pay off the loan so as to purchase a new home. Calculate the loan payoff (in dollars). The answer is not 405, 126.98

Please help me with parts a and b THANK YOUUUUU!

Hazel has taken out a 40,000 loan that requires quarterly payments of $2300 over over five years. What is the APR for this loan how do I answer this using the TVM function

You are assiting a newly hired employee. You begin explaning the process of utilizing excel to finance properties. Consider the following. A realator has a house on sale for $640,000. If possible you  believe you can finance the home for $300,000 for 20 years at a 3% interest rate. What would the monthly principle and interest payment be for the acquird loan? Calculate using the PV funtion in excel. How would you caluclate this in Excel using the PV function? Rate: Nper: Pmt: FV: Type:

Explain well with proper answer. And type the answer.

You purchase a house and obtain a 30-year loan of $198,000 at an annual interest rate of 8.30%. (Round your answers to the nearest cent.) (a) What is the mortgage payment?$ (b) What is the total of the payments over the life of the loan?$ (c) Find the amount of interest paid on the mortgage loan over the 30 years.$

Can someone help? Really appreciate it!

You consider financing the purchase of a new $159,900 sports car from a local luxury car dealership. The loan specifications establish a three-year term and a 9.2 percent APR. The buyer is required to make monthly payments starting immediately after approval. What is the expected payment of this loan?

After starting your full-time job out of college, you decide to buy a new car for $85,000. Create a complete amortization table in excel for this car loan: You make 84 equal end-of-month payments. The discount rate is 6.5 percent compounded quarterly. How much would you owe after the 75 th payment? Please show both regualr and formula format of the spreadsheet.

You want to borrow $59,000 from your local bank to buy a new sailboat. You can afford to make monthly payments of $1,100 but no more. Assuming monthly compounding, what is the hughest rate you can afford on a 66- Training month APR loan? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places