Alexander takes out a 6-year loan L that he repays using the
amortization method. He makes monthly payments at a nominal annual
interest rate of 7.2% compounded monthly. The first payment is $700
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 loan amount and the outstanding loan balance after
the 46 th payment.
L= and B46=
NOTE:
Loan = PV(all the payments) and Outstanding Loan Balance = PV(all
remaining payments)
L=700[v+(0.97)v^2+.....+(0.97)71v^72]
B46=700[(0.97)^46v+(0.97)^47v^2.....+(0.97)^71v^26]
Alexander takes out a 6-year loan L that he repays using the amortization method. He makes...
A loan is amortized over 7 years, with monthly payments at a nominal rate of 9.5% compounded monthly. The first payment is $1000, paid one month from the date of the loan. Each succeeding monthly payment will be 3% lower than the prior one. What is the outstanding balance immediately after the 30th payment is made?
2. (25 Points) Suppose a borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a "teaser" rate of 4%, after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 7%. What would the Year 3 monthly payment be? (15 points) Step I Step2 PV= -179084.11 PV = -200 000 I= 7412=10.58) I=47212= 10.33) N= 336 N=360 130x2)...
Claire repays a loan to banker Maggie by amortization method at 6% effective. She makes 25 equal payments of $1000 at the end of each year. If the amount of interest in each payment is invested by Maggie at 6% effective as she receives the payments. What is the accumulated amount of the reinvested interest at the end of the 25th year?
A B C A borrower takes out a 29-year mortgage loan for $286,819 with an interest rate of 9%. What would the monthly payment be? A borrower takes out a 30-year mortgage loan for $190,372 with an interest rate of 8% and monthly payments. What portion of the first month's payment would be applied to interest? A borrower has a 25-year mortgage loan for $495,186 with an interest rate of 9% and monthly payments. If she wants to pay off...
Dave takes out a 23-year mortgage of 290000 dollars for his new house. Dave gets an interest rate of 14.4 percent compounded monthly. He agrees to make equal monthly payments, the first coming in one month. After making the 70th payment, Dave wants to buy a boat, so he wants to refinance his house to reduce his monthly payment by 400 dollars, and to get a better interest rate. In particular, he negotiates a new rate of 7.2 percent compounded...
AP10-1A (Journal entries for a loan) A company takes out a five-year, $1-million mortgage on October 1. The interest rate on the loan is 6% per year, and blended payments of $19,333 (including both interest and principal) are to be made at the end of each month. The following is an extract from the loan amortization table the bank provided the company: Beginning Loan Balance Ending Loan Balance Payment Interest Principal Payment 1 $19,333 $5,000 $1,000,000 985,667 $14,333 14,405 $985,667...
2. Amortization. Tanner has just begun paying off his student loans of $30,000 which he has decided to pay off over the next 15 years at an annual rate of 5%, compounded monthly, making monthly payments. Use an amortization table and present value tools to advise Tanner on the following: Answer Point Value Points Earned 2.a. What will Tanner's monthly payment be? Work: 2.b. How much of Tanner's first monthly payment will be applied to pay down the principle on...
Vanna has just financed the purchase of a home for $200 000. She agreed to repay the loan by making equal monthly blended payments of $3000 each at 4%/a, compounded monthly. a. Create an amortization table using a Microsoft Excel spreadsheet. In your answer include all the formulas used.b.How long will it take to repay the loan?c. How much will be the final payment?d. Determine how much interest she will pay for her loan.e. Use Microsoft Excel to graph the amortization...
Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Complete an amortization schedule for a $10,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 6% compounded annually. Round all answers to the nearest cent. Ending Beginning Balance Repayment of...
Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate. After 28 years, you would like to sell the property. What is your loan balance at the end of 28 years? Assume that you have a 30 year fully-amortized fixed rate mortgage for your home. Your loan amount is $300,000 with a 3% annual interest rate and your balloon payment is $50,000. What is your...