Question

In: Accounting

A biofuel subsidiary of Petrofac, Inc. is planning to borrow $12 million to acquire a small...

A biofuel subsidiary of Petrofac, Inc. is planning to borrow $12 million to acquire a small technology-based company. The rate of interest on a 5-year loan is highly variable; it could be as low as 7% or as high as 15%, but it is expected to be 10% per year. The company will only move forward with the acquisition offer if the AW is below $5.8 million. The M&O cost is fixed at $3.1 million per year. The anticipated sales price of the company could be $2 million if the interest rate is 7%, or as much as $2.5 million if the rate is 15%, but will most likely be about $2.35 million at a rate of 10% per year. Is the decision to move forward with the acquisition sensitive to the loan's interest rate and salvage value estimates?

The annual worth with a rate of 7% is $  .

The annual worth with a rate of 10% is $  .

The annual worth with a rate of 15% is $  .

The decision is  (Click to select)  not sensitive  sensitive  .

Solutions

Expert Solution

Answer:

a) Determine the Annual worth with a rate of 7%

We Know that,

Annual worth = -$12,000,000*A/P (7%, 5)-$3,100,000+$2,000,000*P/F (7% , 5)*A/P(7% , 5)

Consider A/p and P/F tables Where r=7% , n=5

The value of A/P (7%,5) = 0.2439

The value of P/F (7%,5) = 0.7130

Therefore,

Annual worth = -$12,000,000*0.2439-$3,100,000+$2,000,000*0.7130*0.2439

Annual worth = -$5,678,998.6

We know that Annual worth only accepts the positive values.

then,

Annual worth = $5,678,998.6

b) Determine the annual worth of rate 10%

We have,

Annual worth =-$12,000,000*A/P(10%, 5)-$3,100,000+$2,350,000*P/F(10% , 5)*A/P(10% , 5)

Consider A/p and P/F tables Where r=10% , n=5

The value of A/P (10%,5) = 0.2638

The value of P/F (10%,5) = 0.6209

Annual worth = -$12,000,000*0.2638-$3,100,000+$2,350,000*0.6209*0.2638

Annual worth = -$5,880,539.552

We know that Annual worth only accepts the positive values.

Therefore,

Annual worth = $5,880,539.552

c) Determine the annual worth of rate 15%

Annual worth = -$12,000,000*A/P(15% , 5)-$3,100,000+$2,500,000*P/F(15%, 5)*A/p(15%, 5)

Consider A/p and P/F tables Where r=15% , n=5

The value of A/P (15%,5) = 0.2983

The value of P/F (15%,5) = 0.4972

Annual worth = -$12,000,000*0.2983-$3,100,000+$2,500,000*0.4972*.0.2983

Annual worth = -$6,308,813.1

We know that Annual worth only accepts the positive values.

Therefore,

Annual worth = $6,308,813.1

d) The decision is Non sensitive


Related Solutions

Your company is planning to borrow $1.75 million on a 5-year, 12%, annual payment, fully amortized...
Your company is planning to borrow $1.75 million on a 5-year, 12%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Loan amount $1,750,000 Term in years 5 Annual coupon rate 12.00% Calculation of Loan Payment Formula Loan payment = #N/A Loan Amortization Schedule Year Beginning Balance Payment Interest Principal Ending Balance 1 2 3 4 5 Formulas...
A DI has $18 million in T-bills, a $12 million line of credit to borrow in...
A DI has $18 million in T-bills, a $12 million line of credit to borrow in the repo market, and $12 million in excess cash reserves with the Fed. The DI currently has borrowed $14 million in fed funds and $10 million from the Fed discount window to meet seasonal demands. a. What is the DI’s total available (sources of) liquidity? b. What is the DI’s current total uses of liquidity? c. What is the net liquidity of the DI?...
our company plans to borrow $12 million for 12 months, and your banker gives you a...
our company plans to borrow $12 million for 12 months, and your banker gives you a stated rate of 21 percent interest.      Calculate the effective rate of interest for the following types of loans.      a. Simple 21 percent interest with a compensating balance of 12 percent. (Use a 360-day year. Input your answer as a percent rounded to 2 decimal places.)    Effective rate of interest %       b. Discounted interest (with no compensating balance). (Input your...
A company is planning to borrow $120 million after three months for a period of six...
A company is planning to borrow $120 million after three months for a period of six months. The quote for the loan is LIBOR. The loan rate, LIBOR, will be determined at the start of loan and stay the same for its duration. Currently LIBOR is 3%. The company is willing to pay 3.25% fixed interest on the loan to avoid variable interest. Part a. Construct a Forward Rate Agreement (FRA) for the company. Part b. Should the company buy...
A company is planning to borrow $120 million after three months for a period of six...
A company is planning to borrow $120 million after three months for a period of six months. The quote for the loan is LIBOR. The loan rate, LIBOR, will be determined at the start of loan and stay the same for its duration. Currently LIBOR is 3%. The company is willing to pay 3.25% fixed interest on the loan to avoid variable interest. Part a. Construct a Forward Rate Agreement (FRA) for the company. Part b. Should the company buy...
Parent Inc. is contemplating a tender offer to acquire 80% of Subsidiary Corporation's common stock. Subsidiary's...
Parent Inc. is contemplating a tender offer to acquire 80% of Subsidiary Corporation's common stock. Subsidiary's shares are currently quoted on the New York Stock Exchange at $85 per share. In order to have a reasonable chance of the tender offer attracting 80% of Subsidiary's stock, Parent believes it will have to offer at least $105 per share. If the tender offer is made and is successful, the purchase will be consummated on January 1, 2017. A typical part of...
Please answer the following: Loan Amortization Your company is planning to borrow $1.5 million on a...
Please answer the following: Loan Amortization Your company is planning to borrow $1.5 million on a 7-year, 8%, annual payment, fully amortized term loan. What fraction of the payment made at the end of the second year will represent repayment of principal? Round your answer to two decimal places. Thank you!
InventBear Inc. is planning to establish a subsidiary in Australia to produce and sell gaming products...
InventBear Inc. is planning to establish a subsidiary in Australia to produce and sell gaming products locally. The project will end in three years and the subsidiary will be sold to an Australian firm for A$5 million at the end of the project. The salvage value is net of tax and will not be subject to withholding tax. InventBear estimates that, after paying for the income tax, the Australian subsidiary can remit A$5,450,000 to the parent every year for the...
Elvis Inc. is planning to establish a subsidiary in Australia to produce canola oil. The manufacturing...
Elvis Inc. is planning to establish a subsidiary in Australia to produce canola oil. The manufacturing facility will cost the parent company an initial investment of 5 million U.S. dollars (US$) to set up. The project will end in 3 years. At the end of the project, Elvis will sell the Australian subsidiary for A$8 million to an Australian agriculture firm. This amount is net of capital gain tax and is not subject to the withholding tax. Elvis estimates the...
4. Spartan Inc. (a US based MNC) is planning to open a subsidiary in Switzerland to...
4. Spartan Inc. (a US based MNC) is planning to open a subsidiary in Switzerland to manufacture shoes. The new plant will cost SF 1.0 billion. The salvage value of the plant at the end of the 4 yr economic life is estimated to be SF 200 million net of any tax effects. This plant will also call for extra inventory holding of SF 300 million, and extra accounts payables of SF 200 million. Projected sales from this new plant...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT