You are ready to buy a house and you have $75,000 for a down payment and closing costs. Closing costs are estimated to be 4.5% of the loan value. You have an annual salary of $115,000. The bank is willing to allow your monthly mortgage payment to be equal to 25% of your monthly income. The annual percentage rate on the loan is 6.5% per year with monthly compounding for a 15-year fixed rate loan. Create a loan amortization table in Excel for the original problem (6.5%). Show formulas.

Q: You owe $19,000 on student loans at an interest rate of 4.6% compounded monthly. You want to pay off…

A: The amount of loan "PV" is $19,000 The interest rate is 4.6% Compounded monthly The time period is 6…

Q: You want to buy a house valued at $200,000.  AFter a down payment, you can finance the house with a…

A: The annual percentage rate is the rate earned on the investment or paid on loan over the period of…

Q: You receive a 10-year subsidized student loan of $22,000 at an annual interest rate of 4.3%. What…

A: Using excel PMT function to calculate monthly payment.

Q: You are looking to purchase a Tesla Model X sport utility vehicle. The price of the vehicle is…

A: Balloon payment is the final payment made at the end of loan to close and settle the loan and close…

Q: The price of a home is $600,000. The bank requires a 20% down payment. The cost of the home is…

A: compound = monthly = 12 Price of home = $600,000 Down payment = 20% Time = t = 30 * 12 = 360…

Q: What is the payoff amount for the loan?

A: Present value illustrates the current value of a sum of money that will be received or paid in the…

Q: You are ready to buy a house, and you have $30,000 for a down payment and closing costs. Closing…

A: Mortgage loans are paid by equal and fixed monthly payment that carry the payment of interest and…

Q: You purchase a home for $434,000 by making a down payment of 15% and financing the remaining amount…

A: First we need to use loan amortgage formula below to calculate monthly payment.  where P=Loann…

Q: Suppose you wish to purchase heavy equipment machinery and a commercial bank will lend you $65,000…

A: Amount lent = $65,000 Loan period = 5 years* 12 = 60 Nominal interest rate = 8%/12 = 0.6667%

Q: Big Dom's Pawn Shop charges an interest rate of 20 percent per month on loans to its customers. Like…

A: When we take a loan from banks they charge us interest on that loan. Similarly when we borrow money…

Q: You borrow $6,275 from your friend at a nominal interest annual rate of 11.35% compounded weekly.…

A: Loan = 6275 Interest = 11.35℅ Weekly Compounding Number of compounding periods = 52 Annual Repayment…

Q: You are looking to purchase a Tesla Model X sport utility vehicle. The price of the vehicle is $94,…

A: To find the balloon payment for the Tesla Model X SUV:- Calculate the monthly interest rate using…

Q: You are negotiating to buy a new car with a car salesman at a local dealer. You have negotiated the…

A: Loans are paid by monthly payments and these monthly payments carry the payment for interest and…

Q: You need a 15-year, fixed - rate mortgage to buy a new home for $230,000. Your mortgage bank will…

A: A balloon payment is a significant, lump-sum amount due at the conclusion of a loan term, following…

Q: You need a 25-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank will lend…

A: The lum sump that has to be paid at the end of the mortgage period for settling the loan at given…

Q: You are looking to buy a $415,000.00 home in Haverhill. If Bank of America will give them a 15-year…

A: 1)  Loan Amount = 80% of 415,000 = $332,000.

Q: You are looking to purchase a Tesla Model X sport utility vehicle. The price of the vehicle is…

A:

Q: You are a loan officer trying to structure a 5/25 ARM mortgage. The interest rate in the first 5…

A: A mortgage refers to a loan used for the purchase of real estate. The loan is covered by the real…

Q: A house is being purchased for $138,000.00. The 30-year mortgage has a 10% down payment, an interest…

A: The cost of financing the house will include the total cost of interest for the period of loan is…

Q: ou want to borrow $27,000 from your local bank to buy a new car. you can afford to make monthly…

A: The given problem can be solved using RATE function in excel. RATE function computes interest rate…

Q: have an outstanding student loan with required payments of 550 per month for the next four years.…

A:

Q: You want to borrow $77,000 from your local bank to buy a new sailboat. You can afford to make…

A: Compound = Monthly = 12Present Value = pv = $77,000Monthly Payment = p = $1300Time = t = 78

Q: You have an outstanding student loan with required payments of $600 per month for the next 4 years.…

A: Loans are paid in equal monthly payments and these monthly payments carry interest and loan…

Q: You currently owe $118,580.44 on your mortgage loan, with an interest rate of 6.8%. Interest rates…

A: A loan is a financial arrangement in which one or more people, companies, or other entities lend…

Q: You purchase a home for $438,000 by making a down payment of 15% and financing the remaining amount…

A: Monthly payment refers to the amount that is being paid every month either in the beginning or end…

Q: The price of a condominium is $127,000. The bank requires a​ 5% down payment and one point at the…

A: Required down payment = $127,000 * 5% = $6350 Amount of Mortgage = $127000 * 95% = $120650 One point…

Q: Suppose you are getting a loan from a bank to purchase a feed business. The interest rate on the…

A: The objective of the question is to calculate the annual payment for a loan of $1,000,000 at an…

Q: You have just purchased a new warehouse. To finance the purchase, you've arranged for a 30-year…

A: mortgage value = n = 30 x 12 = 360

Loans

A loan is a term that we are all familiar with. The processing of loans is one of the most important functions of a bank. It keeps our economy stable and facilitates the implementation of monetary policies. Let's take a look at the different forms of loans and get some answers to some common questions.