Determine the internal rate of return

Assignment Help Financial Management

Reference no: EM131620565

On January 15, a firm takes out a loan of $30 million, with interest payments to be made on April 16, July 15, October 14, and the following January 15, when the principal will be repaid. Interest will be paid at LIBOR based on the rate at the exact number of days and 360-day year. The firm wants to buy a cap with an exercise rate of 10 percent and a premium of $125,000 but is concerned about the cost. Its bank suggests that the firm sell a floor with an exercise rate of 9 percent for the same premium. The current LIBOR is 10 percent. Determine the firm’s cash flows on the loan if LIBOR turns out to be 11.35 percent on April 16, 10.2 percent on July 15, and 8.86 percent on October 14. If you have a financial calculator or spreadsheet, determine the internal rate of return and annualize it to determine the cost of borrowing.

Interest Cap Floor Principal With Collar

Date Days LIBOR Payment Payment Payment Repayment Net Cash Flow

1/15 –– 10.00 $125,000 –125,000 125,000 0 30,000,000

4/16 91 11.35

7/15 90 10.20

10/14 91 8.86

1/15 93 ––

Reference no: EM131620565

Questions Cloud

Find the two-year loss for triple m motors : In a recent year Valero Energy had revenue of $118,298 million and a loss of $1,131 million. If Expenses Revenue Profit, find the expenses for Valero Energy.

What were the tanzimat reforms : What were the Tanzimat Reforms and were they effective in allowing the Middle East to catch up to the West?

A bankruptcy process is complex and time-consuming : A bankruptcy process is complex, time-consuming, and costly. The costs of bankruptcy include

How many rolls of plastic can be produced : A plastic film machine can produce 75 rolls of plastic in an hour. How many rolls of plastic can be produced by the machine in a 24-hour period?

Determine the internal rate of return : determine the internal rate of return and annualize it to determine the cost of borrowing.

The black lives matter movement is the new civil rights : The Civil Rights Act of 1964 ended discrimination against minorities but do you think the Black Lives Matter Movement is the new Civil Rights Movement?

How many of each item remained in inventory : Malina Kodama creates 48 pottery coffee cups and 72 pottery bowls in a day. How many can be produced in a 22-day month? If 809 coffee cups and 1,242 bowls.

Describe the type of culture depicted in this film : Describe the type of "culture" depicted in this film.How are concepts of race, class, gender, and sexuality position in this film?

What was his total loss on the stock : Hasan's Electronic Shop is overstocked with 456 USB cables and sells them to a discount house at a $4 loss ($4). What is his total loss on the sale?

User Account

All Pages