Excel Examples

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

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

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