Question

In: Finance

Barbara borrows $3000. She agrees to make monthly interest payments on the loan and will build...

Barbara borrows $3000. She agrees to make monthly interest payments on the loan and will build up a sinking fund with monthly deposits to repay the principal with a single payment 19 months from now. If the interest being charged on the loan is j12 = 8.5% and the interest being earned on the sinking fund is j12= 5.4%, what is the monthly cost of the debt for Barbara?

Solutions

Expert Solution

Solution:

The interest to the lender is based on an annual rate of 8.5%.
Using the simple interest formula, I = Prt.
We get, I = 3000 * (0.085) * (1) = 255 per year.
Dividing by 12 to get monthly interest payment = 255/12 = 21.25

The amount to be deposited in the sinking fund each month is given by following formula:
P = (Amounts need to be accumulated * Interest rate per period) / [ ((1+interest rate per period)^number of time periods) - 1]

The amount to be accumulated = Original borrowed amount = 3000
The interest being earned on the sinking fund based on annual rate is 5.4%
The interest rate per period = 5.4%% divided by 12 = 0.054/12 = 0.0045 or 0.45%.
The number of periods = 19 months.

The amount to be deposited in the sinking fund each month = (3000 * 0.0045) / [ ((1+0.0045)^19) - 1] = 135 / 0.08905 = 1515.957
So, the monthly payment into the sinking fund is $1,515.957.

The monthly cost of the debt for Barbara = The monthly payment into the sinking fund + monthly interest payment = 1515.957 + 21.25 = $1,537.207.


Related Solutions

Harry borrows $3,500 from Mary. He agrees to repay the loan with annual payments, made at...
Harry borrows $3,500 from Mary. He agrees to repay the loan with annual payments, made at the end of each year, of $500, $1,000, $1,500, etc. with a smaller final payment one year after the last regular payment. Mary charges Henry a rate of discount 10% convertible 4 times per year. Determine the amount of the final payment. Ans: At least $1670, but less than $1700.
Eve borrows 10,000. The loan is being repaid with the following sequence of monthly payments: 100,...
Eve borrows 10,000. The loan is being repaid with the following sequence of monthly payments: 100, 150, 100, 150, 100, 150, etc. The annual nominal interest rate is 7.56% payable monthly. Calculate the amount of principal repaid in the 13th payment.
Derek borrows $42,333.00 to buy a car. He will make monthly payments for 6 years. The...
Derek borrows $42,333.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 5.57%. After a 14.00 months Derek decides to pay off his car loan. How much must he give the bank? Currency: Round to: 2 decimal places.
Derek borrows $35,808.00 to buy a car. He will make monthly payments for 6 years. The...
Derek borrows $35,808.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 6.04%. After a 12.00 months Derek decides to pay off his car loan. How much must he give the bank?
Derek borrows $39,180.00 to buy a car. He will make monthly payments for 6 years. The...
Derek borrows $39,180.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 6.07%. After 11 months Derek decides to pay off his car loan. How much must he give the bank? Answer format: round to 2 decimal places
Derek borrows $42,412.00 to buy a car. He will make monthly payments for 6 years. The...
Derek borrows $42,412.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 5.39%. What will the payments be? Derek borrows $36,990.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 6.12%. After a 16.00 months Derek decides to pay off his car loan. How much must he give the bank? Derek plans to buy a $28,270.00 car. The...
Derek borrows $32,708.00 to buy a car. He will make monthly payments for 6 years. The...
Derek borrows $32,708.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 5.24%. After a 11.00 months Derek decides to pay off his car loan. How much must he give the bank? Answer Format Currency: Round to: 2 decimal places.
Derek borrows $43,863.00 to buy a car. He will make monthly payments for 6 years. The...
Derek borrows $43,863.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 5.27%. After a 15.00 months Derek decides to pay off his car loan. How much must he give the bank? Answer Format: Currency: Round to: 2 decimal places.
Assignment: Build an Excel sheet that will compute flexibly the monthly amortization payments, monthly interest amounts,...
Assignment: Build an Excel sheet that will compute flexibly the monthly amortization payments, monthly interest amounts, monthly amortization principal amounts, and any other computationally relevant variables you may deem important. The Excel file must be driven by the pertinent formulae that define the typical Canadian mortgage contracts. We will examine your programming skills in Excel in this particular assignment. Here are following mortgage facts: Mortgage amount: Flexible and any amount the borrower wishes - i.e., your choice Payment frequency: Monthly...
Roberto borrows $10,000 and repays the loan with three equal annual payments. The interest rate for...
Roberto borrows $10,000 and repays the loan with three equal annual payments. The interest rate for the first year of the loan is 4% compounded annually; for the second year of the loan the interest rate is 5% compounded annually; for the third year of the loan the interest rate is 6% compounded annually. a. Determine the size of the equal annual payments. b. Would interchanging the interest rates for first year and third year change the answer to part...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT