Question

In: Finance

Allysha just borrowed 38,900 dollars. She plans to repay this loan by making a special payment...

Allysha just borrowed 38,900 dollars. She plans to repay this loan by making a special payment of 5,100 dollars in 3 years and by making regular annual payments of 6,700 dollars per year until the loan is paid off. If the interest rate on the loan is 4.51 percent per year and she makes her first regular annual payment of 6,700 dollars in one year, then how many regular annual payments of 6,700 dollars must Allysha make? Round your answer to 2 decimal places (for example, 2.89, 14.70, or 6.00).

Solutions

Expert Solution

The future value of an amount today is given by

Future value = Present value *(1+interest rate )^years

As special payment is done in year 3, we will take every payment to year 3 and tale year 3 as focal point.

Value of loan in year 3 if no payment is done = loan amount*(1+interest)^3 = 38900*(1.0451)^3 = 44404.1074

Value of 1st 6700 payment at year 3 = 6700*(1.0451^2) = 7317.9679

Value of 2nd payment of 6700 in year 3 = 6700*(1.0451) = 7002.17

Value of third payment at year 3 = 6700

Also a special payment is made at year 3 of 5100.

Thus, loan balance at year 3 = value of loan at year 3 - payments

= 44404.1074 - 5100 - 6700 - 7002.17 - 7317.9679 = 18283.9695

Thus , loan balance at the end of 3 years is $ 18283.9695

To calculate how much more time is required to payoff, se Excel function = nper

=Nper(rate, pmt, pv,fv)

Rate is 4.51%, pmt is regular payments periodically of 6700, pv is present value of loan balance which is -18283.9695. It will be written negative as cash flow is opposite in sign for inflows and outflows.

=Nper(.0451,6700,-18283.9695) = 2.98

Thus, 2.98 years more is required for paying off the loan completely after 3 years.

Thus, total number of payments is 3+2.98 = 5.98.

Comment in case of any query.


Related Solutions

Allysha just borrowed 35,800 dollars. She plans to repay this loan by making a special payment...
Allysha just borrowed 35,800 dollars. She plans to repay this loan by making a special payment of 6,400 dollars in 5 years and by making regular annual payments of 6,300 dollars per year until the loan is paid off. If the interest rate on the loan is 8.2 percent per year and she makes her first regular annual payment of 6,300 dollars in one year, then how many regular annual payments of 6,300 dollars must Allysha make? Round your answer...
35. Cara just borrowed 245,758 dollars. She plans to repay this loan by making a special...
35. Cara just borrowed 245,758 dollars. She plans to repay this loan by making a special payment of 33,047 dollars in 6 years and by making regular annual payments of 28,962 dollars per year until the loan is paid off. If the interest rate on the loan is 6.29 percent per year and she makes her first regular annual payment of 28,962 dollars immediately, then how many regular annual payments of 28,962 dollars must Cara make? Round your answer to...
36. Allysha just borrowed 39,900 dollars. She plans to repay this loan by making a special...
36. Allysha just borrowed 39,900 dollars. She plans to repay this loan by making a special payment of 5,000 dollars in 5 years and by making regular annual payments of 7,900 dollars per year until the loan is paid off. If the interest rate on the loan is 4.79 percent per year and she makes her first regular annual payment of 7,900 dollars in one year, then how many regular annual payments of 7,900 dollars must Allysha make? Round your...
Celeste just borrowed 47,700 dollars. She plans to repay this loan by making equal quarterly payments...
Celeste just borrowed 47,700 dollars. She plans to repay this loan by making equal quarterly payments of 2,271.5 dollars for 27 quarters. If she makes her first quarterly payment later today, then what is the quarterly interest rate on the loan? Answer as a rate in decimal format so that 12.34% would be entered as .1234 and 0.98% would be entered as .0098.
Answer all please 1.Allysha just borrowed 48,100 dollars. She plans to repay this loan by making...
Answer all please 1.Allysha just borrowed 48,100 dollars. She plans to repay this loan by making a special payment of 5,200 dollars in 3 years and by making regular annual payments of 6,700 dollars per year until the loan is paid off. If the interest rate on the loan is 9.99 percent per year and she makes her first regular annual payment of 6,700 dollars in one year, then how many regular annual payments of 6,700 dollars must Allysha make?...
Franz just took out a loan from the bank for 227,674 dollars. He plans to repay...
Franz just took out a loan from the bank for 227,674 dollars. He plans to repay this loan by making a special payment to the bank of 36,888 dollars in 5 months and by also making equal, regular monthly payments of X. If the interest rate on the loan is 1.06 percent per month, he makes his first regular monthly payment later today, and he makes his last regular monthly payment made in 9 months from today, then what is...
Omar just took out a loan from the bank for 151,051 dollars. He plans to repay...
Omar just took out a loan from the bank for 151,051 dollars. He plans to repay this loan by making a special payment to the bank of 25,246 dollars in 7 months and by also making equal, regular monthly payments of X. If the interest rate on the loan is 1.15 percent per month, he makes his first regular monthly payment later today, and he makes his last regular monthly payment made in 9 months from today, then what is...
You have just borrowed $300,000 to buy a condo. You will repay the loan in equal...
You have just borrowed $300,000 to buy a condo. You will repay the loan in equal monthly payments of $3,950.37 over the next 20 years. a-1. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) b. What is the effective annual rate on that loan? (Do...
You have just borrowed $160,000 to buy a condo. You will repay the loan in equal...
You have just borrowed $160,000 to buy a condo. You will repay the loan in equal monthly payments of $1,287.40 over the next 30 years. a-1. What monthly interest rate are you paying on the loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) a-2. What is the APR? (Do not round intermediate calculations. Enter your answer as a whole percent.) b. What is the effective annual rate on that loan? (Do...
You have just borrowed $100,000 to buy a condo. You will repay the loan in equal...
You have just borrowed $100,000 to buy a condo. You will repay the loan in equal monthly payments of $804.62 over the next 30 years. a. What monthly interest rate are you paying on the loan?' b. What is the APR? c. What is the effective annual rate on that loan? d. What rate is the lender more likely to quote on the loan?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT