Question

In: Accounting

Given a loan with the following characteristics: Co = 50,000€ Annual effective interest 6% to be...

Given a loan with the following characteristics:

Co = 50,000€

Annual effective interest 6% to be amortized in 6 years, and knowing it is a level-fixed payment-rate loan.

Just before making the payment of the second annuity, it is decided to change the amortization method, starting to be amortized through constant principal repayments loan.

a) Outstanding debt just after making the payment of the 3th annuity

b) Amortization schedule for the last 3 years

Solutions

Expert Solution

a

Yearly payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                            50,000
Rate of interest per period:
Annual rate of interest 6.000%
Frequency of payment = Once in 12 month period
Numer of payments in a year = 12/12 = 1
Rate of interest per period R 0.06 /1 = 6.0000%
Total number of payments:
Frequency of payment = Once in 12 month period
Number of years of loan repayment =                                                                          6
Total number of payments N 6 × 1 = 6
Period payment using the formula = [ 50000 × 0.06 × (1+0.06)^6] / [(1+0.06 ^6 -1]
Yearly payment = $                                                      10,168.13
Period Beginning liability Uniform monthly payment Interest owed Principal payment Total owed at end of month
N A C B= A* 0.060000 D=C-B E=A-D
1              50,000.00     10,168.13             3,000.00       7,168.13        42,831.87
2              42,831.87     10,168.13             2,569.91       7,598.22        35,233.65

Balance after second payment is $35,233.65

Third payment will consist of 35,233.65/3 = 11,744.55 principal

Outstanding debt then = 23,489.10

b

Period Beginning liability Payment Interest owed Principal payment Total owed at end of month
N A C B= A* 0.060000 D=C-B E=A-D
1              35,233.65     13,858.57             2,114.02     11,744.55        23,489.10
2              23,489.10     13,153.90             1,409.35     11,744.55        11,744.55
3              11,744.55     12,449.22                704.67     11,744.55                       -  

please rate.


Related Solutions

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...
4) The effective annual interest rate is 6%. A 30 year loan is repaid as follows...
4) The effective annual interest rate is 6%. A 30 year loan is repaid as follows (payments starting at the end of the first year): For the first 10 years, interest only. For the second 10 years, each payment is twice the interest due in that period. For the final 10 years, level payments of X per year. Find the outstanding balance at the end of each 10 year period, and find X. (Optional: do it without using a spreadsheet.)
Madelyn has a loan to be repaid by 16 annual payments at an effective annual interest...
Madelyn has a loan to be repaid by 16 annual payments at an effective annual interest rate of 5%. Payments 1-10 are $600 each, payments 11-14 are $380 each, and the last 2 payments are $570 each. The interest portion in Madelyn's 13th payment is?
Madelyn has a loan to be repaid by 16 annual payments at an effective annual interest...
Madelyn has a loan to be repaid by 16 annual payments at an effective annual interest rate of 5%. Payments 1-10 are $600 each, payments 11-14 are $380 each, and the last 2 payments are $570 each. The interest portion in Madelyn's 13 th payment is? (I have already posted this question and they got 21.95%, which is incorrect!)
Red Sea Co. obtained a $200,000 loan from ANB bank at 6% annual interest rate that...
Red Sea Co. obtained a $200,000 loan from ANB bank at 6% annual interest rate that will be paid off in annual payments over ten years. How much will each annual payment be?
The three little pigs received a loan for $10000 at an effective annual interest rate of...
The three little pigs received a loan for $10000 at an effective annual interest rate of 8% from BBW Bank to make repairs on their brick house. They will repay the loan, starting one year after the loan was disbursed, by making annual payments equal to 7 times the amount of interest due until they can make a final payment of no more than $500. Determine how many payments they will make and the amount of the final payment. (3...
The three little pigs received a loan for $9000 at an effective annual interest rate of...
The three little pigs received a loan for $9000 at an effective annual interest rate of 4% from BBW Bank to make repairs on their brick house. They will repay the loan, starting one year after the loan was disbursed, by making annual payments equal to 6 times the amount of interest due until they can make a final payment of no more than $475. Determine how many payments they will make and the amount of the final payment. (a)...
A 20 year loan of $50, 000 is taken out at effective annual interest i =...
A 20 year loan of $50, 000 is taken out at effective annual interest i = 6% for the first 10 years and then i = 7% for the next 10 years. Payments are constant at the end of each year. Find the outstanding balance after the 16th payment.
A 20 year loan of $50, 000 is taken out at effective annual interest i =...
A 20 year loan of $50, 000 is taken out at effective annual interest i = 6% for the first 10 years and then i = 7% for the next 10 years. Payments are constant at the end of each year. Find the outstanding balance after the 16th payment.
a. What is the effective annual interest rate (EAR) of the APR of 10.5% given that...
a. What is the effective annual interest rate (EAR) of the APR of 10.5% given that it is compounded quarterly? Monthly? Annually? Daily? b. If you purchase a new home for $250,000 today, what is your monthly payment if you have to pay 4.25% annual interest compounded monthly? Assume a 30‐year fixed mortgage (360 months) and 25% down on the home (this is of the purchase price above).
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT