Question

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 flows of 24,457 dollars for 10 months with the first monthly cash flow expected in 1 month. The trampoline park is also expected to make an extra cash flow of 19,141 dollars in 10 months. What is the monthly cost of capital for the trampoline park? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.

3) 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 be today, then what is the monthly interest rate that Bryna would be charged by California Cars? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.

4) 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 2,007.36 dollars for 12 years at a quarterly interest rate of 2.66 percent. Her first payment to Middlefield Motors would be due immediately. If Fairfax Boats would let her make equal monthly payments of 1,244.67 for 5 years and if her first payment to Fairfax Boats would be in 1 month, then what is the monthly interest rate that Mary Jo would be charged by Fairfax Boats? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.

Answer #1

1)use rate formulae in excel

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

=rate(15,-2458.16,30000,0,1)

=3.12%

answer is 0.0312

2)use irr function in excel and answer is 0.0058

Celeste just borrowed 31,500 dollars. She plans to repay this
loan by making equal quarterly payments of 1718.3 dollars for 24
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.

39. Celeste just borrowed 34,200 dollars. She plans to repay
this loan by making equal quarterly payments of 1,897.65 dollars
for 24 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.

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

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

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

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

Middlefield Motors is evaluating a project that would require an
initial investment of 79,077 dollars today. The project is expected
to produce annual cash flows of 7,471 dollars each year forever
with the first annual cash flow expected in 1 year. The NPV of the
project is 432 dollars. What is the IRR of the project? Answer as a
rate in decimal format so that 12.34% would be entered as .1234 and
0.98% would be entered as .0098.

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

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

Oxygen Optimization just bought a new filtration system for
167,300 dollars. To pay for the filtration system, the company took
out a loan that requires Oxygen Optimization to pay the bank a
special payment of 101,000 dollars in 5 year(s) and also make
regular annual payments forever. The first regular payment is
expected in 1 year and is expected to be 1,800 dollars. All
subsequent regular payments are expected to increase by a constant
rate each year forever. The interest...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 4 minutes ago

asked 4 minutes ago

asked 19 minutes ago

asked 30 minutes ago

asked 33 minutes ago

asked 36 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago