Question

Brenna wants to buy a car that is available at two dealerships. The price of the car is the same at both dealerships. Best Buggies would let her make quarterly payments of $2,250 for 5 years at a quarterly interest rate of 3.82 percent. Her first payment to Best Buggies would be due immediately. If California Cars would let her make equal monthly payments of $920 at a monthly interest rate of 1.35 percent and if her first payment to California Cars would be in 1 month, then how many monthly payments would Brenna need to make to California Cars? Round your answer to 2 decimal places (for example, 2.89, 14.70, or 6.00).

Answer #1

First we have to find the price of the car/loan amount by using PV function in EXCEL

=PV(rate,nper,pmt,fv,type)

rate=3.82%

nper=number of periods=5*4=20 (4 quarters in a year)

pmt=2250

fv=0

type=1 (because the payments to made immediately)

=PV(3.82%,20,2250,0,1)

PV=32,258.39

Now use this loan amount to find the monthly payments using NPER function in EXCEL

=NPER(rate,pmt,pv,fv,type)

rate=1.35%

pmt=920

pv=32258.39

fv=0

type=0 (because payments made at the end of the period)

=NPER(1.35%,920,-32258.39,0,0)

NPER=47.82

It takes 47.82 monthly payments to repay the loan amount of 32258.39

Brenna wants to buy a car that is available at two dealerships.
The price of the car is the same at both dealerships. Best Buggies
would let her make quarterly payments of $2,250 for 5 years at a
quarterly interest rate of 3.82 percent. Her first payment to Best
Buggies would be due immediately. If California Cars would let her
make equal monthly payments of $920 at a monthly interest rate of
1.35 percent and if her first payment to...

Bryna wants to buy a car that is available at two dealerships.
The price of the car is the same at both dealerships. Best Buggies
would let her make quarterly payments of $2,240 for 5 years at a
quarterly interest rate of 3.72 percent. Her first payment to Best
Buggies would be due in 3 months. If California Cars would let her
make equal monthly payments of $935 for 4 years and if her first
payment to California Cars would...

Mary Jo wants to buy a boat that is available at two
dealerships. The price of the boat is the same at both dealerships.
Middlefield Motors would let her make quarterly payments of
4,827.66 dollars for 8 years at a quarterly interest rate of 2.35
percent. Her first payment to Middlefield Motors would be due
immediately. If Fairfax Boats would let her make equal monthly
payments of 2,608 for 4 years and if her first payment to Fairfax
Boats would...

42. Mary Jo wants to buy a boat that is available at two
dealerships. The price of the boat is the same at both dealerships.
Middlefield Motors would let her make quarterly payments of
1,160.51 dollars for 11 years at a quarterly interest rate of 2.32
percent. Her first payment to Middlefield Motors would be due
immediately. If Fairfax Boats would let her make equal monthly
payments of 623.37 for 5 years and if her first payment to Fairfax
Boats...

1) Celeste just borrowed 30,000 dollars. She plans to repay this
loan by making equal quarterly payments of 2,458.16 dollars for 15
quarters. If she makes her first quarterly payment later today,
then what is the quarterly interest rate on the loan? Answer as a
rate in decimal format so that 12.34% would be entered as .1234 and
0.98% would be entered as .0098.
2) A trampoline park is worth 255,011 dollars. It is expected to
produce equal monthly cash...

Aldo wants to borrow $12,000 from the bank and is choosing among
two possible loans. The interest rate on both loans is 1.4 percent
per month. Loan A would require him to make 60 equal monthly
payments, with the first payment made to the bank in 1 month. Loan
B would also require him to make equal monthly payments to the
bank. However, 1) the monthly payment associated with loan B would
be $30 less than the monthly payment associated...

XYZ
wants to but exercisr equiptmrnt that is available at two stores.
the price of the exercise equiptment is the same at both stores.
PQR health housr would let her make quartrrly payments of $4,780
fot 6 years at a quarterly interedt rate of 2.67 percent. her first
payment woulf be due immedietly. if ABC bronx would let her make
equal monhtly payments of $2190 for 5 years and it her first
payment to ABC would be in one month,...

Kerri James is considering the purchase of a car. She wants to
buy the new VW Beetle, which will cost her $17,600. She will
finance 90% of the purchase price (i.e., make a 10% down payment)
at an interest rate of 5.9 percent, with monthly payments over
three years. How much money will she still owe on the loan at the
end of one year(that is, immediately after she makes the 12th
payment on her car loan)?

Fatima just borrowed 111,412 dollars. She plans to repay this
loan by making a special payment of 30,056 dollars in 4 years and
by making regular annual payments of 13,870 dollars per year until
the loan is paid off. If the interest rate on the loan is 13.61
percent per year and she makes her first regular annual payment of
13,870 dollars immediately, then how many regular annual payments
of 13,870 dollars must Fatima make? Round your answer to 2...

An investment, which is worth 44,500 dollars and has an expected
return of 13.27 percent, is expected to pay fixed annual cash flows
for a given amount of time. The first annual cash flow is expected
in 1 year from today and the last annual cash flow is expected in 5
years from today. What is the present value of the annual cash flow
that is expected in 3 years from today?
An investment, which is worth 88,925 dollars and...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 4 minutes ago

asked 10 minutes ago

asked 10 minutes ago

asked 12 minutes ago

asked 16 minutes ago

asked 19 minutes ago

asked 27 minutes ago

asked 35 minutes ago

asked 39 minutes ago

asked 39 minutes ago

asked 40 minutes ago

asked 42 minutes ago