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

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

View Full Document Right Arrow Icon
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
Background image of page 1
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

Ask a homework question - tutors are online