1. Assignments must be done individually 2. Sloppy work is not accepted! Assignments must be done using Microsoft Excel and Word. 3. The deadline for the assignment is 27th November 2020, Friday (before 12:30). 4. You must submit your files via Microsoft Teams. Question (1): As a financial manager of the Alpha investment group, you are required to rank the bonds presented on the basis of YTM/YTC. Information on the bonds are provided below. Prepare your list from the best to worse and explain your reason for that. Seiko's bond has 20 year maturity, 9% coupon that is paying semiannually and callable in 4 years at a call price of $1070. A bond sells at a yield to maturity of 8% currently. (Calculate YTC) Wilson's bonds have 12 years remaining to maturity and pay the interest annually. The Par value of the bond is $1000 and the coupon rate is 8% and the market price of the bond is $900. Government zero-coupon bonds with face value of $1000 and maturity of 9 years and currently the price is $532.12. Jackson rentals have a bond that matures in 6 years and 8% annual coupon. The current yield of the bond is 8.51%