Question

In: Finance

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 following questions.

a. What is the effective annual rate?

b. What is the effective biweekly rate?

c. What will be your biweekly loan payment?

d. What is the balance on your loan in 3 years’ time, after 78 payments?

e. Show the amortization schedule (table) for the first 5 payments. If you are doing this on an Excel spreadsheet, copy and paste the first 5 rows from the amortization schedule into a Microsoft Word (or any other word-processing software) document file.

f. You want to put enough money into your bank account to pay for the loan payments for the next six months. If your bank account yields an APR of 2% (compounded bi-weekly), how much money should you put in your bank account now?

Solutions

Expert Solution

Answer (a):

The rate of interest is 2.5% APR compounded semi-annually

Effective annual rate = (1 + 2.5%/2)^2 - 1 = 2.515625%

Effective annual rate = 2.515625%

Answer (b):

Effective biweekly rate = (1 +2.515625%) ^(1/26) - 1 = 0.0956035171988168%

Effective biweekly rate = 0.0956035171988168%

Answer (c):

Loan amount = PV = 48000 - 5000 = $43,000

NPER in biweekly periods = 5 * 26 = 130

Biweekly interest rate = 0.0956035171988168%

Biweekly loan payment = PMT(rate, nper, pv, fv, type) = PMT(0.0956035171988168%, 130, -43000, 0,0) = $351.9075

Biweekly loan payment = $351.91

Answer (d):

Remaning number of biweekly payments after 78 payments = 130 - 78 = 52

Balance on your loan in 3 years’ time, after 78 payments = PV(0.0956035171988168%, 52,-351.9075, 0,0)

=$17,843.46

Balance on your loan in 3 years’ time, after 78 payments = $17,843.46  

Answer (e):

First 5 rows from the amortization schedule are calculated and given below:

Above excel with 'show formula' is as follows:

Answer (f):

Biweely interest rate = 2%/26

Amount of money you need to put in bank account = PV(rate, nper, pmt, fv, type)

= PV(2%/26, 6, -351.9075, 0, 0)

= $2105.77

Amount of money you need to put in bank account = $2,105.77


Related Solutions

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...
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
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?...
You want to buy a $1,000,000 house. Suppose you make a20% down payment today, and you...
You want to buy a $1,000,000 house. Suppose you make a20% down payment today, and you finance the rest of your purchase with a 30‐year fixed rate jumbo mortgage of 4.00%.          What will be your monthly mortgage payments?                    How much of your first month’s payment goes toward paying   off interest? How much  goes toward paying off the loan balance?            How much do you still owe after 5 years (i.e., just after your 60th monthly payment)?                        How long...
"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
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 buy a car with a down payment of $3000 and payments of $600 per month...
You buy a car with a down payment of $3000 and payments of $600 per month for 3 years. If the interest rate is 3.6% compounded monthly, what is the total cost of the car?
You want to buy a house that costs $210,000. You have $21,000 for a down payment,...
You want to buy a house that costs $210,000. You have $21,000 for a down payment, but your credit is such that mortgage companies will not lend you the required $189,000. However, the realtor persuades the seller to take a $189,000 mortgage (called a seller take-back mortgage) at a rate of 5%, provided the loan is paid off in full in 3 years. You expect to inherit $210,000 in 3 years, but right now all you have is $21,000, and...
You want to buy a $188,000 home. You plan to pay 20% as a down payment,...
You want to buy a $188,000 home. You plan to pay 20% as a down payment, and take out a 30 year loan for the rest. a) How much is the loan amount going to be? $ b) What will your monthly payments be if the interest rate is 5%? $ c) What will your monthly payments be if the interest rate is 6%? $
You want to buy a house that costs $180,000. You have $18,000 for a down payment,...
You want to buy a house that costs $180,000. You have $18,000 for a down payment, but your credit is such that mortage companies will not lend you the required $160,000. However, the realtor persuades the seller to take a $160,000 mortage (called a seller take-back mortage) at a rate of 7%, provided the loan is paid off in full in 3 years. You expected to inherit $180,000 in 3 years; but right now all you have is $18,000, and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT