Question

In: Finance

What is the outstanding balance after the 23rd payment interval of a 23 year loan of...

What is the outstanding balance after the 23rd payment interval of a 23 year loan of $15,000 with semi-annual payments and an interest rate of 6% compounded semi-annually? Calculate answer to 2 decimal places.

Solutions

Expert Solution

PV of annuity for making pthly payment
P = PMT x (((1-(1 + r) ^- n)) / i)
Where:
P = the present value of an annuity stream $      15,000
PMT = the dollar amount of each annuity payment To be computed
r = the effective interest rate (also known as the discount rate) 6.09% ((1+6%/2)^2)-1)
i=nominal Interest rate 6.00%
n = the number of periods in which payments will be made 23
15000= PMT x (((1-(1 + r) ^- n)) / i)
15000= PMT * (((1-(1 + 6.09%) ^- 23)) / 6%)
Annual payment= 15000/ (((1-(1 + 6.09%) ^- 23)) / 6%)
Annual payment= $   1,210.88
Semi-annual payment= $      605.44
FV of 23rd payments=
FV of annuity
The formula for the future value of an ordinary annuity, as opposed to an annuity due, is as follows:
P = PMT x ((((1 + r) ^ n) - 1) / i)
Where:
P = the future value of an annuity stream To be computed
PMT = the dollar amount of each annuity payment $   1,210.88
r = the effective interest rate (also known as the discount rate) 6.09%
i=nominal Interest rate 6.00%
n = the number of periods in which payments will be made 11.5 23/2
Future value of annuity payments= PMT x ((((1 + r) ^ n) - 1) / i)
Future value of annuity payments= 1210.88* ((((1 + 6.09%) ^ 11.5) - 1) / 6%)
Future value of annuity payments= $ 19,648.21
FV of loan= 15000*(1+6%/2)^23
FV of loan= $ 29,603.80
Remaining loan balance 29603.80-19648.21
Remaining loan balance $   9,955.59

Related Solutions

What is the outstanding balance after the 23rd payment interval of a 16-year loan of $14,734...
What is the outstanding balance after the 23rd payment interval of a 16-year loan of $14,734 with semi-annual payments and an interest rate of 6.0% compounded semi-annually?
What is the loan balance (in dollars) after the third payment, of a 5 year loan...
What is the loan balance (in dollars) after the third payment, of a 5 year loan of $100,000 with an APR of 10% and annual payments?
Calculate the loan balance after 6 years of payment of the following Balloon Payment Mortgage: 1...
Calculate the loan balance after 6 years of payment of the following Balloon Payment Mortgage: 1 million dollar loan Rate =5% annualized, monthly compounding Loan term = 25 years Amortization = balloon at the end of loan term of $300,000
Calculate the mortgage balance 25 days after the 45th payment on a mortgage loan of $200,000,...
Calculate the mortgage balance 25 days after the 45th payment on a mortgage loan of $200,000, amortised over 15 years at an interest rate of 5.75%.
A 10-year amortized loan of $100,000 with 5% APR requires yearly loan payment. After making four...
A 10-year amortized loan of $100,000 with 5% APR requires yearly loan payment. After making four yearly payments, the fourth year's ending loan balance is $Answer (don't include thousand separator( , ), rounding the number with two decimal places)
A $21,000 car loan is repaid with one payment of $26,533.47 after 36 months. What is...
A $21,000 car loan is repaid with one payment of $26,533.47 after 36 months. What is the annual effective discount rate? Round your answer to 3 decimal places. The effective annual rate of discount has been 6% for the last 3 years. Prior to that it was 5%. A bank account has a balance of $550 today. A single deposit of $X was placed in an account 8 years ago. Calculate the value of X. Given that i(m) = 0.216772...
An loan is paid in 3 years with monthly payment starting one month after the loan...
An loan is paid in 3 years with monthly payment starting one month after the loan is made. The payments are 540 each in the first year, and 900 per month in the second year, and 700 each in the last year. Interest is at a nominal rate of 7.8 percent convertible monthly. What is the outstanding balance after the 15th payment. Keep 4 decimal places only.
1. What would be the monthly payment on a 5 year loan of $35,000 if the...
1. What would be the monthly payment on a 5 year loan of $35,000 if the interest rate is 6.0% compounded monthly? 2. Sarah bought a raft for $664 using her credit card. The interst rate is 0.186 compounded monthly. If she pays $23 a month, how long will it take her to pay off the credit card? 3. What would be the monthly payment on a 5 year loan of $24,000 if the interest rate is 5.0% compounded monthly?
26.)What would be the monthly payment on a 5 year loan of $24,000 if the interest...
26.)What would be the monthly payment on a 5 year loan of $24,000 if the interest rate is 5.0% compounded montly? A. $452.91 B. $492.75 C. $377.42 D. $500.00 true or false: 27.)When doing a comparison of ratios for your company, the comparison probably should be with the industry average. 28.)When taking out a loan you would rather get an interest rate of 7% compounded monthly, instead of one compounded daily. 29.)Which of the following financial ratios are market-based ratios?...
Payment Cash Payment Effective Interest Decrease in balance Outstanding Balance 69,611 1 11,000 11,000 58,611 2...
Payment Cash Payment Effective Interest Decrease in balance Outstanding Balance 69,611 1 11,000 11,000 58,611 2 11,000 7,033 3,967 54,644 3 11,000 6,557 4,443 50,201 4 11,000 6,024 4,976 45,225 5 11,000 5,427 5,573 39,652 6 11,000 4,758 6,242 33,410 7 11,000 4,009 6,991 26,419 8 11,000 3,170 7,830 18,589 9 11,000 ? ? ? 10 11,000 ? ? ? What is the total effective interest paid over the term of the lease? Multiple Choice $110,000. $58,611. $69,611. $40,387.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT