Answer each question and show each step 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. \f34 33 45 0.2740942 12.334238 35 34 45 0.2635521 11.859844 36 35 45 0.2534155 11.403696 37 36 45 0.2436687 10.965092 38 37 45 0.2342968 10.543358 39 38 45 0.2252854 10.137844 40 39 45 0.2166206 9.7479273 41 40 45 0.208289 9.373007 42 41 45 0.2002779 9.0125067 43 42 45 0.1925749 8.6658719 44 43 45 0.1851682 8.3325691 45 44 45 0.1780463 8.0120857 46 45 45 0.1711984 7.7039285 47 46 45 0.1646139 7.4076236 48 47 45 0.1582826 7.122715 49 48 45 0.1521948 6.8487644 50 49 45 0.1463411 6.5853504 51 50 45 0.1407126 6.3320677 52 51 45 0.1353006 6.0885266 53 52 45 0.1300967 5.8543525 54 53 45 0.125093 5.6291851 55 54 45 0.1202817 5.412678 56 55 45 0.1156555 5.2044981 57 56 45 0.1112072 5.0043251 58 57 45 0.10693 4.811851 59 58 45 0.1028173 4.6267798 60 59 45 0.0988628 4.4488268 61 60 45 0.0950604 4.277718 95.060401 62Part Bond Price Expected Return Standard Deviation Cost of Preferred Stock Cost of Commeon Equity Value 1113.11744987238 6 115 10.9658560997306 54 0.1 0.165