Question

In: Finance

Christopher took a loan of $8,300 from his parents to purchase equipment for his hair salon....

Christopher took a loan of $8,300 from his parents to purchase equipment for his hair salon. They agreed on an interest rate of 3% compounded monthly on the loan. What equal quarterly payments made at the end of each period will settle the loan for 5 years if the first payment is to be made 4 years and 1 quarter from now?

Solutions

Expert Solution

Quarterly instalment :
Quarterly Instalment is sum of money due as one of several equal payments for loan/ Mortgage taken today, spread over an agreed period of time.

EMI = Loan / PVAF (r%, n)
PVAF = SUm [ PVF(r%, n) ]
PVF(r%, n) = 1 / ( 1 + r)^n
r = Int rate per period
n = No. of periods

How to calculate PVAF using Excel:
=PV(Rate,NPER,-1)
Rate = Disc Rate
NPER = No.of periods

Int rate per quarter = ( 1 + 0.0025)^3 - 1

= 1.0025^3 - 1

= 0.007519

Particulars Amount
Loan Amount $               8,300.00
Int rate per Quarter 0.7519%
No. of Quarters 20

PVAF from 17 to 36 Quarters:

PVAF (0.7519%, 36) = 31.4363

PVAF (0.7519%, 16) = 15.0219

PVAF (0.7519%, 17 to 36) = 16.4144

Equated Quarterly Instalment = Loan Amount / PVAF (r%, n)
Where r is Int rate per Quarter & n is No. of Quarters
= $ 8300 / PVAF (0.0075 , 20)
= $ 8300 / 16.4144
= $ 505.65

Quarterly Instalment is $ 505.65

Pls comment, if any further assistance is required.


Related Solutions

Vincent took a loan of $8,200 from his parents to purchase equipment for his hair salon....
Vincent took a loan of $8,200 from his parents to purchase equipment for his hair salon. If they agreed on an interest rate of 6% compounded quarterly on the loan, what monthly payments will settle the loan in 5 years if he made his first payment 3 years and 6 months from now? a)$194.16 b)$255.21 c)$158.42 d)$208.23
Farah runs a hair salon in Dammam and employs technicians and cleaners from Kenya and the...
Farah runs a hair salon in Dammam and employs technicians and cleaners from Kenya and the Phillipines. Her business is profitable and has grown from 1 salon to 3 salons in the last 2 years. Her employees are paid on seniority and they were loyal to her. She has never trained any of her employees, always asking the senior technicians to teach the new comers. Recently the following happened: Several good technicians quit in Feb and March, to work for...
A business borrowed $150,000 from a bank to purchase new equipment. The interest on the loan...
A business borrowed $150,000 from a bank to purchase new equipment. The interest on the loan is 3% per year, and it must be paid in 8 years. Create a loan schedule for the payments
Johnny took $20,000 loan from his employer, with an agreement to pay $1000 instalment every month,...
Johnny took $20,000 loan from his employer, with an agreement to pay $1000 instalment every month, at 3% interest when the government rate was 5%. Johnny had paid 3 instalments. Calculate the taxable benefit in the 4th month.
TP acquired a tract of land by way of gift from his parents. His parents purchased...
TP acquired a tract of land by way of gift from his parents. His parents purchased the land in 1980 for $100,000, and gifted it to him in 2010 when it had a fair market value of $500,000. In 2012, TP built a 5 unit apartment building on the land at a cost of $500,000. Accumulated depreciation to date totals $40,000. TP has an agreement to sell the real estate for an adjusted sales price of $1,500,000. He intends to...
Chris acquired a tract of land by way of gift from his parents. His parents purchased...
Chris acquired a tract of land by way of gift from his parents. His parents purchased the land in 1980 for $100,000, and gifted it to him in 2010 when it had a fair market value of $500,000. In 2012, Chris built a 5 unit apartment building on the land at a cost of $500,000. Accumulated depreciation to date totals $40,000. Chris has an agreement to sell the real estate for an adjusted sales price of $1,500,000. He intends to...
Alice’s hair salon increased its total monthly revenue from RM10,000 to RM15,000 when it raised the...
Alice’s hair salon increased its total monthly revenue from RM10,000 to RM15,000 when it raised the price of hair cut from RM50 to RM60. a. Calculate the price elasticity of demand for Alice’s hair salon. b. Suppose you are the hair salon’s consultant, if Alice wish to increase her revenue, would you advise her to continue with her existing plan?
Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan...
Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan has 4.0% APR with monthly payments of $1,800. How much do you owe on the loan today? The remaining loan balance is $________. (round to the nearest dollar) How much interest did you pay on the loan in the past year? The interest paid in year five was $______. (round to the nearest dollar) Over the entire period of 10 years, how much interest...
This morning, you took out a loan of $386,000 to purchase a home. The interest rate...
This morning, you took out a loan of $386,000 to purchase a home. The interest rate on the 30-year mortgage is 3.75 percent and you will make monthly payment. You have decided to make additional monthly payment of $360 beginning with the first payment that will occur one month from today. By how many years will you shorten the length of time it will take you to pay off the loan? Group of answer choices 11.06 years 9.33 years 12.84...
a) Adam wants to purchase a car and finance his purchase with a 3 year loan...
a) Adam wants to purchase a car and finance his purchase with a 3 year loan at 5% interest. If he wants his payments to be $475 per month, how much can he finance with this loan? b) Bernard purchased a car and financed his purchase with a loan at 5% interest. His payments are $475 per month. If he has 3 years left on his loan, what is his remaining balance? c) Carlton purchased a car and took out...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT