Question

In: Finance

A design studio received a loan of $5,300 at 3.10% compounded semi-annually to purchase a camera....

A design studio received a loan of $5,300 at 3.10% compounded semi-annually to purchase a camera. If they settled the loan in 2 years by making quarterly payments, construct the amortization schedule for the loan and answer the following questions:

a. What was the payment size?

Round to the nearest cent

b. What was the size of the interest portion on the first payment?

Round to the nearest cent

c. What was the balance of the loan at end of the first year?

Round to the nearest cent

d. What was the size of the interest portion on the last payment?

Round to the nearest cent

Solutions

Expert Solution

In this case we will have to calculate annual effective interest rate and then calculate monthly payment
Effective annual rate (1+(r/n)^n)-1)
interest rate is r and frequency of compounding is n
Effective annual rate (1+(3.10%/2)^2)-1)
Effective annual rate 1.03124-1
Effective annual rate 3.12%
Quarterly interest rate 0.00781 3.12%/4
No of payments 8 2*4
Formula to calculate quarterly payment
Quarterly payment Loan amount/Annuity discount factor
Annuity discount factor [1-((1+r)^-n)]/r
interest rate is r and number of payments is n
Quarterly payment 5300/(1-(1.00781^-8))/0.00781
Quarterly payment 5300/7.726003
Quarterly payment $686.00
Amortization table
Time period Quarterly payment Interest Principal payment Loan balance
1 $686.00 $41.39 $644.60 $4,655.40
2 $686.00 $36.36 $649.64 $4,005.76
3 $686.00 $31.29 $654.71 $3,351.05
4 $686.00 $26.17 $659.82 $2,691.23
5 $686.00 $21.02 $664.98 $2,026.25
6 $686.00 $15.83 $670.17 $1,356.08
7 $686.00 $10.59 $675.40 $680.68
8 $686.00 $5.32 $680.68 $0.00
Interest is calculated as beginning loan balance*Quarterly interest rate (0.00781)
Principal payment Quarterly payment - Interest for the period
b.
The interest portion in first payment was $41.39
c.
Balance of loan at end of year 1 is $2,691.23 (after 4th payment)
d.
The interest portion in last payment is $5.32

Related Solutions

A design studio received a loan of $5,050 at 5.30% compounded semi-annually to purchase a camera...
A design studio received a loan of $5,050 at 5.30% compounded semi-annually to purchase a camera and settled the loan in 2 years by making quarterly payments. a. What was the size of the payments? b. What was the interest portion on the first payment? c. What was the balance of the loan at end of the first year? d. What was the interest portion on the last payment?
A loan of $27,150.00 at 5.00% compounded semi-annually is to be repaid with payments at the...
A loan of $27,150.00 at 5.00% compounded semi-annually is to be repaid with payments at the end of every 6 months. The loan was settled in 4 years. a. Calculate the size of the periodic payment. $3,406.15 $4,200.70 $3,786.54 $4,276.00 b. Calculate the total interest paid. $3,142.32 $30,292.32 -$644.22 $6,928.86
A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over...
A $37,000 loan at 8.2% compounded semi-annually is to be repaid by equal semi-annual payments over 10 years. a) What will be the principal component of the sixth payment? b) What will be the interest component of the sixteenth payment? c) How much will Payments 6 to 15 inclusive reduce the principal? d) How much interest will be paid in the third year? e) What will be the final payment?
A construction company signed a loan contract at 4.07 % compounded semi-annually , with the provision...
A construction company signed a loan contract at 4.07 % compounded semi-annually , with the provision to pay $665 at the end of each month for three years. (a) What is amount of the loan? (b) How much will be owed at the end of seventeen months? (c) How much of the principal will be repaid within the first seventeen months? (d) How much interest is paid during the first seventeen months?
A loan of ​$13 comma 000 with interest at 12​% compounded semi dash annually is repaid...
A loan of ​$13 comma 000 with interest at 12​% compounded semi dash annually is repaid by payments of $ 937.00 made at the end of every three months. ​(a) How many payments will be required to amortize the​ loan? ​(b) If the loan is repaid in full in 2 years​, what is the payout​ figure? ​(c) If paid​ out, what is the total cost of the​ loan? ​(a) The number of payments required to amortize the loan is nothing....
A company borrowed at 4.63%compounded semi-annually to purchase​ equipment, agreeing to make payments of ​$2,140 at...
A company borrowed at 4.63%compounded semi-annually to purchase​ equipment, agreeing to make payments of ​$2,140 at the end of every three months for 13 payments. ​(a) What is the equivalent cash price of the​ equipment? ​(b) How much will be owed at the end of two ​years? ​(c) How much of the principal will be repaid within the first two ​years?​ (d) How much interest is paid during the first two ​years? ​(a) The cash price of the equipment is...
Yassine took a loan of $6,744.29. The rate of interest is 5% compounded annually. The loan...
Yassine took a loan of $6,744.29. The rate of interest is 5% compounded annually. The loan is to be repaid by annual payments of $500 at the end of each year for 23 years. What is the outstanding balance of the loan after the third payment? ​
Thirteen semi-annual deposits are made earning interest of 6.3​% compounded semi-annually. The size of the first...
Thirteen semi-annual deposits are made earning interest of 6.3​% compounded semi-annually. The size of the first deposit is $1600 and the deposits increase at 3.2​% thereafter. a)Determine the total amount deposited b)how much was the accumulated value of the deposits just after the last deposits was made c)what is the size of the 11th deposits d)what is the amount of interest included in the accumulated value
What nominal rate per annum compounded weekly is equal to 9.5% p.a. compounded semi-annually?
What nominal rate per annum compounded weekly is equal to 9.5% p.a. compounded semi-annually?
A $5000 semi-annual coupon bond paying interest at 12.4%/year compounded semi-annually is redeemable at par in...
A $5000 semi-annual coupon bond paying interest at 12.4%/year compounded semi-annually is redeemable at par in 16 years. It is callable at 115 at the end of 8 years and at 111 at the end of 11 years. Determine the price to guarantee a yield rate of 13.4%/year compounded semi-annually.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT