Excel Examples

Excel Examples - 91.30 32,492 81.30 22,532 91.30 43,653...

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 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 A B C D 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
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 91.30 32,492 81.30 22,532 91.30 43,653 81.30 21,043 91.30 56,656 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%...
View Full Document

This note was uploaded on 07/14/2010 for the course UGBA 18195 taught by Professor Johngonzales during the Summer '10 term at Berkeley.

Ask a homework question - tutors are online