You bought a new car today that cost you $40,000. You paid$2,000 DOWN and financed...

You bought a new car today that cost you $40,000. You paid $2,000 DOWN and financed the balance with a 4-year loan at a 2.99% annual promotional rate. How much is your monthly payment?

N= I/Y= PV= PMT= FV=

Solutions

Expert Solution

EMi in EXcel :

= PMT(I/Y,NPER,PV,0)

I/Y = Int rate per month

NPER = No. of Months

PV = Loan Today

Monthly instalment amount is $ 840.94

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

You bought a $225,000 house with a $40,000 down payment and financed the remaining $185,000 with...

You bought a $225,000 house with a $40,000 down payment and financed the remaining $185,000 with a 30-year mortgage (home loan). The interest rate on the loan is 5%. a) Find the monthly payment. b) After 12 years of paying on this mortgage, you decide to explore refinancing. With 18 years left to go, what is your remaining loan balance? c) If you do refinance the amount from part (b) with a new 15-year loan at 3% interest, how much...

Suppose you purchase a new car today for $25,000. You pay $2,000 as down payment towards...

Suppose you purchase a new car today for $25,000. You pay $2,000 as down payment towards this purchase, and finance the balance over 5 years at an annual interest rate of 5%, the first payment to be made in one month. Payments are made every month over the next 5 years. Calculate the monthly payment using both formula and function method. (Hint: need to multiply time by 12 to find the number of months and need to divide interest rate...

3. The cost of a used car is 11,900. It could be financed with a down...

3. The cost of a used car is 11,900. It could be financed with a down payment of 10% and a 5-year loan at a rate of 6.9%. Determine the following: (a) The amount financed. (b) The monthly payment. (b) The total installment price. (Installments  Down Payment.) (c) The finance charge. 4. A credit card has a monthly rate of 2% and uses the average daily balance method for calculating interest. The minimum monthly payment is the larger of...

Your sister Steffi recently purchased a new car that cost $40,000. She paid 5% of the...

Your sister Steffi recently purchased a new car that cost $40,000. She paid 5% of the purchase price in cash and took out a 5-year loan for the remainder. The loan has an annual interest rate of 6% and requires monthly payments at the end of each month. At the end of the loan, how much will Steffi have paid in total for the car and how much total interest will Steffi have paid on the loan? Total paid for...

A friend of yours just bought a new sports car with a $4,500 down payment, and...

A friend of yours just bought a new sports car with a $4,500 down payment, and her $32,000 car loan is financed at an interest rate of 0.50% per month for 36 months. After 2 years, the "Blue Book" value of her vehicle in the used-car marketplace is $10,000. a. How much does your friend still owe on the car loan immediately after she makes her 24th payment? b. Compare your answer to Part (a) to $10,000. This situation is...

1. (10 pts) You just bought a house for $400,000. You put 20% down and financed...

1. (10 pts) You just bought a house for $400,000. You put 20% down and financed the rest over 30 years at 6% nominal interest. Assuming equal monthly payments over the term of the loan, what are the monthly payments? What is the effective rate? (Chapter 4) 2. (10 pts) What would you need to invest today in an account that had a nominal rate of 8% compounded quarterly, if you wanted $12,000 in 4 years? What would be the...

You are buying a car for $35,000. You will put $2,000 of your own money down...

You are buying a car for $35,000. You will put $2,000 of your own money down and get a loan for the rest of the purchase price. The bank offers you the following loan terms: APR 12% (Annual percentage rate), 6 year loan with annual payments. Calculate the amount of the loan payment (PMT): Create an amortization schedule paying off the loan.

A company purchases a salesman a car for $40,000; the salesman pays $2,000 for an upgraded...

A company purchases a salesman a car for $40,000; the salesman pays $2,000 for an upgraded sound system to make his time on the road more pleasant. The car has an expected salvage value of $2,000 and an expected life of 4 years or 200,000 miles. During the first year the car was driven 45,000 miles, during the second year 40,000 miles and 50,000 miles the 3rd year Please show the annual depreciation expense for years 1, 2, 3 using...

A home has price $260,000. After a down payment of $40,000, the rest is financed over...

A home has price $260,000. After a down payment of $40,000, the rest is financed over 25 years at an annual interest rate of 6% compounded monthl y. a) Use the appropriate table in your book to find the monthly payment to the bank. (Do NOT use annuity formulas). b) Suppose that annual taxes are $3120 and homeowner’s insurance has an annual premium of $720. Lenders often collect these amounts in equal monthly installments along with the mortgage payment and...

You will buy a new car today. You will borrow the full price of the car. You will...

You will buy a new car today. You will borrow the full price of the car. You will get a FIVE year loan that will be paid back annually. It will take you the full FIVE years to pay back the loan. (In other words, you will not pay it off early.) You will pay back the same amount every year (an annuity). The auto dealership offers you 3 choices. 1) Pay $30,000 for the car at 0% interest for the FIVE years. 2) Pay $28,000 for the car at...

Subjects