Question

In: Finance

•Assume you borrow from the bank $5,000,000. Assume you make quarterly payments. Further assume that the...

•Assume you borrow from the bank $5,000,000. Assume you make quarterly payments. Further assume that the stated coupon rate is 9% per annum and the loan matures in 12 years. Determine the interest and principal payment for year 5.

• Assume you borrow from the bank $5,000,000. Assume you make quarterly payments. Further assume that the stated coupon rate is 9% per annum and the loan matures in 12 years. You also make a balloon payment of $1,000,000 in the last quarter. Determine the interest and principal payment for year 5.

Solutions

Expert Solution

•Assume you borrow from the bank $5,000,000. Assume you make quarterly payments. Further assume that the stated coupon rate is 9% per annum and the loan matures in 12 years. Determine the interest and principal payment for year 5.

Interest in year 5 = $337707.23

Principal in year 5 = $347939.32

• Assume you borrow from the bank $5,000,000. Assume you make quarterly payments. Further assume that the stated coupon rate is 9% per annum and the loan matures in 12 years. You also make a balloon payment of $1,000,000 in the last quarter. Determine the interest and principal payment for year 5.

Interest in year 5 = $360165.79

Principal in year 5 = $278351.46

* it is supposed to be APR per quarter

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years.
Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years. There is a balloon payment of $1,000,000 at the end of year 8. Determine annual interest and principal payment for each year. Please make sure your answer includes a separate statement as to the exact principal payment in year 8.
Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years.
Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years. There is a balloon payment of $1,000,000 at the end of year 8. Determine annual interest and principal payment for each year. Please make sure your answer includes a separate statement as to the exact principal payment in year 8. How to do this in excel?
Assume a coupon of 6%. You borrow $10 million from the bank and you make annual...
Assume a coupon of 6%. You borrow $10 million from the bank and you make annual payments over 8 years. There is a balloon payment of $1,000,000 at the end of year 8. Determine annual interest and principal payment for each year. Please make sure your answer includes a separate statement as to the exact principal payment in year 8.
You need to borrow money today from your father. You can make payments like this: 1st...
You need to borrow money today from your father. You can make payments like this: 1st year: $1000, 2nd year: $2,000, 3rd year: $3,000, 4th year: $4,000, 5th year: $5,000. Your dad says that hes getting 4% on his CDs, compounded annually, and you'll need to pay him the same rate. How much can you borrow?
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)?
5. You have a bank loan at 6.75%, compounded monthly with quarterly payments. What is the...
5. You have a bank loan at 6.75%, compounded monthly with quarterly payments. What is the effective interest rate per payment period? 6. You lent $500 to your friend at 10% compounded every 2 months. You have asked her to pay the money back at the end of one year and to make an interest payment every six months (one at the 6 month mark and one at the end). What is the effective interest rate per payment period? 7....
You would like to borrow $300,000.00 to finance a home. You wish to make monthly payments...
You would like to borrow $300,000.00 to finance a home. You wish to make monthly payments for 15 years. If the annual interest rate (APR) is quoted at 5.3%. What will the monthly payments be?
You would like to borrow $200,000.00 to finance a home. You wish to make monthly payments...
You would like to borrow $200,000.00 to finance a home. You wish to make monthly payments for 15 years. If the annual interest rate (APR) is quoted at 8.4%. What will the monthly payments be? Refinance the loan after you have made 84 payments. First what is remaining balance that is owed. Second If the new interest rate (APR) is 4% and n will be based on the remaining time period of the original loan what will be the new...
You borrow $5,530 to purchase furniture for your house. You agree to make monthly payments for...
You borrow $5,530 to purchase furniture for your house. You agree to make monthly payments for 4 years to pay for the furniture. If the interest rate is 5 percent with monthly compounding, how much are your monthly payments? Assume the first payment is made one month after purchase. $103.95 $123.18 $127.35 $104.31 $121.90
You are running a bank and a customer wants to borrow $2m from the bank starting...
You are running a bank and a customer wants to borrow $2m from the bank starting in 207 days and ending in 321 days. You charge interest on an ACT/360 basis and will set the rate at 0.61% above fair. Interest rates are: Days Cont. Comp. Rates 207 3.28 321 3.93 What rate do you charge? Give your rate to 2 decimal places and enter 3.05% as 3.05.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT