Question

In: Economics

You want to buy a new car for $25,000. You put $2000 down and are given...

You want to buy a new car for $25,000. You put $2000 down and are given $2000 as trade-in for your current car. You take out a loan for the remaining $21,000. The terms of the loan are an annual interest rate of 4.8% compounded monthly. You are to make 60 equal monthly payments (end of month) to pay off the loan.

how can i get the answer using excel

Solutions

Expert Solution

The amount of monthly payment on the loan can be calculated using the PMT function in excel.

In excel go to formulas, choose financial and select PMT function, the following window opens.

The monthly payment on the car loan = $ 394.37


Related Solutions

You are buying a car for $25,000. You will put no money down and get a...
You are buying a car for $25,000. You will put no money down and get a loan for the full purchase price. The bank offers you the following loan terms: APR 8% (Annual percentage rate), 3 year loan with quarterly payments. Create an amortization schedule paying off the loan.
You want to buy a car, and a local bank will lend you $25,000.The loan...
You want to buy a car, and a local bank will lend you $25,000. The loan will be fully amortized over 5 years (60 months), and the nominal interest rate will be 5% with interest paid monthly. What will be the monthly loan payment? What will be the loan's EAR? Do not round intermediate calculations. Round your answer for the monthly loan payment to the nearest cent and for EAR to two decimal places.Monthly loan payment: $EAR: %Find the following...
8. You want to buy a car, and a local bank will lend you $25,000. The...
8. You want to buy a car, and a local bank will lend you $25,000. The loan will be fully amortized over 5 years (60 months), and the nominal interest rate will be 11% with interest paid monthly. What will be the monthly loan payment? What will be the loan's EAR? Do not round intermediate calculations. Round your answer for the monthly loan payment to the nearest cent and for EAR to two decimal places. Monthly loan payment: $   EAR:   %...
You want to buy a new car that costs $25,000. How much would your monthly payments...
You want to buy a new car that costs $25,000. How much would your monthly payments be if you borrow the money for 5 years from a credit union at 4% annually (remember you make monthly payments so you have to get the term of the loan and the interest rate from annual periods to months)? PV = FV = I = N = Pmt = Answer: ________
You want a bank loan in order to buy a car (with no down payment of...
You want a bank loan in order to buy a car (with no down payment of your own). You already own a house on which you pay $1,600 per month in mortgage payments, $300 per month in property taxes and $100 per month in utilities. Your gross family income is $80,000 per year. You have no other debts. The bank is willing to give you a loan which will be amortized over 5 years (i.e., 60 monthly payments). The interest...
It is time to buy a new car. You worked hard and want to buy an...
It is time to buy a new car. You worked hard and want to buy an expensive car (Porsche Cayenne) for $100,000. Porsche dealership will gladly finance your new purchase. However, the only way for you to be financed is to show them that you have 20% of the money needed. As soon as you have that much money in your account, the dealership will finance your new vehicle. You start saving for 52 months with the APR of 7.5%,...
You will put $1200 down on a car and want a 4 year loan. You could...
You will put $1200 down on a car and want a 4 year loan. You could buy a new car for $15,000 (interest rate 6%) or the same model car that is 2 years old for $11,500 (interest rate 6.5%). The new car has a monthly payment of $305.31 and the used car has a monthly payment of $244.26. Explain what you would pick and why.
You want to buy a car valued at $48,000. You will make an upfront down-payment of...
You want to buy a car valued at $48,000. You will make an upfront down-payment of $5,000 on the car, and borrow the rest of the money from your bank. Your bank will give you a 5-year loan at 2.5% APR compounded semi-annually. You plan to make biweekly payments (i.e., one payment every two weeks) on the loan. The bank requires that you make the first payment two weeks after you signed the loan contract. Find the answer to the...
You would like to buy a new car that costs $25,000. The dealer offers you a...
You would like to buy a new car that costs $25,000. The dealer offers you a 3-year loan at an 8% interest rate, and because that rate is higher than market rates they offer to lower the price by $2,000. Assuming you make the required payment, should you accept his offer or seek alternative financing at the 3% rate?
You want to buy a house that worth $250,000. You put done $60,000 down payment and...
You want to buy a house that worth $250,000. You put done $60,000 down payment and borrow the rest from a bank with interest rate 4.5% per year compounded monthly for 15 years. What is you monthly payment to the bank? How much interest you will pay to the bank in 15 years? How much interest you pay in the FIRST year?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT