Question

In: Finance

You take out a 40 year loan with effective annual interest i = 5% and yearly...

You take out a 40 year loan with effective annual interest i = 5% and yearly payments at the end of each year being $10,000 for the first 20 years, and then $15,000 for the next 20 years. Find the outstanding balance after the fourth payment. Also find the outstanding balance after the 37th payment.

Solutions

Expert Solution

a. Outstanding balance after 4th payment $ 1,94,013.93
Working:
Outstanding balance is the present value of remianing future payments.
Outstanding balance after 4th payment = Present value of 10,000 for first 16 years + Present value of 10,000 for next 20 years
= $                                                         1,08,377.70 + $                                                                85,636.23
= $                                                         1,94,013.93
Present Value of annuity of 1 for 16 years = (1-(1+i)^-n)/i Where,
= (1-(1+0.05)^-16)/0.05 i = 5%
= 10.83776956 n = 16
Present Value of 1 for 16 years = (1+i)^-n
= (1+0.05)^-16
= 0.458111522
Present Value of annuity of 1 for 20 years = (1-(1+i)^-n)/i Where,
= (1-(1+0.05)^-20)/0.05 i = 5%
= 12.46221034 n = 20
Present value of 10,000 for first 16 years = Annual payment for 16 years * Present Value of annuity of 1 for 16 years
= $                                                             10,000.00 * 10.83776956
= $                                                         1,08,377.70
Present value of 10,000 for next 20 years = Annual payment for 16 years * Present Value of annuity of 1 for 20 years * Present Value of 1 for 16 years
= $                                                             15,000.00 * 12.46221034 * 0.458111522
= $                                                             85,636.23
b. Outstanding balance after 37th payment $ 40,848.72
Working:
Outstanding balance is the present value of remianing future payments.
Outstanding balance after 37th payment = Present value of 15,000 for 3 years
= $                                                             15,000.00 *                                                                        2.72325
= $                                                             40,848.72
Present Value of annuity of 1 for 3 years = (1-(1+i)^-n)/i Where,
= (1-(1+0.05)^-3)/0.05 i = 5%
= 2.723248029 n = 3

Related Solutions

You take out a 40 year loan with effective annual interest i = .05 and yearly...
You take out a 40 year loan with effective annual interest i = .05 and yearly payments at the end of each year being $10, 000 for the first 20 years, and then $15, 000 for the next 20 years. Find the outstanding balance after the fourth payment. Also find the outstanding balance after the 37th 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 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.
You take out a 30-year $500,000 mortgage at an effective annual interest rate of 8%. Immediately...
You take out a 30-year $500,000 mortgage at an effective annual interest rate of 8%. Immediately after your 12th payment, you make an additional principal repayment of $50,000, and then refinance the outstanding balance with a new 15-yeatr mortgage at a 4% effective annual interest rate. Both mortgages require annual year-end level amortization payments. Find the amount of interest in the 5th payment of the new mortgage. PLEASE NO EXCEL!!!! :)
If you take out a car loan for $35,000, will pay an annual interest rate of...
If you take out a car loan for $35,000, will pay an annual interest rate of 4% on the loan, and make monthly payments of $547.58, how many payments will you need to make? -What are you solving for? -What is your answer?
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...
Build a short-term loan model, allowing terms out to 5 years. Take the term, annual interest...
Build a short-term loan model, allowing terms out to 5 years. Take the term, annual interest rate, and principal balance as inputs. Either calculate the required payment or use a payment input cell. Use your model to answer the following questions: - with a term of 5 years and a rate of 5%, what should payments be for a $10,000 loan - how many months will it take to pay off the loan if payments are $1,000 - if all...
Suppose that you take out a 30-year mortgage loan of $200,000 at an interest rate of...
Suppose that you take out a 30-year mortgage loan of $200,000 at an interest rate of 10%. What is your total monthly payment? How much of the first month’s payment goes to reduce the size of the loan? If you can afford to pay $2,000 per month, how long would it take you to pay for this loan (still at 10% interest)? If you can only pay $1,700 per month, and still want to finish paying in 30 years, what...
The effective semi-annual interest rate is 5%. The equivalent effective monthly rate is ___________ (Carry out...
The effective semi-annual interest rate is 5%. The equivalent effective monthly rate is ___________ (Carry out 4 places after the decimal point, and write the answer as a decimal)
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT