You want to buy a new sports coupe for $74,900, and the finance office at the dealership has quoted you a loan with an APR of 7.3 percent for 36 months to buy the car. a. What will your monthly payments be? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the effective annual rate on this loan? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Q: Suppose that you decide to buy a car for $26,635, including taxes and license fees. You saved $7000…

A: Car Value = $ 26,635Down payment =$ 7000Loan Amount = Car Value - Down paymentLoan Amount = $ 26,635…

Q: You are selling your car and the dealership says to you, "we can either give you $15,000 today or we…

A: Solution:- When an amount is borrowed, it can either be repaid as a lump sum payment or in…

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: You purchase a basic package, 4-door sedan for your company's fleet for $18,000. The 3 year loan has…

A: Assumption: It is assumed the given situation is in monthly compounding. The question gives the…

Q: I need assistance to solve this problem: On September 1, 2018, you bought a car for $23,000. You…

A: Calculation of payoff the loan on November 1, 2020:First it is required to calculate the total…

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: You have just purchased a new warehouse. To finance the purchase, you've arranged for a 30-year…

A:

Q: site, find another.) Type in a home price of $300,000. Leaving all other entries as they are, enter…

A: the monthly mortgage payments for the three interest rates using the formula for monthly mortgage…

Q: Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments…

A: Loan is amount borrowed by some investor or company from the stock market or taken by individual…

Q: You want to buy a $177,500 home. You plan to pay 30% as a down payment, and take out a 30-year loan…

A: Closing cost is the cost which has to be paid by either seller or the buyer to the government when…

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: You have just purchased a new warehouse. To finance the purchase, you've arranged for a 37-year…

A: When the lender lends a loan to the borrower, he charges a rate of interest on the borrowed amount.…

Q: Suppose that you decide to buy a car for $27,635, including taxes and license fees. You saved $8000…

A: Autoloans are now common because they are paid in equal monthly installments and these monthly…

Q: You want to buy a $230,500 home. You plan to pay 20% as a down payment, and take ou 5% for the rest.…

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

Q: Using the information provided please show all work and formulas in excel ! Suppose that you have…

A: Incremental borrowing cost refers to an expense that is incurred for taking an extra amount of loan…

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: You want to buy a new sports coupe for $64,987, and the finance office at the dealership has quoted…

A: Amortization is the systematic repayment of loan and interest for a decided period of time. Each…

Q: Suppose that you decide to buy a car for $27,635, including taxes and license fees. You saved $7000…

A: Amortization of a loan refers to the process of gradually paying off a debt or loan over a fixed…

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

A: Step 1: The calculation of the APR and the EAR AB1Purchase price $ 3,390,000.00 2Mortgage amount $…

Q: For the car loan described, give the following information. A car dealer will sell you a used car…

A: Loan is a contract between lender and borrower where lender provide funds to borrower for finite…

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: The bank officer is convincing a customer who is looking for a car loan. Compute the price the bank…

A: Ordinary annuity are the payments which are made at the end of a period.

Q: You want to buy a new sports coupe for $75,200, and the finance office at the dealership has quoted…

A: Loan is a financial obligation that is repayable in the future. A loan is repayable according to the…

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: Use Excel to answer this question: You want to borrow money from your bank to purchase a car. The…

A: Amount you can borrow = Present value of the maximum monthly paymentsNOTE :here the monthly payment…

Q: A car manufacturer is offering the choice of a 0.5% loan compounded monthly for 72 months or $2000…

A: The sum borrowed or loan taken to meet the specific business or personal requirements is regarded as…

Q: You want to buy a new sports coupe for $30,000, and the finance office at the dealership has quoted…

A: in monthly payment, borrower pay the both interest and loan payment each month.  after end of the 60…

Q: You want to buy a new sports coupe for $77,500, and the finance office at the dealership has quoted…

A: Compound = n = Monthly = 12Present Value = pv = $77,500Interest rate = r = 5.9 / 12Time = t = 48

Q: 1) You are planning on buying a car and see that Toyota is advertising a promotional borrowing rate…

A: Cost of car = $24625Upfront cost if financed = $2000Time to pay the remaining amount = 2…

Q: The present value price of a car you would like to purchase today is $17,990. . You are approved…

A: Ordinary annuity are the payments which are made at the end of the period.

Q: Suppose that you borrow $17,000 for three years at 8% toward the purchase of a car. Use PMT= The…

A: When the borrower borrows a loan from the lender, he has to pay a rate of interest on the borrowed…

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

A: Monthly loan payment can be calculated by using excel function of PMT-Excel function of PMT…

Q: You want to buy a car and have negotiated a sale price of $50,000. You can get a loan from your…

A: Present value = pv = $50,000 Compound = monthly = 12 interest rate = r = 6 / 12 = 0.5% Time = t = 6…

Q: The formula below finds the monthly payment for a loan (car, mortgage, student): P=I (r/1-(1+r)-n )…

A: The finance of the loan is dependent on certain factors like, loan amount, rate of loan, compounding…

Q: You want to buy a new sports coupe for $90,500, and the finance office at the dealership has quoted…

A: A.) To calculate monthly payment we will use PMT function in excel. Just simply type =PMT in any…

Q: You wish to buy a house. The market value of the house is $650,000 and you have saved $120,000 as a…

A: Interest Rate = 6.5% Time Period = 26 Years Market Value = $650,000 Down Payment = $120,000

Q: You wish to buy a car at a cost of $45,000. Ford Credit will finance the car at 3.9%/year over 48…

A: The two proposals can be made indifferent if their present worth will be same after offering the…

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.