{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Examples

# Excel Examples - 81.30 15,342 91.30 60,432 81.30 12,111...

This preview shows page 1. Sign up to view the full content.

Calculating Present Value and Rate of Return with Excel present value present value rate of return rate of return (bond price) of future cash  (bond yield) (internal rate of flows of a project return of a project) bond price = \$945.32 investment cost annual coupon = 8.13% is \$125,000 annual coupon = 9.13% par = \$1,000 eight years of par = \$1,000 future cash flows maturity = 20 years maturity = 20 years   discount rate  = 7.43% disc. rate = 9.67% -945.32 -125,000 81.30 10,000 91.30 -25,671 81.30 16,000 91.30 32,492 81.30 22,532 91.30 43,653 81.30 21,043 91.30 56,656
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 81.30 15,342 91.30 60,432 81.30 12,111 91.30 43,234 81.30 8,700 91.30 32,457 81.30 6,738 91.30 18,892 81.30 91.30 81.30 ,=NPV(.0967,B17:B24) 91.30 ,=IRR(D16:D24) 81.30 91.30 81.30 \$78,459.65 91.30 16.01% 81.30 91.30 81.30 investment cost 91.30 81.30 is \$52,000 91.30 81.30 91.30 81.30 91.30 81.30 NPV = \$26,459.65 91.30 81.30 91.30 1081.30 1091.30 ,=NPV(.0743,A17:A36) ,=IRR(C16:C36) \$1,071.74 9.76% A B C D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online