I need upload this assignment on Saturday. The book is Principles of Cooperate Finance. All the exercises must be done in excel.

1. In February 2009 Treasury 6s of 2026 offered a semiannually compounded yield of 3.5965%. Recognizing that coupons are paid semiannually, calculate the bond's price. 3. 10-year German government bond (bund) has a face value of 100 and a coupon rate of 5% paid annually. Assume that the interest rate (in euros) is equal to 6% per year. What is the bond's PV? 4. Calculate the IRR (or IRRs) for the following project: C0 -3000 C1 3500 C2 4000 C3 -4000 For what range of discount rates does the project have positive NPV? 5. The Titanic Shipbuilding Company has a noncancelable contract to build a small cargo vessel. Construction involves a cash outlay of $250,000 at the end of each of the next two years. At the end of the third year the company will receive payment of 6. CSC is evaluating a new project to produce encapsulators. The initial investment in plant and equipment is $500,000. Sales of encapsulators in year 1 are forecasted at $200,000 and costs at $100,000. Both are expected to increase by 10% a year in line with inflation. Profits are taxed at 35%. Working capital in each year consists of inventories of raw materials and is forecasted at 20% of sales in the following year. The project will last five years and the equipment at the end of this period will have no further value. For tax purposes the equipment can be depreciated straight-line over these five years. If the nominal discount rate is 15%, show that the net present value of the project is the same whether calculated using real cash flows or nominal flows. 7. 8. United Pigpen is considering a proposal to manufacture high-protein hog feed. The project would make use of an existing warehouse, which is currently rented out to a neighboring firm. The next year's rental charge on the warehouse is $100,000, and thereafter the rent is expected to grow in line with inflation at 4 percent a year. In addition to using the warehouse, the proposal envisages an investment in plant and equipment of $1.2 million. This could be depreciated for tax purposes straight-line over 10 years. However, Pigpen expects to terminate the project at the end of eight years and to resell the plant and equipment in year 8 for $400,000. Finally, the project requires an initial investment in working capital of $350,000. Thereafter, working capital is forecasted to be 10 percent of sales in each of years 1 through 7. Year 1 sales of hog feed are expected to be $4.2 million, and thereafter sales are forecast to grow by 5 percent a year, slightly faster than the inflation rate. Manufacturing costs are expected to be 90 percent of sales, and projects are subject to tax at 35 percent. The cost of capital is 12 percent What is the NPV of Pigpen's project