AutoSave 01 R Rond Valuation-415b10 (7) - O Search (Alt+) Omar, Yasmeens ov File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share 2 = = = 26 Wrap Text General TL Arial 10 ~ A A BI UB CA LO) WE PA LA Conditional Format as Formatting Table Styles 47 0 Sort & Find & Filter Select Paste Sensitivity Merge Center $ - % Insert Delete Format Analyze Data Undo Clipboard Font Alignment Number Styles Editing Analysis Sensitivity G H 1 J K 117 fo A B C D F 107 (2) Calculating the expected capital gains yield for each bond in each year Years Remaining 10B Until Maturity Bond A Bond B Bond C 109 12 110 11 111 10 112 9 113 8 114 7 115 6 116 5 117 4 118 3 119 2 120 1 121 122 (3) Calculating the total return for each bond in each year Years Remaining 123 Until Maturity Bond A Bond B Bond c 121 12 125 11 126 10 9 128 8 129 7 130 6 131 5 132 4 4 133 3 134 2 Sheet1 Bond A ANIA #N/A #NIA #NIA WNIA #NIA #NIA #NIA UNIA #NIA #NIA #N/A Bond B #N/A #NA #N/A #N/A NA #NA #N/A #N/A NA #N/A #N/A #N/A Bond A UNIA #N/A #NIA ANIA #N/A #NIA #NIA 127 Bond B NA #N/A #N/A #N/A #NA #N/A # #NA INVA #NA #N/A #N/A UNA #N/A #NIA #NIA Reacy Accessibility: Investigate Average 11 Count 2 Sum: 11 F 100 0 8.17 PM 3/23/2022 Rain showers AutoSave 01 R Rond Valuation-415b10 (7) - O Search (Alt+) Omar, Yasmeens ov File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share 2 = = = 26 Wrap Text General TL Arial 10 ~ A A BI UB CA LO) WE PA LA Conditional Format as Formatting Table Styles 47 0 Sort & Find & Filter Select Paste Sensitivity Merge Center $ - % Insert Delete Format Analyze Data Undo Clipboard Font Alignment Number Styles Editing Analysis Sensitivity G H 1 J K 117 fo A B C D F 107 (2) Calculating the expected capital gains yield for each bond in each year Years Remaining 10B Until Maturity Bond A Bond B Bond C 109 12 110 11 111 10 112 9 113 8 114 7 115 6 116 5 117 4 118 3 119 2 120 1 121 122 (3) Calculating the total return for each bond in each year Years Remaining 123 Until Maturity Bond A Bond B Bond c 121 12 125 11 126 10 9 128 8 129 7 130 6 131 5 132 4 4 133 3 134 2 Sheet1 Bond A ANIA #N/A #NIA #NIA WNIA #NIA #NIA #NIA UNIA #NIA #NIA #N/A Bond B #N/A #NA #N/A #N/A NA #NA #N/A #N/A NA #N/A #N/A #N/A Bond A UNIA #N/A #NIA ANIA #N/A #NIA #NIA 127 Bond B NA #N/A #N/A #N/A #NA #N/A # #NA INVA #NA #N/A #N/A UNA #N/A #NIA #NIA Reacy Accessibility: Investigate Average 11 Count 2 Sum: 11 F 100 0 8.17 PM 3/23/2022 Rain showers
