Question

A friend wants to borrow money from you. He states that he will pay you $3,600...

A friend wants to borrow money from you. He states that he will pay you $3,600 every 6 months for 11 years with the first payment exactly 4 years and six months from today. The interest rate is an APR of 5.9 percent with semiannual compounding. What is the value of the payments today?

Homework Answers

Answer #1

Here the problem needs two steps to solve.

First find the Present value of the amount after 4 years and six months.This can be found by using PV function in EXCEL

=PV(rate,nper,pmt,fv,type)

Here the interest is semi-annual compounding

rate=5.9%/2=2.95%

nper=2*11=22

pmt=3600

fv=0

=PV(2.95%,22,3600,0,0)

PV=$57,661.34

Again this amount, $57,661.34 has to discounted today from 4 and 6 months time

Value of today=PV/((1+r)^n)

r=2.95%

n=number of periods=9 (4 and 6 months =Total 9 periods)

Value of today=$57,661.34/((1+2.95%)^9)=$44,386.16

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A friend wants to borrow money from you. He states that he will pay you $3,800...
A friend wants to borrow money from you. He states that he will pay you $3,800 every 6 months for 13 years with the first payment exactly 6 years and six months from today. The interest rate is 6.1 percent compounded semiannually. What is the value of the payments today?
A friend wants to borrow money from you. He states that he will pay you $3,400...
A friend wants to borrow money from you. He states that he will pay you $3,400 every 6 months for 9 years with the first payment exactly 7 years and six months from today. The interest rate is 5.7 percent compounded semiannually. What is the value of the payments today? $32,128.58 $33,021.49 $35,079.17 $31,070.77 $31,956.28
A friend asks to borrow $ 47$47 from you and in return will pay you $...
A friend asks to borrow $ 47$47 from you and in return will pay you $ 50$50 in one year. If your bank is offering a 5.9 %5.9% interest rate on deposits and​ loans: a. How much would you have in one year if you deposited the $ 47$47 ​instead? b. How much money could you borrow today if you pay the bank $ 50$50 in one​ year? c. Should you loan the money to your friend or deposit it...
Your friend wants to borrow money from you. He proposes to repay his debt in 5...
Your friend wants to borrow money from you. He proposes to repay his debt in 5 monthly installments of $200, starting from month 4 (i.e., the first payment will occur at the end of month 4). If the monthly interest rate on your savings account is 1%, how much would you lend your friend at most? Round your result to the nearest cent, and do not use a $ sign (i.e., if the result is $1012.4671, enter it as 1012.47).
Your friend wants to borrow money from you. He proposes to repay his debt in 4...
Your friend wants to borrow money from you. He proposes to repay his debt in 4 monthly installments of $100, starting this month (i.e., the first payment will occur at the end of month 1). If the monthly interest rate on your savings account is 1.5%, how much would you lend your friend at most? Round your result to the nearest cent, and do not use a $ sign (i.e., if the result is $1012.4671, enter it as 1012.47)...
You raise some money today from your friend. He agrees to loan you the money you...
You raise some money today from your friend. He agrees to loan you the money you need, if you make payments of $40 a month for the next one year. In keeping with his reputation, he requires that the first payment be paid today. He also charges you 2 percent interest per month. How much money are you borrowing? ADue PV =
6. You loan some money to a friend and he agrees to pay you $200 at...
6. You loan some money to a friend and he agrees to pay you $200 at the end of each month for the next 2.5 years. Using a rate of 6.3%/year, calculate what this stream of anticipated payments from your friend is worth in today’s dollar terms. In other words, if your friend promises to make these payments, what would be a fair amount to loan to him today?
A friend asks to borrow $49 from you and in return will pay you $52 in...
A friend asks to borrow $49 from you and in return will pay you $52 in one year. If your bank is offering a. 6.1% interest rate on deposits and​ loans: a. How much would you have in one year if you deposited the $49 ​instead? b. How much money could you borrow today if you pay the bank $52 in one​ year? c. Should you loan the money to your friend or deposit it in the​ bank? a. How...
You have been accepted into college. The college guarantees that your tuition will not increase for...
You have been accepted into college. The college guarantees that your tuition will not increase for the four years you attend college. The first $10,000 tuition payment is due in six months. After that, the same payment is due every six months until you have made a total of eight payments. The college offers a bank account that allows you to withdraw money every six months and has a fixed APR of 3.9% (with semiannual compounding) guaranteed to remain the...
You have been accepted into college. The college guarantees that your tuition will not increase for...
You have been accepted into college. The college guarantees that your tuition will not increase for the four years you attend college. The first $ 10 comma 800 tuition payment is due in six months. After​ that, the same payment is due every six months until you have made a total of eight payments. The college offers a bank account that allows you to withdraw money every six months and has a fixed APR of 4.5 % ​(with semiannual​ compounding)...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT