How did they calculate the market value for each bond in the excel spreadsheet given the data in appendix 11?

Price Case 16 The Boeing 7E7 253 EXHIBIT 11 Outstanding Bonds of the Boeing Company as of June 2003 ($ values in millions) Debt Debt Amount Rating Coupon Maturity Yield To Maturity $202 A- 7.625% 2/15/2005 106.175 3.911% $298 A- 6.625% 6/1/2005 105.593 $249 3.393% A- 6.875% 11/1/2006 110.614 3.475% $175 A- 8.100% 11/15/2006 112.650 4.049% $349 9.750% 4/1/2012 129.424 5.470% $597 6.125% 2/15/2013 103.590 4.657% $398 8.750% 8/15/2021 127.000 6.239% $300 7.950% 8/15/2024 126.951 5.732% $247 7.250% 6/15/2025 114.506 6.047% $249 8.750% 9/15/2031 131.000 6.337% $173 8.625% 11/15/2031 138.974 5.805% $393 6.125% 2/15/2033 103.826 5.850% $300 6.625% 2/15/2038 106.715 6.153% $100 7.500% 8/15/2042 119.486 6.173% $173 7.825% 4/15/2043 132.520 5.777% $125 A 6.875% 10/15/2043 110.084 6.191% Note: This table does not include the outstanding debt of Boeing's financing subsidiary, Boeing Capital Corporation Sources: Boeing Company 10-0, Bloomberg Financial Services, and Mergent Online We've updated our read aloud featurel Give it a try here. Paste BIU + Merge & Center Font Clipboard Alignment UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. G13 F G A B D E 4 Debt Price Market Value YTM Weighted YTM 5 202.00 106.175 214.474 3.911% 0.167% 6 298.00 105.593 314.667 3.393% 0.213% 7 249.00 110.614 275.429 3.475% 0.191% 8 175.00 112.650 197.138 4.049% 0.159% 9 349.00 129.424 451.690 5.470% 0.492% 10 597.00 103.590 618.432 4.657% 0.573% 398.00 127.000 505.460 6.239% 0.628% 12 300.00 126.951 380.853 5.732% 0.435% 13 247.00 114.506 282.830 6.047% 0.341% 14 249.00 131.000 326.190 6.337% 0.412% 15 173.00 138.974 240.425 5.805% 0.278% 16 393.00 103.826 408.036 5.850% 0.475% 17 300.00 106.715 320.145 6.153% 0.392% 18 100.00 119.486 119.486 6.173% 0.147% 19 173.00 132.520 229.260 5.777% 0.264% 20 125.00 110.084 137.605 6.191% 0.170% 21 22 Total 23 5,022.12 5.335% Cost of Debt WACC Ready Scroll Lock O Type here to search RI e