1) You want to buy a $24,000 car. The company is offering a 3% interest rate...

1) You want to buy a $24,000 car. The company is offering a 3% interest rate for 48 months (4 years). What will your monthly payments be?

2) Suppose you want to have $800,000 for retirement in 20 years. Your account earns 4% interest. How much would you need to deposit in the account each month?

Solutions

Expert Solution

1.
PV = $24,000
Nper = 48
Rate = 3% / 12 = 0.25%
FV = 0

Monthly payment can be calculated by using the following excel formula:
=PMT(rate,nper,pv,fv)
=PMT(0.25%,48,-24000,0)
= $531.22

Monthly payment = $531.22

2.
FV = $800,000
Nper = 20 * 12 = 240
Rate = 4% / 12
PV = 0

Monthly deposit can be calculated by using the following excel formula:
=PMT(rate,nper,pv,fv)
=PMT(4%/12,240,0,-800000)
= $2,181.18

Monthly deposit = $2,181.18

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You want to buy a $18,500 car. The company is offering a 3% interest rate for...

You want to buy a $18,500 car. The company is offering a 3% interest rate for gour years. a. what will your minthly apyment be? Round to the nearest cent. b. assuming you pay that monthly amount for the entire 4 years, what is the total amount of money you will pay during thise 4 years for the car. C. How much interest will you pay during thise 4 years.

You want to buy a $17,000 car. The company is offereing a 3% interest rate for...

You want to buy a $17,000 car. The company is offereing a 3% interest rate for 36 months (3 years). What will your monthly payments be?

1.Suppose you want to buy a car that costs $19,000. If the dealer is offering 100%...

1.Suppose you want to buy a car that costs $19,000. If the dealer is offering 100% financing at 6.2% APR for a 5 year loan, what would be the monthly payment? (Answer to the nearest penny) 2.Suppose you want to buy a house that costs $850,000. You are required to put 10% down, which means the amount to be borrowed is 90% of the price of the house. If you want a 30 year mortgage, and the borrowing rate is...

You borrow $24,000 to buy a car. The loan is to be paid off in quarterly...

You borrow $24,000 to buy a car. The loan is to be paid off in quarterly installments over four years at 10 percent interest annually. The first payment is due one quarter from today. What is the amount of each quarterly payment? a) $1,745 b) $1,794 c) $1,838 d) $1,876 I need the hand-written formula, not the calculator input.

You want to buy a Jetta for $24,000. The loan offer at the VW dealership will...

You want to buy a Jetta for $24,000. The loan offer at the VW dealership will loan you the entire amount at an annually stated rate of 8.00%. You and the lender agree on a 5-year loan, with one payment at the end of each month for the next 60 months — calculate the size of your monthly payment.

You want to buy a house and will need to borrow $245,000. The interest rate on...

You want to buy a house and will need to borrow $245,000. The interest rate on your loan is 5.77 percent compounded monthly and the loan is for 30 years. What are your monthly mortgage payments?

Assume you want to buy Lamborghini in 10 years for $1 million. Interest rate is 6%...

Assume you want to buy Lamborghini in 10 years for $1 million. Interest rate is 6% per year. You plan to save every month to achieve your goal. How much should be the monthly saving over the next 120 months (10 years) if interest is compounded monthly? a. $8,333 b. $6,102 c. $13,333 d. $3,333

You took a loan to buy a new car. The monthly interest rate on the loan...

You took a loan to buy a new car. The monthly interest rate on the loan is 1.5% and you have to pay $240 every month for 60 months 1)What is the Present value of the Cash flows if its an ordinary annuity? 2)What is the future value of cash flows if its an ordinary annuity? 3)What is the present value of the cash flows if its an annuity due? 4)What is the future value of cash flows if its...

You took out a loan to buy a new car. The monthly interest rate on the...

You took out a loan to buy a new car. The monthly interest rate on the loan is 1%. You have to pay $270 every month for 60 months. Attempt 1/5 for 8 pts. Part 1 What is the present value of the cash flows if it's an ordinary annuity? Attempt 1/5 for 8 pts. Part 2 What is the future value of the cash flows if it's an ordinary annuity? Attempt 1/5 for 10 pts. Part 3 What is...

You want to buy a new sports car 3 years from now, and you plan to...

You want to buy a new sports car 3 years from now, and you plan to save $4,000 per year, beginning one year from today. You will deposit your savings in an account that pays 6.5% interest. How much will you have just after you make the 3rd deposit, 3 years from now? Group of answer choices $12,986 $12,635 $12,364 $12,486

Subjects