Suppose Mary Grace needs to borrow $8,900 for the purchase of a car and is considering two loan options. Loan A is a four-year loan at 7.6% interest while loan B is a seven-year loan at 7.9% interest. Determine the monthly payment required to repay Loan A and the total interest paid over the life of Loan A. Round solutions to the nearest cent, if necessary. The monthly payment for Loan A is $ . The total interest paid for Loan A is $ . Determine the monthly payment required to repay Loan B and the total interest paid over the life of Loan B. Round solutions to the nearest cent, if necessary. The monthly payment for Loan B is $ . The total interest paid for Loan B is $ . Determine the lower-cost option of the two loans. Loan A is the lower-cost option. Loan B is the lower cost option. Determine the amount of savings Mary Grace will experience if she chooses the lower-cost loan option. Savings = $

Q: Example: In this exercise prepare an amortization schedule showing the payments for each loan. Joan…

A: PV = $20,000r = 7% / 2 = 0.07 / 2 = 0.035 (semiannual interest rate)n = 5 years * 2 = 10 payments

Q: a. Calculate the amount of interest and, separately, principal paid on each mortgage. What is the…

A:

Q: You need to borrow $12,000 to buy a car, so you visit two banks and are given two alternatives. The…

A: Loan is a contract between lender and borrower where lender provide funds to borrower which repaid…

Q: Kim is shopping for a car. She will finance $12,000 through a lender. The table to the right shows…

A: A loan refers to a contract where money is borrowed by one party on the promise of future repayment…

Q: a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the…

A: Amortization Schedule: It is a table containing details about each periodic payment. It includes…

Q: An individual wishes to borrow $10,000 for a year and is offered the following alternatives: a. A 10…

A: Calculating the effective interest rate on borrowing option 10% loan discounted in advances. We…

Q: Suppose you borrow $21,000 from your bank to buy a car.  You agree to pay $433.89 per month for 60…

A: As per the time value of money, a dollar is worth more today than the same dollar in the future.…

Q: You plan to purchase a $390,000 house using either a 30-year mortgage obtained from your local…

A: The question is based on the concept of Financial Management.

Q: You want to buy a car, and a local bank will lend you $25,000. The loan will be fully amortized over…

A: Monthly Loan Payment = PV*(r*(1+r)n)((1+r)n-1)  where: PV is the present value of the loan r is the…

Q: The Nguyens are thinking of buying a home for $121,000. A potential lender advertises an 80%,…

A:

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 plan to purchase a $350,000 house using a 15-year mortgage obtained from your bank. The mortgage…

A: Here, Purchase Price $ 350,000.00Time Period in years15Interest Rate5.50%% of Down Payment20%

Q: Erika is weighing her options for transportation.  She’s narrowed them down to the following: Option…

A: Therefore, the monthly payment for option A is $314.71.

Q: You want to buy a car, and a local bank will lend you $10,000. The loan will be fully amortized over…

A: Given: Loan Amount $10,000Annual Nominal Interest Rate 9%Number of Payments = 5 years * 12 months60…

Q: suppose that you decide to borrow $15,000 for a new car. you can select one of the following loans,…

A: a.Loan ALoan Amount (pv) = $15,000Interest Rate (rate) = 5.9%Time Period = 3 YearsNumber of Payments…

Q: are buying a house and will borrow $197,000 on a 25-year fixed rate mortgage with monthly payments…

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

Q: You need $19,000 to purchase a used car. Your wealthy uncle is willing to lend you the money as an…

A: Using Excel formula PMT to find  the annual loan payments

Q: You purchase a house and obtain a 30-year loan of $198,000 at an annual interest rate of 8.30%.…

A:

Q: Barbie is going to borrow $5,000 to help write a book.  The loan is for one year and the money can…

A: Option 1: 1 year loan borrowed at prime rate = 11%Effective interest cost = 11%Option 2: 1 year loan…

Q: A home purchaser need to borrow $500,000 to finance their new home. The buyer believes they will…

A: A borrower can acquire a sort of prepaid interest or fees known as a mortgage point, often referred…

Q: a. What is your annual payment on the loan? b. Construct a mortgage amortization. c. What fraction…

A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…

Q: You want to buy a car, and a local bank will lend you $35,000. The loan will be fully amortized over…

A: An effective annual rate (EAR) is the actual rate of interest to be paid annually after taking…

Q: A man plans to take a vacation in 5 years. He wants to buy a certificate of deposit for $1300 that…

A: To calculate the simple interest rate we will use the below formula   Interest rate = [(A-P)/P]/T…

Q: You plan to purchase a $320,000 house using a 15-year mortgage obtained from your bank. The mortgage…

A: The long-term loan that is taken by an individual person or an organization for the purchase of a…

Q: ou are taking a car loan of 100000, for 5 years and monthly payment of 1648, the interest rate is…

A: Loan is the present value of payment made for the loan based on the time and interest rate of the…

Q: You plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit…

A: We need to use PMT function in excel to calculate monthly payment to pay off mortgage loan.The…

Q: Suppose that you and your friend both need to borrow the same amount of money. You borrow money…

A: In compounding there is interest on interest also including the principal amount and due to which…

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: Suppose you have the following three student loans: $11,000 with an APR of 8.5% for 12 years,…

A: Here,First LoanSecond LoanThird LoanLoan Amount $  11,000.00 $  17,000.00 $…

Q: You plan to purchase a $200,000 house using either a 30-year mortgage obtained from your local…

A: Let us dissect the computations and provide a more comprehensive explanation. a. Interest and…

Q: You want to buy a car, and a local bank will lend you $25,000. The loan will be fully amortized over…

A: Compound = n = Monthly = 12Present Value = pv = $25,000Time = t = 5 * 12 = 60Interest Rate = r = 9 /…

Q: You are considering an option to purchase or rent a single residential property. You can rent it for…

A: a. To determine if buying the property or renting it for a four-year period of ownership would…

Q: Please show how to solve this in excel and please show the spreadsheet and formulas. Suppose that…

A: Loans are paid by equal monthly payments that carry the payment for interest and payment for loan…

Q: You plan to purchase a $310,000 house using a 15-year mortgage obtained from your bank. The mortgage…

A: MS-Excel --> Formulas --> Financials --> PMT

Q: You plan to purchase a $200,000 house using either a 30-year mortgage obtained from your local…

A: Let us dissect the computations and provide a more comprehensive explanation. a. Principal and…

Q: A borrower is purchasing a property for $200,000 and can choose between two possible loan…

A: Present value of annuity Annuity is a series of equal periodic payments at equal interval over a…

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.