Excel金融应用

C m c m w o d o w w w w w c lic k to bu y n o w pd o

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic 532 221 .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic 532 221 .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic The Du Pont System). .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic .d o m w o .c C m o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic .d o m w o .c C m o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic EXCEL ” ” “ ” “ “ ” “ ” ” .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic w EXCEL - - - - - .d o o .c m C m o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic EXCEL • (AAR) -- -- • -- .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic EXCEL • NPV (NPV) NPV NPV Excel 1 Excel NPV() NPV(rate, value1, value2, ...) NPV() NPV() 2 -- PV() ( PV(rate,nper,pmt,fv,type) ) .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic w EXCEL • IRR Excel 1 Excel 2 Excel -- IRR “ ” IRR() IRR(values, guess) .d o o .c m C m o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic w EXCEL • .d o o .c m C m o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic EXCEL • 863 836 .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic w EXCEL -“ ” -- -NPV PI -- IRR IRR -- .d o o .c m C m o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c H F-XC A N GE H F-XC A N GE c u-tr a c k N y bu to k lic EXCEL Excel “ ” Excel .d o o .c m C m w o .d o w w w w w C lic k to bu y N O W ! PD O W ! PD c u-tr a c k .c...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online