Question: i am not sure what i am doing wrong with Excel that i am not getting the correcr answer?? AutoSave Off Book1 - Excel T

AutoSave Off Book1 - Excel T File Review View Help 8 Q Home Insert Draw Page Layout Formulas Data X % conditional Formatting Font Alignment Number Format as Table Cell Styles Paste Cells Editing Ideas bmit Clipboard Styles Ideas ark C12 fy =PMT(C8,C6, C4,010) I Formula Bar B D F G H 1 . 1 4 pv 2 bond price 103.5353% 1,000 = 1035.353 3 1035.353 5 6 n (2035-2019)*2 32 7 8r 0.06019/2 0.030095 1000 10 fv 11 12 pmt 13 14 31.83119 0.063662 0.127325 12.73248 A not the right answer AutoSave 8) Book1 - Excel o File Home Insert Draw Page Layout Formulas Data Review View Help anthercard 8 % Paste Font Conditional Formatting Format as Table cell Styles 4 & Exit Alignment Number Submit Editing Ideas Clipboard Check my work Ideas C12 Styles =PMT(C8,C6, C4,C10) I until $1,000 H s your yield s and enter A Formula Bar B D F G 1 2 bond price 103.5353%*1,000 = 1035.353 3 4 pv 1035.353 5 6 n (2035-2019)*2 32 7 8 F 0.06019/2 0.030095 9 10 fv 1000 11 12 pmt 31.83119 0.063662 0.127325 12.73248 13 AAA not the right answer 14 15 bond price 1046.461 16 1046.461 18 19 n 16 20 21 pmt 27.12 22 23 UNUMI 17 py
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
