Find the most recent price of the bond and show how it can be used to

determine its YTM (Yield to Maturity). Upload your excel file to show your

calculations. If the bond you have chosen has not been traded recently you

can assume a hypothetical price and show the YTM calculation for it.

Please show also the calculation formulas on excel if possible

Thanks

APPLE INC + ADD TO WATCHLIST Coupon Rate Maturity Date CUSIP Next Call Date 2.400% 05/03/2023 Symbol AAPL4001809 037833AK6 Callable Yes Last Trade Price Last Trade Yield Last Trade Date US Treasury $103.11 .373% 10/14/2021 Yield Trade History Price/Yield Chart Classification Elements Price Chart Yield Chart Bond Type - 10/14/2021 Zoom: 5D 1M 3M YTD 1Y 3Y SY 10Y Max Debt Type 10/14/2016 Price US Corporate Debentures Senior Unsecured Note Industrial Manufacturing CORP Industry Group Prices Industry Sub Group Sub-Product Asset Sub-Product Asset Type 104.00 State Corporate Bond Use of Proceeds Security Code 100.00 Special Characteristics Medium Term Note N 96.00 Issue Elements 04/30/2013 2017 2018 2019 05/03/2013 11/03/2013 $5,500,000.00 Credit and Rating Elements 92.00 Offering Date 2020 2021 Dated Date First Coupon Date Original Offering* Amount Outstanding* Aa1 (04/27/2016) Series AA+ (04/30/2013) Issue Description Investment Grade Project Name Payment Frequency $5,500,000.00 Moody's Rating Standard & Poor's Rating TRACE Grade Default Semi-Annual 30/360 Bankruptcy N Day Count Insurance Form Mortgage Insurer Pre-Refunded/Escrowed Depository/Registration Book Entry DTC, Clearstream, Euroclear Additional Description Senior Unsecured Note Security Level Senior Collateral Pledge Put & Redemption Provisions Capital Purpose *dollar amount in thousands Call Date Call Price Call Frequency Continuously Bond Elements Original Maturity Size* 5,500,000.00 Put Date Put Price Put Frequency Amount Outstanding Size* 5,500,000.00 2.42% $99.87 Yield at Offering Price at Offering Coupon Type Escrow Type Fixed