# Project #21324 - Business Finance 1

It needs to be done on excel. can u help?

1. A Zero Coupon Bond, Face Value €7.000,oo, Maturity 2 years. Required Rate by investor is 9%

1.1. And if the bond has constant semiannual coupon rate 3%

1.2. And if coupons grow every semester 0,5% ?
1.2.1.Calculate the Price today for these 3 alternatives, and then probe it. 1.2.2.At what discount are traded these bonds
1.2.3.At what Price are traded these bonds

2. Calculate What is the original maturity (in moths) for a Zero Coupon Bond, Face Value 2.500,00€, required rate of return 16% EAR if we paid 700,00€ and we bought it 6 month after the issuance, and actually we made an instant profit of 58,97€.
2.1. Calculate it price today

2.2. Calculate it again
2.3. And now Probe it
2.4. At what discount are traded these bonds 2.5. At what Price are traded these bonds

3. Our company has issued Zero coupons bonds, Face Value €5.000,oo, maturity 2 years, and we received an offer (bid) for €3.800,oo
3.1. What is the rate required by this investor?
3.2. At what discount are traded these bonds

3.3. At what Price are traded these bonds

4. Our company has issued monthly coupons bonds (coupon rate 0,25%), Face Value €2.000,oo, maturity 3 years, and we received an offer (bid) for €1.900,oo
4.1. What is the rate required by this investor?
4.2. At what discount are traded these bonds

4.3. At what Price are traded these bonds

5. We need to buy a machine, which price is €19.000,oo. La Caixa is going to fund 90% of this price at a rate of 12%, the maturity is 5 years, quarterly payments.

1. 5.1.  How much is each quarterly payment?

2. 5.2.  If we decide, just in the middle of the maturity, to make a lump sum payment, how much should it be?

 Subject Mathematics Due By (Pacific Time) 01/23/2014 12:00 pm
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews