Question

In: Finance

You decided to borrow $20,000and make payments at the end of each month for 10years. The...

You decided to borrow $20,000and make payments at the end of each month for 10years. The maximum monthly payment you can afford is $1000. What is the maximum interest rate you can afford(keep two decimal places)? What is the maximum interest rate you can afford if you are making payments at the beginning of each month for 10 years (keep two decimal places)?

Solutions

Expert Solution

1.Information provided:

Present value= $20,000

Time= 10 years*12= 120 months

Monthly payment= $1,000

The question pertains to ordinary annuity which is computed with the help of a financial calculator in the default END mode.

The question is computed by calculating the yield to maturity.

The yield to maturity is calculated by entering the below in a financial calculator:

PV= -20,000

PMT= 1,000

N= 120

Press the CPT key and I/Y to compute the yield to maturity.

The value obtained is 4.9854.

Therefore, the maximum interest rate I can afford if I make monthly payments at the end of a month is 4.99%.

2.Information provided:

Present value= $20,000

Time= 10 years*12= 120 months

Monthly payment= $1,000

The question pertains to annuity due. Annuity due refers to annuity that occurs at the beginning of a period.

This can also be solved using a financial calculator by inputting the below into the calculator in BGN mode:

The financial calculator is set in the end mode. Annuity due is calculated by setting the calculator to the beginning mode (BGN). To do this, press 2ndBGN 2ndSET on the Texas BA II Plus calculator.

The yield to maturity is calculated by entering the below in a financial calculator:

PV= -20,000

PMT= 1,000

N= 120

Press the CPT key and I/Y to compute the yield to maturity.

The value obtained is 5.25.

Therefore, the maximum interest rate I can afford if I make monthly payments at the beginning of a month is 5.25%.


Related Solutions

You borrow money on a self liquidating installemnt loan (equal payments at the end of each...
You borrow money on a self liquidating installemnt loan (equal payments at the end of each year, each payment is part principal part interest) Loan $708,000 Interest Rate 16.10% Life (years) 51 Date of Loan January 1, 2020 Use the installment method - not straight line Do NOT round any interrmediate numbers. Do NOT turn this into a monthly problem. a) What is the annual payment? b) What are the total interest payments? c) After 21 payments have been made,...
You borrow money on a self liquidating installemnt loan (equal payments at the end of each...
You borrow money on a self liquidating installemnt loan (equal payments at the end of each year, each payment is part principal part interest) Loan $318,000 Interest Rate 13.20% Life (years) 58 Date of Loan January 1, 2020 Annual Payment: 6206.484138 Use the installment method - not straight line Do NOT round any interrmediate numbers. Do NOT turn this into a monthly problem. a) What is the annual payment? b) What are the total interest payments? c) After 25 payments...
Payments of $1100 per month are deposited into a fund at the end of each month...
Payments of $1100 per month are deposited into a fund at the end of each month for 11 years. If interest is 11.2% p.a. compounding monthly, the size of the fund at the end of 11 years will be (to nearest dollar but don’t include $ sign or commas):
You make deposits at the end of each month into an account earning interest at a...
You make deposits at the end of each month into an account earning interest at a rate of 6%/year compounded monthly. Your deposits will be $2000/month in the first year, $2200/month in the second year, $2420/month in the third year, $2662 in the fourth year, and so on. How much will be in your account at the end of 40 years? No Excel answers please.
You're prepared to make monthly payments of $380, beginning at the end of this month, into...
You're prepared to make monthly payments of $380, beginning at the end of this month, into an account that pays 8 percent interest compounded monthly. How many payments will you have made when your account balance reaches $22,992? Multiple Choice 56.1 45.9 51 22.93 4.4
You're prepared to make monthly payments of $390, beginning at the end of this month, into...
You're prepared to make monthly payments of $390, beginning at the end of this month, into an account that pays 5 percent interest compounded monthly. Required: How many payments will you have made when your account balance reaches $25,528? (Do not round your intermediate calculations.)
You're prepared to make monthly payments of $340, beginning at the end of this month, into...
You're prepared to make monthly payments of $340, beginning at the end of this month, into an account that pays 6 percent interest compounded monthly. How many payments will you have made when your account balance reaches $20,575?
You’re prepared to make monthly payments of $270, beginning at the end of this month, into...
You’re prepared to make monthly payments of $270, beginning at the end of this month, into an account that pays 6.8 percent interest compounded monthly.    How many payments will you have made when your account balance reaches $18,000? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
You're prepared to make monthly payments of $320, beginning atthe end of this month, into...
You're prepared to make monthly payments of $320, beginning at the end of this month, into an account that pays 9 percent interest compounded monthly. How many payments will you have made when your account balance reaches $20,260?
2. You just took a $315,000, 30-year loan. Payments at the end of each month are...
2. You just took a $315,000, 30-year loan. Payments at the end of each month are flat (equal in every month) at an annual interest rate of 3.75 percent. a)Calculate the monthly payment. b)Provide the appropriate loan table, showing the breakdown in each month between principal repayment and interest. (PLEASE SHOW STEP-BY-STEP EXCEL FORMULA WITH FUNCTIONS)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT