Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved 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

i am not sure what i am doing wrong with Excel that i am not getting the correcr answer?? image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

Ty e2y Evaluate the integral dy

Answered: 1 week ago

Question

state what is meant by the term performance management

Answered: 1 week ago