Answer each question and show all your steps and work on excel.

Answer each question and show all your steps and work on excel. Part 1. Calculate the price of a bond that has a semi-annual coupon rate of 9% per year, has a face value of $1,000, matures in 30 years, and is priced to have a yield to maturity of 8%? Part 2. Calculate the yield to maturity (YTM) for a bond with a face value of $1,000 and a semi-annual coupon of $90 per year. The bond is currently selling for $1,050 and matures in 25 years. Part 3. Calculate the expected return and standard deviation of the investment in the table below. State of the economy | Probability | Expected rate of return Good 30% 20% Average 50% 15% Bad 20% -10% Use the following information for Parts 4 through 6. A company has $100 million in capital. 40% of the capital was borrowed by issuing bonds. The bonds are currently trading at $950 each. The semiannual coupon rate on the bonds is 7% and they mature in 25 years. The face value of the bonds is $1,000 each. The current tax rate is 40%. The company also raised capital by issuing common equity. The current stock price is $40. Next year's dividends are expected to be $5 per share and are expected to have a constant growth rate of 4% per year. The common equity represents 55% of the company's capital. The rest of the capital, 5%, was obtained by issuing preferred stock. The preferred dividends are $10 per share per year. The price of the preferred stock is $100 per share. Part 4. Calculate the cost of debt for the company. Part 5. Calculate the cost of preferred stock for the company. Part 6. Calculate the cost of common equity for the company. Part 7. A company is evaluating a 10-year project with the following project with an initial investment of $3,5000,000. The forecasted annual cash flows are $550,000 and the cost of capital, WACC, for this firm is 10%. Part a. Calculate the NPV of the project show all the calculator or Excel entries. Part b. Calculate the IRR of the project show all the calculator or Excel entries. Part 8. A company is evaluating the purchase of one of two trucks for a project. Truck A has a price of $150,000 and will cost $3,000 per year to operate; truck B has a price of $140,000 and will cost $5,000 per year to operate. Use the one best method to rank the two trucks and recommend one to purchase. The life of the project is 5 years. The cost of capital for the project is 10%. Part 9. Calculate the stock price for a company with expected dividends of $4 dividends per share. The dividends are expected to grow at a rate 3% per year and the required return on equity is 9%. Part 10. A portfolio has the following features and components. Security | Investment | Beta (B) | Expected return | Standard deviation A $425 1.2 15% 16% B $625 0.9 12% 14% Calculate the expected return and beta () of the portfolio. After-tax cost of debt - YTM x (1 - tax rate) - 7.42% x (1 - 0.40) - 4.45% So, the cost of debt is 4.45% after taxes