Solving rate of return with excel

Reference no: EM13115354

Here is the info I have for the problem I need to solve:

You have two investment opportunities. One will have a 10% rate of return on an investment of $500; the other will have an 11% rate of return on a principal of $700.

You would like to take an advantage of the higher yield investment but have only $500 available.

What is the maximum rate of return that you would pay to borrow the $200 need to take advantage of the high yield investment?

Reference no: EM13115354

Questions Cloud

Transaction fee of underwriting : Sherman Brothers, Inc., sold 4 million shares in its IPO, at a price of $18.50 per share. Management negotiated a fee (the underwriting spread) of 7% on this transaction.

Determining holding period return : The return an investor earns on a bond over a period of time is known as the holding period return, defined as interest income plus or minus the change in the bond's price, all , all divided by the beginning bond price.

Weighted average costs of capital of china corporation : China Corp. has a current capital structure of $18 million in secured bonds paying 6.5% annual interest, $8 million in preferred stock with a par value of $50 per share and an annual dividend of $3.80 per share

How many liters of o2 can be made : how many liters of o2 can be made from 342g H2o2 if the density of o2 is 1.428g.

Solving rate of return with excel : You have two investment opportunities. One will have a 10% rate of return on an investment of $500; the other will have an 11% rate of return on a principal of $700.

What do you think : Do you think a comparable spill of a water-insoluble liquid that has a density of 1.20g/mL would have been as harmful to waterfowl and aquatic mammals.

Calculate the final temperature of the mixture : A 17.0-g sample of ice at -19.0°C is mixed with 101.0 g of water at 87.0°C. Calculate the final temperature of the mixture assuming no heat loss to the surroundings.

Computing stock and portfolio beta : There are two stocks, stock A and stock B. The price of stock A today is $70. The price of stock A next year will be $50 if the economy is in recession, $80 if the economy is normal and $95 if the economy is expanding.

Price of bond of gator corporation : The Florida Investment Fund buys 90 bonds of the Gator Corporation through a broker. The bonds pay 8 percent annual interest.

User Account

All Pages