Question

In: Finance

Julie and Bell apply for a $60,000 loan. Contractual rate is 8 % with 6 annual...

Julie and Bell apply for a $60,000 loan. Contractual rate is 8 % with 6 annual payments. (40 points) Show all your work using the appropriate formulas

a. What are the annual payments (if you use constant (equal) payments method)?

b. What is the cost of the loan (total interest) if you use the method on part a?

c. What are the annual payments if you use constant payment on capital method) Make a table to show initial balance, interest paid, capital paid, and remaining balance.

d. What is the cost of the loan (total interest) if you use the method on part c) Now assume that the bank uses add-on method for the same loan ($60.000). The contractual rate is 8% with 6 annual equal payments.

e. What are the annual payments?

f. What is the effective interest rate of the loan? Now assume that the bank uses discount method for the same loan ($60.000). The contractual rate is 8% with 6 annual equal payments.

g. What are the annual payments?

h. What is the effective interest rate of the loan?

Solutions

Expert Solution

a). Equal payment: PV = 60,000; rate = 8%; N = 6, solve for PMT.

Equal annual payment = 12,978.92

b). Cost of the loan = total amount paid - loan amount = (equal annual payment*N) - 60,000 = (12,978.92*6) - 60,000 = 17,873.54

c). Constant payment on capital method table:

d). Cost of the loan = total interest paid = 4,800 + 4,000 + 3,200 + 2,400 + 1,600 + 800 = 16,800

e). Total interest payable = loan amount*annual rate* number of payments = 60,000*8%*6 = 28,800

Total amount payable = total interest + loan amount = 28,800 + 60,000 = 88,800

Annual payment = total amount/number of payments = 88,800/6 = 14,800

f). Effective interest rate on the add-on can be calculated using the annuity formula: PV = 60,000; PMT = -14,800; N = 6, solve for RATE.

Effective interest rate = 12.50%


Related Solutions

Julie and Bill Stevens are purchasing a tractor and will need a $50,000 loan. The contractual...
Julie and Bill Stevens are purchasing a tractor and will need a $50,000 loan. The contractual rate is currently 7% with five equal annual payments. Their lender uses the add-on method of calculating interest. a. What are the annual payments? b. What is the effective interest rate of the loan? c. What is the effective interest rate if the lender uses the remaining balance method of calculating interest? Explain the difference from problem b.
You borrow $60,000; the annual loan payments are $5,840.18 for30 years. What interest rate are...
You borrow $60,000; the annual loan payments are $5,840.18 for 30 years. What interest rate are you being charged? Round your answer to the nearest whole number.
You plan to apply for a loan from Bank of America. The nominal annual interest rate...
You plan to apply for a loan from Bank of America. The nominal annual interest rate for this loan is 13.89 percent, compounded daily (with a 365-day year). What is the effective annual rate, or EAR (annual percentage yield), of this loan?
Eliza takes out a $36,000 loan at an annual effective interest rate of 6%. It is...
Eliza takes out a $36,000 loan at an annual effective interest rate of 6%. It is agreed that at the end of each of the first six years she will pay $1,800 in principal, along with the interest due, and that at the end of each of the next eight years she will make level payments of $2,500. Eliza will make on final payment at the end of fifteen years to exactly complete her loan obligation. Calculate the amount of...
Jenny takes out a 10-year loan of 100,000 at an annual effective rate of 8%. At...
Jenny takes out a 10-year loan of 100,000 at an annual effective rate of 8%. At the end of each year Jenny makes interest payments to the lender and sinking fund deposits into a sinking fund earning 6% annual effective. Jenny's first sinking fund deposit is $1000 and the remaining deposits are level. a) Find the total (net) interest paid on the loan. b) How would the total (net) interest paid on the loan change if the interest rate on...
1. A proposed loan of $1m has total annual interest rate and fees of 6%. The...
1. A proposed loan of $1m has total annual interest rate and fees of 6%. The loan’s duration is 5.7 years. The lender’s cost of funds is 5.25%. Comparable loans have an interest rate of 5.85%. The expected maximum change in the loan rate due to a change in the credit risk premium for the loan is 1.25% (based on actual change in credit risk premium for the worst 1% of comparable loans over some prior period). a. What is...
1. Construct an amortization schedule for a $1,000, 8% annual rate loan with 3 equal payments....
1. Construct an amortization schedule for a $1,000, 8% annual rate loan with 3 equal payments. The first payment will be made at the end of the1st year. Find the required annual payments A) $355.8 B) $367.2 C)$388.0 D)$390.7 2. Based on the information from Question 1, what’s the ending balance of the amortized loan at the end of the third year A)$0 B)$349.7 C)$388.3 D)$692.0 3. Based on the information from Question 1 and 2, calculate the total amount...
You take out a 15-year $335,000 mortgage loan with a rate of 6% and annual payments....
You take out a 15-year $335,000 mortgage loan with a rate of 6% and annual payments. In 6 years you decide to pay off the mortgage. What is the principal balance on the loan after 6 years?
The fixed rate loans are 10 year, 8% (annual) coupon bonds with a yield of 6%.
ASSETS                                                                   LIABILTIES Cash                                   10                                Core Deposits               60 Fed funds                           30                                Fed funds                     50 Loans (floating)                   80                                Euro CDs                       30 Loans (fixed)                       40                                Equity                           30 TOTAL                                170                                                                  170 The fixed rate loans are 10 year, 8% (annual) coupon bonds with a yield of 6%. Cash and fed funds have a 0 duration. Floating loans have a duration of 1.0. All liabilities have a duration of 0.50. 2. What is the duration of the assets? 3. What is the duration of the...
You just took a $90,000, 10 years loan. The annual percentage rate (APR) is 8%. You...
You just took a $90,000, 10 years loan. The annual percentage rate (APR) is 8%. You are obligated to pay a flat payment at the end of each QUARTER. (a) Make a loan amortization table; (b) Plot a figure to show the flat payment, payment to interest, and payment in each quarter. SHOW IN EXCEL PLEASE
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT