Please do not use Excel!

Please show all formuals and solutions

ON Coupon M VIM 10 25 99 Al 4 650 02/23/2000 3.197 Yes 4375 05132045 Yes Ask 25 90 120 90000 10 2100 4250 2002047 Yee Ask 25 SAP Neody AFD Apple Inc. 45302122018 Cable Bu MA 037833 At Make Whole Call Continuously Callable on 08/23/204510000000 Apple 700512045 DA A OSTA Make Whole Call Now In 425 47 Du MA Al 037833CHI Mae Whole Call ContinuouslyCalle on SW1046 10000000 No. 05.06.2014 By AA ASE OSTAT Make Whole Call Appines Male Whole Can Continously Cable 2000 1000000 747 MA 00 Make Wheel 110700 10 4456 OW 206 Al 25 13200100 10 21 350 0042060 Yee A 25 11274500 10 3742 3.750 1.2 2007 YA 1111 1000 Question 1: What is the most that you are willing to pay for an AAPL bond if the bond has a 4.65% coupon rate, matures in 25 years, $100 par value and interest payment is paid semi- annually? (This bond is listed as the first line on the above listing) Question 2: Given that you have a 26-year AAPL bond with a 3.75% coupon rate, paid semi- annually, $100 par value, and that you have just paid $111.288 for this bond, calculate the yield to maturity for this bond (This bond is listed as the last line on the above listing) Question 3: Walker is a bond investor and currently, he holds 2 bonds in his portfolio. Bond A is a 3.75% coupon rate bond with 4 years remaining (until maturity) while bond B is a 6.25% coupon rate bond with 3 years remaining (until maturity). Currently, if Walker is not investing in bond A, he could have earned a 4% return by investing in bonds with similar risks to that of A. Meanwhile, Walker could have earned 3% by investing in bonds with similar risks to that of B. Walker wants to know whether his bonds are premium, par or discount bond. Without any calculation, please help Walker determining the type of bonds that he has and more importantly, explain to him HOW you arrive to your prediction in plain English