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

i am not sure what i am doing wrong with Excel that i am not getting the correcr answer??  i am not sure what i am doing wrong with Excel
that i am not getting the correcr answer?? AutoSave Off Book1 -
Excel T File Review View Help 8 Q Home Insert Draw Page

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!