ou want to buy a new car, but you can make an initial payment of only...

ou want to buy a new car, but you can make an initial payment of only $2,800 and can afford monthly payments of at most $600. a. If the APR on auto loans is 12% and you finance the purchase over 48 months, what is the maximum price you can pay for the car? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. How much can you afford if you finance the purchase over 60 months? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

Expert Solution

SOLVED USING FINANCIAL FORMULA AS WELL AS EXCEL FUNCTION

jeff jeffy answered 2 years ago

You want to purchase a new car, but can only afford a payment of $1,800 per...

You want to purchase a new car, but can only afford a payment of $1,800 per month. If the dealer tells you that they have financing available at an APR of 5% for a 48-month loan, how much can you afford to borrow for your new car (given the $1,800 payment)?

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 want to buy a new car. You can only afford $600/month. (Don’t forget to use...

You want to buy a new car. You can only afford $600/month. (Don’t forget to use autofill features) How much can you pay for the car? Highlight this answer in your favorite color. Be sure to make three worksheets in one excel file. a. Prepare a loan amortization table for a 5% 5-year loan. b. If you were able to get a 3% loan, how much more could you spend on a car. (Use spinners) Lock the 3% cell in...

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%,...

Suppose you want to buy Amazon stock if and only if you can buy it for...

Suppose you want to buy Amazon stock if and only if you can buy it for less than $3100/share. The kind of order you should place today if it is trading at $3164/share is a: Select one: a. Limit order b. Market order c. Stop-loss order d. Fungible order

"Ms. Jones wants to buy a new car for $30,000. She will make a down payment...

"Ms. Jones wants to buy a new car for $30,000. She will make a down payment of $15,000. She would like to borrow the remainder from a bank at an interest rate of 9.6% compounded monthly. She agrees to pay off the loan monthly for a period of 3.25 years. Assume that Ms. Jones has made 16 payments and wants to figure out the balance remaining immediately after the 16th payment. Determine the remaining balance." Show all work

Suppose you want to buy a condominium that costs $320,000. You will make a down payment...

Suppose you want to buy a condominium that costs $320,000. You will make a down payment equal to 20 percent of the price of the condominium and finance the remainder with a loan that has an interest rate of 4.65 percent compounded monthly. If the loan is for 30 years, what are your monthly mortgage payments? Multiple Choice $1,350.89 $1,286.48 $1,320.03 $1,468.12 $1,534.46

In order to buy a new car, you finance $23,000 with no down payment for a...

In order to buy a new car, you finance $23,000 with no down payment for a term of five years at an APR of 6%. After you have the car for one year, you are in an accident. No one is injured, but the car is totaled. The insurance company says that before the accident, the value of the car had decreased by 25% over the time you owned it, and the company pays you that depreciated amount after subtracting...

You plan to buy a new car. The price is $30,000 and you will make a...

You plan to buy a new car. The price is $30,000 and you will make a down payment of $4,000. Your annual interest rate is 10% and you intend to pay for the car over five years. What will be your monthly payment?

Question