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


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
A.) If you make quarterly payments of$331.00 into an ordinary annuity earning an annual interest rate...
A.) If you make quarterly payments of$331.00 into an ordinary annuity earning an annual interest rate of 5.47%, how much will be in the account after 4 years? B.) If you make monthly payments of $464.00 into an ordinary annuity earning an annual interest rate of 7.4% compounded monthly, how much will you have in the account after 5 years? After 9 years? C.) In 3 years Harry and Sally would like to have $26,000.00 for a down payment on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT