Question

In: Finance

Because of a job change, Ben Hardesty has just relocated to the southeastern United States. He...

  1. Because of a job change, Ben Hardesty has just relocated to the southeastern United States. He sold his furniture before he moved, so he's now shopping for new furnishings. At a local furniture store, he's found an assortment of couches, chairs, tables, and beds that he thinks would look great in his new two-bedroom apartment; the total cost for everything is $3,000. Because of moving costs, Ben is a bit short of cash right now, so he's decided to take out an installment loan for $3,000 to pay for the furniture. The furniture store offers to lend him the money for 36 months at an add-on interest rate of 7 percent. The credit union at Ben's firm also offers to lend him the money - they'll give him the loan at an interest rate of 11.5 percent simple, but only for a term of 24 months.
  1. Compute the monthly payments for the loan from the furniture store. Round the answer to the nearest cent.   (1)

  1. Compute the monthly payments for the loan from the credit union. Round the answer to the nearest cent.  (1)
  1. Determine the APR for the loan from the furniture store. Do not round intermediate calculations. Round the answer to 2 decimal places.   (1)

d. Determine the APR for the loan from the credit union. Do not round intermediate calculations. Round the answer to 2 decimal places. (1)

Solutions

Expert Solution

Given:

Loan amount = $ 3000

Furniture Store offer:

Interest rate = 7% (Add-on Interest)

Tenure = 36 months = 3 years

Credit union Offer:

Interest rate = 11.5% (Simpe Interest)

Tenure = 24 months = 2 years

Solution a:

The monthly payments for the loan from the furniture store include add-on interest. Add-on interest refers to the calculation method of determining the total interest to be paid on a loan. This interest is added to the Principal and the total amount is divided by tenure to determine the monthly payment.

Interest payment = Principal * Annual Interest Rate * Tenure

Interest = 3000 * 7% * (36/12) = 630

Monthly Payments = (Principal + Interest ) / 36

=(3000 + 630) / 36

=3630 / 36

= 100.833

Hence, The monthly payments for the loan from the furniture store is 100.833

Solution b:

Monthly payments for the loan from the credit union: Simple Interest

In this case, Interest is chanrged only on the outstanding principal payments and not the whole Principal amount throughout the tenure.

This can be calculated using the PMT formula in Excel.

PMT(rate,nper, pv)

where, rate is the Interest rate per period = 11.5% / 12

nper is the number of periods = 24

pv is the present value of the Loan = 3000

PMT(11.5%/12,24,-3000) = 140.52

The Monthly Payment = $ 140.52

Solution c:

APR can be calculated using RATE function in Excel.

RATE(nper, pmt, pv),

wehre nper is the number of periods,

pmt is the Monthly installment,

pv is the present value of the loan

APR (Furniture Store) :

RATE(36, 100.833, -3000) = 1.07%

APR = 1.07% * 12 = 12.83%

APR for the loan from the furniture store is 12.83%

Similarly for the Crdit Store:

APR = RATE(24,140.52,-3000) * 12 = 0.96% * 12 = 11.50%

APR for the loan from the credit union is 11.50%


Related Solutions

Because of a job change, Finn McBryde has just relocated to thesoutheastern United States. He...
Because of a job change, Finn McBryde has just relocated to the southeastern United States. He sold his furniture before he moved, so he's now shopping for new furnishings. At a local furniture store, he's found an assortment of couches, chairs, tables, and beds that he thinks would look great in his new, two-bedroom apartment; the total cost for everything is $5,000. Because of moving costs, Finn is a bit short of cash right now, so he's decided to take...
A 50-year-old male presents to the community clinic. He has just relocated to the area and...
A 50-year-old male presents to the community clinic. He has just relocated to the area and has no primary provider. He is a long distance truck driver and requires a physical examination to maintain his continued employment. Physical examination demonstrates a BMI of 33, blood pressure of 180/90 mm Hg, diminished femoral pulses and bilateral varicose veins with nonpitting edema in both ankles. He has a 30-year history of smoking two packs of cigarettes per day. Initial Discussion Post: What...
Epsilon Airlines services predominately the eastern and southeastern United States. The vast majority of Epsilon’s customers...
Epsilon Airlines services predominately the eastern and southeastern United States. The vast majority of Epsilon’s customers make reservations through Epsilon’s website, but a small percentage of customers make reservations via phone. Epsilon employs call-center personnel to handle these reservations along with any problems with the website reservation system and for the rebooking of flights for customers if their plans change or their travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon’s management team. Having too many...
Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of Epsilon’s customers...
Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of Epsilon’s customers make reservations through Epsilon’s website, but a small percentage of customers make reservations via phone. Epsilon employs call-center personnel to handle these reservations along with any problems with the website reservation system and for the rebooking of flights for customers if their plans change or their travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon’s management team. Having too many...
Epsilon Airlines services predominantly the eastern and southeastern united States. The vast majority of Epsilon’s customers...
Epsilon Airlines services predominantly the eastern and southeastern united States. The vast majority of Epsilon’s customers make reservations through Epsilon’s website, but a small percentage of customers make reservations via phones. Epsilon employs call center personnel to handle these reservations and to deal with website reservation system problems and for the rebooking of flights for customers whose plans have changed or whose travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon’s management team. Having too many...
Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of Epsilon’s customers...
Epsilon Airlines services predominately the eastern and southeastern United States. A vast majority of Epsilon’s customers make reservations through Epsilon’s website, but a small percentage of customers make reservations via phone. Epsilon employs call-center personnel to handle these reservations along with any problems with the website reservation system and for the rebooking of flights for customers if their plans change or their travel is disrupted. Staffing the call center appropriately is a challenge for Epsilon’s management team. Having too many...
Is the long term survival of the United States economy at risk because of the United...
Is the long term survival of the United States economy at risk because of the United States government’s level of debt and the amount of the debt held by foreign entities such as China? Why or why not? no less than 250 words in length, make at least one reference to your text or other course materials and provide in-text citations. As you reference information from a source, be sure to provide APA citations in text and at the end...
Wheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company...
Wheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company has two salespeople that do more than just sell the products- they manage relationships with the bicycle shops to enable them to better meet consumers' needs. The company's sales reps visit the shops several times per year, often for hours at a time. The owner of Wheels is considering expanding to the rest of the country and would like to have distribution through 2,250...
Wheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company...
Wheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company has two salespeople that do more than just sell the products- they manage relationships with the bicycle shops to enable them to better meet consumers' needs. The company's sales reps visit the shops several times per year, often for hours at a time. The owner of Wheels is considering expanding to the rest of the country and would like to have distribution through 2,250...
After years of rapid growth, illegal immigration into the United States has declined because of the...
After years of rapid growth, illegal immigration into the United States has declined because of the recent recession and better economic conditions in the countries south of the border. But California still accounts roughly 20% of the nation undocumented immigrants. If you take a random sample of 50 undocumented immigrants, what is the probability that more than a quarter (25%) of them live in California? (HINT: Large sample proportion – use Normal approximation.) Define p = proportion of all undocumented...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT