Question

Your friend is asking a $55,000 loan from you with the following repayment schedule: End of...

Your friend is asking a $55,000 loan from you with the following repayment schedule: End of year 1 $ 0 End of year 2 $ 11,000 End of year 3 $ 22,000 End of year 4 $ 33,000 You demand at least 8% return on this loan deal. Given the repayment schedule, what will be the maximum loan amount you are willing to offer to the borrower for a break-even deal?

Homework Answers

Answer #1

In order to determine the break-even deal given the repayment schedule we need to find the present values of repayment @8%.

Thus;

Discounting factor=1/[(1+r)^n]

Thus, maximum loan that can be given is $51,151.02

If helpful, Thumbs UP please:)

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
1. a.) You loan a friend $200 and are repaid $30 at the end of each...
1. a.) You loan a friend $200 and are repaid $30 at the end of each month for the first 3 months and $120 at the end of the fourth month. What is your rate of return? b.) You loan a friend $200 and are repaid $120 at the end of the first month and $30 at the end of each month for the next three months. What is your rate of return? 2. You purchased stock 13 years ago...
Solve using excel You give a loan to your friend to buy equipment for his business....
Solve using excel You give a loan to your friend to buy equipment for his business. The friend puts $4000 of their own money as a down payment, you lend them $12,000. The equipment is $16,000 total. You will charge your friend 4.0% Interest every year and will collect monthly payments for 60 months. Inflation is 1.7% per year, constant for 5 years. a.) What is the NPV of the loan assuming it is paid each month on time? b.)...
Amortization Schedule Consider a $50,000 loan to be repaid in equal installments at the end of...
Amortization Schedule Consider a $50,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 9%. Set up an amortization schedule for the loan. Round your answers to the nearest cent. Enter "0" if required Year Payment Repayment Interest Repayment of Principal Balance 1 $   $   $   $   2 $   $   $   $   3 $   $   $   $   4 $   $   $   $   5 $   $   $   $   Total...
Complete an amortization schedule for a $46,000 loan to be repaid in equal installments at the...
Complete an amortization schedule for a $46,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 8% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Remaining Year Balance Payment Interest of Principal Balance 1 $   $   $   $   $   2                          3                          What percentage...
Complete an amortization schedule for a $44,000 loan to be repaid in equal installments at the...
Complete an amortization schedule for a $44,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 10% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Remaining Year Balance Payment Interest of Principal Balance 1 $   $   $   $   $   2                          3                          What percentage...
Complete an amortization schedule for a $19,000 loan to be repaid in equal installments at the...
Complete an amortization schedule for a $19,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 9% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $   $   $   $   $   2                          3                          What percentage...
Complete an amortization schedule for a $30,000 loan to be repaid in equal installments at the...
Complete an amortization schedule for a $30,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 9% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $   $   $   $   $   2                          3                          What percentage...
Complete an amortization schedule for a $39,000 loan to be repaid in equal installments at the...
Complete an amortization schedule for a $39,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 6% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Remaining Year Balance Payment Interest of Principal Balance 1 $   $   $   $   $   2                          3                          What percentage...
8) Complete an amortization schedule for a $43,000 loan to be repaid in equal installments at...
8) Complete an amortization schedule for a $43,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 8% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. Beginning Repayment Remaining Year Balance Payment Interest of Principal Balance 1 $   $   $   $   $   2                          3                          What...
1.Your grandparents fund an annuity for you that will pay you $5000 at the end of...
1.Your grandparents fund an annuity for you that will pay you $5000 at the end of each of the 4 years of your college. If the interest rate is 5% compounded annually, use the timeline illustration of the present value of an annuity to determine how much the grandparents must initially invest (present value) so you can enjoy their gift. 2. A business needs to borrow $24,000 for a building project. The manager of the business decides that he can...