In: Finance
Shirley, a recent college graduate, excitedly described to her older sister the $1,510 sofa, table, and chairs she found today. However, when asked she could not tell her sister which interest calculation method was to be used on her credit-based purchase. Calculate the monthly payments and total cost for a bank loan assuming aone-year repayment period and 13.25 percent interest. Now, assume the store uses the add-on method of interest calculation. Calculate the monthly payment and total cost with a one-year repayment period and 11.25 percent interest. Using the information above, how much interest will Shirley "save" or be rebated if she can repay the loans after six months?
For a bank loan assuming a one-year repayment period and 13.25% interest, the monthly payment is?
| One year repayment and 13.25% interest | ||||||||||
| Pv | Amount of Purchase | $1,510 | ||||||||
| Rate | Monthly interest=(13.25/12)%= | 1.10417% | ||||||||
| Nper | Number of months of payment | 12 | ||||||||
| PMT | Monthly Payment | $135.05 | (using PMT function of excelwith Rate=1.10417%,Nper=12, Pv=-1510) | |||||||
| Excel command:PMT(1.10417%,12,-1510) | ||||||||||
| Total Cost=135.05*12= | $1,620.56 | |||||||||
| One year repayment and 11.25% interest(ADD ON METHOD) | ||||||||||
| Amount of Purchase | $1,510 | |||||||||
| Total interest in one year =1510*11.25% | $169.88 | |||||||||
| Total Principal to be paid | $1,510 | |||||||||
| Total Payments=1510+169.88= | $1,680 | |||||||||
| Number of months of payment | 12 | |||||||||
| Monthly Payment=1680/12 | $139.99 | |||||||||
| Total Cost | $1,680 | |||||||||
| Repayment after 6 months at 13.25% interest | $1,606.93 | 1510*(1.1325^0.5) | ||||||||
| Saving in interest =1620.56-1606.93 | $13.63 | |||||||||