Question

In: Finance

a. If the loan was amortized over 3 years, how large would each annual payment be?

You want to buy a house that costs $140,000. You have $14,000 for a down payment, but your credit is such that mort- gage companies will not lend you the required $126,000. However, the realtor persuades the seller to take a $126,000 mortgage (called a seller take-back mortgage) at a rate of 5%, provided the loan is paid off in full in 3 years. You expect to inherit $140,000 in 3 years, but right now all you have is $14,000, and you can afford to make payments of no more than $22,000 per year given your salary. (The loan would call for monthly payments, but assume end-of-year annual payments to simplify things.)

a. If the loan was amortized over 3 years, how large would each annual payment be?
Could you afford those payments?
b. If the loan was amortized over 30 years, what would each payment be? Could you afford those payments?
c. To satisfy the seller, the 30-year mortgage loan would be written as a balloon note, which means that at the end of the third year, you would have to make the regular payment plus the remaining balance on the loan. What would the loan balance be at the end of Year 3, and what would the balloon payment be?

Solutions

Expert Solution

1.
=126000*5%/(1-1/1.05^3)=46268.2791435368

No cannot afford

2.
=126000*5%/(1-1/1.05^30)=8196.48082011485

Yes can afford

3.
=126000*(1+5%)^3-126000*5%/(1-1/1.05^30)*1/5%*(1.05^3-1)=120021.344214588

Loan balance=120021.344214588
Balloon payment=120021.344214588


Related Solutions

Determine the annual payment on a $19,500 loan that is to be amortized over a four-year...
Determine the annual payment on a $19,500 loan that is to be amortized over a four-year period and carries a 10 percent interest rate. Also prepare a loan amortization schedule for this loan.
Determine the annual payment on a $17,000 loan that is to be amortized over a four-year...
Determine the annual payment on a $17,000 loan that is to be amortized over a four-year period and carries a 10 percent interest rate. Also prepare a loan amortization schedule for this loan.
A loan of $330,000 is amortized over 30 years with payments at the end of each...
A loan of $330,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.9%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the...
A loan of $490,000 is amortized over 30 years with payments at the end of each...
A loan of $490,000 is amortized over 30 years with payments at the end of each month and an interest rate of 8.1%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the...
A loan is amortized over five years with monthly payments at an annual nominal interest rate...
A loan is amortized over five years with monthly payments at an annual nominal interest rate of 6% compounded monthly. The first payment is 1000 and is to be paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior payment. Calculate the outstanding loan balance immediately after the 40th payment is made.
QUESTION 1 A $150,000 loan is to be amortized over 7 years, with annual end-of-year payments....
QUESTION 1 A $150,000 loan is to be amortized over 7 years, with annual end-of-year payments. Which of these statements is CORRECT? a. The proportion of interest versus principal repayment would be the same for each of the 7 payments. b. The proportion of each payment that represents interest versus repayment of principal would be higher if the interest rate were higher. c. The proportion of each payment that represents interest as opposed to repayment of principal would be higher...
1. The payment made each period on an amortized loan is constant, and it consists of...
1. The payment made each period on an amortized loan is constant, and it consists of some interest and some principal. Which of the following statement is correct? 2. If a bank compounds savings accounts annually, the effective annual rate is greater than the nominal rate.   True   False 3. The present value of a future cash flow will be greater if we increase the discounted interest rate and compound more frequently.   True   False 4. A bank loan has annual percentage...
Loan payment:   Determine the​ equal, annual,​ end-of-year payment required each year over the life of the...
Loan payment:   Determine the​ equal, annual,​ end-of-year payment required each year over the life of the loan shown in the following table to repay it fully during the stated term of the loan.  ​(Click on the icon located on the​ top-right corner of the data table below in order to copy its contents into a​ spreadsheet.) Loan: Principal: Interest rate: Term of loan (years): A $12,000 8%    3 B $60,000 12% 10 C $75,000 10%    30 D $4,000...
A loan of $10,000 is amortized by equal annual payments for 30 years at an effective...
A loan of $10,000 is amortized by equal annual payments for 30 years at an effective annual interest rate of 5%. The income tax rate level is at 25%. Assume the tax on the interest earned is based on the amortization schedule. a) Determine the income tax in the 10th year b) Determine the total income taxes over the life of the loan c) Calculate the present value of the after-tax payments using the before-tax yield rate. Answer to the...
Consider a mortgage loan of $300,000, to be amortized over thirty years with monthly payments. If...
Consider a mortgage loan of $300,000, to be amortized over thirty years with monthly payments. If the annual percentage rate on this mortgage is 4% : What is the monthly payment on this loan? What is the balance of this loan AFTER the 14th payment is made? How much of the 8th payment is allocated to interest? How much of the 19th payment is allocated to principal?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT