Question

jed wants to borrow 1000 from me. he is proposing to repay me with 3 annual...

jed wants to borrow 1000 from me. he is proposing to repay me with 3 annual payments of 296.20 starting immediately. in addition, he will make a final lump sum payment of 180 three years from today. what rate of return am I earning on the loan ? percentage rounded to two decimal places

Homework Answers

Answer #1
year cash flow
0                   (703.80) (-1000+296.2)
1                     296.20
2                     296.20
3                     180.00
IRR =IRR (B2:B5) 5.20%
what rate of return am I earning on the loan 5.20%
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
Jed wants to borrow ​$1,000 from you. He is proposing to repay you with three annual...
Jed wants to borrow ​$1,000 from you. He is proposing to repay you with three annual payments of ​ $347.03 starting one year from now. In​ addition, he will make a final​ lump-sum payment of ​$120 three years from today. What rate of return are you earning on the​ loan? What rate of return are you earning on the​ loan?
You borrow $100,000 today. You will repay the loan with 20 equal annual payments starting in...
You borrow $100,000 today. You will repay the loan with 20 equal annual payments starting in year 3 If the interest rate on the loan is 5% APR, compounded annually, how big is each payment?
If you borrow $1,800 and agree to repay the loan in four equal annual payments at...
If you borrow $1,800 and agree to repay the loan in four equal annual payments at an interest rate of 10%, what will your payment be? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. What will your payment be if you make the first payment on the loan immediately instead of at the end of the first year? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
a. If you borrow $1,700 and agree to repay the loan in six equal annual payments...
a. If you borrow $1,700 and agree to repay the loan in six equal annual payments at an interest rate of 11%, what will your payment be? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. What will your payment be if you make the first payment on the loan immediately instead of at the end of the first year? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
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 are the loan officer of a bank. The ABC Company wants to borrow $100,000 and...
You are the loan officer of a bank. The ABC Company wants to borrow $100,000 and repay it with four equal annual payments (first payment due one year from now). You decide that the ABC Company should pay 0.10 per year on the loan. a. What is the annual payment? b. Complete the following debt amortization table: Period Amount owed(beginnig of yr) Interest Principal Amount owed(end of yr) 1 $100,000 2 3 4 c. What would be the annual payment...
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?
Albert and Allison borrow exactly the same amount from Liberty Financial. Albert will repay his loan...
Albert and Allison borrow exactly the same amount from Liberty Financial. Albert will repay his loan with 20 end of year annual payments. Albert’s first payment will be 1000, and each of his successive payments will be 1000 greater than the one before. Allison will make level payments of 50000 at times T,2T,3T,4T. Both Albert and Allison’s loans are subject to the same annual effective rate of 5%. Determine the time of Allison’s first payment. (a) 2.7-2.9 years (b) 3-3.2...
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?